delreadercontroller.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.DBConnection;


@SuppressWarnings("serial")
public class delReaderController extends Controller {
	 public void doPost (HttpServletRequest req,
				HttpServletResponse res) throws ServletException, IOException {
		
		String del="",del1="",id="";

		HttpSession session = req.getSession();
		
		del = req.getParameter("del");
		del1 = req.getParameter("del2");
		id = req.getParameter("id");
		
		try{
			if(del.equals("yes")&&del1.equals("yes")){
				DBConnection connection = DBConnection.Instance();
				String sql =  "delete from reader where readerid ='"+id+"'";
				boolean w = false;
				w = connection.runUpdate(sql);
				//session.removeAttribute("rdsearchresult");
				res.sendRedirect("../admin/searchreader.jsp?jieguo1=success&id="+id);			
			}
			if(del.equals("yes")&&del1.equals("no")){
				res.sendRedirect("../admin/readsearchresult.jsp?jieguo=failed1&id="+id);			
			}
			if(del.equals("no")&&del1.equals("yes")){
				res.sendRedirect("../admin/readsearchresult.jsp?jieguo=failed2&id="+id);			
			}
			if(del.equals("no")&&del1.equals("no")){
				res.sendRedirect("../admin/readsearchresult.jsp?jieguo=failed3&id="+id);			
			}
		}catch(Exception e){
			sendErrorRedirect(req, res, e);
		}
	 }
}