servlet里的代码：Mapal=myCart.getMap();for(Map.Entryme:al.entrySet()){purchaseCarItemitem=me.getValue();sql="insertintoo...
servlet里的代码：
Map al = myCart.getMap();
for (Map.Entry me : al.entrySet()) {
purchaseCarItem item = me.getValue();
sql = "insert into orderInf(order_no,goods_name,goods_price,goods_amount,username,user_contact,address,order_time,company_name,order_state,goods_count,small_type,introduct,spjine,spshul,goods_id,goods_num,unit_price,total_price) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, orderid);
pstmt.setString(2, item.getProducts().getProducts_name());
pstmt.setDouble(3, item.getProducts().getProducts_price());
pstmt.setDouble(4, item.getAmount());
pstmt.setString(5, user.getUsersname());
pstmt.setString(6, tel);
pstmt.setString(7, address);
pstmt.setString(8, sys_time);
pstmt.setString(9, "0");
pstmt.setString(10, "0");
pstmt.setDouble(11, item.getQuantity());
pstmt.setString(12, "1");
pstmt.setString(13, "1");
pstmt.setDouble(14, item.getAmount());
pstmt.setDouble(15, item.getQuantity());
pstmt.setInt(16, item.getProducts().getProducts_id());
pstmt.setFloat(17, (float) item.getQuantity());
pstmt.setDouble(18, item.getProducts().getProducts_price());
pstmt.setDouble(19, item.getAmount());
pstmt.executeUpdate();
}
提示事务(进程 ID 265)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。pstmt.executeUpdate();这一行~怎么回事
展开
转播
