//添加訂單 public boolean addOrder(OrderInfo order){ StringBuilder sb = new StringBuilder(); //第一部分SQL語句 sb.append("insert into OrderInfo values (") .append(order.getCustomer().getId()) .append(",") .append(order.getStatus()) .append(",getdate()) "); //第二部分SQL語句 sb.append("declare @orderId int ") .append("select @orderId=@@identity "); ArrayList<OrderGoodsInfo> goodsList = order.getOrderDetails(); for(OrderGoodsInfo goodsDetail : goodsList){ sb.append("insert into OrderGoodsInfo values (@orderId,") .append(goodsDetail.getGoodsId().getGoodsId()) .append(",") .append(goodsDetail.getQuantity()) .append(") "); }