基于javaweb+mysql的ssm酒吧后台管理系统(java+ssm+jsp+html+mysql)

基于javaweb+mysql的ssm酒吧后台管理系统(java+ssm+jsp+html+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的SSM酒吧后台管理系统(java+ssm+jsp+html+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版本；

技术栈

1. 后端：Spring+SpringMVC+Mybatis 2. 前端：HTML+CSS+JavaScript+jsp

使用说明

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

map.put("userCount", userCount);

logger.info("获取分页信息");

pageUtil.setTotal(userCount);

map.put("pageUtil", pageUtil);

logger.info("转到后台管理-用户页-ajax方式");

return "admin/userManagePage";

//转到后台管理-用户详情页-ajax

@RequestMapping(value = "admin/user/{uid}", method = RequestMethod.GET)

public String getUserById(HttpSession session, Map<String,Object> map, @PathVariable Integer uid/* 用户ID */){

logger.info("获取user_id为{}的用户信息",uid);

User user = userService.get(uid);

logger.info("获取用户详情-所在地地址信息");

Address address = addressService.get(user.getUser_address().getAddress_areaId());

JSONObject jsonObject = new JSONObject();

if (user == null) {

logger.info("登录验证失败");

jsonObject.put("success", false);

} else {

logger.info("登录验证成功,用户ID传入会话");

session.setAttribute("userId", user.getUser_id());

jsonObject.put("success", true);

return jsonObject.toJSONString();

//退出当前账号

@RequestMapping(value = "login/logout", method = RequestMethod.GET)

public String logout(HttpSession session) {

pageUtil.setTotal(userCount);

map.put("pageUtil", pageUtil);

logger.info("转到后台管理-用户页-ajax方式");

return "admin/userManagePage";

//转到后台管理-用户详情页-ajax

@RequestMapping(value = "admin/user/{uid}", method = RequestMethod.GET)

public String getUserById(HttpSession session, Map<String,Object> map, @PathVariable Integer uid/* 用户ID */){

logger.info("获取user_id为{}的用户信息",uid);

User user = userService.get(uid);

logger.info("获取用户详情-所在地地址信息");

Address address = addressService.get(user.getUser_address().getAddress_areaId());

public String getUserBySearch(@RequestParam(required = false) String user_name/* 用户名称 */,

@RequestParam(required = false) Byte[] user_gender_array/* 用户性别数组 */,

@RequestParam(required = false) String orderBy/* 排序字段 */,

@RequestParam(required = false,defaultValue = "true") Boolean isDesc/* 是否倒序 */,

@PathVariable Integer index/* 页数 */,

@PathVariable Integer count/* 行数 */) throws UnsupportedEncodingException {

//移除不必要条件

Byte gender = null;

if (user_gender_array != null && user_gender_array.length == 1) {

gender = user_gender_array[0];

//转到后台管理-用户详情页-ajax

@RequestMapping(value = "admin/user/{uid}", method = RequestMethod.GET)

public String getUserById(HttpSession session, Map<String,Object> map, @PathVariable Integer uid/* 用户ID */){

logger.info("获取user_id为{}的用户信息",uid);

User user = userService.get(uid);

logger.info("获取用户详情-所在地地址信息");

Address address = addressService.get(user.getUser_address().getAddress_areaId());

Stack<String> addressStack = new Stack<>();

//最后一级地址

addressStack.push(address.getAddress_name() + " ");

address = addressService.get(address.getAddress_regionId().getAddress_areaId());

addressStack.push(address.getAddress_name() + " ");

StringBuilder builder = new StringBuilder();

while (!addressStack.empty()) {

builder.append(addressStack.pop());

logger.info("所在地地址字符串：{}", builder);

user.setUser_address(new Address().setAddress_name(builder.toString()));

logger.info("获取用户详情-家乡地址信息");

address = addressService.get(user.getUser_homeplace().getAddress_areaId());

//最后一级地址

List<User> userList = userService.getList(null, null, pageUtil);

map.put("userList", userList);

logger.info("获取用户总数量");

Integer userCount = userService.getTotal(null);

map.put("userCount", userCount);

logger.info("获取分页信息");

pageUtil.setTotal(userCount);

map.put("pageUtil", pageUtil);

logger.info("转到后台管理-用户页-ajax方式");

return "admin/userManagePage";

//转到后台管理-用户详情页-ajax

@RequestMapping(value = "admin/user/{uid}", method = RequestMethod.GET)

public String getUserById(HttpSession session, Map<String,Object> map, @PathVariable Integer uid/* 用户ID */){

//登陆验证-ajax

@ResponseBody

@RequestMapping(value = "login/doLogin", method = RequestMethod.POST, produces = "application/json;charset=utf-8")

public String checkLogin(HttpSession session, @RequestParam String username, @RequestParam String password) {

logger.info("用户验证登录");

User user = userService.login(username, password);

JSONObject jsonObject = new JSONObject();

if (user == null) {

logger.info("登录验证失败");

jsonObject.put("success", false);

} else {

logger.info("登录验证成功,用户ID传入会话");

session.setAttribute("userId", user.getUser_id());

//封装查询条件

User user = new User()

.setUser_name(user_name)

.setUser_gender(gender);

OrderUtil orderUtil = null;

if (orderBy != null) {

logger.info("根据{}排序，是否倒序:{}",orderBy,isDesc);

orderUtil = new OrderUtil(orderBy, isDesc);

JSONObject object = new JSONObject();

logger.info("按条件获取第{}页的{}条用户", index + 1, count);

PageUtil pageUtil = new PageUtil(index, count);

List<User> userList = userService.getList(user, orderUtil, pageUtil);

OrderUtil orderUtil = null;

if (orderBy != null) {

logger.info("根据{}排序，是否倒序:{}",orderBy,isDesc);

orderUtil = new OrderUtil(orderBy, isDesc);

JSONObject object = new JSONObject();

logger.info("按条件获取第{}页的{}条用户", index + 1, count);

PageUtil pageUtil = new PageUtil(index, count);

List<User> userList = userService.getList(user, orderUtil, pageUtil);

object.put("userList", JSONArray.parseArray(JSON.toJSONString(userList)));

logger.info("按条件获取用户总数量");

productOrderItem.setProductOrderItem_product(product);

user.setProductOrderItemList(productOrderItemList);

if (user.getUser_realname() != null) {

logger.info("用户隐私加密");

user.setUser_realname(user.getUser_realname().substring(0, 1) + "*");

} else {

user.setUser_realname("未命名");

map.put("user",user);

logger.info("转到后台管理-用户详情页-ajax方式");

return "admin/include/userDetails";

//按条件查询用户-ajax

logger.info("登录验证失败");

jsonObject.put("success", false);

} else {

logger.info("登录验证成功,用户ID传入会话");

session.setAttribute("userId", user.getUser_id());

jsonObject.put("success", true);

return jsonObject.toJSONString();

//退出当前账号

@RequestMapping(value = "login/logout", method = RequestMethod.GET)

public String logout(HttpSession session) {

Object o = session.getAttribute("userId");

if (o != null) {

session.removeAttribute("userId");

/**

* 后台管理-用户页

*/

@Controller

public class UserController extends BaseController{

@Resource(name="userService")

private UserService userService;

@Resource(name="addressService")

private AddressService addressService;

@Resource(name ="reviewService")

private ReviewService reviewService;

user.setUser_realname(user.getUser_realname().substring(0, 1) + "*");

} else {

user.setUser_realname("未命名");

map.put("user",user);

logger.info("转到后台管理-用户详情页-ajax方式");

return "admin/include/userDetails";

//按条件查询用户-ajax

@ResponseBody

@RequestMapping(value = "admin/user/{index}/{count}", method = RequestMethod.GET, produces = "application/json;charset=UTF-8")

public String getUserBySearch(@RequestParam(required = false) String user_name/* 用户名称 */,

@RequestParam(required = false) Byte[] user_gender_array/* 用户性别数组 */,

private ReviewService reviewService;

@Resource(name = "productOrderItemService")

private ProductOrderItemService productOrderItemService;

@Resource(name = "productService")

private ProductService productService;

@Resource(name = "productImageService")

private ProductImageService productImageService;

//转到后台管理-用户页-ajax

@RequestMapping(value = "admin/user", method = RequestMethod.GET)

public String goUserManagePage(HttpSession session, Map<String, Object> map){

//移除不必要条件

Byte gender = null;

if (user_gender_array != null && user_gender_array.length == 1) {

gender = user_gender_array[0];

if (user_name != null) {

//如果为非空字符串则解决中文乱码：URLDecoder.decode(String,"UTF-8");

user_name = "".equals(user_name) ? null : URLDecoder.decode(user_name, "UTF-8");

if (orderBy != null && "".equals(orderBy)) {

orderBy = null;

//封装查询条件

User user = new User()

product.setSingleProductImageList(productImageService.getList(

productId, (byte) 0, new PageUtil(0, 1))

);

productOrderItem.setProductOrderItem_product(product);

user.setProductOrderItemList(productOrderItemList);

if (user.getUser_realname() != null) {

logger.info("用户隐私加密");

user.setUser_realname(user.getUser_realname().substring(0, 1) + "*");

} else {

user.setUser_realname("未命名");

map.put("user",user);

OrderUtil orderUtil = null;

if (orderBy != null) {

logger.info("根据{}排序，是否倒序:{}",orderBy,isDesc);

orderUtil = new OrderUtil(orderBy, isDesc);

JSONObject object = new JSONObject();

logger.info("按条件获取第{}页的{}条用户", index + 1, count);

PageUtil pageUtil = new PageUtil(index, count);

List<User> userList = userService.getList(user, orderUtil, pageUtil);

object.put("userList", JSONArray.parseArray(JSON.toJSONString(userList)));

logger.info("按条件获取用户总数量");