Spring – druid + jpa + tx boot integration

jpa

Jpa introduction

java persistence API

Is a Java persistence specification with two main objectives:

1. forjavaThe application developer provideso/r mappingTools to managejavaRelational data in applications simplifies the task of developing persistence.
2. Integrate ORM technology. Projects such as Hibernate (version 3.2) and TopLink Essentials have implemented the Java Persistence API specification.

Hibernate

• Hibernate provides an open source object-relational mapping framework for Java

• Gavin King founded the Hibernate project.

• Hibernate development team joined JBoss.

• Version 3.2 and later provide implementations of Java persistence apis.

spring data

Spring Data is an open source framework for simplifying database access and enabling cloud services.

Provides relatively consistent storage while preserving the underlying storage features. Spring-based programming model.

Main modules:

• Spring data jdbc
• spring data jpa
• spring data redis
• spring data mongodb
• spring data keyvalue
• .

spring-boot-starter-data-jpa

Defining entity Objects

/ / parent class
@MappedSuperclass
@EntityListeners(AuditingEntityListener.class)
@Data
public abstract class BaseEntity implements Serializable {

  @Column(name = "create_time", updatable = false)
  @CreationTimestamp
  private Date createTime;

  /** last updated */
  @Column(name = "update_time")
  @UpdateTimestamp
  private Date updateTime;
}
Copy the code

@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
@Entity
@Table(name = "T_MENU")
public class Menu extends BaseEntity {
  @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  private Long menuId;

  @Column(name = "parent_id")
  private Long parentId;

  private String name;

  private String url;

  private Integer type;

  @Column(name = "order_num")
  private Integer orderNum;

  @Column(name = "is_deleted")
  private int isDeleted;
}
Copy the code

Common notes:

Entity: marks this class as an Entity bean

@table: Used to configure the mapping between a Table and a class

@column: specifies details about the mapping between a Column and a field or attribute. The most commonly used attribute is:

• The name attribute allows you to explicitly specify the name of a column.
• The length attribute is the size of the column used to map a value, especially a string value.
• The Nullable attribute allows a column to be marked as non-empty when a schema is generated.
• The unique attribute allows columns to contain only one content
• Whether the updatable property can be modified

@ Id: the primary key

@generatedValue: Primary key generation policy

• TABLE: Uses a specific database TABLE to hold the primary key.
• SEQUENCE: Generates primary keys based on the SEQUENCE of the underlying database, provided that the database supports sequences.
  • @sequenceGenerator: Specifies the sequence name
• IDENTITY: Primary key generated automatically by the database (mainly auto-growing)
• AUTO: The primary key is controlled by the program.

@creationtimestamp: creation time

@updatetimestamp: indicates the update time

@OrderBy

The following are comments on the relationships between tables

1 to 1, 1 to many, many to 1, many to many

inheritance

@JoinTable

@JoinColumn

@OneToOne

@OneToMany

@ManyToOne

@ManyToMany

@MappedSuperclass

@EntityListeners(AuditingEntityListener.class)

Repository

@EnableJpaRepositories

@NoRepositoryBean

Interface:

PagingAndSortingRepository<T, ID>

CrudRepository<T, ID>

JpaRepository<T, ID>

Method definition

• Query method definition

  find.. By... / get... By... / query... By... / read... By...

• Definition of statistical method

  count... By...

• Sorting method definition

  ...OrderBy...[Asc/Desc]

• Conditions for joining together

• paging

  Pageable/Sort/Slice/Page

• The rest of the

  Top/Distinct/First

@NoRepositoryBean
public interface BaseRepository<T.Long> extends PagingAndSortingRepository<T.Long> {}
Copy the code

public interface MenuRepository extends BaseRepository<Menu.Long> {}
Copy the code

druid

Druid is the best database connection pool in the Java language. Druid provides powerful monitoring and extension capabilities.

druid.wiki

spring.datasource.url: JDBC: mysql: / / 127.0.0.1:3306 / spring - the boot - demo? useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&failOverReadOnly=false&serverTimezone=GMT%2B8
spring.datasource.username: root
spring.datasource.password: Gepoint
spring.datasource.driver-class-name: com.mysql.cj.jdbc.Driver
spring.datasource.type: com.alibaba.druid.pool.DruidDataSource ## Specifies the connection pool. The default is Hikari

spring.datasource.druid.initial-size: 5
spring.datasource.druid.max-active: 5
spring.datasource.druid.min-idle: 5
spring.datasource.druid.max-wait: 60000
spring.datasource.druid.filters: conn,config,stat,slf4j
spring.datasource.druid.test-on-borrow: true
spring.datasource.druid.test-on-return: true
spring.datasource.druid.test-while-idle: true
Copy the code

transaction

Spring Transaction Propagation features

Spring Transaction Core interface

• PlatformTransactionManager
  • DataSourceTransactionManager
  • HibernateTransactionManager
  • JtaTransactionManager
• TransactionDefinition
  • Propagation
  • Isolation
  • Timeout
  • Read-only Status

One of two ways

1. Declarative transaction

   @EnableTransactionManagement(proxyTargetClass,mode,order)

   @Transactional(transactionManager,propagation,isolation,timeout,readOnly,rollbackFor)

2. Programmatic transactions:

   • TransactionTemplate

     TransactionCallback

     TransactionCallbackWithoutResult

   • PlatformTransactionManager

     TransactionDefinition

   @Autowired
   private TransactionTemplate txTemplate;
   
   @Autowired
   private JdbcTemplate template;
   
   txTemplate.execute(status->{
       template.execute("insert into t (id) values (1)");
       status.setRollbackOnly();
   })
   Copy the code

   [Example code](gitee.com/shawn_fight…

)