话不多说,直接上代码,
(1)接口如下:
@RequestMapping("/videoList.action")
public String videoList(QueryVideoVo video, Model model, HttpSession session) {
//无条件查询视频资源
System.err.println(video);
//重新给start赋值 0
int start = (video.getPage()-1)*video.getRows(); //0 5 10
video.setStart(start);
//标题联动
model.addAttribute("title", video.getTitle());
//System.err.println(video.getTitle());
//讲师姓名联动
//获取讲师id,并转换为int类型
if(!"0".equals(video.getSpearkerId())&&video.getSpearkerId()!=null&&video.getSpearkerId()!=""){
System.err.println("speaker进来了");
int speakerId = Integer.parseInt(video.getSpearkerId());
model.addAttribute("speakerId", speakerId);
}else {
model.addAttribute("speakerId", 0);
}
//课程联动
//获取课程id,并转换为int类型
if(!"0".equals(video.getCourseId())&&video.getCourseId()!=null&&video.getCourseId()!=""){
System.err.println("course进来了");
int courseId = Integer.parseInt(video.getCourseId());
model.addAttribute("courseId", courseId);
}else {
model.addAttribute("courseId", 0);
}
List<VideoSpeaker> list = videoService.selectVideoByQueryVo(video);
//model.addAttribute("list", list);
model.addAttribute("userName", session.getAttribute("userName"));
Page<VideoSpeaker> page = new Page<VideoSpeaker>();
page.setPage(video.getPage()); //当前页
page.setRows(list); //结果集
page.setSize(video.getRows()); //每页展示的条数
//从数据库查询一个总数
page.setTotal(videoService.countVideoByQueryVo(video));//总共多少条
//page 名字不能变
model.addAttribute("page",page);
// 查询所有老师
List<Speaker> speakerList = speakerService.selectAll();
model.addAttribute("speakerList", speakerList);
// 查询所有课程
List<Course> courseList = courseService.selectAll();
model.addAttribute("courseList", courseList);
return "behind/videoList";
}
(2)前端页面:
<form class="navbar-form navbar-right" action="${pageContext.request.contextPath}/video/videoList.action" >
<input type="text" name="title" class="form-control" placeholder="标题" id="title" value="${title }">
<select name="spearkerId" id="spearkerId">
<option value="0" <c:if test="${speakerId==0 }">selected</c:if>>--请选择老师--
<c:forEach items="${speakerList }" var="speaker">
<option value="${speaker.getId() }" <c:if test="${speakerId==speaker.getId() }">selected</c:if>>${speaker.getSpeakerName() }
</c:forEach>
</select>
<select name="courseId" id="courseId">
<option value="0" <c:if test="${courseId==0 }">selected</c:if>>--请选择课程--
<c:forEach items="${courseList }" var="course">
<option value="${course.getId() }" <c:if test="${courseId==course.getId() }">selected</c:if>>${course.getCourseTitle() }
</c:forEach>
</select>
<button type="submit" class="btn btn-info dropdown-toggle">查询</button>
</form>