spring boot整合Spring data jpa

1、在maven POM文件中添加如下依赖

<dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

<dependency>
   <groupId>com.oracle</groupId>
   <artifactId>ojdbc6</artifactId>
   <version>11.2.0.3</version>
</dependency>

2、在配置文件application.properties中增加数据源信息

spring.datasource.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.username=username
spring.datasource.password=password

3、创建表

create table user_info (
user_id             INTEGER NOT NULL,
user_name varchar2(20),
user_age                     INTEGER
);

alter table user_info
  add constraint pk_user_info primary key (user_id);
  
create sequence seq_user_info increment by 1 start with 1 maxvalue 999999999999999; 

4、创建实体类

import javax.persistence.*;

/**
* 用户表
*/
@Entity
@Table(name = "USER_INFO")
@SequenceGenerator(name="USER_INFO",sequenceName="SEQ_USER_INFO",
   allocationSize=1,initialValue=1)//指定初始值和增长值
public class UserInfo 
{
    /**
    * 主键
    */
    @Id
    @Column(name = "USER_ID")
    @GeneratedValue(generator="USER_INFO",strategy=GenerationType.SEQUENCE)
    private Integer userId;

    /**
    * 用户名
    */
    @Column(name = "USER_NAME")
    private String userName;

    /**
    * 用户年龄
    */
    @Column(name = "USER_AGE")
    private String userAge;

   public Integer getUserId() {
      return userId;
   }

   public void setUserId(Integer userId) {
      this.userId = userId;
   }

   public String getUserName() {
      return userName;
   }

   public void setUserName(String userName) {
      this.userName = userName;
   }

   public String getUserAge() {
      return userAge;
   }

   public void setUserAge(String userAge) {
      this.userAge = userAge;
   }
}

5、创建Dao接口

import com.company.entity.UserInfo;
import org.springframework.data.jpa.domain.Specification;
import org.springframework.data.jpa.repository.JpaRepository;

public interface UserInfoDao extends JpaRepository<UserInfo,Integer>{
}

6、直接在service中使用即可

@Service
public class UserInfoService {

    @Autowired
    private UserInfoDao userInfoDao;

    public List<UserInfo> getUser() {
        UserInfo userInfo = new UserInfo();
        userInfo.setUserName("姓名");
        userInfo.setUserAge(1);
        userInfoDao.save(userInfo);

        List<UserInfo> list = userInfoDao.findAll();
        return list;
    }
}