mainframe.java~267~

这是一个用jbuilder2005编写的图书管理系统

    jMenuSM.add(jMenuUserManage);
    jMenuSM.add(jMenuItemIndividual);
    jMenuSM.addSeparator();
    jMenuSM.add(jMenuItemExit);
    jMenuBCO.add(jMenuItemBCInfo);
    jMenuBCO.addSeparator();
    jMenuBCO.add(jMenuItemTBC);
    jMenuBCO.add(jMenuItemLBC);
    jMenuBRO.add(jMenuItemBCheck);
    jMenuBRO.add(jMenuItemRCheck);
    jMenuBRO.add(jMenuItemPay);
    jMenuBRO.add(jMenuItemRenew);
    jMenuSTM.add(jMenuItemStockInfo);
    jMenuSTM.addSeparator();
    jMenuSTM.add(jMenuItemAddBook);
    jMenuSTM.add(jMenuItemDeleteBook);
    jMenuUserManage.add(jMenuItemAddAdm);
    jMenuUserManage.add(jMenuItemDeleteAdm);
    jPanelBottom.add(jPanelFDAdm, "jPanelFDAdm");
    jPanelFDAdm.add(jPanel1, java.awt.BorderLayout.SOUTH);
    jPanel1.add(jButtonFDDelete);
    jPanel1.add(jButtonFDCancel);
    jPanelFDAdm.add(jScrollPane1, java.awt.BorderLayout.CENTER);
    jScrollPane1.getViewport().add(jTableFDAdm);
    jPanelBCInfo.add(jTabbedPaneBC, java.awt.BorderLayout.CENTER);
    jTabbedPaneBC.add(jScrollPane2, "个人详细信息");
    jTabbedPaneBC.add(jScrollPane3, "已借书本");
    jScrollPane3.getViewport().add(jTableBorrowBook);
    jScrollPane2.getViewport().add(jTableBC);
    jPanel3.add(jLabel1);
    jPanel3.add(jTextFieldFindXuehao);
    jPanel3.add(jButtonFindAlert);
    jPanel3.add(jButtonBCCancel);
    jPanelBCInfo.add(jPanel3, java.awt.BorderLayout.NORTH);
    jPaneBackgroud.add(jLabelBottom, java.awt.BorderLayout.CENTER);
    this.getContentPane().add(jPanelBottom, java.awt.BorderLayout.CENTER);
    jMenuDateInOut.add(jMenuItemBiYeSheng);
    jMenuDateInOut.add(jMenuItemInsertBooks);
    this.addWindowListener(new Win());


    //IPAdress.setBounds(200,200,400,210);
    //IPAdress.setVisible(true);
  }

  /**
   * 事件驱动程序
   *
   * @param e ActionEvent 传入一个事件参数
   */
  public void jMenuItemAbout_actionPerformed(ActionEvent e) {
    FrameAbout dlg = new FrameAbout(this);
    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.setModal(true);
    dlg.pack();
    dlg.setVisible(true);

  }


  /**
   * 退出程序
   *
   * @param e ActionEvent 传入一个事件参数
   */
  public void jMenuItemExit_actionPerformed(ActionEvent e) {
    String option[]={"确定","取消"};
    int answer;
      answer=JOptionPane.showOptionDialog(this,"           你确定要退出系统吗？",
      "QUESTION MESSAGE",
      JOptionPane.PLAIN_MESSAGE,JOptionPane.DEFAULT_OPTION,null,option,option[0]);
      if(answer==0){
        System.exit(0);
      }
  }

  /**
   * 事件处理函数，处理按下子菜单“系统登录”或“注销”时产生的事件
   *
   * @param e ActionEvent 传入一个事件参数
   */
  public void jMenuItemEnter_actionPerformed(ActionEvent e) {
    if(jMenuItemEnter.getText().equals("系统登录")){//如果菜单原本是“系统登录”，则显示登录窗口
      Enter enter=new Enter();
      //jButtonFDDelete.setEnabled(false);
      enter.setBounds(300,160,350,240);
      enter.setVisible(true);
    }
    else{//否则，注销，重新设置下列组件为不可用
      String option[]={"确定","取消"};
      int answer;
      answer=JOptionPane.showOptionDialog(this,"           你确定要注销吗？",
      "QUESTION MESSAGE",
      JOptionPane.PLAIN_MESSAGE,JOptionPane.DEFAULT_OPTION,null,option,option[0]);
      if(answer==0){
        jMenuItemIndividual.setEnabled(false);
        jMenuItemBCInfo.setEnabled(false);
        jMenuItemTBC.setEnabled(false);
        jMenuItemLBC.setEnabled(false);
        jMenuItemBCheck.setEnabled(false);
        jMenuItemRCheck.setEnabled(false);
        jMenuItemAddBook.setEnabled(false);
        jMenuItemDeleteBook.setEnabled(false);
        jMenuItemAddAdm.setEnabled(false);
        jMenuItemDeleteAdm.setEnabled(false);
        jMenuUserManage.setEnabled(false);
        jButtonFDDelete.setEnabled(false);
        jMenuItemBiYeSheng.setEnabled(false);
        jMenuItemInsertBooks.setEnabled(false);
        jMenuItemRenew.setEnabled(false);
        jMenuItemPay.setEnabled(false);
        jMenuItemEnter.setText("系统登录");//重新设置菜单为“登录”
        cardLayout1.show(jPanelBottom,"jPaneBackgroud");// 重新设置面板为jPaneBackgroud
      }

    }

  }

  /**
   * 事件处理函数，处理按下子菜单“管理员信息”时产生的事件
   *
   * @param e ActionEvent 传入一个事件参数
   */
  public void jMenuItemAdInfo_actionPerformed(ActionEvent e) {
    cardLayout1.show(jPanelBottom,"jPanelADInfo");//设置面板为jPanelADInfo
  }

  /**
   * 事件处理函数，处理按下子菜单“借书卡信息”时产生的事件
   *
   * @param e ActionEvent 传入一个事件参数
   *
   */
  public void jMenuItemBCInfo_actionPerformed(ActionEvent e) {
    cardLayout1.show(jPanelBottom,"jPanelBCInfo");//设置面板为jPanelBCInfo
  }

  /**
   * 显示管理员密码修改对话框
   * @param e ActionEvent
   */
  public void jMenuItemIndividual_actionPerformed(ActionEvent e) {
    PasswordChange pc=new PasswordChange(MainFrame.this,"管理员密码修改",true);
    pc.setLocation(220,170);
    pc.setSize(300,300);
    pc.setVisible(true);
  }

  /**
   * 显示增加管理员对话框
   * @param e ActionEvent
   */
  public void jMenuItemAddAdm_actionPerformed(ActionEvent e) {
    AdmAdd add=new AdmAdd(this,"增加管理员",true);
    add.setLocation(250,150);
    add.setSize(300,400);
    add.setVisible(true);
  }

  /**
   * 显示查看/删除管理员对话框,并且可以删除一个管理员
   * @param e ActionEvent
   */
  public void jMenuItemDeleteAdm_actionPerformed(ActionEvent e) {
    strSql="select * from administrator where power='管理员'";
    rs = db.getResult(strSql);//获得记录集
    String title[]=new String[6];
    title[0]="id";title[1]="password";title[2]="name";title[3]="power";
    title[4]="worktime";title[5]="telephone";//表的标题
    model=new DefaultTableModel(title,0);
    jTableFDAdm.setModel(model);
    selectionModeFD=jTableFDAdm.getSelectionModel();
    selectionModeFD.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);

    String[] record=new String[6];
    boolean isexist = false;
    try {
      isexist = rs.first();
    }
    catch (SQLException ex1) {
      JOptionPane.showMessageDialog(this,"ex1.toString() " +ex1.toString() );
    }
    if(!isexist){
      JOptionPane.showMessageDialog(this, "除了自己是超级管理员之外，没有其他一般管理员");
      return;
    }
    try {
      rs.beforeFirst();
      while (rs.next()) {//获取数据库的记录
        record[0]=rs.getString("id").trim();
        record[1]=rs.getString("password").trim();
        record[2]=rs.getString("name").trim();
        record[3]=rs.getString("power").trim();
        record[4]=rs.getString("worktime");
        if(record[4]==null){
          record[4]="";
        }
        else record[4]=record[4].trim();
        record[5]=rs.getString("telephone");
        if(record[5]==null){
          record[5]="";
        }
        else record[5]=record[5].trim();
        model.addRow(record);//加入到表中
      }
    }
    catch (SQLException ex) {
      JOptionPane.showMessageDialog(null, "ex.toString() :" + ex.toString());
    }
    db.close();
   //try{
   selectionModeFD.addListSelectionListener(new ListSelectionListener() {
       public void valueChanged(ListSelectionEvent e) {
         if(!type.equals("管理员")){
           jButtonFDDelete.setEnabled(true);
         }
         rowSel = jTableFDAdm.getSelectedRow();
         if(rowSel!=-1){
           strFD = (String) jTableFDAdm.getValueAt(rowSel, 0);
         }
       }
     });
    cardLayout1.show(jPanelBottom,"jPanelFDAdm");
  }

  public void jButtonFDCancel_actionPerformed(ActionEvent e) {
    cardLayout1.show(jPanelBottom,"jPaneBackgroud");// 重新设置面板为jPaneBackgroud
  }

  /**
   * 删除管理员,并且删除选中的表格
   * @param e ActionEvent
   */
  public void jButtonFDDelete_actionPerformed(ActionEvent e){
    strSql = "delete from administrator where id='" + strFD + "'";
    //由数据库操作对象执行数据库操作，并返回操作成功失败的提示信息
    if (db.executeSql(strSql)) {
      model.removeRow(rowSel);
      rowSel=-1;
      jTableFDAdm.revalidate();
      JOptionPane.showMessageDialog(null, "成功删除！");
      jButtonFDDelete.setEnabled(false);
    }
    else {
      JOptionPane.showMessageDialog(null, " 删除失败，请重新操作！");
    }
    db.close();
  }

  public void jMenuItemTBC_actionPerformed(ActionEvent e) {
    AddReader Ad=new AddReader(this,"增加读者",true);
    Ad.setBounds(260,150,310,410);
    Ad.setVisible(true);
  }

  public void jButtonFindAlert_actionPerformed(ActionEvent e) {
    String fXuehao=jTextFieldFindXuehao.getText().trim();
    //System.out.println(fXuehao.length());
    strSql="select * from buser where xuehao='"+fXuehao+"'";
    rs = db.getResult(strSql);//获得记录集

    String title[]=new String[11];
    title[0]="学号";title[1]="姓名";title[2]="类型";title[3]="性别";
    title[4]="电话";title[5]="学院";title[6]="专业";
    title[7]="年级";title[8]="已借书数";title[9]="罚款";title[10]="挂失";//表的标题
    modelBC=new DefaultTableModel(title,0);
    jTableBC.setModel(modelBC);
    String[] record=new String[11];
    boolean isexist = false;
    try {
      isexist = rs.first();
    }
    catch (Exception ex1) {
      JOptionPane.showMessageDialog(this,"ex1.toString() " +ex1.toString() );
    }
    if(!isexist){
      JOptionPane.showMessageDialog(this, "没有这个人的信息，请重新输入正确的有效证件号");
      return;
    }
    try {
      rs.beforeFirst();
      while (rs.next()) {//获取数据库的记录
        record[0]=rs.getString("xuehao").trim();
        record[1]=rs.getString("name").trim();
        record[2]=rs.getString("type").trim();
        record[3]=rs.getString("sex").trim();
        record[4]=rs.getString("telephone");
        record[5]=rs.getString("institute");
        record[6]=rs.getString("specialty");
        record[7]=rs.getString("grade");
        record[8]=String.valueOf(rs.getInt("bookNumOfBorrow"));
        record[9]=String.valueOf(rs.getInt("penalty"));
        int guashi=rs.getInt("hangUp");
        if(guashi==0){
          record[10]="没有";
        }
        else{
          record[10]="有";
        }
        modelBC.addRow(record);//加入到表中
      }
    }
    catch (SQLException ex) {
      JOptionPane.showMessageDialog(this, "ex.toString() :" + ex.toString());
    }
    db.close();
    String []title1={"书名","馆藏","ISBN","作者","出版日期","借书时间","应还书时间","超期天数"};
    modelBorrowBook=new DefaultTableModel(title1,0);
    jTableBorrowBook.setModel(modelBorrowBook);
    strSql="select name,bookAdress,ISBN,bookAuthor,pubDate,lendDate,returnDate, DATEDIFF(day,returnDate,getDate()) as 'chaoqi' from bookInfo_VIEW where xuehao='"+fXuehao+"'";
    rs = db.getResult(strSql);//获得记录集
    String []record1=new String[8];
    try {
      rs.beforeFirst();
      while (rs.next()) {//获取数据库的记录
        record1[0]=rs.getString("name").trim();
        record1[1]=rs.getString("bookAdress").trim();
        record1[2]=rs.getString("ISBN").trim();
        record1[3]=rs.getString("bookAuthor").trim();
        record1[4]=rs.getDate("pubDate").toString();
        record1[5]=rs.getDate("lendDate").toString();
        record1[6]=rs.getDate("returnDate").toString();
        record1[7]=String.valueOf(rs.getInt("chaoqi"));
        modelBorrowBook.addRow(record1);//加入到表中
     }
   }
   catch (SQLException ex) {