medicine_information.java~162~

来自「使用Java语言开发的数据库课程设计——医药管理信息系统。」· JAVA~162~ 代码 · 共 890 行 · 第 1/3 页

                  jTextField6.setText(rs.getString(10));
                  jTextField7.setText(rs.getString(11));
                  jTextField8.setText(rs.getString(12));
                  jTextField9.setText(rs.getString(13));
                  jComboBox1.setSelectedItem(rs.getString(4));
                  jComboBox1.setSelectedItem(rs.getString(5));
                  jComboBox1.setSelectedItem(rs.getString(6));
                  jComboBox1.setSelectedItem(rs.getString(7));
                  jTextField2.setEnabled(true);
                  jTextField3.setEnabled(true);
                  jTextField4.setEnabled(true);
                  jTextField5.setEnabled(true);
                  jTextField6.setEnabled(true);
                  jTextField7.setEnabled(true);
                  jTextField8.setEnabled(true);
                  jTextField9.setEnabled(true);
                  jComboBox1.setEnabled(true);
                  jComboBox2.setEnabled(true);
                  jComboBox3.setEnabled(true);
                  jComboBox4.setEnabled(true);
                  jButton3.setEnabled(true);
              }
              rs.close();
              con.close();
           }
           catch(SQLException ex)
           {
               JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
           }
        }

    }

    public void jButton3_actionPerformed(ActionEvent e)
    {
        int choice = JOptionPane.showConfirmDialog(null,"真的要保存为现在的数据？","请慎重考虑！",JOptionPane.YES_NO_OPTION);
        if(choice==JOptionPane.NO_OPTION) return;
        else
        {
            Connect_DB();
            save = "update Medicine_Data set 药品编号='" +jTextField1.getText() +
                   "',药品名称='" + jTextField2.getText() +
                   "',通用名称='" + jTextField3.getText() +
                   "',药品类别='" + jComboBox1.getSelectedItem().toString() +
                   "',有效期='" + jComboBox2.getSelectedItem().toString() +
                   "',单位='" + jComboBox3.getSelectedItem().toString() +
                   "',剂型='" + jComboBox4.getSelectedItem().toString() +
                   "',包装数量=" + jTextField4.getText() +
                   ",产地='" + jTextField5.getText() +
                   "',零售价格=" + jTextField6.getText() +
                   ",进货价格=" + jTextField7.getText() +
                   ",批发价格=" + jTextField8.getText() +
                   ",批号='" + jTextField9.getText() +
                   "' where(药品编号='" + jTextField1.getText() + "')";
            insert_data = "insert into Medicine_Data (药品编号,药品名称,通用名称,药品类别,有效期,单位,剂型,包装数量,产地,零售价格,进货价格,批发价格,批号) values('"
                          +jTextField1.getText()+"','"+jTextField2.getText()+"','"+jTextField3.getText()+"','"
                          +jComboBox1.getSelectedItem().toString()+"','"+jComboBox2.getSelectedItem().toString()+"','"
                          +jComboBox3.getSelectedItem().toString()+"','"+jComboBox4.getSelectedItem().toString()+"',"
                          +jTextField4.getText()+",'"+jTextField5.getText()+"',"+jTextField6.getText()+","
                          +jTextField7.getText()+","+jTextField8.getText()+",'"+jTextField9.getText()+"')";

            if (jButton3.getText().equals("保  存"))
                Update_Data(save);
            if (jButton3.getText().equals("添  加"))
                Update_Data(insert_data);
            clearPane1();
            jTextField2.setEnabled(false);
            jTextField3.setEnabled(false);
            jTextField4.setEnabled(false);
            jTextField5.setEnabled(false);
            jTextField6.setEnabled(false);
            jTextField7.setEnabled(false);
            jTextField8.setEnabled(false);
            jTextField9.setEnabled(false);
            jComboBox1.setEnabled(false);
            jComboBox2.setEnabled(false);
            jComboBox3.setEnabled(false);
            jComboBox4.setEnabled(false);
            jTextField10.setText("");
            jTextField22.setText("");
            jButton2.setEnabled(true);
            jButton3.setEnabled(false);
        }
    }

    public void jButton4_actionPerformed(ActionEvent e)
    {
        clearPane1();
        jTextField1.setEnabled(false);
        jTextField2.setEnabled(false);
        jTextField3.setEnabled(false);
        jTextField4.setEnabled(false);
        jTextField5.setEnabled(false);
        jTextField6.setEnabled(false);
        jTextField7.setEnabled(false);
        jTextField8.setEnabled(false);
        jTextField9.setEnabled(false);
        jComboBox1.setEnabled(false);
        jComboBox2.setEnabled(false);
        jComboBox3.setEnabled(false);
        jComboBox4.setEnabled(false);
        jButton1.setEnabled(true);
        jButton2.setEnabled(true);
        jTextField10.setText("");
        jTextField22.setText("");
    }

    public void jButton2_actionPerformed(ActionEvent e)
    {
        if(jTextField10.getText().equals("")&&jTextField22.getText().equals(""))
        {
            JOptionPane.showMessageDialog(null,"请先填写药品编号 (必填)!!","系统提示!",
                                JOptionPane.WARNING_MESSAGE);
        }
        else
        {
            jButton1.setEnabled(false);
            jTextField1.setEnabled(false);
            jTextField2.setEnabled(true);
            jTextField3.setEnabled(true);
            jTextField4.setEnabled(true);
            jTextField5.setEnabled(true);
            jTextField6.setEnabled(true);
            jTextField7.setEnabled(true);
            jTextField8.setEnabled(true);
            jTextField9.setEnabled(true);
            jComboBox1.setEnabled(true);
            jComboBox2.setEnabled(true);
            jComboBox3.setEnabled(true);
            jComboBox4.setEnabled(true);
            jButton3.setEnabled(true);
            jButton3.setText("添  加");
            jTextField1.setText(jTextField10.getText());
            jTextField2.setText(jTextField22.getText());
        }
    }

    public void jButton7_actionPerformed(ActionEvent e)
    {
        if(jTextField23.getText().equals("")&&jTextField28.getText().equals(""))
        {
            JOptionPane.showMessageDialog(null,"请输入要删除的药品编号或药品名称!!!","系统提示",JOptionPane.ERROR_MESSAGE);
        }
       else
       {
           if(jTextField23.getText().equals(""))
               query = "SELECT * FROM Medicine_Data WHERE 药品名称 ='"+jTextField28.getText()+"'";
           else if(jTextField28.getText().equals(""))
               query = "SELECT * FROM Medicine_Data WHERE 药品编号 = '"+jTextField23.getText()+"'";
           else query = "SELECT * FROM Medicine_Data WHERE 药品名称 ='"+jTextField28.getText()+"'AND 药品编号 = '"+jTextField23.getText()+"'" ;

           Connect_DB();
           try
          {

              Connection con = DriverManager.getConnection(conURL,Username,Password);
              Statement stm= con.createStatement();
              ResultSet rs = stm.executeQuery(query);
             if(!rs.next())
             {
              JOptionPane.showMessageDialog(null,"你所要删除的药品数据不存在！！","错误!",
                                               JOptionPane.ERROR_MESSAGE);
             }
              else
             {
                  jTextArea1.append("药品编号 : "+rs.getString(1)+'\n'
                                   +"药品名称 : "+rs.getString(2)+'\n'
                                   +"通用名称 : "+rs.getString(3)+'\n'
                                   +"药品类别 : "+rs.getString(4)+'\n'
                                   +"有效期限 : "+rs.getString(5)+'\n'
                                   +" 单 位  : "+rs.getString(6)+'\n'
                                   +" 剂 型  : "+rs.getString(7)+'\n'
                                   +"包装数量 : "+rs.getString(8)+'\n'
                                   +" 产 地  : "+rs.getString(9)+'\n'
                                   +"零售价格 : "+rs.getString(10)+'\n'
                                   +"批发价格 : "+rs.getString(11)+'\n'
                                   +"进货价格 : "+rs.getString(12)+'\n'
                                   +" 批 号  : "+rs.getString(13)+'\n');
                  int choice = JOptionPane.showConfirmDialog(null,"真的要删除的这个数据吗 (详细显示于文本框)？","请慎重考虑！",JOptionPane.YES_NO_OPTION);
                  if(choice==JOptionPane.NO_OPTION)
                 {
                     jTextArea1.setText("");
                     jTextField23.setText("");
                     jTextField23.setText("");
                 }
                 else
                 {
                     if(!jTextField23.getText().equals(""))
                         delete = "delete from Medicine_Data where 药品编号='"+jTextField23.getText()+"'";
                     else if(!jTextField28.getText().equals(""))
                         delete = "delete from Medicine_Data where 药品名称='"+jTextField28.getText()+"'";
                     Connect_DB();
                     Update_Data(delete);
                     jTextArea1.setText("");
                     jTextField23.setText("");
                     jTextField23.setText("");
                 }

            }
              rs.close();
              con.close();

        }
        catch(SQLException ex)
        {
            JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
        }
      }

    }
}


