managerinterface.java~61~

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

      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 ORDER BY 姓名";
          ResultSet resultSet=stmt.executeQuery(SQLOrder);
          int count=0;
            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++;
            }
           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(650,450);
        setBackground(Color.green);
        setVisible(true);    //设置窗口可视
       // setDefaultCloseDperation(JFrame.EXIT_ON_CLOSE);
    }
    else if(cmd.equals("按单科成绩"))//排序不对，要单独读到一个数组里进行排序，然后输出,有待改进！
    {
      this.dispose();
      OrderByOne n=new OrderByOne();
      n.setVisible(true);
    }
    else if(cmd.equals("按GPA成绩"))//排序不对，要单独读到一个数组里进行排序，然后输出,有待改进！
    {
       String [] columnNames={"学号","姓名","高等数学","JAVA","计算机组成原理","个体软件过程","大学英语","军事理论","总成绩","GPA成绩","备注"};
       Object [][] rowData=new Object[30][19];
        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 ORDER BY GPA成绩";
          ResultSet resultSet=stmt.executeQuery(SQLOrder);
          int count=0;
           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++;
           }
           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(650,450);
        setVisible(true);    //设置窗口可视
         // setDefaultCloseDperation(JFrame.EXIT_ON_CLOSE);
    }
    else if(cmd.equals("添加学生"))
    {
      this.dispose();
      StudentsAdd n=new StudentsAdd();
      n.setVisible(true);
    }
    else if(cmd.equals("删除学生"))
    {
      this.dispose();
      StudentsDelete n=new StudentsDelete();
      n.setVisible(true);
    }
    else if(cmd.equals("修改密码"))
    {
      this.dispose();
      PasswordsChange n=new PasswordsChange();
      n.setVisible(true);
    }
    else if(cmd.equals("查询密码"))
    {
      this.dispose();
      PasswordsQuery n=new PasswordsQuery();
      n.setVisible(true);
    }
    else if(cmd.equals("添加管理员"))
    {
      this.dispose();
      ManagersAdd n=new ManagersAdd();
      n.setVisible(true);
    }
    else if(cmd.equals("退出系统"))
    {
       System.exit(0);
    }
    else if(cmd.equals("重新登录"))
    {
      this.dispose();
      Login n=new Login();
      n.setVisible(true);
    }
    else if(cmd.equals("开始打印"))
    {
       JOptionPane.showMessageDialog(null,"对不起，您还没有配置打印机！","张呈刚提醒您......",JOptionPane.WARNING_MESSAGE);
    }
    else if(cmd.equals("使用说明"))
    {
          this.dispose();
          Instructions n=new Instructions();
          n.setVisible(true);
    }
    else if(cmd.equals("版本信息"))
    {
          JOptionPane.showMessageDialog(null,"学生信息综合管理系统，开发者:张呈刚(05软件3班)","版本信息",JOptionPane.INFORMATION_MESSAGE);
    }
  }
//  public void paint(Graphics g)
//  {
//    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 帐号='"+Login.jTextField1.getText()+"'";
//         ResultSet resultSet=stmt.executeQuery(SQLOrder);
//         while(resultSet.next())
//         {
//           String name=resultSet.getString("姓名");
//           g.drawString(name+",你好,欢迎来到学生信息管理系统！",400-4*n,200);
//         }
//         stmt.close();
//         con.close();
//       }
//       catch(Exception ex)
//       {
//         System.out.println(ex.getStackTrace());
//         System.out.println(ex.getMessage());
//       }
//    try
//    {
//      Thread.sleep(200);
//    }
//    catch(InterruptedException e){}
//    if(n==150)     n=0;
//    else    n++;
//      repaint();
//  }
//  public void update(Graphics g)
//  {
//    g.setColor(getBackground());
//    g.fillRect(0,0,WIDTH,HEIGHT);
//    g.setColor(getForeground());
//    paint(g);
//  }
  private void jbInit() throws Exception
 {
   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 帐号='"+Login.jTextField1.getText()+"'";
        ResultSet resultSet=stmt.executeQuery(SQLOrder);
        while(resultSet.next())
        {
          String name=resultSet.getString("姓名");
          jLabel1.setText(Login.jTextField1.getText()+" "+name+",你好！欢迎登录学生信息管理系统！");
        }
        stmt.close();
        con.close();
      }
      catch(Exception ex)
      {
        System.out.println(ex.getStackTrace());
        System.out.println(ex.getMessage());
      }
   jLabel1.setFont(new java.awt.Font("Dialog", 1, 14));
   jLabel1.setForeground(new Color(125, 98, 255));
   jLabel1.setBounds(new Rectangle(1, 100, 400, 121));
   this.getContentPane().setLayout(new FlowLayout());
   this.setFont(new java.awt.Font("Dialog", 1, 16));
   this.setForeground(new Color(255, 98, 98));
   this.getContentPane().add(jLabel1, null);
 }

  public static void main(String[] args)
  {
    ManagerInterface n=new ManagerInterface();
    n.setVisible(true);
  }

}