Package com.jpoweredcart.common.entity.sale.jdbc

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
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
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
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
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

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

  • com.jpoweredcart.admin.model.sale.impl.AffiliateAdminModelImpl
  • com.jpoweredcart.common.service.impl.UserServiceImpl
  • java.math.BigDecimal
    • Copyright © 2018 www.massapicom. 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.