devbox
花生_TL007
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Java项目：SSM电子书网站管理系统_电子书后台管理

作者：花生_TL007 | 2024-03-09 01:21:46

赞

踩

电子书后台管理

作者主页：夜未央5788

 简介：Java领域优质创作者、Java项目、学习资料、技术互助

文末获取源码

项目介绍

本项目包含管理员、用户两种角色；

管理员角色包含以下功能：

登录页面,管理员管理书籍,用户管理等功能。

用户角色包含以下功能：

首页,用户登录页面,电子书查看页面,下载电子书,查看分类,用户上传图书,查看个人中心,添加反馈,查看反馈等功能。

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 

5.数据库：MySql 5.7版本；

6.是否Maven项目：是；

技术栈

1. 后端：Spring+SpringMVC+Mybatis

2. 前端：JSP+CSS+JavaScript

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
3. 将项目中config.properties配置文件中的数据库配置改为自己的配置;

4. 运行项目，在浏览器中输入http://localhost:8080/ssm_ebooknet 登录

运行截图

相关代码

图书控制器

  1. package com.lianshuwang.controller;
  2.  
  3. import com.lianshuwang.domin.Book;
  4. import com.lianshuwang.domin.BookType;
  5. import com.lianshuwang.domin.Upload;
  6. import com.lianshuwang.domin.User;
  7. import com.lianshuwang.helper.PageHelper;
  8. import com.lianshuwang.service.BookService;
  9. import com.lianshuwang.service.UserService;
  10. import org.apache.commons.logging.Log;
  11. import org.apache.commons.logging.LogFactory;
  12. import org.springframework.beans.factory.annotation.Autowired;
  13. import org.springframework.stereotype.Controller;
  14. import org.springframework.ui.Model;
  15. import org.springframework.web.bind.annotation.RequestMapping;
  16. import org.springframework.web.bind.annotation.RequestParam;
  17.  
  18. import javax.servlet.http.HttpServletResponse;
  19. import javax.servlet.http.HttpSession;
  20. import java.io.*;
  21. import java.text.ParseException;
  22. import java.text.SimpleDateFormat;
  23. import java.util.Date;
  24. import java.util.List;
  25.  
  26. /**
  27.  * Created by admin on 2019/10/15.
  28.  */
  29. @Controller
  30. public class BookController {
  31.  
  32.     @Autowired
  33.     private BookService bookService;
  34.     @Autowired
  35.     private UserService userService;
  36.  
  37.     private static final Log logger = LogFactory.getLog(BookController.class);
  38.  
  39.     @RequestMapping(value = "/bookList")
  40.     public String getBookList(String bookType, String smallType, @RequestParam(value = "pageId",defaultValue = "1") int pageId, Model model) {
  41.         logger.info("you are visiting the books list page!");
  42.         List<BookType> smallTypes;
  43.         smallTypes = bookService.getSmallTypesOfBook(bookType);
  44.         model.addAttribute("smallTypesOfBook", smallTypes);
  45.         model.addAttribute("bookType",bookType);
  46.         PageHelper page = new PageHelper();
  47.         page.setCurrentPage(pageId);
  48.         if (null == smallType) {
  49.             int sumOfBooks = bookService.getTotalOfLTBooks(smallTypes);
  50.             page.setTotalRows(sumOfBooks);
  51.             List<Book> books = bookService.getLargeTypeBooks(smallTypes,page);
  52.             model.addAttribute("currentPage",pageId);
  53.             model.addAttribute("totalPage",page.getTotalPage());
  54.             model.addAttribute("books",books);
  55.         } else {
  56.             int type_id = 0;
  57.             for (BookType sBookType : smallTypes) {
  58.                 if (sBookType.getSmall_type_name().equals(smallType)) {
  59.                     type_id = sBookType.getId();
  60.                     break;
  61.                 }
  62.             }
  63.             int sumOfBooks = bookService.getTotalOfSTBooks(type_id);
  64.             page.setTotalRows(sumOfBooks);
  65.             List<Book> books = bookService.getSmallTypeBooks(type_id,page);
  66.             model.addAttribute("currentPage",pageId);
  67.             model.addAttribute("totalPage",page.getTotalPage());
  68.             model.addAttribute("books",books);
  69.             model.addAttribute("smallType",smallType);
  70.         }
  71.         return "bookList";
  72.     }
  73.  
  74.     @RequestMapping(value = "/bookDetail")
  75.     public String bookDetail(long bookID, Model model) {
  76.         Book book;
  77.         book = bookService.getBookDetail(bookID);
  78.         Upload upload;
  79.         upload = bookService.getUploadInfo(bookID);
  80.         Date uploadedDate = upload.getUploadedDate();
  81.         SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
  82.         String uploadDate = dateFormat.format(uploadedDate);
  83.         User user;
  84.         user = userService.queryById(upload.getUploader());
  85.         model.addAttribute("book",book);
  86.         model.addAttribute("uploadedDate",uploadDate);
  87.         model.addAttribute("uploader",user.getUserName());
  88.         model.addAttribute("format",book.getBook_format().toUpperCase());
  89.         logger.info("you are looking up the book:" + book.getBook_title());
  90.         return "bookDetail";
  91.     }
  92.  
  93.     @RequestMapping(value = "/getBookCover")
  94.     public void getBookCover(String coverPath, HttpServletResponse response, HttpSession session) {
  95.         String basePath = session.getServletContext().getRealPath("/") + "ebooks/" + coverPath;
  96.  
  97.         InputStream in = null;
  98.         BufferedInputStream bis = null;
  99.         OutputStream out = null;
  100.         BufferedOutputStream bos = null;
  101.         File file = new File(basePath);
  102.         if (!file.exists() || file.isDirectory()) {
  103.             return;
  104.         }
  105.         try {
  106.             in = new FileInputStream(basePath);
  107.             bis = new BufferedInputStream(in);
  108.             byte[] data = new byte[1024];
  109.             int bytes = 0;
  110.             out = response.getOutputStream();
  111.             bos = new BufferedOutputStream(out);
  112.             while ((bytes = bis.read(data, 0, data.length)) != -1) {
  113.                 bos.write(data, 0, bytes);
  114.             }
  115.             bos.flush();
  116.         } catch (IOException e) {
  117.             e.printStackTrace();
  118.         } finally {
  119.             try {
  120.                 if (bos != null) {
  121.                     bos.close();
  122.                 }
  123.                 if (out != null) {
  124.                     out.close();
  125.                 }
  126.                 if (bis != null) {
  127.                     bis.close();
  128.                 }
  129.                 if (in != null) {
  130.                     in.close();
  131.                 }
  132.             } catch (IOException e) {
  133.                 e.printStackTrace();
  134.             }
  135.         }
  136.     }
  137.  
  138.     @RequestMapping(value = "/book_download")
  139.     public void getBookDownload(long bookID, String filePath, HttpServletResponse response) {
  140.         response.setContentType("text/html;charset=utf-8");
  141.         String fileName = filePath.substring(filePath.lastIndexOf("/") + 1);
  142.         BufferedInputStream bis = null;
  143.         BufferedOutputStream bos = null;
  144.         try {
  145.             long fileLength = new File(filePath).length();
  146.             response.setContentType("application/x-msdownload");
  147.             response.setHeader("Content-disposition", "attachment; filename="
  148.                     + new String(fileName.getBytes("utf-8"), "ISO8859-1"));
  149.             response.setHeader("Content-Length", String.valueOf(fileLength));
  150.             bis =new BufferedInputStream(new FileInputStream(filePath));
  151.             bos = new BufferedOutputStream(response.getOutputStream());
  152.             byte[] buff = new byte[2018];
  153.             int bytesRead;
  154.             while (-1  != (bytesRead = bis.read(buff, 0, buff.length))) {
  155.                 bos.write(buff, 0, bytesRead);
  156.             }
  157.         } catch (IOException e) {
  158.             e.printStackTrace();
  159.         } finally {
  160.             try {
  161.                 if (bis != null) {
  162.                     bis.close();
  163.                 }
  164.                 if (bos != null) {
  165.                     bos.close();
  166.                 }
  167.             } catch (IOException e) {
  168.                 e.printStackTrace();
  169.             }
  170.             bookService.addDownloadTimes(bookID);
  171.             logger.info("you are downloading the book, the book file is " + fileName);
  172.         }
  173.     }
  174.  
  175.     @RequestMapping(value = "/bookSearch")
  176.     public String bookSearch(String searchBy, String searchTxt, Model model) throws ParseException {
  177.         logger.info("you are searching book!");
  178.         logger.info("The search context is " + searchTxt);
  179.         List<Book> books = bookService.searchBook(searchBy, searchTxt);
  180.         model.addAttribute("books", books);
  181.         model.addAttribute("searchTxt",searchTxt);
  182.         return "searchResult";
  183.     }
  184.  
  185. }

