基于javaweb的JSP+Servlet书籍交换二手交易二手书城系统(java+servlet+jsp+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的JSP+Servlet书籍交换二手交易二手书城系统(java+servlet+jsp+mysql)

管理员：
admin 123456

学生：
stu1 123456
stu2 123456
stu3 123456

功能：1.查阅个人信息
2.商城购买书籍和上架书籍（上架时加上书籍信息（包括书名，完整程度，书籍照片，价格，卖家联系方式）），买家可以查看这些信息
3.书籍交换（通过捐赠书籍获取领取书籍次数，领取书籍是从捐赠的书籍中随机抽取几本）

				User user = (User) request.getSession().getAttribute("flogin");
				if (user.getChanges()>0) {
					int i = (int)(1+Math.random()*(size-1+1));
					System.out.println(i);
					String string = idStrings.get(i-1);//获取到交换的书籍ID
					Book book = bookService.getById(string);
					book.setIsOver("1");
					book.setBuyer(user.getId());
					bookService.update(book);
					writer.println("1");
				}else{
					writer.println("2");
				}
			}
		}
	} catch (Exception e) {
		e.printStackTrace();
		writer.println("0");
	}
}


//form跳转页面
private void detail(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	String id = request.getParameter("id");
	Book book = new Book();
	if (id!=null && id!="") {
		book = bookService.getById(id);
	}
	request.setAttribute("book", book);
	User uploader = userService.getById(book.getUploader());
	request.setAttribute("uploader", uploader);
	request.getRequestDispatcher("/views/front/detail.jsp").forward(request, response);
}

//form跳转页面
private void sell(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	String id = request.getParameter("id");
	Book book = new Book();
	if (id!=null && id!="") {
		book = bookService.getById(id);
	}
	request.setAttribute("book", book);
	request.getRequestDispatcher("/views/front/publish.jsp").forward(request, response);
}

//form跳转页面
private void published(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	Book book = new Book();
	//分页有关
	Page<Book> page = new Page<Book>();

	String bookName = request.getParameter("bookName");
	if (bookName != null && bookName != "") {
		book.setBookName(bookName);
		request.setAttribute("bookName", bookName);
	}
	Object attribute = request.getSession().getAttribute("flogin");
	if (attribute!=null) {
		User user = (User) attribute;
		book.setBuyer(user.getId());
	}
	page = bookService.page(book, page);
	request.setAttribute("page", page);
	request.getRequestDispatcher("/views/front/alerdBuy.jsp").forward(request, response);
}


//添加
private void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	

	String bookName = request.getParameter("bookName");
	String price = request.getParameter("price");
	String author = request.getParameter("author");
	String content = request.getParameter("content");
	String product = request.getParameter("product");
	String productTime = request.getParameter("productTime");
	Book book = new Book();
	book.setBookName(bookName);
	book.setPrice(price);
	book.setAuthor(author);
	book.setContent(content);
	book.setProduct(product);
	bookService.add(book);
	response.sendRedirect(contextPath+"/book?method=list");
}

//添加保存
protected void save(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	Book book = new Book();
	 //得到上传文件的保存目录，将上传的文件存放于WEB-INF目录下，不允许外界直接访问，保证上传文件的安全
       String savePath = this.getServletContext().getRealPath("/upload");
       File file = new File(savePath);
       //判断上传文件的保存目录是否存在
       if (!file.exists() && !file.isDirectory()) {
           System.out.println(savePath+"目录不存在，需要创建");
           //创建目录
           file.mkdir();
       }

	userService.update(user);
	request.setAttribute("user", user);
	request.getRequestDispatcher("/views/system/userForm.jsp").forward(request, response);
}

//列表查询
private void list(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	System.err.println("---开始查询---");
	User user = new User();
	//分页有关
	Page<User> page = new Page<User>();
	//设置查询页
	String pageNoStr = request.getParameter("pageNo");
	if (pageNoStr != null && pageNoStr != "") {
		page.setPageNo(Integer.parseInt(pageNoStr));
	}
	//设置查询条件
	String username = request.getParameter("username");
	if (username != null && username != "") {
		user.setUsername(username);
		request.setAttribute("username", username);
	}
	String name = request.getParameter("name");
	if (name != null && name != "") {
		user.setName(name);
		request.setAttribute("name", name);
	}
	String sex = request.getParameter("sex");
	if (sex != null && sex != "") {
		user.setSex(sex);
		request.setAttribute("sex", sex);
	}
	
	page = userService.page(user, page);
	request.setAttribute("page", page);
	request.getRequestDispatcher("/views/system/userList.jsp").forward(request, response);
}

