Mybatis批量插入数据返回主键
2023-09-27 14:28:03 时间
响应效果(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}
]
}
相关文章
- Elasticsearch bulk 批量操作文档
- 一个由正则表达式引发的血案 vs2017使用rdlc实现批量打印 vs2017使用rdlc [asp.net core 源码分析] 01 - Session SignalR sql for xml path用法 MemCahe C# 操作Excel图形——绘制、读取、隐藏、删除图形 IOC,DIP,DI,IoC容器
- Google Earth Engine——使用geetool批量下载单景影像以Landsat 8 反演后的NDSI结果
- 【Redis】redis安装与客户端redis-cli的使用(批量操作)
- Linq-批量删除方法
- mongo批量删除js示例
- MyBatis魔法堂:各数据库的批量Update操作
- Mybatis批量插入3种方法
- Python pymysql批量执行目录里面的多个sql文件
- Revit API批量布置函数doc.Create.NewFamilyInstances();