Пример #1
0
  /**
   * <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;
  }
Пример #2
0
  /**
   * <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;
  }