# 組件源碼 /** * <b>方法描述：</b> SQL查詢(完整SQL) <br/> * <b>創建者：</b> admin <br/> * <b>創建時間：</b> 2019-03-28 14:59:13 <br/> * * @param poolName * 入參|數據源，為空使用默認|{@link java.lang.String} * @param sqlcmd * 入參|查詢sql語句String|{@link java.lang.String} * @param rownum * 入參|需要獲取的數據筆數int|{@link int} * @param num * 出參|查詢到的行數int|{@link int} * @param result * 出參|所有的行數據JavaList| * {@link com.ylink.ide.trade.runtime.context.JavaList} * @return -1 異常<br/> * 2 無數據<br/> * 1 成功<br/> */ @Component(label = "SQL查詢(完整SQL)", style = "判斷型", type = "同步組件", comment = "根據sql查詢語句獲取查詢的數據,默認是取所有,可以指定需要獲取的行數,list中存放查詢到的筆數和數據,格式為:[筆數,所有行的list]", version = "1.0.0", deprecated = false, author = "admin", date = "2019-03-28 02:59:13") @InParams(param = { @Param(name = "poolName", comment = "數據源，為空使用默認", type = java.lang.String.class), @Param(name = "sqlcmd", comment = "查詢sql語句String", type = java.lang.String.class), @Param(name = "rownum", comment = "需要獲取的數據筆數int", type = int.class) }) @OutParams(param = { @Param(name = "num", comment = "查詢到的行數int", type = int.class), @Param(name = "result", comment = "所有的行數據JavaList", type = com.ylink.ide.trade.runtime.context.JavaList.class) }) @Returns(returns = { @Return(id = "-1", desp = "異常"), @Return(id = "2", desp = "無數據"), @Return(id = "1", desp = "成功") }) public static ResultBase P_dmlSelect(String poolName, String sqlcmd, int rownum) { try { JavaList jList = JdbcUtil.dmlSelect(poolName, sqlcmd, rownum); int size = jList.size(); if (jList == null || size < 1) { return new ResultBase(2); } return ResultBase.newSuccessResult(size, jList); } catch (Exception e) { AppLog.error(e); return ResultBase.newExceptionResult("TPTJ0008", "SQL查詢 異常：" + AppLog.errorMsg(e)); } } 交易中組件使用方式：  數據源的來源為項目的配置文件中的數據源，以及前端頁面上的數據源管理列表中添加的數據源