reg_medicine.java~13~

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

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

    public static void main(String[] args)
    {
        new Reg_Medicine();
    }

    public void init_table()
    {
        header = new Vector();
        header.addElement("订单号");
        header.addElement("药品编号");
        header.addElement("药品名称");
        header.addElement("入库数量");
        header.addElement("供应商");
        header.addElement("订购日期");
        tableModel1 = new DefaultTableModel(header,0);
        jTable1.setModel(tableModel1);
        for(int i= 0;i<6;i++)
        jTable1.getColumnModel().getColumn(i).setPreferredWidth(100);
    }

    public void add_table_data(String Order)
    {
        try
           {
               Connection con = DriverManager.getConnection(conURL, Username,
                       Password);
               Statement s = con.createStatement();
               ResultSet rs = s.executeQuery(Order);
               while(rs.next())
               {
                   data = new Vector();
                   data.addElement(rs.getString(1));
                   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));
                   tableModel1.addRow(data);
               }
               jTable1.setModel(tableModel1);
               rs.close();
               con.close();
           }
           catch(SQLException ex)
           {
               JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
           }
    }

    public void jButton1_actionPerformed(ActionEvent e)
    {
        if(jTextField1.getText().equals("")||jTextField3.getText().equals("")
           ||jTextField4.getText().equals("")||jTextField5.getText().equals(""))
        {
            JOptionPane.showMessageDialog(null,"  请输入还没填入的数据 ","系统提示!",
                     JOptionPane.WARNING_MESSAGE);
        }
        else
        {
            try
            {
                Connection con = DriverManager.getConnection(conURL,Username,Password);
                Statement s= con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
                ResultSet rs = s.executeQuery("select 药品编号,药品名称 from Medicine_Data where 药品编号 ='"
                                               +jTextField1.getText()+"'");
               if(rs.next()==false)
                {
                    JOptionPane.showMessageDialog(null,"资料库中没有编号为 '"+jTextField1.getText()+" ' 的药品"+'\n'
                                                  +"请先到资料库添加此药品的资料","系统提示",JOptionPane.WARNING_MESSAGE);
                    medicine_data_input mdi = new medicine_data_input();
                    mdi.jButton1.setEnabled(false);
                    mdi.jTextField9.setText("0");
                    mdi.jTextField6.setText("0.0");
                    mdi.jTextField8.setText("0.0");
                    mdi.jTextField6.setEnabled(false);
                    mdi.jTextField8.setEnabled(false);
                    mdi.jTextField9.setEnabled(false);
                    //rs.beforeFirst();
                }
                else
                {
                    jTextField2.setText(rs.getString(2));
                    String sql = "insert into Medicine_Buy values('"
                                 +jTextField4.getText()+"','"+jTextField1.getText()+"','"
                                 +jTextField2.getText()+"',"+jTextField3.getText()+",'"
                                 +jComboBox1.getSelectedItem().toString()+"','"+jTextField5.getText()+"')";
                    DB_Update(sql);
                    data = new Vector();
                    data.addElement(jTextField4.getText());
                    data.addElement(jTextField1.getText());
                    data.addElement(jTextField2.getText());
                    data.addElement(jTextField3.getText());
                    data.addElement(jComboBox1.getSelectedItem().toString());
                    data.addElement(jTextField5.getText());
                    tableModel1.addRow(data);
                    jTable1.setModel(tableModel1);
                    //JOptionPane.showMessageDialog(null," 操作成功 ","系统提示!",JOptionPane.WARNING_MESSAGE);

                    try                 //获取库存量,并加上购买量
                    {
                        Connection con3 = DriverManager.getConnection(conURL,Username,Password);
                        Statement s3= con3.createStatement();
                        String get_kucun = "select * from Medicine_Data where 药品编号='"+jTextField1.getText()+"'";
                        ResultSet rs3 = s3.executeQuery(get_kucun);
                        rs3.next();
                        kucun_tianjia = rs3.getInt("库存量") + Integer.parseInt(jTextField3.getText());
                        s3.close();
                        con3.close();
                        JOptionPane.showMessageDialog(null, " 操作成功 ", "系统提示!",
                                          JOptionPane.WARNING_MESSAGE);
                    }
                    catch(SQLException ex)
                    {
                        JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
                    }
                    String Reset_kucun = "update Medicine_Data set 库存量=" + kucun_tianjia
                                            +"where 药品编号='"+jTextField1.getText()+"'";
                    DB_Update(Reset_kucun);
                    JOptionPane.showMessageDialog(null," 库存量更新成功 ","系统提示!",JOptionPane.WARNING_MESSAGE);
                }
                rs.close();
                s.close();
                con.close();
            }
            catch(SQLException ex)
            {
                JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告4444444!",JOptionPane.WARNING_MESSAGE);
            }
        }
    }

    public void jButton3_actionPerformed(ActionEvent e)
    {
        init_table();
        Order = "select * from Medicine_Buy order by 订单号";
        add_table_data(Order);
    }

    public void jButton4_actionPerformed(ActionEvent e)
    {
        init_table();
        Order = "select * from Medicine_Buy order by 订购日期";
        add_table_data(Order);
    }

    public void jButton5_actionPerformed(ActionEvent e)
    {
        init_table();
        Order = "select * from Medicine_Buy order by 供应商";
        add_table_data(Order);
    }

    public void jButton2_actionPerformed(ActionEvent e)
    {
        jTextField1.setText("");
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField4.setText("");
        jTextField5.setText("");
    }
}


class Reg_Medicine_jButton2_actionAdapter implements ActionListener {
    private Reg_Medicine adaptee;
    Reg_Medicine_jButton2_actionAdapter(Reg_Medicine adaptee) {
        this.adaptee = adaptee;
    }

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


class Reg_Medicine_jButton5_actionAdapter implements ActionListener {
    private Reg_Medicine adaptee;
    Reg_Medicine_jButton5_actionAdapter(Reg_Medicine adaptee) {
        this.adaptee = adaptee;
    }

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


class Reg_Medicine_jButton4_actionAdapter implements ActionListener {
    private Reg_Medicine adaptee;
    Reg_Medicine_jButton4_actionAdapter(Reg_Medicine adaptee) {
        this.adaptee = adaptee;
    }

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


class Reg_Medicine_jButton3_actionAdapter implements ActionListener {
    private Reg_Medicine adaptee;
    Reg_Medicine_jButton3_actionAdapter(Reg_Medicine adaptee) {
        this.adaptee = adaptee;
    }

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


class Reg_Medicine_jButton1_actionAdapter implements ActionListener {
    private Reg_Medicine adaptee;
    Reg_Medicine_jButton1_actionAdapter(Reg_Medicine adaptee) {
        this.adaptee = adaptee;
    }

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