《第一个web项目优化版》实现注册登录增删改查自动跳转强制登录

最新推荐文章于 2022-06-22 15:15:13 发布

zxwwantlearnjava

最新推荐文章于 2022-06-22 15:15:13 发布

阅读量951

点赞数 1

分类专栏： web项目文章标签： servlet web

本文链接：https://blog.csdn.net/zxwwantlearnjava/article/details/106167908

版权

web项目专栏收录该内容

3 篇文章 0 订阅

订阅专栏

一、简介

本项目用到的技术有html,css,servlet,jsp,tomcat,druid,oracle,java代码,使用工具MyEclipse2018

二、项目大致的功能关系图

新增的强制登陆就不画图了,也就是非法请求,直接送回对应的界面。例如:未登陆的用户请求访问展示层,则送回登陆界面。未正常填写注册信息直接访问注册成功的界面,则送回注册层。已登录成功用户,未正常进入指定操作界面,则送回展示所有用户的界面。

注意: XxxJsp类用jsp技术替换掉了

在这里插入图片描述

三、登陆层

1.Login.html

介绍:展示给用户操作的登录界面,让用户输入账号密码,当用户点击登陆按钮后,跳转到LoginAction判断账号密码是否输入正确。当用户点击注册按钮后,跳转到regist.html界面

<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8" />
<title>登陆页面</title>
<style type="text/css">
img {
	width: 30px;
	height: 30px;
}

#div1 {
	text-align: center;
	margin: auto;
	/*控制div的字体大小*/
	font-size: 30px;
	/*控制文本和边框之间的距离*/
	padding: 15px;
	margin-left: -40px;
}

#div2 {
	text-align: center;
	margin: auto;
	width: 300px;
	height: 100px;
	padding: 0px;
}
/*使光标放在超连接上变红*/
a:hover {
	color: red;
}
</style>
</head>

<body>
	<div id="div1">用户登陆</div>
	<hr />
	<form action="/servlet_day7/login">
		<div id="div2">
			<table>
				<tr>
					<td><img src="/servlet_day7/img/user.png" /></td>
					<td><input type="text" name="username" /></td>
				</tr>
				<tr>
					<td><img src="/servlet_day7/img/pwd.png" /></td>
					<td><input type="password" name="password" /></td>
				</tr>
				<tr>
					<td><a href="/servlet_day7/regist.html"
						style="text-decoration: none">注册</a></td>
					<td><input id="regist" type="submit" value="登陆" /></td>
				</tr>
			</table>
		</div>
	</form>
</body>

</html>

2.LoginAction业务类

介绍:接收用户输入的数据,并调用dao层内的方法判断登录信息是否正确,如果不正确则展示对应的提示界面,如果正确,将信息存入request作用域并跳转到LoginJsp展示层

package servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import dao.PersonDaoImpl;

public class LoginAction extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 4545630235072860810L;

	private static PersonDaoImpl pdi = new PersonDaoImpl();

	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		resp.setContentType("text/html");
		String un = req.getParameter("username");
		String pwd = req.getParameter("password");
		String getPwd = pdi.queryPasswordByUserName(un);
		// 判断账号密码是否都为空
		if (un.equals("") && pwd.equals("")) {
			resp.sendRedirect("/servlet_day7/allnull.html");
			// 判断账号是否为空
		} else if (un.equals("")) {
			resp.sendRedirect("/servlet_day7/unnull.html");
			// 判断密码是否为空
		} else if (pwd.equals("")) {
			resp.sendRedirect("/servlet_day7/pwd1null.html");
		} else {
			// 判断账号密码是否正确
			if (getPwd == null || !getPwd.equals(pwd)) {
				resp.sendRedirect("/servlet_day7/loginfailed.html");
			} else {
				// 获取一个Session
				HttpSession session = req.getSession();
				// 将账号信息放入到session中
				session.setAttribute("name", un);
				// 重定向
				resp.sendRedirect("/servlet_day7/loginsuccess");
			}
		}
	}
}

3.LoginJsp展示层

介绍:接收LoginAction存放在request作用域中数据,将登陆成功的信息动态展示给用户,并自动3秒跳转到ShowJsp界面

package servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class LoginJsp extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 7333050027516684398L;

	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		HttpSession session = req.getSession();
		String un = (String) session.getAttribute("name");
		String html = "<!DOCTYPE html>\n" + "<html>\n" + "  <head>\n"
				+ "<meta http-equiv=\"refresh\" content=\"3;URL=/servlet_day7/private/showAll.jsp\"> "
				+ "    <meta charset=\"UTF-8\">\n" + "		<title>登陆状态</title>\n" + "  </head>\n" + "  <body> 用户" + un
				+ ",登陆成功!3秒后跳转到联系人界面~ </body>\n" + "</html>";
		PrintWriter pw = resp.getWriter();
		pw.flush();
		pw.print(html);
	}
}

四、注册层

1.regist.html

介绍:展示给用户操作的注册界面,让用户输入注册信息,当用户点击注册按钮后,跳转到RegistAction判断用户输入的数据是否合法。当用户点击重置按钮后,将信息恢复默认值

package servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.PersonDaoImpl;
import entity.Person;

public class RegistAction extends HttpServlet {
	/**
	 * 
	 */
	private static final long serialVersionUID = 3653522036179307006L;

