新版搜索优化

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
package com.yeshi.fanli.service.impl.goods; 
 
import java.io.Serializable; 
import java.util.List; 
 
import javax.annotation.Resource; 
 
import org.hibernate.HibernateException; 
import org.hibernate.Query; 
import org.hibernate.Session; 
import org.springframework.orm.hibernate4.HibernateCallback; 
import org.springframework.stereotype.Service; 
 
import com.yeshi.fanli.dao.goods.CollectionGoodsDao; 
import com.yeshi.fanli.entity.bus.user.CollectionGoods; 
import com.yeshi.fanli.service.inter.goods.CollectionGoodsService; 
import com.yeshi.fanli.util.Constant; 
 
@Service 
public class CollectionGoodsServiceImpl implements CollectionGoodsService { 
 
    @Resource 
    private CollectionGoodsDao dao; 
 
    @Override 
    public void save(CollectionGoods cg) { 
        cg.setCreateTime(System.currentTimeMillis()); 
        dao.save(cg); 
    } 
 
    @Override 
    public CollectionGoods findByUidAndAuctionId(long uid, long auctionId) { 
        List<CollectionGoods> list = dao.list("from CollectionGoods cg where cg.userInfo.id=? and auctionId=?", 0, 1, 
                new Serializable[] { uid, auctionId }); 
        if (list.size() > 0) { 
            return list.get(0); 
        } 
        return null; 
    } 
 
    @Override 
    public void delete(CollectionGoods find) { 
        dao.delete(find); 
    } 
 
    @Override 
    public List<CollectionGoods> findCollectionGoods(long uid, int page) { 
        return dao.list("from CollectionGoods cg where cg.userInfo.id = ? order by id desc", 
                (page - 1) * Constant.PAGE_SIZE, Constant.PAGE_SIZE, new Serializable[] { uid }); 
    } 
 
    @Override 
    public int getCount(long uid) { 
        return (int) dao.getCount("select count(*) from CollectionGoods cg where cg.userInfo.id = ?", 
                new Serializable[] { uid }); 
    } 
 
    @Override 
    public void delete(long auctionId, long uid) { 
        dao.excute(new HibernateCallback() { 
 
            @Override 
            public Object doInHibernate(Session session) throws HibernateException { 
                Query query = session 
                        .createQuery("delete from CollectionGoods cg where cg.userInfo.id = ? and auctionId = ?"); 
                query.setParameter(0, uid); 
                query.setParameter(1, auctionId); 
                query.executeUpdate(); 
                return null; 
            } 
        }); 
    } 
 
    @Override 
    public void clear(long uid) { 
        dao.excute(new HibernateCallback() { 
 
            @Override 
            public Object doInHibernate(Session session) throws HibernateException { 
                Query query = session.createQuery(" delete from CollectionGoods cg where cg.userInfo.id = ?"); 
                query.setParameter(0, uid); 
                query.executeUpdate(); 
                return null; 
            } 
        }); 
    } 
 
    @Override 
    public CollectionGoods findByAuctionId(long auctionId) { 
        List<CollectionGoods> list = dao.list("from CollectionGoods cg where cg.auctionId=" + auctionId); 
        if (list != null && list.size() > 0) 
            return list.get(0); 
        else 
            return null; 
    } 
 
}