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

 if(e.getActionCommand().equals("登录"))
    {
        String ID=jTextField1.getText();
        String password=jPasswordField1.getText();

        if((ID.equals("1")&&password.equals("1"))|(ID.equals("12")&&password.equals("12"))|(ID.equals("123")&&password.equals("123"))|(ID.equals("1234")&&password.equals("1234"))|(ID.equals("12345")&&password.equals("12345"))|(ID.equals("123456")&&password.equals("123456")))
        {   this.setVisible(false);
            ManagerInterface n=new ManagerInterface();
            n.setVisible(true);
        }
        else
        {
           JOptionPane.showMessageDialog(null,"您输入的帐号或密码不正确,请重新输入!","张呈刚提醒您.....",JOptionPane.WARNING_MESSAGE);
           jTextField1.setText("");
           jPasswordField1.setText("");   //弹出警告提示框并把已输入的帐号和密码清除,以让用户重新输入
        }
    }
  

 String [] columnNames={"帐号","姓名","密码","级别","状态","备注"};
         Object [][] rowData=new Object[6][8];
         int count=0;

          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 ManagersInformation WHERE 帐号='"+jTextField1.getText()+"' AND 密码='"+jPasswordField1.getText()+"'";
          ResultSet resultSet=stmt.executeQuery(SQLOrder);
          System.out.println("帐号"+jTextField1.getText());
          System.out.println("密码"+jPasswordField1.getText());
           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);
             count++;
           }
           System.out.println("2!");
           stmt.close();
           con.close();
           System.out.println("3!");
          }
        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(650,450);
       setBackground(Color.green);
       setVisible(true);    //设置窗口可视
      // setDefaultCloseDperation(JFrame.EXIT_ON_CLOSE);