dailypperationmagezinsystempanel.java

图书管理系统源代码,05年某人写的,还算不错

                jTxReaderNumD.setText(bianhao);
                jTxReaderNumG.setText(bianhao);
                jTxReaderNumX.setText(bianhao);
                jTxreaderNum.setText(bianhao);
                borrowBooksNum();
            }
        }
     }

     public void jTxreaderNum_mouseClicked(MouseEvent e) {
         inputReaderNum();
     }

     public void jTxReaderNumX_mouseClicked(MouseEvent e) {
         inputReaderNum();
     }

     public void jTxReaderNumD_mouseClicked(MouseEvent e) {
         inputReaderNum();
     }

     public void btnQueren_actionPerformed(ActionEvent e) {
         borrowBooks();
     }
     //借书方法
     public void borrowBooks()
     {
         String booksNum = jTxbookNum.getText().trim();
         String readerNum = jTxreaderNum.getText().trim();

         if(booksNum.trim().equals(""))
             JOptionPane.showMessageDialog(null,"期刊信息不能为空");
         else if(readerNum.trim().equals(""))
             JOptionPane.showMessageDialog(null,"读者信息不能为空");
         else if(!isReader)
              JOptionPane.showMessageDialog(null,"此读者不存在，请核对借阅证！！！","错误",JOptionPane.ERROR_MESSAGE);
         else if(readerNumTempMax > readerNumTemp)

         {
             String sqlbook =
                     "update magazineInfo set number=number-1 where magazineNumber='" +
                     booksNum + "' and number > 0";
             String sqlreader =
                            "update readerInfo set state = 1,borrowBooksNum = borrowBooksNum+1 where readerID='" +readerNum + "' and zhuangtai=1" ;

             if (db.add(sqlbook)) {
                 db.myClose(1);
                 if(db.add(sqlreader)){
                     db.myClose(1);
                     String sql =
                             "insert into magazineBorrowInfo (magazineID,readerId,beginTime,borrowHandlers) values ('" +
                             booksNum + "','" + readerNum + "','" +SystemFrame1.dateTime + "','"+SystemFrame1.login+"')";
                     if (db.add(sql)) {
                         JOptionPane.showMessageDialog(null, "借书成功");
                         borrowBooksNum();
                         display();
                     } else {
                         JOptionPane.showMessageDialog(null, "借书失败", "失败",
                                 JOptionPane.ERROR_MESSAGE);
                     }
                     db.myClose(1);
                 }


             }
             else
                 JOptionPane.showMessageDialog(null, "此本期刊已经全部借出\n借阅失败","失败",JOptionPane.ERROR_MESSAGE);
         }else
             JOptionPane.showMessageDialog(null, "你的借书数量已经达到上限，请先归还","警告",JOptionPane.WARNING_MESSAGE);

     }

     //还书方法
     public void returnBooks()
     {
         String booksNum = jTxbookNumG.getText().trim();
         String readerNum = jTxReaderNumG.getText().trim();

         if(booksNum.trim().equals(""))
             JOptionPane.showMessageDialog(null,"期刊信息不能为空");
         else if(readerNum.trim().equals(""))
             JOptionPane.showMessageDialog(null,"读者信息不能为空");
         else if(!isReader)
              JOptionPane.showMessageDialog(null,"此读者不存在，请核对借阅证！！！","错误",JOptionPane.ERROR_MESSAGE);
         else if( readerNumTemp>0)

         {
             String sqlbook =
                     "update magazineInfo set number=number+1 where magazineNumber='" +
                     booksNum + "'";
             String sqlreader ="update readerInfo set borrowBooksNum = borrowBooksNum-1 where readerID='" +readerNum + "'" ;
             String sqlreader2 ="update readerInfo set state = 0 where readerID='" +readerNum + "'and borrowBooksNum=0" ;

             if (db.add(sqlbook)) {
                 db.myClose(1);
                 if(db.add(sqlreader)){
                     db.myClose(1);
                     String sql =
                             "update magazineBorrowInfo set returnTime='"+SystemFrame1.dateTime+"',returnHandlers='"+SystemFrame1.login+"' ,isreturnmagazine = '是' where magazineID='"+booksNum+"'";
                     if (db.add(sql)) {
                         db.myClose(1);
                         db.add(sqlreader2);
                         db.myClose(1);
                         JOptionPane.showMessageDialog(null, "还书成功");
                         borrowBooksNum();
                         display();
                     } else {
                         JOptionPane.showMessageDialog(null, "还书失败", "失败",
                                 JOptionPane.ERROR_MESSAGE);
                     }

                 }


             }

         }else
             JOptionPane.showMessageDialog(null, "你已经归还全部的图书","警告",JOptionPane.WARNING_MESSAGE);

     }

     public void jTxNumberX_mouseClicked(MouseEvent e) {
         borrowBooksNum();
     }

     //点击查询读者的借书数量
     public void borrowBooksNum()
     {
         String bianhao= jTxreaderNum.getText().trim();
         String num = "";
         String readerTypeNameTemp = "";

         if((int)bianhao.charAt(0)>='A' && (int)bianhao.charAt(0) <= 'Z' )
         {
             Dbcom readerDB = new Dbcom();
             ResultSet rs = null;
             //查询读者的借书数量
             String sql = "select borrowBooksNum,readerTypeName from readerInfo where readerID='"+bianhao+"'";
             rs = readerDB.search(sql);
             try {
                 if(rs.next()){
                     num = rs.getString(1);
                     if (num == null)
                         num = "0";
                     readerTypeNameTemp = rs.getString(2);
                     jTxNumberD.setText(num);
                     jTxNumberG.setText(num);
                     jTxNumberX.setText(num);
                     jTxNumber.setText(num);
                     readerNumTemp = Integer.parseInt(num);
                     isReader = true;
                 }
                 else
                     JOptionPane.showMessageDialog(null,"此读者不存在，请核对借阅证！！！","错误",JOptionPane.ERROR_MESSAGE);
                 readerDB.myClose(1);
             } catch (SQLException ex) {
                 System.out.println(ex.toString());
             }
             if(isReader){
                 String sql1 =
                         "select booksQuantity from readerType where typeName='" +
                         readerTypeNameTemp + "'";
                 rs = readerDB.search(sql1);
                 try {
                     if (rs.next()) {
                         readerNumTempMax = rs.getInt(1);
                         if (readerNumTempMax == readerNumTemp)
                             JOptionPane.showMessageDialog(null,
                                     "你的借书数量已经达到上限，请先归还", "警告",
                                     JOptionPane.WARNING_MESSAGE);
                     }
                     readerDB.myClose(1);
                 } catch (SQLException ex) {
                     System.out.println(ex.toString());
                 }
             }
         }
         else
         JOptionPane.showMessageDialog(null,"读者编号没有输入","信息不完整",JOptionPane.ERROR_MESSAGE);
     }

     public void jTxNumberG_mouseClicked(MouseEvent e) {
         borrowBooksNum();
     }

     public void jTxpurchaseMoneyD_mouseClicked(MouseEvent e) {
         borrowBooksNum();
     }

     public void btnReturnBooks_actionPerformed(ActionEvent e) {
         returnBooks();
     }

     public void jTpRightBottom_mouseClicked(MouseEvent e) {

             int index = jTpRightBottom.getTabCount();
            for(int i=0;i<jTpRightBottom.getTabCount();i++)
            {
                if(i== jTpRightBottom.getSelectedIndex()){
                    jTpRightBottom.setBackgroundAt(i,null );
                   //  jTpRightBottom.getComponent(jTpRightBottom.getSelectedIndex()).setBackground(null);
                }
                else
                    jTpRightBottom.setBackgroundAt( i,Color.LIGHT_GRAY );
            }

            // jTpRightBottom.getSelectedIndex();

            // jTpRightBottom.setBackgroundAt( jTpRightBottom.getSelectedIndex(),Color.blue );


     }

    public void jButton1_actionPerformed(ActionEvent e) {

    }

    public void jButton6_actionPerformed(ActionEvent e) {

    }

    public void jButton5_actionPerformed(ActionEvent e) {

    }

    public void jTxNumberD_mouseClicked(MouseEvent e) {

    }

    public void BtnQuerenD_actionPerformed(ActionEvent e) {

    }

    public void btnRsectD_actionPerformed(ActionEvent e) {

    }

}


