實驗課聽課列表
- 結(jié)合course表、user表、courseanduser表查詢所有課程
HTML頁面代碼<li th:style="'display:' + @{(${session.user.state==0} ? 'block' : 'none')} + ''"> <a href="javascript:;"> <i class="iconfont"></i> <cite>聽課管理</cite> <i class="iconfont nav_right"></i> </a> <ul class="sub-menu"> <li> <a th:_href="@{/course/SelectKecheng}"> <i class="iconfont"></i> <cite>實驗課聽課列表</cite> </a> </li > <li> <a th:_href="@{/course/SelectKecheng_two}"> <i class="iconfont"></i> <cite>理論課聽課列表</cite> </a> </li > </ul> </li>
對應(yīng)的courseController代碼
@RequestMapping("SelectKecheng")
public String SelectKecheng(Model model,Course course, Integer pageNum, Integer pageSize) {
if (pageNum==null || pageNum==0) {
//當(dāng)前頁
pageNum=1;
}
if (pageSize==null) {
//每頁的數(shù)量
pageSize=4;
}
PageInfo<Course> page= courseService.queryByPage(course, pageNum, pageSize);
model.addAttribute("page",page);
return "admin-rule";
}
對應(yīng)的courseServiceImpl.java代碼
@Override
public PageInfo<Course> queryByPage(Course course, Integer pageNum, Integer pageSize) {
//獲取當(dāng)前頁pageNum，pageSize條內(nèi)容，開始分頁
//?第一行是設(shè)置頁數(shù)和每頁顯示幾條，插件會自動對接下來的sql語句加上分頁方式。
Page<Course> page=PageHelper.startPage(pageNum, pageSize,true);
System.out.println("course.getName"+course.getName());
//查詢所有數(shù)據(jù)
courseMapper.SelectKecheng(course.getName());
//PageInfo中是分頁的一些信息，包括總頁數(shù)，當(dāng)前頁，總數(shù)據(jù)等。
return page.toPageInfo();
}
對應(yīng)的courseMapper.java代碼
List<Course> SelectKecheng(@Param("name") String name);
對應(yīng)的courseMapper.xml代碼
<select id="SelectKecheng" resultMap="ResultMap">
SELECT c.*,u.id AS uid,u.name AS uname,u.classes AS uclasses,u.sorce AS usorce,u.lsorce AS ulsorce FROM `course` AS c
JOIN `courseanduser` AS cu
ON c.id=cu.cid
JOIN `user` AS u
ON cu.uid=u.id
<where>
<if test="name!=null and name!=''">
c.name like concat ('%',#{name},'%')
</if>
and u.state=2
ORDER BY u.sorce DESC
</where>
</select>
將查詢數(shù)據(jù)渲染到頁面上
<div class="x-body">
<div class="layui-row">
<form class="layui-form layui-col-md12 x-so"
th:action="@{/course/SelectKecheng}" method="post">
<input type="text" name="name" placeholder="請輸入課程名稱"
autocomplete="off" class="layui-input">
<button class="layui-btn" lay-submit="" lay-filter="sreach">
<i class="layui-icon"></i>
</button>
</form>
</div>
<table class="layui-table">
<thead>
<tr>
<th>課程ID</th>
<th>課程名字</th>
<th>課程內(nèi)容</th>
<th>該課程老師</th>
<th>班級</th>
<th>總分</th>
<th>操作</th>
</thead>
<tbody>
<tr class="r" th:each="item : ${page.list}">
<td th:text="${item.id}">1</td>
<td th:text="${item.name}">admin/user/userlist</td>
<td th:text="${item.context}">admin/user/userlist</td>
<td th:text="${item.user.name}">admin/user/userlist</td>
<td th:text="${item.user.classes}">會員列表</td>
<td class="z" th:text="${item.user.sorce}" th:id="${item.user.id}" ></td>
<td class="td-manage">
<a style="color: yellowgreen;" title="查看聽課老師" th:onclick="openModak(this,[[${item.id}]])"
href="javascript:;"> <i class="layui-icon"></i>
</a>
</td>
</tr>
</tbody>
</table>
<div class="page">
<div>
<a class="prev" th:href="@{/course/SelectKecheng?(pageNum=${page.prePage})}">上一頁</a>
<a class="next" th:href="@{/course/SelectKecheng?(pageNum=${page.nextPage})}">下一頁</a>
</div>
</div>
</div>
- 查看聽課老師
HTML頁面代碼
<td class="td-manage">
<a style="color: yellowgreen;" title="查看聽課老師" th:onclick="openModak(this,[[${item.id}]])"
href="javascript:;"> <i class="layui-icon"></i> </a>
</td>
var socre = 0;
function openModak(obj,id) {
var url=[[@{/user/SelectTingKeLaoShi}]];
$.ajax({
url:url,
type:"post",
dataType:"json",
data:{
id:id
},
success:function(result){
$(".tbody").html("");
$.each(result,function(i,obj){
var b=("<tr>"+
"<td>"+obj.name+"</td>"+
"<td>"+obj.classes+"</td>"+
"<td>"+obj.ex.time+"</td>"+
"<td>"+obj.ex.topic+"</td>"+
"<td>"+obj.ex.address+"</td>"+
"<td>"+obj.ex.evaluate+"</td>"+
"<td>"+obj.ex.comment+"</td>"+
"<td class='f'>"+obj.ex.score+"</td>"+
"</tr>");
socre += obj.ex.score;
$(".tbody").append(b);
});
var uid=$(".z").attr("id");
var url=[[@{/user/XiuGaiZongFen}]];
$.ajax({
url:url,
type:"post",
data:{
sorce:socre,
id:uid
},
success:function(result){
}
});
form.render();
}
});
layui.use([ 'layer' ], function() {
var layer = layui.layer, $ = layui.$;
layer.open({
type : 1,//類型
area : [ '900px', '500px' ],//定義寬和高
title : '查看聽課老師',//題目
shadeClose : false,//點擊遮罩層關(guān)閉
content : $('#motaikunag')
//打開的內(nèi)容
});
})
}
userController.java
@RequestMapping("SelectTingKeLaoShi")
@ResponseBody
public List<User> SelectTingKeLaoShi(String id) {
List<User> list = userService.SelectTingKeLaoShi(id);
System.out.println(JSON.toJSONString(list));
return list;
}
userServiceImpl.java
@Override
public List<User> SelectTingKeLaoShi(String id) {
return userMapper.SelectTingKeLaoShi(id);
}
userMapper.java
List<User> SelectTingKeLaoShi(@Param("id") String id);
userMapper.xml
<select id="SelectTingKeLaoShi" resultMap="ResultMap_two">
SELECT u.*,e.topic AS
etopic,e.time AS etime, e.address AS eaddress,e.evaluate AS
eevaluate,e.comment AS ecomment,e.score AS escore FROM `user` AS u
JOIN `experiment` AS e
ON u.id=e.uid
JOIN course AS c
ON e.courseid=c.id
WHERE c.id=#{id}
</select>
將數(shù)據(jù)渲染到頁面上
<div id="motaikunag" style="display: none;">
<table style="margin-top: 0%" class="layui-table main" width="100%" border="0" cellspacing="0" cellpadding="0" >
<colgroup>
<col width="150">
<col width="200">
<col>
</colgroup>
<thead>
<tr>
<th>聽課老師</th>
<th>該老師班級</th>
<th>聽課時間</th>
<th>課題</th>
<th>地址</th>
<th>評價</th>
<th>評論</th>
<th>分?jǐn)?shù)</th>
</tr>
</thead>
<tbody class="tbody">
</tbody>
</table>
</div>
