#spring boot JPA 连接SQl Server
1、首先呢加载jpa 与jdbc 相关的依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
2、在配置文件里配置相关的连接数据库信息
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.url=jdbc:sqlserver://127.0.0.1:1433; databaseName=smxTest
spring.datasource.username=sa
spring.datasource.password=zlf123456
3、编写数据表对应的Entity文件(若文件名不一样,记得用@Table来指定对应的表明)用@Id指定文件的主键,@GeneratedValue指定逐渐的增长方式(这里对应的是PO层)
@Entity
@Table(name = "users")
public class usersEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
public void setId(int id) {
this.id = id;
}
public int getId() {
return id;
}
3、新建jpa文件(interface)并集成JpaRepository<entity, 主键的数据类型>,下面就开始写增删改查了(这里对应的应该是DAO层)
public interface UsersRespository extends JpaRepository<usersEntity, Integer> {
/**
* 获取所有用户信息
* @return
*/
@Query(value = "select * from users", nativeQuery = true)
List<usersEntity> getFindAll();
}
4、下面就开始查询用了
@RestController
public class UserController {
@Autowired
UsersRespository usersRespository;
@GetMapping("/users")
public int findAll(){
List<usersEntity> list = usersRespository.findAll();
for (usersEntity u:list) {
System.out.println(u.getName());
}
return list.size();
}
}