登录控制器

  1. package com.lianshuwang.controller;
  2.  
  3. import com.lianshuwang.domin.User;
  4. import com.lianshuwang.helper.UserHelper;
  5. import com.lianshuwang.service.UserService;
  6. import org.apache.commons.logging.Log;
  7. import org.apache.commons.logging.LogFactory;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.stereotype.Controller;
  10. import org.springframework.web.bind.annotation.RequestBody;
  11. import org.springframework.web.bind.annotation.RequestMapping;
  12. import org.springframework.web.bind.annotation.RequestMethod;
  13. import org.springframework.web.bind.annotation.ResponseBody;
  14.  
  15. import javax.servlet.http.Cookie;
  16. import javax.servlet.http.HttpServletRequest;
  17. import javax.servlet.http.HttpServletResponse;
  18. import javax.servlet.http.HttpSession;
  19. import java.util.HashMap;
  20. import java.util.Map;
  21.  
  22. /**
  23.  * Created by admin on 2019/10/13.
  24.  */
  25. @Controller
  26. public class LoginController {
  27.  
  28.     @Autowired
  29.     private UserService userService;
  30.  
  31.     private static final Log logger = LogFactory.getLog(LoginController.class);
  32.  
  33.     @RequestMapping(value = "/login", method = RequestMethod.POST)
  34.     @ResponseBody
  35.     public Map<String, Object> index(@RequestBody User user, HttpSession session) {
  36.         logger.info("you are logging in!");
  37.         String userCode = user.getUserCode();
  38.         String password = user.getUserPassword();
  39.         UserHelper userHelper = userService.getLoginUser(userCode,password);
  40.         Map<String, Object> resultMap = new HashMap<String, Object>();
  41.         if (null != userHelper) {
  42.             session.setAttribute("userHelper",userHelper);
  43.             resultMap.put("isLogined", true);
  44.             resultMap.put("user", userHelper);
  45.         } else {
  46.             resultMap.put("isLogined", false);
  47.         }
  48.         return resultMap;
  49.     }
  50.  
  51.     @RequestMapping(value = "/logout")
  52.     public String logout(HttpSession session,HttpServletRequest request,HttpServletResponse response) {
  53.         logger.info("you have logged out!");
  54.         session.invalidate();
  55.         Cookie[] cookies = request.getCookies();  
  56.         try  
  57.         {  
  58.              for(int i=0;i<cookies.length;i++)    
  59.              {  
  60.               //System.out.println(cookies[i].getName() + ":" + cookies[i].getValue());  
  61.               Cookie cookie = new Cookie(cookies[i].getName(), null);  
  62.               cookie.setMaxAge(0);  
  63.               cookie.setPath("/");//根据你创建cookie的路径进行填写      
  64.               response.addCookie(cookie);  
  65.              }  
  66.         }catch(Exception ex)  
  67.         {  
  68.              System.out.println("清空Cookies发生异常！");  
  69.         }   
  70.         return "redirect:/";
  71.     }
  72.  
  73. }

