📄 query.jsp
字号:
<%@ page language="java" import="java.util.*"
import="edu.yinhe.mis.vo.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<%
//得到本页的参数内容;
int totals = 0, totalPages = 1, pageNo = 1, prePageNo = 1, nextPageNo = 1, preOk = 1, nextOk = 1;
String action = path + "/admins/paike/query.html?method=query&";
if (request.getAttribute("total") != null)
totals = Integer.parseInt(request.getAttribute("total")
.toString());
if (request.getAttribute("totalPage") != null)
totalPages = Integer.parseInt(request.getAttribute("totalPage")
.toString());
if (request.getAttribute("pageNum") != null)
pageNo = Integer.parseInt(request.getAttribute("pageNum")
.toString());
if (totalPages < 1)
totalPages = 1;
//计算上一页和下一页的页码及按钮的状态
prePageNo = pageNo;
nextPageNo = pageNo;
if (pageNo > 1)
prePageNo--;
else
prePageNo = 1;
if (pageNo < totalPages)
nextPageNo++;
else
nextPageNo = totalPages;
if (pageNo == 1)
preOk = 0;
if (pageNo == totalPages)
nextOk = 0;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'query.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<LINK href="../css/CSS.css" type=text/css rel=stylesheet>
<LINK href="<%=path%>/admins/css/general.css" type=text/css
rel=stylesheet>
<LINK href="<%=path%>/admins/css/main.css" type=text/css
rel=stylesheet>
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<script type="text/javascript">
</script>
<style>
body {
background-color: #E6FDFF;
span {text-decoretion: none;
}
}
.ftd {
background-color: #bbdde5;
}
.gtd {
background-color: #f4fafb;
}
.put {
background-color: transparent;
padding-top: 0px;
padding-right: 0px;
padding-bottom: 1px;
padding-left: 0px;
border-top-width: 0px;
border-right-width: 0px;
border-bottom-width: 1px;
border-left-width: 0px;
border-bottom-style: solid;
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: none;
}
</style>
</head>
<body>
<form action="<%=path%>admins/paike/query.html?method=query&"
method="post" name="queryform">
<table width="810" height="20" border="1" align="center"
bgcolor="#cdeafa">
<tr>
<td width="90" height="20" align="center" valign="middle"
name="HOUR_DATE">
日期
</td>
<td width="90" align="center" valign="middle" name="PKWEEK">
星期
</td>
<td width="90" align="center" valign="middle" name="TEACHER_NAME">
教师名字
</td>
<td width="90" align="center" valign="middle" name="CLASSNAME">
班级名称
</td>
<td width="90" align="center" valign="middle" name="CLASSROOM_NO">
教室
</td>
<td width="90" align="center" valign="middle" name="OBJECT_NAME">
课程名称
</td>
<td width="90" align="center" valign="middle" name="CLASSTIMES">
课次
</td>
<td width="90" align="center" valign="middle" name="TEACHTIME">
授课时间
</td>
<td width="90" align="center" valign="middle" name="SCHOOL_NO">
授课地点(校区)
</td>
</tr>
<%
ArrayList list1 = (ArrayList) request.getAttribute("query");
QueryVO vo = null;
for (int i = 0; i < list1.size(); i++) {
vo = (QueryVO) list1.get(i);
%>
<tr>
<td height="20" align="center" valign="middle"><%=vo.getHour_date()%></td>
<td align="center" valign="middle"><%=vo.getPkweek()%></td>
<td align="center" valign="middle"><%=vo.getTeacher_name()%></td>
<td align="center" valign="middle"><%=vo.getClassname()%></td>
<td align="center" valign="middle"><%=vo.getClassroom_no()%></td>
<td align="center" valign="middle"><%=vo.getObject_name()%></td>
<td align="center" valign="middle"><%=vo.getClasstimes()%></td>
<td align="center" valign="middle"><%=vo.getTeachtime()%></td>
<td align="center" valign="middle"><%=vo.getSchool_no()%></td>
</tr>
<%
}
%>
</table>
</form>
<center>
<%
if (pageNo > 1) {
%>
<a
href="<%=action%>pageNum=1"
class="blueText"><span class="blueText">首页</span> </a>
<%
if (preOk == 1) {
%>
<a
href="<%=action%>pageNum=<%=prePageNo%>"
class="blueText"><span class="blueText">上一页</span> </a>
<%
}
} else {
%>
<span class="grayText">首页</span>
<span class="grayText">上一页</span>
<%
}
%>
<%
if (pageNo < totalPages) {
%>
<%
if (nextOk == 1) {
%>
<a
href="<%=action%>pageNum=<%=nextPageNo%>"
class="blueText"><span class="blueText">下一页</span> </a>
<a
href="<%=action%>pageNum=<%=totalPages%>"
class="blueText"><span class="blueText">尾页</span> </a>
<%
}
} else {
%>
<span class="grayText">下一页</span>
<span class="grayText">尾页</span>
<%
}
%>
去第
<input type="text" id="willGoPage" name="willGoPage" class="control"
size="2" onKeyPress="return isNumber()">
页
<input type="button" class="button" id="go" value="GO" name="go"
onClick="JavaScript:goPage()">
第
<span class="redText"><%=pageNo%></span>页/共
<span class="redText"><%=totalPages%></span>页 总数
<span class="redText"><%=totals%></span>
</center>
<script language="javascript">
//是否输入数字
function isNumber(){
return ((event.keyCode>47)&&(event.keyCode<58));
}
//响应“GO”按钮
function goPage(goPageNo){
var strNum,s,m;
var maxPageNo = <%=totalPages%>;
var goPageNo = document.all.willGoPage.value;
var url = "<%=basePath%>admins/paike/query.html?method=query&pageNum="+goPageNo;
strNum = document.getElementById("willGoPage").value;
s = /^\d+$/;
m = s.test(strNum);
if(!m){
alert("Sorry,您非法输入,请您重新输入数字!!!");
document.getElementById("willGoPage").value="";
return;
}
if (goPageNo<1 || goPageNo>maxPageNo || goPageNo==''){
alert("您的输入的页号有误，请重新输入！");
document.getElementById("willGoPage").value="";
return ;
}else
{
window.location = url;
}
}
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -