default PageResult<PieceConfigurationOrderDO> selectPage(PieceConfigurationOrderPageReqVO reqVO) {
        LambdaQueryWrapperX<PieceConfigurationOrderDO> queryWrapper = new LambdaQueryWrapperX<PieceConfigurationOrderDO>()
                .likeIfPresent(PieceConfigurationOrderDO::getOrderCode, reqVO.getOrderCode())
                .eqIfPresent(PieceConfigurationOrderDO::getPieceItem, reqVO.getPieceItem())
                .eqIfPresent(PieceConfigurationOrderDO::getUnitPrice, reqVO.getUnitPrice())
                .eqIfPresent(PieceConfigurationOrderDO::getUnitId, reqVO.getUnitId())
                .likeIfPresent(PieceConfigurationOrderDO::getUnitName, reqVO.getUnitName())
                .eqIfPresent(PieceConfigurationOrderDO::getStatus, reqVO.getStatus())
                .betweenIfPresent(PieceConfigurationOrderDO::getCreateTime, reqVO.getCreateTime())
                .eqIfPresent(PieceConfigurationOrderDO::getCreator, reqVO.getCreator())
                .orderByDesc(PieceConfigurationOrderDO::getId);
        queryWrapper.apply(reqVO.getCompanyId() != null, "FIND_IN_SET('" + reqVO.getCompanyId() + "',company_id)");
        queryWrapper.apply(reqVO.getDeptId() != null, "FIND_IN_SET('" + reqVO.getDeptId() + "',dept_id)");
        return selectPage(reqVO, queryWrapper);
            LambdaQueryWrapper<PieceConfigurationOrderDO> queryWrapper = new LambdaQueryWrapper<PieceConfigurationOrderDO>()
                    .eq(PieceConfigurationOrderDO::getPieceItem, createReqVO.getPieceItem())
                    .and(wrapper -> {
                        if (createReqVO.getCompanyId() != null) {
                            wrapper.apply("FIND_IN_SET({0}, company_id)", createReqVO.getCompanyId());
                        }
                        if (createReqVO.getDeptId() != null) {
                            wrapper.apply("FIND_IN_SET({0}, dept_id)", createReqVO.getDeptId());
                        }
                    });
            PieceConfigurationOrderDO matchedOrder = pieceConfigurationOrderMapper.selectOne(queryWrapper, false);

通过find_in_set函数实现数据库逗号分隔查询

# 数据库 # mybatis # java # idea
Logo
DAMO开发者矩阵

DAMO开发者矩阵，由阿里巴巴达摩院和中国互联网协会联合发起，致力于探讨最前沿的技术趋势与应用成果，搭建高质量的交流与分享平台，推动技术创新与产业应用链接，围绕“人工智能与新型计算”构建开放共享的开发者生态。

更多推荐

多智能体架构与模型上下文协议（MCP）

在“工业大模型 × 数字孪生 × 具身智能”深度交织的认知型智能制造系统（SoI）中，多智能体架构（Multi-Agent Architecture）与模型上下文协议（Model Context Protocol, MCP）的融合，已成为 2026 年离散制造与高端装备全生命周期服务（AI-PSS）中打通工业异构多模态数据、消灭 AI 幻觉并保障工业级确定性安全反控的绝对硬核标准 [2026年趋势

avatar DAMO开发者矩阵
cover

排序算法在机器人开发中的核心应用与实践

avatar DAMO开发者矩阵

使用概率图路径规划的机器人路径规划研究Octave（Matlab代码实现）

针对复杂未知环境下传统机器人路径规划算法适应性差、避障稳定性弱、全局搜索效率低的问题，本文开展基于概率图的机器人路径规划方法研究。概率图路径规划依托概率路线图建模思想，通过环境随机采样、节点连通性构建、最优路径检索的核心逻辑，摆脱了传统算法对环境精准建模的依赖，具备强环境适配性与高运算效率。本文系统阐述概率图路径规划的核心理论、运行机制与技术优势，基于Octave仿真平台搭建多场景机器人运动规划仿

avatar DAMO开发者矩阵