JPA 快速CRUD (jpa-querydsl-spring-boot-starter)

àì夳堔傛蜴生んèń 2023-02-09 14:23 23阅读 0赞

### **[jpa-querydsl-spring-boot-starter][]** ###

**地址：[https://github.com/uinio/jpa-querydsl-spring-boot-starter][jpa-querydsl-spring-boot-starter]**

兼容 spring boot 2.1 ~2.4 (包含2.1和2.4)

支持 querydsl (spring boot 版本开箱即用)

--------------------

### **使用** ###

1.  添加依赖
    
        <dependency>
               <groupId>com.github.uinio</groupId>
               <artifactId>jpa-querydsl-spring-boot-starter</artifactId>
               <version>2.4.1</version>
           </dependency>

--------------------

1.  示例

*  实体类

@Entity
             public class User implements Serializable {
             
                 @Id
                 private Integer userId;
    
                 private String loginName;
    
                 private String password;
           }

--------------------

> 仓库

public interface UserRepository extends JpaRepository<User, Integer> {
        
    }

--------------------

> 服务

*  提供单表CURD操作

public interface UserService extends JpaService<User, Integer> {
    }

--------------------

@Service
    @Slf4j
    public class UserServiceImpl extends JpaServiceImpl<User, Integer> implements UserService {
        
    }

--------------------

> 测试

@SpringBootTest
    class MainApplicationTests {
    
        @Autowired
        private UserService userService;
    
        @Test
        void contextLoads() {
           User user = new User();
           user.setLoginName("test");
           user.setpPassword("test");
    
           userService.save(user);
    
           userService.page(1, 2);
    
           userService.findById(1);
           //...
        }
    
    
    }

querydsl 开箱即用

配置

<build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
                <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>
                    <dependencies>
                        <dependency>
                            <groupId>com.querydsl</groupId>
                            <artifactId>querydsl-apt</artifactId>
                            <version>${querydsl.version}</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>

mvn compile 生成query类

@SpringBootTest
    class MainApplicationTests {
    
        @Autowired
        private JPAQueryFactory jpaQueryFactory;
    
        @Test
        void contextLoads() {
           QUser user = QUser.user;
           jpaQueryFactory.update(user).set(user.password,"123")
            .where(user.userId.eq(1))execute();
        }
    
    
    }

[jpa-querydsl-spring-boot-starter]: https://github.com/uinio/jpa-service-spring-boot-starter