menuclass.java~103~

本源码主要完成学生管理系统

package studentms;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.sql.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class menuClass extends JFrame {
  JPanel contentPane;
  JMenuBar mainMenu = new JMenuBar();
  JMenu menuUser=new JMenu();
  JMenu menuUserMan=new JMenu();
  JMenu menuInfo=new JMenu();
  JMenu menuGrade=new JMenu();
  JMenu menuSearchAll=new JMenu();
  JMenu menuSum=new JMenu();
  JMenu menuHelp=new JMenu();
  JMenuItem itemUserLogin=new JMenuItem();
  JMenuItem itemUserNew=new JMenuItem();
  JMenuItem itemUserModify=new JMenuItem();
  JMenuItem itemUserDel=new JMenuItem();
  JMenuItem itemShow=new JMenuItem();
  JMenuItem itemAdd=new JMenuItem();
  JMenuItem itemEdit=new JMenuItem();
  JMenuItem itemDelete=new JMenuItem();
  JMenuItem itemExit=new JMenuItem();
  JMenuItem itemShowG=new JMenuItem();
  JMenuItem itemAddG=new JMenuItem();
  JMenuItem itemEditG=new JMenuItem();
  JMenuItem itemDeleteG=new JMenuItem();
  JMenu menuOrder=new JMenu();
  JMenuItem itemByTotal=new JMenuItem();
  JMenuItem itemByChinese=new JMenuItem();
  JMenuItem itemByMath=new JMenuItem();
  JMenuItem itemByEnglish=new JMenuItem();
  JMenuItem itemByZonghe=new JMenuItem();
  JMenu menuSearch=new JMenu();
  JMenuItem itemSearchGrade=new JMenuItem();
  JMenuItem itemSearchByName=new JMenuItem();
  JMenuItem itemSearchByNum=new JMenuItem();
  JMenuItem itemSearchByClass=new JMenuItem();
  JMenuItem itemSumPeople=new JMenuItem();
  JMenuItem itemSumGrade=new JMenuItem();
  JMenuItem itemAbout=new JMenuItem();

  XYLayout xYLayout1 = new XYLayout();

  //成绩排序时使用的数据库操作
  ResultSet rs ;
  String sql =new String();
  Database DB=new Database();

  //设置不同的人员信息显示窗体，供不同窗体的查询返回结果用
  public static stuInfo SIFall = new stuInfo();
  public static editStuInfo editInfo=new editStuInfo();
  public static delStuInfo delInfo=new delStuInfo();

  //Construct the frame
  public menuClass() {
    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(xYLayout1);
    this.setSize(new Dimension(400, 300));
    this.setTitle("学生管理系统");
    menuUser.setText("系统管理");
    menuUser.setFont(new java.awt.Font("Dialog", 0, 12));
    menuUserMan.setText("用户管理");
    menuUserMan.setFont(new java.awt.Font("Dialog", 0, 12));
    menuInfo.setText("信息管理");
    menuInfo.setFont(new java.awt.Font("Dialog", 0, 12));
    menuGrade.setText("成绩管理") ;
    menuGrade.setFont(new java.awt.Font("Dialog", 0, 12));
    menuSearchAll.setText("查询");
    menuSearchAll.setFont(new java.awt.Font("Dialog", 0, 12));
    menuSearch.setText("查询人员");
    menuSearch.setFont(new java.awt.Font("Dialog", 0, 12));
    menuSum.setText("统计");
    menuSum.setFont(new java.awt.Font("Dialog", 0, 12));
    menuHelp.setText("帮助");
    menuHelp.setFont(new java.awt.Font("Dialog", 0, 12));
    itemUserLogin.setText("用户登录");
    itemUserLogin.setFont(new java.awt.Font("Dialog", 0, 12));
    itemUserLogin.addActionListener(new menuClass_itemUserLogin_ActionAdapter(this));
    itemUserNew.setText("添加用户");
    itemUserNew.addActionListener(new menuClass_itemUserNew_actionAdapter(this));
    itemUserNew.setFont(new java.awt.Font("Dialog", 0, 12));
    itemUserModify.setText("修改用户");
    itemUserModify.addActionListener(new menuClass_itemUserModify_actionAdapter(this));
    itemUserModify.setFont(new java.awt.Font("Dialog", 0, 12));
    itemUserDel.setText("删除用户");
    itemUserDel.addActionListener(new menuClass_itemUserDel_actionAdapter(this));
    itemUserDel.setFont(new java.awt.Font("Dialog", 0, 12));
    itemShow.setText("信息综合管理");
    itemShow.setFont(new java.awt.Font("Dialog", 0, 12));
    itemShow.addActionListener(new menuClass_itemShow_ActionAdapter(this));
    itemAdd.setText("添加信息");
    itemAdd.setFont(new java.awt.Font("Dialog", 0, 12));
    itemAdd.addActionListener(new menuClass_itemAdd_ActionAdapter(this));
    itemEdit.setText("修改信息");
    itemEdit.addActionListener(new menuClass_itemEdit_actionAdapter(this));
    itemEdit.setFont(new java.awt.Font("Dialog", 0, 12));
    itemDelete.setText("删除信息");
    itemDelete.addActionListener(new menuClass_itemDelete_actionAdapter(this));
    itemDelete.setFont(new java.awt.Font("Dialog", 0, 12));
    itemExit.setText("退出");
    itemExit.addActionListener(new menuClass_itemExit_ActionAdapter(this));
    itemExit.setFont(new java.awt.Font("Dialog", 0, 12));
    itemShowG.setText("成绩综合管理");
    itemShowG.setFont(new java.awt.Font("Dialog", 0, 12));
    itemShowG.addActionListener(new menuClass_itemShowG_ActionAdapter(this));
    itemAddG.setText("添加成绩");
    itemAddG.addActionListener(new menuClass_itemAddG_actionAdapter(this));
    itemAddG.setFont(new java.awt.Font("Dialog", 0, 12));
    itemEditG.setText("修改成绩");
    itemEditG.addActionListener(new menuClass_itemEditG_actionAdapter(this));
    itemEditG.setFont(new java.awt.Font("Dialog", 0, 12));
    itemDeleteG.setText("删除成绩");
    itemDeleteG.addActionListener(new menuClass_itemDeleteG_actionAdapter(this));
    itemDeleteG.setFont(new java.awt.Font("Dialog", 0, 12));
    menuOrder.setText("排序");
    menuOrder.setFont(new java.awt.Font("Dialog", 0, 12));
    itemByTotal.setText("按总成绩");
    itemByTotal.addActionListener(new menuClass_itemByTotal_actionAdapter(this));
    itemByTotal.setFont(new java.awt.Font("Dialog", 0, 12));
    itemByChinese.setText("按语文成绩");
    itemByChinese.setFont(new java.awt.Font("Dialog", 0, 12));
    itemByMath.setText("按数学成绩");
    itemByMath.addActionListener(new menuClass_itemByMath_actionAdapter(this));
    itemByMath.setFont(new java.awt.Font("Dialog", 0, 12));
    itemByEnglish.setText("按英语成绩");
    itemByEnglish.addActionListener(new menuClass_itemByEnglish_actionAdapter(this));
    itemByEnglish.setFont(new java.awt.Font("Dialog", 0, 12));
    itemByZonghe.setText("按综合成绩");
    itemByZonghe.addActionListener(new menuClass_itemByZonghe_actionAdapter(this));
    itemByZonghe.setFont(new java.awt.Font("Dialog", 0, 12));
    itemSearchByName.setText("按姓名");
    itemSearchByName.setFont(new java.awt.Font("Dialog", 0, 12));
    itemSearchByName.addActionListener(new menuClass_itemSearchByName_ActionAdapter(this));
    itemSearchByNum.setText("按学号");
    itemSearchByNum.setFont(new java.awt.Font("Dialog", 0, 12));
    itemSearchByNum.addActionListener(new menuClass_itemSearchByNum_ActionAdapter(this));
    itemSearchByClass.setText("按班级");
    itemSearchByClass.setFont(new java.awt.Font("Dialog", 0, 12));
    itemSearchByClass.addActionListener(new menuClass_itemSearchByClass_ActionAdapter(this));
    itemSearchGrade.setText("查询成绩");
    itemSearchGrade.setFont(new java.awt.Font("Dialog", 0, 12));
    itemSearchGrade.addActionListener(new menuClass_itemSearchGrade_ActionAdapter(this));
    itemSumPeople.setText("人员统计");
    itemSumPeople.addActionListener(new menuClass_itemSumPeople_actionAdapter(this));
    itemSumPeople.setFont(new java.awt.Font("Dialog", 0, 12));
    itemSumGrade.setText("成绩统计");
    itemSumGrade.addActionListener(new menuClass_itemSumGrade_actionAdapter(this));
    itemSumGrade.setFont(new java.awt.Font("Dialog", 0, 12));
    itemAbout.setText("关于");
    itemAbout.setFont(new java.awt.Font("Dialog", 0, 12));
    contentPane.setFont(new java.awt.Font("Dialog", 0, 12));
    menuUserMan.add(itemUserNew);
    menuUserMan.add(itemUserModify);
    menuUserMan.add(itemUserDel);
    menuUser.add(itemUserLogin);
    menuUser.add(menuUserMan);
    menuUser.addSeparator() ;
    menuUser.add(itemExit);
    menuInfo.add(itemShow);
    menuInfo.addSeparator();
    menuInfo.add(itemAdd);
    menuInfo.add(itemEdit);
    menuInfo.add(itemDelete);
    menuGrade.add(itemShowG);
  //  menuGrade.addSeparator() ;
    menuGrade.add(itemAddG);
   // menuGrade.add(itemEditG);
   // menuGrade.add(itemDeleteG);
    menuGrade.addSeparator() ;
    menuGrade.add(menuOrder);
    menuOrder.add(itemByTotal);
    menuOrder.add(itemByChinese);
    menuOrder.add(itemByMath);
    menuOrder.add(itemByEnglish);
    menuOrder.add(itemByZonghe);
    menuSearchAll.add(menuSearch);
    menuSearchAll.add(itemSearchGrade);
    menuSearch.add(itemSearchByName);
    menuSearch.add(itemSearchByNum);
    menuSearch.add(itemSearchByClass);
    menuSum.add(itemSumPeople);
    menuSum.add(itemSumGrade);
    menuHelp.add(itemAbout);
    mainMenu.add(menuUser);
    mainMenu.add(menuInfo);
    mainMenu.add(menuGrade);
    mainMenu.add(menuSearchAll);
    mainMenu.add(menuSum);
    mainMenu.add(menuHelp);
    this.setJMenuBar(mainMenu);
    itemByChinese.addActionListener(new menuClass_itemByChinese_actionAdapter(this));

  }
  protected void processWindowEvent(WindowEvent e) {
      super.processWindowEvent(e);
      if (e.getID() == WindowEvent.WINDOW_CLOSING) {
        System.exit(0);
      }
    }

  //用户登录
    void itemUserLogin_actionPerformed(ActionEvent e){
         Login login =new Login();
         Dimension dlgSize = login.getPreferredSize();
         Dimension frmSize = getSize();
         Point loc = getLocation();
         login.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
         login.pack();
         login.show();
    }


  //添加人员信息
  void itemAdd_actionPerformed(ActionEvent e) {
    addStuInfo dlg = new addStuInfo();
    Dimension dlgSize = dlg.getPreferredSize();
    Dimension frmSize = getSize();
    Point loc = getLocation();
    dlg.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
    dlg.pack();
    dlg.show();
    dlg.setExeType("addnew");
  }

  //显示人员信息综合管理
   void itemShow_actionPerformed(ActionEvent e){
       SIFall.setLocation(200, 160);
       SIFall.pack();
       SIFall.show();
       SIFall.setNull();
       SIFall.setAbled(false);
       SIFall.setButton(true,false,false,false,false) ;
   }

   //显示成绩综合管理
   void itemShowG_actionPerformed(ActionEvent e){
       gradeInfo dlgt = new gradeInfo();
       Dimension dlgSize = dlgt.getPreferredSize();
       Dimension frmSize = getSize();
       Point loc = getLocation();
       dlgt.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
       dlgt.pack();
       dlgt.show();
       dlgt.setAbled(false);
       dlgt.setButton(true,false,false,false,false) ;
   }

   //显示按姓名查询
   void itemSearchByName_actionPerformed(ActionEvent e){
       class searchByName extends search{
           public searchByName(){
               jRByName.setVisible(false);
               jRByNum.setVisible(false);
               jRByClass.setVisible(false);
               xYLayout1.setHeight(110);
           }
       }
       searchByName byName=new searchByName();
       Dimension dlgSize = byName.getPreferredSize();
       Dimension frmSize = getSize();
       Point loc = getLocation();
       byName.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
       byName.pack() ;
       byName.setLabelText("请输入要查询人员的姓名：");
       byName.setType("Name");
       byName.show() ;
   }

   //显示按学号查询
   void itemSearchByNum_actionPerformed(ActionEvent e){
      class searchByNum extends search{
         public searchByNum(){
             jRByName.setVisible(false);
             jRByNum.setVisible(false);
             jRByClass.setVisible(false);
             xYLayout1.setHeight(110);
         }
      }
       searchByNum byNum=new searchByNum();
       Dimension dlgSize = byNum.getPreferredSize();
       Dimension frmSize = getSize();
       Point loc = getLocation();
       byNum.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
       byNum.pack() ;
       byNum.setLabelText("请输入要查询人员的学号：");
       byNum.setType("Num");
       byNum.show() ;
   }

   //显示按班级查询
   void itemSearchByClass_actionPerformed(ActionEvent e){
      class searchByClass extends search{
       public searchByClass(){
           jRByName.setVisible(false);
           jRByNum.setVisible(false);
           jRByClass.setVisible(false);
           xYLayout1.setHeight(110);
       }
      }
     searchByClass byClass=new searchByClass();
       Dimension dlgSize = byClass.getPreferredSize();
       Dimension frmSize = getSize();
       Point loc = getLocation();
       byClass.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
       byClass.pack() ;
       byClass.setLabelText("请输入要查询人员的班级：");
       byClass.setType("Class");
       byClass.show() ;
   }

   //查询成绩
   void itemSearchGrade_actionPerformed(ActionEvent e){
       searchGrade seaGrade=new searchGrade();
       Dimension dlgSize = seaGrade.getPreferredSize();
       Dimension frmSize = getSize();
       Point loc = getLocation();
       seaGrade.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
       seaGrade.pack() ;
       seaGrade.show() ;
   }


  //退出
   void itemExit_actionPerformed(ActionEvent e){
     System.exit(0);
   }

 //添加用户
  void itemUserNew_actionPerformed(ActionEvent e) {
    userAdd add =new userAdd();
    Dimension dlgSize = add.getPreferredSize();
    Dimension frmSize = getSize();
    Point loc = getLocation();
    add.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
    add.pack() ;
    add.show() ;
  }

  //修改用户
  void itemUserModify_actionPerformed(ActionEvent e) {
     userModify edit =new userModify();
     Dimension dlgSize = edit.getPreferredSize();
     Dimension frmSize = getSize();
     Point loc = getLocation();
     edit.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
     edit.pack() ;
     edit.show() ;

  }

  //删除用户
  void itemUserDel_actionPerformed(ActionEvent e) {
         userDel del =new userDel();
         Dimension dlgSize = del.getPreferredSize();
         Dimension frmSize = getSize();