	// 创建一个PersonDaoImpl对象
	private static PersonDaoImpl pdi = new PersonDaoImpl();

	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		resp.setContentType("text/html");
		int id = pdi.getSequence();
		String un = req.getParameter("username");
		String pwd1 = req.getParameter("password1");
		String pwd2 = req.getParameter("password2");
		String name = req.getParameter("name");
		String strAge = req.getParameter("age");
		String phone = req.getParameter("phone");
		String address = req.getParameter("address");
		// 判断账号是否为空
		if (un.equals("")) {
			resp.sendRedirect("/servlet_day7/unnull.html");
			// 判断第一次输入的密码是否为空
		} else if (pwd1.equals("")) {
			resp.sendRedirect("/servlet_day7/pwd1null.html");
			// 判断第二次输入的密码是否为空
		} else if (pwd2.equals("")) {
			resp.sendRedirect("/servlet_day7/pwd2null.html");
			// 判断用户名是否被使用
		} else if (pdi.ifExistToUserName(un)) {
			resp.sendRedirect("/servlet_day7/registfailed.html");
			// 判断两次输入的密码是否一致
		} else if (!pwd1.equals(pwd2)) {
			resp.sendRedirect("/servlet_day7/notboth.html");
			// 判断姓名是否为空
		} else if (name.equals("")) {
			resp.sendRedirect("/servlet_day7/namenull.html");
			// 判断年龄是否合法
		} else if (Integer.parseInt(strAge) > 200) {
			resp.sendRedirect("/servlet_day7/agemorethan.html");
			// 判断手机号码是否合法 长度为11位并且是1开头
		} else if (!phone.equals("") && phone.charAt(0) != '1' || phone.length() != 11) {
			resp.sendRedirect("/servlet_day7/morethan.html");
		} else if (pdi.selectLikeTel(phone).size() != 0) {
			resp.sendRedirect("/servlet_day7/phoneExist.html");
		} else {
			req.setAttribute("regist", un);
			// 将注册信息存入数据库
			pdi.insert(un, pwd1, new Person(id, name, Integer.parseInt(strAge), phone, address));
			// 使用转发响应给浏览器
			req.getRequestDispatcher("/registsuccess").forward(req, resp);
		}
	}
}

2.RegtistAction业务层

介绍:接收用户输入的注册信息,根据约束条件先进行第一轮判断,如果不合法则展示对应的提示界面,如果满足约束条件,调用dao层进行第二轮判断,如果合法,将信息存入request作用域并跳转到RegistJsp展示层

package servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.PersonDaoImpl;
import entity.Person;

public class RegistAction extends HttpServlet {
	/**
	 * 
	 */
	private static final long serialVersionUID = 3653522036179307006L;

	// 创建一个PersonDaoImpl对象
	private static PersonDaoImpl pdi = new PersonDaoImpl();

	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		resp.setContentType("text/html");
		int id = pdi.getSequence();
		String un = req.getParameter("username");
		String pwd1 = req.getParameter("password1");
		String pwd2 = req.getParameter("password2");
		String name = req.getParameter("name");
		String strAge = req.getParameter("age");
		String phone = req.getParameter("phone");
		String address = req.getParameter("address");
		Integer age = (strAge.equals("")) ? 0 : Integer.parseInt(strAge);
		// 判断账号是否为空
		if (un.equals("")) {
			resp.sendRedirect("/servlet_day7/unnull.html");
			// 判断第一次输入的密码是否为空
		} else if (pwd1.equals("")) {
			resp.sendRedirect("/servlet_day7/pwd1null.html");
			// 判断第二次输入的密码是否为空
		} else if (pwd2.equals("")) {
			resp.sendRedirect("/servlet_day7/pwd2null.html");
			// 判断用户名是否被使用
		} else if (pdi.ifExistToUserName(un)) {
			resp.sendRedirect("/servlet_day7/registfailed.html");
			// 判断两次输入的密码是否一致
		} else if (!pwd1.equals(pwd2)) {
			resp.sendRedirect("/servlet_day7/notboth.html");
			// 判断姓名是否为空
		} else if (name.equals("")) {
			resp.sendRedirect("/servlet_day7/namenull.html");
			// 判断年龄是否合法
		} else if (age > 200) {
			resp.sendRedirect("/servlet_day7/agemorethan.html");
			// 判断手机号码是否合法 长度为11位并且是1开头
		} else if (!phone.equals("") && phone.charAt(0) != '1' || phone.length() != 11) {
			resp.sendRedirect("/servlet_day7/morethan.html");
		} else if (pdi.selectLikeTel(phone).size() != 0) {
			resp.sendRedirect("/servlet_day7/phoneExist.html");
		} else {
			req.setAttribute("regist", un);
			// 将注册信息存入数据库
			pdi.insert(un, pwd1, new Person(id, name, Integer.parseInt(strAge), phone, address));
			// 使用转发响应给浏览器
			req.getRequestDispatcher("/registsuccess").forward(req, resp);
		}
	}
}

3.RegistJsp展示层

介绍:接收RegistAction存放在request作用域中数据,将注册成功的信息动态展示给用户,并自动3秒跳转到Login.html登录层

package servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class RegistJsp extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = -5800424491666199917L;

	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		resp.setContentType("text/html");
		String html = "<!DOCTYPE html>\n" + "<html>\n" + "<meta http-equiv=\"refresh\" content=\"3;URL=/servlet_day7/Login.html\"> "
				+ "  <head>\n" + "    <meta charset=\"UTF-8\">\n" + "		<title>注册状态</title>\n" + "  </head>\n"
				+ "  <body> 注册成功!3秒后将跳转到登陆界面~ </body>\n" + "</html>";
		PrintWriter pw = resp.getWriter();
		pw.flush();
		pw.print(html);
	}
}

五、展示所有用户信息

1.showAll.jsp展示层

介绍:调用dao层中的selectAll方法获取所有用户信息的集合,并动态展示在浏览器界面上,具有添加用户、删除用户、修改用户、模糊搜索等功能。并根据用户对应的操作,跳转到不同的界面

<%@ page language="java" import="java.util.*,dao.*,entity.*"
	pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'showAll.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">
<style type="text/css">
img {
	width: 30px;
	height: 30px;
}

