基于javaweb+mysql的ssm智能点餐推荐系统(java+ssm+jsp+bootstrap+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM智能点餐推荐系统(java+ssm+jsp+bootstrap+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.是否Maven项目: 是; 6.数据库:MySql 5.7等版本均可;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:JSP+CSS+JavaScript+jquery+bootstrap+echarts
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入http://localhost:8080/shop 登录 用户账号/密码: user/123456 管理员账号/密码:admin/admin
}
@RequestMapping(value = "/js2")
@ResponseBody
public String js2(Car car, Model model, HttpServletRequest request, HttpServletResponse response) {
Object attribute = request.getSession().getAttribute("userId");
JSONObject js = new JSONObject();
if (attribute == null){
js.put("res", 0);
return js.toJSONString();
}
Integer userId = Integer.valueOf(attribute.toString());
car.setUserId(userId);
Item load = itemService.load(car.getItemId());
String price = load.getPrice();
Long valueOf = Long.valueOf(price);
Integer num = car.getNum();
Long t = valueOf*num;
car.setTotal(t.toString());
carService.insert(car);
String key = "car_"+userId;
List<CarDto> list = new ArrayList<CarDto>();
CarDto d = new CarDto();
d.setId(car.getId());
d.setNum(car.getNum());
list.add(d);
request.getSession().setAttribute(key, list);
js.put("res", 1);
return js.toJSONString();
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Car car, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
carService.updateById(car);
//2.通过主键id修改
//carService.updateById(car);
return "redirect:/car/findBySql.action";
}
/**
* 删除通过主键
* @return
public String exUpdateJson(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
addressService.updateById(address);
//2.通过主键id修改
//addressService.updateById(address);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "修改成功");
return jsonObject.toString();
}
/**
* ajax 删除
* @return
*/
@RequestMapping(value = "/delete.json", method = RequestMethod.POST)
@ResponseBody
public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
addressService.deleteById(id);
/*以下是多种删除方式*/
// //2.通过实体条件删除
// addressService.deleteByEntity(address);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!isEmpty(address.getName())){
// params.put("name", address.getName());
// }
//
// if(!isEmpty(address.getPhone())){
// params.put("phone", address.getPhone());
// }
//
// if(!isEmpty(address.getArea())){
// params.put("area", address.getArea());
// }
//
// if(!isEmpty(address.getBm())){
// params.put("bm", address.getBm());
// }
//
// if(!isEmpty(address.getIsUse())){
// params.put("isUse", address.getIsUse());
// }
//
// addressService.deleteByMap(params);
// //4.状态删除
/**
* 生成二维码,返回到页面上
* @param response
*/
@RequestMapping(value="/getErWeiCode",method={RequestMethod.POST,RequestMethod.GET} )
public void getErWeiCode(HttpServletResponse response,Integer id){
ItemOrder byId = itemOrderService.getById(id);
String url=JSON.toJSONString(byId);
if(url!=null&&!"".equals(url)){
ServletOutputStream stream=null;
try {
int width=400;
int height=400;
stream=response.getOutputStream();
QRCodeWriter writer=new QRCodeWriter();
BitMatrix m=writer.encode(url, BarcodeFormat.QR_CODE, height,width);
MatrixToImageWriter.writeToStream(m, "png", stream);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally{
if(stream!=null){
try {
stream.flush();
stream.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
//
// if(!isEmpty(message.getName())){
// params.put("name", message.getName());
// }
//
// if(!isEmpty(message.getPhone())){
// params.put("phone", message.getPhone());
// }
//
// if(!isEmpty(message.getContent())){
// params.put("content", message.getContent());
// }
//
// messageService.deleteByMap(params);
// //4.状态删除
// Message load = messageService.getById(message.getId())
// load.setIsDelete(1);
// messageService.update(load);
//5.状态删除
//Message load = messageService.load(id);
//load.setIsDelete(1);
//messageService.update(load);
return "redirect:/message/findByObj";
}
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
@ResponseBody
}
//分页查询
Pager<User> pagers = userService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", user);
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
userService.insert(user);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
* ajax 修改
* @param
* @return
*/
@RequestMapping(value = "/exUpdate.json", method = RequestMethod.POST)
@ResponseBody
public String exUpdateJson(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
userService.updateById(user);
//2.通过主键id修改
//userService.updateById(user);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "修改成功");
return jsonObject.toString();
}
/**
* ajax 删除
* @return
*/
@RequestMapping(value = "/delete.json", method = RequestMethod.POST)
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMap")
public String listByMap(Comment comment, Model model, HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(comment.getUserId())){
params.put("userId", comment.getUserId());
}
if(!isEmpty(comment.getItemId())){
params.put("itemId", comment.getItemId());
}
if(!isEmpty(comment.getContent())){
params.put("content", comment.getContent());
}
if(!isEmpty(comment.getAddTime())){
params.put("addTime", comment.getAddTime());
}
List<Comment> listAll = commentService.listByMap(params);
model.addAttribute("list", listAll);
return "comment/comment";
}
/*********************************查询列表【分页】***********************************************/
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj")
public String findByObj(Comment comment, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Comment> pagers = commentService.findByEntity(comment);
model.addAttribute("pagers", pagers);
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAll")
public String listAll(User user, Model model, HttpServletRequest request, HttpServletResponse response){
List<User> listAll = userService.listAll();
model.addAttribute("list", listAll);
return "user/user";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntity")
public String listByEntity(User user, Model model, HttpServletRequest request, HttpServletResponse response){
List<User> listAll = userService.listAllByEntity(user);
model.addAttribute("list", listAll);
return "user/user";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMap")
public String listByMap(User user, Model model, HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(user.getUserName())){
params.put("userName", user.getUserName());
}
if(!isEmpty(user.getPassWord())){
params.put("passWord", user.getPassWord());
}
if(!isEmpty(user.getPhone())){
params.put("phone", user.getPhone());
}
if(!isEmpty(user.getRealName())){
return "itemOrder/pay";
}
//查询物流信息
@RequestMapping(value="/wl",produces="text/html;charset=UTF-8")
@ResponseBody
public String upass(Integer id,HttpServletRequest request,String password) throws UnsupportedEncodingException{
JSONObject j = new JSONObject();
ItemOrder obj = itemOrderService.load(id);
KD100Service service = new KD100Service();
LogisticsResponse queryLogistics = service.queryLogistics(obj.getWlgs(), obj.getWlcode());
j.put("res", 1);
j.put("data", queryLogistics);
return j.toString();
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(ItemOrder itemOrder, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
itemOrderService.updateById(itemOrder);
//2.通过主键id修改
//itemOrderService.updateById(itemOrder);
return "redirect:/itemOrder/findBySql.action";
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
itemOrderService.deleteById(id);
/*以下是多种删除方式*/
// //2.通过实体条件删除
// itemOrderService.deleteByEntity(itemOrder);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!isEmpty(itemOrder.getItemId())){
@Controller
@RequestMapping("/item")
public class ItemController extends BaseController {
@Autowired
private ScService scService;
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private ItemService itemService;
@Autowired
private ItemCategoryService itemCategoryService;
// --------------------------------------- 华丽分割线 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAll")
public String listAll(Item item, Model model, HttpServletRequest request, HttpServletResponse response){
//
// orderDetailService.deleteByMap(params);
// //4.状态删除
// OrderDetail load = orderDetailService.getById(orderDetail.getId())
// load.setIsDelete(1);
// orderDetailService.update(load);
//5.状态删除
//OrderDetail load = orderDetailService.load(id);
//load.setIsDelete(1);
//orderDetailService.update(load);
return "redirect:/orderDetail/findBySql.action";
}
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
@ResponseBody
public String listAllJson(OrderDetail orderDetail, HttpServletRequest request, HttpServletResponse response){
List<OrderDetail> listAll = orderDetailService.listAll();
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", orderDetail);
return jsonObject.toString();
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
}
}
}
return "";
}
// --------------------------------------- 华丽分割线 ------------------------------
}
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(manage.getUserName())){
params.put("userName", manage.getUserName());
}
if(!isEmpty(manage.getPassWord())){
params.put("passWord", manage.getPassWord());
}
if(!isEmpty(manage.getRealName())){
params.put("realName", manage.getRealName());
}
//分页查询
Pager<Manage> pagers = manageService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", manage);
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
manageService.insert(manage);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
* ajax 修改
* @param
* @return
*/
@RequestMapping(value = "/exUpdate.json", method = RequestMethod.POST)
@ResponseBody
public String exUpdateJson(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
manageService.updateById(manage);
//2.通过主键id修改
//manageService.updateById(manage);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "修改成功");
return jsonObject.toString();
}
/**
* ajax 删除
* @return
Object attribute = request.getSession().getAttribute("userId");
if (attribute == null){
return "redirect:/login/uLogin.action";
}
Integer userId = Integer.valueOf(attribute.toString());
User load = userService.load(userId);
request.setAttribute("obj", load);
return "login/pass";
}
@RequestMapping("/upass")
@ResponseBody
public String upass(HttpServletRequest request,String password){
Object attribute = request.getSession().getAttribute("userId");
JSONObject j = new JSONObject();
if (attribute == null){
j.put("res", 0);
return j.toString();
}
Integer userId = Integer.valueOf(attribute.toString());
User load = userService.load(userId);
load.setPassWord(password);
userService.updateById(load);
j.put("res", 1);
return j.toString();
}
// @RequestMapping("/toLogin2")
// public String toLogin(Student student, HttpServletRequest request, HttpServletResponse response){
// student.setIsdel(0);
// Student byEntity = studentService.getByEntity(student);
// if(byEntity == null){
// return "redirect:/login/login.action";
// }else{
// request.getSession().setAttribute("role",2);
// request.getSession().setAttribute("type",3);
// request.getSession().setAttribute("username", byEntity.getXh());
// request.getSession().setAttribute("userId", byEntity.getId());
// }
// return "login/index";
// }
/**
* 退出
* @param request
* @param response
* @return
*/
*/
@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(Sc sc, Model model, HttpServletRequest request, HttpServletResponse response) {
scService.insert(sc);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
* ajax 修改
* @param
* @return
*/
@RequestMapping(value = "/exUpdate.json", method = RequestMethod.POST)
@ResponseBody
public String exUpdateJson(Sc sc, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
scService.updateById(sc);
//2.通过主键id修改
//scService.updateById(sc);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "修改成功");
return jsonObject.toString();
}
/**
* ajax 删除
* @return
*/
@RequestMapping(value = "/delete.json", method = RequestMethod.POST)
@ResponseBody
public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
scService.deleteById(id);
/*以下是多种删除方式*/
// //2.通过实体条件删除
// scService.deleteByEntity(sc);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!isEmpty(sc.getItemId())){
// params.put("itemId", sc.getItemId());
// }
//
// if(!isEmpty(sc.getUserId())){
// params.put("userId", sc.getUserId());
// }
//
// scService.deleteByMap(params);
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST)
@ResponseBody
public String listByEntityJson(ItemCategory itemCategory, HttpServletRequest request, HttpServletResponse response){
List<ItemCategory> listAll = itemCategoryService.listAllByEntity(itemCategory);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", itemCategory);
return jsonObject.toString();
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMapJson", method = RequestMethod.POST)
@ResponseBody
public String listByMapJson(ItemCategory itemCategory,HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(itemCategory.getName())){
params.put("name", itemCategory.getName());
}
if(!isEmpty(itemCategory.getPid())){
params.put("pid", itemCategory.getPid());
}
if(!isEmpty(itemCategory.getIsDelete())){
params.put("isDelete", itemCategory.getIsDelete());
}
List<ItemCategory> listAll = itemCategoryService.listByMap(params);
*/
@RequestMapping(value = "/listByMapJson", method = RequestMethod.POST)
@ResponseBody
public String listByMapJson(Address address,HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(address.getName())){
params.put("name", address.getName());
}
if(!isEmpty(address.getPhone())){
params.put("phone", address.getPhone());
}
if(!isEmpty(address.getArea())){
params.put("area", address.getArea());
}
if(!isEmpty(address.getBm())){
params.put("bm", address.getBm());
}
if(!isEmpty(address.getIsUse())){
params.put("isUse", address.getIsUse());
}
List<Address> listAll = addressService.listByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", address);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(Address address, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Address> pagers = addressService.findByEntity(address);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", address);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Comment comment, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
commentService.updateById(comment);
//2.通过主键id修改
//commentService.updateById(comment);
return "redirect:/comment/findBySql.action";
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
commentService.deleteById(id);
/*以下是多种删除方式*/
// //2.通过实体条件删除
// commentService.deleteByEntity(comment);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!isEmpty(comment.getUserId())){
// params.put("userId", comment.getUserId());
// }
//
// if(!isEmpty(comment.getItemId())){
// params.put("itemId", comment.getItemId());
// }
//
// if(!isEmpty(comment.getContent())){
// params.put("content", comment.getContent());
// }
//
// if(!isEmpty(comment.getAddTime())){
// params.put("addTime", comment.getAddTime());
// }
//
// commentService.deleteByMap(params);
// //4.状态删除
// Comment load = commentService.getById(comment.getId())
// load.setIsDelete(1);
// commentService.update(load);
//5.状态删除
//Comment load = commentService.load(id);
//load.setIsDelete(1);
//commentService.update(load);
return "redirect:/comment/findBySql.action";