上一篇:Hibernate 概述 · 下一篇:user 表 CRUD
1. 共用 user 表
库表 DDL 与种子数据与 JDBC 相同,见 环境与 user 表 中的 schema.sql、seed.sql。
2. 新建工程 hibernate-user-lab
hibernate-user-lab/├── pom.xml└── src/main/ ├── java/demo/hibernate/ │ ├── Jpa.java │ └── User.java └── resources/META-INF/persistence.xml3. 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. 编译
mvn -q compile下一篇加入 CrudDemo.java 并查看 Hibernate 生成的 SQL。