booklist.java

使用servlet写的简单网上书店

package v;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletConfig;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.sql.DataSource;

import utils.BookUtil;
import entity.Book;

public class BookList extends HttpServlet {
	private ServletConfig config;
	private DataSource ds;
	private PrintWriter out;
	private ResultSet rs;

	public void init(ServletConfig config) throws ServletException {
		super.init(config);
		this.config = config;
		ServletContext context = config.getServletContext();
		ds = (DataSource) context.getAttribute("DataSource");
	}

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

		HttpSession session = request.getSession(false);
		String pageInfo = "../login.html";
		if(null==session){
		response.sendRedirect(pageInfo);
		}else{
		String str = (String) session.getAttribute("login");
		if ("success".equals(str)) {
			out = response.getWriter();
			this.displayResult(request);

			out.close();
		} else {
			pageInfo = "../login.html";
			response.sendRedirect(pageInfo);
		}
		}
	}

	private void displayResult(HttpServletRequest request) {
		Connection con=null;
		try {
			con = ds.getConnection();
			BookUtil bookUtil=new BookUtil(con);
			
			out.println("<form action=\"../servlet/BookList\" method=\"POST\" name=\"bookList1\"><br>");
			out.println("请选择查询方式：<select>");
			out.println("<option value=\"0\">按书名</option>");
			out.println("<option value=\"1\">按id</option>");
			out.println("</select>");
			out.println("<input type=\"text\" name=\"theBook\">");
			out.println("<input type=\"submit\" value=\"查询\"><br>");
			
			String bookName=request.getParameter("theBook");
			bookUtil.getByName(bookName, out);
			
			out.println("</form>");
			
			out.println("<form action=\"../servlet/AddToCart\" method=\"POST\" name=\"bookList\"><br>");
			out.println("bookId" + "&nbsp;&nbsp;&nbsp;" + "bookName"
					+ "&nbsp;&nbsp;&nbsp;" + "操作<br>");

			Book book=new Book();
			bookUtil.displayBook(book, out);
			
			out.println("<p><input type=submit value=添加到购物车 >");
			out.println("</form>");

			out.println("<input type=\"button\" onclick=\"javascript:window.open('../servlet/ViewCart','bookcart','toolbar=no,status=no,width=300,height=400,menubar=no')\" value=\"查看购物车\"><br>");
			
			out.println("<form action=\"../servlet/AddBook\" method=\"POST\" name=\"bookList\"><br>");
			out.println("书名：");
			out.println("<input type=\"text\" name=\"bookName\"><br>");
			out.println("价钱：");
			out.println("<input type=\"text\" name=\"bookPrice\"><br>");
			out.println("<input type=\"submit\" value=\"添加书籍\"><br>");
			
			out.println("</form>");
			
			out.println("<form action=\"../servlet/DeleteBook\" method=\"POST\" name=\"bookList\"><br>");
			out.println("bookId" + "&nbsp;&nbsp;&nbsp;" + "bookName"
					+ "&nbsp;&nbsp;&nbsp;" + "操作<br>");
			Book book1=new Book();
			bookUtil.displayBook(book1, out);
			out.println("<p><input type=submit value=删除 >");
			out.println("</form>");
			
			con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

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