初始项目

胡仁荣

2022-10-31 fe7381d6e8ec1f427408de0297ac7f41533202f6

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
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
/******************************************************************************
 * Copyright (C) 2015 Shenzhen Penguin Network Technology Co., Ltd
 * All Rights Reserved.
 * ±¾Èí¼þΪÉîÛÚÊÐÆó¶ìÍøÂç¿Æ¼¼ÓÐÏÞ¹«Ë¾¿ª·¢ÑÐÖÆ¡£Î´¾­±¾¹«Ë¾ÕýʽÊéÃæͬÒ⣬ÆäËûÈκθöÈË¡¢ÍÅÌå
 * ²»µÃʹÓᢸ´ÖÆ¡¢Ð޸Ļò·¢²¼±¾Èí¼þ.
 *****************************************************************************/
 
package com.qxueyou.scc.school.dao;
 
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
 
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate4.support.HibernateDaoSupport;
import org.springframework.stereotype.Repository;
 
 
@Repository(value="interactDAO")
/**
 * ×Ô¶¯×¢ÈësessionFactory »¥¶¯
 *
 * @author µËÖ¾ÓÀ
 * @since JDK1.6
 * @history 2015-01-07 µËÖ¾ÓÀ Ð½¨
 */
public class InteractDAO extends HibernateDaoSupport {
    
    /**
     * ×¢ÈësessionFactory
     *
     * @param sessionFactory
     */
    @Autowired(required = false)
    public void setSessionfactory(SessionFactory sessionFactory) {
        this.setSessionFactory(sessionFactory);
    }
    
    /**
     * ²éѯ»¥¶¯Á·Ï°½á¹û
     * @param hql
     * @param args
     * @return
     */
    @SuppressWarnings("unchecked")
    public List<Map<String, Object>> queryResultByInteractExer(String hql,
        List<Object> args) {
        // ²éѯ½á¹û
        List<Object[]> lst = (List<Object[]>) this.getHibernateTemplate().find(hql, args.toArray());
        if(lst.isEmpty()){
            return null;
        }
        List<Map<String, Object>> resultLst = new ArrayList<Map<String, Object>>(lst.size());
        
        Map<String, Object> resultMap = new HashMap<String, Object>(3);
        for (Object[] obj : lst) {
             resultMap = new HashMap<String, Object>();
             resultMap.put("name", obj[0]);
             resultMap.put("count", obj[1]);
             resultMap.put("peopleCount", obj[2]);//×ÜÈËÊý
             resultLst.add(resultMap);
        }
        return resultLst;
    }
    
}