basicinformationinput.java

学生信息管理系统,包括成绩查询,成绩排序,用ACCESS做数据库连接

package Chapter1;
import java.io.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.awt.Rectangle;
import java.awt.Font;

public class BasicInformationInput extends JFrame implements ActionListener
{
  public static final int WIDTH=400;
  public static final int HEIGHT=400;
  JLabel jLabel1 = new JLabel();
  private static JTextField jTextField1 = new JTextField();
  JLabel jLabel2 = new JLabel();
  private static JTextField jTextField2 = new JTextField();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JLabel jLabel9 = new JLabel();
  private static JTextField jTextField9 = new JTextField();
  private static JComboBox jComboBox1 = new JComboBox();
  private static JComboBox jComboBox2 = new JComboBox();
  private static JComboBox jComboBox3 = new JComboBox();
  private static JComboBox jComboBox4 = new JComboBox();
  private static JComboBox jComboBox5 = new JComboBox();
  JLabel jLabel4 = new JLabel();
  private static JComboBox jComboBox6 = new JComboBox();
  JLabel jLabel10 = new JLabel();
  private static JComboBox jComboBox7 = new JComboBox();
  JLabel jLabel11 = new JLabel();
  JComboBox jComboBox8 = new JComboBox();

  public BasicInformationInput()
  {
    setSize(WIDTH,HEIGHT);
    setTitle("学生基本信息输入");
    Container contentPane=getContentPane();
    contentPane.setBackground(Color.green);
    try
    {
      jbInit();
    }//执行方法jbInit()
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }
  public void actionPerformed(ActionEvent e)
  {
    if(e.getActionCommand().equals("提交"))
       { //用于获取用户输入的信息
          try
          {
            String ID="",name="",sex="",yearOfBirth="",department="",
                    major="",homeplace="",timeOfEntering="",addition="";
         ID=jTextField1.getText();
         name=jTextField2.getText();
         sex=(String)(jComboBox1.getSelectedItem());
         yearOfBirth=(String)(jComboBox6.getSelectedItem())+"年"+(String)(jComboBox7.getSelectedItem())+"月";
         department=(String)(jComboBox2.getSelectedItem());
         major=(String)(jComboBox8.getSelectedItem());
         homeplace=(String)(jComboBox3.getSelectedItem())+(String)(jComboBox4.getSelectedItem());
         timeOfEntering=(String)(jComboBox5.getSelectedItem());
         addition=jTextField9.getText();//获取用户的基本信息
           String url="jdbc:odbc:MySecondAccess";
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con=DriverManager.getConnection(url,"","");
           Statement stmt=con.createStatement();
            String  SQLOrder="INSERT INTO BasicInformation VALUES('"+ID+"','"+name+"','"+sex+"','"+yearOfBirth+"','"+department+"','"+ major+"','"+ homeplace+"','"+timeOfEntering+"','"+addition+"')";
            stmt.executeUpdate(SQLOrder);
            stmt.close();
            con.close();
            JOptionPane.showMessageDialog(null,name+"的基本信息录入成功！","提示信息",JOptionPane.INFORMATION_MESSAGE);
          }
          catch(Exception ex)
          {
            JOptionPane.showMessageDialog(null,ex.getMessage(),"警告信息",JOptionPane.WARNING_MESSAGE);
            JOptionPane.showMessageDialog(null,ex.getStackTrace(),"警告信息",JOptionPane.WARNING_MESSAGE);
          }
          finally
          {
            jTextField1.setText("");
            jTextField2.setText("");
            jTextField9.setText("");
            jComboBox1.setSelectedIndex(0);
            jComboBox2.setSelectedIndex(0);
            jComboBox3.setSelectedIndex(0);
            jComboBox4.setSelectedIndex(0);
            jComboBox5.setSelectedIndex(0);
            jComboBox6.setSelectedIndex(0);
            jComboBox7.setSelectedIndex(0);
            jComboBox8.setSelectedIndex(0);
          }
       }//补充：最好能在输入基本信息的同时，也把这些信息输入到选课信息表和学生信息表中去，这样方便！
     else if (e.getActionCommand().equals("重置"))
     {
        jTextField1.setText("");
        jTextField2.setText("");
        jTextField9.setText("");
        jComboBox1.setSelectedIndex(0);
        jComboBox2.setSelectedIndex(0);
        jComboBox3.setSelectedIndex(0);
        jComboBox4.setSelectedIndex(0);
        jComboBox5.setSelectedIndex(0);
        jComboBox6.setSelectedIndex(0);
        jComboBox7.setSelectedIndex(0);
        jComboBox8.setSelectedIndex(0);
     }
     else if  (e.getActionCommand().equals("返回"))
     {
           this.dispose();
           ManagerInterface n1= new ManagerInterface();
           StudentInterface n2=new  StudentInterface();
           if(Login.jComboBox1.getSelectedIndex()==0)
                 {  n1.setVisible(true);  n2.dispose();}
           else if(Login.jComboBox1.getSelectedIndex()==1)
                 {  n2.setVisible(true);  n1.dispose(); }
     }
  }
  public static void main(String[] args)
  {
      BasicInformationInput n=new BasicInformationInput();
      n.setVisible(true);
  }
  private void jbInit() throws Exception
  {
    jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
    jLabel1.setText("学号");
    jLabel1.setBounds(new Rectangle(38, 36, 36, 20));
    this.getContentPane().setLayout(null);
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(90, 37, 80, 20));
    jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
    jLabel2.setRequestFocusEnabled(true);
    jLabel2.setText("姓名");
    jLabel2.setBounds(new Rectangle(38, 78, 30, 16));
    jTextField2.setText("");
    jTextField2.setBounds(new Rectangle(90, 80, 80, 20));
    jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
    jLabel3.setToolTipText("");
    jLabel3.setText("性别");
    jLabel3.setBounds(new Rectangle(36, 122, 39, 18));
    jLabel5.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
    jLabel5.setText("院系");
    jLabel5.setBounds(new Rectangle(221, 36, 36, 20));
    jLabel6.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
    jLabel6.setText("专业 ");
    jLabel6.setBounds(new Rectangle(223, 78, 40, 21));
    jLabel7.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
    jLabel7.setText("籍贯");
    jLabel7.setBounds(new Rectangle(225, 121, 38, 17));
    jLabel8.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
    jLabel8.setText("入学时间");
    jLabel8.setBounds(new Rectangle(22, 202, 74, 25));
    jButton1.setBounds(new Rectangle(65, 253, 71, 31));
    jButton1.setText("提交");
    jButton2.setBounds(new Rectangle(169, 253, 77, 30));
    jButton2.setText("重置");
    jButton3.setBounds(new Rectangle(286, 252, 75, 30));
    jButton3.setText("返回");
    jLabel9.setFont(new java.awt.Font("宋体", 1, 13));
    jLabel9.setText("备注");
    jLabel9.setBounds(new Rectangle(227, 201, 33, 21));
    jTextField9.setBounds(new Rectangle(282, 201, 80, 20));
    jComboBox1.setBounds(new Rectangle(90, 121, 80, 20));
    if(!(jComboBox1.getItemCount()==2))
    {
      jComboBox1.addItem("男");
      jComboBox1.addItem("女");
    }
    jComboBox2.setBounds(new Rectangle(281, 34, 107, 21));
    if(!(jComboBox2.getItemCount()==7))
      {
        jComboBox2.addItem("数学院");
        jComboBox2.addItem("文学院");
        jComboBox2.addItem("医学院");
        jComboBox2.addItem("历史学院");
        jComboBox2.addItem("材料学院");
        jComboBox2.addItem("软件学院");
        jComboBox2.addItem("生命科学院");
      }
    jComboBox3.setBounds(new Rectangle(282, 119, 59, 23));
    if(!(jComboBox3.getItemCount()==16))
    {
      jComboBox3.addItem("北京");
      jComboBox3.addItem("上海");
      jComboBox3.addItem("天津");
      jComboBox3.addItem("南京");
      jComboBox3.addItem("山东");
      jComboBox3.addItem("山西");
      jComboBox3.addItem("陕西");
      jComboBox3.addItem("湖南");
      jComboBox3.addItem("云南");
      jComboBox3.addItem("湖北");
      jComboBox3.addItem("湖南");
      jComboBox3.addItem("河北");
      jComboBox3.addItem("河南");
      jComboBox3.addItem("吉林");
      jComboBox3.addItem("内蒙古");
      jComboBox3.addItem("黑龙江");
    }
    jComboBox4.setBounds(new Rectangle(344, 119, 53, 22));
    if((!(jComboBox4.getItemCount()==17))/*&&(jComboBox3.getSelectedItem().equals("山东"))*/)
    {
      jComboBox4.addItem("济南");
      jComboBox4.addItem("青岛");
      jComboBox4.addItem("淄博");
      jComboBox4.addItem("德州");
      jComboBox4.addItem("莱芜");
      jComboBox4.addItem("烟台");
      jComboBox4.addItem("滨州");
      jComboBox4.addItem("东营");
      jComboBox4.addItem("荷泽");
      jComboBox4.addItem("枣庄");
      jComboBox4.addItem("潍坊");
      jComboBox4.addItem("威海");
      jComboBox4.addItem("临沂");
      jComboBox4.addItem("泰安");
      jComboBox4.addItem("日照");
      jComboBox4.addItem("聊城");
      jComboBox4.addItem("济宁");
    }
    jComboBox5.setBounds(new Rectangle(90, 201, 97, 21));
    if(!(jComboBox5.getItemCount()==19))
    {
      jComboBox5.addItem("1990年");
      jComboBox5.addItem("1991年");
      jComboBox5.addItem("1992年");
      jComboBox5.addItem("1993年");
      jComboBox5.addItem("1994年");
      jComboBox5.addItem("1995年");
      jComboBox5.addItem("1996年");
      jComboBox5.addItem("1997年");
      jComboBox5.addItem("1998年");
      jComboBox5.addItem("1999年");
      jComboBox5.addItem("2000年");
      jComboBox5.addItem("2001年");
      jComboBox5.addItem("2002年");
      jComboBox5.addItem("2003年");
      jComboBox5.addItem("2004年");
      jComboBox5.addItem("2005年");
      jComboBox5.addItem("2006年");
      jComboBox5.addItem("2007年");
      jComboBox5.addItem("2008年");
    }
    jLabel4.setFont(new java.awt.Font("宋体", 1, 13));
    jLabel4.setText("出生年月");
    jLabel4.setBounds(new Rectangle(23, 164, 60, 23));
    jComboBox6.setBounds(new Rectangle(90, 166, 74, 21));
    if(!(jComboBox6.getItemCount()==29))
    {
      jComboBox6.addItem("1970");
      jComboBox6.addItem("1971");
      jComboBox6.addItem("1972");
      jComboBox6.addItem("1973");
      jComboBox6.addItem("1974");
      jComboBox6.addItem("1975");
      jComboBox6.addItem("1976");
      jComboBox6.addItem("1977");
      jComboBox6.addItem("1978");
      jComboBox6.addItem("1979");
      jComboBox6.addItem("1980");
      jComboBox6.addItem("1981");
      jComboBox6.addItem("1982");
      jComboBox6.addItem("1983");
      jComboBox6.addItem("1984");
      jComboBox6.addItem("1985");
      jComboBox6.addItem("1986");
      jComboBox6.addItem("1987");
      jComboBox6.addItem("1988");
      jComboBox6.addItem("1989");
      jComboBox6.addItem("1990");
      jComboBox6.addItem("1991");
      jComboBox6.addItem("1992");
      jComboBox6.addItem("1993");
      jComboBox6.addItem("1994");
      jComboBox6.addItem("1995");
      jComboBox6.addItem("1996");
      jComboBox6.addItem("1997");
      jComboBox6.addItem("1998");
    }
    jLabel10.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel10.setRequestFocusEnabled(true);
    jLabel10.setText("年");
    jLabel10.setBounds(new Rectangle(169, 167, 18, 19));
    jComboBox7.setBounds(new Rectangle(185, 167, 53, 19));
    if(!(jComboBox7.getItemCount()==12))
    {
      jComboBox7.addItem("01");
      jComboBox7.addItem("02");
      jComboBox7.addItem("03");
      jComboBox7.addItem("04");
      jComboBox7.addItem("05");
      jComboBox7.addItem("06");
      jComboBox7.addItem("07");
      jComboBox7.addItem("08");
      jComboBox7.addItem("09");
      jComboBox7.addItem("10");
      jComboBox7.addItem("11");
      jComboBox7.addItem("12");
    }
    jLabel11.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel11.setText("月");
    jLabel11.setBounds(new Rectangle(245, 168, 21, 17));
    jComboBox8.setBounds(new Rectangle(281, 75, 109, 20));
    if(!(jComboBox8.getItemCount()==3))
    {
      jComboBox8.addItem("软件工程");
      jComboBox8.addItem("电子商务");
      jComboBox8.addItem("计算机科学与技术");
    }

    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(jTextField1, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jTextField2, null);
    this.getContentPane().add(jLabel5, null);
    this.getContentPane().add(jLabel6, null);
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton2, null);
    this.getContentPane().add(jButton3, null);
    this.getContentPane().add(jComboBox2, null);
    this.getContentPane().add(jLabel4, null);
    this.getContentPane().add(jTextField9, null);
    this.getContentPane().add(jLabel9, null);
    this.getContentPane().add(jLabel11, null);
    this.getContentPane().add(jComboBox7, null);
    this.getContentPane().add(jComboBox6, null);
    this.getContentPane().add(jLabel8, null);
    this.getContentPane().add(jComboBox5, null);
    this.getContentPane().add(jComboBox1, null);
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(jLabel7, null);
    this.getContentPane().add(jComboBox3, null);
    this.getContentPane().add(jComboBox4, null);
    this.getContentPane().add(jLabel10, null);
    this.getContentPane().add(jComboBox8, null);
    jButton1.addActionListener(this);
    jButton2.addActionListener(this);
    jButton3.addActionListener(this);
  }
}