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

最新推荐文章于 2024-01-31 21:57:20 发布

艾葵茵

最新推荐文章于 2024-01-31 21:57:20 发布

阅读量342

点赞数

文章标签： java

本文链接：https://blog.csdn.net/qq_40139458/article/details/114143116

版权

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

controller:
@ResponseBody
@RequestMapping("/getData")
public List<Map<String, Object>> getData(@RequestBody Map<String, Object> map) {
	return mapper.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
	}
});