基于HTML+CSS+JS+JSP+Mysql的书城购书商城设计与实现.zip

package com.shine.bookshop.servlet.admin; import java.io.File; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.commons.fileupload.FileItem; import org.apache.commons.fileupload.FileUploadException; import org.apache.commons.fileupload.disk.DiskFileItemFactory; import org.apache.commons.fileupload.servlet.ServletFileUpload; import org.apache.commons.io.IOUtils; import com.shine.bookshop.bean.Book; import com.shine.bookshop.bean.Catalog; import com.shine.bookshop.bean.PageBean; import com.shine.bookshop.bean.UpLoadImg; import com.shine.bookshop.dao.BookDao; import com.shine.bookshop.dao.CatalogDao; import com.shine.bookshop.dao.UpLoadImgDao; import com.shine.bookshop.dao.impl.BookDaoImpl; import com.shine.bookshop.dao.impl.CatalogDaoImpl; import com.shine.bookshop.dao.impl.UpLoadImgDaoImpl; import com.shine.bookshop.util.RanUtil; import net.sf.json.JSONObject; /** * Servlet implementation class BookManageServlet */ @WebServlet("/jsp/admin/BookManageServlet") public class BookManageServlet extends HttpServlet { private static final long serialVersionUID = 1L; private static final String BOOKLIST_PATH = "bookManage/bookList.jsp";// 图书列表页面地址 private static final String BOOKADD_PATH = "bookManage/bookAdd.jsp";// 图书增加页面地址 private static final String BOOKEDIT_PATH = "bookManage/bookEdit.jsp";// 图书修改页面地址 private static final String BOOKDETAIL_PATH = "bookManage/bookDetail.jsp";// 图书详情页面地址 private static final String BOOKIMGDIR_PATH="images/book/bookimg/";//图书图片保存文件夹相对路径 /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse * response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse * response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String action = request.getParameter("action"); switch (action) { case "list": bookList(request, response); break; case "detail": bookDetail(request, response); break; case "addReq": bookAddReq(request, response); break; case "add": bookAdd(request, response); break; case "edit": bookEdit(request, response); break; case "update": bookUpdate(request,response); break; case "find": bookFind(request, response); break; case "updateImg": updateImg(request,response); break; case "del": bookDel(request,response); break; case "batDel": bookBatDel(request,response); break; case "seach": seachBook(request,response); } } private void seachBook(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { int curPage = 1; String page = request.getParameter("page"); if (page != null) { curPage = Integer.parseInt(page); } int maxSize = Integer.parseInt(request.getServletContext().getInitParameter("maxPageSize")); String bookname = request.getParameter("bookname"); BookDao bd = new BookDaoImpl(); PageBean pb = null; if(bookname != null && bookname != "") { pb = new PageBean(curPage, maxSize, bd.bookReadCount(bookname)); request.setAttribute("bookList", bd.bookList(pb,bookname)); }else { pb = new PageBean(curPage, maxSize, bd.bookReadCount()); request.setAttribute("bookList", bd.bookList(pb)); } request.setAttribute("pageBean", pb); request.getRequestDispatcher(BOOKLIST_PATH).forward(request, response); } //图书批量删除 private void bookBatDel(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String ids=request.getParameter("ids"); BookDao bd=new BookDaoImpl(); UpLoadImgDao uid=new UpLoadImgDaoImpl(); File contextPath=new File(request.getServletContext().getRealPath("/")); String imgIds=bd.findimgIdByIds(ids);//批量查询图片的id并组成一组字符串 List<UpLoadImg> list = uid.findImgByIds(imgIds); if(bd.bookBatDelById(ids)) { request.setAttribute("bookMessage", "图书已批量删除"); if(uid.imgBatDelById(imgIds)) { for(UpLoadImg uli:list) { //批量删除本地文件 File f=new File(contextPath,uli.getImgSrc()); if(f.exists()) { f.delete(); } } } }else { request.setAttribute("bookMessage", "图书批量删除失败"); } //用户删除成功失败都跳转到用户列表页面 bookList(request, response);//通过servlet中listUser跳到用户列表 } //图书删除 private void bookDel(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { int id=Integer.parseInt(request.getParameter("id")); File contextPath=new File(request.getServletContext().getRealPath("/")); BookDao bd=new BookDaoImpl(); UpLoadImgDao uid=new UpLoadImgDaoImpl(); Book book=bd.findBookById(id); //这里先删除数据库图书信息，再删除图书图片及本地硬盘图片信息 if(bd.bookDelById(id)) { request.setAttribute("bookMessage", "图书已删除"); if(uid.imgDelById(book.getImgId())) { //删除本地文件 File f=new File(contextPath,book.getUpLoadImg().getImgSrc()); if(f.exists()) { f.delete(); } } }else { request.setAttribute("bookMessage", "图书删除失败"); } //用户删除成功失败都跳转到用户列表页面 bookList(request, response);//通过servlet中listUser跳到用户列表 } //图书更新 private void bookUpdate(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { BookDao bookDao=new BookDaoImpl(); Book book=new Book(); book.setBookId(Integer.parseInt(request.getParameter("bookId"))); book.setCatalogId(Integer.parseInt(request.getParameter("catalog"))); book.setAuthor(request.getParameter("author")); book.setPress(request.getParameter("press")); book.setPrice(Double.parseDouble(request.getParameter("price"))); book.setDescription(request.getParameter("description")); if(bookDao.bookUpdate(book)) { request.setAttribute("bookMessage", "修改成功"); bookList(request, response); }else { request.setAttribute("bookMessage", "图片失败"); request.setAttribute("bookInfo", bookDao.findBookById(book.getBookId())); request.getRequestDispatcher(BOOKEDIT_PATH).forward(request, response); } } // 更新图书图片 private void updateImg(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { int bookId = Integer.parseInt(request.getParameter("id")); boolean flag = false; String imgSrc = null; OutputStream outputStream = null; InputStream inputStream = null; String imgName = null; String contentType = null; BookDao bookDao = new BookDaoImpl(); UpLoadImgDao upImgDao = new UpLoadImgDaoImpl(); File contextPath=new File(request.getServletContext().getRealPath("/")); File dirPath = new File( contextPath,BOOKIMGDIR_PATH); if (!dirPath.exists()) { dirPath.mkdirs(); } DiskFileItemFactory dfif = new DiskFileItemFactory(); ServletFileUpload servletFileUpload = new ServletFileUpload(dfif); List<FileItem> parseRequest = null; try { parseRequest = servletFileUpload.parseRequest(request); } catch (FileUploadException e) { e.printStackTrace(); } Iterator<FileItem> iterator = parseRequest.iterator(); while (iterator.hasNext()) { FileItem fileItem =