java 用户登录注册过滤器实现(含数据库脚本)

package com.wgh.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;

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 com.wgh.dao.UserDao;
import com.wgh.model.CityMap;
import com.wgh.model.User;

/**
 * Servlet implementation class UserServlet
 */
public class UserServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
	private UserDao userDao = null;

	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public UserServlet() {
		super();
		userDao = new UserDao();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doGet(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doPost(request, response);// 执行doPost()方法
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doPost(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		String action = request.getParameter("action");
		if ("login".equals(action)) { // 用户登录
			this.login(request, response);
		} else if ("exit".equals(action)) {// 用户退出
			this.exit(request, response);
		} else if ("save".equals(action)) { // 保存用户注册信息
			this.save(request, response);
		} else if ("getProvince".equals(action)) { // 获取省份信息
			this.getProvince(request, response);
		} else if ("getCity".equals(action)) { // 获取市县信息
			this.getCity(request, response);
		} else if ("checkUser".equals(action)) {// 检测用户名是否存在
			this.checkUser(request, response);
		} else if ("forgetPwd1".equals(action)) { // 找回密码第一步
			this.forgetPwd1(request, response);
		} else if ("forgetPwd2".equals(action)) { // 找回密码第二步
			this.forgetPwd2(request, response);
		}
	}

	/**
	 * 功能：用户登录
	 * 
	 * @param request
	 * @param response
	 * @throws ServletException
	 * @throws IOException
	 */
	private void login(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		User f = new User();
		f.setUsername(request.getParameter("username")); // 获取并设置用户名
		f.setPwd(request.getParameter("pwd")); // 获取并设置密码
		int r = userDao.login(f);
		if (r > 0) {// 当用户登录成功时
			HttpSession session = request.getSession();
			session.setAttribute("userName", f.getUsername());// 保存用户名
			session.setAttribute("uid", r);// 保存用户ID
			request.setAttribute("returnValue", "登录成功！");// 保存提示信息
			request.getRequestDispatcher("userMessage.jsp").forward(request,
					response);// 重定向页面
		} else {// 当用户登录不成功时
			request.setAttribute("returnValue", "您输入的用户名或密码错误，请重新输入！");
			request.getRequestDispatcher("userMessage.jsp").forward(request,
					response);// 重定向页面
		}
	}

	/**
	 * 功能：用户退出
	 * 
	 * @param request
	 * @param response
	 * @throws ServletException
	 * @throws IOException
	 */
	private void exit(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		HttpSession session = request.getSession();// 获取HttpSession的对象
		session.invalidate();// 销毁session
		request.getRequestDispatcher("DiaryServlet?action=listAllDiary")
				.forward(request, response);// 重定向页面
	}

	/**
	 * 检测用户名是否被注册
	 * 
	 * @param request
	 * @param response
	 * @throws ServletException
	 * @throws IOException
	 */
	public void checkUser(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		String username = request.getParameter("username");		//获取用户名
		String sql = "SELECT * FROM tb_user WHERE username='"   username   "'";
		String result = userDao.checkUser(sql);		//调用UserDao类的checkUser()方法判断用户是否被注册
		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		out.print(result); 							// 输出检测结果
		out.flush();
		out.close();
	}

	/**
	 * 保证注册的用户信息
	 * 
	 * @param request
	 * @param response
	 * @throws ServletException
	 * @throws IOException
	 */
	public void save(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String username = request.getParameter("user"); // 获取用户名
		String pwd = request.getParameter("pwd"); // 获取密码
		String email = request.getParameter("email"); // 获取E-mail地址
		String city = request.getParameter("city"); // 获取市县
		String question = request.getParameter("question"); // 获取密码提示问题
		String answer = request.getParameter("answer"); // 获取密码提示问题答案
		String sql = "INSERT INTO tb_user (username,pwd,email,question,answer,city) VALUE ('"
				  username
				  "','"
				  pwd
				  "','"
				  email
				  "','"
				  question
				  "','"   answer   "','"   city   "')";
		String result = userDao.save(sql);// 保存用户信息
		response.setContentType("text/html"); // 设置响应的类型
		PrintWriter out = response.getWriter();
		out.print(result); // 输出执行结果
		out.flush();
		out.close();// 关闭输出流对象
	}

	/**
	 * 获取省份和直辖市
	 * 
	 * @param request
	 * @param response
	 * @throws ServletException
	 * @throws IOException
	 */
	public void getProvince(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		String result = "";
		CityMap cityMap = new CityMap();// 实例化保存省份信息的CityMap类的实例
		Map<String, String[]> map = cityMap.model;// 获取省份信息保存到Map中
		Set<String> set = map.keySet(); // 获取Map集合中的键，并以Set集合返回
		Iterator it = set.iterator();
		while (it.hasNext()) { // 将获取的省份连接为一个以逗号分隔的字符串
			result = result   it.next()   ",";
		}
		result = result.substring(0, result.length() - 1); // 去除最后一个逗号
		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		out.print(result); // 输出获取的省份字符串
		out.flush();
		out.close();// 关闭输出流对象
	}

	/**
	 * 获取市县
	 * 
	 * @param request
	 * @param response
	 * @throws ServletException
	 * @throws IOException
	 */
	public void getCity(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String result = "";
		String selProvince = request.getParameter("parProvince"); // 获取选择的省份
		selProvince = new String(selProvince.getBytes("ISO-8859-1"), "GBK");
		CityMap cityMap = new CityMap(); // 实例化保存省份信息的CityMap类的实例
		Map<String, String[]> map = cityMap.model; // 获取省份信息保存到Map中
		String[] arrCity = map.get(selProvince); // 获取指定键的值
		for (int i = 0; i < arrCity.length; i  ) { // 将获取的市县连接为一个以逗号分隔的字符串
			result = result   arrCity[i]   ",";
		}
		result = result.substring(0, result.length() - 1); // 去除最后一个逗号
		response.setContentType("text/html");// 向响应的内容类型
		PrintWriter out = response.getWriter();
		out.print(result); // 输出获取的市县字符串
		out.flush();
		out.close();// 关闭输出流对象
	}

	/**
	 * 找回密码第一步
	 * 
	 * @param request
	 * @param response
	 * @throws ServletException
	 * @throws IOException
	 */
	private void forgetPwd1(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		String username = request.getParameter("username"); // 获取用户名
		String question = userDao.forgetPwd1(username);// 执行找回密码第一步对应的方法获取密码提示问题
		PrintWriter out = response.getWriter();
		if ("".equals(question)) {// 判断密码提示问题是否为空
			out
					.println("<script>alert('您没有设置密码提示问题，不能找回密码！');history.back();</script>");
		} else if ("您输入的用户名不存在！".equals(question)) {
			out
					.println("<script>alert('您输入的用户名不存在！');history.back();</script>");
		} else {// 获取密码提示问题成功
			request.setAttribute("question", question);// 保存密码提示问题
			request.setAttribute("username", username);// 保存用户名
			request.getRequestDispatcher("forgetPwd_2.jsp").forward(request,
					response);// 重定向页面
		}
	}

	/**
	 * 找回密码第二步
	 * 
	 * @param request
	 * @param response
	 * @throws ServletException
	 * @throws IOException
	 */
	private void forgetPwd2(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		String username = request.getParameter("username"); // 获取用户名
		String question = request.getParameter("question");// 获取密码提示问题
		String answer = request.getParameter("answer"); // 获取提示问题答案
		String pwd = userDao.forgetPwd2(username, question, answer);// 执行找回密码第二步的方法判断提示问题答案是否正确
		PrintWriter out = response.getWriter();

		if ("您输入的密码提示问题答案错误！".equals(pwd)) {// 提示问题答案错误
			out
					.println("<script>alert('您输入的密码提示问题答案错误！');history.back();</script>");
		} else {// 提示问题答案正确，返回密码
			out
					.println("<script>alert('您的密码是：\\r\\n"
							  pwd
							  "\\r\\n请牢记！');window.location.href='DiaryServlet?action=listAllDiary';</script>");
		}
	}
}

资源下载

此资源下载价格为3D币（VIP免费），请先登录

资源文件列表

21/.classpath , 1012
21/.project , 1177
21/.settings/.jsdtscope , 454
21/.settings/com.genuitec.eclipse.migration.prefs , 80
21/.settings/org.eclipse.core.resources.prefs , 111
21/.settings/org.eclipse.jdt.core.prefs , 330
21/.settings/org.eclipse.wst.common.component , 410
21/.settings/org.eclipse.wst.common.project.facet.core.xml , 320
21/.settings/org.eclipse.wst.jsdt.ui.superType.container , 49
21/.settings/org.eclipse.wst.jsdt.ui.superType.name , 6
21/WebContent/CSS/style.css , 485
21/WebContent/Database/db_9griddiary.sql , 3447
21/WebContent/JS/AjaxRequest.js , 1937
21/WebContent/JS/excanvas-modified.js , 37315
21/WebContent/JS/jquery-1.3.2.min.js , 57254
21/WebContent/JS/jquery.pngFix.js , 4780
21/WebContent/JS/jquery.pngFix.pack.js , 2495
21/WebContent/JS/wghFunction.js , 1333
21/WebContent/META-INF/MANIFEST.MF , 39
21/WebContent/WEB-INF/lib/jstl-api-1.2.jar , 30677
21/WebContent/WEB-INF/lib/jstl-impl-1.2.jar , 392421
21/WebContent/WEB-INF/lib/mysql-connector-java-5.1.32-bin.jar , 969020
21/WebContent/WEB-INF/web.xml , 2241
21/WebContent/bottom.jsp , 544
21/WebContent/forgetPwd_1.jsp , 1220
21/WebContent/forgetPwd_2.jsp , 1427
21/WebContent/images/1.png , 19898
21/WebContent/images/2.png , 14117
21/WebContent/images/3.png , 23207
21/WebContent/images/4.png , 23409
21/WebContent/images/5.png , 19040
21/WebContent/images/6.png , 16857
21/WebContent/images/7.png , 24518
21/WebContent/images/8.png , 18891
21/WebContent/images/9.png , 20331
21/WebContent/images/Thumbs.db , 78336
21/WebContent/images/bg_00.jpg , 110113
21/WebContent/images/bg_01.jpg , 122063
21/WebContent/images/bg_02.jpg , 186665
21/WebContent/images/bg_bottom.jpg , 65296
21/WebContent/images/bg_top.jpg , 190982
21/WebContent/images/diary/-1625618782951844312.png , 245309
21/WebContent/images/diary/-1625618782951844312scale.jpg , 1626
21/WebContent/images/diary/-2201304326449572193.png , 246894
21/WebContent/images/diary/-2201304326449572193scale.jpg , 1657
21/WebContent/images/diary/-5039247624120215442.png , 181216
21/WebContent/images/diary/-5039247624120215442scale.jpg , 1606
21/WebContent/images/diary/2030326276105596531.png , 181699
21/WebContent/images/diary/2030326276105596531scale.jpg , 1595
21/WebContent/images/diary/241344336121425196.png , 139104
21/WebContent/images/diary/241344336121425196scale.jpg , 13656
21/WebContent/images/diary/7076008621496558673.png , 183199
21/WebContent/images/diary/7076008621496558673scale.jpg , 1629
21/WebContent/images/diary/Thumbs.db , 51200
21/WebContent/images/diaryBg_00.jpg , 116821
21/WebContent/images/diaryBg_01.jpg , 130375
21/WebContent/images/diaryBg_02.jpg , 264190
21/WebContent/images/ico01.ico , 4286
21/WebContent/images/ico02.ico , 4286
21/WebContent/images/loading.gif , 1553
21/WebContent/images/login.jpg , 33445
21/WebContent/images/navigation_bg.jpg , 12954
21/WebContent/images/template_01.png , 139332
21/WebContent/images/template_02.png , 182638
21/WebContent/images/template_03.png , 216197
21/WebContent/index.jsp , 412
21/WebContent/listAllDiary.jsp , 8385
21/WebContent/preview.jsp , 1200
21/WebContent/register.jsp , 15430
21/WebContent/top.jsp , 5692
21/WebContent/userMessage.jsp , 120
21/WebContent/writeDiary.jsp , 12861
21/src/com/wgh/dao/DiaryDao.java , 2457
21/src/com/wgh/dao/UserDao.java , 3665
21/src/com/wgh/filter/CharacterEncodingFilter.java , 1096
21/src/com/wgh/model/CityMap.java , 4896
21/src/com/wgh/model/Diary.java , 1092
21/src/com/wgh/model/User.java , 1199
21/src/com/wgh/servlet/CreateImg.java , 5346
21/src/com/wgh/servlet/DiaryServlet.java , 10728
21/src/com/wgh/servlet/UserServlet.java , 10418
21/src/com/wgh/tools/ConnDB.java , 3720
21/src/com/wgh/tools/MyPagination.java , 2752
21/src/com/wgh/tools/connDB.properties , 126