public int checkCodeOnly(DictionaryBean bean)throws DataAccessException,Exception { <br>Object[] sqlParams = new Object[4]; <br>int index = 0 <int index="0">String sql=""; <br>/* 驗證頁面標誌是否唯一*/ <br>if (bean.getFlag().equals("1")) { <br>sql = "select count(1) from YHAO_PORTALS_PAGE where PAGE_FLAG = ? "; <br>sqlParams[index]=bean.getCode(); <br>index ; <br>} <br>/* 驗證類型志標識是否唯一*/ <br>if (beanan .getFlag().equals("2")) { <br>sql = "select count(1) from YHAO_PORTALS_DOWNTYPE where DOWNTYPE_FLAG = ? "; <br>sqlParams[index]=bean.getCode();; ; <br>} <br>/* 驗證下載志標識是否唯一*/ <br>if (bean.getFlag().equals("3")) { <br>sql = "select count(1) from YHAO_PORTALS_DOWN where DOWN_FLAG = ? "; <br>sqlParams[index]=bean.getCode(); <br>index ; <br>} <br>if (bean.getFlag().equals("4")) { <br>if (bean.getFlag().equals("4")) { <br>if (bean.getFlag().equals("4")) { <br>sql = "select count(1) from YHAO_PORTALS_KUAI where KUAI_FLAG = ? "; <br>sqlParams[index]=bean.getCode(); <br>index ; <br>} <br>Object[] sqlParamsEnd [index]; <br>System.arraycopy(sqlParams, 0, sqlParamsEnd, 0, index); <br>int count = this.queryForInt(sql,sqlParamsEnd); <br>return count; <br>}); <br>return>}; > <br><pre class="brush:php;toolbar:false">