handlepassword.java

jsp+javabean实现的会员管理系统

package myservlet.control;

import mybean.data.*;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class HandlePassword extends HttpServlet {
	public void init(ServletConfig config) throws ServletException {
		super.init(config);
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (Exception e) {
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		HttpSession session = request.getSession(true);
		Login login = (Login) session.getAttribute("login"); // 获取用户登录时的Javabean
		boolean ok = true;
		if (login == null) {
			ok = false;
			response.sendRedirect("login.jsp"); // 重定向到登录页面
		}
		if (ok == true) {
			continueWork(request, response);
		}
	}

	public void continueWork(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		HttpSession session = request.getSession(true);
		Login login = (Login) session.getAttribute("login");
		Connection con = null;
		String logname = login.getLogname();
		Password passwordBean = new Password();
		request.setAttribute("password", passwordBean);
		String oldPassword = request.getParameter("oldPassword");
		String newPassword = request.getParameter("newPassword");
		String uri = "jdbc:MySQL://localhost:3306/ComeHere";
		try {
			con = DriverManager.getConnection(uri, "root", "wsy5201314");
			Statement sql = con.createStatement();
			ResultSet rs = sql
					.executeQuery("SELECT * FROM member where logname='"
							+ logname + "'AND password='" + oldPassword + "'");
			if (rs.next()) {
				String updateString = "UPDATE member SET password='"
						+ newPassword + "' where logname='" + logname + "'";
				int m = sql.executeUpdate(updateString);
				if (m == 1) {
					passwordBean.setBackNews("密码更新成功");
					passwordBean.setOldPassword(oldPassword);
					passwordBean.setNewPassword(newPassword);
				} else {
					passwordBean.setBackNews("密码更新失败1");
				}
			} else {
				passwordBean.setBackNews("密码更新失败2");
			}
		} catch (SQLException exp) {
			passwordBean.setBackNews("密码更新失败3" + exp);
		}
		RequestDispatcher dispatcher = request
				.getRequestDispatcher("/showNewPassword.jsp");
		dispatcher.forward(request, response);
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request, response);
	}
}