• Java项目：基于JSP+Servlet的网上订餐管理系统

    作者主页：夜未央5788

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    基于JSP+Servlet的网上订餐管理系统的设计与实现

    项目介绍

    基于JSP+Servlet的网上订餐管理系统的设计与实现。该项目为前后台管理项目。前台主要展示给普通用户，主要功能有菜品分类、最新菜品、销售排行、美食预订、营养小贴士、餐点搜索、订餐车、在线留言等；

    后台主要提供给管理员，主要功能有菜品管理、菜品类别管理、营养小贴士管理、会员管理、员工管理、留言管理、采购管理、销售订单查询、统计管理、用户管理等；

    环境需要

    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项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目 

    6.数据库：MySql 5.7版本；

    技术栈

    1. 后端：Servlet

    2. 前端：JSP+bootstrap+jQuery

    使用说明

    1. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;

    若为maven项目，导入成功后请执行maven clean;maven install命令，下载所需jar包；

    2. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    3. 将项目中DBConn.java文件中的数据库配置改为自己的配置
    4. 配置tomcat，然后运行项目，输入localhost:8080/xxx 登录
    5. 后台管理员账户:admin  密码:admin

    前台普通用户：111  密码：111

    运行截图

    前台界面

     

     

     

     

     

    后台界面

     

     

     

     

     

     

     

     

     

    相关代码 

    AdminLoginBean

    1. package com.itbaizhan.bean;
    2.  
    3. import java.sql.Connection;
    4. import java.sql.ResultSet;
    5. import java.sql.SQLException;
    6. import java.sql.Statement;
    7. import java.util.ArrayList;
    8.  
    9. import com.itbaizhan.util.DBConn;
    10.  
    11.  
    12. public class AdminLoginBean {
    13. 	
    14. 	Connection conn = null;
    15. 	Statement st = null;
    16. 	ResultSet rs = null;
    17. 	ArrayList al = new ArrayList();
    18. 	
    19. 	public int login(String name,String pwd){
    20. 		int temp = 0;
    21. 		conn = DBConn.getConn();
    22. 		try {
    23. 			st = conn.createStatement();
    24. 			rs = st.executeQuery("select * from admin where name='"+name+"'");
    25. 			if(rs.next()){
    26. 				String id = rs.getString("id");
    27. 				String tname = rs.getString("name");
    28. 				String tpwd = rs.getString("pwd");			
    29. 				if(pwd.equals(tpwd)){
    30. 					temp = 1;
    31. 					al.add(id);
    32. 					al.add(tname);
    33. 					al.add(tpwd);
    34. 				}else{
    35. 					temp = 2;
    36. 				}
    37. 			}else{
    38. 				temp = 3;
    39. 			}
    40. 		} catch (SQLException e) {
    41. 			e.printStackTrace();
    42. 		} finally{
    43. 			DBConn.close(conn,st,rs);
    44. 		}
    45. 		return temp;
    46. 	}
    47. 	
    48. 	public ArrayList getArrayLst(){
    49. 		return al;
    50. 	}
    51.  
    52. }

    ListServlet

    1. package com.itbaizhan.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.util.ArrayList;
    6.  
    7. import javax.servlet.ServletException;
    8. import javax.servlet.http.HttpServlet;
    9. import javax.servlet.http.HttpServletRequest;
    10. import javax.servlet.http.HttpServletResponse;
    11.  
    12. import com.itbaizhan.bean.SelectBean;
    13.  
    14. public class ListServlet extends HttpServlet {
    15.  
    16. 	/**
    17. 	 * Constructor of the object.
    18. 	 */
    19. 	public ListServlet() {
    20. 		super();
    21. 	}
    22.  
    23. 	/**
    24. 	 * Destruction of the servlet. 
    25. 	 */
    26. 	public void destroy() {
    27. 		super.destroy(); // Just puts "destroy" string in log
    28. 		// Put your code here
    29. 	}
    30.  
    31. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    32. 			throws ServletException, IOException {
    33. 		
    34.  
    35. 		SelectBean ib = new SelectBean();
    36. 		
    37. 		String sql1 = "select * from types";
    38. 		String[] args1 = {"id","name"};
    39. 		ArrayList al1 = ib.select(sql1, args1);
    40. 		request.setAttribute("type", al1);
    41. 		
    42. 		String sql2 = "select * from books";
    43. 		String[] args2 = {"id","name","author","publishing","number","price","storage","brief","type","tate","sums","imgpath","price1","sums1"};
    44. 		ArrayList al2 = ib.select(sql2, args2);
    45. 		request.setAttribute("books", al2);
    46. 		
    47. 		String sql3 = "select * from books order by sums1 desc";
    48. 		String[] args3 = {"id","name","author","publishing","number","price","storage","brief","type","tate","sums","imgpath","price1","sums1"};
    49. 		ArrayList al3 = ib.select(sql3, args3);
    50. 		request.setAttribute("xiaosou", al3);
    51. 		
    52. 		String sql5 = "select * from books where tate=1";
    53. 		String[] args5 = {"id","name","author","publishing","number","price","storage","brief","type","tate","sums","imgpath","price1","sums1"};
    54. 		ArrayList al5 = ib.select(sql5, args5);
    55. 		request.setAttribute("tuibook", al5);
    56. 		
    57. 		String sql6 = "select * from books where tate=2";
    58. 		String[] args6 = {"id","name","author","publishing","number","price","storage","brief","type","tate","sums","imgpath","price1","sums1"};
    59. 		ArrayList al6 = ib.select(sql6, args6);
    60. 		request.setAttribute("newbook", al6);
    61. 		
    62. 		String sql7 = "select * from users";
    63. 		String[] args7 = {"id","name","pwd","realname","sex","age","card","address","phone","email","code"};
    64. 		ArrayList al7 = ib.select(sql7, args7);
    65. 		request.setAttribute("users", al7);
    66. 		
    67. 		String sql10 = "select * from leaveword";
    68. 		String[] args10 = {"id","users","title","content","times"};
    69. 		ArrayList al10 = ib.select(sql10, args10);
    70. 		request.setAttribute("leaveword", al10);
    71. 		
    72. 		String sql13 = "select * from books order by id desc";
    73. 		String[] args13 = {"id","name","author","publishing","number","price","storage","brief","type","tate","sums","imgpath","price1","sums1"};
    74. 		ArrayList al13 = ib.select(sql13, args13);
    75. 		request.setAttribute("xiaosou1", al13);
    76. 		
    77. 		String sql14 = "select * from nutrition";
    78. 		String[] args14 = {"id","name","content"};
    79. 		ArrayList al14 = ib.select(sql14, args14);
    80. 		request.setAttribute("nutrition", al14);
    81. 		
    82. 		String sql15 = "select * from emp";
    83. 		String[] args15 = {"id","name","sex","birthday","phone","addr","duty","estate"};
    84. 		ArrayList al15 = ib.select(sql15, args15);
    85. 		request.setAttribute("emp", al15);
    86. 		
    87. 		String sql16 = "select * from stock";
    88. 		String[] args16 = {"id","name","unit","sums","price","times"};
    89. 		ArrayList al16 = ib.select(sql16, args16);
    90. 		request.setAttribute("stock", al16);
    91. 		
    92. 		
    93. 	}
    94.  
    95. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    96. 			throws ServletException, IOException {
    97. 		doGet(request,response);
    98. 	}
    99.  
    100. 	/**
    101. 	 * Initialization of the servlet. 
    102. 	 *
    103. 	 * @throws ServletException if an error occure
    104. 	 */
    105. 	public void init() throws ServletException {
    106. 		// Put your code here
    107. 	}
    108.  
    109. }

    SessAdminServlet

    1. package com.itbaizhan.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5.  
    6. import javax.servlet.ServletException;
    7. import javax.servlet.http.HttpServlet;
    8. import javax.servlet.http.HttpServletRequest;
    9. import javax.servlet.http.HttpServletResponse;
    10.  
    11. public class SessAdminServlet extends HttpServlet {
    12.  
    13. 	/**
    14. 	 * Constructor of the object.
    15. 	 */
    16. 	public SessAdminServlet() {
    17. 		super();
    18. 	}
    19.  
    20. 	/**
    21. 	 * Destruction of the servlet. 
    22. 	 */
    23. 	public void destroy() {
    24. 		super.destroy(); // Just puts "destroy" string in log
    25. 		// Put your code here
    26. 	}
    27.  
    28. 	
    29. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    30. 			throws ServletException, IOException {
    31. 		PrintWriter pw = response.getWriter();
    32. 		if(request.getSession().getAttribute("adminlogin") == null || request.getSession().getAttribute("adminlogin").equals("")){
    33. 			pw.write("");
    34. 		}
    35. 	}
    36.  
    37. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    38. 			throws ServletException, IOException {
    39. 		doGet(request,response);
    40. 	}
    41.  
    42. 	/**
    43. 	 * Initialization of the servlet. 
    44. 	 *
    45. 	 * @throws ServletException if an error occure
    46. 	 */
    47. 	public void init() throws ServletException {
    48. 		// Put your code here
    49. 	}
    50.  
    51. }

    SessLoginServlet

    1. package com.itbaizhan.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5.  
    6. import javax.servlet.ServletException;
    7. import javax.servlet.http.HttpServlet;
    8. import javax.servlet.http.HttpServletRequest;
    9. import javax.servlet.http.HttpServletResponse;
    10.  
    11. public class SessLoginServlet extends HttpServlet {
    12.  
    13. 	/**
    14. 	 * Constructor of the object.
    15. 	 */
    16. 	public SessLoginServlet() {
    17. 		super();
    18. 	}
    19.  
    20. 	/**
    21. 	 * Destruction of the servlet. 
    22. 	 */
    23. 	public void destroy() {
    24. 		super.destroy(); // Just puts "destroy" string in log
    25. 		// Put your code here
    26. 	}
    27.  
    28. 	
    29. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    30. 			throws ServletException, IOException {
    31. 		PrintWriter pw = response.getWriter();
    32. 		if(request.getSession().getAttribute("login") == null || request.getSession().getAttribute("login").equals("")){
    33. 			pw.write("");
    34. 		}
    35. 	}
    36.  
    37. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    38. 			throws ServletException, IOException {
    39. 		doGet(request,response);
    40. 	}
    41.  
    42. 	/**
    43. 	 * Initialization of the servlet. 
    44. 	 *
    45. 	 * @throws ServletException if an error occure
    46. 	 */
    47. 	public void init() throws ServletException {
    48. 		// Put your code here
    49. 	}
    50.  
    51. }

    BeforehandBookServlet

    1. package com.itbaizhan.servlet.qiantai;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.util.ArrayList;
    6.  
    7. import javax.servlet.RequestDispatcher;
    8. import javax.servlet.ServletException;
    9. import javax.servlet.http.HttpServlet;
    10. import javax.servlet.http.HttpServletRequest;
    11. import javax.servlet.http.HttpServletResponse;
    12. import javax.servlet.http.HttpSession;
    13.  
    14. import com.itbaizhan.bean.InsertUpdateDelBean;
    15. import com.itbaizhan.util.Validate;
    16.  
    17.  
    18.  
    19. public class BeforehandBookServlet extends HttpServlet {
    20.  
    21. 	/**
    22. 	 * Constructor of the object.
    23. 	 */
    24. 	public BeforehandBookServlet() {
    25. 		super();
    26. 	}
    27.  
    28. 	/**
    29. 	 * Destruction of the servlet. 
    30. 	 */
    31. 	public void destroy() {
    32. 		super.destroy(); // Just puts "destroy" string in log
    33. 		// Put your code here
    34. 	}
    35.  
    36. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    37. 			throws ServletException, IOException {
    38. 		Validate vd = new Validate();
    39. 		String bookid = vd.getUnicode(request.getParameter("bookid"));
    40. 		String price = vd.getUnicode(request.getParameter("price"));
    41. 		HttpSession session = request.getSession();
    42. 		ArrayList login = (ArrayList)session.getAttribute("login");
    43. 		InsertUpdateDelBean ib = new InsertUpdateDelBean();
    44. 		String sql = "insert into beforehand(users,books,price) values('"+login.get(0)+"','"+bookid+"','"+price+"')";
    45. 		ib.insertANDupdateANDdel(sql);
    46. 		request.setAttribute("okbeforehand", "1");
    47. 		RequestDispatcher rd=request.getRequestDispatcher("/qiantai/loan_book_note.jsp");
    48.         rd.forward(request,response);
    49. 	}
    50.  
    51. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    52. 			throws ServletException, IOException {
    53. 		doGet(request, response);
    54. 	}
    55.  
    56. 	/**
    57. 	 * Initialization of the servlet. 
    58. 	 *
    59. 	 * @throws ServletException if an error occure
    60. 	 */
    61. 	public void init() throws ServletException {
    62. 		// Put your code here
    63. 	}
    64.  
    65. }

    BookinfServlet

    1. package com.itbaizhan.servlet.qiantai;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.util.ArrayList;
    6.  
    7. import javax.servlet.RequestDispatcher;
    8. import javax.servlet.ServletException;
    9. import javax.servlet.http.HttpServlet;
    10. import javax.servlet.http.HttpServletRequest;
    11. import javax.servlet.http.HttpServletResponse;
    12.  
    13. import com.itbaizhan.bean.SelectBean;
    14. import com.itbaizhan.util.Validate;
    15.  
    16.  
    17.  
    18. public class BookinfServlet extends HttpServlet {
    19.  
    20. 	/**
    21. 	 * Constructor of the object.
    22. 	 */
    23. 	public BookinfServlet() {
    24. 		super();
    25. 	}
    26.  
    27. 	/**
    28. 	 * Destruction of the servlet. 
    29. 	 */
    30. 	public void destroy() {
    31. 		super.destroy(); // Just puts "destroy" string in log
    32. 		// Put your code here
    33. 	}
    34.  
    35. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    36. 			throws ServletException, IOException {
    37. 		SelectBean ib = new SelectBean();
    38. 		Validate vd = new Validate();
    39. 		String id = vd.getUnicode(request.getParameter("id"));
    40. 		String adminshow = vd.getUnicode(request.getParameter("adminshow"));
    41. 		String adminupdate = vd.getUnicode(request.getParameter("adminupdate"));
    42. 		String str = "/qiantai/bookinf.jsp";
    43. 		String sql2 = "select * from books where id="+id;
    44. 		String[] args2 = {"id","name","author","publishing","number","price","storage","brief","type","tate","sums","imgpath","price1","sums1"};
    45. 		ArrayList al2 = ib.select(sql2, args2);
    46. 		request.setAttribute("bookinf", al2);
    47. 		if(adminshow != null && !adminshow.equals("")){
    48. 			str ="/admin/showbook.jsp";
    49. 		}
    50. 		if(adminupdate != null && !adminupdate.equals("")){
    51. 			str ="/admin/updatebook.jsp";
    52. 		}
    53. 		RequestDispatcher rd=request.getRequestDispatcher(str);
    54.         rd.forward(request,response);
    55. 	}
    56.  
    57. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    58. 			throws ServletException, IOException {
    59. 		doGet(request,response);
    60. 	}
    61.  
    62. 	/**
    63. 	 * Initialization of the servlet. 
    64. 	 *
    65. 	 * @throws ServletException if an error occure
    66. 	 */
    67. 	public void init() throws ServletException {
    68. 		// Put your code here
    69. 	}
    70.  
    71. }

    如果也想学习本系统，下面领取。关注并回复：007jsp

  • 相关阅读:
    R语言ggplot2可视化：使用patchwork包将多个ggplot2可视化结果组合起来、两个可视化图像纵向组合之后再和另外一个可视化结果横向组合
    聊聊工作中，如何提升自己的编程能力？
    vscode 远程开发golang
    每个开发人员都应该关注的7个优秀的GitHub仓库
    java计算机毕业设计ssm框架的天气预报系统
    打印机多张双面打印使用说明
    计算机操作系统习题集锦（持续鸽新）
    Verilog：$readmemb和$readmemh系统函数的使用与其中的初始化地址相关问题（详细细节）
    洛谷 P4419 [COCI2017-2018#1] CezarL
    工厂模式之简单工厂模式（常用）
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/127096701