3.查询.txt

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

        ResultSet rs3_3 = stmt3_3.executeQuery(sq3_3);
        if(rs3_3.next())
        {
            while(rs3_3.next())
            {
                String rs1item3_3_1 = rs3_3.getString("编号");
                String rs1item3_3_2 = rs3_3.getString("书名");
                String rs1item3_3_3 = rs3_3.getString("作者");
                String rs1item3_3_4 = rs3_3.getString("出版社");
                String rs1item3_3_5 = rs3_3.getString("借阅情况");
                jTextArea1.append("编号：       " + rs1item3_3_1 + '\n' +
                                  "书名：       " + rs1item3_3_2 + '\n' +
                                  "作者：       " + rs1item3_3_3 + '\n' +
                                  "出版社：     " + rs1item3_3_4 + '\n' +
                                  "借阅情况：   " + rs1item3_3_5 + '\n' +
                                  "未借：您可以借书"+'\n'+
                                 "送书：书籍已经被其他读者所借"+'\n'+
                                 "收书：管理员还没有从读者收回书籍"+'\n'+

                                  "---------------------------------------------------"+'\n');
            }
        }
        else
               {
              JOptionPane.showMessageDialog(this,"没有找到相关书籍","错误",JOptionPane.ERROR_MESSAGE);
               }
    }
    catch(Exception e)
    {
        System.err.println(e);
    }
 }   //F3_3()


    public void jButton5_actionPerformed(ActionEvent e)
    {
        F3_4();
    }
    void F3_4()
    {
        try
       {
           String str3_4_1,str3_4_2,str3_4_3;
           str3_4_1=jTextField1.getText();
           str3_4_2=jTextField2.getText();
           str3_4_3=jTextField3.getText();
           Statement stmt3_4 = conn.createStatement(ResultSet.
                                                 TYPE_SCROLL_SENSITIVE,
                                                 ResultSet.CONCUR_UPDATABLE);
           String sq3_4 = "select * from book where 书名 like '%"+str3_4_1+"%' and 作者 like '%"+str3_4_2+"%' and 出版社 like '%"+str3_4_3+"%'";
           ResultSet rs3_4 = stmt3_4.executeQuery(sq3_4);
           if(rs3_4.next())

               while(rs3_4.next())

                   {String rs1item3_4_1 = rs3_4.getString("编号");
               String rs1item3_4_2 = rs3_4.getString("书名");
               String rs1item3_4_3 = rs3_4.getString("作者");
               String rs1item3_4_4 = rs3_4.getString("出版社");
               String rs1item3_4_5 = rs3_4.getString("借阅情况");
               jTextArea1.append("编号：       " + rs1item3_4_1 + '\n' +
                                 "书名：       " + rs1item3_4_2 + '\n' +
                                 "作者：       " + rs1item3_4_3 + '\n' +
                                 "出版社：     " + rs1item3_4_4 + '\n' +
                                 "借阅情况：   " + rs1item3_4_5 + '\n' +
                                 "未借：您可以借书"+'\n'+
                                 "送书：书籍已经被其他读者所借"+'\n'+
                                 "收书：管理员还没有从读者收回书籍"+'\n'+
                                 "------------------------------------------------"+'\n');
            }
            else
            {
              JOptionPane.showMessageDialog(this,"没有找到相关书籍","错误",JOptionPane.ERROR_MESSAGE);
         }




       }
       catch(Exception e)
       {
           System.err.println(e);
           JOptionPane.showMessageDialog(this,"没有找到相关书籍","错误",JOptionPane.ERROR_MESSAGE);
       }

    }  //F3_4();

    public void jButton2_actionPerformed(ActionEvent e)
    {
        F3_1();
    }
    void F3_1()
    {
     try
    {
        String str3_1;
        str3_1=jTextField1.getText();
        Statement stmt3_1 = conn.createStatement(ResultSet.
                                              TYPE_SCROLL_SENSITIVE,
                                              ResultSet.CONCUR_UPDATABLE);
        String sq3_1 = "select * from book where 书名 like '%"+str3_1+"%'";
        ResultSet rs3_1 = stmt3_1.executeQuery(sq3_1);
        if(rs3_1.next()){
            String rs1item3_1_1 = rs3_1.getString("编号");
               String rs1item3_1_2 = rs3_1.getString("书名");
               String rs1item3_1_3 = rs3_1.getString("作者");
               String rs1item3_1_4 = rs3_1.getString("出版社");
               String rs1item3_1_5 = rs3_1.getString("借阅情况");
               jTextArea1.append("编号：       " + rs1item3_1_1 + '\n' +
                                  "书名：       " + rs1item3_1_2 + '\n' +
                                  "作者：       " + rs1item3_1_3 + '\n' +
                                  "出版社：     " + rs1item3_1_4 + '\n' +
                                  "借阅情况：   " + rs1item3_1_5 + '\n' +
                                  "未借：您可以借书" + '\n' +
                                  "送书：书籍已经被其他读者所借" + '\n' +
                                  "收书：管理员还没有从读者收回书籍" + '\n' +
                                  "------------------------------------------------------" +
                                  '\n');

            while (rs3_1.next()) {

                jTextArea1.append("编号：       " + rs1item3_1_1 + '\n' +
                                  "书名：       " + rs1item3_1_2 + '\n' +
                                  "作者：       " + rs1item3_1_3 + '\n' +
                                  "出版社：     " + rs1item3_1_4 + '\n' +
                                  "借阅情况：   " + rs1item3_1_5 + '\n' +
                                  "未借：您可以借书" + '\n' +
                                  "送书：书籍已经被其他读者所借" + '\n' +
                                  "收书：管理员还没有从读者收回书籍" + '\n' +
                                  "------------------------------------------------------" +
                                  '\n');
            }
        }
        else
        {
        JOptionPane.showMessageDialog(this,"没有找到相关书籍","错误",JOptionPane.ERROR_MESSAGE);
        }
    }
    catch(Exception e)
    {
        System.err.println(e);
    }
 }  //F3_1()

    public void jTextField3_actionPerformed(ActionEvent e)
    {
    }

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

