java - Spring批量插入不将数据插入数据库
问题描述
我是春天的新手,我正在尝试批量插入数据库,但由于某种原因它没有插入任何东西。有人可以告诉我我做错了什么。
控制器
public class HomeController {
@Autowired
private UserRepository userRepository;
@RequestMapping("/registration")
public ResponseEntity<String> insertUser()
{
User c1=new User("Kangkan Talukdar","Guwahati","I am java programmer");
User c2=new User("Kangkan Thakuria","Guwahati","I am java programmer");
User c3=new User("Kangkan Ahmed","Guwahati","I am java programmer");
User c4=new User("Kangkan Basumatary","Guwahati","I am java programmer");
List<User> user1 = Arrays.asList(c1, c2, c3, c4);
userRepository.saveAll(user1);
return ResponseEntity.created("/customers");
}
}
用户表
@Entity
public class User {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int id;
private String name;
private String city;
private String status;
//getter,setters etc have been generated
}
我添加了以下属性
spring.jpa.properties.hibernate.jdbc.batch_size=4
spring.jpa.properties.hibernate.order_inserts=true
这是日志
0 nanoseconds spent acquiring 0 JDBC connections;
0 nanoseconds spent releasing 0 JDBC connections;
0 nanoseconds spent preparing 0 JDBC statements;
0 nanoseconds spent executing 0 JDBC statements;
0 nanoseconds spent executing 0 JDBC batches;
0 nanoseconds spent performing 0 L2C puts;
0 nanoseconds spent performing 0 L2C hits;
0 nanoseconds spent performing 0 L2C misses;
0 nanoseconds spent executing 0 flushes (flushing a total of 0 entities and 0 collections);
0 nanoseconds spent executing 0 partial-flushes (flushing a total of 0 entities and 0 collections)
解决方案
你可以试试这个方法。
private Map<Long, User> usersMap = new HashMap<>();
User user = new User();
user.setId(1);
user.setName("Kangkan Talukdar");
user.setCity("Guwahati");
user.setStatus("I am java programmer");
usersMap.put(user.getId(), user);
application.yml :
jpa:
hibernate:
ddl-auto: update
推荐阅读
- unix - Unix命令在同一个文件中搜索多个模式
- r - 我有天数,我想将这个给定的数字转换为 R 中的年月日
- reactjs - 通过在反应中获取 API 获得空值和实际结果
- java - ARcore 与 Twilio 视频通话
- java - 将列表转换为多维地图
- haproxy - HAProxy 路径匹配
- php - 流明哈希检查返回总是假
- javascript - 未捕获的 TypeError:Popper 不是构造函数
- javascript - 最简单的方法 - 仅在 ajax-request 函数完成时调用函数 - 回调,承诺
- c# - SMTP 服务器需要安全连接或客户端未通过身份验证。如何在我的 gmail 帐户上接收电子邮件。?