水一程--数据架构--ORM

目的：深入研究数据架构与应用架构的ORM

---

1.index:

reference: 

1. JPA 网文：https://www.bbsmax.com/A/n2d9PDNQ5D/

https://www.cnblogs.com/masterSoul/articles/14641341.html

https://www.cnblogs.com/masterSoul/articles/13370038.html

常用配置

# Mysql config
spring.datasource.url=jdbc:mysql://localhost:3306/DB_SCHEMA_NAME?userUnicode=true&characterEncoding=utf-8&serverTimezone=GMT
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username=**
spring.datasource.password=**

# Hibernate
spring.jpa.properties.hibernate.jdbc.fetch_size=250
spring.jpa.properties.hibernate.jdbc.batch_size=50

# cp hikari
spring.datasource.hikari.maximum-pool-size=50
spring.datasource.hikari.minimum-idle=2
spring.datasource.hikari.leak-detection-threshold=20000
spring.datasource.hikari.connection-timeout=60000

 

mysql sql script

CREATE USER 'walker'@'localhost' identified BY 'admin';

CREATE SCHEMA HIBERNATE_BASE;
GRANT ALL PRIVILEGES ON HIBERNATE_BASE . * TO 'walker'@'localhost';
FLUSH PRIVILEGES;

SET GLOBAL time_zone = '+3:00';

 

---

 

2.核心

DAO 数据访问模式

DAO 类会将一个接口定义到与特定实体相关的持久化操作；将与该实体持久化有关的代码分组在一起.