class Frame3_jButton2_actionAdapter implements ActionListener
{
    private Frame3 adaptee;
    Frame3_jButton2_actionAdapter(Frame3 adaptee)
    {
        this.adaptee = adaptee;
    }

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

class Frame3_jButton6_actionAdapter implements ActionListener
{
    private Frame3 adaptee;
    Frame3_jButton6_actionAdapter(Frame3 adaptee)
    {
        this.adaptee = adaptee;
    }

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

class Frame3_jButton5_actionAdapter implements ActionListener
{
    private Frame3 adaptee;
    Frame3_jButton5_actionAdapter(Frame3 adaptee)
    {
        this.adaptee = adaptee;
    }

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

class Frame3_jButton4_actionAdapter implements ActionListener
{
    private Frame3 adaptee;
    Frame3_jButton4_actionAdapter(Frame3 adaptee)
    {
        this.adaptee = adaptee;
    }

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

class Frame3_jTextField3_actionAdapter implements ActionListener
{
    private Frame3 adaptee;
    Frame3_jTextField3_actionAdapter(Frame3 adaptee)
    {
        this.adaptee = adaptee;
    }

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

class Frame3_jButton3_actionAdapter implements ActionListener
{
    private Frame3 adaptee;
    Frame3_jButton3_actionAdapter(Frame3 adaptee)
    {
        this.adaptee = adaptee;
    }

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


class Frame3_jButton1_actionAdapter implements ActionListener
{
    private Frame3 adaptee;
    Frame3_jButton1_actionAdapter(Frame3 adaptee)
    {
        this.adaptee = adaptee;
    }

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