Mybatis批量插入数据返回主键的实现

发布时间:2020-03-19 03:43:05发布者:admin浏览数:

响应效果(id为主键):

{ "data": [ {"studentName": "张三","classNo": "一班","id": 111}, {"studentName": "李四","classNo": "二班","id": 112}, {"studentName": "王五","classNo": "一班","id": 113} ]}

控制层:

@PostMapping("/test") @ResponseBody public Map<String, Object> test(@RequestBody String data) { Map<String, Object> resultMap = new HashMap<String, Object>(); //非空校验 if (!checkParams.checkString(data)) { resultMap.put("code", "1"); resultMap.put("msg", "参数为空。"); return resultMap; } //json转List<Map<String, Object>> JSONObject json= new JSONObject(data); String dataString = json.get("data").toString(); com.google.gson.Gson gson = new Gson(); List<Map<String, Object>> list = gson.fromJson(dataString, new com.google.common.reflect.TypeToken<List<Map<String, Object>>>() { }.getType()); //请求接口 resultMap=registerService.test(list); return resultMap; }

接口:

public Map<String, Object> test(List<Map<String,Object>> data);

实现类:

@Override public Map<String, Object> test(List<Map<String,Object>> data) { Map<String, Object> resultMap = new HashMap<String, Object>(); registerMapper.test( data); resultMap.put("data",data); return resultMap; }

持久层:

public void test(List<Map<String,Object>> list);

statement:

<!-- =========================批量插入返回主键示例======================== --> <insert id="test" parameterType="list" useGeneratedKeys="true" keyProperty="id" > INSERT INTO student_info(student_name,class_no)VALUES <foreach collection="list" item="item" separator=","> ( #{item.studentName}, #{item.classNo} ) </foreach> </insert>

请求方式:

http://localhost/xxx/test

请求参数:

{ "data": [ {"studentName": "张三","classNo": "一班"}, {"studentName": "李四","classNo": "二班"}, {"studentName": "王五","classNo": "一班"} ]}

注意事项:

statement中keyProperty的赋值是可以自定义的,如果将keyProperty的值改为key,即改成如下:

<!-- =========================批量插入返回主键示例======================== --> <insert id="test" parameterType="list" useGeneratedKeys="true" keyProperty="key" > INSERT INTO student_info(student_name,class_no)VALUES <foreach collection="list" item="item" separator=","> ( #{item.studentName}, #{item.classNo} ) </foreach> </insert>

则响应效果(key为主键)如下:

{ "data": [ {"studentName": "张三","classNo": "一班","key": 111}, {"studentName": "李四","classNo": "二班","key": 112}, {"studentName": "王五","classNo": "一班","key": 113} ]}

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持我们。

  程序开发分类
程序开发 |  系统教程 |  软件应用 |  图形图像 |  网络应用 |  站长教程 |  网站建设 |  视频教程 |  硬件维护 |  IT资讯 |  中国it动力网
本站发布的系统与软件仅为个人学习测试使用,请在下载后24小时内删除,不得用于任何商业用途,否则后果自负,请支持购买微软正版软件!
如侵犯到您的权益,请及时通知我们,我们会及时处理。
Copyright @ 2019 中国it动力网 网站导航