#title {
	text-align: center;
	/*控制div的字体大小*/
	font-size: 30px;
	/*控制文本和边框之间的距离*/
	padding: 15px;
}
/*使光标放在超连接上变红*/
a:hover {
	color: red;
}

a {
	color: blue;
}

form {
	text-align: center;
	font-family: 微软雅黑;
	font-size: 18px;
}

thead {
	color: white;
}
</style>
<%--
	<link rel="stylesheet" type="text/css" href="styles.css">
	--%>

</head>

<body>
	<div id="title">展示所有联系人</div>
	<hr />
	<form action="/servlet_day7/search" method="post">
		<div style="width: 48%;margin: auto;position:relative">
			<tr>
				<td><a href="insert.html"
					style="position: relative;top: 0px;right: 140px;"> <img
						src="img/add.png" />
				</a></td>
				<td><input type="search" name="search"
					style="position: relative;top: -5px;right: -166px;" /></td>
				<td><input type="submit" value="搜索"
					style="position: relative;top: -5px;right: -170px;"></input></td>
			</tr>
		</div>
	</form>

	<form action="/servlet_day7/delete" method="post">
		<table border="1" cellspacing="1" cellpadding="3"
			style="margin: auto; width: 35%;">
			<thead bgcolor="aquamarine">
				<tr>
					<th><input type="submit" value="删除选中" /></th>
					<th>&emsp;</th>
					<th>ID</th>
					<th>USERNAME</th>
					<th>AGE</th>
					<th>PHONE</th>
					<th>ADDRESS</th>
					<th>删除</th>
					<th>修改</th>
				</tr>
			</thead>
			<tbody>
				<%
					PersonDaoImpl pdi = new PersonDaoImpl();
					List<Person> list = pdi.selectAll();
					for (Person p : list) {
				%>
				<tr>
					<%--删除选中按钮--%>
					<td><input type="checkbox" name="id" value="<%=p.getId()%>" /></td>
					<%--图标--%>
					<td><img src="img/person.png" /></td>
					<%--ID编号--%>
					<td><%=p.getId()%></td>
					<%--姓名--%>
					<td><%=p.getName()%></td>
					<%--年龄--%>
					<td><%=p.getAge()%></td>
					<%--电话--%>
					<td><%=p.getPhone()%></td>
					<%--地址--%>
					<td><%=p.getAddress()%></td>
					<%--删除超链接--%>
					<td><a href="/servlet_day7/delete?id=<%=p.getId()%>"
						name="remove">删除</a></td>
					<%--修改超链接--%>
					<td><a href="/servlet_day7/private/showOne.jsp?id=<%=p.getId()%>"
						name="update">修改</a></td>
				</tr>
				<%
					}
				%>
			</tbody>
		</table>
	</form>
</body>
</html>

六、添加用户

1.insert.html

介绍:展示给用户操作的添加界面,让用户输入添加的联系人信息,当用户点击添加按钮后,跳转到InsertAction判断用户输入的数据是否合法。当用户点击重置按钮后,将信息恢复默认值

<!DOCTYPE html>
<html>

	<head>
		<meta charset="utf-8" />
		<title>添加联系人页面</title>
		<style type="text/css">
			img {
				width: 30px;
				height: 30px;
			}
			
			#div1 {
				text-align: center;
				margin: auto;
				/*控制div的字体大小*/
				font-size: 30px;
				/*控制文本和边框之间的距离*/
				padding: 15px;
				margin-left: -40px;
			}
			
			#div2 {
				text-align: center;
				margin: auto;
				width: 300px;
				height: 100px;
				padding: 0px;
			}
			/*使光标放在超连接上变红*/
			
			a:hover {
				color: red;
			}
		</style>
	</head>

	<body>
		<div id="div1">添加联系人</div>
		<hr />
		<form action="/servlet_day7/insert" method="post">
			<div id="div2">
				<table border="0" cellspacing="0" cellpadding="7">
					<tr>
						<td>
							用户名:
						</td>
						<td>
							<input type="text" name="username" />
						</td>
					</tr>
					<tr>
						<td>
							密码:
						</td>
						<td>
							<input type="password" name="password1" />
						</td>
					</tr>
					<tr>
						<td>
							密码:
						</td>
						<td>
							<input type="password" name="password2" />
						</td>
					</tr>
					<tr>
						<td>
							姓名:
						</td>
						<td>
							<input type="text" name="name" />
						</td>
					</tr>
					<tr>
						<td>
							年龄:
						</td>
						<td>
							<input type="text" name="age" />
						</td>
					</tr>
					<tr>
						<td>
							电话:
						</td>
						<td>
							<input type="text" name="phone" />
						</td>
					</tr>
					<tr>
						<td>
							家庭住址:
						</td>
						<td>
							<input type="text" name="address" />
						</td>
					</tr>
					<tr>
						<td>
							<input type="reset" style="float: left;"/>
						</td>
						<td>
							<input id="insert" type="submit" value="添加" />
						</td>
					</tr>
				</table>
			</div>
		</form>
	</body>

</html>

2.InsertAction业务类

介绍:接收用户输入的添加信息,根据约束条件先进行第一轮判断,如果不合法则展示对应的提示界面,如果满足约束条件,调用dao层进行第二轮判断,如果合法,跳转到ShowJsp界面

package servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.PersonDaoImpl;
import entity.Person;

public class InsertAction extends HttpServlet {
	/**
	 * 
	 */
	private static final long serialVersionUID = 3653522036179307006L;

