Querydsl是一个采用API代替拼凑字符串来构造查询语句，可跟 Hibernate 和 JPA 等框架结合使用。网上很多教程都是结合spring JPA框架下使用的教程，本文介绍的是非spring环境下querydsl JPA整合使用。

1、使用eclipse生成jpa实体类，IDEA也能生成同样JPA实体类。

鼠标右键打开JPA Tools工具：

创建数据库链接：

选择那些数据库表需要生成JPA实体类：

关联表生成：

设置实体生成属性：

单个实体属性修改

生成的JPA实体类AdminLog.java

package com.test.db.entity;import java.io.Serializable;import javax.persistence.*;import java.util.Date;/** * The persistent class for the admin_log database table. * */@Entity@Table(name="admin_log")@NamedQuery(name="AdminLog.findAll", query="SELECT a FROM AdminLog a")public class AdminLog implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue(strategy=GenerationType.AUTO) @Column(unique=true, nullable=false) private String id; @Column(name="action_id", length=20) private String actionId; @Column(name="client_ip", length=15) private String clientIp; @Column(name="controller_id", length=20) private String controllerId; @Temporal(TemporalType.TIMESTAMP) @Column(name="create_date") private Date createDate; @Column(name="create_user", length=50) private String createUser; @Column(name="func_name", length=50) private String funcName; @Column(name="module_name", length=50) private String moduleName; @Column(name="right_name", length=50) private String rightName; @Column(length=200) private String url; public AdminLog() { } public String getId() { return this.id; } public void setId(String id) { this.id = id; } public String getActionId() { return this.actionId; } public void setActionId(String actionId) { this.actionId = actionId; } public String getClientIp() { return this.clientIp; } public void setClientIp(String clientIp) { this.clientIp = clientIp; } public String getControllerId() { return this.controllerId; } public void setControllerId(String controllerId) { this.controllerId = controllerId; } public Date getCreateDate() { return this.createDate; } public void setCreateDate(Date createDate) { this.createDate = createDate; } public String getCreateUser() { return this.createUser; } public void setCreateUser(String createUser) { this.createUser = createUser; } public String getFuncName() { return this.funcName; } public void setFuncName(String funcName) { this.funcName = funcName; } public String getModuleName() { return this.moduleName; } public void setModuleName(String moduleName) { this.moduleName = moduleName; } public String getRightName() { return this.rightName; } public void setRightName(String rightName) { this.rightName = rightName; } public String getUrl() { return this.url; } public void setUrl(String url) { this.url = url; }}

2、生成querydsl查询类

maven pom.xml文件

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http:///static/querydsl/latest/reference/html/ch02.html#jpa_integration

java类库：https:///java/awesomejava#database

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。