主控制器

  1. package com.lianshuwang.controller;
  2.  
  3. import com.lianshuwang.domin.Gonggao;
  4. import com.lianshuwang.helper.RankingBook;
  5. import com.lianshuwang.service.BookService;
  6. import com.lianshuwang.service.GonggaoService;
  7. import com.lianshuwang.util.PropertyConfigurer;
  8. import org.apache.commons.logging.Log;
  9. import org.apache.commons.logging.LogFactory;
  10. import org.springframework.beans.factory.annotation.Autowired;
  11. import org.springframework.stereotype.Controller;
  12. import org.springframework.ui.Model;
  13. import org.springframework.web.bind.annotation.RequestMapping;
  14.  
  15. import java.text.SimpleDateFormat;
  16. import java.util.List;
  17.  
  18. @Controller
  19. public class MainController {
  20.  
  21.     private static final Log logger = LogFactory.getLog(MainController.class);
  22.  
  23.     @Autowired
  24.     private BookService bookService;
  25.     @Autowired
  26.     GonggaoService gonggaoService;
  27.     @RequestMapping(value = "/index")
  28.     public String index(Model model) {
  29.         logger.info("Welcome to gatheringbook.cn!");
  30.         String name = (String)PropertyConfigurer.getProperty("book_path");
  31.         System.out.println("hello, " + name);
  32.         int sumOfBooks = bookService.queryNumberOfBooks();
  33.         model.addAttribute("sumOfBooks", sumOfBooks);
  34.         List<Integer> everyTypeBooks;
  35.         everyTypeBooks = bookService.queryNumberOfSomeTypeBooks();
  36.         model.addAttribute("sumOfTypeBooks",everyTypeBooks);
  37.         String maxUploadDate = bookService.getMaxUploadDate();
  38.         model.addAttribute("maxUploadDate", maxUploadDate);
  39.         List<RankingBook> rankingBooks;
  40.         rankingBooks = bookService.queryByUploadedDate();
  41.         model.addAttribute("rankingBooks",rankingBooks);
  42.         List<RankingBook> rankingBooks1;
  43.         rankingBooks1 = bookService.queryByDownloadTimes();
  44.         model.addAttribute("rankingBooks1",rankingBooks1);
  45.         
  46.         List<Gonggao> gonggaos;
  47.         gonggaos = gonggaoService.getLists();
  48.         for(Gonggao gonggao:gonggaos) {
  49. 			if(gonggao.getContent()!=null&&gonggao.getContent().length()>10) {
  50. 				gonggao.setContent(gonggao.getContent().substring(0,10)+"...");
  51. 				SimpleDateFormat dateFm = new SimpleDateFormat("yyyy-MM-dd"); //格式化当前系统日期
  52. 				String dateTime = dateFm.format(gonggao.getShijian());
  53. 				gonggao.setTime(dateTime);
  54. 			}
  55. 		}
  56.         model.addAttribute("gonggaos",gonggaos);
  57.         return "main";
  58.     }
  59. }

