基于javaweb的JSP+Servlet民宿预订信息管理平台(java+jsp+javascript+servlet+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的JSP+Servlet民宿预订信息管理平台(java+jsp+javascript+servlet+mysql)

项目介绍

本项目为前后台，包括管理员与普通用户两种角色；

管理员角色包含以下功能：

管理员登录,用户管理,会员管理,民宿信息管理,新闻管理,留言管理等功能。

用户角色包含以下功能： 用户登录与注册,查看网站新闻,查看民宿信息,查看留言板,修改个人信息,提交订单,查看我的订单等功能。

环境需要

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

	response.setContentType("text/html");
	PrintWriter out = response.getWriter();
	String name=request.getParameter("name");
	String fang=request.getParameter("fang");
	String count=request.getParameter("count");
	String bdate=request.getParameter("bdate");
	String edate=request.getParameter("edate");
	String tel=request.getParameter("tel");
	String fangkuan=request.getParameter("fangkuan");
	String dingjin=request.getParameter("dingjin");
	String ism=request.getParameter("ism");
	String mtel=request.getParameter("mtel");

	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+"')";
	System.out.println(sql);

	Statement stat = null;
	Connection conn = null;
	DBManager dbm = new DBManager();
	try {
		conn = dbm.getConnection();
		stat = conn.createStatement();
		stat.execute(sql);
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} finally {
		try {
			if (stat != null)
				stat.close();
			if (conn != null)
				conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	out
	out.flush();
	out.close();
}

public void doGet(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {

		
		String sql = "update jiudian set name='"+name+"',dizhi='"+dizhi+"',info='"+info+"',pic='"+pic+"',tel='"+tel+"',style='"+style+"' where id="+id;
		System.out.println(sql);

		Statement stat = null;
		Connection conn=null;
		try {
			conn=dbm.getConnection();
			stat = conn.createStatement();
			stat.execute(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if(stat!=null)
					stat.close();
				if(conn!=null)
					conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		response.sendRedirect("admin/jiudian/list.jsp");
		out.flush();
		out.close();
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}
package com.biyeseng.action;

 * Constructor of the object.	
 */	
public AddKefangAction() {	
	super();	
}	

/**	
 * Destruction of the servlet. <br>	
 */	
public void destroy() {	
	super.destroy(); // Just puts "destroy" string in log	
	// Put your code here	
}	

/**	
 * The doPost method of the servlet. <br>	
 *	
 * This method is called when a form has its tag value method equals to post.	
 * 	
 * @param request the request send by the client to the server	
 * @param response the response send by the server to the client	
 * @throws ServletException if an error occurred	
 * @throws IOException if an error occurred	
 */	
public void doPost(HttpServletRequest request, HttpServletResponse response)	
		throws ServletException, IOException {	

	response.setContentType("text/html");	
	PrintWriter out = response.getWriter();	
	String jid=request.getParameter("jid");
	String name=request.getParameter("name");
	String chuang=request.getParameter("chuang");
	String ren=request.getParameter("ren");
	String price=request.getParameter("price");
	String type=request.getParameter("type");
	String state="";
	DBManager dbm = new DBManager();	
	String sql = "insert into kefang(jid,name,chuang,ren,price,type,state) values("+jid+",'"+name+"','"+chuang+"','"+ren+"','"+price+"','"+type+"','"+state+"')";	
	System.out.println(sql);	

	Statement stat = null;	
	Connection conn=null;	
	try {	
		conn=dbm.getConnection();	

 */
public ModNewsAction() {
	super();
}

/**
 * Destruction of the servlet. <br>
 */
public void destroy() {
	super.destroy(); // Just puts "destroy" string in log
	// Put your code here
}

/**
 * The doPost method of the servlet. <br>
 *
 * This method is called when a form has its tag value method equals to post.
 * 
 * @param request the request send by the client to the server
 * @param response the response send by the server to the client
 * @throws ServletException if an error occurred
 * @throws IOException if an error occurred
 */
public void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {

	response.setContentType("text/html");
	PrintWriter out = response.getWriter();
	String id = request.getParameter("id");
	String title=request.getParameter("title");
	String info=request.getParameter("info");
	DBManager dbm = new DBManager();
	if(info!=null){
		info=dbm.TextToHtml(info);
	}
	String date=new Date().toLocaleString();
	Object user=request.getSession().getAttribute("user");
	
	String appuser="";
	if(user!=null && appuser.toString()!=null){
		appuser=(String) user;

		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		String name=request.getParameter("name");
		String pwd=request.getParameter("pwd");
		String sex=request.getParameter("sex");
		String age=request.getParameter("age");
		String tel=request.getParameter("tel");
		String question=request.getParameter("question");
		String answer=request.getParameter("answer");
		
		DBManager dbm = new DBManager();
		String sql = "insert into userinfo(name,pwd,sex,age,tel,question,answer)  values('"+name+"','"+pwd+"','"+sex+"','"+age+"','"+tel+"','"+question+"','"+answer+"')";

		Statement stat = null;
		Connection conn=null;
		try {
			conn=dbm.getConnection();
			stat = conn.createStatement();
			System.out.println(sql+"-----");
			stat.execute(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if(stat!=null)
					stat.close();
				if(conn!=null)
					conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		response.sendRedirect("admin/user/list.jsp");
		out.flush();
		out.close();
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}
package com.biyeseng.action;

			conn=dbm.getConnection();
			stat = conn.createStatement();
			System.out.println(sql+"-----");
			stat.execute(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if(stat!=null)
					stat.close();
				if(conn!=null)
					conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		response.sendRedirect("admin/user/list.jsp");
		out.flush();
		out.close();
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}
package com.biyeseng.action;




/**
 * 删除新闻
 * 

---

项目链接：
https://javayms.github.io?id=301122532008200qq
https://javayms.pages.dev?id=301122532008200qq