基于javaweb+mysql的jsp+servlet生鲜商城系统(java+jsp+bootstrap+servlet+mysql)

基于javaweb+mysql的jsp+servlet生鲜商城系统(java+jsp+bootstrap+servlet+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的JSP+Servlet生鲜商城系统(java+jsp+bootstrap+servlet+mysql)

项目介绍

本项目分为前后台，分为管理员与普通用户两种角色，管理员登录后台，普通用户登录前台； 管理员登录包含以下功能： 登录,订单管理操作发货,客户管理,生鲜管理,生鲜类目管理等功能。

用户角色包含以下功能： 用户首页,用户登录,全部分类,查看生鲜,查看购物车,提交订单,查看订单等功能。

环境需要

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项目：否；

技术栈

JSP+CSS+jQuery+bootstrap+mysql+servlet

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中src/utils/DBUtil.java配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入localhost:8080/jsp_shenxian_shop/ 登录 注：tomcat中配置项目路径必须为jsp_shenxian_shop，否则会有异常； 用户账号/密码：user/123456 管理员账号/密码：admin/admin

*/

@GetMapping("/findusernamelist")

public ResultResp finByUserNameAdminList(@RequestParam String userName,

@RequestParam(required = false, defaultValue = "1") int pageIndex,

@RequestParam(required = false, defaultValue = "8") int pageSize){

return userService.findByUserNameList(userName, pageIndex, pageSize);

/**

* 用户列表

* @return

*/

@GetMapping("/adminuserlist")

public ResultResp adminUserList(@RequestParam(required = false, defaultValue = "1") int pageIndex,

@RequestParam(required = false, defaultValue = "8") int pageSize){

return "goods/goodInfo";

@RequestMapping(value = "/goods/goodInfo", method = RequestMethod.POST)

public String putReview(

@RequestParam(value = "goodId", required = false) Integer goodId,

@RequestParam(value = "reviewId", required = false) Integer reviewId,

@RequestParam(value = "fromUserId", required = false) Integer fromUserId,

@RequestParam(value = "toUserId", required = false) Integer toUserId,

@RequestParam(value = "fromUser", required = false) String fromUser,

@RequestParam(value = "toUser", required = false) String toUser,

@RequestParam(value = "replyText", required = false, defaultValue = "") String replyText,

@RequestParam(value = "reviewText", required = false, defaultValue = "") String reviewText) {

if (reviewText.equals("")) {

if (replyText.equals("")) {

* 用户登录

*/

@PostMapping("/login")

public ResultResp login(@RequestBody LoginVo loginVo){

System.out.println(loginVo);

return userService.login(loginVo);

/**

* 根据用户名查找用户

*/

@PostMapping("/userinfo")

* @param userName

* @param bookId

* @param addressId

* @return

*/

@PostMapping("/addorder")

public ResultResp addOrder(@RequestParam String userName,

@RequestParam int bookId,

@RequestParam int addressId){

return orderService.addOrder(bookId,addressId,userName);

/**

model.addAttribute("firstTypes", firstTypes);

return "goods/publishGood";

@RequestMapping(value = "/goods/publishGood/uploadImage", method = RequestMethod.POST)

public String uploadImage(

HttpSession session,

@RequestParam(value = "goodId", required = false) Integer goodId,

@RequestParam(value = "mainFile", required = false) MultipartFile mainFile,

@RequestParam(value = "file", required = false) MultipartFile[] file)

throws IOException {

User user = (User) session.getAttribute("user");

FileCheck fileCheck = new FileCheck();

RandomString randomString = new RandomString();

String filePath = "/statics/image/goods/" + user.getId() + "/" + goodId;

@RequestMapping(value = "/goods/publishGood", method = RequestMethod.GET)

public String getPublishGood(ModelMap model, HttpSession session) {

User user = (User) session.getAttribute("user");

if (user == null) {

return "redirect:/";

Good good = new Good();

List<FirstType> firstTypes = typeService.getAllFirstType();

List<Good> goods = goodService.getAllGoods(0, 5);

model.addAttribute("goods", goods);

model.addAttribute("good", good);

model.addAttribute("firstTypes", firstTypes);

System.out.println(userName);

return userService.isUsernameExist(userName);

/**

* 添加用户

*/

@GetMapping("/adduserName")

public ResultResp adduserName(@RequestParam String userName,

@RequestParam String userPwd ){

return userService.addUser(userName, userPwd);

订单管理控制层：

goodInfo.getId());

model.addAttribute("message", message);

model.addAttribute("reviews", reviews);

model.addAttribute("goodInfo", goodInfo);

model.addAttribute("images", images);

model.addAttribute("goodUser", goodUser);

model.addAttribute("goods", goods);

model.addAttribute("collect", collect);

message = "";

return "goods/goodInfo";

@RequestMapping(value = "/goods/goodInfo", method = RequestMethod.POST)

imageService.deleteImage(goodId);

RandomString randomString = new RandomString();

String filePath = "/statics/image/goods/" + user.getId() + "/" + goodId;

String pathRoot = fileCheck.checkGoodFolderExist(filePath);

String name;

if (!mainFile.isEmpty()) {

String contentType = mainFile.getContentType();

String fileName = goodId + randomString.getRandomString(10);

String imageName = contentType

.substring(contentType.indexOf("/") + 1);

name = fileName + "." + imageName;

mainFile.transferTo(new File(pathRoot + name));

String photoUrl = filePath + "/" + name;

model.addAttribute("goods", goods);

model.addAttribute("good", good);

model.addAttribute("goodImages", goodImages);

model.addAttribute("firstTypes", firstTypes);

return "goods/userGoodEdit";

@RequestMapping(value = "/goods/userGoodEdit", method = RequestMethod.POST)

public String postGoodEdit(ModelMap model, HttpSession session,

@Valid Good good) {

List<FirstType> firstTypes = typeService.getAllFirstType();

User user = (User) session.getAttribute("user");

if (user == null) {

return "redirect:/";

List<Good> goods = goodService.getAllGoods(0, 5);

public ResultResp findNmae(@RequestParam String userName){

System.out.println(userName);

return userService.isUsernameExist(userName);

/**

* 添加用户

*/

@GetMapping("/adduserName")

public ResultResp adduserName(@RequestParam String userName,

@RequestParam String userPwd ){

return userService.addUser(userName, userPwd);

订单管理控制层：

name = fileName + "." + imageName;

System.out.println("name:" + name);

mf.transferTo(new File(pathRoot + name));

Image image = new Image();

image.setGoodId(goodId);

image.setName(name);

image.setUrl(filePath + "/" + name);

imageService.insertImage(image);

} else {

System.out.println("文件为空！");

return "redirect:/goods/goodInfo?goodId=" + goodId;

@RequestMapping(value = "/goods/userGoods", method = RequestMethod.GET)

secondTypeId);

List<FirstType> firstTypes = typeService.getAllFirstType();

for (FirstType firstType : firstTypes) {

firstType.setSecondType(typeService

.getSecondTypeByFirstTypeId(firstType.getId()));

model.addAttribute("firstTypes", firstTypes);

model.addAttribute("goods", goods);

model.addAttribute("pages", Math.ceil(goodsNum / limit));

model.addAttribute("goodsNum", goodsNum);

model.addAttribute("offset", offset);

if (!mf.isEmpty()) {

// 生成uuid作为文件名称

String fileName = goodId + randomString.getRandomString(10);

// 获得文件类型（可以判断如果不是图片，禁止上传）

String contentType = mf.getContentType();

// 获得文件后缀名称

String imageName = contentType.substring(contentType

.indexOf("/") + 1);

name = fileName + "." + imageName;

System.out.println("name:" + name);

mf.transferTo(new File(pathRoot + name));

@PostMapping("/cancelorder")

public ResultResp cancelOrder(@RequestParam int orderId){

return orderService.cancelOrder(orderId);

商品管理控制层：

@Controller

public class GoodController {

private final GoodService goodService;

private final TypeService typeService;

private final ReviewService reviewService;

private final UserService userService;

private final ImageService imageService;

private final CollectService collectService;

.indexOf("/") + 1);

name = fileName + "." + imageName;

System.out.println("name:" + name);

mf.transferTo(new File(pathRoot + name));

Image image = new Image();

image.setGoodId(goodId);

image.setName(name);

image.setUrl(filePath + "/" + name);

imageService.insertImage(image);

return "redirect:/goods/goodInfo?goodId=" + goodId;

@RequestMapping(value = "/goods/userGoodEdit/delete/{goodId}", method = RequestMethod.GET)

public ResponseEntity deleteGood(@PathVariable Integer goodId) {

secondTypeId);

List<FirstType> firstTypes = typeService.getAllFirstType();

for (FirstType firstType : firstTypes) {

firstType.setSecondType(typeService

.getSecondTypeByFirstTypeId(firstType.getId()));

model.addAttribute("firstTypes", firstTypes);

model.addAttribute("goods", goods);

model.addAttribute("pages", Math.ceil(goodsNum / limit));

model.addAttribute("goodsNum", goodsNum);

model.addAttribute("offset", offset);

model.addAttribute("limit", limit);

if (!mf.isEmpty()) {

// 生成uuid作为文件名称

String fileName = goodId + randomString.getRandomString(10);

// 获得文件类型（可以判断如果不是图片，禁止上传）

String contentType = mf.getContentType();

// 获得文件后缀名称

String imageName = contentType.substring(contentType

.indexOf("/") + 1);

name = fileName + "." + imageName;

System.out.println("name:" + name);

mf.transferTo(new File(pathRoot + name));

Image image = new Image();

image.setGoodId(goodId);

image.setName(name);