📄 adminlist.jsp

📁 这是一个在线教育系统
💻 JSP
字号:
<%@ include file="conn.jsp"%>
<%@ include file="fenlei.jsp"%>
<%request.setCharacterEncoding("GB2312");
String sqlname;
String teacherid=request.getParameter("teacherid");
if(teacherid==null){
	teacherid="";
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE>TD {
	FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
BODY {
	FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
A:link {
	COLOR: #0033cc; TEXT-DECORATION: none
}
A:visited {
	COLOR: #0033cc; TEXT-DECORATION: none
}
A:active {
	COLOR: #ff0000; TEXT-DECORATION: none
}
A:hover {
	COLOR: #000000; TEXT-DECORATION: underline
}
.header	{
font-family: Tahoma, Verdana; font-size: 9pt; color: #FFFFFF; background-color: #69C37C
}
.category{
font-family: Tahoma, Verdana; font-size: 9pt; color: #000000; background-color: #EFEFEF
}
</STYLE>
<title>资料列表</title>

</head>
<body text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0>
 <%
int intPageSize;
int intRowCount;//记录总数
int intPageCount;//总页数
int intPage;//页面参数
String strPage;//定义变量用来传递page
int i,j;
intPageSize=5;//定义每页显示5条记录
strPage=request.getParameter("page");//取得当前的页码
if(strPage==null){//判断初始页面,如果没有显示记录,就置为第一页
intPage=1;
}else{
intPage=Integer.parseInt(strPage);//将strPage转化为整数
if(intPage<1) intPage=1;
}



 sqlname="select count(*) from scott.main,scott.teacher,scott.type where main.idofteacher=teacher.teacherid and main.idoftype=type.typeid  and teacherid like '%"+teacherid+"%' order by main.dateandtime desc";

ResultSet rt=stmt.executeQuery(sqlname); 


rt.next();
intRowCount=rt.getInt(1);//取得整数保存与intRowCount变量中
intPageCount=(intRowCount+intPageSize-1)/intPageSize;//计算出总页数(记录总数+每页显示的记录-1)/每页显示的记录)
if(intPage>intPageCount)
intPage=intPageCount;


 sqlname="select * from scott.main,scott.teacher,scott.type where main.idofteacher=teacher.teacherid and main.idoftype=type.typeid  and teacherid like '%"+teacherid+"%' order by main.dateandtime desc";


 rs=stmt.executeQuery(sqlname);//执行sql，按照时间先后排序显示
i=(intPage-1)*intPageSize;
for(j=0;j<i;j++)
rs.next();
%>
<%-- 设置intPage参数 --%>
  <%if(intRowCount==0){%>
		  对不起，还没有数据！
		  <%}else{%>
		

<br>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=5 width=550 border=1>
<tr><td>
<table style="BORDER-COLLAPSE: collapse" width=100% border=0>
<tr class="header"><td colspan=3 align=center>资料列表</td></tr>
<%-- 显示每页的数据 (根据i的值判断每页的5条记录) --%>
	<%
		i=0;
		while(i<intPageSize && rs.next()){

out.print( "<tr><td width=200>所属"+strfenlei1+"："+rs.getString("fenlei1")+"</td>");
out.print("<td width=230>所属"+strfenlei2+"："+rs.getString("fenlei2")+"</td>");
out.print("<td width=120>教师姓名：<a href=teacherinfo.jsp?id="+rs.getString("teacherid")+" title='查看"+rs.getString("teacher")+"的个人专集'>"+rs.getString("teacher")+"</a></td></tr>");
out.print("<tr><td>相关资料："+rs.getString("course")+"</td>");

out.print("<td>更新日期："+rs.getString("dateandtime")+"</td>");
out.print( "<td>阅读次数："+rs.getString("times")+"</td></tr>");
out.print("<tr><td>资料类型："+rs.getString("type")+"</td><td colspan=2>资料标题："+rs.getString("title")+"</td></tr>");
out.print("<tr><td colspan=2>简介："+rs.getString("content")+"</td><td><img src=images/i1.gif border=0>");
out.print("<a href=edit.jsp?id="+rs.getString("mainid")+">编辑</a>");

out.print( "&nbsp;&nbsp;<img src=images/i1.gif border=0><a href=teacherdelcourseware.jsp?id="+rs.getString("mainid")+">删除</a>");
out.print("</td></tr><tr><td colspan=3><HR SIZE=1></td></tr>");
	i++;//通过I循环设置每页的页数
  }
out.print( "<tr></tr>");
}
%>
   <FORM action=adminlist.jsp method=POST>
<p align='center' vAlign='bottom'>
				第<%=intPage%>页 &nbsp;&nbsp;&nbsp;共<%=intPageCount%>页&nbsp;&nbsp;&nbsp;
				<%if(intPage<intPageCount){%>
				<a href="adminlist.jsp?page=<%=intPage+1%>&teacherid=<%=teacherid%>">下一页</a>&nbsp;&nbsp;&nbsp;
				<%}%>
				<%if(intPage>1){%>
				<a href="adminlist.jsp?page=<%=intPage-1%>&teacherid=<%=teacherid%>">上一页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<%}%>
				 </form>
</table>
</td></tr>
</table>

</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -