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

  
  @Override
  public TaxRate get(Integer taxRateId) {
    String sql = "SELECT * FROM " +quoteTable("tax_rate")+ " WHERE tax_rate_id = ?";
    TaxRate taxRate = getJdbcOperations().queryForObject(sql, 
        new Object[]{taxRateId}, new TaxRateRowMapper());
    
    sql = "SELECT customer_group_id FROM "+quoteTable("tax_rate_to_customer_group")+ " WHERE tax_rate_id =?";
    List<Integer> customerGroupIds = getJdbcOperations()
        .queryForList(sql, Integer.class, taxRateId);
    taxRate.setCustomerGroupIds(customerGroupIds);

    String sql = "SELECT tr.tax_rate_id, tr.name AS name, tr.rate, tr.type, tr.geo_zone_id, gz.name AS geo_zone, tr.date_added, tr.date_modified FROM " 
        +quoteTable("tax_rate")+ " tr LEFT JOIN " +quoteTable("geo_zone")+ " gz ON (tr.geo_zone_id = gz.geo_zone_id)";
    //sortedKeys={"tr.name", "tr.rate", "tr.type", "gz.name", "tr.date_added", "tr.date_modified"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    List<TaxRate> taxRateList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new TaxRateRowMapper(){
          @Override
          public TaxRate mapRow(ResultSet rs, int rowNum)
              throws SQLException {
            TaxRate taxRate = super.mapRow(rs, rowNum);
            taxRate.setGeoZone(rs.getString("geo_zone"));

Related Classes of com.jpoweredcart.common.entity.localisation.jdbc.TaxRateRowMapper

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.