updategoods.java

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

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();
        Tosql tt=new Tosql();
        Connection con=tt.tosql();
        try {
            PreparedStatement ps = con.prepareStatement(" update goods set goodsname=? where goodsid=?  update goods set address=? where goodsid=? update goods set vent=? where goodsid=? update goods set goodssort=? where goodsid=? update goods set inprice=? where goodsid=? update goods set amount=? where goodsid=? update goods set goodsid=? where goodsid=?");

            ps.setString(1, j.goodsname);
            ps.setString(2,i.toString());
            ps.setString(3, j.address);
            ps.setString(4,i.toString());
            ps.setString(5, j.vent);
            ps.setString(6,i.toString());
            ps.setString(7, j.goodssort);
            ps.setString(8,i.toString());
            ps.setFloat(9, j.inprice);
            ps.setString(10,i.toString());
            ps.setInt(11, j.amount);
            ps.setString(12,i.toString());
            ps.setString(13, j.goodsid);
            ps.setString(14,i.toString());
            int o = ps.executeUpdate();
        } catch (SQLException ex) {
        }

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

    }
}