import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.border.*;
public class ModifyRecord extends JDialog implements ActionListener{
 JLabel hintLabel;
 JTextField inputNumber;
 Object a[][]=new Object[1][3];
 Object name[]={"姓名","日期","月薪"};
 JTable table;
 JButton enterModify;
 Connection con;
 Statement sql;
 ResultSet rs;
 String number;
 ModifyRecord(String s){
  setTitle(s);
  hintLabel=new JLabel("输入工号（回车确认）:");
  inputNumber=new JTextField(20);
  table=new JTable(a,name);
  enterModify=new JButton("更新记录");
  setLayout(null);
  Box baseBox=Box.createHorizontalBox();
  baseBox.add(hintLabel);
  baseBox.add(inputNumber);
  baseBox.add(new JScrollPane(table));
  baseBox.add(enterModify);
  add(baseBox);
  baseBox.setBounds(10,40,600,38);
  inputNumber.addActionListener(this);
  enterModify.addActionListener(this);
  setBounds(200,60,700,200);
 }
 public void actionPerformed(ActionEvent e){
  if(e.getSource()==inputNumber){
      try{
          number=inputNumber.getText().trim();
       con=DriverManager.getConnection("jdbc:odbc:xuefeng","","");
       sql=con.createStatement();
       rs=sql.executeQuery("SELECT * FROM employee WHERE number='"+number+"'");
       boolean boo=rs.next();
       if(boo==false){
       JOptionPane.showMessageDialog(this,"工号不存在","提示",JOptionPane.WARNING_MESSAGE);
       }
       else{
       a[0][0]=rs.getString(2);
       a[0][1]=rs.getString(3).toString();
       a[0][2]=rs.getString(4);
       table.repaint();
       }   
       con.close();
      }
      catch(SQLException ee){
        System.out.println(ee);
      }
  }
  if(e.getSource()==enterModify){
   try{
    con=DriverManager.getConnection("jdbc:odbc:xuefeng","","");
    sql=con.createStatement();
    sql.executeUpdate("UPDATE employee SET name='"+a[0][0]+"',birthday='"+a[0][1]+"',salary='"+a[0][2]+"'WHERE number='"+number+"'");
    JOptionPane.showMessageDialog(this, "更新成功","成功",JOptionPane.PLAIN_MESSAGE);
    con.close();
   }
   catch(SQLException ee){
    JOptionPane.showMessageDialog(this, "更新失败"+ee,"失败",JOptionPane.ERROR_MESSAGE);
   }
  }
 }
}