📄 queryall.jsp
字号:
<%@ page language="java" import="java.util.*"
import="edu.yinhe.mis.vo.*" import="edu.yinhe.mis.dto.*"
pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<%
//得到本页的参数内容
String classno = (String) request.getAttribute("classno");
String classroom = (String) request.getAttribute("classroom");
String schoolno = (String) request.getAttribute("schoolno");
if (classno == null)
classno = "";
if (classroom == null)
classroom = "";
if (schoolno == null)
schoolno = "";
int totals = 0, totalPages = 1, pageNo = 1, prePageNo = 1, nextPageNo = 1, preOk = 1, nextOk = 1;
String action = path + "/admins/paike/query.html?method=queryall&";
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>查询所有班级课表~~！</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">
function toclear(){
document.all.classroom.value="";
document.all.classno.value="";
document.all.schoolno.value="";
reutrn;
}
</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=queryall&"
method="post" name="form1">
<table width="100%" height="29" border="0" cellpadding="0"
cellspacing="0">
<jsp:include page="/admins/core/school.html" flush="false">
<jsp:param name="method" value="findSchool" />
</jsp:include>
<jsp:include page="/admins/core/room.html" flush="false">
<jsp:param name="method" value="findclassno" />
</jsp:include>
<tr>
<%
QueryDTO queryDTO = (QueryDTO) request.getAttribute("queryDTO");
ArrayList slist = (ArrayList) request.getAttribute("slist");
ArrayList list = (ArrayList) request.getAttribute("list");
%>
<td align="center" width="8%">
班级编号：
</td>
<td align="center" width="5%">
<input size=10 name="classno" maxlength="20" value="">
</td>
<td align="center" width="8%">
教室编号：
</td>
<td width="5%">
<select name="classroom">
<option value="">
请选择......
</option>
<%
if (list != null) {
for (Iterator it = list.iterator(); it.hasNext();) {
RoomVO rvo = (RoomVO) it.next();
%>
<option value="<%=rvo.getClassroomNo()%>"
<%
System.out.println(queryDTO.getClassroom_no());
if(queryDTO!=null&&queryDTO.getClassroom_no()!=null&&!queryDTO.getClassroom_no().equals("")&&queryDTO.getClassroom_no().equals(rvo.getClassroomNo())){ %>
selected="selected" <%} %>><%=rvo.getClassroomNo()%></option>
<%
}
}
%>
</select>
</td>
<td align="center" width="12%">
授课地点（校区编号）：
</td>
<td width="5%">
<select name="schoolno">
<option value="">
请选择......
</option>
<%
if (slist != null) {
for (Iterator it = slist.iterator(); it.hasNext();) {
SchoolVO avo = (SchoolVO) it.next();
%>
<option value="<%=avo.getSchoolNo()%>"
<%
System.out.println(queryDTO.getSchool_no());
if(queryDTO!=null&&queryDTO.getSchool_no()!=null&&!queryDTO.getSchool_no().equals("")&&queryDTO.getSchool_no().equals(avo.getSchoolNo())){ %>
selected="selected" <%} %>><%=avo.getSchoolNo()%></option>
<%
}
}
%>
</select>
</td>
<td width="5%">
<input name="submit" type=submit class=button value=" 搜索">
</td>
<td width="5%">
<input name="submit" type=button class=button value=" 重置"
onclick="toclear()">
</td>
</tr>
</table>
<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("queryall");
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&classno=<%=classno%>&classroom=<%=classroom%>&schoolno=<%=schoolno%>"
class="blueText"><span class="blueText">首页</span> </a>
<%
if (preOk == 1) {
%>
<a
href="<%=action%>pageNum=<%=prePageNo%>&classno=<%=classno%>&classroom=<%=classroom%>&schoolno=<%=schoolno%>"
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%>&classno=<%=classno%>&classroom=<%=classroom%>&schoolno=<%=schoolno%>"
class="blueText"><span class="blueText">下一页</span> </a>
<a
href="<%=action%>pageNum=<%=totalPages%>&classno=<%=classno%>&classroom=<%=classroom%>&schoolno=<%=schoolno%>"
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=queryall&pageNum="+goPageNo+"&classno=<%=classno%>&classroom=<%=classroom%>&schoolno=<%=schoolno%>";
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 + -