Examples of AffiliateRowMapper

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

27
28
29
30
31
32
33
 
  @Override
  public Affiliate getAffiliateByEmail(String email) {
    String sql = "SELECT * FROM "+quoteTable("affiliate")+" WHERE LCASE(email) =?";
    return getJdbcOperations().queryForObject(sql, new Object[]{email},
        new AffiliateRowMapper());
  }
View Full Code Here

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

104
105
106
107
108
109
110
 
  @Override
  public Affiliate get(Integer affId, Class<? extends Affiliate> clazz) {
    String sql = "SELECT * FROM "+quoteTable("affiliate")+" WHERE affiliate_id=?";
    return getJdbcOperations().queryForObject(sql, new Object[]{affId},
        new AffiliateRowMapper().setTargetClass(clazz));
  }
View Full Code Here

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

111
112
113
114
115
116
117
  @Override
  public Affiliate getOneByEmail(String email) {
    String sql = "SELECT DISTINCT * FROM "+quoteTable("affiliate")+" WHERE LCASE(email) =?";
    return getJdbcOperations().queryForObject(sql, new Object[]{email},
        new AffiliateRowMapper());
  }
View Full Code Here

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

151
152
153
154
155
156
157
158
159
160
161
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(params.toArray());
    System.out.println(query.getSql());
    System.out.println(query.getParameterList());
    return getJdbcOperations().query(query.getSql(),
        query.getParameters(), new AffiliateRowMapper(){
          @Override
          public Affiliate mapRow(ResultSet rs, int rowNum)
              throws SQLException {
            Affiliate aff = super.mapRow(rs, rowNum);
            aff.setBalance(rs.getBigDecimal("balance"));
View Full Code Here

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

175
176
177
178
179
180
181
 
  @Override
  public List<Affiliate> getAllByNewsletter() {
   
    String sql = "SELECT * FROM "+quoteTable("affiliate")+ " WHERE newsletter =? ORDER BY firstname, lastname, email";
    return getJdbcOperations().query(sql, new Object[]{Boolean.TRUE}, new AffiliateRowMapper());
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.