Package easyJ.database.dao.command

Examples of easyJ.database.dao.command.SelectCommand

36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
        StringBuffer buffer = new StringBuffer();
        CompositeDataProxy cdp = CompositeDataProxy.getInstance();
        Object o = BeanUtil
                .getEmptyObject("cn.edu.pku.dr.requirement.elicitation.data.Problemvalue");
        Class clazz = o.getClass();
        SelectCommand scmd = DAOFactory.getSelectCommand(clazz);
        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>");
        // 投票面板,先从缓存中得到目前用户的信息,然后查看ProblemvalueTypeValue表,是否已经投过票了,这里更高的效率应该是用主子表查询
        SysUserCache userCache = (SysUserCache) request.getSession()
                .getAttribute(Globals.SYS_USER_CACHE);
        Long userId = userCache.getUser().getUserId();
        pvtv.setProblemId(problemvalue.getProblemId());
        // evaluation所有人的关于这个问题可理解行的没有过期的投票结果。
        ArrayList evaluation_num = cdp.query(pvtv);
        pvtv.setCreatorId(userId);
        // 当前登陆者关于这个问题可理解行的没有过期的投票结果。
        ArrayList myevaluation = cdp.query(pvtv);
        o = BeanUtil
                .getEmptyObject("cn.edu.pku.dr.requirement.elicitation.data.ProblemvalueTypeValue");
        clazz = o.getClass();
        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) {
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
        }
        Filter filter = DAOFactory.getFilter();
        filter.setAccurateProperties(accurateProperties);
        filter = filter.buildFilter(lower, upper,true);
        SelectCommand scmd = DAOFactory.getSelectCommand(lower.getClass());
        scmd.setFilter(filter);
        // 得到总的满足条件的数据量
        Long count = null;
        ArrayList paramList = new ArrayList();
        if (filter != null) {
            String totalNumStr = filter.getSQL();
            paramList = filter.getParameters();
            count = getTotalNum(scmd.getViewName(), totalNumStr, paramList,
                    conn);
        } else {
            count = getTotalNum(scmd.getViewName(), "", paramList, conn);
        }
        accurateProperties = null;
        return count;

    }
View Full Code Here
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
        }
        Filter filter = DAOFactory.getFilter();
        filter.setAccurateProperties(accurateProperties);
        filter = filter.buildFilter(o,true);
        SelectCommand scmd = DAOFactory.getSelectCommand(o.getClass());
        /* 如果没有排序，则默认为按照主键排序 */
        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());

        ArrayList result = (ArrayList) scmd.execute(conn);
        accurateProperties = null;
        return result;
    }
View Full Code Here
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
        }
        Filter filter = DAOFactory.getFilter();
        filter.setAccurateProperties(accurateProperties);
        filter = filter.buildFilter(lower, upper,true);
        SelectCommand scmd = DAOFactory.getSelectCommand(lower.getClass());
        /* 如果没有排序，则默认为按照主键排序 */
        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;
        return result;
    }
View Full Code Here
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
            String orderbyClauses, int currentPageNo, Connection conn)
            throws EasyJException {
        Class clazz = BeanUtil.getClass(className);
        Page page = new Page();
        page.setCurrentPageNo(currentPageNo);
        SelectCommand scmd = DAOFactory.getSelectCommand(clazz);
        /* 设置查询条件，代替filter */
        scmd.setCondition(condition);
        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();
                StringTokenizer conditionToken = new StringTokenizer(
                        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
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
        }
        Filter filter = DAOFactory.getFilter();
        filter.setAccurateProperties(accurateProperties);
        filter = filter.buildFilter(o,true);
        SelectCommand scmd = DAOFactory.getSelectCommand(o.getClass());
        scmd.setFilter(filter);
        // 得到总的满足条件的数据量
        String totalNumStr = filter.getSQL();
        ArrayList paramList = filter.getParameters();
        Long totalNum = getTotalNum(scmd.getViewName(), totalNumStr, paramList,
                conn);

        Page page = new Page();
        page.setTotalNum(totalNum);
        page.setCurrentPageNo(currentPageNo);
        /* 如果没有排序，则默认为按照主键排序 */
        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);
        String sql = scmd.getSQL();
        // EasyJLog.debug(scmd.getExecutableSQL());
        ArrayList list = (ArrayList) scmd.execute(conn);
        page.setPageData(list);
        accurateProperties = null;
        return page;
    }
View Full Code Here
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
        }
        Filter filter = DAOFactory.getFilter();
        filter.setAccurateProperties(accurateProperties);
        filter = filter.buildFilter(lower, upper,true);
        SelectCommand scmd = DAOFactory.getSelectCommand(lower.getClass());
        scmd.setFilter(filter);
        // 得到总的满足条件的数据量
        Long totalNum = null;
        ArrayList paramList = new ArrayList();
        if (filter != null) {
            String totalNumStr = filter.getSQL();
            paramList = filter.getParameters();
            totalNum = getTotalNum(scmd.getViewName(), totalNumStr, paramList,
                    conn);
        } else {
            totalNum = getTotalNum(scmd.getViewName(), "", paramList, conn);
        }

        Page page = new Page();
        page.setTotalNum(totalNum);
        page.setCurrentPageNo(currentPageNo);
        /* 如果没有排序，则默认为按照主键排序 */
        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);
        // EasyJLog.debug(scmd.getExecutableSQL());
        ArrayList list = (ArrayList) scmd.execute(conn);
        page.setPageData(list);
        accurateProperties = null;
        return page;
    }
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
    public static ArrayList getClassProperty(String className, Long userId)
            throws EasyJException {
        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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
        // 查询好友发送的信息
        if (choose.equals("1")) {
            Object o = BeanUtil
                    .getEmptyObject("cn.edu.pku.dr.requirement.elicitation.data.Message");
            Class clazz = o.getClass();
            SelectCommand scmd = DAOFactory.getSelectCommand(clazz);
            Filter filter1 = DAOFactory.getFilter();
            Filter filter2 = DAOFactory.getFilter("messageReceiver",
                    SQLOperator.EQUAL, user.getUserId());
            Filter filter3 = DAOFactory.getFilter("creatorId",
                    SQLOperator.NOT_EQUAL, "3");
            Filter filter4 = DAOFactory.getFilter("useState",
                    SQLOperator.EQUAL, "Y");
            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")) {
View Full Code Here
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
    public void writeMessageToFriend() throws EasyJException {
        Message message = new Message();
        message = (Message) object;
        Object o = BeanUtil.getEmptyObject("easyJ.system.data.SysUser");
        Class clazz = o.getClass();
        SelectCommand scmd = DAOFactory.getSelectCommand(clazz);
        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());
View Full Code Here
TOP

Related Classes of easyJ.database.dao.command.SelectCommand

  • cn.edu.pku.dr.requirement.elicitation.action.DescriptionVersionAction
  • cn.edu.pku.dr.requirement.elicitation.action.LoginAction
  • cn.edu.pku.dr.requirement.elicitation.action.MessageAction
  • cn.edu.pku.dr.requirement.elicitation.action.ProblemValueImpl
  • cn.edu.pku.dr.requirement.elicitation.action.ScenarioAction
  • cn.edu.pku.dr.requirement.elicitation.action.ScenarioVersionAction
  • easyJ.business.facade.UserRightFacade
  • easyJ.database.dao.DAOSQLServerImpl
  • easyJ.system.service.UserColumnService
  • easyJ.tools.GeneratorSQLServerImpl
    • Copyright © 2018 www.massapicom. 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.