changeifon.java

使用java连接server sql 2000 的一个小作业

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());}
			
	}
}
}