📄 teacherman.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<html>
<!------系统交互javascript----->
<script language="JavaScript">
<!--
function check_data() {
//按提交按钮时，检查数据是否为空
if(add_teacher_form.teachername.value.length==0){
alert("输入的教师姓名为空，请重新输入！");
return false;
}else return true;
}
function delete_confirm() {
//按删除链接时，弹出确认对话框
if(confirm("确认要删除吗？")){
return true;
}else return false;
}
-->
</script>
<body bgcolor="#DCDADA">
<!---------导航菜单------------->
<jsp:include page="navigator.txt"/>
<!---------数据输入------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
<tr>
<td width="100%">
<table border="0" width="100%">
<tr>
<td width="100%" colspan="3">录入教师信息：<br><hr></td>
</tr>
<form name="add_teacher_form" action="teacher_add.jsp" method="post" onsubmit="return check_data()">
<tr>
<td width="25%" align="right">教师姓名：</td>
<td width="25%"><input type="text" name="teachername" maxlength="20"></td>
<td width="50%"><input type="submit" value="提交"></td>
</tr>
</form>
</table>
</td>
</tr>
</table><br>
<!-------查询数据库的SQL语句-------->
<c:set var="selectRSSQL" value="select teacher_id,teacher_name from teacher"/>
<c:set var="selectCountSQL" value="select count(*) as teacherCount from teacher"/>
<!------设置数据源------>
<sql:setDataSource dataSource="jdbc/sqlserver" var="sqlDS"/>
<!--查询出总记录条数-->
<sql:query
sql="${selectCountSQL}"
var="teacherCountRS" dataSource="${sqlDS}"/>
<!--得到当前页的页号-->
<c:if test="${not empty param.page}">
<c:set var="page" value="${param.page}"/>
</c:if>
<c:if test="${empty param.page}">
<c:set var="page" value="1"/>
</c:if>
<!--得到总记录条数-->
<c:set var="teacherCount" value="${teacherCountRS.rowsByIndex[0][0]}"/>
<!--设置每页显示记录条数-->
<c:set var="pageSize" value="10"/>
<!--计算总页数-->
<c:if test="${teacherCount%pageSize==0}">
<c:set var="pageCount" value="${teacherCount/pageSize}"/>
</c:if>
<c:if test="${teacherCount%pageSize!=0}">
<c:set var="pageCount" value="${teacherCount/pageSize+1-(teacherCount%pageSize)/pageSize}"/>
</c:if>
<fmt:formatNumber value="${pageCount}" maxFractionDigits="0" var="pageCount"/>
<!--得到当前页数据在SQL查询结果中的起始位置-->
<c:set var="startPosition" value="${(page-1)*pageSize}"/>
<!--查询出当前页的数据-->
<sql:query
sql="${selectRSSQL}"
var="teacherRS" dataSource="${sqlDS}" startRow="${startPosition}" maxRows="${pageSize}"/>
<!---------数据输出------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
<tr>
<td colspan="4" align="center">
所有教师(共${teacherCount}位)
<c:if test="${teacherCount!=0}">
当前第${page}页，共${pageCount}页
<c:if test="${page!=1}">
<a href="${pageContext.request.requestURL}?page=1">首页</a>
<a href="${pageContext.request.requestURL}?page=${page-1}">上一页</a>
</c:if>
<c:if test="${page!=pageCount}">
<a href="${pageContext.request.requestURL}?page=${page+1}">下一页</a>
<a href="${pageContext.request.requestURL}?page=${pageCount}">尾页</a>）
</c:if>
</c:if>
</td>
</tr>
<tr>
<td width="21%" align="center">教师序号</td>
<td width="39%" align="center">教师姓名</td>
<td width="20%" align="center">修改？</td>
<td width="20%" align="center">删除？</td>
</tr>
<c:if test="${teacherRS.rowCount>=1}">
<c:forEach items="${teacherRS.rowsByIndex}" var="cucN">
<tr>
<td align="center">${cucN[0]}</td>
<td align="center">${cucN[1]}</td>
<td align="center"><a href="teacher_update1.jsp?teacher_id=${cucN[0]}">修改</a></td>
<td align="center">
<a href="teacher_delete.jsp?teacher_id=${cucN[0]}" onclick="return delete_confirm()">×</a>
</td>
</tr>
</c:forEach>
</c:if>
</table><br>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -