authorsearch.java

vb+java实现的图书管理系统

package servlet;

import java.io.IOException;
import java.io.PrintWriter;

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

import com.bean.util.DbConn;

public class AuthorSearch extends HttpServlet {

	public AuthorSearch() {
		super();
	}

	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("gbk");
		response.setContentType("text/html;charset=gbk");
		PrintWriter out = response.getWriter();
		int type=Integer.parseInt(request.getParameter("typeId").toString());
		String author=request.getParameter("author").toString().trim();
		String sql="";
		if(type==0){
			sql="select BookId,BookName,Publisher,author from bookInfo where author like '%"+author+"%'";
		}
		else{
			sql="select BookId,BookName,Publisher,author from bookInfo where author like '%"+author+"%' and bookTypeId="+type+"";
		}
		DbConn conn=new DbConn();
		String[][] bookInfo=conn.getData(sql);
		request.setAttribute("bookInfo",bookInfo);
		RequestDispatcher rd = getServletContext().getRequestDispatcher("/index.jsp?contr=search&type=result");
		rd.forward(request, response);
		out.flush();
		out.close();
	}

	public void init() throws ServletException {
		// Put your code here
	}

}