scoresquery.java

学生信息管理系统,包括成绩查询,成绩排序,用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 ScoresQuery extends JFrame implements ActionListener
{
   public static final int WIDTH=400;
   public static final int HEIGHT=400;
  JLabel jLabel1 = new JLabel();
  JButton jButton1 = new JButton();
  JTextField jTextField1= new JTextField(11);
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  public ScoresQuery()
   {
       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={"学号","姓名","高等数学","JAVA","计算机组成原理","PSP","大学英语","军事理论","总成绩","GPA成绩","备注"};
      Object [][] rowData=new Object[20][11];
      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 Scores 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] = Double.toString(resultSet.getDouble("高等数学"));
            rowData [count][3] = Double.toString(resultSet.getDouble("JAVA"));
            rowData [count][4] = Double.toString(resultSet.getDouble("计算机组成原理"));
            rowData [count][5] = Double.toString(resultSet.getDouble("个体软件过程"));
            rowData [count][6] = Double.toString(resultSet.getDouble("大学英语"));
            rowData [count][7] = Double.toString(resultSet.getDouble("军事理论"));
            rowData [count][8] = Double.toString(resultSet.getDouble("总成绩"));
            rowData [count][9] = Double.toString(resultSet.getDouble("GPA成绩"));
            rowData [count][10] = resultSet.getString("备注");
            count++;
            Container container=getContentPane();                  //获取窗口容器
            JTable table=new JTable(rowData,columnNames);         //实例化表格
            table.getColumn("JAVA").setMaxWidth(35);               //设置行宽
            container.add(new JScrollPane(table),BorderLayout.CENTER); //增加组件
            setSize(650,450);
            setBackground(Color.green);
            setVisible(true);    //设置窗口可视
              // setDefaultCloseDperation(JFrame.EXIT_ON_CLOSE);
           }
           else
             JOptionPane.showMessageDialog(null,"对不起,不存在此学号的学生!","张呈刚提醒您.......",JOptionPane.WARNING_MESSAGE);
           stmt.close();
           con.close();
         }
         catch(Exception ex)
         {
            JOptionPane.showMessageDialog(null,ex.getMessage(),"警告信息",JOptionPane.WARNING_MESSAGE);
            JOptionPane.showMessageDialog(null,ex.getStackTrace(),"警告信息",JOptionPane.WARNING_MESSAGE);
         }
        jTextField1.setText("");
     }
    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 Scores ";
        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);
           rowData [count][9] = resultSet.getString(10);
           rowData [count][10] = resultSet.getString(11);
           count++;
         }
         jTextField1.setText("");
         stmt.close();
         con.close();
      }
      catch(Exception ex)
      {
           JOptionPane.showMessageDialog(null,ex.getMessage(),"警告信息",JOptionPane.WARNING_MESSAGE);
           JOptionPane.showMessageDialog(null,ex.getStackTrace(),"警告信息",JOptionPane.WARNING_MESSAGE);
      }
      Container container=getContentPane();          //获取窗口容器
      JTable table=new JTable(rowData,columnNames);         //实例化表格
      table.getColumn("JAVA").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.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)
  {
       ScoresQuery  n = new ScoresQuery();
        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(285, 82, 102, 31));
    jButton1.setText("开始查询");
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(263, 49, 104, 26));
    jButton2.setBounds(new Rectangle(286, 190, 100, 30));
    jButton2.setText("显示所有学生的成绩");
    if(Login.jComboBox1.getSelectedIndex()==1)
   {
      jButton2.setEnabled(false);
      this.jTextField1.setText(Login.ID);
      jTextField1.setEditable(false);
   }
    jButton3.setBounds(new Rectangle(286, 271, 96, 28));
    jButton3.setText("返回");
    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(jTextField1, null);
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton2, null);
    this.getContentPane().add(jButton3);
    jButton1.addActionListener(this);
    jButton2.addActionListener(this);
    jButton3.addActionListener(this);
  }
}