BookStore-Website：使用servlet和jsp创建了一个简单的书店网站

package com.sarthak.bookstore; import java.io.IOException; import java.sql.SQLException; import java.util.List; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class ControllerServlet extends HttpServlet { private static final long serialVersionUID = 1L; private BookDAO bookDAO; public void init() { String jdbcURL = getServletContext().getInitParameter("jdbcURL"); String jdbcUsername = getServletContext().getInitParameter("jdbcUsername"); String jdbcPassword = getServletContext().getInitParameter("jdbcPassword"); bookDAO = new BookDAO(jdbcURL, jdbcUsername, jdbcPassword); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //System.out.println("hello dopost"); doGet(request, response); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //System.out.println("hello doget"); String action = request.getRequestURL().toString(); //System.out.println(action); try { switch (action) { case "http://localhost:8080/BookStore/new": //System.out.println("hello 1"); showNewForm(request, response); break; case "http://localhost:8080/BookStore/insert": insertBook(request, response); break; case "http://localhost:8080/BookStore/delete": deleteBook(request, response); break; case "http://localhost:8080/BookStore/edit": showEditForm(request, response); break; case "http://localhost:8080/BookStore/update": updateBook(request, response); break; default: listBook(request, response); break; } } catch (SQLException ex) { throw new ServletException(ex); } } private void listBook(HttpServletRequest request, HttpServletResponse response) throws SQLException, IOException, ServletException { List<Book> listBook = bookDAO.listAllBooks(); request.setAttribute("listBook", listBook); RequestDispatcher dispatcher = request.getRequestDispatcher("BookList.jsp"); dispatcher.forward(request, response); } private void showNewForm(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //System.out.println("hello"); RequestDispatcher dispatcher = request.getRequestDispatcher("BookForm.jsp"); dispatcher.forward(request, response); } private void showEditForm(HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException { int id = Integer.parseInt(request.getParameter("id")); Book existingBook = bookDAO.getBook(id); RequestDispatcher dispatcher = request.getRequestDispatcher("BookForm.jsp"); request.setAttribute("book", existingBook); dispatcher.forward(request, response); } private void insertBook(HttpServletRequest request, HttpServletResponse response) throws SQLException, IOException { String title = request.getParameter("title"); String author = request.getParameter("author"); float price = Float.parseFloat(request.getParameter("price")); Book newBook = new Book(title, author, price); bookDAO.insertBook(newBook); response.sendRedirect("list"); } private void updateBook(HttpServletRequest request, HttpServletResponse response) throws SQLException, IOException { int id = Integer.parseInt(request.getParameter("id")); String title = request.getParameter("title"); String author = request.getParameter("author"); float price = Float.parseFloat(request.getParameter("price")); Book book = new Book(id, title, author, price); bookDAO.updateBook(book); response.sendRedirect("list"); } private void deleteBook(HttpServletRequest request, HttpServletResponse response) throws SQLException, IOException { int id = Integer.parseInt(request.getParameter("id")); Book book = new Book(id); bookDAO.deleteBook(book); response.sendRedirect("list"); } }