5.还书界面.txt

本系统是基于JBuilder和SQL2000开发的

                        String sq4_1_54 = "select * from book where 编号 = '"+str5_4_3+"'";
                        ResultSet rs4_1_54 = stmt4_1_54.executeQuery(sq4_1_54);
                         if(rs4_1_54.next())
                           { String rs1item1 = rs4_1_54.getString("编号");
                                String rs1item2 = rs4_1_54.getString("书名");
                                String rs1item3 = rs4_1_54.getString( "作者");
                                String rs1item4 = rs4_1_54.getString("出版社");
                                jTextArea1.setText("编号：       " +
                                        rs1item1 +
                                        '\n' +
                                        "书名：       " + rs1item2 + '\n' +
                                        "作者：       " + rs1item3 + '\n' +
                                        "出版社：       " + rs1item4 +
                                        '\n');}

                                 JOptionPane.showMessageDialog(this, "请核对所要归还的书籍信息", "成功还书",
                                                               JOptionPane.OK_CANCEL_OPTION);

                                 try {


                                         Statement stmt5_4_4 = conn.createStatement(
                                       ResultSet.
                                       TYPE_SCROLL_SENSITIVE,
                                       ResultSet.CONCUR_UPDATABLE);
                                         String sq5_4_4 ="update  reader  set 已借书籍4 = '未借'  where ID ='"+str5_4_1+"'";
                                     stmt5_4_4.executeUpdate(sq5_4_4);

                                     Statement stmt5_4_5 = conn.createStatement(ResultSet.
                                                                            TYPE_SCROLL_SENSITIVE,
                                                                            ResultSet.CONCUR_UPDATABLE);
                                     String sq5_4_5 = "update  book  set 借阅情况 = '收书' where 编号 ='"+str5_4_3+"'";
                                     stmt5_4_5.executeUpdate(sq5_4_5);

                                     Statement stmt5_4_6 = conn.createStatement(ResultSet.
                                                                            TYPE_SCROLL_SENSITIVE,
                                                                            ResultSet.CONCUR_UPDATABLE);
                                     String sq5_4_6 = "update  book  set 借书ID =  '' where 编号 ='"+str5_4_3+"'";
                                     stmt5_4_6.executeUpdate(sq5_4_6);
                                 } catch (Exception e) {
                                     System.err.println(e);
                                 }
                             }
                        }
                     }
                     catch(Exception e)
                       {
                          System.err.println(e);
                       }
               }

          }
                       catch(Exception e)
                       {
                          System.err.println(e);
                       }

         }

    public void jButton5_actionPerformed(ActionEvent e) {
                 F5_5();
    }

    void F5_5(){
              try
                  {
                      String str5_5_1,str5_5_2;
                     str5_5_1=jTextField1.getText();
                     str5_5_2=new String(jPasswordField1.getPassword());
                  Statement stmt5_5_1 = conn.createStatement(ResultSet.
                                                     TYPE_SCROLL_SENSITIVE,
                                                     ResultSet.CONCUR_UPDATABLE);
                  String sq5_5_l= "select * from reader where ID='"+str5_5_1+"' AND 密码 = '"+str5_5_2+"' ";
                  ResultSet rs5_5_1 = stmt5_5_1.executeQuery(sq5_5_l);
                  if(!rs5_5_1.next())
                      {
                         JOptionPane.showMessageDialog(this,"帐号或者密码错误","错误",JOptionPane.ERROR_MESSAGE);
               }
                  else
                       {
                      stmt5_5_1.close();
                      try
                       {
                          String str5_5_3;
                          str5_5_3=jTextField6.getText();
                          Statement stmt5_5_2 = conn.createStatement(ResultSet.
                                                 TYPE_SCROLL_SENSITIVE,
                                                 ResultSet.CONCUR_UPDATABLE);
                          String sq5_5_2 = "select * from book where 编号 = '"+str5_5_3+"'";
                          ResultSet rs5_5_2 = stmt5_5_2.executeQuery(sq5_5_2);
                          if(!rs5_5_2.next())
                            {
                              JOptionPane.showMessageDialog(this,"编号错误","错误",JOptionPane.ERROR_MESSAGE);
                            }
                           else{
                               Statement stmt5_5_3 = conn.createStatement(ResultSet.
                                                         TYPE_SCROLL_SENSITIVE,
                                                         ResultSet.CONCUR_UPDATABLE);
                                String sq5_5_3 = "select 借阅情况,借书ID from book where  借书ID ='"+str5_5_1+"'  ";
                                ResultSet rs5_5_3 = stmt5_5_3.executeQuery(sq5_5_3);
                                String a=new String("送书");
                                if((rs5_5_3.next()&&rs5_5_3.getString("借阅情况").equals(a)))
                                {
                                JOptionPane.showMessageDialog(this,"此书没有被你所借","错误",JOptionPane.ERROR_MESSAGE);
                                stmt5_5_3.close();
                                }
                            else
                                {
                                    Statement stmt4_1_55 = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                                                     ResultSet.CONCUR_UPDATABLE);
                        String sq4_1_55 = "select * from book where 编号 = '"+str5_5_3+"'";
                        ResultSet rs4_1_55 = stmt4_1_55.executeQuery(sq4_1_55);
                         if(rs4_1_55.next())
                           { String rs1item1 = rs4_1_55.getString("编号");
                                String rs1item2 = rs4_1_55.getString("书名");
                                String rs1item3 = rs4_1_55.getString( "作者");
                                String rs1item4 = rs4_1_55.getString("出版社");
                                jTextArea1.setText("编号：       " +
                                        rs1item1 +
                                        '\n' +
                                        "书名：       " + rs1item2 + '\n' +
                                        "作者：       " + rs1item3 + '\n' +
                                        "出版社：       " + rs1item4 +
                                        '\n');}

                                    JOptionPane.showMessageDialog(this, "请核对所要归还的书籍信息", "成功还书",JOptionPane.OK_CANCEL_OPTION);

                                    try {
                                            Statement stmt5_5_4 = conn.createStatement(
                                          ResultSet.
                                          TYPE_SCROLL_SENSITIVE,
                                          ResultSet.CONCUR_UPDATABLE);
                                          String sq5_5_4 ="update  reader  set 已借书籍5 = '未借'  where ID ='"+str5_5_1+"'";
                                        stmt5_5_4.executeUpdate(sq5_5_4);
                                        Statement stmt5_5_5 = conn.createStatement(ResultSet.
                                                                               TYPE_SCROLL_SENSITIVE,
                                                                               ResultSet.CONCUR_UPDATABLE);
                                        String sq5_5_5 = "update  book  set 借阅情况 = '收书' where 编号 ='"+str5_5_3+"'";
                                        stmt5_5_5.executeUpdate(sq5_5_5);
                                        Statement stmt5_5_6 = conn.createStatement(ResultSet.
                                                                               TYPE_SCROLL_SENSITIVE,
                                                                               ResultSet.CONCUR_UPDATABLE);
                                        String sq5_5_6 = "update  book  set 借书ID =   '' where 编号 ='"+str5_5_3+"'";
                                        stmt5_5_6.executeUpdate(sq5_5_6);
                                    } catch (Exception e) {
                                        System.err.println(e);
                                    }
                                }
                           }
                        }
                        catch(Exception e)
                          {
                             System.err.println(e);
                          }
                  }

             }
                          catch(Exception e)
                          {
                             System.err.println(e);
                          }
            }              //F5_5

    public void jButton6_actionPerformed(ActionEvent e) {
                   jTextArea1.setText("");
    }
}


class Frame5_jButton6_actionAdapter implements ActionListener {
    private Frame5 adaptee;
    Frame5_jButton6_actionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame5_jButton4_actionAdapter implements ActionListener {
    private Frame5 adaptee;
    Frame5_jButton4_actionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame5_jButton3_actionAdapter implements ActionListener {
    private Frame5 adaptee;
    Frame5_jButton3_actionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame5_jButton2_actionAdapter implements ActionListener {
    private Frame5 adaptee;
    Frame5_jButton2_actionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame5_jButton1_actionAdapter implements ActionListener {
    private Frame5 adaptee;
    Frame5_jButton1_actionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame5_jButton5_actionAdapter implements ActionListener {
    private Frame5 adaptee;
    Frame5_jButton5_actionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

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