环境与实体映射

笔记/Java/Java 持久层/Hibernate/环境与实体映射

上一篇:Hibernate 概述 · 下一篇:user 表 CRUD

1. 共用 user 表#

库表 DDL 与种子数据与 JDBC 相同,见 环境与 user 表 中的 schema.sqlseed.sql

2. 新建工程 hibernate-user-lab#

hibernate-user-lab/
├── pom.xml
└── src/main/
├── java/demo/hibernate/
│ ├── Jpa.java
│ └── User.java
└── resources/META-INF/persistence.xml

3. pom.xml#

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.blog.demo</groupId>
<artifactId>hibernate-user-lab</artifactId>
<version>1.0.0</version>
<properties>
<maven.compiler.release>17</maven.compiler.release>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<hibernate.version>6.4.10.Final</hibernate.version>
<mysql.version>8.3.0</mysql.version>
</properties>
<dependencies>
<dependency>
<groupId>org.hibernate.orm</groupId>
<artifactId>hibernate-core</artifactId>
<version>${hibernate.version}</version>
</dependency>
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<version>${mysql.version}</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>exec-maven-plugin</artifactId>
<version>3.5.0</version>
</plugin>
</plugins>
</build>
</project>

4. persistence.xml#

路径:src/main/resources/META-INF/persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="https://jakarta.ee/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="https://jakarta.ee/xml/ns/persistence https://jakarta.ee/xml/ns/persistence/persistence_3_0.xsd"
version="3.0">
<persistence-unit name="jdbc-lab" transaction-type="RESOURCE_LOCAL">
<class>demo.hibernate.User</class>
<properties>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.format_sql" value="true"/>
<property name="hibernate.hbm2ddl.auto" value="validate"/>
</properties>
</persistence-unit>
</persistence>

validate:表必须已存在,Hibernate 不会自动建表。

5. Jpa.java — 数据源配置#

package demo.hibernate;
import jakarta.persistence.EntityManagerFactory;
import jakarta.persistence.Persistence;
import org.hibernate.cfg.AvailableSettings;
import java.util.HashMap;
import java.util.Map;
public final class Jpa {
public static final String PU = "jdbc-lab";
private Jpa() {}
public static EntityManagerFactory createEntityManagerFactory() {
Map<String, Object> overrides = new HashMap<>();
overrides.put(AvailableSettings.JAKARTA_JDBC_URL, env("JDBC_URL",
"jdbc:mysql://127.0.0.1:3306/jdbc_lab?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai"));
overrides.put(AvailableSettings.JAKARTA_JDBC_USER, env("JDBC_USER", "root"));
overrides.put(AvailableSettings.JAKARTA_JDBC_PASSWORD, env("JDBC_PASSWORD", "root"));
overrides.put(AvailableSettings.JAKARTA_JDBC_DRIVER, "com.mysql.cj.jdbc.Driver");
return Persistence.createEntityManagerFactory(PU, overrides);
}
private static String env(String key, String fallback) {
String value = System.getenv(key);
return value == null || value.isBlank() ? fallback : value.trim();
}
}

6. User.java — 实体映射#

package demo.hibernate;
import jakarta.persistence.*;
import java.time.LocalDateTime;
@Entity
@Table(name = "user")
public class User {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@Column(name = "user_name", nullable = false, length = 64)
private String userName;
@Column(length = 128)
private String email;
@Column(nullable = false)
private int status = 1;
@Column(name = "created_at", insertable = false, updatable = false)
private LocalDateTime createdAt;
public User() {}
public User(String userName, String email, int status) {
this.userName = userName;
this.email = email;
this.status = status;
}
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }
public String getUserName() { return userName; }
public void setUserName(String userName) { this.userName = userName; }
public String getEmail() { return email; }
public void setEmail(String email) { this.email = email; }
public int getStatus() { return status; }
public void setStatus(int status) { this.status = status; }
public LocalDateTime getCreatedAt() { return createdAt; }
@Override
public String toString() {
return "User{id=" + id + ", userName='" + userName + "', email='" + email
+ "', status=" + status + ", createdAt=" + createdAt + "}";
}
}

7. 编译#

Terminal window
mvn -q compile

下一篇加入 CrudDemo.java 并查看 Hibernate 生成的 SQL。

文章目录

文章目录