java用户表单

## java用户表单
UserServlet.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.annotation.WebServlet;
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
 */
@WebServlet("/UserServlet")
public class UserServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
	private UserDao userDao = null;  
    /**
     * @see HttpServlet#HttpServlet()
     */
    public UserServlet() {
        super();
        // TODO Auto-generated constructor stub
        userDao = new UserDao();
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		response.setContentType("text/heml;charset=UTF-8");
		request.setCharacterEncoding("UTF-8");
		
		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);
		}
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(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>");
		}
	}
}

ConnDB.java

package com.wgh.tools;

import java.io.InputStream; //导入java.io.InputStream类
import java.sql.*; //导入java.sql包中的所有类
import java.util.Properties; //导入java.util.Properties类

public class ConnDB {
	public Connection conn = null; // 声明Connection对象的实例
	public Statement stmt = null; // 声明Statement对象的实例
	public ResultSet rs = null; // 声明ResultSet对象的实例
	private static String propFileName = "connDB.properties"; // 指定资源文件保存的位置
	private static Properties prop = new Properties(); // 创建并实例化Properties对象的实例
	private static String dbClassName = "com.mysql.jdbc.Driver"; // 定义保存数据库驱动的变量
	private static String dbUrl = "jdbc:mysql://127.0.0.1:3306/db_9griddiary?user=root&password=root&useUnicode=true";

	public ConnDB() { // 构造方法
		try { // 捕捉异常
			// 将Properties文件读取到InputStream对象中
			InputStream in = getClass().getResourceAsStream(propFileName);
			prop.load(in); // 通过输入流对象加载Properties文件
			dbClassName = prop.getProperty("DB_CLASS_NAME"); // 获取数据库驱动
			// 获取连接的URL
			dbUrl = prop.getProperty("DB_URL", dbUrl);
		} catch (Exception e) {
			e.printStackTrace(); // 输出异常信息
		}
	}

	/**
	 * 功能：获取连接的语句
	 * 
	 * @return
	 */
	public static Connection getConnection() {
		Connection conn = null;
		try { // 连接数据库时可能发生异常因此需要捕捉该异常
			Class.forName(dbClassName).newInstance(); // 装载数据库驱动
			conn = DriverManager.getConnection(dbUrl); // 建立与数据库URL中定义的数据库的连接
		} catch (Exception ee) {
			ee.printStackTrace(); // 输出异常信息
		}
		if (conn == null) {
			System.err
					.println("警告: DbConnectionManager.getConnection() 获得数据库链接失败.\r\n\r\n链接类型:"
							+ dbClassName + "\r\n链接位置:" + dbUrl); // 在控制台上输出提示信息
		}
		return conn; // 返回数据库连接对象
	}

	/*
	 * 功能：执行查询语句
	 */
	public ResultSet executeQuery(String sql) {
		try { // 捕捉异常
			conn = getConnection(); // 调用getConnection()方法构造Connection对象的一个实例conn
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			rs = stmt.executeQuery(sql);
		} catch (SQLException ex) {
			System.err.println(ex.getMessage()); // 输出异常信息
		}
		return rs; // 返回结果集对象
	}

	/*
	 * 功能:执行更新操作
	 */
	public int executeUpdate(String sql) {
		int result = 0; // 定义保存返回值的变量
		try { // 捕捉异常
			conn = getConnection(); // 调用getConnection()方法构造Connection对象的一个实例conn
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			result = stmt.executeUpdate(sql); // 执行更新操作
		} catch (SQLException ex) {
			result = 0; // 将保存返回值的变量赋值为0
		}
		return result; // 返回保存返回值的变量
	}

	/*
	 * 功能:关闭数据库的连接
	 */
	public void close() {
		try { // 捕捉异常
			if (rs != null) { // 当ResultSet对象的实例rs不为空时
				rs.close(); // 关闭ResultSet对象
			}
			if (stmt != null) { // 当Statement对象的实例stmt不为空时
				stmt.close(); // 关闭Statement对象
			}
			if (conn != null) { // 当Connection对象的实例conn不为空时
				conn.close(); // 关闭Connection对象
			}
		} catch (Exception e) {
			e.printStackTrace(System.err); // 输出异常信息
		}
	}
}

connDB.properties

DB_CLASS_NAME=com.mysql.jdbc.Driver
DB_URL=jdbc:mysql://127.0.0.1:3306/db_9griddiary?user=root&password=root&useUnicode=true