• Java项目：基于jsp+mysql的JSP在线旅游美食展现管理系统

    作者主页：源码空间站2022

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

    文末获取源码

    项目介绍

    本项目分为管理员与用户两种角色；
    管理员角色包含以下功能：
    管理员登录,用户管理,景点管理,美食管理,查看收藏数据,修改密码等功能。

    用户角色包含以下功能：
    用户登录,查看首页,查看景点详情,查看附近美食,查看美食详情,修改个人资料,查看我的收藏等功能。

    环境需要

    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.数据库：MySql 5.7版本；

    技术栈

    1. 后端：Spring+SpringMVC+Mbytes

    2. 前端：JSP+bootstrap+jQuery

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
    若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
    3. 将项目中db.properties配置文件中的数据库配置改为自己的配置;

    4. 运行项目，在浏览器中输入localhost:8080/

    运行截图
    用户角色

    管理员角色 

     

    相关代码 

    CllentServlet

    1. package com.travel.controller;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.sql.SQLException;
    6.  
    7. import javax.servlet.ServletException;
    8. import javax.servlet.annotation.WebServlet;
    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.alibaba.fastjson.JSONArray;
    15. import com.alibaba.fastjson.JSONObject;
    16. import com.travel.dao.BaseDao;
    17. import com.travel.dao.BaseDaoImpl;
    18. import com.travel.entity.CllentEntity;
    19. import com.travel.service.ObjectService;
    20.  
    21. @WebServlet("/Cllent")//用户类
    22. public class CllentServlet extends HttpServlet {
    23. 	private static final long serialVersionUID = 1L;
    24. 	BaseDao dao = new BaseDaoImpl();
    25. 	PrintWriter out = null;
    26.  
    27. 	@Override
    28. 	protected void service(HttpServletRequest request, HttpServletResponse response)
    29. 			throws ServletException, IOException {
    30. 		request.setCharacterEncoding("UTF-8");
    31. 		response.setContentType("text/html;charset=utf-8");
    32. 		// service
    33. 		// 方法类-----------------------------------------------------------------------------------------------------
    34. 		ObjectService service = new ObjectService();
    35. 		CllentEntity con = service.setObject(request, CllentEntity.class);
    36. 		HttpSession session = request.getSession();
    37. 		out = response.getWriter();
    38. 		// 全局变量类----------------------------------------------------------------------------------------------------------
    39. 		String method = request.getParameter("method");
    40. 		System.out.println(method);
    41.  
    42. 		if ("cllentList".equals(method)) {// 列表
    43. 			try {
    44. 				JSONArray cllent = dao.findJSONArray("select * from cllent ");
    45. 				request.setAttribute("cllent", cllent);
    46. 				request.getRequestDispatcher("admin-cllent.jsp").forward(request, response);
    47. 			} catch (SQLException e) {
    48. 				e.printStackTrace();
    49. 			}
    50. 		} else if ("searchCllent".equals(method)) {// 查询
    51. 			try {
    52. 				JSONArray cllent = dao.findJSONArray("select * from cllent where ctel like '%" + con.getCtel() + "%'");
    53. 				request.setAttribute("cllent", cllent);
    54. 				request.getRequestDispatcher("admin-cllent.jsp").forward(request, response);
    55. 			} catch (SQLException e) {
    56. 				e.printStackTrace();
    57. 			}
    58. 		} else if ("cllentAdd".equals(method)) {// 增加
    59. 			Object[] params = { con.getCllName(), con.getCtel(), con.getCsex(),con.getAge(),service.getRandom() };
    60. 			try {
    61. 				CllentEntity user = dao.findBean(CllentEntity.class, "select * from cllent where ctel=?",
    62. 						con.getCtel());
    63. 				if (user != null) {
    64. 					service.outWrite(out, "2");
    65. 				} else {
    66. 					int i = dao.update("INSERT INTO cllent(cll_name,ctel,csex,age,id_code,password) VALUES(?,?,?,?,?,?)", params);
    67. 					if (i > 0) {
    68. 						service.outWrite(out, "1");
    69. 					} else {
    70. 						service.outWrite(out, "3");
    71. 					}
    72. 				}
    73. 			} catch (SQLException e) {
    74. 				e.printStackTrace();
    75. 			}
    76. 		} else if ("resetPwd".equals(method)) {// 重置密码
    77. 			try {
    78. 				int i = dao.update("update cllent set password = '123456' where ctel=?", con.getCtel());
    79. 				if (i > 0) {
    80. 					response.sendRedirect("Cllent?method=cllentList");
    81. 				}
    82. 			} catch (SQLException e) {
    83. 				e.printStackTrace();
    84. 			}
    85. 		} else if ("deleteCllent".equals(method)) {// 删除
    86. 			try {
    87. 				int i = dao.update("delete from cllent where ctel=?", con.getCtel());
    88. 				if (i > 0 ) {
    89. 					response.sendRedirect("Cllent?method=cllentList");
    90. 				}
    91. 			} catch (SQLException e) {
    92. 				e.printStackTrace();
    93. 			}
    94. 		} else if ("updateCllent".equals(method)) {// 修改
    95. 			Object[] params = { con.getCllId() };
    96. 			try {
    97. 				JSONObject cllent = dao.findJSONObject("select * from cllent where cll_id = ?", params);
    98. 				request.setAttribute("cllent", cllent);
    99. 				request.getRequestDispatcher("admin-cllentUpdate.jsp").forward(request, response);
    100. 			} catch (SQLException e) {
    101. 				e.printStackTrace();
    102. 			}
    103. 		} else if ("updateCllent1".equals(method)) {// 完成修改
    104. 			Object[] params = {  con.getCllName(), con.getCsex(),con.getIdCode(),con.getAge(), con.getCtel() };
    105. 			try {
    106. 				int i = dao.update("update cllent set cll_name = ?,csex=?,id_code=?,age=? where ctel=?",
    107. 						params);
    108. 				if (i > 0) {
    109. 					service.outWrite(out, "1");
    110. 				} else {
    111. 					service.outWrite(out, "2");
    112. 				}
    113. 			} catch (SQLException e) {
    114. 				e.printStackTrace();
    115. 			}
    116. 		} else if ("updateCllent2".equals(method)) {// 用户完成修改信息
    117. 			Object[] params1 = { con.getCllName(), con.getCsex(),con.getIdCode(),con.getAge(), con.getCtel() };
    118. 			try {
    119.  
    120. 				int i = dao.update("update cllent set cll_name = ?,csex=?,id_code=?,age=? where ctel=?",
    121. 						params1);
    122. 				if(i>0) {
    123. 					response.sendRedirect("Cllent?method=cllentList");
    124. 				}
    125. 			} catch (SQLException e) {
    126. 				e.printStackTrace();
    127. 			}
    128. 		} else if ("cllent".equals(method)) {// 用户信息
    129. 			String uname = (String) session.getAttribute("uname");
    130. 			JSONArray cllent;
    131. 			try {
    132. 				cllent = dao.findJSONArray(
    133. 						"select u.*,c.* from users u join cllent c on c.uname=u.uname where u.uname=?", uname);
    134. 				System.out.println(cllent);
    135. 				request.setAttribute("cllent", cllent);
    136. 				request.getRequestDispatcher("cllent-info.jsp").forward(request, response);
    137. 			} catch (SQLException e) {
    138. 				e.printStackTrace();
    139. 			}
    140. 		}
    141. 	}
    142.  
    143. }

    CollectServlet

    1. package com.travel.controller;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.sql.SQLException;
    6.  
    7. import javax.servlet.ServletException;
    8. import javax.servlet.annotation.MultipartConfig;
    9. import javax.servlet.annotation.WebServlet;
    10. import javax.servlet.http.HttpServlet;
    11. import javax.servlet.http.HttpServletRequest;
    12. import javax.servlet.http.HttpServletResponse;
    13.  
    14. import com.alibaba.fastjson.JSON;
    15. import com.alibaba.fastjson.JSONArray;
    16. import com.travel.dao.BaseDao;
    17. import com.travel.dao.BaseDaoImpl;
    18. import com.travel.entity.FoodEntity;
    19. import com.travel.entity.ScenicEntity;
    20. import com.travel.service.ObjectService;
    21.  
    22. @WebServlet("/CollectServlet") // 用户类
    23. @MultipartConfig
    24. public class CollectServlet extends HttpServlet {
    25. 	private static final long serialVersionUID = 1L;
    26. 	BaseDao dao = new BaseDaoImpl();
    27. 	PrintWriter out = null;
    28.  
    29. 	@Override
    30. 	protected void service(HttpServletRequest request, HttpServletResponse response)
    31. 			throws ServletException, IOException {
    32. 		request.setCharacterEncoding("UTF-8");
    33. 		response.setContentType("text/html;charset=utf-8");
    34. 		// service
    35. 		// 方法类-----------------------------------------------------------------------------------------------------
    36. 		ObjectService service = new ObjectService();
    37. 		FoodEntity foo = service.setObject(request, FoodEntity.class);
    38. 		ScenicEntity sce = service.setObject(request, ScenicEntity.class);
    39. 		out = response.getWriter();
    40. 		// 全局变量类----------------------------------------------------------------------------------------------------------
    41. 		String method = request.getParameter("method");
    42. 		System.out.println(method);
    43.  
    44. 		if ("sce_collect".equals(method)) {// 景点收藏
    45. 			try {
    46. 				String sce_collect = "select count(*) value,s.sce_name name from scenic s "
    47. 						+ "join sce_collect sc on s.sce_id = sc.sce_id join cllent c on sc.ctel = c.ctel "
    48. 						+ " GROUP BY s.sce_id ORDER BY  value DESC limit 0,15";
    49. 				JSONArray scenic = dao.findJSONArray(sce_collect);
    50. 				service.outWrite(out, JSON.toJSONString(scenic));
    51. 			} catch (SQLException e) {
    52. 				e.printStackTrace();
    53. 			}
    54. 		} else if ("foo_collect".equals(method)) {// 美食收藏
    55. 			try {
    56. 				String foo_collect = "select count(*) value,f.foo_name name from food f "
    57. 						+ "join foo_collect fc on f.foo_id = fc.foo_id join cllent c on fc.ctel = c.ctel "
    58. 						+ "GROUP BY f.foo_id ORDER BY  value DESC limit 0,15";
    59. 				JSONArray food = dao.findJSONArray(foo_collect);
    60. 				service.outWrite(out, JSON.toJSONString(food));
    61. 			} catch (SQLException e) {
    62. 				e.printStackTrace();
    63. 			}
    64. 		} else if ("deleteFoo".equals(method)) {// 取消美食收藏
    65. 			String ctel = (String) request.getSession().getAttribute("ctel");
    66. 			Object[] params = { foo.getFooId(), ctel };
    67. 			System.out.println(foo.getFooId() + " " + ctel);
    68. 			try {
    69. 				int a = dao.update("delete from foo_collect where foo_id=? and ctel=?", params);
    70. 				if (a > 0) {
    71. 					service.outWrite(out, "1");
    72. 				} else {
    73. 					service.outWrite(out, "2");
    74. 				}
    75. 			} catch (SQLException e) {
    76. 				e.printStackTrace();
    77. 			}
    78. 		} else if ("addFoo".equals(method)) {// 美食收藏
    79. 			String ctel = (String) request.getSession().getAttribute("ctel");
    80. 			Object[] params = { foo.getFooId(), ctel };
    81. 			System.out.println(foo.getFooId() + " " + ctel);
    82. 			try {
    83. 				int a = dao.update("insert into foo_collect(foo_id,ctel) values(?,?)", params);
    84. 				if (a > 0) {
    85. 					service.outWrite(out, "1");
    86. 				} else {
    87. 					service.outWrite(out, "2");
    88. 				}
    89. 			} catch (SQLException e) {
    90. 				e.printStackTrace();
    91. 			}
    92. 		} else if ("deleteSce".equals(method)) {// 取消美食收藏
    93. 			String ctel = (String) request.getSession().getAttribute("ctel");
    94. 			Object[] params = { sce.getSceId(), ctel };
    95. 			try {
    96. 				int a = dao.update("delete from sce_collect where sce_id=? and ctel=?", params);
    97. 				if (a > 0) {
    98. 					service.outWrite(out, "1");
    99. 				} else {
    100. 					service.outWrite(out, "2");
    101. 				}
    102. 			} catch (SQLException e) {
    103. 				e.printStackTrace();
    104. 			}
    105. 		} else if ("addSce".equals(method)) {// 美食收藏
    106. 			String ctel = (String) request.getSession().getAttribute("ctel");
    107. 			Object[] params = { sce.getSceId(), ctel };
    108. 			try {
    109. 				int a = dao.update("insert into sce_collect(sce_id,ctel) values(?,?)", params);
    110. 				if (a > 0) {
    111. 					service.outWrite(out, "1");
    112. 				} else {
    113. 					service.outWrite(out, "2");
    114. 				}
    115. 			} catch (SQLException e) {
    116. 				e.printStackTrace();
    117. 			}
    118. 		} else if ("collectSec".equals(method)) {// 用户查看景点收藏
    119. 			String ctel = (String) request.getSession().getAttribute("ctel");
    120. 			try {
    121. 				String sce_collect = "select s.* from scenic s join sce_collect sc on s.sce_id = sc.sce_id join cllent c on sc.ctel = c.ctel where sc.ctel=?";
    122. 				JSONArray scenic = dao.findJSONArray(sce_collect,ctel);
    123. 				request.setAttribute("collect", scenic);
    124. 				request.getRequestDispatcher("collectSce-list.jsp").forward(request, response);
    125. 			} catch (SQLException e) {
    126. 				e.printStackTrace();
    127. 			}
    128. 		} else if ("collectFoo".equals(method)) {// 美食收藏
    129. 			String ctel = (String) request.getSession().getAttribute("ctel");
    130. 			try {
    131. 				String foo_collect = "select f.* from food f join foo_collect fc on f.foo_id = fc.foo_id join cllent c on fc.ctel = c.ctel where fc.ctel=?";
    132. 				JSONArray food = dao.findJSONArray(foo_collect,ctel);
    133. 				request.setAttribute("collect", food);
    134. 				request.getRequestDispatcher("collectFoo-list.jsp").forward(request, response);
    135. 			} catch (SQLException e) {
    136. 				e.printStackTrace();
    137. 			}
    138. 		}
    139. 	}
    140.  
    141. }

    FoodServlet

    1. package com.travel.controller;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.sql.SQLException;
    6.  
    7. import javax.servlet.ServletException;
    8. import javax.servlet.annotation.MultipartConfig;
    9. import javax.servlet.annotation.WebServlet;
    10. import javax.servlet.http.HttpServlet;
    11. import javax.servlet.http.HttpServletRequest;
    12. import javax.servlet.http.HttpServletResponse;
    13. import javax.servlet.http.Part;
    14.  
    15. import com.alibaba.fastjson.JSONArray;
    16. import com.alibaba.fastjson.JSONObject;
    17. import com.travel.dao.BaseDao;
    18. import com.travel.dao.BaseDaoImpl;
    19. import com.travel.entity.FoodEntity;
    20. import com.travel.service.ObjectService;
    21.  
    22. @WebServlet("/FoodServlet") // 用户类
    23. @MultipartConfig
    24. public class FoodServlet extends HttpServlet {
    25. 	private static final long serialVersionUID = 1L;
    26. 	BaseDao dao = new BaseDaoImpl();
    27. 	PrintWriter out = null;
    28.  
    29. 	@Override
    30. 	protected void service(HttpServletRequest request, HttpServletResponse response)
    31. 			throws ServletException, IOException {
    32. 		request.setCharacterEncoding("UTF-8");
    33. 		response.setContentType("text/html;charset=utf-8");
    34. 		// service
    35. 		// 方法类-----------------------------------------------------------------------------------------------------
    36. 		ObjectService service = new ObjectService();
    37. 		FoodEntity foo = service.setObject(request, FoodEntity.class);
    38. 		out = response.getWriter();
    39. 		// 全局变量类----------------------------------------------------------------------------------------------------------
    40. 		String method = request.getParameter("method");
    41. 		System.out.println(method);
    42.  
    43. 		if ("foodList".equals(method)) {// 列表
    44. 			try {
    45. 				JSONArray food = dao
    46. 						.findJSONArray("select s.sce_name,f.* from food f left join scenic s on s.sce_id=f.sce_id");
    47. 				request.setAttribute("food", food);
    48. 				request.getRequestDispatcher("admin-food.jsp").forward(request, response);
    49. 			} catch (SQLException e) {
    50. 				e.printStackTrace();
    51. 			}
    52. 		} else if ("searchFood".equals(method)) {// 查询
    53. 			try {
    54. 				System.out.println(foo.getFooName());
    55. 				JSONArray food = dao.findJSONArray(
    56. 						"select s.sce_name,f.* from food f left join scenic s on s.sce_id=f.sce_id where f.foo_name like '%"
    57. 								+ foo.getFooName() + "%'");
    58. 				String sceId = request.getParameter("sceId");
    59. 				System.out.println(sceId);
    60. 				if (sceId != null && sceId != "") {
    61. 					food = dao.findJSONArray(
    62. 							"select s.sce_name,f.* from food f left join scenic s on s.sce_id=f.sce_id where f.sce_id="
    63. 									+ sceId + " and f.foo_name like '%" + foo.getFooName() + "%'");
    64. 				}
    65. 				request.setAttribute("food", food);
    66. 				request.getRequestDispatcher("admin-food.jsp").forward(request, response);
    67. 			} catch (SQLException e) {
    68. 				e.printStackTrace();
    69. 			}
    70. 		} else if ("foodAdd".equals(method)) {// 增加
    71. 			Part part = request.getPart("Savatar");
    72. 			String heads_url = service.imagepath(part);
    73. 			String img_url = heads_url;
    74. 			Object[] params = { foo.getFooName(), img_url, foo.getAddress(), foo.getSceId(), foo.getDescription() };
    75. 			try {
    76. 				int i = dao.update("INSERT INTO food(foo_name,img_url,address,sce_id,description) VALUES(?,?,?,?,?)",
    77. 						params);
    78. 				if (i > 0) {
    79. 					response.sendRedirect("FoodServlet?method=foodList");
    80. 				}
    81. 			} catch (SQLException e) {
    82. 				e.printStackTrace();
    83. 			}
    84. 		} else if ("deleteFood".equals(method)) {// 删除
    85. 			try {
    86. 				int i = dao.update("delete from food where foo_id=?", foo.getFooId());
    87. 				if (i > 0) {
    88. 					response.sendRedirect("FoodServlet?method=foodList");
    89. 				}
    90. 			} catch (SQLException e) {
    91. 				e.printStackTrace();
    92. 			}
    93. 		} else if ("updateFood".equals(method)) {// 修改
    94. 			Object[] params = { foo.getFooId() };
    95. 			try {
    96. 				JSONObject food = dao.findJSONObject(
    97. 						"select s.sce_name,f.* from food f left join scenic s on s.sce_id=f.sce_id where f.foo_id = ?",
    98. 						params);
    99. 				request.setAttribute("food", food);
    100. 				request.getRequestDispatcher("admin-foodUpdate.jsp").forward(request, response);
    101. 			} catch (SQLException e) {
    102. 				e.printStackTrace();
    103. 			}
    104. 		} else if ("updateFood1".equals(method)) {// 完成修改
    105. 			String img_url = null;
    106. 			Part part1 = request.getPart("Savatar");
    107. 			if (part1.getSize() > 0) {
    108. 				String savepath = service.imagepath(part1);
    109. 				img_url = savepath;
    110. 			} else {
    111. 				img_url = foo.getImgUrl();
    112. 			}
    113. 			Object[] params = { foo.getFooName(), img_url, foo.getAddress(), foo.getSceId(), foo.getDescription(),
    114. 					foo.getFooId() };
    115. 			try {
    116. 				int i = dao.update(
    117. 						"update food set foo_name = ?,img_url=?,address=?,sce_id=?,description=? where foo_id=?",
    118. 						params);
    119. 				if (i > 0) {
    120. 					response.sendRedirect("FoodServlet?method=foodList");
    121. 				}
    122. 			} catch (SQLException e) {
    123. 				e.printStackTrace();
    124. 			}
    125. 		} else if ("foodCllentList".equals(method)) {// 用户查看列表
    126. 			String ctel = (String) request.getSession().getAttribute("ctel");
    127. 			try {
    128. 				String sql = "select IF(ISNULL(c.ctel),'0','1') count,IF(ISNULL(fo.foo_id),'0',CONVERT( COUNT(*) USING UTF8)) num ,f.* "
    129. 						+ "from foo_collect fo " + "left join food f on fo.foo_id=f.foo_id "
    130. 						+ "left join cllent c on c.ctel=fo.ctel " + "and c.ctel=? where f.sce_id=? "
    131. 						+ "GROUP BY f.foo_id order by num desc";
    132. 				JSONArray food = dao.findJSONArray(sql, ctel, foo.getSceId());
    133. 				request.setAttribute("food", food);
    134. 				request.getRequestDispatcher("food-list.jsp").forward(request, response);
    135. 			} catch (SQLException e) {
    136. 				e.printStackTrace();
    137. 			}
    138. 		} else if ("foodCllentSearch".equals(method)) {// 用户搜索列表
    139. 			String ctel = (String) request.getSession().getAttribute("ctel");
    140. 			try {
    141. 				String sql = "select IF(ISNULL(c.ctel),'0','1') count,IF(ISNULL(fo.foo_id),'0',CONVERT( COUNT(*) USING UTF8)) num ,f.* "
    142. 						+ "from foo_collect fo " + "left join food f on fo.foo_id=f.foo_id "
    143. 						+ "left join cllent c on c.ctel=fo.ctel " + "and c.ctel=" + ctel + " where f.sce_id = "
    144. 						+ foo.getSceId() + " and f.foo_name like '%" + foo.getFooName() + "%' "
    145. 						+ "GROUP BY f.foo_id order by num desc";
    146. 				JSONArray food = dao.findJSONArray(sql);
    147. 				request.setAttribute("food", food);
    148. 				request.getRequestDispatcher("food-list.jsp").forward(request, response);
    149. 			} catch (SQLException e) {
    150. 				e.printStackTrace();
    151. 			}
    152. 		} else if ("detailFood".equals(method)) {// 美食详情
    153. 			try {
    154. 				JSONObject food = dao.findJSONObject("select * from food where foo_id=?", foo.getFooId());
    155. 				request.setAttribute("food", food);
    156. 				request.getRequestDispatcher("food-detail.jsp").forward(request, response);
    157. 			} catch (SQLException e) {
    158. 				e.printStackTrace();
    159. 			}
    160. 		}
    161. 	}
    162.  
    163. }

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

     

  • 相关阅读:
    互联网智慧工地源码，“互联网+建筑大数据”SaaS微服务架构，支持PC端、手机端、数据大屏端
    vue3的生命周期
    Unity游戏Mod/插件制作教程05 - 插件实例2: 简单功能实现
    01 uniapp/微信小程序 项目day01
    【电源专题】不合理接地引发的典型问题及地环路隔离的方法
    搭建docker，docker搭建达梦数据库，详细【图文】
    C语言数组和指针笔试题(二)(一定要看)
    Android USB分析
    【性能测试】缓慢的磁盘问题分析套路
    设计链表复习
  • 原文地址：https://blog.csdn.net/m0_74967853/article/details/128073734