19. index.html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>主页面</title>
</head>
<body>
<h1><a href="StudentListServlet.action">查找所有学生</a></h1>
<h1><a href="StudentListPageServlet.action?currentPage=1">分页查找所有学生</a></h1>
</body>
</html>
20. 所有学生列表页面list.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>学生列表页面</title>
<script type="text/javascript">
function doDelete(sid) {
var flag = confirm("是否确定删除?");
if(flag){
location.href="DeleteServlet.action?sid="+sid;
}
}
</script>
</head>
<body>
<form action="SearchStudentServlet.action" method="post">
<table border="1px" width="1300px" align="center">
<tr>
<td colspan="8">
按姓名查询:<input type="text" name="sname"/>
按性别查询:<select name="gender">
<option value="">--请选择--
<option value="男">男
<option value="女">女
</select>
<input type="submit" value="查询">
<a href="add.jsp">添加</a>
</td>
</tr>
<tr>
<td width="100px">编号</td>
<td width="100px">姓名</td>
<td width="50px">性别</td>
<td width="150px">电话</td>
<td width="200px">爱好</td>
<td width="400px">详情</td>
<td width="200px">出生年月日</td>
<td width="100px">操作</td>
</tr>
<c:forEach items="${studentList}" var="student">
<tr>
<td>${student.sid}</td>
<td>${student.sname}</td>
<td>${student.gender}</td>
<td>${student.phone}</td>
<td>${student.hobby}</td>
<td>${student.info}</td>
<td>${student.birthday}</td>
<td><a href="EditServlet.action?sid=${student.sid}">修改</a> <a href="#" onclick="doDelete(${student.sid})">删除</a></td>
</tr>
</c:forEach>
</table>
</form>
</body>
</html>
21. 分页学生列表页面page_list.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>学生列表页面</title>
<script type="text/javascript">
function doDelete(sid) {
var flag = confirm("是否确定删除?");
if(flag){
location.href="DeleteServlet.action?sid="+sid;
}
}
</script>
</head>
<body>
<form action="SearchStudentServlet.action" method="post">
<table border="1px" width="1300px" align="center">
<tr>
<td colspan="8">
按姓名查询:<input type="text" name="sname"/>
按性别查询:<select name="gender">
<option value="">--请选择--
<option value="男">男
<option value="女">女
</select>
<input type="submit" value="查询">
<a href="add.jsp">添加</a>
</td>
</tr>
<tr>
<td width="100px">编号</td>
<td width="100px">姓名</td>
<td width="50px">性别</td>
<td width="150px">电话</td>
<td width="200px">爱好</td>
<td width="400px">详情</td>
<td width="200px">出生年月日</td>
<td width="100px">操作</td>
</tr>
<c:forEach items="${pageBean.list}" var="student">
<tr>
<td>${student.sid}</td>
<td>${student.sname}</td>
<td>${student.gender}</td>
<td>${student.phone}</td>
<td>${student.hobby}</td>
<td>${student.info}</td>
<td>${student.birthday}</td>
<td><a href="EditServlet.action?sid=${student.sid}">修改</a> <a href="#" onclick="doDelete(${student.sid})">删除</a></td>
</tr>
</c:forEach>
<tr>
<td colspan="8">
第 ${pageBean.currentPage} / ${pageBean.totalPage}
每页显示:<strong>${pageBean.pageSize}条 </strong>
总的记录数:<strong>${pageBean.totalSize}</strong>
<c:if test="${pageBean.currentPage !=1 }">
<a href="StudentListPageServlet.action?currentPage=1">[首页]</a>
| <a href="StudentListPageServlet.action?currentPage=${pageBean.currentPage-1 }">[上一页]</a>
</c:if>
<c:forEach begin="1" end="${pageBean.totalPage }" var="i">
<c:if test="${pageBean.currentPage == i }">
${i }
</c:if>
<c:if test="${pageBean.currentPage != i }">
<a href="StudentListPageServlet.action?currentPage=${i }">[${i}]</a>
</c:if>
</c:forEach>
<c:if test="${pageBean.currentPage !=pageBean.totalPage }">
<a href="StudentListPageServlet.action?currentPage=${pageBean.currentPage+1 }">[下一页]</a> |
<a href="StudentListPageServlet.action?currentPage=${pageBean.totalPage }">[尾页]</a>
</c:if>
</td>
</tr>
</table>
</form>
</body>
</html>
22. 添加学生页面add.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>添加学生信息</title>
</head>
<body>
<form action="AddServlet.action" method="post">
<table border="1px" width="400px">
<tr>
<td>姓名:<input type="text" name="sname"></td>
</tr>
<tr>
<td>性别:<input type="radio" name="gender" value="男">男<input type="radio" name="gender" value="女">女</td>
</tr>
<tr>
<td>电话:<input type="text" name="phone"></td>
</tr>
<tr>
<td>爱好:
<input type="checkbox" name="hobby" value="旅游">旅游
<input type="checkbox" name="hobby" value="美食">美食
<input type="checkbox" name="hobby" value="游泳">游泳
<input type="checkbox" name="hobby" value="唱歌">唱歌
</td>
</tr>
<tr>
<td>详情:<textarea rows="3" cols="20" name="info"></textarea></td>
</tr>
<tr>
<td>出生年月日:<input type="text" name="birthday"></td>
</tr>
<tr><td><input type="submit"></td></tr>
</table>
</form>
</body>
</html>
23. 编辑学生页面edit.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>更新学生页面</title>
</head>
<body>
<form action="UpdateServlet.action" method="post">
<input type="hidden" name="sid" value="${student.sid}">
<table border="1" width="600px">
<tr>
<td>姓名</td>
<td><input type="text" name="sname" value="${student.sname}"></td>
</tr>
<tr>
<td>性别</td>
<td>
<input type="radio" name="gender" value="男" <c:if test="${student.gender == '男'}">checked</c:if>>男
<input type="radio" name="gender" value="女" <c:if test="${student.gender == '女'}">checked</c:if>>女
</td>
</tr>
<tr>
<td>电话</td>
<td><input type="text" name="phone" value="${student.phone}"></td>
</tr>
<tr>
<td>生日</td>
<td><input type="text" name="birthday" value="${student.birthday}"></td>
</tr>
<tr>
<td>爱好</td>
<td>
<input type="checkbox" name="hobby" value="旅游" <c:if test="${fn:contains(student.hobby,'旅游') }">checked</c:if>>旅游
<input type="checkbox" name="hobby" value="美食" <c:if test="${fn:contains(student.hobby,'美食') }">checked</c:if>>美食
<input type="checkbox" name="hobby" value="游泳" <c:if test="${fn:contains(student.hobby,'游泳') }">checked</c:if>>游泳
<input type="checkbox" name="hobby" value="唱歌" <c:if test="${fn:contains(student.hobby,'唱歌') }">checked</c:if>>唱歌
</td>
</tr>
<tr>
<td>简介</td>
<td><textarea name="info" rows="3" cols="20">${student.info }</textarea></td>
</tr>
<tr>
<td colspan="2"> <input type="submit" value="更新"> </td>
</tr>
</table>
</form>
</body>
</html>
24. 学生表信息
25. 运行查看index.html
26. 点击查找所有学生
27. 选择"男", 点击查询
28. 输入框输入"王", 点击查询
29. 点击添加, 跳转到添加界面
30. 填写学生信息, 点击提交按钮
31. 修改学生信息
32. 删除学生
33. 点击分页查找所有学生