• Java项目：JSP民宿预订网站信息管理平台

    作者主页：夜未央5788

     简介：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版本；

    6.是否Maven项目：否；

    技术栈

    JSP+CSS+JavaScript+mysql+servlet

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
    若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
    3. 将项目中db/DBManager.java配置文件中的数据库配置改为自己的配置;
    4. 运行项目，输入localhost:8080/ 登录
    用户账号/密码： user/123456

    管理员账号/密码：admin/admin

    运行截图

    用户角色

     

     

     

     

     

     管理员角色

     

     

     

     

      

    相关代码 

    YudingJiuAction

    1. package com.biyeseng.action;
    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. import com.biyeseng.db.DBManager;
    12. import java.sql.*;
    13. import java.util.Date;
    14.  
    15. /**
    16.  * 修改新闻
    17.  * 
    18.  * @author win7
    19.  * 
    20.  */
    21. public class YudingJiuAction extends HttpServlet {
    22.  
    23. 	/**
    24. 	 * Constructor of the object.
    25. 	 */
    26. 	public YudingJiuAction() {
    27. 		super();
    28. 	}
    29.  
    30. 	/**
    31. 	 * Destruction of the servlet. 
    32. 	 */
    33. 	public void destroy() {
    34. 		super.destroy(); // Just puts "destroy" string in log
    35. 		// Put your code here
    36. 	}
    37.  
    38. 	/**
    39. 	 * The doPost method of the servlet. 
    40. 	 * 
    41. 	 * This method is called when a form has its tag value method equals to
    42. 	 * post.
    43. 	 * 
    44. 	 * @param request
    45. 	 *            the request send by the client to the server
    46. 	 * @param response
    47. 	 *            the response send by the server to the client
    48. 	 * @throws ServletException
    49. 	 *             if an error occurred
    50. 	 * @throws IOException
    51. 	 *             if an error occurred
    52. 	 */
    53. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    54. 			throws ServletException, IOException {
    55.  
    56. 		response.setContentType("text/html");
    57. 		PrintWriter out = response.getWriter();
    58. 		String name=request.getParameter("name");
    59. 		String fang=request.getParameter("fang");
    60. 		String count=request.getParameter("count");
    61. 		String bdate=request.getParameter("bdate");
    62. 		String edate=request.getParameter("edate");
    63. 		String tel=request.getParameter("tel");
    64. 		String fangkuan=request.getParameter("fangkuan");
    65. 		String dingjin=request.getParameter("dingjin");
    66. 		String ism=request.getParameter("ism");
    67. 		String mtel=request.getParameter("mtel");
    68.  
    69. 		String sql = "insert into yuding(name,fang,count,bdate,edate,tel,fangkuan,dingjin,ism,mtel) values('"+name+"','"+fang+"','"+count+"','"+bdate+"','"+edate+"','"+tel+"','"+fangkuan+"','"+dingjin+"','"+ism+"','"+mtel+"')";
    70. 		System.out.println(sql);
    71.  
    72. 		Statement stat = null;
    73. 		Connection conn = null;
    74. 		DBManager dbm = new DBManager();
    75. 		try {
    76. 			conn = dbm.getConnection();
    77. 			stat = conn.createStatement();
    78. 			stat.execute(sql);
    79. 		} catch (SQLException e) {
    80. 			// TODO Auto-generated catch block
    81. 			e.printStackTrace();
    82. 		} finally {
    83. 			try {
    84. 				if (stat != null)
    85. 					stat.close();
    86. 				if (conn != null)
    87. 					conn.close();
    88. 			} catch (SQLException e) {
    89. 				// TODO Auto-generated catch block
    90. 				e.printStackTrace();
    91. 			}
    92. 		}
    93.  
    94. 		out
    95. 				.println("");
    96. 		out.flush();
    97. 		out.close();
    98. 	}
    99.  
    100. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    101. 			throws ServletException, IOException {
    102.  
    103. 		this.doPost(request, response);
    104. 	}
    105.  
    106. 	/**
    107. 	 * Initialization of the servlet. 
    108. 	 * 
    109. 	 * @throws ServletException
    110. 	 *             if an error occurs
    111. 	 */
    112. 	public void init() throws ServletException {
    113. 		// Put your code here
    114. 	}
    115.  
    116. }

    AddAdminAction

    1. package com.biyeseng.action;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.sql.*;
    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.biyeseng.db.DBManager;
    13.  
    14. /**
    15.  * 添加管理员
    16.  * @author win7
    17.  *
    18.  */
    19. public class AddAdminAction extends HttpServlet {
    20.  
    21. 	/**
    22. 	 * Constructor of the object.
    23. 	 */
    24. 	public AddAdminAction() {
    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. 	/**
    37. 	 * The doPost method of the servlet. 
    38. 	 *
    39. 	 * This method is called when a form has its tag value method equals to post.
    40. 	 * 
    41. 	 * @param request the request send by the client to the server
    42. 	 * @param response the response send by the server to the client
    43. 	 * @throws ServletException if an error occurred
    44. 	 * @throws IOException if an error occurred
    45. 	 */
    46. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    47. 			throws ServletException, IOException {
    48.  
    49. 		response.setContentType("text/html");
    50. 		PrintWriter out = response.getWriter();
    51. 		String name=request.getParameter("name");
    52. 		String pwd=request.getParameter("pwd");
    53. 		String zhi=request.getParameter("zhi");
    54. 		String tel=request.getParameter("tel");
    55. 		String age=request.getParameter("age");
    56. 		
    57. 		DBManager dbm = new DBManager();
    58. 		//插入管理员信息表
    59. 		String sql = "insert into admin(userName,userPw,zhi,tel,age)  values('"+name+"','"+pwd+"','"+zhi+"','"+tel+"','"+age+"')";
    60.  
    61. 		Statement stat = null;
    62. 		Connection conn=null;
    63. 		try {
    64. 			conn=dbm.getConnection();
    65. 			stat = conn.createStatement();
    66. 			System.out.println(sql);
    67. 			stat.execute(sql);
    68. 		} catch (SQLException e) {
    69. 			// TODO Auto-generated catch block
    70. 			e.printStackTrace();
    71. 		} finally {
    72. 			try {
    73. 				if(stat!=null)
    74. 					stat.close();
    75. 				if(conn!=null)
    76. 					conn.close();
    77. 			} catch (SQLException e) {
    78. 				// TODO Auto-generated catch block
    79. 				e.printStackTrace();
    80. 			}
    81. 		}
    82. 		response.sendRedirect("admin/admin/list.jsp");
    83. 		out.flush();
    84. 		out.close();
    85. 	}
    86.  
    87. 	/**
    88. 	 * Initialization of the servlet. 
    89. 	 *
    90. 	 * @throws ServletException if an error occurs
    91. 	 */
    92. 	public void init() throws ServletException {
    93. 		// Put your code here
    94. 	}
    95.  
    96. }

    AddJiudianAction

    1. package com.biyeseng.action;
    2.  
    3. import java.io.File;
    4. import java.io.IOException;
    5. import java.io.PrintWriter;
    6. import java.sql.Connection;
    7. import java.sql.SQLException;
    8. import java.sql.Statement;
    9. import java.util.Date;
    10. import java.util.Iterator;
    11. import java.util.List;
    12.  
    13. import javax.servlet.ServletException;
    14. import javax.servlet.http.HttpServlet;
    15. import javax.servlet.http.HttpServletRequest;
    16. import javax.servlet.http.HttpServletResponse;
    17.  
    18. import org.apache.commons.fileupload.DiskFileUpload;
    19. import org.apache.commons.fileupload.FileItem;
    20. import org.apache.commons.fileupload.FileItemFactory;
    21. import org.apache.commons.fileupload.disk.DiskFileItemFactory;
    22. import org.apache.commons.fileupload.servlet.ServletFileUpload;
    23.  
    24. import com.biyeseng.db.DBManager;
    25.  
    26. public class AddJiudianAction extends HttpServlet {
    27.  
    28. 	/**
    29. 	 * Constructor of the object.
    30. 	 */
    31. 	public AddJiudianAction() {
    32. 		super();
    33. 	}
    34.  
    35. 	/**
    36. 	 * Destruction of the servlet. 
    37. 	 */
    38. 	public void destroy() {
    39. 		super.destroy(); // Just puts "destroy" string in log
    40. 		// Put your code here
    41. 	}
    42.  
    43. 	/**
    44. 	 * The doGet method of the servlet. 
    45. 	 *
    46. 	 * This method is called when a form has its tag value method equals to get.
    47. 	 * 
    48. 	 * @param request the request send by the client to the server
    49. 	 * @param response the response send by the server to the client
    50. 	 * @throws ServletException if an error occurred
    51. 	 * @throws IOException if an error occurred
    52. 	 */
    53. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    54. 			throws ServletException, IOException {
    55.  
    56. 		this.doPost(request, response);
    57. 	}
    58.  
    59. 	/**
    60. 	 * The doPost method of the servlet. 
    61. 	 *
    62. 	 * This method is called when a form has its tag value method equals to post.
    63. 	 * 
    64. 	 * @param request the request send by the client to the server
    65. 	 * @param response the response send by the server to the client
    66. 	 * @throws ServletException if an error occurred
    67. 	 * @throws IOException if an error occurred
    68. 	 */
    69. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    70. 			throws ServletException, IOException {
    71.  
    72. 		request.setCharacterEncoding("UTF-8");
    73. 		
    74. 		response.setContentType("text/html");
    75. 		PrintWriter out = response.getWriter();
    76.  
    77. 		DBManager dbm = new DBManager();
    78. 		
    79. 		String name=request.getParameter("name");
    80. 		String dizhi=request.getParameter("dizhi");
    81. 		String info=request.getParameter("info");
    82. 		String pic=request.getParameter("fujian");
    83. 		String tel=request.getParameter("tel");
    84. 		String style=request.getParameter("style");
    85.  
    86. 		
    87. 	 
    88. 		
    89. 		String date = new Date().toLocaleString();
    90. 		Object user = request.getSession().getAttribute("user");
    91.  
    92. 		String appuser = "";
    93. 		if (user != null && appuser.toString() != null) {
    94. 			appuser = (String) user;
    95. 		}
    96. 		if(pic != null) {
    97. 			pic = pic.replaceAll("/upload", "upload");
    98. 		}
    99. 		
    100. 		
    101.  
    102. 		String sql = "insert into jiudian(name,dizhi,info,pic,tel,style) values('"+name+"','"+dizhi+"','"+info+"','"+pic+"','"+tel+"','"+style+"')";
    103. 		Statement stat = null;
    104. 		Connection conn = null;
    105. 		try {
    106. 			conn = dbm.getConnection();
    107. 			stat = conn.createStatement();
    108. 			System.out.println(sql);
    109. 			stat.execute(sql);
    110. 		} catch (SQLException e) {
    111. 			// TODO Auto-generated catch block
    112. 			e.printStackTrace();
    113. 		} finally {
    114. 			try {
    115. 				if (stat != null)
    116. 					stat.close();
    117. 				if (conn != null)
    118. 					conn.close();
    119. 			} catch (SQLException e) {
    120. 				// TODO Auto-generated catch block
    121. 				e.printStackTrace();
    122. 			}
    123. 		}
    124. 		response.sendRedirect("admin/jiudian/list.jsp");
    125.  
    126. 		
    127. 		out.flush();
    128. 		out.close();
    129. 	}
    130.  
    131. 	/**
    132. 	 * Initialization of the servlet. 
    133. 	 *
    134. 	 * @throws ServletException if an error occurs
    135. 	 */
    136. 	public void init() throws ServletException {
    137. 		// Put your code here
    138. 	}
    139.  
    140. }

    AddKefangAction

    1. package com.biyeseng.action;	
    2. 	
    3. import java.io.IOException;	
    4. import java.io.PrintWriter;	
    5. import java.sql.*;	
    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.biyeseng.db.DBManager;	
    13. 	
    14. /**	
    15.  * 添加部门	
    16.  * @author win7	
    17.  *	
    18.  */	
    19. public class AddKefangAction extends HttpServlet {	
    20. 	
    21. 	/**	
    22. 	 * Constructor of the object.	
    23. 	 */	
    24. 	public AddKefangAction() {	
    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. 	/**	
    37. 	 * The doPost method of the servlet. 
      	
    38. 	 *	
    39. 	 * This method is called when a form has its tag value method equals to post.	
    40. 	 * 	
    41. 	 * @param request the request send by the client to the server	
    42. 	 * @param response the response send by the server to the client	
    43. 	 * @throws ServletException if an error occurred	
    44. 	 * @throws IOException if an error occurred	
    45. 	 */	
    46. 	public void doPost(HttpServletRequest request, HttpServletResponse response)	
    47. 			throws ServletException, IOException {	
    48. 	
    49. 		response.setContentType("text/html");	
    50. 		PrintWriter out = response.getWriter();	
    51. 		String jid=request.getParameter("jid");
    52. 		String name=request.getParameter("name");
    53. 		String chuang=request.getParameter("chuang");
    54. 		String ren=request.getParameter("ren");
    55. 		String price=request.getParameter("price");
    56. 		String type=request.getParameter("type");
    57. 		String state="";
    58. 		DBManager dbm = new DBManager();	
    59. 		String sql = "insert into kefang(jid,name,chuang,ren,price,type,state) values("+jid+",'"+name+"','"+chuang+"','"+ren+"','"+price+"','"+type+"','"+state+"')";	
    60. 		System.out.println(sql);	
    61. 	
    62. 		Statement stat = null;	
    63. 		Connection conn=null;	
    64. 		try {	
    65. 			conn=dbm.getConnection();	
    66. 			stat = conn.createStatement();	
    67. 			stat.execute(sql);	
    68. 		} catch (SQLException e) {	
    69. 			// TODO Auto-generated catch block	
    70. 			e.printStackTrace();	
    71. 		} finally {	
    72. 			try {	
    73. 				if(stat!=null)	
    74. 					stat.close();	
    75. 				if(conn!=null)	
    76. 					conn.close();	
    77. 			} catch (SQLException e) {	
    78. 				// TODO Auto-generated catch block	
    79. 				e.printStackTrace();	
    80. 			}	
    81. 		}	
    82. 		response.sendRedirect("admin/kefang/list.jsp?jid="+jid);	
    83. 		out.flush();	
    84. 		out.close();	
    85. 	}	
    86. 	
    87. 	/**	
    88. 	 * Initialization of the servlet. 
      	
    89. 	 *	
    90. 	 * @throws ServletException if an error occurs	
    91. 	 */	
    92. 	public void init() throws ServletException {	
    93. 		// Put your code here	
    94. 	}	
    95. 	
    96. }

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

  • 相关阅读:
    jQuery网页开发案例:jQuery常用API--jQuery 尺寸、位置操作及 电梯导航案例和节流阀(互斥锁)
    深入理解JVM----垃圾回收算法
    【个人记录】Ceph添加OSD
    小程序自定义组件以及组件传值的简单总结
    物联网开发笔记（17）- 使用Micropython开发ESP32开发板开发环境准备
    继承里的析构函数与构造函数
    基于Echarts的22个可视化大盘静态前台页面
    选择 Guava EventBus 还是 Spring Framework ApplicationEvent
    软件测评的必要性，选择第三方软件测试机构的好处
    Spring框架（四）：Spring命名空间和配置标签
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/127037605