medicine_data_input.java~185~

使用Java语言开发的数据库课程设计——医药管理信息系统。

                   data.addElement(rs.getString(2));
                   data.addElement(rs.getString(3));
                   data.addElement(rs.getString(4));
                   data.addElement(rs.getString(5));
                   data.addElement(rs.getString(6));
                   data.addElement(rs.getString(7));
                   data.addElement(rs.getString(8));
                   data.addElement(rs.getString(9));
                   data.addElement(rs.getString(10));
                   data.addElement(rs.getString(11));
                   data.addElement(rs.getString(12));
                   data.addElement(rs.getString(13));
                   tableModel1.addRow(data);
              }
          }
              s.close();
              jTable1.setModel(tableModel1);
          }
          catch(SQLException ex)
          {
              JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
          }
        }
    }

    public void jButton6_actionPerformed(ActionEvent e)
    {
        jTextField11.setText("");
        jTextField13.setText("");
        jTextField12.setText("");
    }

    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()+"'" ;

           new Load_DB_Driver();
           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'+'\n'
                                   +"药品名称 :   "+rs.getString(2)+'\n'+'\n'
                                   +"通用名称 :   "+rs.getString(3)+'\n'+'\n'
                                   +"药品类别 :   "+rs.getString(4)+'\n'+'\n'
                                   +"有效期限 :   "+rs.getString(5)+'\n'+'\n'
                                   +" 单 位  :   "+rs.getString(6)+'\n'+'\n'
                                   +" 剂 型  :   "+rs.getString(7)+'\n'+'\n'
                                   +"包装数量 :   "+rs.getString(8)+'\n'+'\n'
                                   +" 产 地  :   "+rs.getString(9)+'\n'+'\n'
                                   +"零售价格 :   "+rs.getString(10)+'\n'+'\n'
                                   +"批发价格 :   "+rs.getString(11)+'\n'+'\n'
                                   +"进货价格 :   "+rs.getString(12)+'\n'+'\n'
                                   +" 库存量  :   "+rs.getString(13));
                  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()+"'";
                     new Load_DB_Driver();
                     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);
        }
      }
    }

    public void jButton8_actionPerformed(ActionEvent e)
    {
        if (jTextField13.getText().equals(""))
        {
            JOptionPane.showMessageDialog(null," 请输入精确值 !! ","系统提示",JOptionPane.WARNING_MESSAGE);
        }
        else
        {
            init_model();
            new Load_DB_Driver();
            try
           {
               Connection con2 = DriverManager.getConnection(conURL, Username,
                       Password);
               Statement s2 = con2.createStatement(ResultSet.
                       TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
               ResultSet rs2 = s2.executeQuery(
                       "select * from Medicine_Data where "
                       + jComboBox6.getSelectedItem().toString()
                       + "='" + jTextField13.getText() + "'");
               if (rs2.next() == false)
                   JOptionPane.showMessageDialog(null, " 搜索到 0 个符合条件的条目 !!! ",
                                                 "系统提示",
                                                 JOptionPane.ERROR_MESSAGE);
               else
               {
                   rs2.beforeFirst();
                   while (rs2.next())
                   {
                       data = new Vector();
                       data.addElement(rs2.getString(1));
                       data.addElement(rs2.getString(2));
                       data.addElement(rs2.getString(3));
                       data.addElement(rs2.getString(4));
                       data.addElement(rs2.getString(5));
                       data.addElement(rs2.getString(6));
                       data.addElement(rs2.getString(7));
                       data.addElement(rs2.getString(8));
                       data.addElement(rs2.getString(9));
                       data.addElement(rs2.getString(10));
                       data.addElement(rs2.getString(11));
                       data.addElement(rs2.getString(12));
                       data.addElement(rs2.getString(13));
                       tableModel1.addRow(data);
                   }
                   s2.close();
                   jTable1.setModel(tableModel1);
               }
           }
          catch(SQLException ex)
          {
              JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
          }

        }
    }
}


class medicine_data_input_jButton8_actionAdapter implements ActionListener {
    private medicine_data_input adaptee;
    medicine_data_input_jButton8_actionAdapter(medicine_data_input adaptee) {
        this.adaptee = adaptee;
    }

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

class medicine_data_input_jButton6_actionAdapter implements ActionListener {
    private medicine_data_input adaptee;
    medicine_data_input_jButton6_actionAdapter(medicine_data_input adaptee) {
        this.adaptee = adaptee;
    }

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

class medicine_data_input_jButton7_actionAdapter implements ActionListener {
    private medicine_data_input adaptee;
    medicine_data_input_jButton7_actionAdapter(medicine_data_input adaptee) {
        this.adaptee = adaptee;
    }

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

class medicine_data_input_jButton4_actionAdapter implements ActionListener {
    private medicine_data_input adaptee;
    medicine_data_input_jButton4_actionAdapter(medicine_data_input adaptee) {
        this.adaptee = adaptee;
    }

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

class medicine_data_input_jButton2_actionAdapter implements ActionListener {
    private medicine_data_input adaptee;
    medicine_data_input_jButton2_actionAdapter(medicine_data_input adaptee) {
        this.adaptee = adaptee;
    }

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

class medicine_data_input_jButton3_actionAdapter implements ActionListener {
    private medicine_data_input adaptee;
    medicine_data_input_jButton3_actionAdapter(medicine_data_input adaptee) {
        this.adaptee = adaptee;
    }

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

class medicine_data_input_jButton1_actionAdapter implements ActionListener {
    private medicine_data_input adaptee;
    medicine_data_input_jButton1_actionAdapter(medicine_data_input adaptee) {
        this.adaptee = adaptee;
    }

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

class medicine_data_input_jButton5_actionAdapter implements ActionListener {
    private medicine_data_input adaptee;
    medicine_data_input_jButton5_actionAdapter(medicine_data_input adaptee) {
        this.adaptee = adaptee;
    }

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