Package easyJ.database.session

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

314
315
316
317
318
319
320
321
322
323
324
        Session session = null;
        try {
            session = SessionFactory.openSession();
            session.setAccurateProperties(accurateProperties);
            // change the o's use_state
            return session.query(className, condition, orderbyClauses,
                    currentPageNo);
        } finally {
            if (session != null)
                session.close();
        }
View Full Code Here
330
331
332
333
334
335
336
337
338
339
340
        Session session = null;
        try {
            session = SessionFactory.openSession();
            session.setAccurateProperties(accurateProperties);
            // change the o's use_state
            return session.query(className, conditions, orderbyClauses);
        } finally {
            if (session != null)
                session.close();
        }
    }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
        Long problemId = problemvalue.getProblemId();
        Filter filter = DAOFactory.getFilter("problemId", SQLOperator.EQUAL,
                problemId);
        scmd.setFilter(filter);
        Session session = SessionFactory.openSession();
        ArrayList problemvalues = session.query(scmd);
        // 标题
        buffer
                .append("<div class=\"t1\"><div class=\"ico\"><div class=\"icomment\"></div></div>");
        buffer.append("对于问题的价值现有<span style=\"color:#FF0000\">"
                + problemvalues.size() + "</span>个讨论</div>");
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
        scmd = DAOFactory.getSelectCommand(clazz);
        Filter filter2 = DAOFactory.getFilter("creatorId", SQLOperator.EQUAL,
                userId);
        scmd.setFilter(filter2);
        // 查询当前用户是否有或者有过评论
        ArrayList myallevaluation = session.query(scmd);
        session.close();
        // todo:有没有问题应该是针对problem版本的，现在是针problemId，以后需要修改
        if (myallevaluation.size() > 0) {
            if (myevaluation.size() == 0) {
                buffer
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
        Session session = null;
        try {
            session = SessionFactory.openSession();
            SelectCommand scmd = DAOFactory
                    .getSelectCommand(UserPropertyRight.class);
            return session.query(scmd);
        } finally {
            if (session != null)
                session.close();
        }
    }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
    public void createTree() throws EasyJException {
        Session session = null;
        try {
            session = SessionFactory.openSession();
            List valueList = session.query(BeanUtil.getEmptyObject(className));
            if (valueList.size() == 0)
                return;
            createTree(valueList);
        } finally {
            if (session != null)
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
            filter1.addFilter(filter2);
            filter1.addFilter(filter3, LogicOperator.AND);
            filter1.addFilter(filter4, LogicOperator.AND);
            scmd.setFilter(filter1);
            Session session = SessionFactory.openSession();
            messageList = session.query(scmd);
        }
        // 查询系统发送的消息
        else if (choose.equals("2")) {
            message.setMessageReceiver(user.getUserId());
            Long sys = new Long("3");
View Full Code Here
273
274
275
276
277
278
279
280
281
282
283
        Filter filter1 = DAOFactory.getFilter("userName", SQLOperator.EQUAL,
                message.getUserName());

        scmd.setFilter(filter1);
        Session session = SessionFactory.openSession();
        ArrayList userId = session.query(scmd);
        if (userId.size() > 0) {
            SysUser sys = (SysUser) userId.get(0);
            message.setMessageReceiver(sys.getUserId());
            SysUserCache syscuercache = (SysUserCache) request.getSession()
                    .getAttribute(Globals.SYS_USER_CACHE);
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
        SelectCommand scmdScenarioVersion = DAOFactory.getSelectCommand(clazz);
        Filter filter = DAOFactory.getFilter("scenarioVersionId",
                SQLOperator.EQUAL, ScenarioVersionId.toString());
        scmdScenarioVersion.setFilter(filter);
        Session session = SessionFactory.openSession();
        ArrayList scenarioVersions = session.query(scmdScenarioVersion);
        if (scenarioVersions.size() == 1) {
            scenarioversion = (ScenarioVersion) scenarioVersions.get(0);
        }
        // 查询上一版本的scenarioversion
        if (oldScenarioVersionId.intValue() > -1) {
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
            SelectCommand scmdOldScenarioVersion = DAOFactory
                    .getSelectCommand(clazz);
            Filter oldfilter = DAOFactory.getFilter("scenarioVersionId",
                    SQLOperator.EQUAL, oldScenarioVersionId.toString());
            scmdOldScenarioVersion.setFilter(oldfilter);
            ArrayList oldscenarioVersions = session
                    .query(scmdOldScenarioVersion);
            if (oldscenarioVersions.size() == 1) {
                oldscenarioversion = (ScenarioVersion) oldscenarioVersions
                        .get(0);
            }
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.