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
}
});
![]()