	// 创建一个PersonDaoImpl对象
	private static PersonDaoImpl pdi = new PersonDaoImpl();

	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		resp.setContentType("text/html");
		int id = pdi.getSequence();
		String un = req.getParameter("username");
		String pwd1 = req.getParameter("password1");
		String pwd2 = req.getParameter("password2");
		String name = req.getParameter("name");
		String strAge = req.getParameter("age");
		String phone = req.getParameter("phone");
		String address = req.getParameter("address");
		Integer age = (strAge.equals("")) ? 0 : Integer.parseInt(strAge);
		// 判断账号是否为空
		if (un.equals("")) {
			resp.sendRedirect("/servlet_day7/unnull.html");
			// 判断第一次输入的密码是否为空
		} else if (pwd1.equals("")) {
			resp.sendRedirect("/servlet_day7/pwd1null.html");
			// 判断第二次输入的密码是否为空
		} else if (pwd2.equals("")) {
			resp.sendRedirect("/servlet_day7/pwd2null.html");
			// 判断用户名是否被使用
		} else if (pdi.ifExistToUserName(un)) {
			resp.sendRedirect("/servlet_day7/insertfailed.html");
			// 判断两次输入的密码是否一致
		} else if (!pwd1.equals(pwd2)) {
			resp.sendRedirect("/servlet_day7/notboth.html");
			// 判断姓名是否为空
		} else if (name.equals("")) {
			resp.sendRedirect("/servlet_day7/namenull.html");
			// 判断年龄是否合法
		} else if (age > 200) {
			resp.sendRedirect("/servlet_day7/agemorethan.html");
			// 判断手机号码是否合法 长度为11位并且是1开头
		} else if (!phone.equals("") && phone.charAt(0) != '1' || phone.length() != 11) {
			resp.sendRedirect("/servlet_day7/morethan.html");
		} else if (pdi.selectLikeTel(phone).size() != 0) {
			resp.sendRedirect("/servlet_day7/phoneExist.html");
		} else {
			// 将添加的信息存入数据库
			pdi.insert(un, pwd1, new Person(id, name, age, phone, address));
			// 使用重定向响应给浏览器
			resp.sendRedirect("/servlet_day7/private/showAll.jsp");
		}
	}
}

七、删除用户

1.DeleteAction业务层

介绍:接收用户点击删除超链接或是点批量删除按钮传递过来的id值的集合,并调用dao层实现批量删除

package servlet;

import java.io.IOException;
import java.util.LinkedHashSet;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.PersonDaoImpl;

public class DeleteAction extends HttpServlet {
	/**
	 * 
	 */
	private static final long serialVersionUID = -4219373680813944804L;

	private static PersonDaoImpl pdi = new PersonDaoImpl();

	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// 设置文本格式
		resp.setContentType("text/html");
		// 收集数据
		String[] strId = req.getParameterValues("id");
		LinkedHashSet<Integer> idSet = new LinkedHashSet<>();
		for (String id : strId) {
			idSet.add(Integer.parseInt(id));
		}
		pdi.deleteAll(idSet);
		// 将响应重定向到服务器
		resp.sendRedirect("/servlet_day7/private/showAll.jsp");
	}
}

八、修改用户信息

1.showOne.jsp展示层

介绍:展示用户修改的联系人信息,当用户修改信息后点击确认按钮跳转到UpdateAction业务层进行判断,当用户点击重置按钮后,恢复到初始信息

<%@ page language="java" import="java.util.*,dao.*,entity.*"
	pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'showAll.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">
<style type="text/css">
img {
	width: 30px;
	height: 30px;
}

#div1 {
	text-align: center;
	margin: auto;
	/*控制div的字体大小*/
	font-size: 30px;
	/*控制文本和边框之间的距离*/
	padding: 15px;
	margin-left: -40px;
}

#div2 {
	text-align: center;
	margin: auto;
	width: 300px;
	height: 100px;
	padding: 0px;
}

<%--使光标放在超连接上变红--%>
a:hover {
	color: red;
}
</style>
<%--
	<link rel="stylesheet" type="text/css" href="styles.css">
	--%>

</head>

<body>
	<% String strId = (String)request.getParameter("id");
	PersonDaoImpl pdi = new PersonDaoImpl();
	Person p = pdi.selectOne(Integer.parseInt(strId));
 %>
	<div id="div1">修改联系人</div>
	<hr />
	<form action="/servlet_day7/update?id=<%=strId%>" method="post">
		<div id="div2">
			<table>
				<tr>
					<td>姓名:</td>
					<td><input type="text" value="<%=p.getName()%>" name="name" /></td>
				</tr>
				<tr>
					<td>年龄:</td>
					<td><input type="text" value="<%=p.getAge()%>" name="age" /></td>
				</tr>
				<tr>
					<td>电话:</td>
					<td><input type="text" value="<%=p.getPhone()%>" name="phone" /></td>
				</tr>
				<tr>
					<td>家庭住址:</td>
					<td><input type="text" value="<%=p.getAddress()%>"
						name="address" /></td>
				</tr>
				<tr>
					<td><input type="reset" style="float: left;" /></td>
					<td><input id="update" type="submit" value="修改" /></td>
				</tr>
			</table>
		</div>
	</form>
</body>
</html>

2.UpdateAction业务层

介绍:接收用户修改后的信息,判断是否满足约束条件,如果不满足,跳转到对应的提示界面,如果满足,调用dao层将数据库中数据进行修改

package servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.PersonDaoImpl;
import entity.Person;

public class UpdateAction extends HttpServlet {
	/**
	 * 
	 */
	private static final long serialVersionUID = -4219373680813944804L;

	private static PersonDaoImpl pdi = new PersonDaoImpl();

	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// 设置文本格式
		resp.setContentType("text/html");
		String strId = req.getParameter("id");
		String strAge = req.getParameter("age");
		String name = req.getParameter("name");
		String phone = req.getParameter("phone");
		String address = req.getParameter("address");
		// 收集数据
		int id = Integer.parseInt(strId);
		int age = Integer.parseInt(strAge);
		if (age > 200) {
			resp.sendRedirect("/servlet_day7/agemorethan.html");
		} else if (phone.charAt(0) != '1' || phone.length() != 11) {
			resp.sendRedirect("/servlet_day7/morethan.html");
		} else {
			pdi.update(id, new Person(name, age, phone, address));
			// 将响应重定向到服务器
			resp.sendRedirect("/servlet_day7/private/showAll.jsp");
		}
	}
}

