goodsframe.java~113~

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

           Goods g=new Goods();
           g.setgoodsid(id.toString());
           boolean flag =false;
           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){

      }

      else if(jRadioButton3.isSelected()==true){

      }
     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);
    }
}