public void insertOrder(OrderDTO orderDTO) throws PafaDAOException, IOException, SQLException{
Reader reader = Resources.getResourceAsReader("sqlmap-config.xml");
SqlMapClient sqlMap =SqlMapClientBuilder.buildSqlMapClient(reader);
System.out.println(null==sqlMap);//打印false
System.out.println(sqlMap.toString());//有打印对象地址
Map map=new HashMap();
map.put("orderId", orderDTO.getOrderID());
try {
sqlMap.startTransaction();
// 插入基本订单对象
sqlMap.insert("addAnBaseOrder", orderDTO);
// 插入订单对象的成员 List<GoodsBatchItemDTO> orderItemList;
for (GoodsBatchItemDTO anOrderItem : orderDTO.getOrderItemList()) {
map.put("pdctId", anOrderItem.getGdsDto().getPdctNO());
map.put("num", anOrderItem.getNum());
sqlMap.insert("addAnOrderItem", map);
}
// 插入基本订单对象 DistributionDTO distribution;
map.put("userId", orderDTO.getDistribution().getUserID());
map.put("address", orderDTO.getDistribution().getAddress());
map.put("phone", orderDTO.getDistribution().getPhone());
map.put("payMean", orderDTO.getDistribution().getPayMean());
sqlMap.insert("addDistribution", map);
sqlMap.commitTransaction();
} catch (Exception e) {
e.printStackTrace();
}
finally{
sqlMap.endTransaction();
}
}
Reader reader = Resources.getResourceAsReader("sqlmap-config.xml");
SqlMapClient sqlMap =SqlMapClientBuilder.buildSqlMapClient(reader);
System.out.println(null==sqlMap);//打印false
System.out.println(sqlMap.toString());//有打印对象地址
Map map=new HashMap();
map.put("orderId", orderDTO.getOrderID());
try {
sqlMap.startTransaction();
// 插入基本订单对象
sqlMap.insert("addAnBaseOrder", orderDTO);
// 插入订单对象的成员 List<GoodsBatchItemDTO> orderItemList;
for (GoodsBatchItemDTO anOrderItem : orderDTO.getOrderItemList()) {
map.put("pdctId", anOrderItem.getGdsDto().getPdctNO());
map.put("num", anOrderItem.getNum());
sqlMap.insert("addAnOrderItem", map);
}
// 插入基本订单对象 DistributionDTO distribution;
map.put("userId", orderDTO.getDistribution().getUserID());
map.put("address", orderDTO.getDistribution().getAddress());
map.put("phone", orderDTO.getDistribution().getPhone());
map.put("payMean", orderDTO.getDistribution().getPayMean());
sqlMap.insert("addDistribution", map);
sqlMap.commitTransaction();
} catch (Exception e) {
e.printStackTrace();
}
finally{
sqlMap.endTransaction();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货