showbook.java

网上书店网站源代码

package bookshop.bean;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import bookshop.bean.book;
import bookshop.bean.DataBase;
public class ShowBook extends HttpServlet{
public void doGet(HttpServletRequest request,
	HttpServletResponse response)
	 throws ServletException, IOException {
		request.setCharacterEncoding("GB2312");
		String key=request.getParameter("key");
		String mes="";
		Vector booklist=new Vector();
		HttpSession session=request.getSession();
		String sql="select * from b_book where";
		if(session.getAttribute("booklist")!=null){
			session.removeAttribute("booklist");
		}
		if(key==null){
			if(request.getParameter("type")==null){
				sql+="ifNew='yes'";
			}
			else{
				String type="";
				if(request.getParameter("type").equals("building")){
					type="a";
				}
				if(request.getParameter("type").equals("statute")){
					type="a"; 
				}
				if(request.getParameter("type").equals("compute")){
					type="a";
				}
				if(request.getParameter("type").equals("medicine")){
					type="a"; 
				}
				if(request.getParameter("type").equals("literar")){
					type="a";
				}
				if(request.getParameter("type").equals("run")){
					type="a"; 
				}
				if(request.getParameter("type").equals("qita")){
					type="a"; 
				}
				sql+="type="+"\'"+type+"\'";
				}
				}
				else{
					sql+="name like"+"\"'%"+key+"%\'"
					+"or author like "+"\'%"+key+"%\'"
					+"or press like "+"\'%"+key+"%\'"
					+"or price like "+"\'%"+key+"%\'";
				}
				DataBase db=new DataBase();
				db.connect();
				ResultSet rs=db.executeQuery(sql);
				try{
					while(rs.next()){
						book b=new book();
						rs.getString("b_no");
						rs.getString("b_name");
						rs.getString("b_author");
						rs.getString("b_press");
						rs.getString("b_price");
//						rs.getString("b_type"));
						booklist.addElement(b);
					}
				}
				catch(Exception e){
					System.out.println(e.getMessage());
				}
				db.closeConnection();
				session.setAttribute("booklist",booklist);
				response.sendRedirect("/bookshop/main2.jsp/");
			}
			public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
	{
		doGet(request,response);
	}
	
}