基于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
List<ItemOrder> yqx = itemOrderService.listBySqlReturnEntity(sql3);
String sql4 = "SELECT * FROM item_order WHERE status = 2 and user_id="+userId;
sql4 += " ORDER BY ID DESC ";
//已发货
List<ItemOrder> yfh = itemOrderService.listBySqlReturnEntity(sql4);
String sql5 = "SELECT * FROM item_order WHERE status = 3 and user_id="+userId;
sql5 += " ORDER BY ID DESC ";
//待评价
List<ItemOrder> dpj = itemOrderService.listBySqlReturnEntity(sql5);
model.addAttribute("all", all);
model.addAttribute("dfh", dfh);
model.addAttribute("yqx", yqx);
model.addAttribute("yfh", yfh);
model.addAttribute("dpj", dpj);
//存储查询条件
model.addAttribute("obj", itemOrder);
return "itemOrder/my";
}
/**
* 分页查询 返回list对象(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap")
public String findByMap(ItemOrder itemOrder, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(itemOrder.getItemId())){
params.put("itemId", itemOrder.getItemId());
}
if(!isEmpty(itemOrder.getUserId())){
params.put("userId", itemOrder.getUserId());
}
if(!isEmpty(itemOrder.getCode())){
params.put("code", itemOrder.getCode());
}
if(!isEmpty(itemOrder.getAddTime())){
params.put("addTime", itemOrder.getAddTime());
}
if(!isEmpty(itemOrder.getTotal())){
params.put("total", itemOrder.getTotal());
return "message/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Message message, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
messageService.update(message);
//2.通过主键id修改
//messageService.updateById(message);
return "redirect:/message/findByObj";
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
messageService.deleteById(id);
/*以下是多种删除方式*/
// //2.通过实体条件删除
// messageService.deleteByEntity(message);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// 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.状态删除
* @param id
* @return
*/
@RequestMapping(value = "/saveFiles")
public String saveFiles(@RequestParam("file") CommonsMultipartFile[] files,Integer id,HttpServletRequest request){
for(int i = 0;i<files.length;i++){
System.out.println("fileName---------->" + files[i].getOriginalFilename());
if(!files[i].isEmpty()){
int pre = (int) System.currentTimeMillis();
try {
//拿到输出流,同时重命名上传的文件
String filePath = request.getRealPath("/upload");
File f=new File(filePath);
if(!f.exists()){
f.mkdirs();
}
String fileNmae=new Date().getTime() + files[i].getOriginalFilename();
File file=new File(filePath+"/"+pre + files[i].getOriginalFilename());
if(!file.exists()){
file.createNewFile();
}
files[i].transferTo(file);
} catch (Exception e) {
e.printStackTrace();
System.out.println("上传出错");
}
}
}
return "";
}
// --------------------------------------- 华丽分割线 ------------------------------
}
//messageService.updateById(message);
return "redirect:/message/findByObj";
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
messageService.deleteById(id);
/*以下是多种删除方式*/
// //2.通过实体条件删除
// messageService.deleteByEntity(message);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// 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操作的方法。】 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 分页查询 返回list对象(通过对By Sql)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findBySql")
public String findBySql(Item item, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM item WHERE 1=1 and isDelete =0 ";
if(!isEmpty(item.getName())){
sql += " and name like '%"+item.getName()+"%'";
}
if(!isEmpty(item.getPrice())){
sql += " and price like '%"+item.getPrice()+"%'";
}
if(!isEmpty(item.getScNum())){
sql += " and scNum like '%"+item.getScNum()+"%'";
}
if(!isEmpty(item.getGmNum())){
sql += " and gmNum like '%"+item.getGmNum()+"%'";
}
if(!isEmpty(item.getUrl1())){
sql += " and url1 like '%"+item.getUrl1()+"%'";
}
if(!isEmpty(item.getUrl2())){
sql += " and url2 like '%"+item.getUrl2()+"%'";
}
if(!isEmpty(item.getUrl3())){
sql += " and url3 like '%"+item.getUrl3()+"%'";
}
if(!isEmpty(item.getUrl4())){
sql += " and url4 like '%"+item.getUrl4()+"%'";
}
if(!isEmpty(item.getUrl5())){
sql += " and url5 like '%"+item.getUrl5()+"%'";
}
if(!isEmpty(item.getMs())){
sql += " and ms like '%"+item.getMs()+"%'";
}
if(!isEmpty(item.getPam1())){
sql += " and pam1 like '%"+item.getPam1()+"%'";
// }
//
// if(!isEmpty(item.getMs())){
// params.put("ms", item.getMs());
// }
//
// if(!isEmpty(item.getPam1())){
// params.put("pam1", item.getPam1());
// }
//
// if(!isEmpty(item.getPam2())){
// params.put("pam2", item.getPam2());
// }
//
// if(!isEmpty(item.getPam3())){
// params.put("pam3", item.getPam3());
// }
//
// if(!isEmpty(item.getType())){
// params.put("type", item.getType());
// }
//
// if(!isEmpty(item.getIsDelete())){
// params.put("isDelete", item.getIsDelete());
// }
//
// itemService.deleteByMap(params);
// //4.状态删除
// Item load = itemService.getById(item.getId())
// load.setIsDelete(1);
// itemService.update(load);
//5.状态删除
Item load = itemService.load(id);
load.setIsDelete(1);
itemService.updateById(load);
return "redirect:/item/findBySql.action";
}
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
/**********************************【增删改】******************************************************/
/**
* 跳至添加页面
* @return
*/
@RequestMapping(value = "/add")
public String add() {
return "message/add";
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAdd", method = RequestMethod.POST)
@ResponseBody
public String exAdd(Message message, Model model, HttpServletRequest request, HttpServletResponse response) {
messageService.insert(message);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
Message obj = messageService.load(id);
model.addAttribute("obj",obj);
return "message/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Message message, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
messageService.update(message);
//2.通过主键id修改
//messageService.updateById(message);
return "redirect:/message/findByObj";
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private OrderDetailService orderDetailService;
// --------------------------------------- 华丽分割线 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAll")
public String listAll(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response){
List<OrderDetail> listAll = orderDetailService.listAll();
model.addAttribute("list", listAll);
return "orderDetail/orderDetail";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntity")
public String listByEntity(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response){
List<OrderDetail> listAll = orderDetailService.listAllByEntity(orderDetail);
model.addAttribute("list", listAll);
return "orderDetail/orderDetail";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
public String findByObjByEntityJson(Manage manage, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Manage> pagers = manageService.findByEntity(manage);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", manage);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMapJson", method = RequestMethod.POST)
@ResponseBody
public String findByMapJson(Manage manage,HttpServletRequest request, HttpServletResponse response) {
//通过map查询
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 jsonObject = new JSONObject();
jsonObject.put("message", "删除成功");
return jsonObject.toString();
}
/**
* 单文件上传
* @param file
* @param request
* @param model
* @return
*/
@RequestMapping(value = "/saveFile")
public String saveFile(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request, Model model) {
System.out.println("开始");
String path = request.getSession().getServletContext().getRealPath("/upload");
String fileName = file.getOriginalFilename();
System.out.println(path);
File targetFile = new File(path, fileName);
if(!targetFile.exists()){
targetFile.mkdirs();
}
//保存
try {
file.transferTo(targetFile);
} catch (Exception e) {
e.printStackTrace();
}
return "";
}
/**
* springMvc多文件上传
* @param files
* @param id
* @return
*/
@RequestMapping(value = "/saveFiles")
public String saveFiles(@RequestParam("file") CommonsMultipartFile[] files,Integer id,HttpServletRequest request){
for(int i = 0;i<files.length;i++){
System.out.println("fileName---------->" + files[i].getOriginalFilename());
if(!files[i].isEmpty()){
int pre = (int) System.currentTimeMillis();
try {
//拿到输出流,同时重命名上传的文件
String filePath = request.getRealPath("/upload");
File f=new File(filePath);
if(!f.exists()){
// }
//
// itemService.deleteByMap(params);
// //4.状态删除
// Item load = itemService.getById(item.getId())
// load.setIsDelete(1);
// itemService.update(load);
//5.状态删除
Item load = itemService.load(id);
load.setIsDelete(1);
itemService.updateById(load);
return "redirect:/item/findBySql.action";
}
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
@ResponseBody
public String listAllJson(Item item, HttpServletRequest request, HttpServletResponse response){
List<Item> listAll = itemService.listAll();
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", item);
return jsonObject.toString();
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
@Controller
@RequestMapping("/itemOrder")
public class ItemOrderController extends BaseController {
@Autowired
private ItemService itemService;
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private UserService userService;
@Autowired
private CarService carService;
@Autowired
private ItemOrderService itemOrderService;
@Autowired
private AddressService addressService;
@Autowired
@Controller
@RequestMapping("/manage")
public class ManageController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private ManageService manageService;
// --------------------------------------- 华丽分割线 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAll")
//存储查询条件
model.addAttribute("obj", user);
return "user/user";
}
/**
* 分页查询 返回list对象(通过对By Sql)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findBySql")
public String findBySql(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM user WHERE 1=1 ";
if(!isEmpty(user.getUserName())){
sql += " and userName like '%"+user.getUserName()+"%'";
}
if(!isEmpty(user.getPassWord())){
sql += " and passWord like '%"+user.getPassWord()+"%'";
}
if(!isEmpty(user.getPhone())){
sql += " and phone like '%"+user.getPhone()+"%'";
}
if(!isEmpty(user.getRealName())){
sql += " and realName like '%"+user.getRealName()+"%'";
}
if(!isEmpty(user.getSex())){
sql += " and sex like '%"+user.getSex()+"%'";
}
if(!isEmpty(user.getAddress())){
sql += " and address like '%"+user.getAddress()+"%'";
}
if(!isEmpty(user.getEmail())){
sql += " and email like '%"+user.getEmail()+"%'";
}
sql += " ORDER BY ID DESC ";
Pager<User> pagers = userService.findBySqlRerturnEntity(sql);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", user);
return "user/user";
}
/**
* 分页查询 返回list对象(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap")
String[] user_item = new String[items.size()+1];
List<String> isitems = new ArrayList<String>(items);
user_item[0] = String.valueOf(u.getId());
for(int k = 1; k < items.size()+1 ; k++){
user_item[k] = String.valueOf(isitems.get(k-1));
}
int length = user_item.length;
userItemLength.put(user_item[0], length);//eg: A 3
userID.put(user_item[0], a);//用户ID与稀疏矩阵建立对应关系
idUser.put(a, user_item[0]);
//建立物品--用户倒排表
for(int j = 1; j < length; j ++){
if(items.contains(user_item[j])){//如果已经包含对应的物品--用户映射,直接添加对应的用户
Set<String> set2 = itemUserCollection.get(user_item[j]);
if (!CollectionUtils.isEmpty(set2)){
set2.add(user_item[0]);
}else{
itemUserCollection.put(user_item[j], new HashSet<String>());//创建物品--用户倒排关系
itemUserCollection.get(user_item[j]).add(user_item[0]);
}
//itemUserCollection.get(user_item[j]).add(user_item[0]);
}else{//否则创建对应物品--用户集合映射
items.add(user_item[j]);
itemUserCollection.put(user_item[j], new HashSet<String>());//创建物品--用户倒排关系
itemUserCollection.get(user_item[j]).add(user_item[0]);
}
}
a++;
}
System.out.println(itemUserCollection.toString());
//计算相似度矩阵【稀疏】
Set<Entry<String, Set<String>>> entrySet = itemUserCollection.entrySet();
Iterator<Entry<String, Set<String>>> iterator = entrySet.iterator();
while(iterator.hasNext()){
Set<String> commonUsers = iterator.next().getValue();
for (String user_u : commonUsers) {
for (String user_v : commonUsers) {
if(user_u.equals(user_v)){
continue;
}
sparseMatrix[userID.get(user_u)][userID.get(user_v)] += 1;//计算用户u与用户v都有正反馈的物品总数
}
}
}
System.out.println(userItemLength.toString());
String recommendUser = String.valueOf(userId);
System.out.println(userID.get(recommendUser));
@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
*/
@RequestMapping(value = "/delete")
@ResponseBody
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
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);
model.addAttribute("list", listAll);
return "address/address";
}
/*********************************查询列表【分页】***********************************************/
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj")
public String findByObj(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Address> pagers = addressService.findByEntity(address);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", address);
return "address/address";
}
/**
* 分页查询 返回list对象(通过对By Sql)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findBySql")
public String findBySql(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {