Examples of com.jpoweredcart.common.entity.sale.jdbc.IpBlacklistRowMapper

  
  @Override
  public IpBlacklist get(Integer blacklistId, Class<? extends IpBlacklist> clazz) {
    String sql = "SELECT * FROM " +quoteTable("customer_ip_blacklist")+ " WHERE customer_ip_blacklist_id = ?";
    return getJdbcOperations().queryForObject(sql, new Object[]{blacklistId}, 
        new IpBlacklistRowMapper().setTargetClass(clazz));
  }

    String sql = "SELECT *, (SELECT COUNT(DISTINCT customer_id) FROM " +quoteTable("customer_ip")
        + " ci WHERE ci.ip = cib.ip) AS total FROM " +quoteTable("customer_ip_blacklist")+" cib";
    //sortedKeys={"ip"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<IpBlacklist> blacklists = getJdbcOperations().query(query.getSql(), 
        query.getParameters(), new IpBlacklistRowMapper(){
          @Override
          public IpBlacklist mapRow(ResultSet rs, int rowNum)
              throws SQLException {
            IpBlacklist blacklist = super.mapRow(rs, rowNum);
            blacklist.setTotalCustomers(rs.getInt("total"));

Related Classes of com.jpoweredcart.common.entity.sale.jdbc.IpBlacklistRowMapper

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.