//form跳转页面
private void form(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	String id = request.getParameter("id");
	User user = new User();
	if (id!=null && id!="") {
		user = userService.getById(id);

//form跳转页面
private void sell(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	String id = request.getParameter("id");
	Book book = new Book();
	if (id!=null && id!="") {
		book = bookService.getById(id);
	}
	request.setAttribute("book", book);
	request.getRequestDispatcher("/views/front/publish.jsp").forward(request, response);
}

//form跳转页面
private void published(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	Book book = new Book();
	//分页有关
	Page<Book> page = new Page<Book>();
	//设置查询页
	String pageNoStr = request.getParameter("pageNo");
	if (pageNoStr != null && pageNoStr != "") {
		page.setPageNo(Integer.parseInt(pageNoStr));
	}
	//设置查询条件
	String bookName = request.getParameter("bookName");
	if (bookName != null && bookName != "") {
		book.setBookName(bookName);
		request.setAttribute("bookName", bookName);
	}
	Object attribute = request.getSession().getAttribute("flogin");
	if (attribute!=null) {
		User user = (User) attribute;
		book.setUploader(user.getId());
	}
	page = bookService.page(book, page);
	request.setAttribute("page", page);
	request.getRequestDispatcher("/views/front/published.jsp").forward(request, response);
}


//form跳转页面
private void alerdBuy(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	Book book = new Book();

                   //判断输入流中的数据是否已经读完的标识
                   int len = 0;
                   //循环将输入流读入到缓冲区当中，(len=in.read(buffer))>0就表示in里面还有数据
                   while((len=in.read(buffer))>0){
                       //使用FileOutputStream输出流将缓冲区的数据写入到指定的目录(savePath + "\\" + filename)当中
                       out.write(buffer, 0, len);
                   }
                   //关闭输入流
                   in.close();
                   //关闭输出流
                   out.close();
                   //删除处理文件上传时生成的临时文件
                   item.delete();
					msg = "文件上传成功！";
                   
                   book.setPic("\\upload" + "\\" + filename);
               }
           }
           if (book.getId()!=null && !"".equals(book.getId())) {
           	Book oldBook = bookService.getById(book.getId());
   			bookService.update(book);
   			if ("1".equals(oldBook.getType())) {
   				if ("2".equals(book.getType())) {
   					User byId = userService.getById(book.getUploader());
   					byId.setChanges(byId.getChanges()+1);
   					userService.update(byId);
   				}
			}
   			if ("2".equals(oldBook.getType())) {
   				if ("1".equals(book.getType())) {
   					User byId = userService.getById(book.getUploader());
   					byId.setChanges(byId.getChanges()-1);
   					userService.update(byId);
   				}
			}
   		}else{
   			book.setIsOver("0");
   			bookService.add(book);
   			if ("2".equals(book.getType())) {
				User byId = userService.getById(book.getUploader());
				byId.setChanges(byId.getChanges()+1);
				userService.update(byId);
			}
   		}
   		response.sendRedirect(contextPath+"/f?method=published");
       }catch (Exception e) {
           msg= "文件上传失败！";
           e.printStackTrace();
           request.setAttribute("msg",msg);
           request.getRequestDispatcher("/views/front/publish.jsp").forward(request, response);
       }
}

	String bookName = request.getParameter("bookName");
	String price = request.getParameter("price");
	String author = request.getParameter("author");
	String content = request.getParameter("content");
	String product = request.getParameter("product");
	String productTime = request.getParameter("productTime");
	Book book = new Book();
	book.setBookName(bookName);
	book.setPrice(price);
	book.setAuthor(author);
	book.setContent(content);
	book.setProduct(product);
	bookService.add(book);
	response.sendRedirect(contextPath+"/book?method=list");
}

//添加保存
protected void save(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	Book book = new Book();
	 //得到上传文件的保存目录，将上传的文件存放于WEB-INF目录下，不允许外界直接访问，保证上传文件的安全
       String savePath = this.getServletContext().getRealPath("/upload");
       File file = new File(savePath);
       //判断上传文件的保存目录是否存在
       if (!file.exists() && !file.isDirectory()) {
           System.out.println(savePath+"目录不存在，需要创建");
           //创建目录
           file.mkdir();
       }
       //消息提示
       String msg = "";
       try{
           //使用Apache文件上传组件处理文件上传步骤：
           //1、创建一个DiskFileItemFactory工厂
           DiskFileItemFactory factory = new DiskFileItemFactory();
           //2、创建一个文件上传解析器
           ServletFileUpload upload = new ServletFileUpload(factory);
            //解决上传文件名的中文乱码
           upload.setHeaderEncoding("UTF-8"); 
           //3、判断提交上来的数据是否是上传表单的数据
           if(!ServletFileUpload.isMultipartContent(request)){
               //按照传统方式获取数据
               return;
           }
           //4、使用ServletFileUpload解析器解析上传数据，解析结果返回的是一个List<FileItem>集合，每一个FileItem对应一个Form表单的输入项
           List<FileItem> list = upload.parseRequest(request);
           for(FileItem item : list){
               //如果fileitem中封装的是普通输入项的数据
               if(item.isFormField()){
                   String name = item.getFieldName();
                    //解决普通输入项的数据的中文乱码问题

---

项目链接：
https://javayms.github.io?id=231423582708201ca
https://javayms.pages.dev?id=231423582708201ca