'初始化导入'

admin

2021-01-04 aa6ef62aef83e277d4171df1d9f0803f91738216

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
package com.newvideo.service.imp;
 
import java.util.Iterator;
import java.util.List;
 
import javax.annotation.Resource;
 
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate4.HibernateCallback;
import org.springframework.stereotype.Service;
 
import com.newvideo.dao.VideoResourceDao;
import com.newvideo.domain.LeShiAccount;
import com.newvideo.domain.VideoResource;
import com.newvideo.util.StringUtil;
 
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
 
@Service
public class VideoResourceService {
    @Resource
    private VideoResourceDao videoResourceDao;
 
    public VideoResourceDao getVideoResourceDao() {
        return videoResourceDao;
    }
 
    public void setVideoResourceDao(VideoResourceDao videoResourceDao) {
        this.videoResourceDao = videoResourceDao;
    }
 
    public List<VideoResource> getResourceList() {
        return videoResourceDao.list("from VideoResource");
    }
 
    public VideoResource getResource(String id) {
        return (VideoResource) videoResourceDao.find(VideoResource.class, id);
    }
 
    public void addResource(VideoResource re) {
        videoResourceDao.create(re);
    }
 
    public void deleteResource(String id) {
        VideoResource re = new VideoResource();
        re.setId(id);
        videoResourceDao.delete(re);
    }
 
    public void updateResource(VideoResource re) {
        videoResourceDao.update(re);
    }
 
    public String resourceListToJson(List<VideoResource> list, List<LeShiAccount> accountList) {
        JSONObject object = new JSONObject();
        JSONArray array = new JSONArray();
        VideoResource vr;
        for (Iterator<VideoResource> iterator = list.iterator(); iterator.hasNext(); array
                .add(StringUtil.outPutResultJson(vr)))
            vr = (VideoResource) iterator.next();
 
        object.put("Type", array);
        return object.toString();
    }
 
    public void excuteSQL(final String sql) {
        videoResourceDao.excute(new HibernateCallback() {
            public Object doInHibernate(Session session) throws HibernateException {
                session.getTransaction().begin();
                session.createSQLQuery(sql).executeUpdate();
                session.flush();
                session.getTransaction().commit();
                return null;
            }
        });
    }
 
}