scoresquery.java~32~

学生信息管理系统,包括成绩查询,成绩排序,用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)
  {
     if(e.getActionCommand().equals("开始查询"))
     {
       try
         {
           System.out.println("     学号"+"   \t  姓名"+"    \t高等数学"+"   \t JAVA"+"    \t计算机组成原理"+"  \tPSP"+"      \t 大学英语"+"   \t 军事理论"+"  \t  中华民族历史与精神"+"    \t传统文学修养"+"   \t体育"+"      \t总成绩"+"   \t GPA成绩"+"   \t 排名"+"     \t 备注");
           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);
           while(resultSet.next())
           {
                 String  ID=resultSet.getString(1);
                 String  name=resultSet.getString(2);
                 double  sex=Double.parseDouble(resultSet.getString(3));
                 double age=Double.parseDouble(resultSet.getString(4));
                 double department=Double.parseDouble(resultSet.getString(5));
                 double major=Double.parseDouble(resultSet.getString(6));
                 double homeplace=Double.parseDouble(resultSet.getString(7));
                 double   timeOfEntering=Double.parseDouble(resultSet.getString(8));
                 double  n1=Double.parseDouble(resultSet.getString(9));
                 double   n2=Double.parseDouble(resultSet.getString(10));
                 double   n3=Double.parseDouble(resultSet.getString(11));
                 double   n4=Double.parseDouble(resultSet.getString(12));
                 double   n5=Double.parseDouble(resultSet.getString(13));

                 int  n7=Integer.parseInt(resultSet.getString(15));
                 String  n8=resultSet.getString(16);
                 System.out.println(ID+"    \t"+name+"   \t "+ sex+"    \t"+age+"   \t "+department+"    \t"+major+"      \t"+homeplace+"      \t"+timeOfEntering+"   \t   "+n1+"    \t        "+n2+"  \t       "+n3+"  \t       "+n4+"   \t        "+n5+"  \t         "+"   \t    "+n7+" \t    "+n8+"     \t  ");


           }
           stmt.close();
           con.close();
         }
         catch(Exception ex)
         {
           System.out.println(ex.getStackTrace());
           System.out.println(ex.getMessage());
         }

     }
    else if(e.getActionCommand().equals("重置"))
    {

    }
    else if(e.getActionCommand().equals("返回"))
    {
        this.setVisible(false);
        ManagerInterface n=new ManagerInterface();
        n.setVisible(true);
    }
  }
  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("查询排名");
    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);
  }


}