Spring Boot 之 Spring Data JPA（一）1、新建工程2、配置数据库3、代码结构4、从数据到逻辑总结

# JPA (JpaBaseConfiguration, HibernateJpaAutoConfiguration)
# DATASOURCE (DataSourceAutoConfiguration & DataSourceProperties)
spring.datasource.continue-on-error=false # Do not stop if an error occurs while initializing the database.
spring.datasource.data= # Data (DML) script resource references.
spring.datasource.data-username= # User of the database to execute DML scripts (if different).
spring.datasource.data-password= # Password of the database to execute DML scripts (if different).
spring.datasource.dbcp2.*= # Commons DBCP2 specific settings
spring.datasource.driver-class-name= # Fully qualified name of the JDBC driver. Auto-detected based on the URL by default.
spring.datasource.generate-unique-name=false # Generate a random datasource name.
spring.datasource.hikari.*= # Hikari specific settings
spring.datasource.initialize=true # Populate the database using 'data.sql'.
spring.datasource.jmx-enabled=false # Enable JMX support (if provided by the underlying pool).
spring.datasource.jndi-name= # JNDI location of the datasource. Class, url, username & password are ignored when set.
spring.datasource.name=testdb # Name of the datasource.
spring.datasource.password= # Login password of the database.
spring.datasource.platform=all # Platform to use in the schema resource (schema-${platform}.sql).
spring.datasource.schema= # Schema (DDL) script resource references.
spring.datasource.schema-username= # User of the database to execute DDL scripts (if different).
spring.datasource.schema-password= # Password of the database to execute DDL scripts (if different).
spring.datasource.separator=; # Statement separator in SQL initialization scripts.
spring.datasource.sql-script-encoding= # SQL scripts encoding.
spring.datasource.tomcat.*= # Tomcat datasource specific settings
spring.datasource.type= # Fully qualified name of the connection pool implementation to use. By default, it is auto-detected from the classpath.
spring.datasource.url= # JDBC url of the database.
spring.datasource.username= # Login user of the database.
spring.datasource.xa.data-source-class-name= # XA datasource fully qualified name.
spring.datasource.xa.properties= # Properties to pass to the XA data source.

# H2 Web Console (H2ConsoleProperties)
spring.h2.console.enabled=false # Enable the console.
spring.h2.console.path=/h2-console # Path at which the console will be available.
spring.h2.console.settings.trace=false # Enable trace output.
spring.h2.console.settings.web-allow-others=false # Enable remote access.

# JOOQ (JooqAutoConfiguration)
spring.jooq.sql-dialect= # SQLDialect JOOQ used when communicating with the configured datasource. For instance `POSTGRES`

# JPA (JpaBaseConfiguration, HibernateJpaAutoConfiguration)
spring.data.jpa.repositories.enabled=true # Enable JPA repositories.
spring.jpa.database= # Target database to operate on, auto-detected by default. Can be alternatively set using the "databasePlatform" property.
spring.jpa.database-platform= # Name of the target database to operate on, auto-detected by default. Can be alternatively set using the "Database" enum.
spring.jpa.generate-ddl=false # Initialize the schema on startup.
spring.jpa.hibernate.ddl-auto= # DDL mode. This is actually a shortcut for the "hibernate.hbm2ddl.auto" property. Default to "create-drop" when using an embedded database, "none" otherwise.
spring.jpa.hibernate.naming.implicit-strategy= # Hibernate 5 implicit naming strategy fully qualified name.
spring.jpa.hibernate.naming.physical-strategy= # Hibernate 5 physical naming strategy fully qualified name.
spring.jpa.hibernate.naming.strategy= # Hibernate 4 naming strategy fully qualified name. Not supported with Hibernate 5.
spring.jpa.hibernate.use-new-id-generator-mappings= # Use Hibernate's newer IdentifierGenerator for AUTO, TABLE and SEQUENCE.
spring.jpa.open-in-view=true # Register OpenEntityManagerInViewInterceptor. Binds a JPA EntityManager to the thread for the entire processing of the request.
spring.jpa.properties.*= # Additional native properties to set on the JPA provider.
spring.jpa.show-sql=false # Enable logging of SQL statements.