用户控制器

  1. package com.lianshuwang.controller;
  2.  
  3. import com.lianshuwang.domin.User;
  4. import com.lianshuwang.helper.UploadHelper;
  5. import com.lianshuwang.helper.UserHelper;
  6. import com.lianshuwang.service.UserService;
  7. import org.apache.commons.logging.Log;
  8. import org.apache.commons.logging.LogFactory;
  9. import org.springframework.beans.factory.annotation.Autowired;
  10. import org.springframework.stereotype.Controller;
  11. import org.springframework.ui.Model;
  12. import org.springframework.web.bind.annotation.RequestMapping;
  13. import org.springframework.web.bind.annotation.ResponseBody;
  14.  
  15. import javax.servlet.http.HttpSession;
  16. import java.util.HashMap;
  17. import java.util.List;
  18. import java.util.Map;
  19.  
  20. /**
  21.  * Created by admin on 2019/10/15.
  22.  */
  23. @Controller
  24. public class UserController {
  25.     @Autowired
  26.     private UserService userService;
  27.  
  28.     private static final Log logger = LogFactory.getLog(UserController.class);
  29.  
  30.     @RequestMapping(value = "/person")
  31.     public String getPerosonInfo(Model model, HttpSession session) {
  32.         UserHelper userHelper = (UserHelper) session.getAttribute("userHelper");
  33.         if (null == userHelper) {
  34.             return "redirect:index";
  35.         }
  36.         model.addAttribute("user", userHelper);
  37.         logger.info("The user(" + userHelper.getUserName() + ") is coming to person information page!");
  38.         return "personInfo";
  39.     }
  40.  
  41.     @RequestMapping(value = "/infoModify")
  42.     public String infoModify(String name, String email, String avatarImg, HttpSession session) {
  43.         logger.info("The user is modifying his information!");
  44.         UserHelper userHelper = (UserHelper) session.getAttribute("userHelper");
  45.         User user = new User();
  46.         user.setId(userHelper.getId());
  47.         user.setUserName(name);
  48.         user.setEmail(email);
  49.         int avatarId = userService.getAvatarId(avatarImg);
  50.         user.setAvatarNum(avatarId);
  51.         userService.updateUserInfo(user);
  52.         User user1;
  53.         user1 = userService.queryById(userHelper.getId());
  54.         UserHelper newUserHelper;
  55.         newUserHelper = userService.getLoginUser(user1.getUserCode(),user1.getUserPassword());
  56.         session.setAttribute("userHelper",newUserHelper);
  57.         return "redirect:/person";
  58.     }
  59.  
  60.     @RequestMapping(value = "/pwdModify")
  61.     public String pwdModify(String newPwd, HttpSession session) {
  62.         logger.info("The user is modifying his password!");
  63.         UserHelper userHelper = (UserHelper) session.getAttribute("userHelper");
  64.         userService.updateUserPassword(userHelper.getId(), newPwd);
  65.         session.invalidate();
  66.         return "redirect:/index";
  67.     }
  68.  
  69.     @RequestMapping(value = "/getUploadHistory")
  70.     @ResponseBody
  71.     public Map<String,Object> getUploadHistory(HttpSession session) {
  72.         Map<String,Object> resultMap = new HashMap<String,Object>();
  73.         UserHelper userHelper = (UserHelper) session.getAttribute("userHelper");
  74.         List<UploadHelper> uploadHelperList = userService.getUploadedBook(userHelper.getId());
  75.         resultMap.put("uploadList", uploadHelperList);
  76.         logger.info("you are looking up the uploaded books");
  77.         return resultMap;
  78.     }
  79.  
  80.     @RequestMapping(value = "/feedback")
  81.     @ResponseBody
  82.     public void feedback(String contact, String suggestion,HttpSession session) {
  83.         UserHelper userHelper = (UserHelper) session.getAttribute("userHelper");
  84.         userService.addFeedback(userHelper.getId(),contact,suggestion);
  85.         logger.info("you are posting the suggestion!");
  86.         logger.info("contact:" + contact);
  87.         logger.info("suggestion:" + suggestion);
  88.     }
  89. }

