Examples of StockStatusRowMapper

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

71
72
73
74
75
76
77
  @Override
  public StockStatus get(Integer stockStatusId) {
    String sql = "SELECT * FROM " +quoteTable("stock_status")+ " WHERE stock_status_id = ? and language_id = ?";
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    return getJdbcOperations().queryForObject(sql, new Object[]{stockStatusId, languageId},
        new StockStatusRowMapper());
  }
View Full Code Here

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

82
83
84
85
86
87
88
89
90
    //sortedKeys={"name"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    query.addParameters(languageId);
    List<StockStatus> stockStatusList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new StockStatusRowMapper());
   
    return stockStatusList;
  }
View Full Code Here

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

92
93
94
95
96
97
98
99
100
  @Override
  public StockStatuses getStockStatuses(Integer descId) {
    String sql = "SELECT s.stock_status_id, s.name, s.language_id, l.name AS language_name, l.image AS language_image FROM " +
        quoteTable("stock_status")+" s INNER JOIN "+quoteTable("language")+" l ON s.language_id=l.language_id WHERE stock_status_id=?";
    List<StockStatus> list = getJdbcOperations().query(sql, new Object[]{descId},
        new StockStatusRowMapper());
    StockStatuses stockStatuses = new StockStatuses(list);
    return stockStatuses;
  }
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.