addinf.java

学生管理系统

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

public class AddInf
    extends JFrame
    implements ActionListener {
  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();
  TextField textField6 = new TextField();
  Label label10 = new Label();
  TextField textField7 = new TextField();
  Label label11 = new Label();
 
  
  Button button1 = new Button();

  public AddInf() {
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    label1.setText("学        号:");
    label1.setBounds(new Rectangle(30, 11, 51, 33));
    this.getContentPane().setLayout(null);
    textField1.setText("");
    textField1.setBounds(new Rectangle(86, 16, 74, 22));
    label2.setText("姓名:");
    label2.setBounds(new Rectangle(162, 11, 28, 33));
    textField2.setText("");
    textField2.setBounds(new Rectangle(192, 16, 44, 22));
    label3.setText("性别:");
    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(true);
    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("出生日期:");
    textField3.setBounds(new Rectangle(86, 58, 74, 22));
    textField3.setText("YYYY-MM-DD");
    label6.setText("籍贯:");
    label6.setBounds(new Rectangle(163, 53, 26, 33));
    textField4.setBounds(new Rectangle(191, 58, 44, 22)); 
    textField4.setText("");
    label7.setBounds(new Rectangle(30, 94, 50, 33));
    label7.setText("班        级:");
    choice3.setEnabled(true);
    choice3.setFont(new java.awt.Font("Dialog", 0, 12));
    choice3.setForeground(Color.black);
    choice3.setLocale(java.util.Locale.getDefault());
    choice3.setVisible(true);
    choice3.setBounds(new Rectangle(86, 98, 75, 25));
    label8.setText("JAVA:");
    label8.setBounds(new Rectangle(86, 160, 51, 33));
    textField5.setText("");
    textField5.setBounds(new Rectangle(150, 165, 22, 22));
    label9.setText("成绩信息:");
    label9.setBounds(new Rectangle(30, 132, 51, 33));
    label10.setText("操作系统:");
    label10.setBounds(new Rectangle(86, 132, 51, 33));
    textField6.setText("");
    textField6.setBounds(new Rectangle(150, 137, 22, 22));
    label11.setText("系统结构:");
    label11.setBounds(new Rectangle(180, 132, 51, 33));
    textField7.setText("");
    textField7.setBounds(new Rectangle(252, 137, 22, 22));
    button1.setLabel("增加");
    button1.setVisible(true);
    button1.setBounds(new Rectangle(156, 244, 89, 22));
    button1.addActionListener(this);
    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(label7, null);
    this.getContentPane().add(choice3, null);
    this.getContentPane().add(label9, null);
    this.getContentPane().add(label10, null);
    this.getContentPane().add(textField6, null);
    this.getContentPane().add(label11, null);
    this.getContentPane().add(textField7, null);
    this.getContentPane().add(label8, null);
    this.getContentPane().add(textField5, null);
    this.getContentPane().add(button1, null);
    choice3.addItem("软件0301");
    choice3.addItem("软件0302");
  }

  public void actionPerformed(ActionEvent e) {
    try {
      String strurl =
          "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/student.mdb";
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection conn = DriverManager.getConnection(strurl);
      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("select 学号 from BaseInf where 学号='" +
                                       textField1.getText() + "'");
      if (rs.next()) {
        JOptionPane.showMessageDialog(null, "此学号已经被注册.", "警告",
                                      JOptionPane.WARNING_MESSAGE);
        return;
      }
      stmt.execute(
          "insert into BaseInf (学号,班级,姓名,性别,出生日期,籍贯,操作系统成绩,系统结构成绩,JAVA成绩) values ('" +
          textField1.getText() + "','" + choice3.getSelectedItem() + "','" + textField2.getText() + "','" +
          choice1.getSelectedItem() + "','" + textField3.getText() + "','" + textField4.getText() + "','" + textField6.getText() + "','" + textField7.getText() + "','" +           textField5.getText() + "')");
      textField1.setText("");
      textField2.setText("");
      textField3.setText("");
      textField4.setText("");
      textField5.setText("");
      
      JOptionPane.showMessageDialog(null, "增加信息成功!");
    }
    catch (Exception eg) {
      JOptionPane.showMessageDialog(null, "请认真检查各项(不能为空),\n日期要合法!然后重试.", "异常警告",
                                    JOptionPane.WARNING_MESSAGE);
      eg.printStackTrace();
    }
  }
}