基于javaweb+mysql的ssm+maven网上订餐在线点餐系统(java+ssm+jsp+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven网上订餐在线点餐系统(java+ssm+jsp+mysql)
前台:
http://localhost:8080/qiantai
user1 123456
user2 123456
后台:
http://localhost:8080/admin
admin 123456
@Qualifier("typesService")
private TypesService typesService;
/**
* 查询所有菜单类别
* @param model
* @return
*/
@RequestMapping("queryAll")
public String queryAll(Model model){
List<Types> types=typesService.queryAll();
model.addAttribute("types",types);
return "admin/type";
}
@RequestMapping("getall")
public List<Types> queryall()
{
return this.typesService.queryAll();
}
/**
* 通过id删除菜单类别
* @param model
* @param id
* @return
*/
@RequestMapping("delete")
public String delete(Model model,@Param("id") int id){
this.typesService.delete(id);
return queryAll(model);
}
/**
* 修改菜单类别
* @param model
* @param id
* @return
*/
//函数入口
@RequestMapping("update")
public String update(Model model,@Param("id") int id,@Param("name") String name) {
typesService.update(new Types(id,name));
return queryAll(model);
}
/**
* 根据id查询元素
* @param model
* @param id
* @return
*/
@RequestMapping("queryById")
public String queryById(Model model,@Param("id") int id){
@Qualifier("noticeService")
private NoticeService noticeService;
/**
* 查询所有元素
* @param model
* @return
*/
@RequestMapping("queryAll")
public String queryAll(Model model){
List<Notice> notices=noticeService.queryAll();
model.addAttribute("notices",notices);
return "admin/notice";
}
/**
* 查询所有公共并传送到前台
* @param model
* @return
*/
@RequestMapping("queryAlltoQiantai")
public String queryAlltoQiantai(Model model){
List<Notice> notices=noticeService.queryAll();
model.addAttribute("notices",notices);
return "qiantai/index";
}
/**
* 根据id删除元素
* @param model
* @param id
* @return
*/
@RequestMapping("delete")
public String delete(Model model, @Param("id") Integer id){
this.noticeService.delete(id);
return queryAll(model);
}
/**
* 根据id查询元素
* @param model
* @param id
/**
* (Types)表控制层
*
*/
@Controller
@RequestMapping("types")
public class TypesController {
/**
* 服务对象
*/
@Autowired
@Qualifier("typesService")
private TypesService typesService;
/**
* 查询所有菜单类别
* @param model
* @return
*/
@RequestMapping("queryAll")
public String queryAll(Model model){
List<Types> types=typesService.queryAll();
model.addAttribute("types",types);
return "admin/type";
}
@RequestMapping("getall")
public List<Types> queryall()
{
return this.typesService.queryAll();
}
/**
* 通过id删除菜单类别
* @param model
* @param id
* @return
@RequestMapping("/qiantai/allMenus")
public String menusList(Model model ){
List<Menus> list = menusService.queryAll();
model.addAttribute("menusList",list);
List<Types> typesList=typesService.queryAll();
model.addAttribute("typesList",typesList);
List<Notice> notices=noticeService.queryAll();
model.addAttribute("notices",notices);
return "/qiantai/index";
}
// 查询全部菜单,并且返回到菜单信息页面
@RequestMapping("/allMenus")
public String list(Model model ){
List<Menus> list = menusService.queryAllByLimit(1, 10);
model.addAttribute("list",list);
List<Types> typesList=typesService.queryAll();
model.addAttribute("typesList",typesList);
return "/admin/menus";
}
// 插入一个菜单信息到数据库
@RequestMapping("/insert")
public String insert(Menus menus, @RequestPart("img")MultipartFile multipartFile, HttpSession session) throws IOException {
String realPath = session.getServletContext().getRealPath("");
if (!multipartFile.isEmpty()) {
String originalFilename = multipartFile.getOriginalFilename();
System.out.println("==================================================");
System.out.println(realPath);
multipartFile.transferTo(new File(realPath + "public\\img\\" + originalFilename));
menus.setImgpath("img//" + originalFilename);
}
menus.setSums(0);
menus.setSums1(0);
menusService.insert(menus);
return "/admin/menus_add";
}
//菜单信息修改
@RequestMapping("/update")
public void update(Menus menus,HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException {
menusService.update(menus);
request.getRequestDispatcher("../menus/allMenus").forward(request,response);
}
//菜单信息删除
@RequestMapping("/delete")
public void delete(Integer id,HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException {
menusService.deleteById(id);
request.getRequestDispatcher("../menus/allMenus").forward(request,response);
}
Users user = (Users) session.getAttribute("user_session");
Integer userid = usersService.queryByname(user.getName());
Integer delivery = 0;
String remove = request.getParameter("remove");
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date date = new Date(System.currentTimeMillis());
String day = formatter.format(date);
Integer id = null;
if (shoppingCarts != null) {
for (ShoppingCart shoppingCart : shoppingCarts) {
Integer sums = shoppingCart.getSums();
Integer menuid = shoppingCart.getId();
Orders orders = new Orders(id, userid, menuid, sums, day, delivery);
ordersService.insert(orders);
}
session.removeAttribute("shoppingcar");
}
if(remove!=null) {
if (remove.equals("1")) {
session.removeAttribute("shoppingcar");
}
}
}else{
return "redirect:../public/qiantai/login.jsp";
}
return "redirect:/menus/qiantai/allMenus";
}
}
/**
* (Notice)表控制层
*
*/
@Controller
@RequestMapping("notice")
public class NoticeController {
/**
* 服务对象
*/
@Autowired
@Qualifier("noticeService")
private NoticeService noticeService;
/**
* 查询所有元素
* @param model
* @return
*/
@RequestMapping("queryAll")
public String queryAll(Model model){
List<Notice> notices=noticeService.queryAll();
model.addAttribute("notices",notices);
return "admin/notice";
}
/**
* 查询所有公共并传送到前台
* @param model
* @return
*/
*/
@RequestMapping("login")
public String login(Users user, HttpServletRequest request){
boolean loginType=usersService.login(user.getName(), user.getPwd());
HttpSession session=request.getSession();
if(loginType){
session.setAttribute("user_session",usersService.queryById(usersService.queryByname(user.getName())));
return "redirect:/menus/qiantai/allMenus";
}else{
session.setAttribute("message","用户名密码错误");
return "qiantai/userLoginFail";
}
}
//登出,地址/users/logout
@RequestMapping("logout")
public String logout(HttpSession session){
//清除session
session.removeAttribute("user_session");
//重定向到登录页面的跳转方法
return "redirect:/menus/qiantai/allMenus";
}
@RequestMapping("insert")
public String insert(@Param("name") String name,@Param("pwd") String pwd,@Param("realname") String realname,@Param("sex") String sex,@Param("age") Integer age,@Param("card") String card,@Param("address") String address,@Param("Phone") String phone,@Param("email")String email,@Param("code")String code,@Param("type")Integer type){
Users user=new Users(name,pwd,realname,sex,age,card,address,phone,email,code,type);
usersService.insert(user);
return "redirect:../public/qiantai/login.jsp";
}
@RequestMapping("update")
public String update(HttpSession session,@Param("id")Integer id,@Param("name") String name,@Param("pwd") String pwd,@Param("realname") String realname,@Param("sex") String sex,@Param("age") Integer age,@Param("card") String card,@Param("address") String address,@Param("Phone") String phone,@Param("email")String email,@Param("code")String code,@Param("type")Integer type){
Users user=new Users(id,name,pwd,realname,sex,age,card,address,phone,email,code,type);
usersService.update(user);
session.removeAttribute("user_session");
return "redirect:/users/login";
}
}
/**
* 服务对象
*/
@Autowired
@Qualifier("usersService")
private UsersService usersService;
/**
* 通过主键查询单条数据
*
* @param id 主键
* @return 单条数据
*/
@RequestMapping ("queryById")
public Users queryById(Integer id) {
return this.usersService.queryById(id);
}
/**
* 登录方法
* @param user
* @param request
* @return
*/
@RequestMapping("login")
public String login(Users user, HttpServletRequest request){
boolean loginType=usersService.login(user.getName(), user.getPwd());
HttpSession session=request.getSession();
if(loginType){
session.setAttribute("user_session",usersService.queryById(usersService.queryByname(user.getName())));
return "redirect:/menus/qiantai/allMenus";
}else{
session.setAttribute("message","用户名密码错误");
return "qiantai/userLoginFail";
}
}
//登出,地址/users/logout
@RequestMapping("logout")
public String logout(HttpSession session){
//清除session
session.removeAttribute("user_session");
//重定向到登录页面的跳转方法
return "redirect:/menus/qiantai/allMenus";
}
@RequestMapping("insert")
public String insert(@Param("name") String name,@Param("pwd") String pwd,@Param("realname") String realname,@Param("sex") String sex,@Param("age") Integer age,@Param("card") String card,@Param("address") String address,@Param("Phone") String phone,@Param("email")String email,@Param("code")String code,@Param("type")Integer type){
Users user=new Users(name,pwd,realname,sex,age,card,address,phone,email,code,type);
usersService.insert(user);
return "redirect:../public/qiantai/login.jsp";
/**
* (Admin)表控制层
*
*/
@Controller
@RequestMapping("admin")
public class AdminController {
/**
* 服务对象
*/
//自动注入业务层的AdminService类
@Autowired
@Qualifier("adminService")
private AdminService adminService;
//修改管理员信息
@RequestMapping("update")
public String update(Admin admin) {
adminService.update(admin);
return "/admin/menus";
}
@RequestMapping(value = "/login",method = RequestMethod.GET)
public String toLogin(){
return "/admin/index";
}
//login业务的访问位置为/admin/login
@RequestMapping(value = "/login",method = RequestMethod.POST)
public String login(Admin admin, HttpServletRequest request,HttpSession session){
//调用login方法来验证是否是注册用户
boolean loginType = adminService.login(admin.getName(),admin.getPwd());
if(loginType){
/**
* (Orders)表控制层
*
*/
@Controller
@RequestMapping("orders")
public class OrdersController {
/**
* 服务对象
*/
@Autowired
@Qualifier("ordersService")
private OrdersService ordersService;
@Autowired
@Qualifier("menusService")
private MenusService menusService;
@Autowired
@Qualifier("usersService")
private UsersService usersService;
//获取全部订单信息
@RequestMapping("ordergetall")
public String ordergetall( HttpServletRequest request) {
//传给前端
Pages page1=null;
//总页面
Integer totalCount=null;
//当前页面
String currentpages="1";
//获取上一页还是下一页标识
String s="";
//数据库操作页面
String pagess="1";
//前端页面总数
Integer allpage=null;
//如果不为空则获取currentpage
if(request.getParameter("currentpage")!=null){
currentpages=request.getParameter("currentpage");
StringBuilder day=new StringBuilder(day1);
day.replace(9,10,aa);
String day2=day.toString();
list=ordersService.pageListByDate(day1,day2);
}else {
System.out.println("未提交");
}
session.setAttribute("ordersearch", list);
System.out.println(id);
System.out.println(menuname);
System.out.println(day1);
return "/admin/order_search";
}
//跳转到statistic页面
@RequestMapping("order_statistic")
public String order_statistic( HttpServletRequest request) throws UnsupportedEncodingException {
List<Orders> list=null;
HttpSession session=request.getSession();
request.setCharacterEncoding("utf-8");
SimpleDateFormat formatter= new SimpleDateFormat("yyyy-MM-dd");
Date date = new Date(System.currentTimeMillis());
String day1=formatter.format(date);
Integer a=Integer.parseInt(day1.substring(9,10));
String aa=""+(a+1);
StringBuilder day=new StringBuilder(day1);
day.replace(9,10,aa);
String day2=day.toString();
System.out.println(a);
System.out.println(day1);
System.out.println(day2);
list=ordersService.pageListByDate(day1,day2);
session.setAttribute("orderstatistic", list);
return "/admin/order_statistic";
Integer delivery = 0;
String remove = request.getParameter("remove");
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date date = new Date(System.currentTimeMillis());
String day = formatter.format(date);
Integer id = null;
if (shoppingCarts != null) {
for (ShoppingCart shoppingCart : shoppingCarts) {
Integer sums = shoppingCart.getSums();
Integer menuid = shoppingCart.getId();
Orders orders = new Orders(id, userid, menuid, sums, day, delivery);
ordersService.insert(orders);
}
session.removeAttribute("shoppingcar");
}
if(remove!=null) {
if (remove.equals("1")) {
session.removeAttribute("shoppingcar");
}
}
}else{
return "redirect:../public/qiantai/login.jsp";
}
return "redirect:/menus/qiantai/allMenus";
}
}
String aa=""+(a+1);
StringBuilder day=new StringBuilder(day1);
day.replace(9,10,aa);
String day2=day.toString();
list=ordersService.pageListByDate(day1,day2);
}else {
System.out.println("未提交");
}
session.setAttribute("ordersearch", list);
System.out.println(id);
System.out.println(menuname);
System.out.println(day1);
return "/qiantai/order";
}
@RequestMapping(value="order_searchs",method = RequestMethod.POST)
public String order_searchs( HttpServletRequest request) throws UnsupportedEncodingException {
List<Orders> list=null;
HttpSession session=request.getSession();
request.setCharacterEncoding("utf-8");
Integer id=null;
String menuname=null;
String day1=null;
if(request.getParameter("userid")!=null&&(!request.getParameter("userid").equals(""))){
id=Integer.parseInt(request.getParameter("userid"));
list=ordersService.pageListByID(id);
}else if(request.getParameter("menuname")!=null&&(!request.getParameter("menuname").equals(""))){
menuname=request.getParameter("menuname");
list=ordersService.pageListByMenue(menuname);
}else if(request.getParameter("date")!=null&&(!request.getParameter("date").equals(""))){
day1=request.getParameter("date");
Integer a=Integer.parseInt(day1.substring(9,10));
String aa=""+(a+1);
StringBuilder day=new StringBuilder(day1);
day.replace(9,10,aa);
String day2=day.toString();
list=ordersService.pageListByDate(day1,day2);
/**
* (Notice)表控制层
*
*/
@Controller
@RequestMapping("notice")
public class NoticeController {
/**
* 服务对象
*/
@Autowired
@Qualifier("noticeService")
private NoticeService noticeService;
/**
* 查询所有元素
* @param model
* @return
*/
@RequestMapping("queryAll")
public String queryAll(Model model){
List<Notice> notices=noticeService.queryAll();
model.addAttribute("notices",notices);
return "admin/notice";
String aa=""+(a+1);
StringBuilder day=new StringBuilder(day1);
day.replace(9,10,aa);
String day2=day.toString();
list=ordersService.pageListByDate(day1,day2);
}else {
System.out.println("未提交");
}
session.setAttribute("ordersearch", list);
System.out.println(id);
System.out.println(menuname);
System.out.println(day1);
return "/qiantai/order";
}
@RequestMapping(value="order_searchs",method = RequestMethod.POST)
public String order_searchs( HttpServletRequest request) throws UnsupportedEncodingException {
List<Orders> list=null;
HttpSession session=request.getSession();
request.setCharacterEncoding("utf-8");
Integer id=null;
String menuname=null;
String day1=null;
if(request.getParameter("userid")!=null&&(!request.getParameter("userid").equals(""))){
id=Integer.parseInt(request.getParameter("userid"));
list=ordersService.pageListByID(id);
}else if(request.getParameter("menuname")!=null&&(!request.getParameter("menuname").equals(""))){
menuname=request.getParameter("menuname");
list=ordersService.pageListByMenue(menuname);
}else if(request.getParameter("date")!=null&&(!request.getParameter("date").equals(""))){
day1=request.getParameter("date");
Integer a=Integer.parseInt(day1.substring(9,10));
String aa=""+(a+1);
StringBuilder day=new StringBuilder(day1);
day.replace(9,10,aa);
if(i.equals(id)){
shoppingCarts.remove(shoppingCart);
break;
}
i++;
}
return "redirect:/menus/qiantai/allMenus";
}
@RequestMapping("order_addshoppingcartoOrder")
//提交或取消订单
public String order_addshoppingcartoOrder(HttpServletRequest request) {
HttpSession session=request.getSession();
List<ShoppingCart> shoppingCarts=(List<ShoppingCart>)session.getAttribute("shoppingcar");
if(session.getAttribute("user_session")!=null) {
Users user = (Users) session.getAttribute("user_session");
Integer userid = usersService.queryByname(user.getName());
Integer delivery = 0;
String remove = request.getParameter("remove");
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date date = new Date(System.currentTimeMillis());
String day = formatter.format(date);
Integer id = null;
if (shoppingCarts != null) {
for (ShoppingCart shoppingCart : shoppingCarts) {
Integer sums = shoppingCart.getSums();
Integer menuid = shoppingCart.getId();
Orders orders = new Orders(id, userid, menuid, sums, day, delivery);
ordersService.insert(orders);
}
session.removeAttribute("shoppingcar");
}
if(remove!=null) {
if (remove.equals("1")) {
session.removeAttribute("shoppingcar");
}
}
}else{
return "redirect:../public/qiantai/login.jsp";
}
String originalFilename = multipartFile.getOriginalFilename();
System.out.println("==================================================");
System.out.println(realPath);
multipartFile.transferTo(new File(realPath + "public\\img\\" + originalFilename));
menus.setImgpath("img//" + originalFilename);
}
menus.setSums(0);
menus.setSums1(0);
menusService.insert(menus);
return "/admin/menus_add";
}
//菜单信息修改
@RequestMapping("/update")
public void update(Menus menus,HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException {
menusService.update(menus);
request.getRequestDispatcher("../menus/allMenus").forward(request,response);
}
//菜单信息删除
@RequestMapping("/delete")
public void delete(Integer id,HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException {
menusService.deleteById(id);
request.getRequestDispatcher("../menus/allMenus").forward(request,response);
}
/**
* 通过主键查询单条数据
*
* @param id 主键
* @return 单条数据
*/
@GetMapping("selectOne")
public Menus selectOne(Object id) {
return this.menusService.queryById(id);
}
}
menusService.update(menus);
request.getRequestDispatcher("../menus/allMenus").forward(request,response);
}
//菜单信息删除
@RequestMapping("/delete")
public void delete(Integer id,HttpServletRequest request,HttpServletResponse response) throws IOException, ServletException {
menusService.deleteById(id);
request.getRequestDispatcher("../menus/allMenus").forward(request,response);
}
/**
* 通过主键查询单条数据
*
* @param id 主键
* @return 单条数据
*/
@GetMapping("selectOne")
public Menus selectOne(Object id) {
return this.menusService.queryById(id);
}
}