goodsframe.java

超市管理系统 运行环境JDK1.4以上 JB2006 源代码公开

        Selectgoodsid ss = new Selectgoodsid();
        flag = ss.select(g);

        if (flag == true) {

            Goods good = new Goods();
            Object id1 = jTable2.getValueAt(row, 0);
            Object name = jTable2.getValueAt(row, 1);
            Object address = jTable2.getValueAt(row, 2);
            Object vent = jTable2.getValueAt(row, 3);
            Object sort = jTable2.getValueAt(row, 4);
            Object inprice = jTable2.getValueAt(row, 5);
            Object amount = jTable2.getValueAt(row, 6);
            good.setgoodsid(id1.toString());
            good.setgoodsname(name.toString());
            good.setaddress(address.toString());
            good.setvent(vent.toString());
            good.setgoodssort(sort.toString());
            good.setinprice(Float.parseFloat(inprice.toString()));
            good.setamount(Integer.parseInt(amount.toString()));
            Updategoods up = new Updategoods();
            up.update(good, id);
            jop.showMessageDialog(this, "修改成功", "系统提示",
                                  JOptionPane.INFORMATION_MESSAGE);
        } else {
            jop.showMessageDialog(this, "商品编号不存在", "系统提示",
                                  JOptionPane.ERROR_MESSAGE);
        }

    }

    public void jButton4_actionPerformed(ActionEvent e) {
//        Connection con = null;
//        try {
//            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//            con = DriverManager.getConnection(
//                    "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Market;",
//                    "sa", "sa");
//        } catch (SQLException ex1) {
//        } catch (ClassNotFoundException ex1) {
//        }
//        Jdbc jj=new Jdbc();
//        Connection con=jj.jdbcodbc();
        Tosql tt = new Tosql();
        Connection con = tt.tosql();
        try {
            PreparedStatement ps = con.prepareStatement(
                    "select * from goods");
            ResultSet rs = ps.executeQuery();
            int i = 0;
            while (rs.next()) {
                rs.getString(1);
                jTable1.setValueAt(rs.getString(2), i, 0);
                jTable1.setValueAt(rs.getString(3), i, 1);
                jTable1.setValueAt(rs.getString(4), i, 2);
                jTable1.setValueAt(rs.getString(5), i, 3);
                jTable1.setValueAt(rs.getString(6), i, 4);
                rs.getString(7);
                rs.getFloat(8);
                jTable1.setValueAt(rs.getFloat(9), i, 5);
                jTable1.setValueAt(rs.getInt(10), i, 6);
                i++;
            }
        } catch (SQLException ex) {
        }
    }

    public void jButton6_actionPerformed(ActionEvent e) {
//        Jdbc jj=new Jdbc();
//        Connection con=jj.jdbcodbc();
        Tosql tt = new Tosql();
        Connection con = tt.tosql();
        try {
            PreparedStatement ps = con.prepareStatement(
                    "select * from goods");
            ResultSet rs = ps.executeQuery();
            int i = 0;
            while (rs.next()) {
                rs.getString(1);
                jTable2.setValueAt(rs.getString(2), i, 0);
                jTable2.setValueAt(rs.getString(3), i, 1);
                jTable2.setValueAt(rs.getString(4), i, 2);
                jTable2.setValueAt(rs.getString(5), i, 3);
                jTable2.setValueAt(rs.getString(6), i, 4);
                rs.getString(7);
                rs.getFloat(8);
                jTable2.setValueAt(rs.getFloat(9), i, 5);
                jTable2.setValueAt(rs.getInt(10), i, 6);
                i++;
            }
        } catch (SQLException ex) {
        }

    }

    public void jButton5_actionPerformed(ActionEvent e) {
        int row = 0;
        row = jTable1.getSelectedRow();
        Object id = jTable1.getValueAt(row, 0);
        Goods good = new Goods();
        good.setgoodsid(id.toString());
        boolean flag = false;
        Selectgoodsid ss = new Selectgoodsid();
        flag = ss.select(good);
        if (flag == true) {
            jop.showMessageDialog(this, "删除成功", "系统提示",
                                  JOptionPane.INFORMATION_MESSAGE);
            Deletegoods de = new Deletegoods();
            de.delete(id);
        } else {
            jop.showMessageDialog(this, "商品编号不存在", "系统提示",
                                  JOptionPane.ERROR_MESSAGE);
        }
    }

    public void jButton2_actionPerformed(ActionEvent actionEvent) {
        this.dispose();
    }

    public void jButton9_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void jButton8_actionPerformed(ActionEvent e) {
        Tosql tt = new Tosql();
        Connection con = tt.tosql();
        if (jRadioButton1.isSelected() == true) {
            String str1 = jop.showInputDialog(this, "请输入商品类别");
            try {
                PreparedStatement ps = con.prepareStatement(
                        "select * from goods where goodssort=?");
                ps.setString(1, str1);
                ResultSet rs = ps.executeQuery();
                int i = 0;
                while (rs.next()) {
                    rs.getString(1);
                    jTable3.setValueAt(rs.getString(2), i, 0);
                    jTable3.setValueAt(rs.getString(3), i, 1);
                    jTable3.setValueAt(rs.getString(4), i, 2);
                    jTable3.setValueAt(rs.getString(5), i, 3);
                    jTable3.setValueAt(rs.getString(6), i, 4);
                    rs.getString(7);
                    rs.getFloat(8);
                    jTable3.setValueAt(rs.getFloat(9), i, 5);
                    jTable3.setValueAt(rs.getInt(10), i, 6);
                    i++;

                }
            } catch (SQLException ex) {
            }
        } else if (jRadioButton2.isSelected() == true) {

                String str2 = jop.showInputDialog(this, "请输入商品编号");
                try {
                    PreparedStatement ps = con.prepareStatement(
                            "select * from goods where goodsid=?");
                    ps.setString(1, str2);
                    ResultSet rs = ps.executeQuery();
                    int i = 0;
                    while (rs.next()) {
                        rs.getString(1);
                        jTable3.setValueAt(rs.getString(2), i, 0);
                        jTable3.setValueAt(rs.getString(3), i, 1);
                        jTable3.setValueAt(rs.getString(4), i, 2);
                        jTable3.setValueAt(rs.getString(5), i, 3);
                        jTable3.setValueAt(rs.getString(6), i, 4);
                        rs.getString(7);
                        rs.getFloat(8);
                        jTable3.setValueAt(rs.getFloat(9), i, 5);
                        jTable3.setValueAt(rs.getInt(10), i, 6);
                        i++;

                    }
                } catch (SQLException ex) {
                }

            }

            else if (jRadioButton3.isSelected() == true) {
                String str3 = jop.showInputDialog(this, "请输入商品名称");
              try {
                  PreparedStatement ps = con.prepareStatement(
                          "select * from goods where goodsname=?");
                  ps.setString(1, str3);
                  ResultSet rs = ps.executeQuery();
                  int i = 0;
                  while (rs.next()) {
                      rs.getString(1);
                      jTable3.setValueAt(rs.getString(2), i, 0);
                      jTable3.setValueAt(rs.getString(3), i, 1);
                      jTable3.setValueAt(rs.getString(4), i, 2);
                      jTable3.setValueAt(rs.getString(5), i, 3);
                      jTable3.setValueAt(rs.getString(6), i, 4);
                      rs.getString(7);
                      rs.getFloat(8);
                      jTable3.setValueAt(rs.getFloat(9), i, 5);
                      jTable3.setValueAt(rs.getInt(10), i, 6);
                      i++;

                  }
              } catch (SQLException ex) {
              }

            } else {
                jop.showMessageDialog(this, "请选择查询类别", "系统提示",
                                      JOptionPane.ERROR_MESSAGE);
            }

        }
    }


    class GoodsFrame_jButton8_actionAdapter implements ActionListener {
        private GoodsFrame adaptee;
        GoodsFrame_jButton8_actionAdapter(GoodsFrame adaptee) {
            this.adaptee = adaptee;
        }

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


    class GoodsFrame_jButton9_actionAdapter implements ActionListener {
        private GoodsFrame adaptee;
        GoodsFrame_jButton9_actionAdapter(GoodsFrame adaptee) {
            this.adaptee = adaptee;
        }

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


    class GoodsFrame_jButton2_actionAdapter implements ActionListener {
        private GoodsFrame adaptee;
        GoodsFrame_jButton2_actionAdapter(GoodsFrame adaptee) {
            this.adaptee = adaptee;
        }

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


    class GoodsFrame_jButton7_actionAdapter implements ActionListener {
        private GoodsFrame adaptee;
        GoodsFrame_jButton7_actionAdapter(GoodsFrame adaptee) {
            this.adaptee = adaptee;
        }

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


    class GoodsFrame_jButton5_actionAdapter implements ActionListener {
        private GoodsFrame adaptee;
        GoodsFrame_jButton5_actionAdapter(GoodsFrame adaptee) {
            this.adaptee = adaptee;
        }

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


    class GoodsFrame_jButton6_actionAdapter implements ActionListener {
        private GoodsFrame adaptee;
        GoodsFrame_jButton6_actionAdapter(GoodsFrame adaptee) {
            this.adaptee = adaptee;
        }

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


    class GoodsFrame_jButton4_actionAdapter implements ActionListener {
        private GoodsFrame adaptee;
        GoodsFrame_jButton4_actionAdapter(GoodsFrame adaptee) {
            this.adaptee = adaptee;
        }

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


    class GoodsFrame_jButton1_actionAdapter implements ActionListener {
        private GoodsFrame adaptee;
        GoodsFrame_jButton1_actionAdapter(GoodsFrame adaptee) {
            this.adaptee = adaptee;
        }

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