BackStageService

  1. package com.lianshuwang.service;
  2.  
  3. import com.lianshuwang.dao.BookDao;
  4. import com.lianshuwang.dao.FeedbackDao;
  5. import com.lianshuwang.dao.UploadDao;
  6. import com.lianshuwang.dao.UserDao;
  7. import com.lianshuwang.domin.Book;
  8. import com.lianshuwang.domin.Feedback;
  9. import com.lianshuwang.domin.Upload;
  10. import com.lianshuwang.domin.User;
  11. import com.lianshuwang.helper.doBookHelper;
  12. import com.lianshuwang.util.PropertyConfigurer;
  13. import org.springframework.beans.factory.annotation.Autowired;
  14. import org.springframework.stereotype.Service;
  15.  
  16. import java.io.File;
  17. import java.util.ArrayList;
  18. import java.util.HashMap;
  19. import java.util.List;
  20. import java.util.Map;
  21.  
  22. import javax.servlet.http.HttpSession;
  23.  
  24. @Service
  25. public class BackStageService {
  26.     @Autowired
  27.     private UploadDao uploadDao;
  28.     @Autowired
  29.     private BookDao bookDao;
  30.     @Autowired
  31.     private UserDao userDao;
  32.     @Autowired
  33.     private FeedbackDao feedbackDao;
  34.  
  35.     public boolean getLogin(String username, String password, HttpSession session) {
  36.     	User user = userDao.queryByLogin(username,password);
  37.     	if(user == null) {
  38.     		return false;
  39.     	}else if(user.getRole() == 0){
  40.     		return false;
  41.     	}
  42.     	else if(user.getRole() == 1||user.getRole() == 2){
  43.     		session.setAttribute("role", user.getRole());
  44.     		session.setAttribute("id", user.getId());
  45.     		return true;
  46.     	}else {
  47.     		return false;
  48. 		}
  49.  
  50.     }
  51.  
  52.     public List<doBookHelper> iteratorUploadList(List<Upload> uploadList) {
  53.         List<doBookHelper> doBookHelperList = new ArrayList<doBookHelper>();
  54.         Book book;
  55.         for (Upload upload : uploadList) {
  56.             doBookHelper bookHelper = new doBookHelper();
  57.             book = bookDao.queryById(upload.getUploadedBook());
  58.             bookHelper.setId(book.getId());
  59.             bookHelper.setTitle(book.getBook_title());
  60.             bookHelper.setAuthor(book.getBook_author());
  61.             bookHelper.setUploader(upload.getUploader());
  62.             bookHelper.setUploadedDate(upload.getUploadedDate());
  63.             doBookHelperList.add(bookHelper);
  64.         }
  65.         return doBookHelperList;
  66.     }
  67.  
  68.     public List<doBookHelper> getUploadBooks() {
  69.         List<doBookHelper> doBookHelperList;
  70.         List<Upload> uploadList = uploadDao.queryByUploadedDate();
  71.         doBookHelperList = iteratorUploadList(uploadList);
  72.         return doBookHelperList;
  73.     }
  74.  
  75.     public List<doBookHelper> getBooksByDays(int days) {
  76.         List<doBookHelper> doBookHelperList;
  77.         List<Upload> uploadList;
  78.         if (days == 30) {
  79.             uploadList = uploadDao.searchByThirtyDays();
  80.         } else if (days == 7) {
  81.             uploadList = uploadDao.searchBySevenDays();
  82.         } else {
  83.             uploadList = uploadDao.searchByToday();
  84.         }
  85.         doBookHelperList = iteratorUploadList(uploadList);
  86.         return doBookHelperList;
  87.     }
  88.  
  89.     public List<doBookHelper> getBooksByTitle(String title) {
  90.         List<doBookHelper> doBookHelperList = new ArrayList<doBookHelper>();
  91.         List<Book> bookList = bookDao.searchBookByTitle(title);
  92.         for (Book book: bookList) {
  93.             doBookHelper bookHelper = new doBookHelper();
  94.             bookHelper.setId(book.getId());
  95.             bookHelper.setTitle(book.getBook_title());
  96.             bookHelper.setAuthor(book.getBook_author());
  97.             Upload upload = uploadDao.queryByBookId(book.getId());
  98.             bookHelper.setUploader(upload.getUploader());
  99.             bookHelper.setUploadedDate(upload.getUploadedDate());
  100.             doBookHelperList.add(bookHelper);
  101.         }
  102.         return doBookHelperList;
  103.     }
  104.  
  105.     public List<doBookHelper> getBooksByUserId(long userId) {
  106.         List<doBookHelper> doBookHelperList = new ArrayList<doBookHelper>();
  107.         List<Upload> uploadList = uploadDao.queryByUserId(userId);
  108.         Book book;
  109.         for (Upload upload : uploadList) {
  110.             book = bookDao.queryById(upload.getUploadedBook());
  111.             doBookHelper bookHelper = new doBookHelper();
  112.             bookHelper.setId(book.getId());
  113.             bookHelper.setTitle(book.getBook_title());
  114.             bookHelper.setAuthor(book.getBook_author());
  115.             bookHelper.setUploader(upload.getUploader());
  116.             bookHelper.setUploadedDate(upload.getUploadedDate());
  117.             doBookHelperList.add(bookHelper);
  118.         }
  119.         return doBookHelperList;
  120.     }
  121.  
  122.     public int deleteBook(long bookId) {
  123.         Book book;
  124.         book = bookDao.queryById(bookId);
  125.         String bookFilePath = book.getBook_file();
  126.         File file = new File(bookFilePath);
  127.         if (file.exists()) {
  128.             file.delete();
  129.         }
  130. //        else {
  131. //            return 0;
  132. //        }
  133.         String bookCoverPath = book.getBook_cover();
  134.         File cover = new File(bookCoverPath);
  135.         if (cover.exists()) {
  136.             cover.delete();
  137.         }
  138. //        else {
  139. //            return 0;
  140. //        }
  141.         int count = bookDao.deleteBook(bookId);
  142.         int count2 = uploadDao.deleteUploadRow(bookId);
  143.         if (count == 0 || count2 == 0) {
  144.             return 0;
  145.         }
  146.         return 1;
  147.     }
  148.  
  149.     public Map<String,Object> getUserByContribution() {
  150.         Map<String,Object> resultMap = new HashMap<String,Object>();
  151.         List<User> userList = userDao.queryUserByContribution();
  152.         resultMap.put("userList",userList);
  153.         resultMap.put("totalUser",userDao.queryUserNumber());
  154.         resultMap.put("weekUser",userDao.queryUserNumberByWeek());
  155.         resultMap.put("monthUser",userDao.queryUserNumberByMonth());
  156.         return resultMap;
  157.     }
  158.     
  159.     public Map<String,Object> getAdminByRole() {
  160.         Map<String,Object> resultMap = new HashMap<String,Object>();
  161.         List<User> userList = userDao.queryByRole(1);
  162.         if(userList != null) {
  163.         	 userList.addAll(userDao.queryByRole(2));
  164.         }else {
  165.         	 userList = userDao.queryByRole(2);
  166.         }
  167.         resultMap.put("userList",userList);
  168.         resultMap.put("totalUser",userDao.queryAdminNumber());
  169.         resultMap.put("weekUser",userDao.queryAdminNumberByWeek());
  170.         resultMap.put("monthUser",userDao.queryAdminNumberByMonth());
  171.         return resultMap;
  172.     }
  173.     
  174.     public Map<String,Object> getUserByRole() {
  175.         Map<String,Object> resultMap = new HashMap<String,Object>();
  176.         List<User> userList = userDao.queryByRole(0);
  177.         resultMap.put("userList",userList);
  178.         resultMap.put("totalUser",userDao.queryUserNumber());
  179.         resultMap.put("weekUser",userDao.queryUserNumberByWeek());
  180.         resultMap.put("monthUser",userDao.queryUserNumberByMonth());
  181.         return resultMap;
  182.     }
  183.  
  184.     public int deleteUser(long userId) {
  185.         int count = userDao.deleteUser(userId);
  186.         uploadDao.deleteUploadRowByUser(userId);
  187.         if (count == 0) {
  188.             return 0;
  189.         }
  190.         return 1;
  191.     }
  192.  
  193.     public List<User> getUserBySearch(String searchTxt) {
  194.         List<User> userList = new ArrayList<User>();
  195.         if (searchTxt.length() < 5 ) {
  196.             userList = userDao.queryUserByUserName(searchTxt);
  197.         } else if (isNumeric(searchTxt)) {
  198.             long userId = Long.parseLong(searchTxt);
  199.             User user1 = userDao.queryById(userId);
  200.             userList.add(user1);
  201.             List<User> userList1 = userDao.queryUserByUserName(searchTxt);
  202.             userList.addAll(userList1);
  203.         }
  204.         return userList;
  205.     }
  206.  
  207.     public boolean isNumeric(String str) {
  208.         for (int i = str.length();--i>=0;){
  209.             if (!Character.isDigit(str.charAt(i))){
  210.                 return false;
  211.             }
  212.         }
  213.         return true;
  214.     }
  215.  
  216.     public List<Feedback> getFeedback() {
  217.         List<Feedback> feedbackList = feedbackDao.queryAllNotRead();
  218.         return feedbackList;
  219.     }
  220.  
  221.     public int setOneFeedbackRead(int id) {
  222.         int count = feedbackDao.setOneRead(id);
  223.         return count;
  224.     }
  225.  
  226.     public int setAllFeedbackRead() {
  227.         return feedbackDao.setAllRead();
  228.     }
  229. }

如果也想学习本系统，下面领取。关注并回复：129ssm 

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/花生_TL007/article/detail/213219
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号