实验目的及要求:
- JavBean相关知识
- Servlet相关知识
- 利于MVC开发模式开发web项目
实验内容:
用MVC模式实现学生信息表的增删查改编写Model层代码实现对数据库操作,实现所有的业务逻辑功能。
实验关键代码:
- 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>
<center><h3 align="center">学生信息管理系统</h3></center>
<center><table width="750" height="54">
<div align="center">
<td><a href="add.jsp">增加学生信息表</a></td>
<td><a href="delete.jsp">删除学生信息表</a></td>
<td><a href="modify.jsp">修改学生信息表</a></td>
<td><a href="query.jsp">查询学生信息表</a></td>
<td><a href="studentADQM?pages=11&jump=1">学生信息分页显示</a></td>
</div>
</table></center>
</body>
</html>
2.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>
<h3 align="center">增加学生信息</h3>
<form action="studentADQM" method="post">
<table border="1" align="center">
<tr><td>学号</td><td><input type="text" name="addSno"></td></tr>
<tr><td>姓名</td><td><input type="text" name="addSname"></td></tr>
<tr><td>出生年月</td><td><input type="text" name="addSbirth"></td></tr>
<tr><td>联系电话</td><td><input type="text" name="addSphone"></td></tr>
<tr><td>家庭地址</td><td><input type="text" name="addSaddress"></td></tr>
<tr><td>性别</td><td><input type="text" name="addSsex"></td></tr>
<tr><td>年级</td><td><input type="text" name="addSgrade"></td></tr>
<tr><td>专业</td><td><input type="text" name="addSmajor"></td></tr>
<tr><td>班级</td><td><input type="text" name="addSclass"></td></tr>
</table>
<div align="center">
<input type="submit" value="提交">
<input type="reset" value="重置">
</div>
</form>
<div align="center">
<a href="index.jsp">返回主页面</a>
</div>
</body>
</html>
3.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.util.*"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>处理数据成功</title>
</head>
<body>
<div align="center">
<h3>${sessionScope.result}学生信息成功</h3>
</div>
<div align="center">
<a href="index.jsp">返回主页面</a>
</div>
</body>
</html>
4.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>
<h3 align="center">修改学生信息</h3>
<form action="studentADQM" method="post" align="center">
请输入你要修改的学生学号:<br>
<input type="text" name="modifyBySno"><br>
<input type="submit" value="提交">
<input type="reset"value="重置">
</form>
<div align="center">
<a href="index.jsp">返回主页面</a>
</div>
</body>
</html>
5.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>修改学生信息</title>
</head>
<body>
<h3 align="center">修改学生信息</h3>
<form action="studentADQM" method="post" align="center">
<table border="1" align="center">
<c:forEach items="${list}" var="student">
<tr><td>学号</td><td><input type="text" name="modifySno" value="${student.sno}"></td></tr>
<tr><td>姓名</td><td><input type="text" name="modifySname" value="${student.sname}"></td></tr>
<tr><td>出生年月</td><td><input type="text" name="modifySbirth" value="${student.sbirth}"></td></tr>
<tr><td>联系电话</td><td><input type="text" name="modifySphone" value="${student.sphone}"></td></tr>
<tr><td>家庭地址</td><td><input type="text" name="modifySaddress" value="${student.saddress}"></td></tr>
<tr><td>性别</td><td><input type="text" name="modifySsex" value="${student.ssex}"></td></tr>
<tr><td>年级</td><td><input type="text" name="modifySgrade" value="${student.sgrade}"></td></tr>
<tr><td>专业</td><td><input type="text" name="modifySmajor" value="${student.smajor}"></td></tr>
<tr><td>班级</td><td><input type="text" name="modifySclass" value="${student.sclass}"></td></tr>
<tr>
</c:forEach>
</table>
<div align="center">
<input type="submit" value="提交">
<input type="reset" value="重置">
</div>
</form>
<div align="center">
<a href="index.jsp">返回主页面</a>
</div>
</body>
</html>
6.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.util.*"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h3 align="center">分页显示学生信息</h3>
<div align="center">
<form action="studentADQM" method="post">
请输入你想每页显示记录条数:
<input type="text" name="pages" value="${sessionScope.pages}"><br>
请输入你要跳转到的指定页数:
<input type="text" name="jump" value="${sessionScope.jump}"><br>
<input type="submit" value="提交"> <input type="reset" value="重置">
</form>
</div>
<hr color="#999999">
<table border="1" align="center">
<thead>
<tr align="center">
<td>学号</td>
<td>姓名</td>
<td>出生年月</td>
<td>联系电话</td>
<td>家庭地址</td>
<td>性别</td>
<td>年级</td>
<td>专业</td>
<td>班级</td>
</tr>
</thead>
<tbody>
<c:forEach items="${list}" var="student">
<tr align="center">
<td>${student.sno}</td>
<td>${student.sname}</td>
<td>${student.sbirth}</td>
<td>${student.sphone}</td>
<td>${student.saddress}</td>
<td>${student.ssex}</td>
<td>${student.sgrade}</td>
<td>${student.smajor}</td>
<td>${student.sclass}</td>
</tr>
</c:forEach>
</tbody>
</table>
<hr color="#999999">
<div align="center">
第<c:out value="${sessionScope.jump}"></c:out>页
共<c:out value="${sessionScope.pageCount}"></c:out>页
<c:choose>
<c:when test="${sessionScope.jump==1}"></c:when>
<c:otherwise>
<a href="studentADQM?pages=${sessionScope.pages}&jump=${sessionScope.jump-1}">上一页</a>
</c:otherwise>
</c:choose>
<c:choose>
<c:when test="${sessionScope.jump==sessionScope.pageCount}"></c:when>
<c:otherwise>
<a href="studentADQM?pages=${sessionScope.pages}&jump=${sessionScope.jump+1}">下一页</a>
</c:otherwise>
</c:choose>
</div>
<div align="center">
<a href="index.jsp">返回主页面</a>
</div>
</body>
</html>
7.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*" import="java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>查询学生信息</title>
</head>
<body>
<h3 align="center">查询学生信息</h3>
<form action="studentADQM" method="post" align="center">
按照
<select name="querySnoOrName">
<option selected value="querySno">学号</option>
<option selected value="querySname">姓名</option>
</select> 查询学生信息<br>
<input type="text" name="queryScontent"> <br>
<input type="submit" value="提交">
<input type="reset"value="重置">
</form>
<div align="center">
<a href="index.jsp">返回主页面</a>
</di
8.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>显示查询后的学生信息</title>
</head>
<body>
<h3 align="center">查询学生信息成功</h3>
<table border="1" align="center">
<thead>
<tr align="center">
<td>学号</td>
<td>姓名</td>
<td>出生年月</td>
<td>联系电话</td>
<td>家庭地址</td>
<td>性别</td>
<td>年级</td>
<td>专业</td>
<td>班级</td>
</tr>
</thead>
<tbody>
<c:forEach items="${list}" var="student">
<tr align="center">
<td>${student.sno}</td>
<td>${student.sname}</td>
<td>${student.sbirth}</td>
<td>${student.sphone}</td>
<td>${student.saddress}</td>
<td>${student.ssex}</td>
<td>${student.sgrade}</td>
<td>${student.smajor}</td>
<td>${student.sclass}</td>
</tr>
</c:forEach>
</tbody>
</table>
<div align="center">
<a href="index.jsp">返回主页面</a>
</div>
</body>
</html>
9.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.util.*"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>处理数据成功</title>
</head>
<body>
<div align="center">
<h3>${sessionScope.result}学生信息成功</h3>
</div>
<div align="center">
<a href="index.jsp">返回主页面</a>
</div>
</body>
</html>