|
发表于 2017-2-18 08:28:42
|
显示全部楼层
可以看看起步给出的主从保存案例呀
- private static void saveMasterDetail(ServletRequest request, ServletResponse response) throws ParseException, SQLException, NamingException {
- // 参数序列化
- JSONObject params = (JSONObject) JSONObject.parse(request.getParameter("params"));
- // 获取参数
- JSONObject userData = params.getJSONObject("userData");
- JSONObject orderData = params.getJSONObject("orderData");
- // 转换Table
- Table userTable = Transform.jsonToTable(userData);
- Table orderTable = Transform.jsonToTable(orderData);
- Connection conn = Util.getConnection(DATASOURCE_TAKEOUT);
- try {
- conn.setAutoCommit(false);
- try {
- // 排除不能保存的列
- Collection<String> userColumns = userTable.getColumnNames();
- userColumns.remove("orderCount");
- // 一个事务内同时保存多张表
- Util.saveData(conn, userTable, TABLE_TAKEOUT_USER, userColumns);
- Util.saveData(conn, orderTable, TABLE_TAKEOUT_ORDER);
-
- conn.commit();
- } catch (SQLException e) {
- conn.rollback();
- throw e;
- }
- } finally {
- conn.close();
- }
- }
-
复制代码 |
|