mybatis之map作为参数和结果类型

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
    }
});

posted @ 2021-03-03 11:03  艾葵茵  阅读(410)  评论(0)    收藏  举报