2.SpringBoot整合SpringDataJpa

SpringBoot整合SpringDataJpa

1.导入SpringBoot的起步依赖和数据库的连接驱动坐标(根据不同数据库选择)

  <!-- springBoot JPA的起步依赖 -->
     <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
     </dependency>
  <!-- MySQL连接驱动 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>

2.在项目resources下创建application.properties,配置数据库连接,以及数据库名称,打印Sql语句,生成建表语句,自动建表策略为update
3.创建Dao实体类,生成get和set方法,和UserDao接口
实体类

@Entity
@Table(name = "t_user")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    private String username;
    private String password;
    private String name;4      

userDao接口:

public interface UserDao extends JpaRepository<User,Integer> {
}

4.写一个Controller测试一下吧,Jpa支持自动建表,数据库中数据我们自己添加一下

@RestController
@RequestMapping("/user")
public class UserController {
    @Autowired
    private UserDao userDao;

    @RequestMapping
    public List<User> findAll(Model model){
      return userDao.findAll();
    }
  }