java新闻管理系统 +sql （2018完整）

package com.ivfox.goods.user.controller; import java.awt.Image; import java.io.File; import java.io.IOException; import java.io.UnsupportedEncodingException; import java.util.List; import java.util.Map; import java.util.UUID; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.swing.ImageIcon; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.multipart.MultipartFile; import cn.itcast.commons.CommonUtils; import com.ivfox.goods.user.entity.Book; import com.ivfox.goods.user.entity.Category; import com.ivfox.goods.user.pager.Page; import com.ivfox.goods.user.service.BookService; import com.ivfox.goods.user.service.CategoryService; @Controller public class AdminBookController{ @Autowired private BookService bookService; @Autowired private CategoryService categoryService; @RequestMapping("adminBookManage") public String adminBookManage(HttpServletRequest request,HttpServletResponse response){ return "adminjsps/admin/book/main"; } @RequestMapping("adminfindCategoryAll") public String findCategoryAll(HttpServletRequest request,HttpServletResponse response){ List categoryList = categoryService.findCategoryList(); System.out.println(categoryList.toString()); request.setAttribute("categoryList", categoryList); return "adminjsps/admin/book/left"; } /** * ��ȡ����ҳ * @param request * @return */ public int getPageNow(HttpServletRequest request){ int pageNow =1; String parma=request.getParameter("pageNow"); if(parma!=null&& !parma.isEmpty()){ try { pageNow=Integer.parseInt(parma); } catch (RuntimeException e) { } } return pageNow; } /** * ��ȡ�����url * @param request * @return * @throws UnsupportedEncodingException */ public String getUrl(HttpServletRequest request) throws UnsupportedEncodingException { String url=request.getRequestURI()+"?"+request.getQueryString(); int index = url.lastIndexOf("&pageNow="); if(index!=-1){ url=url.substring(0,index); } return url; } /** * �������ѯ * @param request * @param response * @param map * @return * @throws UnsupportedEncodingException */ @RequestMapping("adminfindBookListByCagegory") public String findBookListByCagegory(HttpServletRequest request,HttpServletResponse response,Map map) throws UnsupportedEncodingException{ //��ȡ����ҳ Page page =new Page(); int pageNow=getPageNow(request); String cid=request.getParameter("cid"); String url=getUrl(request); Book book= new Book(); book.setCid(cid); page.setPageNow(pageNow); page.setPageSize(10); page.setStart((pageNow-1) * page.getPageSize()); page.setUrl(url); Page pages = bookService.findBookListByCondition(book,page); request.setAttribute("page", pages); return "adminjsps/admin/book/list"; } /** * �����߲�ѯ * @param request * @param response * @param map * @return * @throws UnsupportedEncodingException */ @RequestMapping("adminfindBookListByAuthor") public String findBookListByAuthor(HttpServletRequest request,HttpServletResponse response,Map map) throws UnsupportedEncodingException{ //��ȡ����ҳ Page page =new Page(); int pageNow=getPageNow(request); String author=request.getParameter("author"); author=new String(author.getBytes("iso-8859-1"),"utf-8"); String url=getUrl(request); Book book= new Book(); book.setAuthor(author); page.setPageNow(pageNow); page.setPageSize(10); page.setStart((pageNow-1) * page.getPageSize()); page.setUrl(url); Page pages = bookService.findBookListByCondition(book,page); request.setAttribute("page", pages); return "adminjsps/admin/book/list"; } /** * ���������ѯ * @param request * @param response * @param map * @return * @throws UnsupportedEncodingException */ @RequestMapping("adminfindBookListByPress") public String findBookListByPress(HttpServletRequest request,HttpServletResponse response) throws UnsupportedEncodingException{ //��ȡ����ҳ Page page =new Page(); int pageNow=getPageNow(request); String press=request.getParameter("press"); press=new String(press.getBytes("iso-8859-1"),"utf-8"); String url=getUrl(request); Book book= new Book(); book.setPress(press); page.setPageNow(pageNow); page.setPageSize(10); page.setStart((pageNow-1) * page.getPageSize()); page.setUrl(url); Page pages = bookService.findBookListByCondition(book,page); request.setAttribute("page", pages); return "adminjsps/admin/book/list"; } /** * �������ѯ * @param request * @param response * @param map * @return * @throws UnsupportedEncodingException */ @RequestMapping("adminfindBookListByBookName") public String findBookListByBookName(HttpServletRequest request,HttpServletResponse response,Map map) throws UnsupportedEncodingException{ //��ȡ����ҳ Page page =new Page(); int pageNow=getPageNow(request); String bname=request.getParameter("bname"); bname=new String(bname.getBytes("iso-8859-1"),"utf-8"); String url=getUrl(request); Book book= new Book(); book.setBname(bname); page.setPageNow(pageNow); page.setPageSize(10); page.setStart((pageNow-1) * page.getPageSize()); page.setUrl(url); Page pages = bookService.findBookListByCondition(book,page); request.setAttribute("page", pages); return "adminjsps/admin/book/list"; } @RequestMapping("adminbookDetail") public String bookDetail(HttpServletRequest request,HttpServletResponse response,Map map){ String bid=request.getParameter("bid"); Book book = bookService.bookDetail(bid); map.put("book", book); List categoryList = categoryService.findCategoryList(); map.put("categoryList", categoryList); String cid=book.getCid(); String pid=categoryService.getPidByCid(cid); List<Category> childCategory = categoryService.findChildCategory(pid); map.put("pid", pid); map.put("childCategory", childCategory); return "adminjsps/admin/book/desc"; } @RequestMapping("admin/findCategoryList") public String findCategoryList(HttpServletRequest request,HttpServletResponse response){ List categoryList = categoryService.findCategoryList(); System.out.println(categoryList.toString()); request.setAttribute("categoryList", categoryList); return "adminjsps/admin/book/left"; } @RequestMapping("adminEditOrDelBook") public String editBook(HttpServletRequest request,HttpServletResponse response){ String method=request.getParameter("method"); String bid=request.getParameter("bid"); if(method.equals("del")){ try { bookService.delBookByBid(bid); request.setAttribute("code", "success"); request.setAttribute("msg", "删除图书成功"); } catch (Exception e) { request.setAttribute("code", "error"); request.setAttribute("msg", "删除图书失败"); e.printStackTrace(); } }else if(method.equals("edit")){ try { Book book=new Book(); String bname=request.getParameter("bname"); String currPrice=request.getParameter("currPrice"); String price =request.getParameter("price"); String discount=request.getParameter("discount"); String author=request.getParameter("author"); String press=request.getParameter("press"); String publishtime=request.getParameter("publishtime"); String edition=r