medicine_data_input.java~177~

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

        jLabel32.setForeground(Color.black);
        jLabel32.setText("药品编号");
        jLabel33.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jLabel33.setForeground(Color.black);
        jLabel33.setText("药品名称");
        jTextArea1.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        jTextArea1.setForeground(Color.black);
        jTextArea1.setBorder(BorderFactory.createEtchedBorder());
        jTextArea1.setLineWrap(true);
        jLabel30.setIcon(pic);
        jPanel5.setBackground(new Color(236, 233, 173));
        jPanel5.setMinimumSize(new Dimension(10, 200));
        jPanel5.setOpaque(false);
        jPanel5.setPreferredSize(new Dimension(10, 200));
        jPanel5.setLayout(xYLayout3);
        jPanel4.setLayout(borderLayout3);
        jScrollPane1.setHorizontalScrollBarPolicy(JScrollPane.
                                                  HORIZONTAL_SCROLLBAR_ALWAYS);
        jLabel15.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel15.setForeground(Color.green);
        jLabel15.setText("请输入查询条件");
        jButton5.addActionListener(new
                                   medicine_data_input_jButton5_actionAdapter(this));
        jButton6.addActionListener(new
                                   medicine_data_input_jButton6_actionAdapter(this));
        jLabel17.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jLabel17.setForeground(Color.green);
        jLabel17.setText("库存量大于或等于");
        jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        jButton1.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton2.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton3.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton4.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton5.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton5.setIcon(null);
        jButton5.setText("查  询");
        jButton6.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton6.setIcon(null);
        jButton6.setText("取  消");
        jButton7.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton8.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton8.setIcon(null);
        jButton8.setText("查  询");
        jButton8.addActionListener(new
                                   medicine_data_input_jButton8_actionAdapter(this));
        jLabel16.setForeground(Color.green);
        jLabel16.setText("精确查询");
        jLabel18.setForeground(Color.green);
        jLabel18.setText("分类查询");
        jTextField10.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jTextField22.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jTextField23.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jTextField28.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jTextField13.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jTextField11.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jTextField12.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jPanel9.setLayout(borderLayout2);
        jLabel19.setIcon(bg);
        this.getContentPane().add(jTabbedPane1, java.awt.BorderLayout.CENTER);
        jPanel1.add(jTextField6, new XYConstraints(472, 167, 148, 25));
        jPanel1.add(jLabel1, new XYConstraints(16, 66, 66, 34));
        jPanel1.add(jTextField1, new XYConstraints(125, 71, 148, 25));
        jPanel1.add(jLabel2, new XYConstraints(16, 114, 66, 34));
        jPanel1.add(jTextField2, new XYConstraints(125, 119, 148, 25));
        jPanel1.add(jLabel3, new XYConstraints(16, 162, 66, 34));
        jPanel1.add(jTextField3, new XYConstraints(125, 167, 148, 25));
        jPanel1.add(jLabel13, new XYConstraints(16, 210, 66, 34));
        jPanel1.add(jComboBox1, new XYConstraints(125, 215, 148, 25));
        jPanel1.add(jLabel8, new XYConstraints(16, 258, 66, 34));
        jPanel1.add(jComboBox2, new XYConstraints(125, 263, 148, 25));
        jPanel1.add(jLabel4, new XYConstraints(16, 306, 66, 34));
        jPanel1.add(jComboBox3, new XYConstraints(125, 311, 148, 25));
        jPanel1.add(jComboBox4, new XYConstraints(125, 359, 148, 25));
        jPanel1.add(jLabel5, new XYConstraints(16, 354, 66, 34));
        jPanel1.add(jLabel6, new XYConstraints(358, 66, 66, 34));
        jPanel1.add(jLabel9, new XYConstraints(358, 114, 66, 34));
        jPanel1.add(jLabel12, new XYConstraints(358, 162, 66, 34));
        jPanel1.add(jLabel10, new XYConstraints(358, 210, 66, 34));
        jPanel1.add(jLabel11, new XYConstraints(358, 258, 66, 34));
        jPanel1.add(jTextField9, new XYConstraints(472, 311, 148, 25));
        jPanel1.add(jTextField8, new XYConstraints(472, 263, 148, 25));
        jPanel1.add(jTextField7, new XYConstraints(472, 215, 148, 25));
        jPanel1.add(jTextField5, new XYConstraints(472, 119, 148, 25));
        jPanel1.add(jTextField4, new XYConstraints(472, 71, 148, 25));
        jTabbedPane1.add(jPanel1, "数据录入");
        jPanel1.add(jPanel3, new XYConstraints(0, 0, 672, 54));
        jTabbedPane1.add(jPanel7, "数据删除");
        jPanel7.add(jPanel8, new XYConstraints(0, 0, 672, 54));
        jPanel8.add(jTextField23, new XYConstraints(270, 19, 105, 23));
        jPanel8.add(jLabel32, new XYConstraints(197, 22, -1, -1));
        jPanel8.add(jLabel33, new XYConstraints(388, 22, -1, -1));
        jPanel8.add(jTextField28, new XYConstraints(453, 19, 105, 23));
        jPanel7.add(jLabel30, new XYConstraints(183, 53, 488, 407));
        jTabbedPane1.add(jPanel2, "数据查询");
        jScrollPane1.getViewport().add(jTable1);
        jPanel7.add(jTextArea1, new XYConstraints(0, 53, 186, 410));
        jPanel8.add(jButton7, new XYConstraints(576, 15, -1, 31));
        jPanel1.add(jPanel6, new XYConstraints(0, 404, 671, 59));
        jPanel5.add(jLabel15, new XYConstraints(15, 16, -1, -1));
        jPanel1.add(jLabel7, new XYConstraints(367, 311, 49, 25));
        jPanel4.add(jScrollPane1, java.awt.BorderLayout.CENTER);
        jPanel5.add(jComboBox6, new XYConstraints(97, 46, -1, -1));
        jPanel5.add(jLabel16, new XYConstraints(25, 50, -1, -1));
        jPanel5.add(jLabel18, new XYConstraints(27, 104, -1, -1));
        jPanel5.add(jTextField12, new XYConstraints(199, 143, 136, 28));
        jPanel2.add(jPanel4, new XYConstraints(0, 0, 670, 260));
        jPanel2.add(jPanel5, new XYConstraints(0, 260, 673, 203));
        jPanel6.add(jButton3, new XYConstraints(430, 8, 90, 35));
        jPanel6.add(jButton4, new XYConstraints(545, 8, 90, 35));
        jPanel3.add(jButton1, new XYConstraints(480, 8, 90, 35));
        jPanel3.add(jButton2, new XYConstraints(574, 8, 90, 35));
        jPanel3.add(jTextField22, new XYConstraints(371, 14, 105, 23));
        jPanel3.add(jLabel31, new XYConstraints(296, 17, -1, -1));
        jPanel3.add(jTextField10, new XYConstraints(184, 14, 105, 23));
        jPanel3.add(jLabel14, new XYConstraints(111, 17, -1, -1));
        jPanel2.add(jPanel9, new XYConstraints(0, 260, 673, 203));
        jPanel9.add(jLabel19, java.awt.BorderLayout.CENTER);
        jPanel5.add(jTextField13, new XYConstraints(197, 43, 136, 28));
        jPanel5.add(jButton8, new XYConstraints(391, 40, 69, 34));
        jPanel5.add(jComboBox5, new XYConstraints(99, 100, -1, -1));
        jPanel5.add(jTextField11, new XYConstraints(198, 97, 136, 28));
        jPanel5.add(jButton5, new XYConstraints(393, 94, 69, 34));
        jPanel5.add(jLabel17, new XYConstraints(51, 149, -1, -1));
        jPanel5.add(jButton6, new XYConstraints(393, 140, 69, 34));
        header = new Vector();
        this.validate();
    }

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

    public void init_model()
    {
        header = new Vector();
        for(int i=0;i<header_name.length;i++)
        {
            header.addElement(header_name[i]);
        }
        tableModel1 = new DefaultTableModel(header,0);
        jTable1.setModel(tableModel1);
    }

    public void jButton1_actionPerformed(ActionEvent e)
        {
            if(jTextField10.getText().equals("")&&jTextField22.getText().equals(""))
            {
                JOptionPane.showMessageDialog(null,"不能修改空数据，请输入药品编号或药品名称进行修改!!!","系统提示",JOptionPane.ERROR_MESSAGE);
            }
            else
            {
                jButton2.setEnabled(false);
                if (jTextField10.getText().equals(""))
                    query = "SELECT * FROM Medicine_Data WHERE 药品名称 ='" +
                            jTextField22.getText() + "'";
                else if (jTextField22.getText().equals(""))
                    query = "SELECT * FROM Medicine_Data WHERE 药品编号 = '" +
                            jTextField10.getText() + "'";
                else
                    query = "SELECT * FROM Medicine_Data WHERE 药品名称 ='" +
                            jTextField22.getText() + "'AND 药品编号 = '" +
                            jTextField10.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.WARNING_MESSAGE);
                        jButton2.setEnabled(true);
                    }
                    else
                    {
                        jTextField1.setText(rs.getString(1));
                        jTextField2.setText(rs.getString(2));
                        jTextField3.setText(rs.getString(3));
                        jTextField4.setText(rs.getString(8));
                        jTextField5.setText(rs.getString(9));
                        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);
                        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 jButton2_actionPerformed(ActionEvent e)
        {
            if(jTextField10.getText().equals("")&&jTextField22.getText().equals(""))
            {
                JOptionPane.showMessageDialog(null,"请先填写药品编号 (必填)!!","系统提示!",
                                    JOptionPane.WARNING_MESSAGE);
            }
            else
            {
                if (jTextField10.getText().equals(""))
                    query = "SELECT * FROM Medicine_Data WHERE 药品名称 ='" +
                            jTextField22.getText() + "'";
                else if (jTextField22.getText().equals(""))
                    query = "SELECT * FROM Medicine_Data WHERE 药品编号 = '" +
                            jTextField10.getText() + "'";
                else
                    query = "SELECT * FROM Medicine_Data WHERE 药品名称 ='" +
                            jTextField22.getText() + "'AND 药品编号 = '" +
                            jTextField10.getText() + "'";
                try
                {
                    Connection con = DriverManager.getConnection(conURL, Username,
                            Password);
                    Statement stm = con.createStatement();
                    ResultSet rs = stm.executeQuery(query);
                    if (rs.next())
                    {
                        JOptionPane.showMessageDialog(null, "你所要添加的药品已存在！！", "请注意!",
                                                      JOptionPane.WARNING_MESSAGE);

                    }
                    else
                    {
                        jButton2.setEnabled(true);
                        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(false);
                        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());
                    }
                    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
        {
            new Load_DB_Driver();
            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);