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