class medicine_information_jButton7_actionAdapter implements ActionListener {
    private medicine_information adaptee;
    medicine_information_jButton7_actionAdapter(medicine_information adaptee) {
        this.adaptee = adaptee;
    }

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


class medicine_information_jButton2_actionAdapter implements ActionListener {
    private medicine_information adaptee;
    medicine_information_jButton2_actionAdapter(medicine_information adaptee) {
        this.adaptee = adaptee;
    }

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


class medicine_information_jButton4_actionAdapter implements ActionListener {
    private medicine_information adaptee;
    medicine_information_jButton4_actionAdapter(medicine_information adaptee) {
        this.adaptee = adaptee;
    }

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


class medicine_information_jButton3_actionAdapter implements ActionListener {
    private medicine_information adaptee;
    medicine_information_jButton3_actionAdapter(medicine_information adaptee) {
        this.adaptee = adaptee;
    }

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


class medicine_information_jButton1_actionAdapter implements ActionListener {
    private medicine_information adaptee;
    medicine_information_jButton1_actionAdapter(medicine_information adaptee) {
        this.adaptee = adaptee;
    }

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


class medicine_information_jButton6_actionAdapter implements ActionListener {
    private medicine_information adaptee;
    medicine_information_jButton6_actionAdapter(medicine_information adaptee) {
        this.adaptee = adaptee;
    }

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


class medicine_information_jButton5_actionAdapter implements ActionListener {
    private medicine_information adaptee;
    medicine_information_jButton5_actionAdapter(medicine_information adaptee) {
        this.adaptee = adaptee;
    }

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