九、搜索层

1.SearchAction业务层

介绍:接收用户点击超链接时传递过来的数据,调用dao层中的方法进行模糊查询,并将数据放入request作用域进行存储

package servlet;

import java.io.IOException;
import java.util.LinkedHashSet;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.PersonDaoImpl;
import entity.Person;

public class SearchAction extends HttpServlet {
	/**
	 * 
	 */
	private static final long serialVersionUID = -750773065686049751L;

	private static PersonDaoImpl pdi = new PersonDaoImpl();

	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		resp.setContentType("text/html");
		String value = req.getParameter("search");
		// 将结果放在作用域
		req.setAttribute("search", value);
		LinkedHashSet<Person> selectAllLike = new LinkedHashSet<>();
		if (pdi.ifInteger(value)) {
			selectAllLike.addAll(pdi.selectLikeAge(value));
			selectAllLike.addAll(pdi.selectLikeTel(value));
		} else {
			selectAllLike.addAll(pdi.selectLikeName(value));
			selectAllLike.addAll(pdi.selectLikeAddress(value));
		}
		// 将查询到的值放到作用域
		req.setAttribute("searchAll", selectAllLike);
		// 转发给SearchJsp
		req.getRequestDispatcher("/private/likeSearch.jsp").forward(req, resp);
	}
}

2.likeSearch.jsp展示层

介绍:获取request作用域中的数据集,并动态展示在浏览器界面上

<%@ page language="java" import="java.util.*,entity.*"
	pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'showAll.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">
<style type="text/css">
img {
	width: 30px;
	height: 30px;
}

#title {
	text-align: center;
	/*控制div的字体大小*/
	font-size: 30px;
	/*控制文本和边框之间的距离*/
	padding: 15px;
}
/*使光标放在超连接上变红*/
a:hover {
	color: red;
}

a {
	color: blue;
}

form {
	text-align: center;
	font-family: 微软雅黑;
	font-size: 18px;
}

thead {
	color: white;
}
</style>
<%--
	<link rel="stylesheet" type="text/css" href="styles.css">
	--%>

</head>

<body>
	<div id="title">展示所有联系人</div>
	<hr />
	<form action="/servlet_day7/search" method="post">
		<div style="width: 48%;margin: auto;position:relative">
			<tr>
				<td><a href="insert.html"
					style="position: relative;top: 0px;right: 140px;"> <img
						src="img/add.png" />
				</a></td>
				<td><input type="search" name="search"
					style="position: relative;top: -5px;right: -166px;" /></td>
				<td><input type="submit" value="搜索"
					style="position: relative;top: -5px;right: -170px;"></input></td>
					<td><a href="/servlet_day7/private/showAll.jsp"
					style="position: relative;top: 0px;left: 170px;">返回首页</a></td>
			</tr>
		</div>
	</form>

	<form action="/servlet_day7/delete" method="post">
		<table border="1" cellspacing="1" cellpadding="3"
			style="margin: auto; width: 35%;">
			<thead bgcolor="aquamarine">
				<tr>
					<th><input type="submit" value="删除选中" /></th>
					<th>&emsp;</th>
					<th>ID</th>
					<th>USERNAME</th>
					<th>AGE</th>
					<th>PHONE</th>
					<th>ADDRESS</th>
					<th>删除</th>
					<th>修改</th>
				</tr>
			</thead>
			<tbody>
				<%
					LinkedHashSet<Person> list = (LinkedHashSet<Person>) request.getAttribute("searchAll");
					for (Person p : list) {
				%>
				<tr>
					<%--删除选中按钮--%>
					<td><input type="checkbox" name="id" value="<%=p.getId()%>" /></td>
					<%--图标--%>
					<td><img src="img/person.png" /></td>
					<%--ID编号--%>
					<td><%=p.getId()%></td>
					<%--姓名--%>
					<td><%=p.getName()%></td>
					<%--年龄--%>
					<td><%=p.getAge()%></td>
					<%--电话--%>
					<td><%=p.getPhone()%></td>
					<%--地址--%>
					<td><%=p.getAddress()%></td>
					<%--删除超链接--%>
					<td><a href="/servlet_day7/delete?id=<%=p.getId()%>"
						name="remove">删除</a></td>
					<%--修改超链接--%>
					<td><a href="/servlet_day7/private/showOne.jsp?id=<%=p.getId()%>"
						name="update">修改</a></td>
				</tr>
				<%
					}
				%>
			</tbody>
		</table>
	</form>
</body>
</html>

十、dao层

1.PersonDao接口

介绍:定义了一些需要用到的方法

package dao;

import java.util.LinkedHashSet;
import java.util.List;

import entity.Person;

public interface PersonDao {
	// 通过用户名查询密码
	public String queryPasswordByUserName(String username);

	// 判断用户名是否存在
	public boolean ifExistToUserName(String username);

	// 新用户注册
	public boolean insert(String username, String password,Person p);

	// 查询所有用户信息
	public List<Person> selectAll();
	
	// 通过id查询用户信息
	public Person selectOne(Integer id);
	
	// 获取下一个序列值
	public int getSequence();
	
	// 判断是否为整数
	public boolean ifInteger(String str);
	
	// 通过id批量删除用户
	public void deleteAll(LinkedHashSet<Integer> id);
	
	// 根据id修改用户信息
	public void update(Integer id,Person p);
	
	// 通过手机号模糊查询用户
	public List<Person> selectLikeTel(String tel);
	
	// 通过姓名模糊查询用户
	public List<Person> selectLikeName(String name);
	