spring.datasource.url=jdbc:h2:file:d:/h2/data.db;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
spring.jpa.database-platform= org.hibernate.dialect.H2Dialect
spring.jpa.generate-ddl=true
spring.jpa.hibernate.ddl-auto=create-drop
spring.jpa.open-in-view=true 
spring.jpa.show-sql=false
spring.h2.console.enabled=false

com
 +- example
     +- myproject
         +- Application.java
         |
         +- domain
         |   +- Customer.java
         |   +- CustomerRepository.java
         |
         +- service
         |   +- CustomerService.java
         |
         +- web
             +- CustomerController.java

@Entity
public class Records {
    @Id
    @GeneratedValue
    private Long id;
    @Column
    private String title;
    @Column
    private String description;
    @Column
    private Date updateDate;
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    public String getTitle() {
        return title;
    }
    public void setTitle(String title) {
        this.title = title;
    }
    public String getDescription() {
        return description;
    }
    public void setDescription(String description) {
        this.description = description;
    }
    public Date getUpdateDate() {
        return updateDate;
    }
    public void setUpdateDate(Date updateDate) {
        this.updateDate = updateDate;
    }   
}

@Repository
public interface RecordsRepo extends JpaRepository<Records, Long> {
}

@Service
public class RecordsService {
    
    @Autowired
    RecordsRepo recRepo;
    
    public Records save(Records rec) {
        return recRepo.save(rec);
    }
    
    public List<Records> list() {
        return recRepo.findAll();
    }
    
    public void delete(Records rec) {
        recRepo.delete(rec);
    }
    
    public Records get(Long id) {
        return recRepo.findOne(id);
    }
}

@SpringBootApplication
@RestController
public class SpringBootJpaApplication {

    @Autowired
    RecordsService recSevc;
    
    public static void main(String[] args) {
        SpringApplication.run(SpringBootJpaApplication.class, args);
    }
    
    @RequestMapping("new")
    public Records newRecords() {
        Records rec = new Records();
        rec.setTitle("title" + Math.random());
        rec.setDescription("desc" + Math.random());
        rec.setUpdateDate(Calendar.getInstance().getTime());
        rec = recSevc.save(rec);
        return rec;
    }
    
    @RequestMapping("update")
    public Records updateRecords() {
        Records rec = recSevc.get(1l);
        rec.setTitle("modified");
        recSevc.save(rec);
        return rec;
    }
    
    @RequestMapping("delete")
    public String deleteRecords() {
        Records rec = recSevc.get(1l);
        recSevc.delete(rec);
        return "deleted";
    }
}

spring.h2.console.enabled=true
spring.h2.console.path=/h2 #默认是/h2_console

@RunWith(SpringRunner.class)
@SpringBootTest
public class SpringBootJpaApplicationTests {

    @Autowired
    RecordsService recSevc;
    
    @Test
    public void contextLoads() {
    }
    
    @Test
    public void testJpaRecords() {
        Records rec = new Records();
        rec.setTitle("title" + Math.random());
        rec.setDescription("desc" + Math.random());
        rec.setUpdateDate(Calendar.getInstance().getTime());
        rec = recSevc.save(rec);
        Long id = rec.getId();
        assertThat(rec.getId()).isNotNull();
        rec.setTitle("modified");
        rec = recSevc.save(rec);
        assertThat(rec.getTitle()).isEqualTo("modified");
        assertThat(rec.getId()).isEqualTo(id);
        
        List<Records> recs = recSevc.list();
        int size = recs.size();
        assertThat(size).isGreaterThan(0);
        
        rec = recSevc.get(id);
        assertThat(rec.getId()).isEqualTo(id);
        
        recSevc.delete(rec);
        rec = recSevc.get(id);
        assertThat(rec).isNull();
    }
}