$(
function () {
$(
".list-group-item").
click(
function(){
if (
$(
this).
find(
"ul") ) {
$(
this).
toggleClass(
"tree-closed")
;
if (
$(
this).
hasClass(
"tree-closed") ) {
$(
"ul", this).
hide(
"fast")
;
}
else {
$(
"ul", this).
show(
"fast")
;
}
}
})
;
var pageno =
0;
if (pageno ==
""||pageno==
0) {
queryPage(
0)
;
}
else {
queryPage(pageno-
1)
;
}
})
;
//使用Ajax异步查询数据
function queryPage( pageIndex){
var dataObj = {
"pageno" : pageIndex+
1 , //pageno 是属性名称,是否增加双引号无所谓
"pagesize" :
10
}
;
if(condition){
dataObj.
subjectId=
$(
"#selectSysSubject option:selected").
val()
;
dataObj.
courseName=
$(
"#courseName").
val()
;
dataObj.
isAvaliable=
$(
"#select option:selected").
val()
;
dataObj.
startTime=
$(
"#startTime").
val()
;
dataObj.
endTime=
$(
"#endTime").
val()
;
}
var loadingIndex = -
1 ;
$.
ajax({
url :
"queryCourseInfoList",
type :
"post",
data : dataObj
,
beforeSend :
function(){
loadingIndex =
layer.
msg(
'数据查询中', {
icon:
6})
;
return true ;
}
,
success :
function(result){
//显示结果
layer.
close(loadingIndex)
;
if(result.
success){
//循环遍历,显示数据
var pageObj = result.
page;
var list = pageObj.
datas ;
var content =
"";
// $("tbody").html(content);
$.
each(list
,function(i
, n){
content+=
"<tr>";
content+=
" <td>"+n.
courseName+
"</td>";
if(n.
isAvaliable==
'1'){
content+=
" <td>上架</td>";
}
else{
content+=
" <td>下架</td>";
}
content+=
" <td>"+n.
subjectName+
"</td>";
content+=
" <td>"+n.sourcePrice+
"</td>";
content+=
" <td>"+(n.sourcePrice-n.currentPrice)+
"</td>";
content+=
" <td>"+n.lessionNum+
"</td>";
content+=
" <td>"+n.pageBuycount+
"</td>";
content+=
" <td>"+n.pageViewcount+
"</td>";
content+=
" <td>"+n.dataTime +
"</td>";
content+=
" <td>"+n.endDateTime+
"</td>";
/*<button class='btn btn-primary btn-lg' class='btn btn-success btn-xs' data-toggle='modal' th:attr='data-target=("+"#myModal\""+${user.userId}"+\")'>*/
content+=
" <td>";
content+=
"<button type=\"button\" οnclick=\"updatePageInfo("+n.courseId+
")\" class=\"btn btn-success btn-xs\">章节管理<i class=\"glyphicon glyphicon-eye-open\">";
content+=
"</i>";
content+=
"</button>";
content+=
"<button type=\"button\" οnclick=\"updateCourseInfo("+n.courseId+
")\" class=\"btn btn-success btn-xs\">修改<i class=\"glyphicon glyphicon-eye-open\">";
content+=
"</i>";
content+=
"</button>";
content+=
"<button type=\"button\" οnclick=\"deleteTeacher("+n.courseId+
")\" class=\"btn btn-success btn-xs\">删除<i class=\"glyphicon glyphicon-eye-remove\">";
content+=
"</i>";
content+=
" </button>";
content+=
" </td>";
content+=
"</tr>";
})
;
//$("tbody").append(content);
$(
"tbody").
html(content)
;
// 创建分页
var num_entries = pageObj.totalsize
;
$(
"#Pagination").
pagination(num_entries
, {
num_edge_entries:
2, //边缘页数
num_display_entries:
4, //主体页数
callback:
queryPage, //查询当前页的数据.
items_per_page:pageObj.
pagesize, //每页显示1项
current_page:(pageObj.
pageno-
1)
, //当前页,索引从0开始
prev_text:
"上一页",
next_text:
"下一页"
})
;
}
else{
layer.
msg(
"教师分页查询数据失败", {
time:
1000, icon:
5, shift:
6})
;
}
}
,
error :
function(){
layer.
msg(
"教师分页查询数据错误", {
time:
1000, icon:
5, shift:
6})
;
}
})
;
}
var condition =
false ;
function queryCourse(){
/*var userInfo= $("#userInfoes").val();
var isStar= $("#select option:selected").val();
var startTime= $("#startTime").val();
var endTime=$("#endTime").val();
$.ajax({
type:"post",
url:"http://www.teacher.com/queryTeacherInfo",
data:{
userInfo:userInfo,
isStar:isStar,
startTime:startTime,
endTime:endTime
},
beforeSend:function () {
return true;
},
success:function (result) {
}
})*/
condition =
true ;
queryPage(
0)
;
}
后台:
@RequestMapping(
"queryCourseInfoList")
@ResponseBody
public AjaxResult
queryCourseInfoList(
@RequestParam Map map
, @RequestParam(
value =
"pageno",required =
false,defaultValue =
"0")Integer pageno
, @RequestParam(
value =
"pagesize",required =
false,defaultValue =
"10")Integer pagesize){
AjaxResult result=
new AjaxResult()
;
map.put(
"pageno",pageno)
;
map.put(
"pagesize",pagesize)
;
try {
Page<EduCourse>page=
courseService.getCourseInfoList(map)
;
result.setSuccess(
true)
;
result.setPage(page)
;
}
catch (Exception e) {
e.printStackTrace()
;
result.setSuccess(
false)
;
}
return result
;
}
public Page<EduCourse>
getCourseInfoList(Map map) {
//获取请求过来的参数pageno ,pagesize
Integer pageno = (Integer) map.get(
"pageno")
;
Integer pagesize = (Integer) map.get(
"pagesize")
;
//创建Page对象把pageno ,pagesize赋值给page对象
Page<EduCourse> page =
new Page<>(pageno
, pagesize)
;
Integer startIndex = page.getStartIndex()
;
map.put(
"startIndex", startIndex)
;
//获取页面总共显示的条数
Integer totalsize =
eduCourseMapper.selectAll().size()
;
//查询总数据
List<EduCourse> datas = getEduCourse(map)
;
for (EduCourse data : datas) {
Date createTime = data.getAddTime()
;
Date endTime = data.getEndTime()
;
SimpleDateFormat sdf =
new SimpleDateFormat(
"yyyy-MM-dd")
;
String dateTime = sdf.format(createTime)
;
String endDateTime = sdf.format(endTime)
;
data.setDataTime(dateTime)
;
data.setEndDateTime(endDateTime)
;
}
//获取总共显示的页码
//Integer totalno = (totalsize%pagesize==0)?(totalsize/pagesize):(totalsize/pagesize+1);
Integer totalno = (totalsize % pagesize ==
0) ? (totalsize / pagesize) : (totalsize / pagesize +
1)
;
page.setTotalno(totalno)
;
page.setTotalsize(totalsize)
;
page.setDatas(datas)
;
return page
;
}
需要引入插件<script src="jquery/jquery.pagination.js"></script>
