| | |
|---|
| | | |
|---|
| | | import javax.annotation.Resource; |
|---|
| | | |
|---|
| | | import com.yeshi.buwan.util.NumberUtil; |
|---|
| | | import org.hibernate.HibernateException; |
|---|
| | | import org.hibernate.Session; |
|---|
| | | import org.springframework.cache.annotation.CacheEvict; |
|---|
| | |
|---|
| | | public List<VideoInfo> doInHibernate(Session session) throws HibernateException { |
|---|
| | | String sql = ""; |
|---|
| | | for (VideoInfo vi : list) { |
|---|
| | | if (NumberUtil.isNumeric(vi.getId())) |
|---|
| | | sql += " (SELECT v.`id`,bv.`videoid`,bv.`detailsystemid`,bv.`show` FROM wk_video_video v LEFT JOIN wk_video_banquan_video bv ON bv.`videoid`=v.`id` WHERE v.`id`=" |
|---|
| | | + vi.getId() + ") UNION ALL"; |
|---|
| | | } |
|---|
