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

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


 
  @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


 
  @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

  @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

    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

 
  @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

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.