Examples of easyJ.database.session.Session.query()

easyJ.database.session.Session.query()
此方法用来对数据进行查询 @param className String 进行查询的数据库表对应的类 @param condition String 进行查询的条件里面是直接执行的条件语句，用的是数据库字段名而不是属性名，例如：student_name like '%liu%' @param orderbyClauses String 进行排序的语句，用的也是数据库字段名，例如：order by student_name @param currentPageNo int 用来标识需要的第几页数据 @throws EasyJException @return Page 返回符合条件的处于第currentPageNo页的数据。

                String[] datas = new String[10];
                datas = (String[]) scenarioversion.getDatas().split("\\,");
                Filter filternew = DAOFactory.getFilter("dataId",
                        SQLOperator.IN, datas);
                scmd.setFilter(filternew);
                ArrayList dataList = session.query(scmd);
                for (int j = 0; j < dataList.size(); j++) {
                    data = (Data) dataList.get(j);
                    newDatas = newDatas + data.getDataName();
                }
                // 取以前的datas

View Full Code Here

                    datas = (String[]) oldscenarioversion.getDatas().split(
                            "\\,");
                    Filter filterold = DAOFactory.getFilter("dataId",
                            SQLOperator.IN, datas);
                    scmd.setFilter(filterold);
                    dataList = session.query(scmd);
                    for (int j = 0; j < dataList.size(); j++) {
                        data = (Data) dataList.get(j);
                        oldDatas = oldDatas + data.getDataName();
                    }
                }

View Full Code Here

                participants = (String[]) scenarioversion.getParticipants()
                        .split("\\,");
                Filter filternew = DAOFactory.getFilter("roleId",
                        SQLOperator.IN, participants);
                scmd.setFilter(filternew);
                ArrayList participantList = session.query(scmd);
                for (int j = 0; j < participantList.size(); j++) {
                    participant = (Role) participantList.get(j);
                    newParticipants = newParticipants
                            + participant.getRoleName();
                }

View Full Code Here

                    participants = (String[]) oldscenarioversion
                            .getParticipants().split("\\,");
                    Filter filterold = DAOFactory.getFilter("roleId",
                            SQLOperator.IN, participants);
                    scmd.setFilter(filterold);
                    participantList = session.query(scmd);
                    session.close();
                    for (int j = 0; j < participantList.size(); j++) {
                        participant = (Role) participantList.get(j);
                        oldParticipants = oldParticipants
                                + participant.getRoleName();

View Full Code Here

                communicators = (String[]) scenarioversion.getParticipants()
                        .split("\\,");
                Filter filternew = DAOFactory.getFilter("roleId",
                        SQLOperator.IN, communicators);
                scmd.setFilter(filternew);
                ArrayList communicatorList = session.query(scmd);
                for (int j = 0; j < communicatorList.size(); j++) {
                    communicator = (Role) communicatorList.get(j);
                    newCommunicators = newCommunicators
                            + communicator.getRoleName();
                }

View Full Code Here

                    communicators = (String[]) oldscenarioversion
                            .getParticipants().split("\\,");
                    Filter filterold = DAOFactory.getFilter("roleId",
                            SQLOperator.IN, communicators);
                    scmd.setFilter(filterold);
                    communicatorList = session.query(scmd);
                    session.close();
                    for (int j = 0; j < communicatorList.size(); j++) {
                        communicator = (Role) communicatorList.get(j);
                        oldCommunicators = oldCommunicators
                                + participant.getRoleName();

View Full Code Here

                observers = (String[]) scenarioversion.getParticipants().split(
                        "\\,");
                Filter filternew = DAOFactory.getFilter("roleId",
                        SQLOperator.IN, observers);
                scmd.setFilter(filternew);
                ArrayList communicatorList = session.query(scmd);
                for (int j = 0; j < communicatorList.size(); j++) {
                    observer = (Role) communicatorList.get(j);
                    newObservers = newObservers + observer.getRoleName();
                }
                // 取以前的observers

View Full Code Here

                    observers = (String[]) oldscenarioversion.getParticipants()
                            .split("\\,");
                    Filter filterold = DAOFactory.getFilter("roleId",
                            SQLOperator.IN, observers);
                    scmd.setFilter(filterold);
                    communicatorList = session.query(scmd);
                    session.close();
                    for (int j = 0; j < communicatorList.size(); j++) {
                        observer = (Role) communicatorList.get(j);
                        oldObservers = oldObservers + observer.getRoleName();
                    }

View Full Code Here

                String descriptions = (String) scenarioversion
                        .getScenarioVersionId().toString();
                Filter filternew = DAOFactory.getFilter("scenarioVersionId",
                        SQLOperator.EQUAL, descriptions);
                scmd.setFilter(filternew);
                ArrayList descriptionList = session.query(scmd);
                for (int j = 0; j < descriptionList.size(); j++) {
                    description = (DescriptionVersion) descriptionList.get(j);
                    newDescription = newDescription
                            + description.getDescriptionVersionContent();
                }

View Full Code Here

                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);
                    oldDescription = oldDescription
                            + oldescription.getDescriptionVersionContent();

View Full Code Here

0 1 2 3 4

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.