使用JPA-Hibernate访问SQL Database

version 1.5.7

安装

在你的pom.xml文件中加上以下依赖：

  1. <dependency>
  2.     <groupId>org.actframework</groupId>
  3.     <artifactId>act-hibernate</artifactId>
  4.     <version>1.5.7</version>
  5. </dependency>

根据你的数据库类型，你也需要加入相应的JDBC访问包的依赖。比如：

  1. <dependency>
  2.     <groupId>com.h2database</groupId>
  3.     <artifactId>h2</artifactId>
  4.     <version>1.4.178</version>
  5. </dependency>

你还需要引入一个数据库连接池，根据自身条件在以下任选其一：

  1. <dependency>
  2.       <groupId>com.zaxxer</groupId>
  3.       <artifactId>HikariCP-java7</artifactId>
  4.       <version>2.4.13</version>
  5. </dependency>
  7. <dependency>
  8.       <groupId>com.zaxxer</groupId>
  9.       <artifactId>HikariCP</artifactId>
  10.       <version>2.7.9</version>
  11. </dependency>
  13. <dependency>
  14.       <groupId>com.alibaba</groupId>
  15.       <artifactId>druid</artifactId>
  16.       <version>1.1.16</version>
  17. </dependency>

配置

  1. # If you have only one DBPlugin in your class path, then
  2. # you do not need to specify the db.impl configuration
  3. db.impl=act.db.hibernate.HibernatePlugin
  4. # database driver default to org.h2.Driver
  5. db.driver=...
  6. # database Url default to jdbc:h2:mem:tests
  7. db.url=...
  8. # username default is empty
  9. db.username=...
  10. # password default is empty
  11. db.password=...

域模型

下面创建一个简单的域模型，该模型有三个字段：

  1. id
  2. password
  3. phone
  4. email
  1. package com.mycom.myprj;
  3. import act.util.SimpleBean;
  4. import javax.persistence.*;
  6. @Entity
  7. @Table(name = "user")
  8. public class User{
  10.     @Id
  11.     @GeneratedValue(strategy = GenerationType.IDENTITY)
  12.     private Integer id;
  13.     @Column
  14.     private String password;
  15.     @Column
  16.     private String email;
  17.     @Column
  18.     private String phone;
  20.     public Integer getId() {
  21.         return id;
  22.     }
  24.     public void setId(Integer id) {
  25.         this.id = id;
  26.     }
  28.     public String getPassword() {
  29.         return password;
  30.     }
  32.     public void setPassword(String password) {
  33.         this.password = password;
  34.     }
  36.     public String getEmail() {
  37.         return email;
  38.     }
  40.     public void setEmail(String email) {
  41.         this.email = email;
  42.     }
  44.     public String getPhone() {
  45.         return phone;
  46.     }
  48.     public void setPhone(String phone) {
  49.         this.phone = phone;
  50.     }
  51. }

数据库访问层

Dao 只需要很简单的 继承自 act.db.jpa.JPADao 就行了。

  1. package com.mycom.myprj;
  3. import act.db.jpa.JPADao;
  4. import com.mycom.myprj.User;
  6. public class UserDao extends JPADao<Integer,User> {
  8. }