应该还有更简单的方法
但是我不晓得
A表 :通过订单编号 查询数据获得
B表 :通过A表中的字段查询遍历获得
问题: 手动输入文本框内容 保存到数据库
|
<form id="forme" action="${pageContext.request.contextPath }/business/businessOfferSubmit" method="post" class="form-horizontal" role="form">
/*判断 文本框内容*/ <script type="text/javascript">
|
controller层-->service层-->serviceimpl层-->mapper层-->mapperprovider层
| @RequestMapping(value="/businessOfferSubmit") public String editBusinessOffer(@RequestParam Map<String, Object> businessOffer,HttpServletRequest req) { LOGGER.debug("编辑业务处理："+businessOffer); System.out.println(businessOffer); try { Map<String, Object> resultBusinessOffer = businessOfferService.editBusinessOffer(businessOffer); if (resultBusinessOffer!=null) { req.setAttribute("businessOffer_edit_msg", "业务处理成功"); }else { req.setAttribute("businessOffer_edit_msg", "10010-业务处理失败"); } } catch (Exception e) { req.setAttribute("businessOffer_edit_msg", "10009-业务处理更新失败-未知异常"); e.printStackTrace(); } //编辑后跳回到编辑页面 return "forward:/business/toBusinessOfferList/1"; } |
controller层-->service层-->serviceimpl层-->mapper层-->mapperprovider层
| /** * 编辑模块 * @param businessOffer * @return */ Map<String, Object> editBusinessOffer(Map<String, Object> businessOffer); |
controller层-->service层-->serviceimpl层-->mapper层-->mapperprovider层
|
@Override //将A表输入的数据 更新 数据库 //通过 订单编号 查询 货物清单 //遍历 查询到的数据 并更新 //通过拼接字符串 获得到 页面传回来 的name属性的值 |
controller层-->service层-->serviceimpl层-->mapper层-->mapperprovider层
|
/** /** |
controller层-->service层-->serviceimpl层-->mapper层-->mapperprovider层
| public String updateForNotNull(Map<String, Object> modular) { //1.构建公共的SQL语句 String sql="UPDATE tb_basic_order SET "; //2.构建SQL动态语句 StringBuilder builder=new StringBuilder(sql); if (modular.get("volume_rate")!=null) { builder.append("volume_rate=#{volume_rate},"); } if (modular.get("weight_rate")!=null) { builder.append("weight_rate=#{weight_rate},"); } if (modular.get("take_charge")!=null) { builder.append("take_charge=#{take_charge},"); } if (modular.get("order_status")!=null) { builder.append("order_status=3,"); } //删除最后一个逗号 builder.delete(builder.length()-1, builder.length()); //追加条件 builder.append(" WHERE order_id=#{order_id}"); //3.返回SQL语句 return builder.toString(); } public String updateGood(Map<String, Object> businessOffer) { //1.构建公共的SQL语句 String sql="UPDATE tb_basic_good SET "; //2.构建SQL动态语句 StringBuilder builder=new StringBuilder(sql); if (businessOffer.get("good_volume")!=null) { builder.append("good_volume=#{good_volume},"); } if (businessOffer.get("good_weigth")!=null) { builder.append("good_weigth=#{good_weigth},"); } //删除最后一个逗号 builder.delete(builder.length()-1, builder.length()); //追加条件 builder.append(" WHERE good_id=#{good_id}"); //3.返回SQL语句 return builder.toString(); } |
项目遇到的问题:页面c:forEach循环的数据进行计算传回后台并保持到数据库
原文：https://www.cnblogs.com/aknife/p/11140714.html