基于javaweb+springboot的在线点餐系统(java+Springboot+ssm+mysql+maven)
一、项目简述
功能:数据库采用mysq昨为数据存储,系统中涉及到的关 键表有,用户表、用户详情表、商品表、订单表、商品订 单关联表、评价表等等。本系统分为前端和后端,前端功 能有:登录注册、修改个人信息、修改收货地址、查看商 品、加购商品、结算商品,对订单进行评价、用户留言等 功能;后端功能有:登录、商品管理、用户管理、订单管 理、留言公告管理等功能。本系统中的购物车功能设计、io流读写图片存放本地、订单导出、“echarts插件实现订单信 息统计、后台批量操作、pagehelper实现分页等细节值得 学习。
二、项目运行
环境配置: Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)
项目技术: JSP +Springboot+ SpringMVC + MyBatis + html+ css + JavaScript + JQuery + Ajax + Layui+ maven等等。
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
return "/admin/advertising";
}
@RequestMapping("/admin/transaction")
public String transaction() {
return "/admin/order/transaction";
}
@RequestMapping("/amounts")
public String amounts() {
return "/admin/Amounts";
}
@RequestMapping("/orderHandling")
public String orderHandling() {
return "/admin/Order_handling";
}
@RequestMapping("/coverManagement")
public String coverManagement() {
return "/admin/Cover_management";
}
@RequestMapping("/userList")
public String userList() {
int sCount = 0;
for(User user : userList){
/* if("超级管理员".equals(user.getRole().getRoleName())){
sRoleName = sRoleName + " " + user.getUsername();
sCount = sCount + 1;
}else{
pRoleName = pRoleName + " " + user.getUsername();
pCount = pCount + 1;
}*/
}
model.addAttribute("pRoleName", pRoleName);
model.addAttribute("pCount", pCount);
model.addAttribute("sRoleName" , sRoleName);
model.addAttribute("sCount", sCount);
return "/admin/member/admin_competence";
}
}
后台登录系统控制层:
/**
* 后台登录系统控制层
return "/admin/order/transaction";
}
@RequestMapping("/amounts")
public String amounts() {
return "/admin/Amounts";
}
@RequestMapping("/orderHandling")
public String orderHandling() {
return "/admin/Order_handling";
}
@RequestMapping("/coverManagement")
public String coverManagement() {
return "/admin/Cover_management";
for(int i=0;i<dataList.size();i++){
OrderExcelExportVO data = (OrderExcelExportVO)dataList.get(i);
List<Object> vpd = new ArrayList<>();
varList.add(data);
}
dataMap.put("varList", varList);
return dataMap;
}
/**
*@描述 1-3-导出excel-自定义Excel标题和文件名
*/
protected Map<String,String> getExcelTitleAndFileName(){
Map<String,String> excelMap = new HashMap<String,String>();
excelMap.put("excelTitle","订单信息表格");//excel标题
DateFormat sdf = new SimpleDateFormat("yyyyMMdd");
String time = sdf.format(new Timestamp(System.currentTimeMillis()));
excelMap.put("fileName","订单信息表格" + time);//文件名
return excelMap;
}
@RequestMapping("/admin/selectUser")
public String selectUser(String userName, Model model){
List<User> dbUserList = userService.findUserByUsername(userName);
model.addAttribute("userList", dbUserList);
return "/admin/member/member_list";
}
@PostMapping("/admin/stopStatus")
public void stopState(String userId) {
int status = 0;
userService.updateUserStatus(userId, status);
}
@PostMapping("/admin/startStatus")
public void startState(String userId) {
int status = 1;
*/
@Controller
public class Back_OrderController {
@Autowired
private OrderService orderService;
@Autowired
private UserService userService;
@Autowired
private EvaService evaService;
/**
* 跳转到订单详情页面--并展示订单详情
* @return
*/
@RequestMapping("/admin/toOrderList")
public String orderForm(@RequestParam(required = true, defaultValue = "1") Integer page, Model model) {
PageHelper.startPage(page, 5);
List<Order> orderAll = orderService.findOrderAll();
model.addAttribute("order",orderAll);
PageInfo<Order> pageInfo = new PageInfo<>(orderAll);
model.addAttribute("page", pageInfo);
return "/admin/order/order_list";
}
@RequestMapping("/admin/deleteOrder")
public String deleteOrder(String orderId){
}
}
后台登录系统控制层:
/**
* 后台登录系统控制层
*/
@Controller
public class Back_HomeController {
@Autowired
private UserMapper userMapper;
@Autowired
private LeaveMapper leaveMapper;
/**
List<User> dbUserList = userService.findUserByUsername(userName);
model.addAttribute("userList", dbUserList);
return "/admin/member/member_list";
}
@PostMapping("/admin/stopStatus")
public void stopState(String userId) {
int status = 0;
userService.updateUserStatus(userId, status);
}
@PostMapping("/admin/startStatus")
public void startState(String userId) {
int status = 1;
userService.updateUserStatus(userId, status);
}
@RequestMapping("/admin/deleteUserById")
public void deleteUserById(String userId) {
*@描述 1-2-导出Excel-自定义列标题和数据
*/
protected Map<String,Object> getTitleArrayAndVarList(List<Object> dataList) {
Map<String,Object> dataMap = new HashMap<String,Object>();
//1-标题
String[] titleArray = {
"订单序号",
"订单编号",
"订单金额",
"收货人",
"收获地址",
"下单时间",
"订单状态"
};
dataMap.put("titles", Arrays.asList(titleArray));
//2-数据
List<OrderExcelExportVO> varList = new ArrayList<OrderExcelExportVO>();
for(int i=0;i<dataList.size();i++){
OrderExcelExportVO data = (OrderExcelExportVO)dataList.get(i);
List<Object> vpd = new ArrayList<>();
varList.add(data);
"订单金额",
"收货人",
"收获地址",
"下单时间",
"订单状态"
};
dataMap.put("titles", Arrays.asList(titleArray));
//2-数据
List<OrderExcelExportVO> varList = new ArrayList<OrderExcelExportVO>();
for(int i=0;i<dataList.size();i++){
OrderExcelExportVO data = (OrderExcelExportVO)dataList.get(i);
List<Object> vpd = new ArrayList<>();
varList.add(data);
}
dataMap.put("varList", varList);
return dataMap;
}
/**
*@描述 1-3-导出excel-自定义Excel标题和文件名
*/
protected Map<String,String> getExcelTitleAndFileName(){
Map<String,String> excelMap = new HashMap<String,String>();
excelMap.put("excelTitle","订单信息表格");//excel标题
DateFormat sdf = new SimpleDateFormat("yyyyMMdd");
String time = sdf.format(new Timestamp(System.currentTimeMillis()));
excelMap.put("fileName","订单信息表格" + time);//文件名
* @return
*/
@RequestMapping("/admin/toAnsEva")
public String toAnsEva(String orderId,Model model){
Evaluate evaluate = evaService.findEvaListByOrderId(orderId);
model.addAttribute("evaluate",evaluate);
return "/admin/adminAnsEva";
}
@RequestMapping("/admin/ansEva")
public String ansEva(String orderId,String ansContent,Integer orderStatus){
evaService.saveAnsEva(orderId,ansContent);
orderService.updateOrderStatus(orderStatus,orderId);
return "redirect:/admin/toOrderList";
}
//跳转到订单详情页面
@RequestMapping("/admin/orderDetailed")
public String orderDetailed(String orderId,Model model){
Order order = orderService.findListByOrderId(orderId);
model.addAttribute("order",order);
return "/admin/order/order_detailed";
}
/**
* 根据订单状态查询订单