maindemoframe1.java~142~

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

        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 jComboBox3_actionPerformed(ActionEvent e) {

    }

    public void jComboBox2_actionPerformed(ActionEvent e) {

    }

    public void jButton3_actionPerformed(ActionEvent e) {
     String Publish = (String)jComboBox3.getSelectedItem();
     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();
     }

    }
}


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_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);
    }
}