	// 通过地址模糊查询用户
	public List<Person> selectLikeAddress(String addr);
	
	// 通过年龄模糊查询用户
	public List<Person> selectLikeAge(String age);
}

2.PersonDaoImpl实现类

介绍:通过jdbc连接数据库,实现接口中的方法

package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;
import java.util.regex.Pattern;

import org.junit.Test;

import entity.Person;
import utils.JdbcUtils;

public class PersonDaoImpl implements PersonDao {

	// 通过用户名查询密码
	@Override
	public String queryPasswordByUserName(String username) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement("select password from person where username = ?");
			ps.setString(1, username);
			rs = ps.executeQuery();
			boolean bn = rs.next();
			if (bn) {
				return rs.getString(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, rs);
		}
		return null;
	}

	@Test
	public void testQuery() {
		PersonDaoImpl pdi = new PersonDaoImpl();
		String str = pdi.queryPasswordByUserName("zxw");
		System.out.println(str);
	}

	// 判断用户名是否存在
	@Override
	public boolean ifExistToUserName(String username) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement("select password from person where username = ?");
			ps.setString(1, username);
			rs = ps.executeQuery();
			return rs.next();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, rs);
		}
		return false;
	}

	// 注册新用户
	@Override
	public boolean insert(String username, String password, Person p) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement("insert into person values(?,?,?,?,?,?,?)");
			ps.setInt(1, p.getId());
			ps.setString(2, username);
			ps.setString(3, password);
			ps.setString(4, p.getName());
			ps.setInt(5, p.getAge() == null ? 0 : p.getAge());
			ps.setString(6, p.getPhone());
			ps.setString(7, p.getAddress());
			ps.executeUpdate();
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, rs);
		}
		return false;
	}

	// 获取所有用户信息
	@Override
	public List<Person> selectAll() {
		List<Person> list = new ArrayList<Person>();
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement("select ID,NAME,AGE,PHONE,ADDRESS from person");
			rs = ps.executeQuery();
			while (rs.next()) {
				Integer id = rs.getInt(1);
				String name = rs.getString(2);
				Integer age = rs.getInt(3);
				String phone = rs.getString(4);
				String address = rs.getString(5);
				list.add(new Person(id, name, age, phone, address));
			}
			return list;
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, rs);
		}
		return null;
	}

	@Test
	public void testSelectAll() {
		List<Person> list = selectAll();
		for (Person p : list) {
			System.out.println(p);
		}
	}

	// 获取下一个序列值
	@Override
	public int getSequence() {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement("select login_seq.nextVal from dual");
			rs = ps.executeQuery();
			if (rs.next())
				return rs.getInt(1);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, rs);
		}
		return 0;
	}

	@Test
	public void testGetSequence() {
		System.out.println(getSequence());
	}

	// 判断是否为整数
	@Override
	public boolean ifInteger(String str) {
		Pattern pattern = Pattern.compile("^[-\\+]?[\\d]*$");
		return pattern.matcher(str).matches();
	}

	@Test
	public void testIfInteger() {
		Scanner s = new Scanner(System.in);
		System.out.println(ifInteger(s.next()) ? "是整数!" : "不是整数!");
		s.close();
	}

	// 通过id批量删除用户
	@Override
	public void deleteAll(LinkedHashSet<Integer> idSet) {
		Connection conn = null;
		PreparedStatement ps = null;
		try {
			conn = JdbcUtils.getConnection();
			for(Integer id : idSet) {
				ps = conn.prepareStatement("delete person where id = ?");
				ps.setInt(1, id);
				ps.executeUpdate();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, null);
		}
	}

	@Test
	public void testDeleteAll() {
		LinkedHashSet<Integer> idSet = new LinkedHashSet<>();
		idSet.add(48);
		idSet.add(52);
		idSet.add(53);
		idSet.add(54);
		idSet.add(55);
		deleteAll(idSet);
	}


	@Override
	public Person selectOne(Integer id) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement("select NAME,AGE,PHONE,ADDRESS from person where id = ?");
			ps.setInt(1, id);
			rs = ps.executeQuery();
			if (rs.next())
				return new Person(rs.getString(1), rs.getInt(2), rs.getString(3), rs.getString(4));
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, rs);
		}
		return null;
	}

	@Test
	public void testSelectOne() {
		Person p = selectOne(1);
		System.out.println(p);
	}

	@Override
	public void update(Integer id, Person p) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement("update person set NAME=?,AGE=?,PHONE=?,ADDRESS=? where ID=?");
			ps.setString(1, p.getName());
			ps.setInt(2, p.getAge());
			ps.setString(3, p.getPhone());
			ps.setString(4, p.getAddress());
			ps.setInt(5, id);
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, rs);
		}
	}

	@Test
	public void testUpdate() {
		update(38, new Person("修改测试", 20, "12345678910", "湖南娄底"));
	}

	@Override
	public List<Person> selectLikeTel(String tel) {
		List<Person> list = new ArrayList<Person>();
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement("select ID,NAME,AGE,PHONE,ADDRESS from person where PHONE like '%'||?||'%'");
			ps.setString(1, tel);
			rs = ps.executeQuery();
			while (rs.next()) {
				Integer id = rs.getInt(1);
				String name = rs.getString(2);
				Integer age = rs.getInt(3);
				String phone = rs.getString(4);
				String address = rs.getString(5);
				list.add(new Person(id, name, age, phone, address));
			}
			return list;
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, rs);
		}
		return null;
	}

	@Override
	public List<Person> selectLikeName(String name) {
		List<Person> list = new ArrayList<Person>();
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement("select ID,NAME,AGE,PHONE,ADDRESS from person where NAME like '%'||?||'%'");
			ps.setString(1, name);
			rs = ps.executeQuery();
			while (rs.next()) {
				Integer id = rs.getInt(1);
				String name1 = rs.getString(2);
				Integer age = rs.getInt(3);
				String phone = rs.getString(4);
				String address = rs.getString(5);
				list.add(new Person(id, name1, age, phone, address));
			}
			return list;
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, rs);
		}
		return null;
	}

	@Test
	public void testSelectLike() {
		List<Person> list = selectLikeName("刘");
		System.out.println(list.size());
		for (Person p : list) {
			System.out.println(p);
		}
	}

	@Override
	public List<Person> selectLikeAddress(String addr) {
		List<Person> list = new ArrayList<Person>();
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement("select ID,NAME,AGE,PHONE,ADDRESS from person where ADDRESS like '%'||?||'%'");
			ps.setString(1, addr);
			rs = ps.executeQuery();
			while (rs.next()) {
				Integer id = rs.getInt(1);
				String name1 = rs.getString(2);
				Integer age = rs.getInt(3);
				String phone = rs.getString(4);
				String address = rs.getString(5);
				list.add(new Person(id, name1, age, phone, address));
			}
			return list;
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, rs);
		}
		return null;
	}

	@Override
	public List<Person> selectLikeAge(String age) {
		List<Person> list = new ArrayList<Person>();
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement("select ID,NAME,AGE,PHONE,ADDRESS from person where AGE like '%'||?||'%'");
			ps.setString(1, age);
			rs = ps.executeQuery();
			while (rs.next()) {
				Integer id = rs.getInt(1);
				String name1 = rs.getString(2);
				Integer age1 = rs.getInt(3);
				String phone = rs.getString(4);
				String address = rs.getString(5);
				list.add(new Person(id, name1, age1, phone, address));
			}
			return list;
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtils.closeAll(conn, ps, rs);
		}
		return null;
	}
}

