updategoods.java~2~

来自「超市管理系统 运行环境JDK1.4以上 JB2006 源代码公开」· JAVA~2~ 代码 · 共 24 行

package com.aptech.classmarket;
import java.sql.*;
import com.aptech.connection.*;
public class Updategoods {
    public void update(Goods j,Object i){
        Jdbc jj=new Jdbc();
        Connection con=jj.jdbcodbc();
        PreparedStatement ps = con.prepareStatement("update goods set goodsid=? and goodsname=? and address=? and vent=? and goodssort=? and and inprice=? and amount=? where goodsid=?");
        ps.setString(1, j.goodsid);
        ps.setString(2, j.goodsname);
        ps.setString(3, j.address);
        ps.setString(4, j.vent);
        ps.setString(5, j.goodssort);
        ps.setFloat(6, j.inprice);
        ps.setInt(7, j.amount);
        ps.setString(8,i.toString());
        int o = ps.executeUpdate();

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

    }
}