springboot--SpringDataJPA生成表 crud数据

JPA(Java Persistence API)java持久化规范。

只需要编写一个接口继承一个类就可以进行操作

1. <dependency>
2. <groupId>mysql </groupId>
3. <artifactId>mysql-connector-java </artifactId>
4. </dependency>
7. <dependency>
8. <groupId>org.springframework.boot </groupId>
9. <artifactId>spring-boot-starter-data-jpa </artifactId>
10. </dependency>

1. @Entity
2. public class User {
3. //使用这个注解id必须是int
4. @Id
5. @GeneratedValue(strategy=GenerationType.AUTO)
6. private long id;
7. private String name;
9. @JSONField(format= "yyyy-MM-dd HH:mm:ss")
10. private Date date;
12. @JSONField(serialize= false)
13. private String notSerilized;
15. public String getNotSerilized() {
16. return notSerilized;
17. }
18. public void setNotSerilized(String notSerilized) {
19. this.notSerilized = notSerilized;
20. }
21. public String getName() {
22. return name;
23. }
24. public void setName(String name) {
25. this.name = name;
26. }
27. public Date getDate() {
28. return date;
29. }
30. public void setDate(Date date) {
31. this.date = date;
32. }
33. public long getId() {
34. return id;
35. }
36. public void setId(long id) {
37. this.id = id;
38. }
40. }

会根据@id和@GeneratedValue生成数据主键：注意如果使用GeneratedValue那么逐渐必须不是String
生成字段的原则是驼峰 比如oldName --OLD_NAME

repository

创建repository接口继承CRUDRopository

1. public interface UserRepository extends CrudRepository<User, Integer>{
3. }

1. @Service
2. public class UserService {
4. @Resource
5. private UserRepository userRepository;
7. @Transactional
8. public void save(User user){
9. userRepository.save(user);
10. }
12. @Transactional
13. public void delete(User user){
14. userRepository.delete(user);
15. }
18. public Iterable<User> findAll(){
19. return userRepository.findAll();
20. }
21. }

1. @RestController
2. @RequestMapping(value= "/user")
3. public class UserController {
5. @Resource
6. private UserService userService;
8. /* @RequestMapping("/save")
9. public String save(@RequestParam(required=false) User user){
10. userService.save(user);
11. return "save ok";
12. }*/
14. @RequestMapping( "/delete")
15. public String delete(@RequestParam(required=false) User user){
16. userService.delete(user);
17. return "delete ok";
18. }
20. @RequestMapping( "/getAll")
21. public Iterable<User> findAll(){
22. return userService.findAll();
23. }
25. @RequestMapping( "/saveById")
26. public String saveByName(@RequestParam String name){
27. User user = new User();
28. user.setName(name);
29. user.setDate( new Date());
30. userService.save(user);
31. return "save ok";
32. }
33. }