addgoods.java~8~

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

package com.aptech.classmarket;
import com.aptech.connection.*;
import java.sql.*;
public class Addgoods {
    public void add(Goods j){

//        Tosql tt=new Tosql();
//        Connection con=tt.tosql();
//        Jdbc jj=new Jdbc();
//        Connection con=jj.jdbcodbc();
        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 ex) {
            } catch (ClassNotFoundException ex) {
            }

        try {
            PreparedStatement ps = con.prepareStatement("insert into goods(goodsid,goodsname,address,vent,goodssort,unit,money,inprice,amount) values(?,?,?,?,?,?,?,?,?)");
            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.setString(6, j.unit);
            ps.setFloat(7, j.money);
            ps.setFloat(8, j.inprice);
            ps.setInt(9, j.amount);
            int i = ps.executeUpdate();
        } catch (SQLException ex) {
        }
    }
    public static void main(String[] args) {

    }
}