basicinformationquery.java~83~

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

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

public class BasicInformationQuery extends JFrame implements ActionListener
{
   public static final int WIDTH=400;
   public static final int HEIGHT=400;
  JLabel jLabel1 = new JLabel();
  JButton jButton1 = new JButton();
  static JButton jButton2 = new JButton();
  static JTextField jTextField1 = new JTextField(10);
  JButton jButton3 = new JButton();

  public  BasicInformationQuery()
   {
       setTitle("基本信息查询");
       setSize(WIDTH,HEIGHT);
       Container contentPane=getContentPane();
       contentPane.setBackground(Color.green);
       contentPane.setLayout(new FlowLayout());
    try
    {
      jbInit();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }

   }
  public void actionPerformed(ActionEvent e)
  {    String [] columnNames={"学号","姓名","性别","年龄","院系","专业","籍贯","入学时间","备注"};
       Object [][] rowData=new Object[20][10];
       int count=0;
     if(e.getActionCommand().equals("开始查询"))
     {
        try
        {
          String url="jdbc:odbc:MySecondAccess";
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          Connection con=DriverManager.getConnection(url,"","");
          Statement stmt=con.createStatement();

          String  SQLOrder="SELECT * FROM BasicInformation WHERE 学号='"+jTextField1.getText()+"'";
          ResultSet resultSet=stmt.executeQuery(SQLOrder);
           if(resultSet.next())
           {
             rowData [count][0] = resultSet.getString(1);
             rowData [count][1] = resultSet.getString(2);
             rowData [count][2] = resultSet.getString(3);
             rowData [count][3] = resultSet.getString(4);
             rowData [count][4] = resultSet.getString(5);
             rowData [count][5] = resultSet.getString(6);
             rowData [count][6] = resultSet.getString(7);
             rowData [count][7] = resultSet.getString(8);
             rowData [count][8] = resultSet.getString(9);
             count++;
             Container container=getContentPane();          //获取窗口容器
             JTable table=new JTable(rowData,columnNames);         //实例化表格
             table.getColumn("年龄").setMaxWidth(35);               //设置行宽
             container.add(new JScrollPane(table),BorderLayout.CENTER); //增加组件
             setSize(600,450);
             setVisible(true);    //设置窗口可视
             // setDefaultCloseDperation(JFrame.EXIT_ON_CLOSE);
           }
           else
             JOptionPane.showMessageDialog(null,"对不起,不存在此学号的学生!","张呈刚提醒您.......",JOptionPane.WARNING_MESSAGE);
           jTextField1.setText("");
           stmt.close();
           con.close();
        }
        catch(Exception ex)
        {
          System.out.println(ex.getStackTrace());
          System.out.println(ex.getMessage());
        }

//        Container container=getContentPane();          //获取窗口容器
//        JTable table=new JTable(rowData,columnNames);         //实例化表格
//        table.getColumn("年龄").setMaxWidth(35);               //设置行宽
//        container.add(new JScrollPane(table),BorderLayout.CENTER); //增加组件
//        setSize(600,450);
//        setVisible(true);    //设置窗口可视
//         // setDefaultCloseDperation(JFrame.EXIT_ON_CLOSE);
     }
    else if(e.getActionCommand().equals("显示所有学生"))
    {
      try
       {
         String url="jdbc:odbc:MySecondAccess";
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         Connection con=DriverManager.getConnection(url,"","");
         Statement stmt=con.createStatement();
         String  SQLOrder="SELECT * FROM BasicInformation ";
         ResultSet resultSet=stmt.executeQuery(SQLOrder);
          while (resultSet.next())
          {
            rowData [count][0] = resultSet.getString(1);
            rowData [count][1] = resultSet.getString(2);
            rowData [count][2] = resultSet.getString(3);
            rowData [count][3] = resultSet.getString(4);
            rowData [count][4] = resultSet.getString(5);
            rowData [count][5] = resultSet.getString(6);
            rowData [count][6] = resultSet.getString(7);
            rowData [count][7] = resultSet.getString(8);
            rowData [count][8] = resultSet.getString(9);
            count++;
          }
          jTextField1.setText("");
          stmt.close();
          con.close();
       }
       catch(Exception ex)
       {
         System.out.println(ex.getStackTrace());
         System.out.println(ex.getMessage());
       }
       Container container=getContentPane();          //获取窗口容器
       JTable table=new JTable(rowData,columnNames);         //实例化表格
       table.getColumn("年龄").setMaxWidth(35);               //设置行宽
       container.add(new JScrollPane(table),BorderLayout.CENTER); //增加组件
       setSize(600,450);
       setVisible(true);    //设置窗口可视
        // setDefaultCloseDperation(JFrame.EXIT_ON_CLOSE);
    }
    else if(e.getActionCommand().equals("返回"))
    {
         this.setVisible(false);
         ManagerInterface n1= new ManagerInterface();
         StudentInterface n2=new  StudentInterface();
         if(Login.jComboBox1.getSelectedIndex()==0)
               {  n1.setVisible(true);  n2.setVisible(false);}
         else if(Login.jComboBox1.getSelectedIndex()==1)
               {  n2.setVisible(true);  n1.setVisible(false); }
    }
  }
  public static void main(String[] args)
  {
        BasicInformationQuery  n = new  BasicInformationQuery();
        n.setVisible(true);
  }
  private void jbInit() throws Exception
  {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setText("请输入您所要查询的学生的学号:");
    jLabel1.setBounds(new Rectangle(27, 35, 236, 58));
    this.getContentPane().setLayout(new FlowLayout());
    jButton1.setBounds(new Rectangle(57, 84, 123, 31));
    jButton1.setText("开始查询");
    jButton2.setBounds(new Rectangle(208, 84, 122, 31));
    jButton2.setText("显示所有学生");
    if(Login.jComboBox1.getSelectedIndex()==1)
     {
        System.out.println(Login.jTextField1.getText());
        String userName = Login.userName;
        System.out.println(userName);
        jButton2.setEnabled(false);
        this.jTextField1.setText(Login.jTextField1.getText());
        //this.jTextField1.setText(userName);
        jTextField1.setEditable(false);
        this.repaint();

     }
    jTextField1.setBounds(new Rectangle(263, 49, 104, 26));
    jButton3.setBounds(new Rectangle(164, 325, 66, 31));
    jButton3.setText("返回");
    this.getContentPane().add(jLabel1, -1);
    this.getContentPane().add(jTextField1, -1);
    this.getContentPane().add(jButton1, -1);
    this.getContentPane().add(jButton2, -1);
    this.getContentPane().add(jButton3);
    jButton1.addActionListener(this);
    jButton2.addActionListener(this);
    jButton3.addActionListener(this);
  }


}