/**
* <br>
* [機 能] 検索結果の件数取得 <br>
* [解 説] <br>
* [備 考]
*
* @param searchMdl 検索パラメータ
* @return 検索結果件数
* @throws SQLException SQL実行時例外
*/
public int recordCount(Sml380SearchModel searchMdl) throws SQLException {
PreparedStatement pstmt = null;
ResultSet rs = null;
Connection con = null;
int ret = 0;
con = getCon();
try {
// SQL文
SqlBuffer sql = new SqlBuffer();
sql.addSql(" select ");
sql.addSql(" count(SBC_SID) as CNT");
sql.addSql(" from ");
sql.addSql(" SML_BAN_DEST_CONF");
if (!StringUtil.isNullZeroString(searchMdl.getKeyword())) {
sql.addSql(" where ");
sql.addSql(" SBC_NAME ");
String value =
" like '%"
+ JDBCUtil.encFullStringLike(searchMdl.getKeyword())
+ "%' ESCAPE '"
+ JDBCUtil.def_esc
+ "'";
sql.addSql(value);
}
pstmt = con.prepareStatement(sql.toSqlString());
log__.info(sql.toLogString());
rs = pstmt.executeQuery();
if (rs.next()) {
ret = rs.getInt("CNT");
}
} catch (SQLException e) {
throw e;
} finally {
JDBCUtil.closeResultSet(rs);
JDBCUtil.closeStatement(pstmt);
}
return ret;
}
/**
* <br>
* [機 能] 一覧取得 <br>
* [解 説] <br>
* [備 考]
*
* @param searchMdl 検索パラメータ
* @return 検索結果
* @throws SQLException SQL実行時例外
*/
public List<Sml380DataModel> searchSbc(Sml380SearchModel searchMdl) throws SQLException {
PreparedStatement pstmt = null;
ResultSet rs = null;
Connection con = null;
ArrayList<Sml380DataModel> ret = new ArrayList<Sml380DataModel>();
con = getCon();
try {
// SQL文
SqlBuffer sql = new SqlBuffer();
sql.addSql(" select ");
sql.addSql(" SBC_SID,");
sql.addSql(" SBC_NAME,");
sql.addSql(" SBC_BIKO,");
sql.addSql(" SBC_AUID,");
sql.addSql(" SBC_ADATE,");
sql.addSql(" SBC_EUID,");
sql.addSql(" SBC_EDATE");
sql.addSql(" from ");
sql.addSql(" SML_BAN_DEST_CONF");
if (!StringUtil.isNullZeroString(searchMdl.getKeyword())) {
sql.addSql(" where ");
sql.addSql(" SBC_NAME ");
String value =
" like '%"
+ JDBCUtil.encFullStringLike(searchMdl.getKeyword())
+ "%' ESCAPE '"
+ JDBCUtil.def_esc
+ "'";
sql.addSql(value);
}
sql.addSql(" order by ");
sql.addSql(" SML_BAN_DEST_CONF.SBC_NAME ");
if (searchMdl.getOrder() == GSConstSmail.ORDER_KEY_ASC) {
sql.addSql(" asc ");
} else {
sql.addSql(" desc ");
}
pstmt =
con.prepareStatement(
sql.toSqlString(), ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
sql.setParameter(pstmt);
log__.info(sql.toLogString());
rs = pstmt.executeQuery();
int start = searchMdl.getStart();
int maxCount = searchMdl.getLimit();
if (start > 1) {
rs.absolute(start - 1);
}
for (int i = 0; rs.next() && i < maxCount; i++) {
Sml380DataModel bean = new Sml380DataModel();
bean.setSbcSid(rs.getInt("SBC_SID"));
bean.setDspSbcName(rs.getString("SBC_NAME"));
bean.setDspSbcBiko(StringUtilHtml.transToHTmlPlusAmparsant(rs.getString("SBC_BIKO")));
ret.add(bean);
}
} catch (SQLException e) {
throw e;
} finally {
JDBCUtil.closeResultSet(rs);
JDBCUtil.closeStatement(pstmt);
}
return ret;
}
