frame1.java~66~

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

                                         "已借书籍(4)：    "+rs1item8_2_7+'\n'+
                                         "已借书籍(5)：    "+rs1item8_2_8+'\n');
                  }
              }
              catch(Exception e)
                       {
                          System.err.println(e);
                       }
          }//if 2
          else if(jRadioButton7.isSelected())
          {
              try
              {
                  Statement stmt8_3_1 = conn.createStatement(ResultSet.
                                                     TYPE_SCROLL_SENSITIVE,
                                                     ResultSet.CONCUR_UPDATABLE);
                            String sq8_3_1 = "select * from reader order by 宿舍";
                            ResultSet rs8_3_1 = stmt8_3_1.executeQuery(sq8_3_1);
                  while(rs8_3_1.next())
                  {
                      String rs1item8_3_1 = rs8_3_1.getString("ID");
                      String rs1item8_3_2 = rs8_3_1.getString("姓名");
                      String rs1item8_3_3 = rs8_3_1.getString("宿舍");
                      String rs1item8_3_4 = rs8_3_1.getString("已借书籍");
                      String rs1item8_3_5 = rs8_3_1.getString("已借书籍2");
                      String rs1item8_3_6 = rs8_3_1.getString("已借书籍3");
                      String rs1item8_3_7 = rs8_3_1.getString("已借书籍4");
                      String rs1item8_3_8 = rs8_3_1.getString("已借书籍5");
                      jTextArea4.append("ID：         "+rs1item8_3_1+'\n'+
                                         "姓名：       "+rs1item8_3_2+'\n'+
                                         "宿舍：       "+rs1item8_3_3+'\n'+
                                         "已借书籍(1)：    "+rs1item8_3_4+'\n'+
                                         "已借书籍(2)：    "+rs1item8_3_5+'\n'+
                                         "已借书籍(3)：    "+rs1item8_3_6+'\n'+
                                         "已借书籍(4)：    "+rs1item8_3_7+'\n'+
                                         "已借书籍(5)：    "+rs1item8_3_8+'\n');
                  }
              }
              catch(Exception e)
                       {
                          System.err.println(e);
                       }
          }//if 3
          else if(jRadioButton8.isSelected())
          {
        try
       {
           Statement stmt8_4_1 = conn.createStatement(ResultSet.
                                              TYPE_SCROLL_SENSITIVE,
                                              ResultSet.CONCUR_UPDATABLE);
                     String sq8_4_1 = "select '总数'=count(ID) from reader";
                     ResultSet rs8_4_1 = stmt8_4_1.executeQuery(sq8_4_1);
           while(rs8_4_1.next())
           {
               String rs1item8_4_1 = rs8_4_1.getString("总数");
               jTextArea4.setText("总共有读者：           "+rs1item8_4_1);

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


             }//if  4
             else
                     {
                 JOptionPane.showMessageDialog(this,"请选择其中一个","错误",JOptionPane.ERROR_MESSAGE);
                     }
    }//F7()

    public void jButton16_actionPerformed(ActionEvent e) {
                 jTextArea4.setText("");
    }
}




class Frame1_jButton16_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton16_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton14_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton14_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton15_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton15_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton13_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton13_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jRadioButton1_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jRadioButton1_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton10_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton10_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton9_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton9_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton12_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton12_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton8_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton8_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton11_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton11_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton7_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton7_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton5_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton5_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton3_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton3_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton6_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton6_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton2_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton2_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton4_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton4_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton1_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton1_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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