classesinformationquery.java~14~

学生信息管理系统,包括成绩查询,成绩排序,用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 ClassesInformationQuery extends JFrame implements ActionListener
{
   public static final int WIDTH=400;
   public static final int HEIGHT=400;
  JLabel jLabel1 = new JLabel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JTextField jTextField1 = new JTextField();
  JTextArea jTextArea1 = new JTextArea();
  JButton jButton3 = new JButton();

  public ClassesInformationQuery()
   {
       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
       {
         String url="jdbc:odbc:MySecondAccess";
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         Connection con=DriverManager.getConnection(url,"","");
         Statement stmt=con.createStatement();
         String  SQLOrder="SELECT * FROM ClassesInformation WHERE 课程号='"+jTextField1.getText()+"'";
         ResultSet resultSet=stmt.executeQuery(SQLOrder);

           while(resultSet.next())
           {
             String  num1=resultSet.getString(1);   //课程号
             String  num2=resultSet.getString(1);   //课序号
             String  name=resultSet.getString(1);  //课程名
             String  teacher=resultSet.getString(1);  //授课教师
             String  time=resultSet.getString(1);      //上课时间
             String  place=resultSet.getString(1);  //上课地点
             String  goal=resultSet.getString(1);//学分
             String  kind=resultSet.getString(1);          //课程性质
             String  testKind=resultSet.getString(1);    //考试形式
             String  addition=resultSet.getString(1);   //备注
                                                                     //用于获取用户输入的信息
               System.out.println("课程号:"+num1+"\n"+"课序号:"+num2+"\n"+"课程名:"+ name+"\n"+"授课教师:"+teacher+"\n"+"上课时间:"+time+"\n"+"上课地点:"+place+"\n"+"学分:"+goal+"\n"+"课程性质:"+kind+"考试形式:"+testKind+"备注:"+addition);
           }

         stmt.close();
         con.close();
       }
       catch(Exception ex)
       {
         System.out.println("Failure in connecting with the database!");
         System.out.println(ex.getMessage());
       }

     }
    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 ClassesInformation ";
         ResultSet resultSet=stmt.executeQuery(SQLOrder);
         while(resultSet.next())
         {
               String  ID=resultSet.getString(1);
               String  name=resultSet.getString(2);
               String  sex=resultSet.getString(3);
               int age=Integer.parseInt(resultSet.getString(4));
               String  department=resultSet.getString(5);
               String  major=resultSet.getString(6);
               String  homeplace=resultSet.getString(7);
               String  timeOfEntering=resultSet.getString(8);
               System.out.println("学号:"+ID+"\n"+"姓名:"+name+"\n"+"性别:"+ sex+"\n"+"年龄:"+age+"\n"+"院系:"+department+"\n"+"专业:"+major+"\n"+"籍贯:"+homeplace+"\n"+"入学时间:"+timeOfEntering);
         }
         stmt.close();
         con.close();
       }
       catch(Exception ex)
       {

         System.out.println(ex.getMessage());
       }

    }
    else if(e.getActionCommand().equals("返回"))
    {
      this.setVisible(false);
      ManagerInterface n=new ManagerInterface();
      n.setVisible(true);
    }
  }
  public static void main(String[] args)
  {
       ClassesInformationQuery  n = new ClassesInformationQuery();
        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(null);
    jButton1.setBounds(new Rectangle(25, 84, 102, 31));
    jButton1.setText("开始查询");
    jButton2.setBounds(new Rectangle(231, 83, 146, 31));
    jButton2.setText("显示所有课程信息");
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(263, 49, 104, 26));
    jTextArea1.setBounds(new Rectangle(5, 118, 382, 174));
    jButton3.setBounds(new Rectangle(138, 302, 92, 25));
    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(jTextArea1, null);
    this.getContentPane().add(jButton3);
    jButton1.addActionListener(this);
    jButton2.addActionListener(this);
    jButton3.addActionListener(this);
  }


}