import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
/**
* <P>Title: 硕卓学籍管理系统</P>
* <P>Description: 课程设计项目</P>
* <P>Copyright: Copyright (c) 2004</P>
* <P>Company: 硕卓软件公司</P>
* @author 盛守卓
* @version 1.0
*/
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 {
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("女");
this.setDefaultCloseOperation(HIDE_ON_CLOSE);
this.setEnabled(true);
this.setResizable(false);
this.setTitle("修改学生信息");
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.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.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.setEnabled(true);
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));
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);
choice2.addItem("团员");
choice2.addItem("党员");
choice2.addItem("其他");
choice3.addItem("计算机");
choice3.addItem("电子");
choice3.addItem("生化");
choice3.addItem("艺术");
strurl =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/student.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(strurl);
stmt = conn.createStatement();
}
public void actionPerformed(ActionEvent e) {
if (e.getSource() == button2) {
try {
rs = stmt.executeQuery("SELECT * FROM BaseInf where 学号='" +
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);
textArea1.setVisible(true);
textArea1.setText(rs.getString("备注"));
textField1.setVisible(true);
textField1.enable(false);
textField1.setText(rs.getString("学号"));
textField2.setVisible(true);
textField2.setText(rs.get