package com.newvideo.service.imp;
|
|
import com.newvideo.dao.CategoryVideoDao;
|
import com.newvideo.domain.CategoryVideo;
|
import com.newvideo.domain.VideoInfo;
|
import com.newvideo.domain.VideoType;
|
import org.hibernate.HibernateException;
|
import org.hibernate.SQLQuery;
|
import org.hibernate.Session;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.orm.hibernate4.HibernateCallback;
|
import org.springframework.stereotype.Service;
|
|
import java.util.List;
|
|
@Service
|
public class CategoryVideoService {
|
@Autowired
|
private CategoryVideoDao categoryVideoDao;
|
|
public String getTypeNameByVid(final String id) {
|
return (String) categoryVideoDao.excute(new HibernateCallback<String>() {
|
@Override
|
public String doInHibernate(Session session)
|
throws HibernateException {
|
SQLQuery query = session.createSQLQuery("select vt.name from wk_video_type vt where vt.id = (select cv.videotypeid from wk_category_video cv where cv.videoid= ? LIMIT 0,1)");
|
query.setParameter(0, id);
|
return (String) query.uniqueResult();
|
}
|
});
|
}
|
|
|
public void addCategoryVideo(String videoId, long categoryId) {
|
List<CategoryVideo> list = categoryVideoDao.listByVideoIdAndCategoryId(videoId, categoryId);
|
if (list == null || list.size() == 0) {
|
CategoryVideo cv = new CategoryVideo();
|
cv.setVideo(new VideoInfo(videoId));
|
cv.setVideoType(new VideoType(categoryId));
|
categoryVideoDao.save(cv);
|
}
|
}
|
|
|
|
}
|
