mainframe.java

java+SQLServer2005编写的学生学籍管理系统

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 java.io.*;

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();
    JMenuItem deleteuser = 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();
    JMenu jMenu1 = new JMenu();

    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));
         deleteuser.setFont(new java.awt.Font("Dialog", 0, 15));/////////////////////////////////////////////////////////////
         deleteuser.setText("删除用户");
         deleteuser.addActionListener(new mainFrame_deleteuser_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));
         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));
         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));
         jMenuFile.add(login);
         jMenuFile.add(llyh);
         jMenuFile.add(jMenuItem1);
         jMenuFile.add(adduser);
         jMenuFile.add(deleteuser);///////////////////////////////////////////////////////////////////
         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);
         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);
         this.setJMenuBar(jMenuBar1);
         xjgl.setEnabled(false);
         bjgl.setEnabled(false);
         kcsz.setEnabled(false);
         cjgl.setEnabled(false);
         jMenuFile.setEnabled(true);
         llyh.setEnabled(false);
         adduser.setEnabled(false);
         deleteuser.setEnabled(false);////////////////////////////////////////
         this.setBounds(100, 100, 800, 600);
         this.setVisible(true);
    }

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


    public void jMenuFileExit_actionPerformed(ActionEvent e) {
        System.exit(0);
     }

    //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();
    }
    
    void deleteuser_actionPerformed(ActionEvent e) {///////////////////////////////////////////////
        new deleteuser();
    }
    
    void xgmm_actionPerformed(ActionEvent e) {
        new xiugaimima();
    }

     void tjbj_actionPerformed(ActionEvent e) {
        new addxj();
     }

     void exit_actionPerformed(ActionEvent e) {
         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 {//连接数据库，验证用户
                String name = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
                String url ="jdbc:sqlserver://localhost:1433; DatabaseName=student";               
                Class.forName(name);
                Connection con = DriverManager.getConnection(url, "ss", "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()){        
                        JOptionPane.showMessageDialog(null, "不存在此用户！");
                     }
                     else if (! (rs.getString("pwd").trim().equals(pwd))) {
                     JOptionPane.showMessageDialog(null, "密码错误！");
                 }
                 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);
                         deleteuser.setEnabled(true);
                     }
                     else {
                         cjgl.setEnabled(true);
                         xjgl.setEnabled(true);
                         xgcj.setEnabled(false);
                         tjcj.setEnabled(false);
                         xgxj.setEnabled(false);
                         tjxj.setEnabled(false);
                      }