Examples of ZoneRowMapper

Examples of com.jpoweredcart.common.entity.localisation.jdbc.ZoneRowMapper

42
43
44
45
46
47
48
  }

  @Override
  public Zone get(Integer zoneId) {
    String sql = "SELECT * FROM " +quoteTable("zone")+ " WHERE zone_id = ?";
    return getJdbcOperations().queryForObject(sql, new Object[]{zoneId}, new ZoneRowMapper());
  }
View Full Code Here

Examples of com.jpoweredcart.common.entity.localisation.jdbc.ZoneRowMapper

52
53
54
55
56
57
58
59
    String sql = "SELECT z.zone_id, z.country_id, z.code, z.name, z.status, c.name AS country_name FROM " +
        quoteTable("zone") + " z LEFT JOIN "+quoteTable("country") + " c ON (z.country_id = c.country_id)";
    //sortedKeys={"c.name", "z.name", "z.code"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<Zone> zoneList = getJdbcOperations().query(query.getSql(),
        query.getParameters(), new ZoneRowMapper());
    return zoneList;
  }
View Full Code Here

Examples of com.jpoweredcart.common.entity.localisation.jdbc.ZoneRowMapper

60
61
62
63
64
65
66
67
68
 
  @Override
  public List<Zone> getAllByCountryId(Integer countryId){
    String sql = "SELECT * FROM " +quoteTable("zone")+ " WHERE country_id = ? ORDER BY name";
    List<Zone> zoneList = getJdbcOperations().query(sql,
        new Object[]{countryId}, new ZoneRowMapper());
    //TODO: set cache ??
    return zoneList;
  }
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.