基于java鲜花销售商店管理系统
项目获取请看文章最底下官网
鲜花销售管理系统是java编程语言和mysql数据库开发,基于B/S架构。本系统主要分为用户和管理员两个角色,其中用户可以查看鲜花分类,鲜花详情,下订单,在线留言,搜索商品等;管理员可以对用户,鲜花,分类,订单,新闻等内容进行管理。本设计结构简单,适合作为要求不高的java毕业设计和java课程设计来参考和学习。
一.技术环境
JDK版本:1.7
IDE工具:eclipse
数据库: mysql 5.5
编程语言: Java
tomcat: 7.0
框架:jsp+servlet
详细技术:HTML+CSS+JS+JSP+JAVA+servlet+MYSQL
二.项目文件(项目获取请看文末官网)
三.系统功能
四.代码示例
package com.ldu.controller;
import com.ldu.pojo.Admin;
import com.ldu.pojo.Goods;
import com.ldu.pojo.Orders;
import com.ldu.pojo.Purse;
import com.ldu.pojo.User;
import com.ldu.service.AdminService;
import com.ldu.service.GoodsService;
import com.ldu.service.OrdersService;
import com.ldu.service.PurseService;
import com.ldu.service.UserService;
import com.ldu.util.GoodsGrid;
import com.ldu.util.OrdersGrid;
import com.ldu.util.PurseGrid;
import com.ldu.util.UserGrid;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;
import java.util.List;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
/**
* 2018-3-7 10:40:38
*/
@Controller
@RequestMapping(value = "/admin")
public class AdminController {
@Resource
private UserService userService;
@Resource
private GoodsService goodsService;
@Resource
private OrdersService ordersService;
@Resource
private PurseService purseService;
@Resource
private AdminService adminService;
@RequestMapping(value = "", method = RequestMethod.GET)
public String login(HttpSession session) {
// 清除session
//session.invalidate();
return "/admin/login";
}
@RequestMapping(value = "/index", method = RequestMethod.POST)
public String index(HttpServletRequest request, Admin admins) {
Admin myadmin = adminService.findAdmin(admins.getPhone(), admins.getPassword());
if (myadmin != null) {
request.getSession().setAttribute("admin", myadmin);
return "/admin/index";
}
return "/admin/login";
}
@RequestMapping(value = "/indexs")
public String indexs(HttpServletRequest request) {
Admin admin = (Admin) request.getSession().getAttribute("admin");
if (admin != null) {
Integer id = admin.getId();
Admin myadmin = adminService.findAdminById(id);
request.getSession().setAttribute("admin", myadmin);
return "/admin/index";
}
return "/admin/login";
}
/* 个人信息 */
@RequestMapping(value = "/info")
@ResponseBody
public ModelAndView getInfo(HttpServletRequest request) {
Admin admin = (Admin) request.getSession().getAttribute("admin");
ModelAndView modelAndView = new ModelAndView();
modelAndView.addObject("admin", admin);
modelAndView.setViewName("admin/info");
return modelAndView;
}
/* 个人密码 */
@RequestMapping(value = "/modify")
@ResponseBody
public ModelAndView getModify(HttpServletRequest request) {
Admin admin = (Admin) request.getSession().getAttribute("admin");
ModelAndView modelAndView = new ModelAndView();
modelAndView.addObject("admin", admin);
modelAndView.setViewName("admin/modify");
return modelAndView;
}
/* 修改密码 */
@RequestMapping(value = "/changePassword")
@ResponseBody
public ModelAndView changePassword(HttpServletRequest request,Admin admin) {
String pwd=request.getParameter("password1");
ModelAndView modelAndView = new ModelAndView();
Admin admins = (Admin) request.getSession().getAttribute("admin");
if(admin.getPassword().equals(admins.getPassword())) {
admins.setPassword(pwd);
adminService.updateAdmin(admins);
}else {
modelAndView.addObject("msg", "原密码有误,请重新输入!");
modelAndView.setViewName("admin/modify");
return modelAndView;
}
modelAndView.setViewName("admin/login");
return modelAndView;
}
/*********************************************************
* 用户管理 1.查找所有用户 2.查看用户 3.修改用户 4.删除用户 5.查询用户
*
**********************************************************/
/* 查找所有用户 */
@RequestMapping(value = "/userList")
@ResponseBody
public ModelAndView getUserList(@RequestParam("pageNum") int pageNum) {
ModelAndView modelAndView = new ModelAndView();
int pageSize = 10;
int total = userService.getUserNum();
List<User> rows = userService.getPageUser(pageNum, pageSize);
UserGrid userGrid = new UserGrid();
userGrid.setCurrent(pageNum);
userGrid.setRowCount(pageSize);
userGrid.setRows(rows);
userGrid.setTotal(total);
modelAndView.addObject("userGrid", userGrid);
modelAndView.setViewName("admin/user/user_list");
return modelAndView;
}
/* 查看用户 */
@RequestMapping(value = "/getUser")
@ResponseBody
public User getUser(HttpServletRequest request) {
String id = request.getParameter("id");
User user = userService.getUserById(Integer.parseInt(id));
return user;
}
/* 修改用户 */
@RequestMapping(value = "/updateUser", method = RequestMethod.POST)
@ResponseBody
public String updateUser(HttpServletRequest request, User user) {
User users = userService.selectByPrimaryKey(user.getId());
user.setPassword(users.getPassword());
try {
userService.updateUserName(user);
} catch (Exception e) {
return "{\"success\":false,\"msg\":\"保存失败!\"}";
}
return "{\"success\":true,\"msg\":\"保存成功!\"}";
}
/* 删除用户 */
@RequestMapping(value = "/deleteUser", method = RequestMethod.POST)
@ResponseBody
public String deleteUser(HttpServletRequest request, @RequestParam(value = "ids[]") String[] ids) {
try {
for (int i = 0; i < ids.length; i++) {
userService.deleteUserById(ids[i]);
}
} catch (Exception e) {
return "{\"success\":false,\"msg\":\"删除失败!\"}";
}
return "{\"success\":true,\"msg\":\"删除成功!\"}";
}
/* 查询用户 */
@RequestMapping(value = "/searchUser", method = RequestMethod.POST)
@ResponseBody
public ModelAndView searchUser(HttpServletRequest request, User user) {
ModelAndView mv = new ModelAndView();
int pageNum = 1;
int pageSize = 10;
int total = userService.getUserNum();
String phone = user.getPhone();
String username = user.getUsername();
String qq = user.getQq();
List<User> rows = userService.getPageUserByUser(phone, username, qq, pageNum, pageSize);
UserGrid userGrid = new UserGrid();
User searchuser = new User();
searchuser.setPhone(phone);
searchuser.setUsername(username);
searchuser.setQq(qq);
userGrid.setCurrent(pageNum);
userGrid.setRowCount(pageSize);
userGrid.setRows(rows);
userGrid.setTotal(total);
mv.addObject("userGrid", userGrid);
mv.addObject("searchuser", searchuser);
mv.setViewName("admin/user/user_list");
return mv;
}
/*********************************************************
* 商品管理 1.查找所有商品 2.查看商品 3.修改商品 4.删除商品 5.查询商品 lyq
*
**********************************************************/
/* 查找所有商品 */
@RequestMapping(value = "/goodsList")
@ResponseBody
public ModelAndView getGoodsList(@RequestParam("pageNum") int pageNum) {
ModelAndView modelAndView = new ModelAndView();
int pageSize = 10;
int total = goodsService.getGoodsNum();
List<Goods> rows = goodsService.getPageGoods(pageNum, pageSize);
GoodsGrid goodsGrid = new GoodsGrid();
goodsGrid.setCurrent(pageNum);
goodsGrid.setRowCount(pageSize);
goodsGrid.setRows(rows);
goodsGrid.setTotal(total);
modelAndView.addObject("goodsGrid", goodsGrid);
modelAndView.setViewName("admin/goods/goods_list");
return modelAndView;
}
/* 查看商品 */
@RequestMapping(value = "/getGoods")
@ResponseBody
public Goods getGoods(HttpServletRequest request) {
String id = request.getParameter("id");
Goods goods = goodsService.getGoodsById(Integer.parseInt(id));
return goods;
}
/* 修改商品 */
@RequestMapping(value = "/updateGoods", method = RequestMethod.POST)
@ResponseBody
public String updateGoods(HttpServletRequest request, Goods goods) {
int id = goods.getId();
Goods oldGoods = goodsService.getGoodsById(id);
goods.setUserId(oldGoods.getUserId());
goods.setPolishTime(oldGoods.getPolishTime());
goods.setEndTime(oldGoods.getEndTime());
try {
goodsService.updateGoodsByPrimaryKeyWithBLOBs(goods.getId(), goods);
} catch (Exception e) {
return "{\"success\":false,\"msg\":\"保存失败!\"}";
}
return "{\"success\":true,\"msg\":\"保存成功!\"}";
}
/* 删除商品 */
@RequestMapping(value = "/deleteGoods", method = RequestMethod.POST)
@ResponseBody
public String deleteGoods(HttpServletRequest request, @RequestParam(value = "ids[]") String[] ids) {
try {
for (int i = 0; i < ids.length; i++) {
goodsService.deleteGoodsByPrimaryKeys(Integer.parseInt(ids[i]));
}
} catch (Exception e) {
return "{\"success\":false,\"msg\":\"删除失败!\"}";
}
return "{\"success\":true,\"msg\":\"删除成功!\"}";
}
/* 查询商品 */
@RequestMapping(value = "/searchGoods", method = RequestMethod.POST)
public ModelAndView searchGoods(HttpServletRequest request, Goods goods) {
ModelAndView mv = new ModelAndView();
int pageNum = 1;
int pageSize = 10;
int total = goodsService.getGoodsNum();
Integer id = goods.getId();
String name = goods.getName();
Integer status = goods.getStatus();
List<Goods> rows = goodsService.getPageGoodsByGoods(id, name, status, pageNum, pageSize);
GoodsGrid goodsGrid = new GoodsGrid();
Goods searchgoods = new Goods();
searchgoods.setId(id);
searchgoods.setName(name);
searchgoods.setStatus(status);
goodsGrid.setCurrent(pageNum);
goodsGrid.setRowCount(pageSize);
goodsGrid.setRows(rows);
goodsGrid.setTotal(total);
mv.addObject("goodsGrid", goodsGrid);
mv.addObject("searchgoods", searchgoods);
mv.setViewName("admin/goods/goods_list");
return mv;
}
/*********************************************************
* 订单管理 1.查找所有订单 2.查看订单 3.修改订单 4.删除订单 5.查询订单 lyq
*
**********************************************************/
/* 查找所有订单 */
@RequestMapping(value = "/ordersList")
@ResponseBody
public ModelAndView getOrdersList(@RequestParam("pageNum") int pageNum) {
ModelAndView modelAndView = new ModelAndView();
int pageSize = 10;
int total = ordersService.getOrdersNum();
List<Orders> rows = ordersService.getPageOrders(pageNum, pageSize);
OrdersGrid ordersGrid = new OrdersGrid();
ordersGrid.setCurrent(pageNum);
ordersGrid.setRowCount(pageSize);
ordersGrid.setRows(rows);
ordersGrid.setTotal(total);
modelAndView.addObject("ordersGrid", ordersGrid);
modelAndView.setViewName("admin/orders/orders_list");
return modelAndView;
}
/* 查看订单 */
@RequestMapping(value = "/getOrders")
@ResponseBody
public Orders getOrders(HttpServletRequest request) {
String id = request.getParameter("id");
Orders orders = ordersService.getOrdersById(Integer.parseInt(id));
return orders;
}
/* 修改订单 */
@RequestMapping(value = "/updateOrders", method = RequestMethod.POST)
@ResponseBody
public String updateOrders(HttpServletRequest request, Orders orders) {
int id = orders.getId();
Orders oldorders = ordersService.getOrdersById(id);
orders.setGoodsId(oldorders.getGoodsId());
orders.setUserId(oldorders.getUserId());
Goods goods=goodsService.getGoodsById(oldorders.getGoods().getId());
if (oldorders.getOrderState() != orders.getOrderState()) {
Float balance = orders.getOrderPrice();
if (orders.getOrderState() == 3) {
purseService.updatePurseByuserId(goods.getUserId(), balance);
} else {
purseService.updatePurseOfdel(goods.getUserId(), balance);
}
}
try {
ordersService.updateByPrimaryKey(id, orders);
} catch (Exception e) {
return "{\"success\":false,\"msg\":\"保存失败!\"}";
}
return "{\"success\":true,\"msg\":\"保存成功!\"}";
}
/* 删除订单 */
@RequestMapping(value = "/deleteOrders", method = RequestMethod.POST)
@ResponseBody
public String deleteOrders(HttpServletRequest request, @RequestParam(value = "ids[]") String[] ids) {
try {
for (int i = 0; i < ids.length; i++) {
ordersService.deleteOrdersByPrimaryKeys(Integer.parseInt(ids[i]));
}
} catch (Exception e) {
return "{\"success\":false,\"msg\":\"删除失败!\"}";
}
return "{\"success\":true,\"msg\":\"删除成功!\"}";
}
/* 查询订单 */
@RequestMapping(value = "/searchOrders", method = RequestMethod.POST)
@ResponseBody
public ModelAndView searchOrders(HttpServletRequest request, Orders orders) {
ModelAndView mv = new ModelAndView();
int pageNum = 1;
int pageSize = 10;
int total = ordersService.getOrdersNum();
Long orderNum = orders.getOrderNum();
String orderInformation = orders.getOrderInformation();
Integer orderState = orders.getOrderState();
List<Orders> rows = ordersService.getPageOrdersByOrders(orderNum, orderInformation, orderState, pageNum, pageSize);
OrdersGrid ordersGrid = new OrdersGrid();
Orders searchorders = new Orders();
searchorders.setOrderNum(orderNum);
searchorders.setOrderInformation(orderInformation);
searchorders.setOrderState(orderState);
ordersGrid.setCurrent(pageNum);
ordersGrid.setRowCount(pageSize);
ordersGrid.setRows(rows);
ordersGrid.setTotal(total);
mv.addObject("ordersGrid", ordersGrid);
mv.addObject("searchorders", searchorders);
mv.setViewName("admin/orders/orders_list");
return mv;
}
/*********************************************************
* 钱包管理 1.查找所有钱包 2.查看钱包 3.修改钱包 4.删除钱包 5.查询钱包 lyq
*
**********************************************************/
/* 查找所有钱包 */
@RequestMapping(value = "/purseList")
@ResponseBody
public ModelAndView getPurseList(HttpServletRequest request) {
int pageNum=Integer.parseInt(request.getParameter("pageNum"));
ModelAndView modelAndView = new ModelAndView();
int pageSize = 10;
int total = purseService.getPurseNum();
List<Purse> rows = purseService.getPagePurse(pageNum, pageSize);
PurseGrid purseGrid = new PurseGrid();
purseGrid.setCurrent(pageNum);
purseGrid.setRowCount(pageSize);
purseGrid.setRows(rows);
purseGrid.setTotal(total);
modelAndView.addObject("purseGrid", purseGrid);
modelAndView.setViewName("admin/purse/purse_list");
return modelAndView;
}
/* 查询钱包 */
@RequestMapping(value = "/searchPurse", method = RequestMethod.POST)
@ResponseBody
public ModelAndView searchPurse(HttpServletRequest request, Purse purse) {
ModelAndView mv = new ModelAndView();
int pageNum = 1;
int pageSize = 10;
int total = purseService.getPurseNum();
Integer userId = purse.getUserId();
Integer state=purse.getState();
List<Purse> rows = purseService.getPagePurseByPurse(userId,state, pageNum, pageSize);
PurseGrid purseGrid = new PurseGrid();
Purse searchpurse = new Purse();
searchpurse.setUserId(userId);
searchpurse.setState(state);
purseGrid.setCurrent(pageNum);
purseGrid.setRowCount(pageSize);
purseGrid.setRows(rows);
purseGrid.setTotal(total);
mv.addObject("purseGrid", purseGrid);
mv.addObject("searchpurse", searchpurse);
mv.setViewName("admin/purse/purse_list");
return mv;
}
/* 查看订单 */
@RequestMapping(value = "/getPurse")
@ResponseBody
public Purse getPurse(HttpServletRequest request) {
String id = request.getParameter("id");
Purse purse = purseService.getPurseById(Integer.parseInt(id));
return purse;
}
/* 修改钱包 */
// @RequestMapping(value = "/updatePurse", method = RequestMethod.POST)
// @ResponseBody
// public String updatePurse(HttpServletRequest request, Purse purse) {
// int id = purse.getId();
// try {
// purseService.updateByPrimaryKey(id, purse);
// } catch (Exception e) {
// return "{\"success\":false,\"msg\":\"保存失败!\"}";
// }
// return "{\"success\":true,\"msg\":\"保存成功!\"}";
// }
/* 通过 */
@RequestMapping(value = "/updatePursePass", method = RequestMethod.POST)
@ResponseBody
public String updatePursePass(HttpServletRequest request, Purse purse) {
Float balance=purse.getBalance();
purse.setState(2);
try {
if(purse.getRecharge()!=null){//充值 充值金额=null 当前金额=当前金额+充值金额
Float recharge=purse.getRecharge();
Float balanceRecharge=balance+recharge;
purse.setBalance(balanceRecharge);
purseService.updatePursePassById(purse.getId(),purse);
}if(purse.getWithdrawals()!=null) {//提现
Float withdrawals=purse.getWithdrawals();
Float balanceWithdrawals=balance-withdrawals;
purse.setBalance(balanceWithdrawals);
purseService.updatePurseRefuseById(purse.getId(),purse);
}
}
catch (Exception e) {
return "{\"success\":true,\"msg\":\"审核失败,请核对金额!\"}";
}
return "{\"success\":true,\"msg\":\"审核成功!\"}";
}
/* 不通过 */
@RequestMapping(value = "/updatePurseRefuse", method = RequestMethod.POST)
@ResponseBody
public String updatePurseRefuse(HttpServletRequest request, Purse purse) {
purse.setState(1);
try {
purseService.updatePurseRefuseById(purse.getId(),purse);
}
catch (Exception e) {
return "{\"success\":true,\"msg\":\"审核失败!\"}";
}
return "{\"success\":true,\"msg\":\"审核成功!\"}";
}
/* 用户查看审核结果 */
@RequestMapping(value = "/updatePurseState", method = RequestMethod.GET)
public void updatePurseState(HttpServletRequest request) {
Integer id=Integer.parseInt(request.getParameter("id"));
Purse purse= purseService.getPurseById(id);
purse.setState(null);
this.purseService.updateByPrimaryKey(id,purse);//修改state为null
}
}
五.项目截图