java访问数据库sql server 增删改查第五篇

xiugai.java

import javax.swing.JDialog;
import javax.swing.JFrame;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;

class xiugai extends JDialog implements ActionListener
{
   JLabel bq1,bq2,bq3,bq4;
   JTextField wbk1,wbk2,wbk3,wbk4;
   JButton an1,an2;
   JPanel mb1,mb2,mb3,mb4;
   
   public xiugai(Frame fck,String ckm,Boolean msck,xsxx xsxx2,int hang)
   {
	   super(fck,ckm,msck);
	   bq1=new JLabel("               学号      ");
	   bq2=new JLabel("               姓名      ");
	   bq3=new JLabel("               性别     ");
	   bq4=new JLabel("               年龄     ");

	   wbk1=new JTextField(5);
	   wbk1.setText((String)xsxx2.getValueAt(hang,0));
	   wbk1.setEditable(false);
	   wbk2=new JTextField(5);
	   wbk2.setText((String)xsxx2.getValueAt(hang,1));
	   wbk3=new JTextField(5);
	   wbk3.setText((String)xsxx2.getValueAt(hang,2));
	   wbk4=new JTextField(5);
	   wbk4.setText((String)xsxx2.getValueAt(hang,3).toString());
	  
	   an1=new JButton("修改");
	   an1.addActionListener(this);
	   an1.setActionCommand("xiugai");
	   an2=new JButton("取消");
	   an2.addActionListener(this);
	   an2.setActionCommand("quxiao");
	   
	   mb1=new JPanel();
	   mb2=new JPanel();
	   mb3=new JPanel(); 
	   mb4=new JPanel(); 
	   
	   mb1.setLayout(new GridLayout(4,1));
	   mb2.setLayout(new GridLayout(4,1));
	   
	   mb1.add(bq1);  mb1.add(bq2);  mb1.add(bq3);
	   mb1.add(bq4); 
	   
	   mb2.add(wbk1);  mb2.add(wbk2);  mb2.add(wbk3);
	   mb2.add(wbk4); 
	   
	   mb3.add(an1);  mb3.add(an2);
	   
	   this.add(mb1,BorderLayout.WEST);
	   this.add(mb2);
	   this.add(mb3,BorderLayout.SOUTH);
	   this.add(mb4,BorderLayout.EAST);
	  	   
	  	this.setSize(370,270);
		this.setLocation(401,281);
		this.setResizable(false);
		this.setVisible(true);		   
   }
   public void actionPerformed(ActionEvent e)
   {
	   if(e.getActionCommand().equals("xiugai"))
	   {
		   PreparedStatement ps=null;
		   Connection ct=null;
		   ResultSet rs=null;
		   Statement sm=null;
		   
		   try {
			      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				  ct=DriverManager.getConnection("jdbc:odbc:sql server");
				  String ss=("update Table_3 set xingming=?,xingbie=?,age=? where xuehao=?");
				  ps=ct.prepareStatement(ss);	
				  ps.setString(1,wbk2.getText());
				  ps.setString(2,wbk3.getText());
				  ps.setString(3,wbk4.getText());
				  ps.setString(4,wbk1.getText());
				  ps.executeUpdate();
				  
				  this.dispose();				  
			} catch (Exception e2){System.out.println("error");}
		    finally
		    {
		    	try {
		    		if(rs!=null)
					{
						rs.close();
					}
		    		if(ps!=null)
					{
						ps.close();
					}
					if(ct!=null)
					{
						ct.close();
					}
					
				} catch (Exception e3){}		
		    }
	   }
	   else if(e.getActionCommand().equals("quxiao"))
	   {
		   this.dispose();
	   }
   }
}