詳解非spring框架下使用querydsl的方法
更新時間：2019年01月09日 10:28:52 作者：penngo
Querydsl是一個采用API代替拼湊字符串來構造查詢語句，可跟 Hibernate 和 JPA 等框架結合使用。本文介紹的是非spring環(huán)境下querydsl JPA整合使用，感興趣的小伙伴們可以參考一下
Querydsl是一個采用API代替拼湊字符串來構造查詢語句，可跟 Hibernate 和 JPA 等框架結合使用。網上很多教程都是結合spring JPA框架下使用的教程，本文介紹的是非spring環(huán)境下querydsl JPA整合使用。
1、使用eclipse生成jpa實體類，IDEA也能生成同樣JPA實體類。
鼠標右鍵打開JPA Tools工具：
創(chuàng)建數據庫鏈接：
選擇那些數據庫表需要生成JPA實體類：
關聯(lián)表生成：
設置實體生成屬性：
單個實體屬性修改
生成的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://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.test.db</groupId>
<artifactId>dbtest</artifactId>
<packaging>jar</packaging>
<version>1.0-SNAPSHOT</version>
<name>dbtest</name>
<url>http://maven.apache.org</url>
<properties>
<querydsl.version>4.2.1</querydsl.version>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>com.querydsl</groupId>
<artifactId>querydsl-sql</artifactId>
<version>${querydsl.version}</version>
</dependency>
<dependency>
<groupId>com.querydsl</groupId>
<artifactId>querydsl-apt</artifactId>
<version>${querydsl.version}</version>
</dependency>
<dependency>
<groupId>com.querydsl</groupId>
<artifactId>querydsl-jpa</artifactId>
<version>${querydsl.version}</version>
</dependency>
<dependency>
<groupId>com.querydsl</groupId>
<artifactId>querydsl-sql-codegen</artifactId>
<version>${querydsl.version}</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.eclipse.persistence</groupId>
<artifactId>org.eclipse.persistence.jpa</artifactId>
<version>2.6.0</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.6.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-entitymanager</artifactId>
<version>5.4.0.Final</version>
</dependency>
</dependencies>
<build>
<plugins>
<!-- 生成jpa實體插件 -->
<plugin>
<groupId>com.querydsl</groupId>
<artifactId>querydsl-maven-plugin</artifactId>
<version>${querydsl.version}</version>
<executions>
<execution>
<phase>generate-sources</phase>
<goals>
<goal>jpa-export</goal>
</goals>
<configuration>
<targetFolder>${project.basedir}/target/generated-sources/java</targetFolder>
<packages>com.test.db.entity</packages>
</configuration>
</execution>
</executions>
</plugin>
<!-- 生成jpa實體插件 -->
<!--
<plugin>
<groupId>com.mysema.maven</groupId>
<artifactId>apt-maven-plugin</artifactId>
<version>1.1.3</version>
<executions>
<execution>
<goals>
<goal>process</goal>
</goals>
<configuration>
<outputDirectory>target/generated-sources/java</outputDirectory>
<processor>com.querydsl.apt.jpa.JPAAnnotationProcessor</processor>
</configuration>
</execution>
</executions>
</plugin>
-->
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
</plugins>
</build>
</project>
執(zhí)行命令mvn compile或mvn eclipse:eclipse生成jpa實體對應的querydsl查詢類
AdminLog.java對應的querydsl對應查詢類
package com.test.db.entity;
import static com.querydsl.core.types.PathMetadataFactory.*;
import com.querydsl.core.types.dsl.*;
import com.querydsl.core.types.PathMetadata;
import javax.annotation.Generated;
import com.querydsl.core.types.Path;
/**
* QAdminLog is a Querydsl query type for AdminLog
*/
@Generated("com.querydsl.codegen.EntitySerializer")
public class QAdminLog extends EntityPathBase<AdminLog> {
private static final long serialVersionUID = 392071999L;
public static final QAdminLog adminLog = new QAdminLog("adminLog");
public final StringPath actionId = createString("actionId");
public final StringPath clientIp = createString("clientIp");
public final StringPath controllerId = createString("controllerId");
public final DateTimePath<java.util.Date> createDate = createDateTime("createDate", java.util.Date.class);
public final StringPath createUser = createString("createUser");
public final StringPath funcName = createString("funcName");
public final StringPath id = createString("id");
public final StringPath moduleName = createString("moduleName");
public final StringPath rightName = createString("rightName");
public final StringPath url = createString("url");
public QAdminLog(String variable) {
super(AdminLog.class, forVariable(variable));
}
public QAdminLog(Path<? extends AdminLog> path) {
super(path.getType(), path.getMetadata());
}
public QAdminLog(PathMetadata metadata) {
super(AdminLog.class, metadata);
}
}
3、查詢例子
JPA持久化META-INF\persistence.xml配置文件，EntityManagerFactory創(chuàng)建實例時，需要讀取該配置文件：
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
version="2.0">
<persistence-unit name="jpa" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<properties>
<!-- .MySQLInnoDBDialect -->
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL8Dialect"/>
<property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver" />
<property name="javax.persistence.jdbc.url" value="jdbc:mysql://127.0.0.1:3306/yiiboot?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=true" />
<property name="javax.persistence.jdbc.user" value="root" />
<property name="javax.persistence.jdbc.password" value="123" />
<property name="connection.provider_class" value="com.alibaba.druid.support.hibernate.DruidConnectionProvider" />
<!-- 配置初始化大小、最小、最大 -->
<property name="initialSize" value="1" />
<property name="minIdle" value="1" />
<property name="maxActive" value="20" />
<!-- 配置獲取連接等待超時的時間 -->
<property name="maxWait" value="60000" />
<!-- 配置間隔多久才進行一次檢測，檢測需要關閉的空閑連接，單位是毫秒 -->
<property name="timeBetweenEvictionRunsMillis" value="60000" />
<!-- 配置一個連接在池中最小生存的時間，單位是毫秒 -->
<property name="minEvictableIdleTimeMillis" value="300000" />
</properties>
</persistence-unit>
</persistence>
測試代碼
package com.test.db.main;
import java.util.List;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import com.querydsl.jpa.impl.JPAQueryFactory;
import com.test.db.entity.AdminModule;
import com.test.db.entity.QAdminModule;
public class JpaTest {
public static void main(String[] args) throws Exception{
String persistenceUnitName = "jpa";
EntityManagerFactory entityManagerFactory =
Persistence.createEntityManagerFactory(persistenceUnitName);
JPAQueryFactory queryFactory = new JPAQueryFactory(entityManagerFactory.createEntityManager());
QAdminModule adminModule = QAdminModule.adminModule;
List<AdminModule> list = queryFactory.selectFrom(adminModule).fetch();
list.forEach(module->{
System.out.println(module.getId() + "," + module.getDisplayLabel() + "," + module.getCreateDate());
});
}
}
querydsl官方文檔：http://www.querydsl.com/static/querydsl/latest/reference/html/ch02.html#jpa_integration
java類庫：https://www.21doc.net/java/awesomejava#database
以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持腳本之家。
您可能感興趣的文章:
相關文章
這篇文章主要介紹了使用SpringBoot_jar方式啟動并配置日志文件操作，具有很好的參考價值，希望對大家有所幫助。如有錯誤或未考慮完全的地方，望不吝賜教2021-09-09
這篇文章主要給大家介紹了關于mybatis實現一對一關聯(lián)映射的相關資料，文中通過示例代碼介紹的非常詳細，對大家的學習或者工作具有一定的參考學習價值，需要的朋友們下面隨著小編來一起學習學習吧。2017-11-11
這篇文章主要為大家介紹了項目中使用Spring?Cache?Redis實現數據緩存，有需要的朋友可以借鑒參考下，希望能夠有所幫助，祝大家多多進步，早日升職加薪2022-06-06
這篇文章主要介紹了Spring?boot?運用策略模式實現避免多次使用if，文章圍繞主題展開詳細的內容介紹，具有一定的參考價值，需要的小伙伴可以參考一下2022-09-09
兩萬字詳解Java Sring String的常見操作以及StringBuffer StringBuilder的區(qū)別
本篇文章帶你認識Sring、String的常見操作和StringBuffer 與StringBuilder的區(qū)別（字符串詳解），對大家的學習或工作具有一定的參考借鑒價值，需要的朋友可以參考下2021-09-09
使用Mybatis遇到的there is no getter異常
這篇文章主要介紹了使用Mybatis遇到的there is no getter異常，小編覺得挺不錯的，現在分享給大家，也給大家做個參考。一起跟隨小編過來看看吧2018-09-09
下面小編就為大家分享一篇基于JVM 中常見垃圾收集算法介紹，具有很好的參考價值，希望對大家有所幫助。一起跟隨小編過來看看吧2018-01-01
這篇文章主要介紹了基于IDEA中格式化代碼的快捷鍵分享，具有很好的參考價值，希望對大家有所幫助。一起跟隨小編過來看看吧2021-02-02
題目是：求1000！的結果末尾有多少個0,解題思路：兩個素數2、5，相乘即可得到10，我們可以認為，有多少組2、5，結尾就有多少個0，下面是代碼,需要的朋友可以參考下2014-02-02
利用Kafka動態(tài)調整topic分區(qū)partition
這篇文章主要介紹了利用Kafka動態(tài)調整topic分區(qū)partition問題，具有很好的參考價值，希望對大家有所幫助。如有錯誤或未考慮完全的地方，望不吝賜教2022-12-12