首先写Sql语句(第一条新增商品信息,第二条新增商品库存信息)
Dao层新增:
@Override
public boolean insert(CommodityTableVo commodity) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
boolean boolR=false;
try {
conn = JdbcUtils.getConnection();
//将事务设置为手动提交
conn.setAutoCommit(false);
ps=conn.prepareStatement(InsertCommodity, Statement.RETURN_GENERATED_KEYS);
ps.setString(1,commodity.getInvoicesNo());
ps.setString(2,commodity.getCommodityName());
ps.setInt(3,commodity.getCommodityTypeId());
ps.setString(4,commodity.getPicture());
ps.setString(5,commodity.getBarCode());
ps.setString(6,commodity.getSpecification());
ps.setInt(7,commodity.getUnitsId());
ps.setString(8,commodity.getUnitsWeight());
ps.setString(9,commodity.getRemark());
ps.setByte(10,commodity.getIsEnable());
ps.setSt