jsp servlet 图书管理系统

package com.sam.web.book; import java.io.IOException; import java.io.PrintWriter; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletConfig; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.sam.web.Show; import com.sam.web.db.DbUtil; public class BookServlet extends HttpServlet { private String encoding = "utf-8"; public void init(ServletConfig config) { String encodingParam = config.getInitParameter("encoding"); if(encodingParam!=null) encoding = encodingParam; } public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { request.setCharacterEncoding(encoding); response.setContentType("text/html;charset=gb2312"); BookService service = new BookService(); TypeService typeservice = new TypeService(); Book book = new Book(); BookType bookType = new BookType(); FormService.introspect(book, request); FormService.introspect(bookType, request); String op = request.getParameter("op"); if (op == null) op = ""; if (op.equals("load")) { String name = request.getParameter("username"); String password = request.getParameter("password"); if (name != null && password != null) { if (service.check("tb_user WHERE username='" + name + "' AND password='" + password + "'") > 0) { request.setAttribute("loginState", "1"); } else { request.setAttribute("loginState", "0"); } request.getRequestDispatcher("book/index.jsp").forward(request, response); } } if (op.equals("add")) { service.setbook(book); try { service.save(); response.sendRedirect("book/bookManege.jsp?username='1'"); } catch (SQLException e) { e.printStackTrace(); } } if (op.equals("update")) { service.setbook(book); String bookname = request.getParameter("bookname"); service.update(bookname); response.sendRedirect("book/bookManege.jsp"); } if (op.equals("delete")) { String isbn = request.getParameter("isbn"); service.delete(isbn); response.sendRedirect("book/bookManege.jsp"); } if (op.equals("addType")) { typeservice.setbookType(bookType); try { typeservice.save(); response.sendRedirect("book/typeList.jsp"); } catch (SQLException e) { e.printStackTrace(); } } if (op.equals("delType")) { String typename = request.getParameter("typename"); typeservice.delete(typename); response.sendRedirect("book/typeList.jsp"); } } public void destroy() { } }