List of addOrderRule() Examples

Examples of addOrderRule()

easyJ.database.dao.command.SelectCommand.addOrderRule()
为一个查询增加排序条件，一个查询可以有多个排序条件，按照增加的顺序决定优先级 @param orderRule OrderRule @throws EasyJException

Examples of easyJ.database.dao.command.SelectCommand.addOrderRule()

        /* 如果没有排序，则默认为按照主键排序 */
        if (orderRules == null)
            orderRules = getDefaultOrderRule(o.getClass());
        if (orderRules != null) {
            for (int i = 0; i < orderRules.length; i++)
                scmd.addOrderRule(orderRules[i]);
        }
        scmd.setFilter(filter);
        String sql = scmd.getSQL();
        // EasyJLog.debug(scmd.getExecutableSQL());

View Full Code Here

Examples of easyJ.database.dao.command.SelectCommand.addOrderRule()

        /* 如果没有排序，则默认为按照主键排序 */
        if (orderRules == null)
            orderRules = getDefaultOrderRule(lower.getClass());
        if (orderRules != null) {
            for (int i = 0; i < orderRules.length; i++)
                scmd.addOrderRule(orderRules[i]);
        }
        scmd.setFilter(filter);
        // EasyJLog.debug(scmd.getExecutableSQL());
        ArrayList result = (ArrayList) scmd.execute(conn);
        accurateProperties = null;

View Full Code Here

Examples of easyJ.database.dao.command.SelectCommand.addOrderRule()

        scmd.setLimits((currentPageNo - 1) * Page.pageSize, currentPageNo
                * Page.pageSize);
        /* 如果没有排序，则默认为按照主键排序 */
        if (GenericValidator.isBlankOrNull(orderbyClauses)) {
            OrderRule rule = getDefaultOrderRule(clazz)[0];
            scmd.addOrderRule(rule);
        } else {
            StringTokenizer orderbyClausesToken = new StringTokenizer(
                    orderbyClauses, ",");
            while (orderbyClausesToken.hasMoreElements()) {
                String orderbyClause = orderbyClausesToken.nextToken();

View Full Code Here

Examples of easyJ.database.dao.command.SelectCommand.addOrderRule()

                        orderbyClause, " ");
                String propertyName = conditionToken.nextToken();
                OrderDirection direction = new OrderDirection(conditionToken
                        .nextToken());
                OrderRule orderRule = new OrderRule(propertyName, direction);
                scmd.addOrderRule(orderRule);
            }
        }
        ArrayList list = (ArrayList) scmd.execute(conn);
        page.setPageData(list);
        return page;

View Full Code Here

Examples of easyJ.database.dao.command.SelectCommand.addOrderRule()

        /* 如果没有排序，则默认为按照主键排序 */
        if (orderRules == null)
            orderRules = getDefaultOrderRule(o.getClass());
        if (orderRules != null) {
            for (int i = 0; i < orderRules.length; i++)
                scmd.addOrderRule(orderRules[i]);
        }
        scmd.setLimits((currentPageNo - 1) * Page.pageSize, currentPageNo
                * Page.pageSize);
        // 因为sql的语句中条件出现了两次，所以参数也要两次。
        paramList.addAll(paramList);

View Full Code Here

Examples of easyJ.database.dao.command.SelectCommand.addOrderRule()

        /* 如果没有排序，则默认为按照主键排序 */
        if (orderRules == null)
            orderRules = getDefaultOrderRule(lower.getClass());
        if (orderRules != null) {
            for (int i = 0; i < orderRules.length; i++)
                scmd.addOrderRule(orderRules[i]);
        }
        scmd.setLimits((currentPageNo - 1) * Page.pageSize, currentPageNo
                * Page.pageSize);
        // 因为sql的语句中条件出现了两次，所以参数也要两次。
        paramList.addAll(paramList);

View Full Code Here

Examples of easyJ.database.dao.command.SelectCommand.addOrderRule()

                        SQLOperator.EQUAL, scenarioversion.getCreatorId()
                                .toString());
                filter1.addFilter(filter2);
                filter1.addFilter(filter3, LogicOperator.AND);
                scmd.setFilter(filter1);
                scmd.addOrderRule(new OrderRule("scenarioVersionId",
                        OrderDirection.DESC));
                descriptionList = session.query(scmd);
                if (descriptionList.size() > 0) {


                    oldescription = (DescriptionVersion) descriptionList.get(0);

View Full Code Here

Examples of easyJ.database.dao.command.SelectCommand.addOrderRule()

        SelectCommand scmdDescriptionVersion = DAOFactory
                .getSelectCommand(clazz);
        Filter filter = DAOFactory.getFilter("creatorId", SQLOperator.EQUAL,
                creatorId);
        scmdDescriptionVersion.setFilter(filter);
        scmdDescriptionVersion.addOrderRule(new OrderRule(
                "descriptionVersionId", OrderDirection.DESC));
        Session session = SessionFactory.openSession();
        ArrayList tempdescriptionVersions = session
                .query(scmdDescriptionVersion);
        ArrayList descriptionVersions = new ArrayList();

View Full Code Here

TOP

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.