studentinterface.java

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

package Chapter1;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class StudentInterface  extends JFrame implements ActionListener
{
  public static final int WIDTH=400;
  public static final int HEIGHT=400;
  JLabel jLabel1 = new JLabel();
  public StudentInterface()
  {
    setSize(WIDTH,HEIGHT);
    setTitle("学生信息管理系统学生用户界面");
    Container contentPane=getContentPane();
    contentPane.setBackground(Color.green);
    JMenu m1=new JMenu("信息录入");
    JMenu m2=new JMenu("信息查询");
    JMenu m3=new JMenu("查看排名");
    JMenu m4=new JMenu("系统");
    JMenu m5=new JMenu("打印");
    JMenu m6=new JMenu("帮助");
    JMenu m7=new JMenu("已选课删除");

    JMenuItem m11=new JMenuItem("选课信息录入");

    m11.addActionListener(this);
    m1.add(m11);
                    //完成第一个菜单的定义

    JMenuItem m21=new JMenuItem("基本信息查询");
    JMenuItem m22=new JMenuItem("课程信息查询");
    JMenuItem m23=new JMenuItem("选课信息查询");
    JMenuItem m24=new JMenuItem("成绩查询");
    m21.addActionListener(this);
    m22.addActionListener(this);
    m23.addActionListener(this);
    m24.addActionListener(this);
    m2.add(m21);
    m2.add(m22);
    m2.add(m23);
    m2.add(m24);                     //完成第二个菜单的定义


    JMenuItem m31=new JMenuItem("按单科成绩");
    JMenuItem m32=new JMenuItem("按GPA成绩");
    m31.addActionListener(this);
    m32.addActionListener(this);
    m3.add(m31);
    m3.add(m32);
                                    //完成第三个菜单的定义
    JMenuItem m40=new JMenuItem("查询密码");
    JMenuItem m41=new JMenuItem("修改密码");
    JMenuItem m42=new JMenuItem("退出系统");
    JMenuItem m43=new JMenuItem("重新登录");
    m40.addActionListener(this);
    m41.addActionListener(this);
    m42.addActionListener(this);
    m43.addActionListener(this);
    m4.add(m40);
    m4.add(m41);
    m4.add(m42);
    m4.add(m43);               //完成第四个菜单的定义

    JMenuItem m51=new JMenuItem("开始打印");
    m51.addActionListener(this);
   m5.add(m51);              //完成第五个菜单的定义

   JMenuItem m61=new JMenuItem("使用说明");
   JMenuItem m62=new JMenuItem("版本信息");
   m61.addActionListener(this);
   m62.addActionListener(this);
   m6.add(m61);
   m6.add(m62);

   JMenuItem m71=new JMenuItem("已选课删除");
   m71.addActionListener(this);
   m7.add(m71);

    JMenuBar mBar=new JMenuBar();
    mBar.add(m1);
    mBar.add(m2);
    mBar.add(m7);
    mBar.add(m3);
    mBar.add(m4);
    mBar.add(m5);
    mBar.add(m6);
    setJMenuBar(mBar);
    try
    {
      jbInit();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }
  public void actionPerformed(ActionEvent e)
  {
    String cmd=e.getActionCommand();
    if(cmd.equals("选课信息录入"))
    {
       this.dispose();
       ClassesChoiceInput n = new ClassesChoiceInput();
       n.setVisible(true);
    }
    else if(cmd.equals("基本信息查询"))
    {
      this.dispose();
      BasicInformationQuery  n = new  BasicInformationQuery();
      n.setVisible(true);
    }
    else if(cmd.equals("课程信息查询"))
    {
       this.dispose();
       ClassesInformationQuery  n = new ClassesInformationQuery();
       n.setVisible(true);
    }
    else if(cmd.equals("选课信息查询"))
    {
        this.dispose();
        ClassesChoiceQuery  n = new ClassesChoiceQuery();
        n.setVisible(true);
    }
    else if(cmd.equals("成绩查询"))
    {
          this.dispose();
          ScoresQuery n=new ScoresQuery();
          n.setVisible(true);
    }
    else if(cmd.equals("已选课删除"))
    {
      this.dispose();
       String name=JOptionPane.showInputDialog("请输入您要删除的课程的课程名!");
       try
          {
            String url="jdbc:odbc:MySecondAccess";
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con=DriverManager.getConnection(url,"","");
            Statement stmt=con.createStatement();
            String  SQLOrder="UPDATE ClassesChoicesInformation SET "+name+"='未选' WHERE 学号='"+Login.ID+"'";
            stmt.executeUpdate(SQLOrder);
            stmt.close();
            con.close();
           JOptionPane.showMessageDialog(null,"已选课程删除成功！","提示信息",JOptionPane.INFORMATION_MESSAGE);
          }
          catch(Exception ex)
          {
            System.out.println(ex.getStackTrace());
            System.out.println(ex.getMessage());
          }
    }
    else if(cmd.equals("修改密码"))
    {
         String formerPassword=JOptionPane.showInputDialog("请输入您的旧密码!");
         if(!formerPassword.equals(Login.password))
         {
               JOptionPane.showMessageDialog(null,"您输入的旧密码不正确！请重新输入！","提示信息",JOptionPane.WARNING_MESSAGE);
               formerPassword=JOptionPane.showInputDialog("请输入您的旧密码!");
         }
         else
         {
           String newPassword1=JOptionPane.showInputDialog("请输入您的新密码!");
           String newPassword2=JOptionPane.showInputDialog("请确认新密码!");
           if(formerPassword.equals(Login.password)&&newPassword1.equals(newPassword2))
           {
            try
            {
             String url="jdbc:odbc:MySecondAccess";
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con=DriverManager.getConnection(url,"","");
             Statement stmt=con.createStatement();
             String  SQLOrder="UPDATE StudentsInformation SET 密码='"+newPassword1+"' WHERE 帐号='"+Login.ID+"'";
             stmt.executeUpdate(SQLOrder);
             stmt.close();
             con.close();
            }
            catch(Exception ex)
               {
                 System.out.println(ex.getStackTrace());
                 System.out.println(ex.getMessage());
               }
           }
         }
    }
    else if(cmd.equals("查询密码"))
    {
      JOptionPane.showMessageDialog(null,"您的密码是"+Login.password,"查询密码",JOptionPane.INFORMATION_MESSAGE);
    }
    else if(cmd.equals("退出系统"))
    {
       System.exit(0);
    }
    else if(cmd.equals("重新登录"))
    {
      this.dispose();
      Login n=new Login();
      n.setVisible(true);
    }
    else if(cmd.equals("按单科成绩"))
    {
      //出一个INPUTDIALOG令用户输入按哪一门课排名显示最高分、最低分及排名!
    }
    else if(cmd.equals("按GPA成绩"))
    {
       //出一个INFORMATIONTDIALOG输出你的学分基点并显示最高分、最低分及排名及应获得的奖学金!
    }
    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 static void main(String[] args)
  {
    StudentInterface n=new StudentInterface();
    n.setVisible(true);
  }
  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 StudentsInformation 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);
  }
}