import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;public class ChangeInf extends JFrame implements ActionListener {
String strurl;
Connection conn;
Statement stmt;
ResultSet rs;
Label label1 = new Label();
TextField textField1 = new TextField();
Label label2 = new Label();
TextField textField2 = new TextField();
Label label3 = new Label();
Choice choice1 = new Choice();
Label label4 = new Label();
TextField textField3 = new TextField();
Label label5 = new Label();
Choice choice2 = new Choice();
Label label6 = new Label();
TextField textField4 = new TextField();
Label label7 = new Label();
Choice choice3 = new Choice();
Label label8 = new Label();
TextField textField5 = new TextField();
Label label9 = new Label();
TextArea textArea1 = new TextArea();
Button button1 = new Button();
TextField textField6 = new TextField();
Button button2 = new Button();
Label label10 = new Label(); public ChangeInf() {
try {
jbInit();
} catch (Exception e) {
e.printStackTrace();
}
} private void jbInit() throws Exception {
this.setDefaultCloseOperation(HIDE_ON_CLOSE);
this.setEnabled(true);
this.setResizable(false);
this.setTitle("修改员工信息");
label1.setText("员工编号:");
label1.setVisible(false);
label1.setBounds(new Rectangle(30, 11, 51, 33));
this.getContentPane().setLayout(null);
textField1.setText("");
textField1.setVisible(false);
textField1.setBounds(new Rectangle(86, 16, 74, 22));
label2.setBounds(new Rectangle(162, 11, 28, 33));
label2.setText("姓名:");
label2.setVisible(false);
textField2.setText("");
textField2.setVisible(false);
textField2.setBounds(new Rectangle(192, 16, 44, 22));
label3.setText("性别:");
label3.setVisible(false);
label3.setBounds(new Rectangle(241, 11, 28, 33));
choice1.setEnabled(true);
choice1.setFont(new java.awt.Font("Dialog", 0, 12));
choice1.setForeground(Color.black);
choice1.setLocale(java.util.Locale.getDefault());
choice1.setVisible(false);
choice1.setBounds(new Rectangle(275, 15, 50, 25));
choice1.addItem("男");
choice1.addItem("女"); label4.setBounds(new Rectangle(31, 53, 49, 33));
label4.setText("出生日期:");
label4.setVisible(false);
textField3.setBounds(new Rectangle(86, 58, 74, 22));
textField3.setLocale(java.util.Locale.getDefault());
textField3.setText("");
textField3.setVisible(false);
label5.setText("政治面貌:");
label5.setVisible(false);
label5.setBounds(new Rectangle(241, 53, 47, 33));
choice2.setEnabled(true);
choice2.setBounds(new Rectangle(296, 57, 72, 25));
choice2.setVisible(false);
choice2.setLocale(java.util.Locale.getDefault());
choice2.setForeground(Color.black);
choice2.setFont(new java.awt.Font("Dialog", 0, 12));
choice2.addItem("党员");
choice2.addItem("其他");
choice2.setEnabled(true);
label6.setText("籍贯:");
label6.setVisible(false);
label6.setBounds(new Rectangle(163, 53, 26, 33));
textField4.setBounds(new Rectangle(191, 58, 44, 22));
textField4.setText("");
textField4.setVisible(false);
label7.setBounds(new Rectangle(30, 94, 50, 33));
label7.setText("所属部门:");
label7.setVisible(false); choice3.setFont(new java.awt.Font("Dialog", 0, 12));
choice3.setForeground(Color.black);
choice3.setLocale(java.util.Locale.getDefault());
choice3.setVisible(false);
choice3.setBounds(new Rectangle(86, 98, 75, 25));
choice3.addItem("董事会");
choice3.addItem("后勤处");
choice3.addItem("保卫科");
choice3.addItem("传达室");
choice3.setEnabled(true);
label8.setBounds(new Rectangle(163, 94, 26, 33));
label8.setText("手机:");
label8.setVisible(false);
textField5.setText("");
textField5.setVisible(false);
textField5.setBounds(new Rectangle(190, 99, 178, 22));
label9.setText("住址:");
label9.setVisible(false);
label9.setBounds(new Rectangle(27, 132, 50, 33));
textArea1.setVisible(false);
textArea1.setBounds(new Rectangle(84, 139, 285, 95));
button1.setLabel("修改");
button1.setVisible(false);
button1.setBounds(new Rectangle(153, 241, 94, 22));
button1.addActionListener(this);
textField6.setText("");
textField6.setBounds(new Rectangle(147, 92, 105, 23));
button2.setFont(new java.awt.Font("Dialog", 1, 15));
button2.setLabel("下一步");
button2.setVisible(true);
button2.setBounds(new Rectangle(156, 148, 89, 23));
button2.addActionListener(this);
label10.setFont(new java.awt.Font("Dialog", 1, 15));
label10.setText("请输入要修改的员工编号");
label10.setBounds(new Rectangle(110, 49, 178, 24));
this.getContentPane().add(label3, null);
this.getContentPane().add(label1, null);
this.getContentPane().add(textField1, null);
this.getContentPane().add(label2, null);
this.getContentPane().add(textField2, null);
this.getContentPane().add(choice1, null);
this.getContentPane().add(label4, null);
this.getContentPane().add(textField3, null);
this.getContentPane().add(label6, null);
this.getContentPane().add(textField4, null);
this.getContentPane().add(label5, null);
this.getContentPane().add(choice2, null);
this.getContentPane().add(label7, null);
this.getContentPane().add(choice3, null);
this.getContentPane().add(label8, null);
this.getContentPane().add(textField5, null);
this.getContentPane().add(label9, null);
this.getContentPane().add(textArea1, null);
this.getContentPane().add(button2, null);
this.getContentPane().add(textField6, null);
this.getContentPane().add(label10, null);
this.getContentPane().add(button1, null);
} public void actionPerformed(ActionEvent e) {
if (e.getSource() == button2) {
try {
String url = "jdbc:odbc:StaffInfo";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url, "admin", "123456");
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM staffinfo where sno="
+ textField6.getText()); if (rs.next()) {
textField6.setVisible(false);
button2.setVisible(false);
label10.setVisible(false);
label1.setVisible(true);
label2.setVisible(true);
label3.setVisible(true);
label4.setVisible(true);
label5.setVisible(true);
label6.setVisible(true);
label7.setVisible(true);
label8.setVisible(true);
label9.setVisible(true);
textField1.setVisible(true);
textField1.enable(false);
textField2.setVisible(true);
textField3.setVisible(true);
textField4.setVisible(true);
textField5.setVisible(true);
textArea1.setVisible(true);
button1.setVisible(true);
textField1.setText(rs.getString("sno"));
textField2.setText(rs.getString("sname"));
choice1.select(rs.getString("ssex"));
choice1.setVisible(true);
textField3.setText(rs.getString("sbirth"));
textField4.setText(rs.getString("shometown"));
choice2.select(rs.getString("spolity"));
choice2.setVisible(true);
choice3.select(rs.getString("sdept"));
choice3.setVisible(true);
textField5.setText(rs.getString("sphone"));
textArea1.setText(rs.getString("saddress"));
} else
JOptionPane.showMessageDialog(null, "无该编号的员工相应信息,请重新输入",
"警告", JOptionPane.WARNING_MESSAGE);
} catch (Exception eg) {
eg.printStackTrace();
}
} else if (e.getSource() == button1) {
try {
String url = "jdbc:odbc:StaffInfo";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url, "admin", "123456");
stmt = conn.createStatement();
stmt.execute("DELETE FROM staffinfo where sno="
+ textField1.getText());
stmt
.execute("insert into staffinfo "
+ "(sno,sname,ssex,sbirth,shometown,spolity,sdept,sphone,saddress) values ('"
+ textField1.getText() + "','"
+ textField2.getText() + "','"
+ choice1.getSelectedItem() + "','"
+ textField3.getText() + "','"
+ textField4.getText() + "','"
+ choice2.getSelectedItem() + "','"
+ choice3.getSelectedItem() + "','"
+ textField5.getText() + "','"
+ textArea1.getText() + "')");
JOptionPane.showMessageDialog(null, "修改信息成功!"); } catch (Exception eg) {
JOptionPane.showMessageDialog(null,
"请认真检查各项(不能为空),\n日期要合法!然后重试.", "异常警告",
JOptionPane.WARNING_MESSAGE);
eg.printStackTrace();
}
}
}
}3个choice,如果我system.out.println()这样显示的都是正确的项目,但是如果用choice.select()总是显示的就是添加choice中的第一个被添加的item