4.借书界面.txt

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

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

    public void jButton5_actionPerformed(ActionEvent e) {
               F4_5();
    }
    void F4_5(){
            try
                {
                   String str4_5_1,str4_5_2;
                   str4_5_1=jTextField1.getText();
                   str4_5_2=new String(jPasswordField1.getPassword());
                   Statement stmt4_5_1 = conn.createStatement(ResultSet.
                                                      TYPE_SCROLL_SENSITIVE,
                                                      ResultSet.CONCUR_UPDATABLE);
                   String sq4_5_l= "select * from reader where ID='"+str4_5_1+"' AND 密码 = '"+str4_5_2+"' ";
                   ResultSet rs4_5_1 = stmt4_5_1.executeQuery(sq4_5_l);
                   if(!rs4_5_1.next())
                    {
                       JOptionPane.showMessageDialog(this,"帐号或者密码错误","错误",JOptionPane.ERROR_MESSAGE);
                    }
                   else
                     {
                  try
                     {
                        String str4_5_3;
                        str4_5_3=jTextField6.getText();
                        Statement stmt4_5_2 = conn.createStatement(ResultSet.
                                               TYPE_SCROLL_SENSITIVE,
                                               ResultSet.CONCUR_UPDATABLE);
                                            String sq4_5_2 = "select * from book where 编号 = '"+str4_5_3+"'";
                        ResultSet rs4_5_2 = stmt4_5_2.executeQuery(sq4_5_2);
                        if(!rs4_5_2.next())
                          {
                            JOptionPane.showMessageDialog(this,"书籍编号错误","错误",JOptionPane.ERROR_MESSAGE);
                          }

                         else{
                                 Statement stmt4_5_3 = conn.createStatement(
                                         ResultSet.
                                         TYPE_SCROLL_SENSITIVE,
                                         ResultSet.CONCUR_UPDATABLE);
                                 String sq4_5_3 ="select 借阅情况 from book where 编号 = '"+str4_5_3+"'";
                                 ResultSet rs4_5_3 = stmt4_5_3.executeQuery(sq4_5_3);
                                 String a = new String("未借");
                                 if ((!rs4_5_3.next()) &&!rs4_5_3.getString("借阅情况").equals(a))
                                 {
                                     JOptionPane.showMessageDialog(this, "此书已借被借阅","错误", JOptionPane.ERROR_MESSAGE);
                                 }
                                 else
                                 {
                                     Statement stmt4_5_4 = conn.createStatement(ResultSet.
                                                                                TYPE_SCROLL_SENSITIVE,
                                                                                ResultSet.CONCUR_UPDATABLE);
                                 String sq4_5_4 ="select 已借书籍5 from reader where ID = '"+str4_5_1+"'";
                                 ResultSet rs4_5_4 = stmt4_5_4.executeQuery(sq4_5_4);
                                 String b = new String("未借");
                             if((rs4_5_4.next())&&!rs4_5_4.getString("已借书籍5").equals(b))
                             {
                                 JOptionPane.showMessageDialog(this, "此借书位已经不能借书，请尝试其他借书位","错误", JOptionPane.ERROR_MESSAGE);
                             }
                                  else{
                                      Statement stmt4_1_25 = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                                                               ResultSet.CONCUR_UPDATABLE);
                                  String sq4_1_25 = "select * from book where 编号 = '"+str4_5_3+"'";
                                  ResultSet rs4_1_25 = stmt4_1_25.executeQuery(sq4_1_25);
                                   if(rs4_1_25.next())
                                     { String rs1item1 = rs4_1_25.getString("编号");
                                          String rs1item2 = rs4_1_25.getString("书名");
                                          String rs1item3 = rs4_1_25.getString( "作者");
                                          String rs1item4 = rs4_1_25.getString("出版社");
                                          jTextArea1.setText("编号：       " +
                                                  rs1item1 +
                                                  '\n' +
                                                  "书名：       " + rs1item2 + '\n' +
                                                  "作者：       " + rs1item3 + '\n' +
                                                  "出版社：       " + rs1item4 +
                                                  '\n');}
                                          JOptionPane.showMessageDialog(this,"请核对所借的书籍信息", "成功借书",JOptionPane.OK_CANCEL_OPTION);

                                          try
                                           {
                                               Statement stmt4_5_5_1 = conn.createStatement(ResultSet.
                                               TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
                                              String sq4_5_5_1="select * from book where 编号='"+str4_5_3+"'";
                                              ResultSet rs4_5_5_1 = stmt4_5_5_1.executeQuery(sq4_5_5_1);
                                            if(rs4_5_5_1.next())
                                           {
                                               String bookName5 = rs4_5_5_1.getString("书名");
                                               Statement stmt4_5_5 = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
                                               String sq4_5_5 ="update  reader  set 已借书籍5 ='"+bookName5+"' where ID ='" +str4_5_1 + "'";
                                               stmt4_5_5.executeUpdate(sq4_5_5);
                                               Statement stmt4_5_6 = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
                                               String sq4_5_6 =
                                                       "update book set 借阅情况 = '送书' where 编号 ='" +
                                                       str4_5_3 + "'";
                                               stmt4_5_6.executeUpdate(sq4_5_6);
                                           }
                                                Statement stmt4_5_7 = conn.createStatement(ResultSet.
                                                                                           TYPE_SCROLL_SENSITIVE,
                                                                                           ResultSet.CONCUR_UPDATABLE);
                                                 String sq4_5_7 ="update book set 借书ID = '" +str4_5_1 + "' where 编号 ='" + str4_5_3 + "'";
                                                 stmt4_5_7.executeUpdate(sq4_5_7);
                                           }

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


class Frame4_jButton4_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton4_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame4_jButton5_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton5_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame4_jButton6_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton6_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame4_jButton2_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton2_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame4_jButton3_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton3_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

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




class Frame4_jButton1_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton1_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

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