www.pudn.com > st.rar > ChangeIfon.java

import java.awt.*; 
import java.awt.event.*; 
 
import javax.swing.*; 
 
import java.util.*; 
import java.sql.*; 
 
public class ChangeIfon extends JPanel implements ActionListener{ 
	String sql;  
    Connection conn;  
    Statement stmt;  
    ResultSet rs; 
    JButton b1=new JButton("修改"); JButton b2=new JButton("返回"); 
    String tem=new String(); 
    JLabel l1=new JLabel("学号：");JTextField t1=new JTextField(15); 
	JLabel l2=new JLabel("姓名：");JTextField t2=new JTextField(15); 
	JLabel l3=new JLabel("密码：");JTextField t3=new JTextField(15); 
	JLabel l4=new JLabel("生日：");JTextField t4=new JTextField(15); 
	JLabel l5=new JLabel("Email：");JTextField t5=new JTextField(15); 
	JLabel l6=new JLabel("电话：");JTextField t6=new JTextField(15); 
	JLabel l7=new JLabel("简介：");TextArea t7=new TextArea(3,50); 
	ChangeIfon(String ID){ 
		try{ 
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
			String url="jdbc:odbc:SUMMIT";  
			String user="sa";  
			String password="198662";  
			conn= DriverManager.getConnection(url,user,password); 
			stmt=conn.createStatement();  
			tem=ID; 
			sql="select * from Student where SNO=";  
			sql=sql+"'"+tem+"'"; 
			rs=stmt.executeQuery(sql);  
			rs.next(); 
////////////////////		 
			setLayout(new GridLayout(9,1)); 
			JPanel jp[]=new JPanel[9]; 
			for(int i=0;i<9;i++){ 
			jp[i]=new JPanel(new FlowLayout(FlowLayout.LEFT)); 
			add(jp[i]); 
			jp[i].setBackground(Color.orange);} 
			jp[0].setLayout(new FlowLayout(FlowLayout.CENTER)); 
			jp[0].add(new JLabel("个人信息管理")); 
 
			jp[8].setLayout(new FlowLayout(FlowLayout.CENTER)); 
			 
			t1.setEditable(false); 
	 
           
			jp[1].add(l1);jp[1].add(t1); 
			jp[2].add(l2);jp[2].add(t2);jp[2].add(new JLabel("**  (不可为空)")); 
			jp[3].add(l3);jp[3].add(t3);jp[3].add(new JLabel("**")); 
			jp[4].add(l4);jp[4].add(t4);jp[4].add(new JLabel("**")); 
			jp[5].add(l5);jp[5].add(t5);jp[5].add(new JLabel("YYYY-MM-DD")); 
			jp[6].add(l6);jp[6].add(t6); 
 
			jp[7].add(l7);jp[7].add(t7); 
			jp[8].add(b1);jp[8].add(b2); 
 
			t1.setText(rs.getString(1)); t2.setText(rs.getString(2)); 
			t3.setText(rs.getString(3)); t4.setText(rs.getString(4).substring(0,10)); 
			t5.setText(rs.getString(5)); t6.setText(rs.getString(6)); 
			t7.setText(rs.getString(7));  
 
////////////////////////// 
			b1.addActionListener(this); 
			b2.addActionListener(this); 
			rs.close();  
			stmt.close(); 
			conn.close();  
			}catch(Exception e){JOptionPane.showMessageDialog(null, e.getMessage());} 
	} 
	public void actionPerformed(ActionEvent e){ 
		if(e.getSource()==b1){ 
			if(t2.getText().trim().equals("")||t3.getText().trim().equals("")){ 
				JOptionPane.showMessageDialog(null, "姓名或密码不可为空！"); 
				return; 
			} 
			try{ 
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
				String url="jdbc:odbc:SUMMIT";  
				String user="sa";  
				String password="198662";  
				conn= DriverManager.getConnection(url,user,password); 
				stmt=conn.createStatement();  
				sql="update Student set SNAME='"+t2.getText().trim()+"'"; 
				sql=sql+",SPASSWD='"+t3.getText().trim()+"'"; 
				sql=sql+",BIRTHDAY='"+t4.getText().trim()+"'"; 
				sql=sql+",EMAIL='"+t5.getText().trim()+"'"; 
				sql=sql+",PHONE='"+t6.getText().trim()+"'"; 
				sql=sql+",INFO='"+t7.getText().trim()+"'"; 
				sql=sql+" where SNO='"+tem+"'"; 
				int ok=stmt.executeUpdate(sql);  
                if(ok==1){ 
                JOptionPane.showMessageDialog(null, "修改成功");} 
                 
				stmt.close(); 
				conn.close();  
		}catch(Exception e1){JOptionPane.showMessageDialog(null,e1.getMessage());} 
			 
	} 
} 
}