1、在pom.xml中引入相关jar包
<!-- spring data jpa -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency> <!-- 内存数据库hsqldb -->
<dependency>
<groupId>org.hsqldb</groupId>
<artifactId>hsqldb</artifactId>
<scope>runtime</scope>
</dependency>
2、配置yml,将数据写入硬盘
spring:
jpa:
show-sql: false
hibernate:
ddl-auto: update
datasource:
url: jdbc:hsqldb:file:C:/rct/db/rct-db
username: admin
password: admin
driverClassName: org.hsqldb.jdbcDriver
3、使用jpa注解,并设定自增主键,如果想某些属性不存入数据库,应使用@Transient注解
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id; @Entity
public class Update {
@Id
@GeneratedValue
protected Long id;
String version;//当前版本 public String getVersion() {
return version;
} public void setVersion(String version) {
this.version = version;
}
}
4、创建dao
import com.smart.rct.domain.Update;
import org.springframework.data.repository.CrudRepository; public interface UpdateDao extends CrudRepository<Update, Long> {
}
5、保存数据
6、创建接口,获取数据
@ApiOperation(value = "查询历史版本")
@GetMapping("findAllVersion")
public List<Update> findAllVersion() {
return (List<Update>) updateDao.findAll();
}
6、查看结果