ThinkChat2.0新版上线,更智能更精彩,支持会话、画图、阅读、搜索等,送10W Token,即刻开启你的AI之旅 广告
# 组件源码 ``` /** * <b>方法描述:</b> 查询(columnMap) <br/> * <b>创建者:</b> admin <br/> * <b>创建时间:</b> 2020-09-14 16:37:54 <br/> * * @param poolName * 入参|数据源名称|{@link java.lang.String} * @param className * 入参|执行操作类名|{@link java.lang.String} * @param map * 入参|字段条件|{@link java.util.Map} * @param list * 出参|查询条数|{@link java.util.List} * @return -1 异常<br/> * 0 失败<br/> * 1 成功<br/> * 2 无数据<br/> */ @Component(label = "查询(columnMap)", style = "判断型", type = "同步组件", comment = "根据数据库表字段查询数据,参数为表字段及其值组成的map", version = "1.0.0", deprecated = false, author = "admin", date = "2020-09-14 04:37:54") @InParams(param = {@Param(name = "poolName", comment = "数据源名称", type = java.lang.String.class), @Param(name = "className", comment = "执行操作类名", type = java.lang.String.class), @Param(name = "map", comment = "字段条件", type = java.util.Map.class)}) @OutParams(param = {@Param(name = "list", comment = "查询条数", type = java.util.List.class)}) @Returns(returns = {@Return(id = "-1", desp = "异常"), @Return(id = "0", desp = "失败"), @Return(id = "2", desp = "无数据"), @Return(id = "1", desp = "成功")}) @Order(value = 2) public static ResultBase P_seleteByMap(String poolName, String className, Map map) { try { AppLog.debug("根据字段查询数据 组件参数:poolName={},className={},map={}", poolName, className, map); if (StringUtil.isEmpty(className)) { return ResultBase.newFailureResult("TPTD0001", "参数错误:执行类参数【className】不能为空"); } if (MapUtil.isEmpty(map)) { return ResultBase.newFailureResult("TPTD0002", "参数错误:查询字段条件【map】不能为空"); } setDatasource(poolName); Object maper = BundleUtil.getService(className); if (maper == null) { return ResultBase.newFailureResult("TPTD0010", "错误:当前环境未找到[" + className + "]的可用数据库操作Mapper 实例"); } Method method = getMethod(maper.getClass(), className, MybatisPlusMapperMehtod.selectByMap); if (method != null) { AppLog.debug("开始执行相应的Mapper 方法"); List list = (List)method.invoke(maper, map); if (list.isEmpty()) return new ResultBase(2); return ResultBase.newSuccessResult(list); } } catch (Exception e) { AppLog.error(e); return ResultBase.newExceptionResult("TPTD0003", "方法调用错误,类:" + className + "调用:" + MybatisPlusMapperMehtod.selectByMap + " 方法错误" + AppLog.errorMsg(e)); } return ResultBase.newFailureResult("TPTD0004", "方法调用错误,类:" + className + "没有可执行方法:" + MybatisPlusMapperMehtod.selectByMap); } ``` # 交易中组件使用方式 ![](https://img.kancloud.cn/cf/60/cf607eff286d5bf87b50bd1245508f2b_1868x896.png) # 参数说明及示例 ## 入口参数 数据源名称:使用的数据源名称,可以为空 执行操作类名:执行 SQL 语句的类,示例: `"data.test.test.mapper.TUserMapper"` 字段条件:表字段及其值组成的 map,示例: `{ "name":"YY" }` ## 出口参数 查询条数:包含输入条件的数据库记录,示例: `__INNER__["list"]` > 当交易部署到微服务上时,数据源在微服务界面上配置。