searchbookbean.java

本系统完成简单的图书管理系统

/***********************************************************************
*                          湖南大学图书管理系统
* @author Administrator                                                         
* @since 2008.06                                                  
* @version 1.0                                                           															  
* @category 查询图书bean
*************************************************************************/

package library.control;

import java.io.IOException;
import java.util.Hashtable;
import java.util.Vector;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import library.DBaccess.SearchBookDB;

public class SearchBookBean extends HttpServlet{

	
	public SearchBookBean(){
		super();
	}
	
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		
		
		if(req.getParameter("name").equals("search"))
		{
			System.out.println("图书查询");
			req.setAttribute("title","图书查询");
			req.setAttribute("URL","//student/view/searchBook.jsp");
			RequestDispatcher dis=this.getServletContext().getRequestDispatcher("/student/index.jsp");
			dis.forward(req,resp);
		}
		if(req.getParameter("name").equals("searchmanager"))
		{
			System.out.println("图书查询");
			req.setAttribute("title","图书查询");
			req.setAttribute("URL","//manager/view/searchBook.jsp");
			RequestDispatcher dis=this.getServletContext().getRequestDispatcher("/manager/index.jsp");
			dis.forward(req,resp);
		}
		//super.doPost(req, resp);
		
	}

	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		req.setCharacterEncoding("gb2312");
		if(req.getParameter("name").equals("bquery"))
		{
			String parameter=req.getParameter("select");
			//System.out.println(parameter);
			String value=req.getParameter("value");
			//System.out.println(value);
			Vector vv=null;
			SearchBookDB sbd=new SearchBookDB();
			if(parameter.equals("bookName"))
			{
				
				vv=sbd.getBookByName("TITLE",value);
			}
			if(parameter.equals("author"))
			{
				vv=sbd.getBookByName("AUTHOR",value);
			}
			if(parameter.equals("isbn"))
			{
				vv=sbd.getBookByName("ISBN",value);
			}
			System.out.println(vv.size());
			req.setAttribute("bookValue",vv);
			
			//必须封装
			req.setAttribute("title","图书查询");
			req.setAttribute("URL","//manager/view/borrowBook.jsp");
			
			RequestDispatcher dis=this.getServletContext().getRequestDispatcher("//manager/index.jsp");
			dis.forward(req,resp);		
				
		}
		if(req.getParameter("name").equals("query"))
		{
			String parameter=req.getParameter("select");
			//System.out.println(parameter);
			String value=req.getParameter("value");
			//System.out.println(value);
			Vector vv=null;
			SearchBookDB sbd=new SearchBookDB();
			if(parameter.equals("bookName"))
			{
				
				vv=sbd.getBookByName("TITLE",value);
			}
			if(parameter.equals("author"))
			{
				vv=sbd.getBookByName("AUTHOR",value);
			}
			if(parameter.equals("isbn"))
			{
				vv=sbd.getBookByName("ISBN",value);
			}
			System.out.println(vv.size());
			req.setAttribute("bookValue",vv);
			
			//必须封装
			req.setAttribute("title","图书查询");
			req.setAttribute("URL","//student/view/searchBook.jsp");
			
			RequestDispatcher dis=this.getServletContext().getRequestDispatcher("//student/index.jsp");
			dis.forward(req,resp);		
				
		}
		
		if(req.getParameter("name").equals("lookup"))
		{
			String parameter=req.getParameter("select");
			//System.out.println(parameter);
			String value=req.getParameter("value");
			//System.out.println(value);
			Vector vv=null;
			SearchBookDB sbd=new SearchBookDB();
			if(parameter.equals("bookName"))
			{
				
				vv=sbd.getBookByName("TITLE",value);
			}
			if(parameter.equals("author"))
			{
				vv=sbd.getBookByName("AUTHOR",value);
			}
			if(parameter.equals("isbn"))
			{
				vv=sbd.getBookByName("ISBN",value);
			}
			System.out.println(vv.size());
			req.setAttribute("bookValue",vv);
			
			//必须封装
			req.setAttribute("title","图书查询");
			req.setAttribute("URL","//manager/view/searchBook.jsp");
			
			RequestDispatcher dis=this.getServletContext().getRequestDispatcher("//manager/index.jsp");
			dis.forward(req,resp);		
				
		}
		
		/*if(req.getParameter("name").equals("lookUp"))
		{
			Hashtable hhs=null;
			String bookid=req.getParameter("bookid");
			SearchBookDB sbd=new SearchBookDB();
			hhs=sbd.getBookByID(Integer.valueOf(bookid).intValue());
			System.out.println(hhs);
			req.setAttribute("bookMainInfo",hhs);
			
			//馆藏信息
			Hashtable hs=sbd.getBookInfo(Integer.valueOf(bookid).intValue());
			req.setAttribute("bookInfo",hs);
			
			req.setAttribute("title","图书详细信息");
			req.setAttribute("URL","/view/BookView.jsp");
			
			RequestDispatcher dis=this.getServletContext().getRequestDispatcher("/index.jsp");
			dis.forward(req,resp);
//			
		}*/
		
	}

	@Override
	public void destroy() {
		// TODO Auto-generated method stub
		super.destroy();
	}

	@Override
	public void init() throws ServletException {
		// TODO Auto-generated method stub
		//super.init();
	}

}