第一步:配置pom.xml
<!-- 使用jpa连接数据库-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<!-- mysql连接-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!-- jpa的dsl查询所需依赖-->
<dependency>
<groupId>com.querydsl</groupId>
<artifactId>querydsl-jpa</artifactId>
</dependency>
<dependency>
<groupId>com.querydsl</groupId>
<artifactId>querydsl-apt</artifactId>
<version>4.1.4</version>
</dependency>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
<!-- 添加这个插件是为了让程序自动生成query type(查询实体,命名方式为:"Q"+对应实体名)-->
<plugin>
<groupId>com.mysema.maven</groupId>
<artifactId>apt-maven-plugin</artifactId>
<version>1.1.3</version>
<executions>
<execution>
<phase>generate-sources</phase>
<goals>
<goal>process</goal>
</goals>
<configuration>
<outputDirectory>target/generated-sources/java</outputDirectory>
<processor>com.querydsl.apt.jpa.JPAAnnotationProcessor</processor>
</configuration>
</execution>
</executions>
</plugin>
</plugins>
</build>
第二步:配置application.properties
#数据库地址
spring.datasource.url=jdbc:mysql://localhost:3306/querydsl?allowPublicKeyRetrieval=true
spring.datasource.username= mysql的username
spring.datasource.password= mysql的password
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver #数据库驱动
spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect #数据库方言
spring.jpa.hibernate.ddl-auto=update #生成策略
spring.jpa.show-sql=true #是否显示sql语句
特殊情况:可能小伙伴们在生成Q类后但是无法使用