Package com.jpoweredcart.common

Examples of com.jpoweredcart.common.QueryBean.addParameters()

80
81
82
83
84
85
86
87
88
89
90
  public List<StockStatus> getStockStatuses(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("stock_status")+" WHERE language_id=?";
    //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
80
81
82
83
84
85
86
87
88
89
90
  public List<ReturnStatus> getList(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("return_status")+" WHERE language_id=?";
    //sortedKeys={"name"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    query.addParameters(languageId);
    List<ReturnStatus> returnStatusList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new ReturnStatusRowMapper());
   
    return returnStatusList;
  }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT * FROM " +quoteTable("voucher_theme")+ " vt LEFT JOIN " +quoteTable("voucher_theme_description")
        + " vtd ON (vt.voucher_theme_id = vtd.voucher_theme_id) WHERE vtd.language_id = ?";
    //sortedKeys={"vtd.name"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    List<VoucherTheme> customerGroupList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new VoucherThemeRowMapper(){
          @Override
          public VoucherTheme mapRow(ResultSet rs, int rowNum)
              throws SQLException {
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
  public List<ReturnReason> getList(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("return_reason")+" WHERE language_id=?";
    //sortedKeys={"name"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    query.addParameters(languageId);
    List<ReturnReason> returnReasonList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new ReturnReasonRowMapper());
   
    return returnReasonList;
  }
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
  public List<ReturnAction> getList(PageParam pageParam) {
    String sql = "SELECT * FROM "+quoteTable("return_action")+" WHERE language_id=?";
    //sortedKeys={"name"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    query.addParameters(languageId);
    List<ReturnAction> returnActionList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new ReturnActionRowMapper());
   
    return returnActionList;
  }
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT * FROM " +quoteTable("customer_group")+ " cg LEFT JOIN " +quoteTable("customer_group_description")
        + " cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = ?";
    //sortedKeys={"cgd.name", "cg.sort_order"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    List<CustomerGroup> customerGroupList = getJdbcOperations()
        .query(query.getSql(), query.getParameters(), new CustomerGroupRowMapper(){
          @Override
          public CustomerGroup mapRow(ResultSet rs, CustomerGroup object)
              throws SQLException {
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
    Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
    String sql = "SELECT * FROM " +quoteTable("length_class")+ " wc LEFT JOIN " +quoteTable("length_class_description")+
        " wcd ON (wc.length_class_id = wcd.length_class_id) WHERE wcd.language_id = ?";
    //sortedKeys={"title", "unit", "value"}
    QueryBean query = createPaginationQuery(sql, pageParam);
    query.addParameters(languageId);
    List<LengthClass> lengthClassList = getJdbcOperations().query(query.getSql(),
        query.getParameters(), new LengthClassRowMapper(){
          @Override
          public LengthClass mapRow(ResultSet rs, int rowNum)
              throws SQLException {
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.