十一、其它的工具类和资源文件

1.CharacterEncodingFilter过滤器

介绍:设置编码格式,减少冗余代码

package filter;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;

public class CharacterEncodingFilter implements Filter {
	private ServletContext application;

	@Override
	public void destroy() {

	}

	@Override
	public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain)
			throws IOException, ServletException {
		String encoding = application.getInitParameter("encoding");
		request.setCharacterEncoding(encoding);
		response.setCharacterEncoding(encoding);
		chain.doFilter(request, response);
	}

	@Override
	public void init(FilterConfig filterConfig) throws ServletException {
		application = filterConfig.getServletContext();
	}

}

2.CheckNomalCommingFilter过滤器

介绍:判断是否为正常请求,减少冗余代码

package filter;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class CheckNomalCommingFilter implements Filter {

	@Override
	public void destroy() {

	}

	@Override
	public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain)
			throws IOException, ServletException {
		HttpServletRequest req = (HttpServletRequest) request;
		HttpSession session = req.getSession();
		HttpServletResponse resp = (HttpServletResponse) response;
		String un = (String) session.getAttribute("name");
		String path = req.getServletPath();
		// 如果没有登陆,送回登陆界面
		if (path.contains(".html") || path.contains("img")) {
			chain.doFilter(request, response);
		} else if (un == null && !path.equals("/login")) {
			resp.sendRedirect("/servlet_day7/Login.html");
			// 判断是否设置了用户名
		} else if (req.getParameter("username") == null) {
			// 如果是登录请求,送回登录界面
			if (path.equals("/login")) {
				resp.sendRedirect("/servlet_day7/Login.html");
				// 如果是注册请求,判断是注册前还是注册成功后
			} else if (path.contains("regist")) {
				// 如果未注册,送回注册界面
				if (req.getAttribute("regist") == null)
					resp.sendRedirect("/servlet_day7/regist.html");
				// 如果注册成功,直接放行
				else
					chain.doFilter(request, response);
				// 如果是添加请求,送回添加界面
			} else if (path.contains("insert")) {
				resp.sendRedirect("/servlet_day7/insert.html");
				// 如果都不是,进行以下判断
			} else {
				// 如果是搜索请求,并且搜索的内容为空,送回show界面
				if (path.contains("earch") && (request.getParameter("search") == null)) {
					resp.sendRedirect("/servlet_day7/private/showAll.jsp");
					// 如果是删除、修改、查看某一个用户信息的请求,并且id值为空,送回show界面
				} else if ((path.contains("delete") || path.contains("update") || path.contains("showOne"))
						&& req.getParameter("id") == null) {
					resp.sendRedirect("/servlet_day7/private/showAll.jsp");
					// 放行
				} else {
					chain.doFilter(request, response);
				}
			}
			// 放行
		} else {
			chain.doFilter(request, response);
		}
	}

	@Override
	public void init(FilterConfig filterConfig) throws ServletException {
	}

}

3.JdbcUtils工具类

介绍:定义了获取连接和关闭资源的方法,供dao层调用

package utils;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;

import com.alibaba.druid.pool.DruidDataSourceFactory;

public class JdbcUtils {
	// 封装一个数据库连接池对象
	private static DataSource ds;
	// 加载驱动
	static {
		try {
			Properties pro = new Properties();
			// 创建一个输入流对象读取数据
			InputStream path = JdbcUtils.class.getResourceAsStream("/druid.properties");
			pro.load(path);
			ds = DruidDataSourceFactory.createDataSource(pro);
		} catch (Exception e1) {
			e1.printStackTrace();
		}
	}

	// 创建一个ThreadLocal对象
	private static final ThreadLocal<Connection> local1 = new ThreadLocal<>();

