borrow.java~58~

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

     }
     db.close();

  }

  public void jButtonBorrow_actionPerformed(ActionEvent e) {
    String isbn="";
    int tag;
    isbn=jTextFieldBorrowISBN.getText().trim();
    if(isbn.equals("")){
      JOptionPane.showMessageDialog(this, " ISBN号不能为空");
      return;
    }
    if(jTextFieldtag.getText().trim().equals("")){
      JOptionPane.showMessageDialog(this, " tag值不能为空!");
      return;
    }
    if(bcq){
      JOptionPane.showMessageDialog(this, " 此读者有"+bookNumOfChaoqi+"本书超期，必须还掉才能再借");
      return;
    }
    tag=Integer.parseInt(jTextFieldtag.getText().trim());
    strSQL="select * from bookADS where ISBN='"+isbn+"' and tag='"+tag+"'";
    rs = db.getResult(strSQL);
    boolean isexist = false;
    try {
      isexist = rs.first();
    }
    catch (SQLException ex1) {
    }
    if(!isexist){
      JOptionPane.showMessageDialog(this, " 没有这本书！");
      return;
    }
    try{
      rs.next();
      String kejie=rs.getString("isBorrow");
      if(!kejie.equals("可借")){
        JOptionPane.showMessageDialog(this, " 这本书已经借出！");
      }
    }catch(SQLException ee){

    }




    strSQL="select * from buser where xuehao='"+xh+"'";
    rs=db.getResult(strSQL);
    try{
      rs.next();
      int hangup=rs.getInt("hangUp");
      float penalty=rs.getFloat("penalty");
      //System.out.println(""+penalty);
      int bookNumOfBorrow=rs.getInt("bookNumOfBorrow");
      String ttype=rs.getString("type").trim();
     // System.out.println(ttype);
      db.close();
      if(hangup!=1){
        if(penalty<-10.0){
          JOptionPane.showMessageDialog(this, " 此读者已欠款超过10元，不能借书，需还清欠款后才能再借!");
          return;
        }

        else{
          strSQL="select * from bookNum where type='"+ttype+"'";
          rs=db.getResult(strSQL);
          rs.next();
          int num=rs.getInt("bookNum");
          if(bookNumOfBorrow>=num){
            JOptionPane.showMessageDialog(this, " 此读者已经借了"+num+"，不能再借书!");
            return;
          }
          else{
            strSQL=" exec Pro_BorrowBook '"+xh+"','"+isbn+"',"+tag+"";
            if (db.executeSql(strSQL)) {
              JOptionPane.showMessageDialog(this, " 借书成功！");
            }
            else{
              JOptionPane.showMessageDialog(this, "借书失败！请重新操作");
               //db.conn.rollback();
              return;
            }

          }
        }
      }
      else {
        JOptionPane.showMessageDialog(this, " 此读者已经挂失，不能借书!");
        return;
      }

    }catch(SQLException ee){
      ee.printStackTrace();
    }
    String titles1[]={"书名","ISBN","索引号","借书日期","还书日期","超期天数"};
     model=new DefaultTableModel(titles1,0);
     jTable1.setModel(model);
     strSQL="select ISBN,name,bookAdress,lendDate,returnDate, DATEDIFF(day,returnDate,getDate()) as 'chaoqi' from bookInfo_VIEW where xuehao='"+xh+"'";
     String [] record1=new String[6];
     rs = db.getResult(strSQL);
     bcq=false;
     bookNumOfChaoqi=0;
     try{
       while(rs.next()){
         record1[0]=rs.getString("name").trim();
         record1[1]=rs.getString("ISBN").trim();
         record1[2]=rs.getString("bookAdress").trim();
         record1[3]=rs.getDate("lendDate").toString().trim();
         record1[4]=rs.getDate("returnDate").toString().trim();
         record1[5]=String.valueOf(rs.getInt("chaoqi"));
         if(rs.getInt("chaoqi")>0){
           bcq=true;
           bookNumOfChaoqi++;
         }


         model.addRow(record1);
       }

     }catch(Exception el){
       el.printStackTrace();
     }
     db.close();




  }

  public void jButtonBack_actionPerformed(ActionEvent e) {
    String isbn="";
    int tag;
    isbn=jTextFieldBorrowISBN.getText().trim();

    if(isbn.equals("")){
      JOptionPane.showMessageDialog(this, " ISBN号不能为空");
      return;
    }
    if(jTextFieldtag.getText().trim().equals("")){
      JOptionPane.showMessageDialog(this, " tag值不能为空!");
      return;
    }
    tag=Integer.parseInt(jTextFieldtag.getText().trim());
    strSQL="select * from borrow where ISBN='"+isbn+"' and tag="+tag+"";
    rs = db.getResult(strSQL);

    boolean isexist = false;
    try {
      isexist = rs.first();
    }
    catch (SQLException ex1) {
    }
    if(!isexist){
      JOptionPane.showMessageDialog(this, " 没有人借这本书！");
      return;
    }
    String strxuehao="";
    try{
      strxuehao=rs.getString("xuehao").trim();
      db.close();
      strSQL="select * from buser where xuehao='"+strxuehao+"'";
      rs1 = db1.getResult(strSQL);
      jTextFieldXueHao.setText(strxuehao);
      rs1.next();

      name.setText(rs1.getString("name"));
      type.setText(rs1.getString("type"));
      if(rs1.getString("sex").equals("男")){
        jRadioButtonMale.setSelected(true);
        jRadioButtonFemale.setSelected(false);
      }
      else{
        jRadioButtonMale.setSelected(false);
        jRadioButtonFemale.setSelected(true);
      }
      jTextFieldGrade.setText(rs1.getString("grade").trim());
      jTextFieldXueYuan.setText(rs1.getString("institute").trim());
      jTextFieldZhuanYe.setText(rs1.getString("specialty").trim());
      jTextFieldMoney.setText(String.valueOf(rs1.getFloat("penalty")));
      if(rs1.getInt("hangUp")==1){
        jCheckBoxGuaQi.setSelected(true);
      }
      else{
        jCheckBoxGuaQi.setSelected(false);
      }
    }catch(Exception e1){
      e1.printStackTrace();
      return;
    }

    String titles[]={"书名","ISBN","索引号","借书日期","还书日期","超期天数"};
    model=new DefaultTableModel(titles,0);
    jTable1.setModel(model);
    strSQL="select ISBN,name,bookAdress,lendDate,returnDate, DATEDIFF(day,returnDate,getDate()) as 'chaoqi' from bookInfo_VIEW where xuehao='"+strxuehao+"'";

    String [] record=new String[6];
    rs = db.getResult(strSQL);
    bcq=false;
    bookNumOfChaoqi=0;
    try{
      while(rs.next()){
        record[0]=rs.getString("name").trim();
        record[1]=rs.getString("ISBN").trim();
        record[2]=rs.getString("bookAdress").trim();
        record[3]=rs.getDate("lendDate").toString().trim();
        record[4]=rs.getDate("returnDate").toString().trim();
        record[5]=String.valueOf(rs.getInt("chaoqi"));
        if(rs.getInt("chaoqi")>0){
          bcq=true;
          bookNumOfChaoqi++;
        }

        model.addRow(record);
      }

    }catch(Exception el){
      el.printStackTrace();
    }


    strSQL="delete from borrow where ISBN='"+isbn+"' and tag="+tag+"";
    if (db.executeSql(strSQL)) {
      strSQL="update bookADS set isBorrow='可借' where ISBN='"+isbn+"' and tag="+tag+"";
      db.executeSql(strSQL);
      strSQL="update buser set bookNumOfBorrow=bookNumOfBorrow-1 where xuehao='"+strxuehao+"'";
      db.executeSql(strSQL);
      JOptionPane.showMessageDialog(this, "成功还书！");
      jTextFieldtag.setText("");
      jTextFieldBorrowISBN.setText("");
      }
    else {
      JOptionPane.showMessageDialog(this, " 还书失败，请重新操作！");
      return;
    }
    String titles1[]={"书名","ISBN","索引号","借书日期","还书日期","超期天数"};
    model=new DefaultTableModel(titles1,0);
    jTable1.setModel(model);
    strSQL="select ISBN,name,bookAdress,lendDate,returnDate, DATEDIFF(day,returnDate,getDate()) as 'chaoqi' from bookInfo_VIEW where xuehao='"+strxuehao+"'";
    String [] record1=new String[6];
    rs = db.getResult(strSQL);
    bcq=false;
    bookNumOfChaoqi=0;
    try{
      while(rs.next()){
        record1[0]=rs.getString("name").trim();
        record1[1]=rs.getString("ISBN").trim();
        record1[2]=rs.getString("bookAdress").trim();
        record1[3]=rs.getDate("lendDate").toString().trim();
        record1[4]=rs.getDate("returnDate").toString().trim();
        record1[5]=String.valueOf(rs.getInt("chaoqi"));
        if(rs.getInt("chaoqi")>0){
          bcq=true;
          bookNumOfChaoqi++;
        }


        model.addRow(record1);
      }

    }catch(Exception el){
      el.printStackTrace();
    }

    db.close();
    db1.close();
  }

  public void jButton1_actionPerformed(ActionEvent e) {
    this.dispose();
  }
}