• Java项目：基于jsp+sevlet+mysql日记系统

    作者主页：源码空间站2022

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

    文末获取源码

    项目介绍

    本项目主要功能有： 
    写日记 查看日记 日记删除 日记修改 日记类别添加 日记类别修改 日记类别删除 个人信息查看 个人信息修改 分页功能

    用户名:xyj 密码:123456

    环境需要

    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版本；

    6.是否Maven项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目

    技术栈

    1. 后端：servlet

    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. 运行项目，在浏览器中输入http://localhost:8080/ 登录

    运行截图

    相关代码 

    NewsTypeServlet

    1. package com.java1234.web;
    2.  
    3. import java.io.IOException;
    4. import java.sql.Connection;
    5. import java.util.List;
    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 net.sf.json.JSONObject;
    13.  
    14. import com.java1234.dao.NewsDao;
    15. import com.java1234.dao.NewsTypeDao;
    16. import com.java1234.model.Link;
    17. import com.java1234.model.NewsType;
    18. import com.java1234.util.DbUtil;
    19. import com.java1234.util.NavUtil;
    20. import com.java1234.util.ResponseUtil;
    21. import com.java1234.util.StringUtil;
    22.  
    23. public class NewsTypeServlet extends HttpServlet{
    24.  
    25. 	/**
    26. 	 * 
    27. 	 */
    28. 	private static final long serialVersionUID = 1L;
    29. 	
    30. 	DbUtil dbUtil=new DbUtil();
    31. 	NewsDao newsDao=new NewsDao();
    32. 	NewsTypeDao newsTypeDao=new NewsTypeDao();
    33. 	
    34. 	@Override
    35. 	protected void doGet(HttpServletRequest request, HttpServletResponse response)
    36. 			throws ServletException, IOException {
    37. 		this.doPost(request, response);
    38. 	}
    39.  
    40. 	@Override
    41. 	protected void doPost(HttpServletRequest request, HttpServletResponse response)
    42. 			throws ServletException, IOException {
    43. 		request.setCharacterEncoding("utf-8");
    44. 		String action=request.getParameter("action");
    45. 		if("preSave".equals(action)){
    46. 			this.newsTypePreSave(request, response);
    47. 		}else if("save".equals(action)){
    48. 			this.newsTypeSave(request, response);
    49. 		}else if("backList".equals(action)){
    50. 			this.newsTypeBackList(request, response);
    51. 		}else if("delete".equals(action)){
    52. 			this.newsTypeDelete(request, response);
    53. 		}
    54. 		
    55. 	}
    56.  
    57. 	private void newsTypePreSave(HttpServletRequest request, HttpServletResponse response)
    58. 			throws ServletException, IOException {
    59. 		String newsTypeId=request.getParameter("newsTypeId");
    60. 		Connection con=null;
    61. 		try{
    62. 			con=dbUtil.getCon();
    63. 			if(StringUtil.isNotEmpty(newsTypeId)){
    64. 				NewsType newsType=newsTypeDao.getNewsTypeById(con, newsTypeId);
    65. 				request.setAttribute("newsType", newsType);
    66. 			}
    67. 			
    68. 			if(StringUtil.isNotEmpty(newsTypeId)){
    69. 				request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻类别管理", "新闻类别修改"));
    70. 			}else{
    71. 				request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻类别管理", "新闻类别添加"));
    72. 			}
    73. 			request.setAttribute("mainPage", "/background/newsType/newsTypeSave.jsp");
    74. 			request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
    75. 		}catch(Exception e){
    76. 			e.printStackTrace();
    77. 		}finally{
    78. 			try {
    79. 				dbUtil.closeCon(con);
    80. 			} catch (Exception e) {
    81. 				// TODO Auto-generated catch block
    82. 				e.printStackTrace();
    83. 			}
    84. 		}
    85. 	}
    86. 	
    87. 	private void newsTypeSave(HttpServletRequest request, HttpServletResponse response)
    88. 			throws ServletException, IOException {
    89. 		Connection con=null;
    90. 		String newsTypeId=request.getParameter("newsTypeId");
    91. 		String typeName=request.getParameter("typeName");
    92. 		
    93. 		NewsType newsType=new NewsType(typeName);
    94. 		
    95. 		if(StringUtil.isNotEmpty(newsTypeId)){
    96. 			newsType.setNewsTypeId(Integer.parseInt(newsTypeId));
    97. 		}
    98. 		try{
    99. 			con=dbUtil.getCon();
    100. 			if(StringUtil.isNotEmpty(newsTypeId)){
    101. 				newsTypeDao.newsTypeUpdate(con, newsType);
    102. 			}else{
    103. 				newsTypeDao.newsTypeAdd(con, newsType);
    104. 			}
    105. 			request.getRequestDispatcher("/newsType?action=backList").forward(request, response);
    106. 		}catch(Exception e){
    107. 			e.printStackTrace();
    108. 		}finally{
    109. 			try {
    110. 				dbUtil.closeCon(con);
    111. 			} catch (Exception e) {
    112. 				// TODO Auto-generated catch block
    113. 				e.printStackTrace();
    114. 			}
    115. 		}
    116. 	}
    117. 	
    118. 	
    119. 	private void newsTypeBackList(HttpServletRequest request, HttpServletResponse response)
    120. 			throws ServletException, IOException {
    121. 		Connection con=null;
    122. 		try{
    123. 			con=dbUtil.getCon();
    124. 			List newsTypeBackList=newsTypeDao.newsTypeList(con);
    125. 			request.setAttribute("newsTypeBackList", newsTypeBackList);
    126. 			request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻类别管理", "新闻类别维护"));
    127. 			request.setAttribute("mainPage", "/background/newsType/newsTypeList.jsp");
    128. 			request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
    129. 		}catch(Exception e){
    130. 			e.printStackTrace();
    131. 		}finally{
    132. 			try {
    133. 				dbUtil.closeCon(con);
    134. 			} catch (Exception e) {
    135. 				// TODO Auto-generated catch block
    136. 				e.printStackTrace();
    137. 			}
    138. 		}
    139. 		
    140. 	}
    141. 	
    142. 	private void newsTypeDelete(HttpServletRequest request, HttpServletResponse response)
    143. 			throws ServletException, IOException {
    144. 		String newsTypeId=request.getParameter("newsTypeId");
    145. 		Connection con=null;
    146. 		try{
    147. 			con=dbUtil.getCon();
    148. 			JSONObject result=new JSONObject();
    149. 			boolean exist=newsDao.existNewsWithNewsTypeId(con, newsTypeId);
    150. 			if(exist){
    151. 				result.put("errorMsg", "该新闻类别下有新闻，不能删除此新闻类别");
    152. 			}else{
    153. 				int delNums=newsTypeDao.newsTypeDelete(con, newsTypeId);
    154. 				if(delNums>0){
    155. 					result.put("success", true);
    156. 				}else{
    157. 					result.put("errorMsg", "删除失败");
    158. 				}
    159. 			}
    160. 			ResponseUtil.write(result, response);
    161. 		}catch(Exception e){
    162. 			e.printStackTrace();
    163. 		}finally{
    164. 			try {
    165. 				dbUtil.closeCon(con);
    166. 			} catch (Exception e) {
    167. 				// TODO Auto-generated catch block
    168. 				e.printStackTrace();
    169. 			}
    170. 		}
    171. 	}
    172. }

    UserServlet

    1. package com.java1234.web;
    2.  
    3. import java.io.IOException;
    4. import java.sql.Connection;
    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. import javax.servlet.http.HttpSession;
    11.  
    12. import com.java1234.dao.UserDao;
    13. import com.java1234.model.User;
    14. import com.java1234.util.DbUtil;
    15.  
    16. public class UserServlet extends HttpServlet{
    17.  
    18. 	/**
    19. 	 * 
    20. 	 */
    21. 	private static final long serialVersionUID = 1L;
    22. 	
    23. 	DbUtil dbUtil=new DbUtil();
    24. 	UserDao userDao=new UserDao();
    25.  
    26. 	protected void doGet(HttpServletRequest request, HttpServletResponse response)
    27. 			throws ServletException, IOException {
    28. 		this.doPost(request, response);
    29. 	}
    30.  
    31. 	@Override
    32. 	protected void doPost(HttpServletRequest request, HttpServletResponse response)
    33. 			throws ServletException, IOException {
    34. 		request.setCharacterEncoding("utf-8");
    35. 		String action=request.getParameter("action");
    36. 		if("login".equals(action)){
    37. 			login(request,response);
    38. 		}else if("logout".equals(action)){
    39. 			logout(request,response);
    40. 		}
    41. 		
    42. 	}
    43. 	
    44. 	private void login(HttpServletRequest request, HttpServletResponse response)
    45. 			throws ServletException, IOException {
    46. 		String userName=request.getParameter("userName");
    47. 		String password=request.getParameter("password");
    48. 		
    49. 		HttpSession session=request.getSession();
    50. 		Connection con=null;
    51. 		try{
    52. 			con=dbUtil.getCon();
    53. 			User user=new User(userName,password);
    54. 			User currentUser=userDao.login(con, user);
    55. 			if(currentUser==null){
    56. 				request.setAttribute("error", "用户名或者密码错误！");
    57. 				request.setAttribute("password", password);
    58. 				request.setAttribute("userName", userName);
    59. 				request.getRequestDispatcher("/background/login.jsp").forward(request, response);
    60. 			}else{
    61. 				session.setAttribute("currentUser", currentUser);
    62. 				request.setAttribute("mainPage", "/background/default.jsp");
    63. 				request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
    64. 			}
    65. 		}catch(Exception e){
    66. 			e.printStackTrace();
    67. 		}finally{
    68. 			try {
    69. 				dbUtil.closeCon(con);
    70. 			} catch (Exception e) {
    71. 				// TODO Auto-generated catch block
    72. 				e.printStackTrace();
    73. 			}
    74. 		}
    75. 	}
    76. 	
    77. 	private void logout(HttpServletRequest request, HttpServletResponse response)
    78. 			throws ServletException, IOException {
    79. 		request.getSession().invalidate();
    80. 		System.out.println(request.getContextPath()+"/background/login.jsp");
    81. 		response.sendRedirect(request.getContextPath()+"/background/login.jsp");
    82. 	}
    83.  
    84. }

    LinkServlet

    1. package com.java1234.web;
    2.  
    3. import java.io.IOException;
    4. import java.sql.Connection;
    5. import java.util.List;
    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 net.sf.json.JSONObject;
    13.  
    14. import com.java1234.dao.LinkDao;
    15. import com.java1234.model.Link;
    16. import com.java1234.util.DbUtil;
    17. import com.java1234.util.NavUtil;
    18. import com.java1234.util.ResponseUtil;
    19. import com.java1234.util.StringUtil;
    20.  
    21. public class LinkServlet extends HttpServlet{
    22.  
    23. 	/**
    24. 	 * 
    25. 	 */
    26. 	private static final long serialVersionUID = 1L;
    27. 	
    28. 	DbUtil dbUtil=new DbUtil();
    29. 	LinkDao linkDao=new LinkDao();
    30.  
    31. 	protected void doGet(HttpServletRequest request, HttpServletResponse response)
    32. 			throws ServletException, IOException {
    33. 		this.doPost(request, response);
    34. 	}
    35.  
    36. 	@Override
    37. 	protected void doPost(HttpServletRequest request, HttpServletResponse response)
    38. 			throws ServletException, IOException {
    39. 		request.setCharacterEncoding("utf-8");
    40. 		String action=request.getParameter("action");
    41. 		if("preSave".equals(action)){
    42. 			linkPreSave(request,response);
    43. 		}else if("save".equals(action)){
    44. 			linkSave(request,response);
    45. 		}else if("backList".equals(action)){
    46. 			linkBackList(request,response);
    47. 		}else if("delete".equals(action)){
    48. 			linkDelete(request,response);
    49. 		}
    50. 		
    51. 	}
    52. 	
    53. 	private void linkDelete(HttpServletRequest request,
    54. 			HttpServletResponse response) throws ServletException, IOException{
    55. 		String linkId=request.getParameter("linkId");
    56. 		Connection con=null;
    57. 		try{
    58. 			con=dbUtil.getCon();
    59. 			JSONObject result=new JSONObject();
    60. 			int delNums=linkDao.linkDelete(con, linkId);
    61. 			if(delNums>0){
    62. 				result.put("success", true);
    63. 			}else{
    64. 				result.put("errorMsg", "删除失败");
    65. 			}
    66. 			ResponseUtil.write(result, response);
    67. 		}catch(Exception e){
    68. 			e.printStackTrace();
    69. 		}finally{
    70. 			try {
    71. 				dbUtil.closeCon(con);
    72. 			} catch (Exception e) {
    73. 				// TODO Auto-generated catch block
    74. 				e.printStackTrace();
    75. 			}
    76. 		}
    77. 	}
    78.  
    79. 	private void linkBackList(HttpServletRequest request,
    80. 			HttpServletResponse response) throws ServletException, IOException{
    81. 		Connection con=null;
    82. 		try{
    83. 			con=dbUtil.getCon();
    84. 			List linkBackList=linkDao.linkList(con, "select * from t_link order by orderNum");
    85. 			request.setAttribute("linkBackList", linkBackList);
    86. 			request.setAttribute("navCode", NavUtil.genNewsManageNavigation("友情链接管理", "友情链接维护"));
    87. 			request.setAttribute("mainPage", "/background/link/linkList.jsp");
    88. 			request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
    89. 		}catch(Exception e){
    90. 			e.printStackTrace();
    91. 		}finally{
    92. 			try {
    93. 				dbUtil.closeCon(con);
    94. 			} catch (Exception e) {
    95. 				// TODO Auto-generated catch block
    96. 				e.printStackTrace();
    97. 			}
    98. 		}
    99. 	}
    100.  
    101. 	private void linkPreSave(HttpServletRequest request, HttpServletResponse response)
    102. 			throws ServletException, IOException{
    103. 		String linkId=request.getParameter("linkId");
    104. 		Connection con=null;
    105. 		try{
    106. 			con=dbUtil.getCon();
    107. 			if(StringUtil.isNotEmpty(linkId)){
    108. 				Link link=linkDao.getLinkById(con, linkId);
    109. 				request.setAttribute("link", link);
    110. 			}
    111. 			
    112. 			if(StringUtil.isNotEmpty(linkId)){
    113. 				request.setAttribute("navCode", NavUtil.genNewsManageNavigation("友情链接管理", "友情链接修改"));
    114. 			}else{
    115. 				request.setAttribute("navCode", NavUtil.genNewsManageNavigation("友情链接管理", "友情链接添加"));
    116. 			}
    117. 			request.setAttribute("mainPage", "/background/link/linkSave.jsp");
    118. 			request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
    119. 		}catch(Exception e){
    120. 			e.printStackTrace();
    121. 		}finally{
    122. 			try {
    123. 				dbUtil.closeCon(con);
    124. 			} catch (Exception e) {
    125. 				// TODO Auto-generated catch block
    126. 				e.printStackTrace();
    127. 			}
    128. 		}
    129. 	}
    130. 	
    131. 	private void linkSave(HttpServletRequest request, HttpServletResponse response)
    132. 			throws ServletException, IOException {
    133. 		Connection con=null;
    134. 		String linkId=request.getParameter("linkId");
    135. 		String linkName=request.getParameter("linkName");
    136. 		String linkUrl=request.getParameter("linkUrl");
    137. 		String linkEmail=request.getParameter("linkEmail");
    138. 		String orderNum=request.getParameter("orderNum");
    139. 		
    140. 		Link link=new Link(linkName, linkUrl, linkEmail, Integer.parseInt(orderNum));
    141. 		
    142. 		if(StringUtil.isNotEmpty(linkId)){
    143. 			link.setLinkId(Integer.parseInt(linkId));
    144. 		}
    145. 		try{
    146. 			con=dbUtil.getCon();
    147. 			if(StringUtil.isNotEmpty(linkId)){
    148. 				linkDao.linkUpdate(con, link);
    149. 			}else{
    150. 				linkDao.linkAdd(con, link);
    151. 			}
    152. 			request.getRequestDispatcher("/link?action=backList").forward(request, response);
    153. 		}catch(Exception e){
    154. 			e.printStackTrace();
    155. 		}finally{
    156. 			try {
    157. 				dbUtil.closeCon(con);
    158. 			} catch (Exception e) {
    159. 				// TODO Auto-generated catch block
    160. 				e.printStackTrace();
    161. 			}
    162. 		}
    163. 	}
    164. }

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

     

  • 相关阅读:
    获取和设置小程序和h5的页面栈
    Centos 8 stream x64安装KVM
    首批48所高校大模型开课“尝鲜”，AI教学赋能计划合作名单公布
    时间序列常用数据处理
    SpingBoot的配置文件，SSM整合
    将json数据导入到ES集群——解决方案对比&填坑日记
    客服都喜欢的快捷回复软件
    IBM MQ 通道数量查看，以及最大通道数的修改
    Eureka Series : 5G + RTC
    C++ String类 （下） String类的模拟实现
  • 原文地址：https://blog.csdn.net/m0_74967853/article/details/128073674