<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                # 組件源碼 /** * <b>方法描述:</b> 預編譯SQL查詢(參數) <br/> * <b>創建者:</b> admin <br/> * <b>創建時間:</b> 2019-03-28 15:00:26 <br/> * * @param poolName * 入參|數據源,為空使用默認|{@link java.lang.String} * @param sqlcmd * 入參|預編譯查詢sql語句String,可以含?|{@link java.lang.String} * @param values * 入參|SQL語句中?的值JavaList,列中的值順序要和?的位置對應,如:[VAL1,VAL2...]| * {@link com.ylink.ide.trade.runtime.context.JavaList} * @param rownum * 入參|需要獲取的數據筆數int|{@link int} * @param num * 出參|查詢到的行數int|{@link int} * @param result * 出參|所有的行數據list| * {@link com.ylink.ide.trade.runtime.context.JavaList} * @return -1 異常<br/> * 0 失敗<br/> * 2 無數據<br/> * 1 成功<br/> */ @Component(label = "預編譯SQL查詢(參數)", style = "判斷型", type = "同步組件", comment = "根據sql查詢語句獲取查詢的數據,默認是取所有,可以指定需要獲取的行數,list中存放查詢到的筆數和數據,格式為:[筆數,所有行的list]", version = "1.0.0", deprecated = false, author = "admin", date = "2019-03-28 03:00:26") @InParams(param = { @Param(name = "poolName", comment = "數據源,為空使用默認", type = java.lang.String.class), @Param(name = "sqlcmd", comment = "預編譯查詢sql語句String,可以含?", type = java.lang.String.class), @Param(name = "values", comment = "SQL語句中?的值JavaList,列中的值順序要和?的位置對應,如:[VAL1,VAL2...]", type = com.ylink.ide.trade.runtime.context.JavaList.class), @Param(name = "rownum", comment = "需要獲取的數據筆數int", type = int.class) }) @OutParams(param = { @Param(name = "num", comment = "查詢到的行數int", type = int.class), @Param(name = "result", comment = "所有的行數據list", type = com.ylink.ide.trade.runtime.context.JavaList.class) }) @Returns(returns = { @Return(id = "-1", desp = "異常"), @Return(id = "0", desp = "失敗"), @Return(id = "2", desp = "無數據"), @Return(id = "1", desp = "成功") }) public static ResultBase P_preparedSelect(String poolName, String sqlcmd, JavaList values, int rownum) { try { JavaList jList = JdbcUtil.preparedSelect(poolName, sqlcmd, values, rownum); if (jList.size() == 0) { return new ResultBase(2); } else { int size = jList.size(); return ResultBase.newSuccessResult(size, jList); } } catch (Exception e) { AppLog.error(e); return ResultBase.newExceptionResult("TPTJ0010", "SQL查詢(參數) 異常:" + AppLog.errorMsg(e)); } } 交易中組件使用方式: ![](https://img.kancloud.cn/ae/a4/aea4a3053a9eb856a9bbb6c25de5f250_1694x1120.jpg) 數據源的來源為項目的配置文件中的數據源,以及前端頁面上的數據源管理列表中添加的數據源 ## 參數說明及示例 預編譯查詢sql語句String,可以含?:在里面填寫可執行的預編譯sql語句,示例: `"select * from sys_user where name = ? and age < ?"` SQL語句中?的值JavaList,列中的值順序要和?的位置對應:對應sql語句中?的值,根據數據庫的字段類型正確填寫對應的字段值,示例: `["張三", 47]` 需要獲取的數據筆數int:需要獲取的數據條數,示例: `3` 查詢到的行數int:查詢到的數據條數,示例: `__INNER__["totle"]` 所有的行數據list:填寫true或者false,示例: `__INNER__["result"]`
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看