readerchagepasswdcontroller.java

学习jsp时做的一个书馆

 import java.io.IOException;
import java.sql.ResultSet;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import library.*;


@SuppressWarnings("serial")
public class ReaderChagepasswdController extends Controller {
	 public void doPost (HttpServletRequest req,
				HttpServletResponse res) throws ServletException, IOException {
		
		String newpasswd="",newpasswd1="", oldpasswd="";

		HttpSession session = req.getSession();
		
		oldpasswd = req.getParameter("oldpasswd");
		newpasswd = req.getParameter("newpasswd");
		newpasswd1 = req.getParameter("newpasswd1");	
		boolean isEqual = false;
		if(newpasswd.equals(newpasswd1)){
			isEqual = true;
		}
		session = req.getSession();
		
	    boolean islogin = false;
		try {
			islogin = (new Reader((String)session.getAttribute("readerno"),oldpasswd)).isLogin();
		} catch (Exception e) {
			sendErrorRedirect(req, res, e);
		}
		
		try {
		    if(islogin == false){	
			    res.sendRedirect("../changepasswd.jsp?jieguo=failed1");
		    }else if(isEqual==false){
		    	//res.sendRedirect("../test.jsp?jieguo="+"update reader set password = '"+newpasswd+"' where ReaderID='" +(String)session.getAttribute("readerno")+ "'");
		    	res.sendRedirect("../changepasswd.jsp?jieguo=failed2");
		    }else if(newpasswd.equals("")||newpasswd1.equals("")){
		    	 res.sendRedirect("../changepasswd.jsp?jieguo=failed3");
		    }else{
			    DBConnection myConnection = DBConnection.Instance();
			 	String sqlUpdate = "update  reader  set  password = '"+newpasswd1+"' where  ReaderID = '" +(String)session.getAttribute("readerno")+ "' ";
			 	boolean r = false;
			 	r = myConnection.runUpdate( sqlUpdate );
			 	//res.sendRedirect("../test.jsp?jieguo="+sqlQuery);
				res.sendRedirect("../changepasswd.jsp?jieguo=success");
		    }
		} catch (Exception e2) {
		    sendErrorRedirect(req, res, e2);
		}
	    }
}