	// 根据帐号密码获取Connetion对象
	public static Connection getConnection(String userName, String password) {
		try {
			if (local1.get() == null) {
				local1.set(ds.getConnection());
			}
			return local1.get();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}

	// 创建一个ThreadLocal对象
	private static final ThreadLocal<Connection> local2 = new ThreadLocal<>();

	// 获取默认帐号密码的Connection对象
	public static Connection getConnection() {
		try {
			if (local2.get() == null) {
				local2.set(ds.getConnection());
			}
			return local2.get();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}

	// 关闭所有资源
	public static void closeAll(Connection conn, PreparedStatement ps, ResultSet rs) {
		if (conn != null) {
			try {
				if (local1.get() != null) {
					local1.remove();
				} else if (local2.get() != null) {
					local2.remove();
				}
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if (ps != null) {
			try {
				ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

		if (rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

	// 关闭Connection
	public static void closeOne(Connection conn) {
		if (conn != null) {
			try {
				if (local1.get() != null) {
					local1.remove();
				}
				if (local2.get() != null) {
					local2.remove();
				}
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}

4.实体类Person

介绍:封装了一些属性,覆盖了equals和hashcode方法

package entity;

public class Person {
	private Integer id;
	private String name;
	private Integer age;
	private String phone;
	private String address;

	public Person() {
		super();
	}

	public Person(Integer id, String name, Integer age, String phone, String address) {
		super();
		this.id = id;
		this.name = name;
		this.age = age;
		this.phone = phone;
		this.address = address;
	}

	public Person(String name, Integer age, String phone, String address) {
		super();
		this.name = name;
		this.age = age;
		this.phone = phone;
		this.address = address;
	}

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public Integer getAge() {
		return age;
	}

	public void setAge(Integer age) {
		this.age = age;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	@Override
	public String toString() {
		return "Person [id=" + id + ", name=" + name + ", age=" + age + ", phone=" + phone + ", address=" + address
				+ "]";
	}

	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + ((id == null) ? 0 : id.hashCode());
		return result;
	}

	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		Person other = (Person) obj;
		if (id == null) {
			if (other.id != null)
				return false;
		} else if (!id.equals(other.id))
			return false;
		return true;
	}
}

5.xml配置文件

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
  <!-- 配置一个基本变量,使用户可以在没有源码的情况下修改编码格式 -->
  <context-param>
  	<param-name>encoding</param-name>
  	<param-value>UTF-8</param-value>
  </context-param>
  
  <!-- 配置字符编码集的过滤器 -->
  <filter>
  	<filter-name>characterEncodingFilter</filter-name>
  	<filter-class>filter.CharacterEncodingFilter</filter-class>
  </filter>
  <filter-mapping>
  	<filter-name>characterEncodingFilter</filter-name>
  	<url-pattern>/*</url-pattern>
  </filter-mapping>
  
  <!-- 检查是否正常进入的过滤器 -->
  <filter>
  	<filter-name>checkNomalCommingFilter</filter-name>
  	<filter-class>filter.CheckNomalCommingFilter</filter-class>
  </filter>
  <filter-mapping>
  	<filter-name>checkNomalCommingFilter</filter-name>
  	<url-pattern>/*</url-pattern>
  </filter-mapping>
  
  <!-- 判断登陆成功 -->
  <servlet>
  	<servlet-name>loginAction</servlet-name>
  	<servlet-class>servlet.LoginAction</servlet-class>
  </servlet>
  <servlet-mapping>
  	<servlet-name>loginAction</servlet-name>
  	<url-pattern>/login</url-pattern>
  </servlet-mapping>
  
  <!-- 展示登陆状态 -->
  <servlet>
  	<servlet-name>loginJsp</servlet-name>
  	<servlet-class>servlet.LoginJsp</servlet-class>
  </servlet>
  <servlet-mapping>
  	<servlet-name>loginJsp</servlet-name>
  	<url-pattern>/loginsuccess</url-pattern>
  </servlet-mapping>
  
  <!-- 判断注册成功 -->
   <servlet>
  	<servlet-name>RegistAction</servlet-name>
  	<servlet-class>servlet.RegistAction</servlet-class>
  </servlet>
  <servlet-mapping>
  	<servlet-name>RegistAction</servlet-name>
  	<url-pattern>/regist</url-pattern>
  </servlet-mapping>
  
  <!-- 展示注册状态 -->
   <servlet>
  	<servlet-name>RegistJSP</servlet-name>
  	<servlet-class>servlet.RegistJsp</servlet-class>
  </servlet>
  <servlet-mapping>
  	<servlet-name>RegistJSP</servlet-name>
  	<url-pattern>/registsuccess</url-pattern>
  </servlet-mapping>
  
  <!-- 修改联系人 -->
   <servlet>
  	<servlet-name>UpdateAction</servlet-name>
  	<servlet-class>servlet.UpdateAction</servlet-class>
  </servlet>
  <servlet-mapping>
  	<servlet-name>UpdateAction</servlet-name>
  	<url-pattern>/update</url-pattern>
  </servlet-mapping> 
  
  <!-- 添加联系人 -->
   <servlet>
  	<servlet-name>InsertAction</servlet-name>
  	<servlet-class>servlet.InsertAction</servlet-class>
  </servlet>
  <servlet-mapping>
  	<servlet-name>InsertAction</servlet-name>
  	<url-pattern>/insert</url-pattern>
  </servlet-mapping>
  
  <!-- 删除联系人 -->
   <servlet>
  	<servlet-name>DeleteAction</servlet-name>
  	<servlet-class>servlet.DeleteAction</servlet-class>
  </servlet>
  <servlet-mapping>
  	<servlet-name>DeleteAction</servlet-name>
  	<url-pattern>/delete</url-pattern>
  </servlet-mapping>
  
  <!-- 模糊搜索联系人Action -->
   <servlet>
  	<servlet-name>SearchAction</servlet-name>
  	<servlet-class>servlet.SearchAction</servlet-class>
  </servlet>
  <servlet-mapping>
  	<servlet-name>SearchAction</servlet-name>
  	<url-pattern>/search</url-pattern>
  </servlet-mapping>
  
</web-app>