public int addOrder(Order order) throws Exception {  //实际上order只含有userIdDbUtil.getConn();User user = new User();user.setUserId(order.getUserId());ResultSet res = cartDao.findCartByUserId(user);  //查询该用户购物车List<Cart> cartList = new ArrayList<>();while(res.next()){Cart cart = new Cart();cart.setGoodsId(res.getInt(1));cart.setGoodsCode(res.getString(2));cart.setGoodsPic(res.getString(3));cart.setGoodsName(res.getString(4));cart.setGoodsPrice(res.getFloat(5));cart.setGoodsNum(res.getInt(6));cart.setCartId(res.getInt(7));cart.setUserId(res.getInt(8));  //用来区分订单的关键参数sell_id (商家id)  cartList.add(cart);}List<List<Cart>> list = new ArrayList<>();for(int i = 0; i < cartList.size(); i++){   //对购物车list进行遍历List<Cart> childList = new ArrayList<>();  if(cartList.get(i).getCartSize() != -1){cartList.get(i).setCartSize(-1);  //访问过该商品  做标记int sell_id = cartList.get(i).getUserId();  for(int j = i+1; j < cartList.size(); j++){  对当前访问商品之后商品进行对比if(sell_id == cartList.get(j).getUserId()){childList.add(cartList.get(j));  //相同sell_id的商品归类cartList.get(j).setCartSize(-1);  //访问过做标记}}childList.add(cartList.get(i));  //对添加最初的商品list.add(childList);  }}int count = 0;for(int i = 0; i < list.size(); i++){  //对已经按商家分类的list进行遍历String str = "0123456789";Random ran = new Random();StringBuffer sb = new StringBuffer();for(int j = 0; j < 16; j++){sb.append(str.charAt(ran.nextInt(str.length())));}String orderCode = sb.toString();  //随机生成编码Order newOrder = new Order();  newOrder.setOrderCode(orderCode);newOrder.setUserId(order.getUserId());newOrder.setOrderTime(new Date());newOrder.setOrderStatus(1);newOrder.setSell_id(list.get(i).get(0).getUserId());orderDao.addOrder(newOrder);for(int j = 0; j < list.get(i).size(); j++){  //对子列表商品进行遍历Order childOrder = new Order();childOrder.setOrderCode(orderCode);childOrder.setGoods_num(list.get(i).get(j).getGoodsNum());childOrder.setGoods_price(list.get(i).get(j).getGoodsPrice());if(addOrderList(childOrder, list.get(i).get(j).getGoodsId()) == 1){  //将子列表商品添加到同一个订单列表中count ++;}}}return count;}