maindemoframe1.java~145~

该文件中包含有源代码及一部分的文档,该系统是一个小型的英语单词字典的系统.

     Database database = new Database();
     String sql = "select * from book where Publish = '"+Publish+"'";
     ResultSet rs = database.query(sql);
     try {
         String text = "";
         while (rs.next()) {
            text =  "书名："+ rs.getString(2)+"    "

                            +"作者："+rs.getString(4)+"    "
                            +"出版社："+rs.getString(7)+"   "
                            +"价格："+rs.getString(8)+"\n"+text;
         }
         if(text.equals("")){
            text = "无此书！";
         }
         jTextArea1.setText(text);
     } catch (SQLException ex) {
         ex.printStackTrace();
     }

    }

    public void jPanel5_componentShown(ComponentEvent e) {
        Database database = new Database();
        String sql = "select distinct Publish from book";
        ResultSet rs = database.query(sql);
        try {
          while (rs.next()) {
             jComboBox3.addItem(rs.getString(1));
          }
       } catch (SQLException ex) {
         ex.printStackTrace();
     }

    }

    public void jPanel6_componentShown(ComponentEvent e) {
      Database database = new Database();
      String sql = "select distinct ClassName from BookClass ";
      ResultSet rs = database.query(sql);
      try {
        while (rs.next()) {
           jComboBox3.addItem(rs.getString(1));
        }
     } catch (SQLException ex) {
       ex.printStackTrace();
   }

    }

    public void jButton4_actionPerformed(ActionEvent e) {
        String ClassName = (String)jComboBox3.getSelectedItem();
        Database database = new Database();
        String sql = "select * from book ,BookClass where ClassName = '"+ClassName+"'";
        ResultSet rs = database.query(sql);
        try {
              String text = "";
               while (rs.next()) {
                  text =  "书名："+ rs.getString(2)+"    "

                         +"作者："+rs.getString(4)+"    "
                         +"出版社："+rs.getString(7)+"   "
                         +"价格："+rs.getString(8)+"\n"+text;
      }
       if(text.equals("")){
         text = "无此书！";
      }
           jTextArea1.setText(text);
     } catch (SQLException ex) {
      ex.printStackTrace();
  }

    }
}


class MainDemoframe1_jButton4_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jButton4_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MainDemoframe1_jPanel5_componentAdapter extends ComponentAdapter {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jPanel5_componentAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

    public void componentShown(ComponentEvent e) {
        adaptee.jPanel5_componentShown(e);
    }
}


class MainDemoframe1_jPanel6_componentAdapter extends ComponentAdapter {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jPanel6_componentAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

    public void componentShown(ComponentEvent e) {
        adaptee.jPanel6_componentShown(e);
    }
}


class MainDemoframe1_jButton3_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jButton3_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MainDemoframe1_jComboBox2_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jComboBox2_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MainDemoframe1_jComboBox3_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jComboBox3_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MainDemoframe1_jMenuItem6_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jMenuItem6_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MainDemoframe1_jMenuItem5_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jMenuItem5_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MainDemoframe1_jButton1_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jButton1_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MainDemoframe1_jTextField1_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jTextField1_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MainDemoframe1_jPanel4_componentAdapter extends ComponentAdapter {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jPanel4_componentAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

    public void componentShown(ComponentEvent e) {
        adaptee.jPanel4_componentShown(e);
    }
}


class MainDemoframe1_jButton2_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jButton2_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MainDemoframe1_jPanel3_componentAdapter extends ComponentAdapter {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jPanel3_componentAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

    public void componentShown(ComponentEvent e) {
        adaptee.jPanel3_componentShown(e);
    }
}

class MainDemoframe1_jMenuItem4_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jMenuItem4_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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

class MainDemoframe1_jMenuItem2_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jMenuItem2_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MainDemoframe1_jMenuItem3_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jMenuItem3_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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


class MainDemoframe1_jMenuItem1_actionAdapter implements ActionListener {
    private MainDemoframe1 adaptee;
    MainDemoframe1_jMenuItem1_actionAdapter(MainDemoframe1 adaptee) {
        this.adaptee = adaptee;
    }

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