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

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

import library.DBConnection;


public class AdSrarchBookController extends Controller {
	 @SuppressWarnings("unchecked")
		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 name = new String(req.getParameter("bookname").getBytes("ISO-8859-1"),"GB2312");
			String auther =new String( req.getParameter("auther").getBytes("ISO-8859-1"),"GB2312");
			String publisher = new String(req.getParameter("publisher").getBytes("ISO-8859-1"),"GB2312");
			String isbn = new String(req.getParameter("isbn").getBytes("ISO-8859-1"),"GB2312");
			String publishData = new String(req.getParameter("publishData").getBytes("ISO-8859-1"),"GB2312");
		
			session = req.getSession();
		
			boolean find = true;
			
			if(id.equals("")&&name.equals("")&&
					auther.equals("")&&publisher.equals("")&&
					publishData.equals("")){
				    find = false;
			}
			try{
				if(find==false){
					res.sendRedirect("../admin/searchBook.jsp?jieguo=failed");
				}else{
					String sql = "select * from books,booktitle where ";
					if(!id.equals("")){
						sql += "findid = '"+id+"'";
					}
					if(!name.equals("")&&!sql.endsWith("where ")){
						sql += "and name like '%"+name+"%'";
					}
					if(!name.equals("")&&sql.endsWith("where ")){
						sql += "name like '%"+name+"%'";
					}
					if(!auther.equals("")&&!sql.endsWith("where ")){
						sql += "and aurher like '%"+auther+"%'";
					}
					if(!auther.equals("")&&sql.endsWith("where ")){
						sql += " auther like '%"+auther+"%'";
					}
					if(!publisher.equals("")&&!sql.endsWith("where ")){
						sql += "and publisher like '%"+publisher+"%'";
					}
					if(!publisher.equals("")&&sql.endsWith("where ")){
						sql += " publisher like '%"+publisher+"%'";
					}
					if(!isbn.equals("")&&!sql.endsWith("where ")){
						sql += "and isbn = '"+isbn+"'";
					}
					if(!isbn.equals("")&&sql.endsWith("where ")){
						sql += " isbn = '"+isbn+"'";
					}
					if(!publishData.equals("")&&!sql.endsWith("where ")){
						sql += "and publishData = '"+publishData+"'";
					}
					if(!publishData.equals("")&&sql.endsWith("where ")){
						sql += " publishData = '"+publishData+"'";
					}
					DBConnection connection = DBConnection.Instance();
					ResultSet w = null;
					
					Vector vector = new Vector();
					w = connection.runQuery(sql);
					while(w.next()){
						boolean add=true;
						String hh = "";
						for(int i=0;i<vector.size();i++){
							hh = (String)vector.get(i);
							if(hh.equals(w.getString("books.isbn"))){
								add = false;
							}
						}
						if(add==true){
						    vector.add(w.getString("books.isbn"));
						}
						;
						//res.sendRedirect("../admin/new.jsp?l="+w.getString("readerid"));
					}
					session.setAttribute("rdsearchbookresult", vector);
					res.sendRedirect("../admin/searchbookresult.jsp");
				}
				
			}catch(Exception e){
				 sendErrorRedirect(req, res, e);
			}
		 }
	}