//添加订单
public boolean addOrder(Easybuy_order eo,List<Easybuy_order_detail> list){
boolean flag=false;
Connection con=BaseDao.getCon();
PreparedStatement sta=null;
PreparedStatement sta1=null;
PreparedStatement sta2=null;
ResultSet rs=null;
String sql="insert into Easybuy_order values (?,?,?,default,?,1,1) select SCOPE_IDENTITY() as id";
try {
//设置自动提交为假
con.setAutoCommit(false);
//添加订单
sta=con.prepareStatement(sql);
sta.setString(1, eo.getEo_user_id());
sta.setString(2, eo.getEo_user_name());
sta.setString(3, eo.getEo_user_address());
sta.setDouble(4, eo.getEo_cost());
rs =sta.executeQuery();
rs.next();
int id = rs.getInt(1);
//添加订单详情
for (Easybuy_order_detail eod : list) {
String sql3="insert into Easybuy_order_detail values(?,?,?,?)";
sta1=con.prepareStatement(sql3);
sta1.setInt(1, id);
sta1.setInt(2,eod.getEp_id());
sta1.setInt(3,eod.getEod_quantity());
sta1.setDouble(4,eod.getEod_cost());
sta1.executeUpdate();
//修改产品库存
String sql2 ="update easybuy_product set ep_stock = ep_stock - ? where ep_id = ?";
sta2 = con.prepareStatement(sql2);
sta2.setInt(1, eod.getEod_quantity());
sta2.setInt(2, eod.getEp_id());
sta2.executeUpdate();
}
//提交
con.commit();
flag = true;
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally{
try {
//还原自动提交为真
con.setAutoCommit(true);
} catch (SQLException e) {
e.printStackTrace();
}
BaseDao.closeAll(rs, sta, con);
BaseDao.closeAll(null, sta1, null);
}
return flag;
}
商城之添加订单,jdbc事务,获取刚插入的标识列
最新推荐文章于 2022-07-29 11:58:37 发布