Package com.jpoweredcart.common.entity.catalog.jdbc

Examples of com.jpoweredcart.common.entity.catalog.jdbc.InformationRowMapper$Store


    String sql = "SELECT DISTINCT *, (SELECT keyword FROM " +quoteTable("url_alias")
        + " WHERE query = ?) AS keyword FROM "
        + quoteTable("information")+" WHERE information_id = ?";
    InformationForm infoForm = (InformationForm)getJdbcOperations().queryForObject(
        sql, new Object[]{"information_id="+infoId, infoId},
        new InformationRowMapper(){
          @Override
          public Information mapRow(ResultSet rs, int rowNum)
              throws SQLException {
            InformationForm form = (InformationForm)super.mapRow(rs, rowNum);
            form.setKeyword(rs.getString("keyword"));
View Full Code Here


  @Override
  public Information get(Integer infoId, Class<? extends Information> clazz) {
   
    String sql = "SELECT * FROM " + quoteTable("information")+" WHERE information_id = ?";
    Information info = getJdbcOperations().queryForObject(sql,
        new Object[]{infoId}, new InformationRowMapper().setTargetClass(clazz));
    return info;
  }
View Full Code Here

        + " id ON (i.information_id = id.information_id) WHERE id.language_id = ?";
    //sortedKeys={"id.title", "i.sort_order"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    List<Information> infoList = getJdbcOperations().query(query.getSql(),
        query.getParameters(), new InformationRowMapper(){
      @Override
      public Information mapRow(ResultSet rs, int rowNum)
          throws SQLException {
        Information info = super.mapRow(rs, rowNum);
        info.setTitle(rs.getString("title"));
View Full Code Here

TOP

Related Classes of com.jpoweredcart.common.entity.catalog.jdbc.InformationRowMapper$Store

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.