From 4011b8d0b377af33e2bc435f7726329630d706cb Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期二, 02 三月 2021 18:28:52 +0800
Subject: [PATCH] 搜索引擎接口更新
---
src/main/java/com/yeshi/buwan/service/imp/VideoResourceService.java | 116 +++++++++++++++++++++++++++++-----------------------------
1 files changed, 58 insertions(+), 58 deletions(-)
diff --git a/src/main/java/com/yeshi/buwan/service/imp/VideoResourceService.java b/src/main/java/com/yeshi/buwan/service/imp/VideoResourceService.java
index 29f53d5..af4031c 100644
--- a/src/main/java/com/yeshi/buwan/service/imp/VideoResourceService.java
+++ b/src/main/java/com/yeshi/buwan/service/imp/VideoResourceService.java
@@ -23,73 +23,73 @@
@Service
public class VideoResourceService {
- @Resource
- private VideoResourceDao videoResourceDao;
+ @Resource
+ private VideoResourceDao videoResourceDao;
- public List<VideoResource> getResourceList() {
- return videoResourceDao.list("from VideoResource");
- }
+ public List<VideoResource> getResourceList() {
+ return videoResourceDao.list("from VideoResource");
+ }
- public VideoResource getResource(String id) {
- return (VideoResource) videoResourceDao.find(VideoResource.class, id);
- }
+ public VideoResource getResource(String id) {
+ return (VideoResource) videoResourceDao.find(VideoResource.class, id);
+ }
- public void addResource(VideoResource re) {
- videoResourceDao.create(re);
- }
+ 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 deleteResource(String id) {
+ VideoResource re = new VideoResource();
+ re.setId(id);
+ videoResourceDao.delete(re);
+ }
- public void updateResource(VideoResource re) {
- videoResourceDao.update(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();
+ 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();
- }
+ 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;
- }
- });
- }
+ 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;
+ }
+ });
+ }
- @SuppressWarnings("unchecked")
- public List<VideoResource> getResourceByVideo(final VideoInfo vi) {
-
- final String sql="select vr.* from wk_video_resource vr left join wk_resource_video rv on vr.id=rv.resourceid where rv.videoid = ? ";
-
- return (List<VideoResource>) videoResourceDao.excute(new HibernateCallback<List<VideoResource>>() {
+ @SuppressWarnings("unchecked")
+ public List<VideoResource> getResourceByVideo(final VideoInfo vi) {
- @Override
- public List<VideoResource> doInHibernate(Session session)
- throws HibernateException {
- SQLQuery query = session.createSQLQuery(sql);
- query.setParameter(0, vi.getId());
- query.addEntity(VideoResource.class);
- return query.list();
- }
- });
-
-// List<VideoResource> list = videoResourceDao.list("from VideoResource vr left join ResourceVideo rv where rv.video.id = ? and vr.id=rv.resource.id",new Serializable[]{vi.getId()});
- }
+ final String sql = "select vr.* from wk_video_resource vr left join wk_resource_video rv on vr.id=rv.resourceid where rv.videoid = ? ";
+
+ return (List<VideoResource>) videoResourceDao.excute(new HibernateCallback<List<VideoResource>>() {
+
+ @Override
+ public List<VideoResource> doInHibernate(Session session)
+ throws HibernateException {
+ SQLQuery query = session.createSQLQuery(sql);
+ query.setParameter(0, vi.getId());
+ query.addEntity(VideoResource.class);
+ return query.list();
+ }
+ });
+
+// List<VideoResource> list = videoResourceDao.list("from VideoResource vr left join ResourceVideo rv where rv.juhe.id = ? and vr.id=rv.resource.id",new Serializable[]{vi.getId()});
+ }
}
--
Gitblit v1.8.0