changereadercontroller.java

学习jsp时做的一个书馆

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

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

import library.DBConnection;


public class changeReaderController extends Controller {
	 public void doPost (HttpServletRequest req,
				HttpServletResponse res) throws ServletException, IOException {
		HttpSession session = req.getSession();
		//req.setCharacterEncoding("GB2312"); 
		
		String id =  new String(req.getParameter("id").getBytes("ISO-8859-1"),"GB2312");
		String passwd = new String(req.getParameter("passwd").getBytes("ISO-8859-1"),"GB2312");
		String stuno = new String(req.getParameter("stuno").getBytes("ISO-8859-1"),"GB2312");
		String name =new String( req.getParameter("name").getBytes("ISO-8859-1"),"GB2312");
		String sex = new String(req.getParameter("sex").getBytes("ISO-8859-1"),"GB2312");
		String age = new String(req.getParameter("age").getBytes("ISO-8859-1"),"GB2312");
		String xueyuan = new String(req.getParameter("xueyuan").getBytes("ISO-8859-1"),"GB2312");
		String zhuanye = new String(req.getParameter("zhuanye").getBytes("ISO-8859-1"),"GB2312");
		String kind = new String(req.getParameter("kind").getBytes("ISO-8859-1"),"GB2312");
		String maxno = new String(req.getParameter("maxno").getBytes("ISO-8859-1"),"GB2312");
		String data = new String(req.getParameter("data").getBytes("ISO-8859-1"),"GB2312");
		String beizhu = new String(req.getParameter("beizhu").getBytes("ISO-8859-1"),"GB2312");
		
		session = req.getSession();
	
		boolean change1 = true;
		if(passwd.equals("")&&stuno.equals("")&&
				name.equals("")&&sex.equals("")&&age.equals("")&&xueyuan.equals("")&&
				zhuanye.equals("")&&kind.equals("")&&maxno.equals("")&&data.equals("")&&beizhu.equals("")){
			    change1 = false;
		}
		try {
		    if(change1 == false){	
			    res.sendRedirect("../admin/changereader.jsp?jieguo=failed1&id="+id);
		    }else{
			    String url ="jdbc:mysql://localhost/library?user=root&password=linux&useUnicode=true&characterEncoding=GB2312" ;
			    Connection conn= DriverManager.getConnection(url); 
			    Statement stmt=conn.createStatement();
			   
			    String sql = "";
			    boolean rs = false;
			    if(!name.equals("")){
			    	sql = "update reader set name = '"+name+"' where readerid = '"+id+"'";
			    	rs=stmt.execute(sql);
			    }
			    if(!age.equals("")){
			    	sql = "update reader set age = '"+age+"' where readerid = '"+id+"'";
			    	rs=stmt.execute(sql);
			    }
			    if(!passwd.equals("")){
			    	sql = "update reader set password = '"+passwd+"' where readerid = '"+id+"'";
			    	rs=stmt.execute(sql);
			    }
			    
			    if(!stuno.equals("")){
			    	sql = "update reader set stuno = '"+stuno+"' where readerid = '"+id+"'";
			    	rs=stmt.execute(sql);
			    }
			    if(!sex.equals("")){
			    	sql = "update reader set sex = '"+sex+"' where readerid = '"+id+"'";
			    	rs=stmt.execute(sql);
			    }
			    if(!xueyuan.equals("")){
			    	sql = "update reader set xueyuan = '"+xueyuan+"' where readerid = '"+id+"'";
			    	rs=stmt.execute(sql);
			    }
			    if(!zhuanye.equals("")){
			    	sql = "update reader set zhuanye = '"+zhuanye+"' where readerid = '"+id+"'";
			    	rs=stmt.execute(sql);
			    }
			    if(!kind.equals("")){
			    	sql = "update reader set readerkind = '"+kind+"' where readerid = '"+id+"'";
			    	rs=stmt.execute(sql);
			    }
			    if(!maxno.equals("")){
			    	sql = "update reader set maxno = '"+maxno+"' where readerid = '"+id+"'";
			    	rs=stmt.execute(sql);
			    }
			    if(!data.equals("")){
			    	sql = "update reader set usedata = '"+data+"' where readerid = '"+id+"'";
			    	rs=stmt.execute(sql);
			    }
			    if(!beizhu.equals("")){
			    	sql = "update reader set beizhu = '"+beizhu+"' where readerid = '"+id+"'";
			    	rs=stmt.execute(sql);
			    }
			    stmt.close();
			    res.sendRedirect("../admin/readsearchresult.jsp?jieguo2=success&id1="+id);			 	
		    }
		} catch (Exception e2) {
			sendErrorRedirect(req, res, e2);
		}
	    }
}