1.在mapper.java 声明执行拼接SQL的方法;
List<Map<String, Object>> getListCommon(@Param(value = "sqlStr") String sqlStr); |
2.在mapper.xml中定义执行拼接SQL的方法;
<select id="getListCommon" parameterType="String" resultType="java.util.Map"> ${sqlStr} </select> |
3.在controller层拼接SQL,并调用mapper层声明的执行拼接SQL的方法,并获取返回结果。
@PostMapping("/api/getQueryContent") public ResultInfo getQueryContent() { Map<String, Object> map = new HashMap<>(); try { String sql ="select * from a"; List<Map<String, Object>> listCommon = commonMapper.getListCommon(sql); map.put("datas",listCommon); return ResultInfo.ok(map); } catch (Exception e) { return ResultInfo.error(901,"查询失败"); } } |