package com.yeshi.buwan.dao.juhe.funtv;
|
|
import com.yeshi.buwan.dao.base.BaseDao;
|
import com.yeshi.buwan.videos.funtv.entity.VideoFunTV;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
@Repository
|
public class VideoFunTVDao extends BaseDao<VideoFunTV> {
|
|
/**
|
* @param start
|
* @param count
|
* @return
|
*/
|
public List<VideoFunTV> listAll(int start, int count) {
|
List list = sqlList("select f.`videoid`,a.`aid`,fv.`vid` from wk_video_funtv f left join wk_funtv_album a on f.`albumid`=a.`id` left join wk_funtv_video fv on fv.`id`=f.`funvideoid`", start, count, null);
|
List<VideoFunTV> funTVList = new ArrayList<>();
|
for (int i = 0; i < list.size(); i++) {
|
Object[] objs = (Object[]) list.get(i);
|
VideoFunTV funTV = new VideoFunTV();
|
funTV.setVideoId(Long.parseLong(objs[0] + ""));
|
funTV.setAid(objs[1] + "");
|
funTV.setVid(objs[2] + "");
|
funTVList.add(funTV);
|
}
|
return funTVList;
|
}
|
|
|
}
|
