依赖文件
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion> <groupId>com.example</groupId>
<artifactId>demo</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging> <name>demo</name>
<description>Demo project for Spring Boot</description> <parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.0.RELEASE</version>
<relativePath/>
</parent> <properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
</properties> <dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency> <dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency> <dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
</dependency> </dependencies> <build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build> </project>
配置文件
spring:
datasource:
url: jdbc:postgresql://127.0.0.1:5432/postgres
username: postgres
password: postgres
driverClassName: org.postgresql.Driver
initialization-mode: always
jpa:
show-sql: true
hibernate:
ddl-auto: update
properties:
hibernate:
temp:
use_jdbc_metadata_defaults: false
实体类
package com.example.demo; import javax.persistence.*;
import java.io.Serializable; /**
* @Author:
* @Description:
* @Date Create in 2018/11/29 18:12
* @Modified By:
*/
@Entity
@Table(name="test_pg_wushan")
public class TestDomain implements Serializable { private static final long serialVersionUID = 2672553622864930471L;
@Id
@GeneratedValue(strategy= GenerationType.SEQUENCE,generator="s_test_pg_wushan")
@SequenceGenerator(sequenceName="test_sequence", name="s_test_pg_wushan",allocationSize = 1)
@Column(name="test_id")
private Integer id;
@Column(name="test_name")
private String name; public Integer getId() {
return id;
} public void setId(Integer id) {
this.id = id;
} public String getName() {
return name;
} public void setName(String name) {
this.name = name;
}
}
repository类
package com.example.demo; import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Service; /**
* @Author:
* @Description:
* @Date Create in 2018/11/29 18:14
* @Modified By:
*/
@Service
public interface TestRepository extends JpaRepository<TestDomain, Long> {
}
controller类
package com.example.demo; import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody; /**
* @Author:
* @Description:
* @Date Create in 2018/11/29 18:13
* @Modified By:
*/
@Controller
public class TestController { @Autowired
TestRepository testRepository ; @RequestMapping("/")
@ResponseBody
public String test1(){
return "hello";
} @RequestMapping("/save")
@ResponseBody
public String test2(){
TestDomain te = new TestDomain();
te.setName(System.currentTimeMillis()+"");
testRepository.save(te);
testRepository.flush();
return "success";
}
}
备注：
创建表后，查看创建sql语句，发现主键并没有设置为序列自增。但是使用controller类操作存储元素，是可以在不指定主键值的情况下存储的。