项目需求：将购物车中的商品添加到订单表和订单商品表

附上购物车表，订单表和订单商品表字段

shopcartController代码：

@RequestMapping("useraddResult")
@ResponseBody
@SuppressWarnings("null")
public LBResult useraddResult(String addressid, String shopcartids,
String uid, HttpServletRequest request, HttpServletResponse response) {

// 1.
JifenAddressInfo addressInfo = jifenAddressInfoService
.userAddressInfo(addressid);

// 2.根据购物车id查询信息
String[] ids = shopcartids.split(",");
ShoppingCart[] cart = new ShoppingCart[ids.length];
BigDecimal ordersum = new BigDecimal(0);
for (int j = 0; j < ids.length; j++) {
cart[j] = carShopService.carById(ids[j]);
BigDecimal sumBigDecimal1 = cart[j].getLogisticsjifen();
BigDecimal sumBigDecimal2 = new BigDecimal(cart[j].getGoodsnum());
// ordersum = ordersum.add(sumBigDecimal1.multiply(sumBigDecimal2));
ordersum = BigDecimalCalculateUtil
.add(ordersum, BigDecimalCalculateUtil.mul(sumBigDecimal1,
sumBigDecimal2));
}

// 3.根据购物车id，更新购物车状态
List<String> ids1 = null;

if (ids.length > 0) {
List<String> idsList1 = Arrays.asList(ids);

ids1 = new ArrayList<String>(idsList1);
}

int count = carShopService.txbatchUpdateState(ids1);

// 4.生成订单编号

String ordercodeString = LBUtil.getOrderNumber();

// 5.根据订单编号、地址信息、订单总积分、uid，插入订单表

// 获得地址信息表中得字段
String provinceString = addressInfo.getProvince();
String cityString = addressInfo.getCity();
String countryString = addressInfo.getCounty();
String addressnameString = addressInfo.getAddressname();
String addresstelString = addressInfo.getAddresstel();
String addressdetailed = addressInfo.getAddressdetailed();

OrderDetail orderDetail = new OrderDetail();
orderDetail.setOrdercode(ordercodeString);
orderDetail.setOrderstatus("01");
orderDetail.setOrdersum(ordersum);
orderDetail.setId(UUIDGenerator.getUUID());
Date nowDate = DateUtil1.getFormatDate(new Date(),
"yyyy-MM-dd HH:mm:ss");
orderDetail.setCreatetime(nowDate);
orderDetail.setCity(cityString);
orderDetail.setAddressname(addressnameString);
orderDetail.setAddresstel(addresstelString);
orderDetail.setCounty(countryString);
orderDetail.setAddressid(addressid);
orderDetail.setAddressdetailed(addressdetailed);
orderDetailService.txInsert(orderDetail);
// 插入订单结束

// 6.根据订单编号、购物车信息，插入订单商品表

List<OrderGoods> orderGoodsList = new ArrayList<OrderGoods>();

for (int j = 0; j < cart.length; j++) {

OrderGoods orderGoods = new OrderGoods();
orderGoods.setId(UUIDGenerator.getUUID());
orderGoods.setOrdercode(ordercodeString);
orderGoods.setGoodsname(cart[j].getGoodsname());
orderGoods.setGoodscode(cart[j].getGoodscode());
orderGoods.setGoodsnum(cart[j].getGoodsnum());
orderGoods.setImgname(cart[j].getImgname());
orderGoods.setImgaccesspath(cart[j].getImgaccesspath());
orderGoods.setImgpath(cart[j].getImgpath());
orderGoods.setCreatetime(cart[j].getCreatetime());
orderGoodsList.add(orderGoods);
}

int countNum = orderGoodsService.txinsertByBatch(orderGoodsList);
return LBResult.ok(countNum);
}

useraddressInfo方法：

public JifenAddressInfo userAddressInfo(String id) {
// TODO Auto-generated method stub

JifenAddressInfo addressInfo =
jifenAddressInfoMapper.selectByPrimaryKey(id);
if (LBUtil.isNotEmpty(addressInfo)) {
return addressInfo;
}
return null;
}

批量更新方法：

<update id="batchUpdateState" parameterType="java.util.List">

update t_jifen_shoppingcart

<set>

shoppinggoodsstatus="09"

</set>

where id in

<foreach collection="list" item="item" index="index" open="(" close=")" separator=",">

#{item}

</foreach>

</update>

int batchUpdateState(List<String> ids);//mapper中的写法

serviceImpl层中得方法：

// 批量更新

public int txbatchUpdateState(List<String> ids) {

int count = carShopMapper.batchUpdateState(ids);

return count;
}

批量插入方法：

<insert id="insertByBatch" parameterType="java.util.List">
insert into
t_jifen_order_goods (id, ordercode, goodscode,
goodsname, goodsnum, imgname,
imgpath, imgaccesspath, createtime)
values
<foreach collection="list" item="item" index="index"
separator=",">
(#{item.id,jdbcType=VARCHAR},
#{item.ordercode,jdbcType=INTEGER},
#{item.goodscode,jdbcType=DECIMAL},
#{item.goodsname,jdbcType=VARCHAR},
#{item.goodsnum,jdbcType=INTEGER},
#{item.imgname,jdbcType=VARCHAR},
#{item.imgpath,jdbcType=VARCHAR},
#{item.imgaccesspath,jdbcType=VARCHAR},
#{item.createtime,jdbcType=TIMESTAMP}
)
</foreach>
</insert>

mapper中的写法：

int insertByBatch(List<OrderGoods> orderGoods);

service中得写法：

int txinsertByBatch(List<OrderGoods> orderGoods);

serviceImpl中得写法：

// 批量更新
public int txinsertByBatch(List<OrderGoods> orderGoods) {
int count = orderGoodsMapper.insertByBatch(orderGoods);
return count;
}

----------------------------------------------------结束------------------------------------------------------

原文链接：https://blog.csdn.net/u011277745/article/details/62871813