xml: <select id="getData" resultType="map" parameterType="map"> select * from student where 1 = 1 <if test="name != null and name != ‘‘"> and name like concat(‘%‘, #{name}, ‘%‘) </if> <if test="address != null and address != ‘‘"> and address like concat(‘%‘, #{address}, ‘%‘) </if> </select>
mapper: List<Map<String, Object>> getData(Map<String, Object> map); service: public List<Map<String, Object>> getData(Map<String, Object> map) { return mapper.getData(map); } controller: @ResponseBody @RequestMapping("/getData") public List<Map<String, Object>> getData(@RequestBody Map<String, Object> map) { return service.getData(map); }
js: var params = {}; params.name = "张三"; params.address = "武汉"; $.ajax({ url: "/ace/getData", type: "POST", data: JSON.stringify(params), contentType: "application/json", success:function(data){ debugger } });

原文:https://www.cnblogs.com/xxdjj/p/14473261.html