Example usage for org.apache.ibatis.session RowBounds RowBounds

Introduction

In this page you can find the example usage for org.apache.ibatis.session RowBounds RowBounds.

Prototype

public RowBounds(int offset, int limit)

Source Link

Usage

From source file:com.glaf.core.service.impl.MxMembershipServiceImpl.java

License:Apache License

public List<Membership> getMembershipsByQueryCriteria(int start, int pageSize, MembershipQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<Membership> rows = sqlSessionTemplate.selectList("getMemberships", query, rowBounds);
    return rows;//w  w w  . jav  a 2s . c o m
}

From source file:com.glaf.core.service.impl.MxQueryDefinitionServiceImpl.java

License:Apache License

/**
 * ????//from ww w  .ja  va  2s.co m
 * 
 * @return
 */
public List<QueryDefinition> getQueryDefinitionsByQueryCriteria(int start, int pageSize,
        QueryDefinitionQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<QueryDefinition> rows = sqlSession.selectList("getQueryDefinitions", query, rowBounds);
    return rows;
}

From source file:com.glaf.core.service.impl.MxSchedulerLogServiceImpl.java

License:Apache License

/**
 * ????//ww  w.java2s. c  o m
 * 
 * @return
 */
public List<SchedulerLog> getSchedulerLogsByQueryCriteria(int start, int pageSize, SchedulerLogQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SchedulerLog> rows = sqlSessionTemplate.selectList("getSchedulerLogs", query, rowBounds);
    return rows;
}

From source file:com.glaf.core.service.impl.MxSysCalendarServiceImpl.java

License:Apache License

public List<SysCalendar> getSysCalendarsByQueryCriteria(int start, int pageSize, SysCalendarQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysCalendar> rows = sqlSessionTemplate.selectList("getSysCalendars", query, rowBounds);
    return rows;/*from  w ww. java2  s  .co  m*/
}

From source file:com.glaf.core.service.impl.MxSysDataItemServiceImpl.java

License:Apache License

/**
 * ????/*from  ww w. java2s  .co  m*/
 * 
 * @return
 */
public List<SysDataItem> getSysDataItemsByQueryCriteria(int start, int pageSize, SysDataItemQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysDataItem> rows = sqlSessionTemplate.selectList("getSysDataItems", query, rowBounds);
    return rows;
}

From source file:com.glaf.core.service.impl.MxSysDataLogServiceImpl.java

License:Apache License

public List<SysDataLog> getSysDataLogsByQueryCriteria(int start, int pageSize, SysDataLogQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysDataLog> rows = sqlSessionTemplate.selectList("getSysDataLogs", query, rowBounds);
    return rows;// w w w  .ja v  a2s .  com
}

From source file:com.glaf.core.service.impl.MxSysDataServiceImpl.java

License:Apache License

public List<SysData> getSysDatasByQueryCriteria(int start, int pageSize, SysDataQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysData> rows = sqlSessionTemplate.selectList("getSysDatas", query, rowBounds);
    return rows;//from  w w  w. ja va2s  .  c o  m
}

From source file:com.glaf.core.service.impl.MxSysDataTableServiceImpl.java

License:Apache License

public List<SysDataTable> getDataTablesByQueryCriteria(int start, int pageSize, SysDataTableQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysDataTable> rows = sqlSessionTemplate.selectList("getSysDataTables", query, rowBounds);
    return rows;/*  w w w.  j  ava2 s  . co m*/
}

From source file:com.glaf.core.service.impl.MxSysDataTableServiceImpl.java

License:Apache License

/**
 * ??/*from  w w  w.j  a  va2 s.c  om*/
 * 
 * @param start
 * @param pageSize
 * @param query
 * @return
 */
public JSONObject getPageTableData(int start, int pageSize, SysDataTableQuery query) {
    JSONObject result = new JSONObject();
    SysDataTable dataTable = this.getDataTableByName(query.getTablename());
    if (dataTable == null) {
        return result;
    }

    TableModel tableModel = new TableModel();
    tableModel.setTableName(query.getTablename());
    tableModel.setDataRequest(query.getDataRequest());
    int total = tableDataMapper.getTableCountByConditions(tableModel);
    if (total > 0) {
        result.put("total", total);
        Map<String, SysDataField> fieldMap = new HashMap<String, SysDataField>();
        if (dataTable.getFields() != null) {
            List<SysDataField> fields = dataTable.getFields();
            for (SysDataField field : fields) {
                if (field.getName() != null) {
                    fieldMap.put(field.getColumnName(), field);
                    fieldMap.put(field.getColumnName().toLowerCase(), field);
                }
            }
        }

        if (StringUtils.isNotEmpty(dataTable.getSortColumnName())) {
            String orderBy = " order by E." + dataTable.getSortColumnName();
            if (StringUtils.equals(dataTable.getSortOrder(), "desc")) {
                orderBy = orderBy + " desc";
            } else {
                orderBy = orderBy + " asc";
            }
            tableModel.setOrderBy(orderBy);
        }

        RowBounds rowBounds = new RowBounds(start, pageSize);
        List<Map<String, Object>> list = sqlSessionTemplate.selectList("getTableDataByConditions", tableModel,
                rowBounds);
        if (list != null && !list.isEmpty()) {
            JSONArray array = new JSONArray();
            for (Map<String, Object> rowMap : list) {
                JSONObject json = new JSONObject();
                Set<Entry<String, Object>> entrySet = rowMap.entrySet();
                for (Entry<String, Object> entry : entrySet) {
                    String key = entry.getKey();
                    Object value = entry.getValue();
                    if (value != null) {
                        if (fieldMap.get(key.toLowerCase()) != null) {
                            SysDataField field = fieldMap.get(key.toLowerCase());
                            if ("Date".equals(field.getDataType())) {
                                if (value instanceof Date) {
                                    Date date = (Date) value;
                                    json.put(field.getName(), DateUtils.getDate(date));
                                    json.put(field.getName() + "_date", DateUtils.getDate(date));
                                    json.put(field.getName() + "_datetime", DateUtils.getDateTime(date));
                                } else if (value instanceof Long) {
                                    Date date = new Date((Long) value);
                                    json.put(field.getName(), DateUtils.getDate(date));
                                    json.put(field.getName() + "_date", DateUtils.getDate(date));
                                    json.put(field.getName() + "_datetime", DateUtils.getDateTime(date));
                                } else {
                                    json.put(field.getName(), value);
                                }
                            } else {
                                json.put(field.getName(), value);
                            }
                        } else {
                            json.put(key.toLowerCase(), value);
                        }
                    }
                }
                array.add(json);
            }
            result.put("rows", array);
        }
    }
    return result;
}

From source file:com.glaf.core.service.impl.MxSysKeyServiceImpl.java

License:Apache License

/**
 * ????// ww  w.  java  2  s  .co  m
 * 
 * @return
 */
public List<SysKey> getSysKeysByQueryCriteria(int start, int pageSize, SysKeyQuery query) {
    RowBounds rowBounds = new RowBounds(start, pageSize);
    List<SysKey> rows = sqlSessionTemplate.selectList("getSysKeys", query, rowBounds);
    return rows;
}