Activiti6对象查询案例

我就是我 2024-04-17 17:53 40阅读 0赞

### 一、对象查询举例 ###

/**
         * 对象查询Query：
         * asc desc count list listPage singleResult 用法举例
         * 用户组表查询举例
         */
        @Test
        public void testObjectQuery(){
            //1.查询list()
            List<Group> groupList = identityService.createGroupQuery().list();
            if(groupList==null||groupList.size()==0){//如果，没有测试数据，创建10条
                for(int i=0;i<10;i++){
                    Group group=identityService.newGroup(i+"");//创建一个用户组
                    group.setName("Group_"+i);
                    group.setType("Type_"+i);
                    identityService.saveGroup(group);
                }
            }else{//遍历打印输出
                for (Group group : groupList) {
                    System.out.println(group.getId()+","+group.getName()+","+group.getType());
                }
                System.out.println("查询list()结束#################################");
            }
            
            //2.分页查询listPage()
            groupList = identityService.createGroupQuery().listPage(1, 5);
            for (Group group : groupList) {
                System.out.println(group.getId()+","+group.getName()+","+group.getType());
            }
            System.out.println("分页查询listPage()结束#################################");
    
            // 3.count()数量
            long count = identityService.createGroupQuery().count();
            System.out.println("数量count()："+count);
            System.out.println("查询count()数量结束#################################");
    
            //4.desc和asc，多个字段排序举例
            groupList = identityService.createGroupQuery().orderByGroupName().desc().orderByGroupType().desc().list();
            for (Group group : groupList) {
                System.out.println(group.getId()+","+group.getName()+","+group.getType());
            }
            System.out.println("desc和asc结束#################################");
    
            //5.查询singResult(),假如数据库中有多个会抛出异常
            Group group = identityService.createGroupQuery().groupName("Group_0").singleResult();
            System.out.println(group.getId()+","+group.getName()+","+group.getType());
            System.out.println("查询singResult()结束#################################");
        }

测试结果：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70][]

### 二、原生SQL查询举例 ###

/**
         * 原生SQL查询Query
         * 用户组表查询举例
         */
        @Test
        public void testNativeSql(){
            Group group = identityService.createNativeGroupQuery()
                    .sql("select * from act_id_group where name_=#{name}")
                    .parameter("name", "Group_2").singleResult();
            System.out.println(group.getId()+","+group.getName()+","+group.getType());
        }

测试结果：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/6fd99a522bb347308327b7228a060292.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/8e3a322185ce49e5ac2cc49102a94bf6.png