class DailyPperationMagezinSystemPanel_jTabRightTop_mouseAdapter extends
        MouseAdapter {
    private DailyPperationMagezinSystemPanel adaptee;
    DailyPperationMagezinSystemPanel_jTabRightTop_mouseAdapter(
            DailyPperationMagezinSystemPanel adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jTabRightTop_mouseClicked(e);
    }
}


class DailyPperationMagezinSystemPanel_btnRsectD_actionAdapter implements
        ActionListener {
    private DailyPperationMagezinSystemPanel adaptee;
    DailyPperationMagezinSystemPanel_btnRsectD_actionAdapter(
            DailyPperationMagezinSystemPanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnRsectD_actionPerformed(e);
    }
}


class DailyPperationMagezinSystemPanel_jTreBooks_mouseAdapter extends
        MouseAdapter {
    private DailyPperationMagezinSystemPanel adaptee;
    DailyPperationMagezinSystemPanel_jTreBooks_mouseAdapter(
            DailyPperationMagezinSystemPanel adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jTreBooks_mouseClicked(e);
    }
}


class DailyPperationMagezinSystemPanel_BtnQuerenD_actionAdapter implements
        ActionListener {
    private DailyPperationMagezinSystemPanel adaptee;
    DailyPperationMagezinSystemPanel_BtnQuerenD_actionAdapter(
            DailyPperationMagezinSystemPanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.BtnQuerenD_actionPerformed(e);
    }
}


class DailyPperationMagezinSystemPanel_jTxNumberD_mouseAdapter extends
        MouseAdapter {
    private DailyPperationMagezinSystemPanel adaptee;
    DailyPperationMagezinSystemPanel_jTxNumberD_mouseAdapter(
            DailyPperationMagezinSystemPanel adaptee) {
        this.adaptee = adaptee;
    }