新版搜索优化

Administrator

2018-10-30 c0c91fbda1ba601c4c8cb6d12fd43dfbe02eea5d

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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
package com.yeshi.fanli.service.impl.config; 
 
import java.io.Serializable; 
import java.util.ArrayList; 
import java.util.List; 
 
import javax.annotation.Resource; 
 
import org.hibernate.HibernateException; 
import org.hibernate.Query; 
import org.hibernate.Session; 
import org.hibernate.Transaction; 
import org.springframework.cache.annotation.Cacheable; 
import org.springframework.orm.hibernate4.HibernateCallback; 
import org.springframework.stereotype.Service; 
 
import com.yeshi.fanli.dao.goods.SuperHotSearchDao; 
import com.yeshi.fanli.entity.bus.search.HotSearch; 
import com.yeshi.fanli.entity.bus.su.search.SuperHotSearch; 
import com.yeshi.fanli.entity.system.System; 
import com.yeshi.fanli.service.inter.config.SuperHotSearchService; 
import com.yeshi.fanli.service.inter.config.SystemService; 
 
@Service 
public class SuperHotSearchSerivceImpl implements SuperHotSearchService { 
 
    @Resource 
    private SuperHotSearchDao superHotSearchDao; 
 
    @Resource 
    private SystemService systemService; 
 
    public List<SuperHotSearch> getSuperHotSearchBySystemId(long id) { 
 
        return superHotSearchDao.list("from SuperHotSearch shs where shs.system.id=? order by hotSearch.orderby desc", 
                new Serializable[] { id }); 
    } 
 
    public List<SuperHotSearch> getSuperHotSearchsByHotSearchs(List<Long> hsIdList) { 
        if (hsIdList.size() == 0) { 
            return new ArrayList<SuperHotSearch>(); 
        } 
        StringBuffer sb = new StringBuffer(" from SuperHotSearch shs "); 
        Serializable[] serArr = new Serializable[hsIdList.size()]; 
        for (int i = 0; i < hsIdList.size(); i++) { 
            if (i == 0) { 
                sb.append(" where shs.hotSearch.id=? "); 
            } else { 
                sb.append(" or shs.hotSearch.id=? "); 
            } 
            serArr[i] = hsIdList.get(i); 
        } 
        String hql = sb.toString(); 
 
        return superHotSearchDao.list(hql, serArr); 
 
    } 
 
    public List<SuperHotSearch> getSuperHotSearchBySystemId(long id, int strat, int count) { 
        return superHotSearchDao.list("from SuperHotSearch shs where shs.system.id=?", strat, count, 
                new Serializable[] { id }); 
 
    } 
 
    public List<SuperHotSearch> getSuperHotSearchBySystemId(long id, int strat, int count, String key) { 
        return superHotSearchDao.list("from SuperHotSearch srs where srs.system.id=? and srs.hotSearch.name like ?", 
                strat, count, new Serializable[] { id, key }); 
 
    } 
 
    public Integer deleteSuperHotSearch(final long hsid, final String platform, final String packageName) { 
        return (Integer) superHotSearchDao.excute(new HibernateCallback<Integer>() { 
 
            public Integer doInHibernate(Session session) throws HibernateException { 
                System system = systemService.getSystem(platform, packageName); 
                Transaction transaction = session.beginTransaction(); 
                Query query = session 
                        .createQuery("delete SuperHotSearch shs " + " where shs.hotSearch.id=? and shs.system.id=?"); 
                query.setLong(0, hsid); 
                query.setLong(1, system.getId()); 
                int i = query.executeUpdate(); 
                transaction.commit(); 
                return i; 
            } 
        }); 
    } 
 
    public void addSuperHotSearch(long hsid, String platform, String packageName) { 
        System system = systemService.getSystem(platform, packageName); 
        SuperHotSearch superHotSearch = new SuperHotSearch(); 
        HotSearch hotSearch = new HotSearch(); 
        hotSearch.setId(hsid); 
        superHotSearch.setHotSearch(hotSearch); 
        superHotSearch.setSystem(system); 
        superHotSearchDao.create(superHotSearch); 
    } 
 
    @Cacheable(value = "crgCache", key = "'getSuperHotSearchBySystemIdCache'+#id") 
    @Override 
    public List<SuperHotSearch> getSuperHotSearchBySystemIdCache(long id) { 
        return getSuperHotSearchBySystemId(id); 
    } 
 
}