Map<String, Object> map = new HashMap<String, Object>(); map.put("createdateGt",tbOrderInfo.getCreatedateGt()); map.put("createdateLt",tbOrderInfo.getCreatedateLt()); map.put("saleOrderId",tbOrderInfo.getSaleOrderId()); map.put("hm",tbOrderInfo.getHm()); map.put("orderDetail",tbOrderInfo.getOrderDetail()); map.put("cityCode",tbOrderInfo.getCityCode()); map.put("status",tbOrderInfo.getStatus()); map.put("areaCode",tbOrderInfo.getAreaCode()); map.put("orderType",tbOrderInfo.getOrdertype()); page= tbOrderInfoService.findByPage(map, page); for (TbOrderInfo orderInfo1 : page.getItems()) { List<Map<String, Object>> usermap = tbUserInfoService.findCustom("select * from tb_User_Info where (username = #{p[0]} or phone =#{p[0]}) and isDelete = 0", new Object[]{orderInfo1.getDistribId()}); if (!usermap.isEmpty()) { orderInfo1.setJson(new JSONObject().fluentPut("area2", usermap.get(0).get("AREA2"))); } } for (TbOrderInfo orderInfo1 : page.getItems()) { List<Map<String, Object>> usermap = tbUserInfoService.findCustom("select * from tb_User_Info where (username = #{p[0]} or phone =#{p[0]}) and isDelete = 0", new Object[]{orderInfo1.getDistribId()}); if (!usermap.isEmpty()) { orderInfo1.setJson(new JSONObject().fluentPut("level", usermap.get(0).get("level"))); } }怎么改,不要findCustom并且改为list
时间: 2024-04-11 11:28:38 浏览: 193
要将代码中的 `findCustom` 方法替换为使用 `List`,你可以使用 `JdbcTemplate` 类提供的 `queryForList` 方法来执行 SQL 查询并返回结果列表。下面是修改后的代码示例:
```java
Map<String, Object> map = new HashMap<String, Object>();
map.put("createdateGt", tbOrderInfo.getCreatedateGt());
map.put("createdateLt", tbOrderInfo.getCreatedateLt());
map.put("saleOrderId", tbOrderInfo.getSaleOrderId());
map.put("hm", tbOrderInfo.getHm());
map.put("orderDetail", tbOrderInfo.getOrderDetail());
map.put("cityCode", tbOrderInfo.getCityCode());
map.put("status", tbOrderInfo.getStatus());
map.put("areaCode", tbOrderInfo.getAreaCode());
map.put("orderType", tbOrderInfo.getOrdertype());
page = tbOrderInfoService.findByPage(map, page);
for (TbOrderInfo orderInfo1 : page.getItems()) {
List<Map<String, Object>> usermap = jdbcTemplate.queryForList("select * from tb_User_Info where (username = ? or phone = ?) and isDelete = 0", orderInfo1.getDistribId(), orderInfo1.getDistribId());
if (!usermap.isEmpty()) {
orderInfo1.setJson(new JSONObject().fluentPut("area2", usermap.get(0).get("AREA2")));
}
}
for (TbOrderInfo orderInfo1 : page.getItems()) {
List<Map<String, Object>> usermap = jdbcTemplate.queryForList("select * from tb_User_Info where (username = ? or phone = ?) and isDelete = 0", orderInfo1.getDistribId(), orderInfo1.getDistribId());
if (!usermap.isEmpty()) {
orderInfo1.setJson(new JSONObject().fluentPut("level", usermap.get(0).get("level")));
}
}
```
在上述修改后的代码中,我们使用 `jdbcTemplate.queryForList` 方法执行 SQL 查询,并将结果存储在 `List<Map<String, Object>>` 中。注意,我们使用 `?` 占位符来代替参数值,并在方法调用中传递参数值。这样可以保证查询语句的安全性,并避免 SQL 注入攻击的风险。
阅读全文
相关推荐


















