insertoutgoods.java

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

package com.aptech.classmarket;
import com.aptech.connection.*;
import java.sql.*;
public class Insertoutgoods {
    public boolean insert(Outgoods j){
        Tosql tt = new Tosql();
        Connection con = tt.tosql();
        boolean flag = false;
        try {
            PreparedStatement ps = con.prepareStatement("insert into outgoods(stocksid,goodsid,goodsname,address,vent,goodssort,unit,inprice,amount,outtime,beizhu) values(?,?,?,?,?,?,?,?,?,?,?)");
            ps.setString(1, j.stocksid);
            ps.setString(2, j.goodsid);
            ps.setString(3, j.goodsname);
            ps.setString(4, j.address);
            ps.setString(5, j.vent);
            ps.setString(6, j.goodssort);
            ps.setString(7, j.unit);
            ps.setFloat(8, j.inprice);
            ps.setInt(9, j.amount);
            ps.setString(10, j.outtime);
            ps.setString(11, j.beizhu);
            int i = ps.executeUpdate();
            if (i > 0) {
                flag = true;
            }
        } catch (SQLException ex) {
        }
        return flag;
    }
        public static void main(String[] args) {

        }
    }