addreadercontroller.java

学习jsp时做的一个书馆

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

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import   java.net.URLEncoder;   

import library.DBConnection;
import library.Reader;



@SuppressWarnings("serial")
public class AddReaderController 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 change = true;
		boolean change1 = true;
		boolean change2 = true;
		try {
			DBConnection connection = DBConnection.Instance();
			String sql = "select * from reader where readerid ='"+id+"'";
			ResultSet w = null;
			w = connection.runQuery(sql);
			if(w.next()){
				change = false;
			}
			sql =  "select * from reader where stuno ='"+stuno+"'";
			w = connection.runQuery(sql);
			if(w.next()){
				change2 = false;
			}
		} catch (Exception e1) {
			 sendErrorRedirect(req, res, e1);
		}
		if(id.equals("")||passwd.equals("")||stuno.equals("")||
				name.equals("")||sex.equals("")||age.equals("")||xueyuan.equals("")||
				zhuanye.equals("")||kind.equals("")||maxno.equals("")||data.equals("")){
			    change1 = false;
		}
		try {
		    if(change1 == false){	
			    res.sendRedirect("../admin/addreader.jsp?jieguo=failed1");
		    }else if(change==false){
		    	//res.sendRedirect("../test.jsp?jieguo="+"update reader set password = '"+newpasswd+"' where ReaderID='" +(String)session.getAttribute("readerno")+ "'");
		    	res.sendRedirect("../admin/addreader.jsp?jieguo=failed2");
		    }else if(change2 == false){
		    	res.sendRedirect("../admin/addreader.jsp?jieguo=failed4");
		    }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 = "insert into reader (readerid,password,stuno,name,sex,age,xueyuan,zhuanye,readerkind,maxreadno,yijieshu,usedata,beizhu) " +
			    		" values ('"+id+"','"+passwd+"','"+stuno+"','"+name+"','"+sex+"',"+age+",'"
			    +xueyuan+"','"+zhuanye+"','"+kind+"',"+maxno+",0"+",'"+data+"','"+beizhu+"')";
			    boolean rs=stmt.execute(sql);
			    stmt.close();
			    res.sendRedirect("../admin/addreader.jsp?jieguo=success");			 	
		    }
		} catch (Exception e2) {
			sendErrorRedirect(req, res, e2);
		}
	    }
}