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 menuSystem=new JMenu();  JMenuItem itemExit=new JMenuItem();  JMenu menuInfo=new JMenu();  JMenuItem itemShow=new JMenuItem();  JMenuItem itemAdd=new JMenuItem();  JMenuItem itemEdit=new JMenuItem();  JMenuItem itemDelete=new JMenuItem();  JMenu menuGrade=new JMenu();  JMenuItem itemShowG=new JMenuItem();  JMenuItem itemAddG=new JMenuItem();  JMenu menuOrder=new JMenu();  JMenuItem itemByTotal=new JMenuItem();  JMenuItem itemByChinese=new JMenuItem();  JMenuItem itemByMath=new JMenuItem();  JMenuItem itemByEnglish=new JMenuItem();  JMenuItem itemByComposite=new JMenuItem();  JMenuItem itemEditG=new JMenuItem();  JMenuItem itemDeleteG=new JMenuItem();  JMenu menuSearchAll=new JMenu();  JMenu menuSearch=new JMenu();  JMenuItem itemSearchByName=new JMenuItem();  JMenuItem itemSearchByNum=new JMenuItem();  JMenuItem itemSearchByClass=new JMenuItem();  JMenuItem itemSearchGrade=new JMenuItem();  JMenu menuSum=new JMenu();  JMenuItem itemSumPeople=new JMenuItem();  JMenuItem itemSumGrade=new JMenuItem();  JMenu menuHelp=new JMenu();  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();  public static gradeInfo graInfo=new gradeInfo();  //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("學生管理系統");    menuSystem.setText("系統管理");    menuSystem.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));    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));    itemByChinese.addActionListener(new menuClass_itemByChinese_actionAdapter(this));    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));    itemByComposite.setText("按綜合成績");    itemByComposite.addActionListener(new menuClass_itemByComposite_actionAdapter(this));    itemByComposite.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)); //   menuUser.addSeparator() ;    menuSystem.add(itemExit);    menuInfo.add(itemShow);    menuInfo.addSeparator();    menuInfo.add(itemAdd);    menuInfo.add(itemEdit);    menuInfo.add(itemDelete);    menuGrade.add(itemShowG);    menuGrade.add(itemAddG);    menuGrade.addSeparator() ;    menuGrade.add(menuOrder);    menuOrder.add(itemByTotal);    menuOrder.add(itemByChinese);    menuOrder.add(itemByMath);    menuOrder.add(itemByEnglish);    menuOrder.add(itemByComposite);    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(menuSystem);    mainMenu.add(menuInfo);    mainMenu.add(menuGrade);    mainMenu.add(menuSearchAll);    mainMenu.add(menuSum);    mainMenu.add(menuHelp);    this.setJMenuBar(mainMenu);  }  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){       graInfo.setLocation(200, 160);       graInfo.pack();       graInfo.show();       graInfo.setAbled(false);       graInfo.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() ;  }