mainframe.java

用Java开发的学生信息管理系统

package studentsystem;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.UIManager;
import java.awt.Toolkit;
import java.awt.Canvas;

import java.awt.Dimension;
import java.io.FileInputStream;
import sun.audio.AudioStream;
import sun.audio.*;
import java.io.*;


/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @download by http://www.codefans.net
 * @author not attributable
 * @version 1.0
 */

public class mainFrame
    extends JFrame {
  JPanel contentPane;
  String user1;
  int power;
  Statement ps;
  ResultSet rs;
  Connection con;
  String url;
  String username;

  JMenuBar jMenuBar1 = new JMenuBar();
  JMenu jMenuFile = new JMenu();
  JMenu jMenuHelp = new JMenu();
  JMenuItem jMenuHelpAbout = new JMenuItem();
  JMenuItem adduser = new JMenuItem();
  JMenu xjgl = new JMenu();
  JMenuItem cxxj = new JMenuItem();
  JMenuItem xgxj = new JMenuItem();
  JMenuItem tjxj = new JMenuItem();
  JMenu bjgl = new JMenu();
  JMenuItem xgbj = new JMenuItem();
  JMenuItem tjbj = new JMenuItem();
  JMenu kcsz = new JMenu();
  JMenuItem sznj = new JMenuItem();
  JMenuItem xgkc = new JMenuItem();
  JMenuItem tjkc = new JMenuItem();
  JMenu cjgl = new JMenu();
  JMenuItem tjcj = new JMenuItem();
     ImageIcon icon = new ImageIcon("images" + File.separator+"a.jpg");
  JLabel jLabel1 = new JLabel(icon, JLabel.CENTER);
  JMenuItem xgcj = new JMenuItem();
  JMenuItem cxcj = new JMenuItem();
  JMenuItem exit = new JMenuItem();
  JMenuItem jMenuItem1 = new JMenuItem();
  JMenuItem llyh = new JMenuItem();
  JMenuItem login = new JMenuItem();
  JMenu ghbj = new JMenu();
  JMenuItem jMenuItem2 = new JMenuItem();
  JMenuItem jMenuItem3 = new JMenuItem();
  JMenuItem jMenuItem4 = new JMenuItem();
  JMenuItem jMenuItem5 = new JMenuItem();
  FileInputStream fileau;// = new FileInputStream("lzlh.mid");
  AudioStream as;
  JMenu jMenu1 = new JMenu();
  JMenuItem jMenuItem6 = new JMenuItem();
  JMenuItem jMenuItem7 = new JMenuItem();

  public mainFrame() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);

    try {

      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
     }

  //Component initialization
  private void jbInit() throws Exception {
    contentPane = (JPanel)this.getContentPane();
    contentPane.setLayout(null);
    //this.setSize(new Dimension(800, 600));

    this.setResizable(false);
    this.setTitle("学生管理系统");
    jMenuFile.setFont(new java.awt.Font("Dialog", 0, 15));
    jMenuFile.setForeground(Color.black);
    jMenuFile.setText("  系统 ");
    jMenuHelp.setFont(new java.awt.Font("Dialog", 0, 15));
    jMenuHelp.setText(" 帮助  ");
    jMenuHelpAbout.setFont(new java.awt.Font("Dialog", 0, 15));
    jMenuHelpAbout.setText("关于   ");
    jMenuHelpAbout.addActionListener(new mainFrame_jMenuHelpAbout_ActionAdapter(this));
    adduser.setFont(new java.awt.Font("Dialog", 0, 15));
    adduser.setText("添加用户");
    adduser.addActionListener(new mainFrame_adduser_actionAdapter(this));
    xjgl.setFont(new java.awt.Font("Dialog", 0, 15));
    xjgl.setText("  学籍管理  ");
    xjgl.addActionListener(new mainFrame_xjgl_actionAdapter(this));
    bjgl.setFont(new java.awt.Font("Dialog", 0, 15));
    bjgl.setText("  班级管理    ");
    kcsz.setFont(new java.awt.Font("Dialog", 0, 15));
    kcsz.setText("  课程设置  ");
    cjgl.setFont(new java.awt.Font("Dialog", 0, 15));
    cjgl.setText("成绩管理");
    tjcj.setFont(new java.awt.Font("Dialog", 0, 15));
    tjcj.setText("添加成绩信息");
    tjcj.addActionListener(new mainFrame_tjcj_actionAdapter(this));
    tjxj.setFont(new java.awt.Font("Dialog", 0, 15));
    tjxj.setForeground(Color.black);
    tjxj.setText("添加学籍信息");
    tjxj.addActionListener(new mainFrame_tjxj_actionAdapter(this));
    // jMenuItem9.addActionListener(new mainFrame_jMenuItem9_actionAdapter(this));
    xgxj.setFont(new java.awt.Font("Dialog", 0, 15));
    xgxj.setText("修改学籍信息");
    xgxj.addActionListener(new mainFrame_xgxj_actionAdapter(this));
    cxxj.setFont(new java.awt.Font("Dialog", 0, 15));
    cxxj.setText("查询学籍信息");
    cxxj.addActionListener(new mainFrame_cxxj_actionAdapter(this));
    // jMenuItem3.addActionListener(new mainFrame_jMenuItem3_actionAdapter(this));
    tjbj.setFont(new java.awt.Font("Dialog", 0, 15));
    tjbj.setText("添加班级信息");
    tjbj.addActionListener(new mainFrame_tjbj_actionAdapter(this));
    xgbj.setFont(new java.awt.Font("Dialog", 0, 15));
    xgbj.setText("修改班级信息");
    xgbj.addActionListener(new mainFrame_xgbj_actionAdapter(this));
    tjkc.setFont(new java.awt.Font("Dialog", 0, 15));
    tjkc.setText("添加课程信息");
    tjkc.addActionListener(new mainFrame_tjkc_actionAdapter(this));
    xgkc.setFont(new java.awt.Font("Dialog", 0, 15));
    xgkc.setText("修改课程信息");
    xgkc.addActionListener(new mainFrame_xgkc_actionAdapter(this));
    sznj.setFont(new java.awt.Font("Dialog", 0, 15));
    sznj.setText("设置年级课程");
    sznj.addActionListener(new mainFrame_sznj_actionAdapter(this));
    jLabel1.setText("");
    jLabel1.setBounds(new Rectangle(1, 0, 800, 603));
    xgcj.setFont(new java.awt.Font("Dialog", 0, 15));
    xgcj.setText("修改成绩信息");
    xgcj.addActionListener(new mainFrame_xgcj_actionAdapter(this));
    cxcj.setFont(new java.awt.Font("Dialog", 0, 15));
    cxcj.setText("查询成绩信息");
    cxcj.addActionListener(new mainFrame_cxcj_actionAdapter(this));
    exit.setFont(new java.awt.Font("Dialog", 0, 15));
    exit.setText("退出");
    exit.addActionListener(new mainFrame_exit_actionAdapter(this));
    exit.addMouseListener(new mainFrame_exit_mouseAdapter(this));
    jMenuItem1.setFont(new java.awt.Font("Dialog", 0, 15));
    jMenuItem1.setText("修该密码");
    jMenuItem1.addActionListener(new mainFrame_jMenuItem1_actionAdapter(this));
    llyh.setFont(new java.awt.Font("Dialog", 0, 15));
    llyh.setText("浏览用户");
    llyh.addActionListener(new mainFrame_llyh_actionAdapter(this));
    login.setFont(new java.awt.Font("Dialog", 0, 15));
    login.setText("用户登录");
    login.addActionListener(new mainFrame_login_actionAdapter(this));
    ghbj.setFont(new java.awt.Font("Dialog", 0, 15));
    ghbj.setText("更换背景");
    jMenuItem4.setFont(new java.awt.Font("SansSerif", 0, 15));
    jMenuItem4.setHorizontalAlignment(SwingConstants.LEFT);
    jMenuItem4.setHorizontalTextPosition(SwingConstants.LEFT);
    jMenuItem4.setText("森林");
    jMenuItem4.addActionListener(new mainFrame_jMenuItem4_actionAdapter(this));
    jMenuItem3.setFont(new java.awt.Font("Dialog", 0, 15));
    jMenuItem3.setText("红叶");
    jMenuItem3.addActionListener(new mainFrame_jMenuItem3_actionAdapter(this));
    jMenuItem2.setFont(new java.awt.Font("Dialog", 0, 15));
    jMenuItem2.setText("南山");
    jMenuItem2.addActionListener(new mainFrame_jMenuItem2_actionAdapter(this));
    jMenuItem5.setFont(new java.awt.Font("Dialog", 0, 15));
    jMenuItem5.setText("水晶");
    jMenuItem5.addActionListener(new mainFrame_jMenuItem5_actionAdapter(this));
    jMenu1.addActionListener(new mainFrame_jMenu1_actionAdapter(this));
    jMenu1.setFont(new java.awt.Font("Dialog", 0, 15));
    jMenu1.setText("背景音乐");
    jMenuItem7.setFont(new java.awt.Font("Dialog", 0, 15));
    jMenuItem7.setText("打开");
    jMenuItem7.addActionListener(new mainFrame_jMenuItem7_actionAdapter(this));
    jMenuItem6.setFont(new java.awt.Font("Dialog", 0, 15));
    jMenuItem6.setText("关闭");
    jMenuItem6.addActionListener(new mainFrame_jMenuItem6_actionAdapter(this));
    jMenuFile.add(login);
    jMenuFile.add(llyh);
    jMenuFile.add(jMenuItem1);
    jMenuFile.add(adduser);
    jMenuFile.add(exit);
    jMenuHelp.add(jMenuHelpAbout);
    jMenuBar1.add(jMenuFile);
    jMenuBar1.add(xjgl);
    jMenuBar1.add(bjgl);
    jMenuBar1.add(kcsz);
    jMenuBar1.add(cjgl);
    jMenuBar1.add(ghbj);
    jMenuBar1.add(jMenu1);
    jMenuBar1.add(jMenuHelp);
    fileau = new FileInputStream("music" + File.separator+"lzlh.mid");
    as = new AudioStream(fileau);

    xjgl.add(tjxj);
    xjgl.add(xgxj);
    xjgl.add(cxxj);
    bjgl.add(tjbj);
    bjgl.add(xgbj);
    kcsz.add(tjkc);
    kcsz.add(xgkc);
    kcsz.add(sznj);
    cjgl.add(tjcj);
    cjgl.add(xgcj);
    cjgl.add(cxcj);
    contentPane.add(jLabel1, null);
    ghbj.add(jMenuItem4);
    ghbj.add(jMenuItem3);
    ghbj.add(jMenuItem2);
    ghbj.add(jMenuItem5);
    jMenu1.add(jMenuItem7);
    jMenu1.add(jMenuItem6);
    this.setJMenuBar(jMenuBar1);

    xjgl.setEnabled(false);
    bjgl.setEnabled(false);
    kcsz.setEnabled(false);
    cjgl.setEnabled(false);
    jMenuFile.setEnabled(true);
    llyh.setEnabled(false);
    adduser.setEnabled(false);
    jMenuItem7.setEnabled(false);

  this.setBounds(100, 100, 800, 600);
    this.setVisible(true);
    try {
           AudioPlayer.player.start(as);
           //System.out.println("添加音乐成功");
         }
         catch (Exception e1) {
           e1.printStackTrace();
         }


    }



  public static void main(String args[]) {
    mainFrame main = new mainFrame();

  }


  public void jMenuFileExit_actionPerformed(ActionEvent e) {
    System.exit(0);
    Log log = new Log();
    log.addLog("\r\r", username + "退出了系统！");
    log.closeStream();

  }

  //Help | About action performed
  public void jMenuHelpAbout_actionPerformed(ActionEvent e) {
    new about();
  }

  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      jMenuFileExit_actionPerformed(null);
    }
  }

  void adduser_actionPerformed(ActionEvent e) {
    new adduser();
    Log log = new Log();
    log.addLog("\r\r", username + "浏览了添加用户模块！");
    log.closeStream();

  }

  void xgmm_actionPerformed(ActionEvent e) {
    new xiugaimima();
    Log log = new Log();
    log.addLog("\r\r", username + "浏览了修改密码模块！");
    log.closeStream();

  }

  void tjbj_actionPerformed(ActionEvent e) {
    new addxj();
    Log log = new Log();
    log.addLog("\r\r", username + "浏览了添加学籍模块");
    log.closeStream();

  }

  void exit_actionPerformed(ActionEvent e) {
    Log log = new Log();
    log.addLog("\r\r", username + "退出了系统");
    log.closeStream();

    System.exit(0);
  }

  void xgbj_actionPerformed(ActionEvent e) {
    new xgbj();
  }

  void xjgl_actionPerformed(ActionEvent e) {

  }

  void login_actionPerformed(ActionEvent e) {
    username = JOptionPane.showInputDialog(this, "请输入用户名");
    String pwd = JOptionPane.showInputDialog(this, "请输入密码");
    if (! (username == null && pwd == null)) {

       try {//连接数据库，验证用户

          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          Connection con = DriverManager.getConnection(
              "jdbc:odbc:lee",
              "sa", "123");


          ps = con.createStatement(ResultSet.
                                   TYPE_SCROLL_INSENSITIVE,
                                   ResultSet.CONCUR_READ_ONLY);
          try {
         rs = ps.executeQuery("select * from users where username='" +
                              username + "' "); //读取数据库
         if (!rs.next())

         {
           Log log = new Log();
           log.addLog("\r\r", username + "用户试图登录系统，失败！");
           log.closeStream();

           JOptionPane.showMessageDialog(null, "不存在此用户！");
         }
         else if (! (rs.getString("pwd").trim().equals(pwd))) {

           JOptionPane.showMessageDialog(null, "密码错误！");
           Log log = new Log();
           log.addLog("\r\r", username + "用户试图登录系统，失败！");
           log.closeStream();

         }
         else {
           if (rs.getString("power").trim().equals("系统管理员")) {
             xjgl.setEnabled(true);
             bjgl.setEnabled(true);
             kcsz.setEnabled(true);
             cjgl.setEnabled(true);
             jMenuFile.setEnabled(true);
             llyh.setEnabled(true);
             adduser.setEnabled(true);
             Log log = new Log();
             log.addLog("\r\r", username + "(系统管理员)登录系统");
             log.closeStream();

           }
           else {
             cjgl.setEnabled(true);
             xjgl.setEnabled(true);
             xgcj.setEnabled(false);
             tjcj.setEnabled(false);
             xgxj.setEnabled(false);
             tjxj.setEnabled(false);
             Log log = new Log();
             log.addLog("\r\r", username + "(普通用户)登录系统");
             log.closeStream();

           }

         }
       }

       catch (SQLException sqle) {
         String error = sqle.getMessage();
         JOptionPane.showMessageDialog(null, error);
         sqle.printStackTrace();

       }

        }
        catch (Exception err) {
        //  err.getMessage();
          Log log = new Log();
          log.addLog("\r\r", "数据库连接错误！");
          log.closeStream();
          String error = err.getMessage();
          JOptionPane.showMessageDialog(null, error);

        }

      }
       }

  void tjxj_actionPerformed(ActionEvent e) {
    new tjxjxx();
    Log log = new Log();
    log.addLog("\r\r", "浏览了添加学籍模块！");
    log.closeStream();

  }

  void xgxj_actionPerformed(ActionEvent e) {
    new xgxjxx();
    Log log = new Log();
    log.addLog("\r\r", "浏览了修改学籍模块！");
    log.closeStream();

  }

  void cxxj_actionPerformed(ActionEvent e) {
    new cxxj();
    Log log = new Log();
    log.addLog("\r\r", "浏览了查询学籍模块！");
    log.closeStream();

  }

  void tjkc_actionPerformed(ActionEvent e) {
    new tjkcxx();
    Log log = new Log();
    log.addLog("\r\r", "浏览了添课程信息模块！");
    log.closeStream();

  }

  void llyh_actionPerformed(ActionEvent e) {
    new scanuser();
    Log log = new Log();
    log.addLog("\r\r", "浏览了用户模块！");
    log.closeStream();