基于javaweb+mysql的jsp+servlet民宿预订信息管理平台(java+jsp+javascript+servlet+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的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
使用说明
- 使用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
}
/**
* 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 name = request.getParameter("name");
String pwd = request.getParameter("pwd");
String sex = request.getParameter("sex");
String age = request.getParameter("age");
String type=request.getParameter("type");
DBManager dbm = new DBManager();
String sql = "update userinfo set name='"+name+"',pwd='"+pwd+"',sex='"+sex+"',age='"+age+"',grade='"+type+"' 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();
*
* @throws ServletException
* if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
/**
* 修改新闻
*
*
*/
public class YudingJiuAction extends HttpServlet {
/**
* Constructor of the object.
*/
public YudingJiuAction() {
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
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
}
}
/**
* 添加留言
*
*/
public class AddMsgAction extends HttpServlet {
/**
* Constructor of the object.
*/
public AddMsgAction() {
super();
}
/**
* Destruction of the servlet. <br>
*/
/**
* 添加学生
*
*/
public class AddUserAction extends HttpServlet {
/**
* Constructor of the object.
*/
public AddUserAction() {
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 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+"')";
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();
}
}
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException
* if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
*/
public class AddUserAction extends HttpServlet {
/**
* Constructor of the object.
*/
public AddUserAction() {
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 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();
/**
* 修改新闻
*
*/
public class ModJiudianAction extends HttpServlet {
/**
* Constructor of the object.
*/
public ModJiudianAction() {
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 name=request.getParameter("name");
String dizhi=request.getParameter("dizhi");
String info=request.getParameter("info");
String pic=request.getParameter("fujian");
String tel=request.getParameter("tel");
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();
}
}
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
/**
* 修改新闻
*
*/
public class ModNewsAction extends HttpServlet {
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @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 doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* 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)
public ModUserFrAction() {
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 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 email = request.getParameter("email");
String address = request.getParameter("address");
DBManager dbm = new DBManager();
String sql = "update userinfo set pwd='"+pwd+"', name='"+name+"',sex='"+sex+"',age='"+age+"',email='"+email+"',address='"+address+"' where tel='"+tel+"'";
System.out.println(sql);
/**
* 用户注册
*
*/
public class UserRegAction extends HttpServlet {
/**
* Constructor of the object.
*/
public UserRegAction() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @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 doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
*/
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 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();
}
}
// info=dbm.TextToHtml(info);
// }
String date=new Date().toLocaleString();
if(pic != null) {
pic = pic.replaceAll("/upload", "upload");
}
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
}
*
*/
public class AddMsgAction extends HttpServlet {
/**
* Constructor of the object.
*/
public AddMsgAction() {
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();
DBManager dbm = new DBManager();
String msg=request.getParameter("msg");
if(msg!=null){
msg=dbm.TextToHtml(msg);
}
String date=new Date().toLocaleString();
/**
* 添加留言
*
*/
public class AddMsgAction extends HttpServlet {
/**
* Constructor of the object.
*/
public AddMsgAction() {
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();
DBManager dbm = new DBManager();
PrintWriter out = response.getWriter();
DBManager dbm = new DBManager();
String name=request.getParameter("name");
String dizhi=request.getParameter("dizhi");
String info=request.getParameter("info");
String pic=request.getParameter("fujian");
String tel=request.getParameter("tel");
String style=request.getParameter("style");
String date = new Date().toLocaleString();
Object user = request.getSession().getAttribute("user");
String appuser = "";
if (user != null && appuser.toString() != null) {
appuser = (String) user;
}
if(pic != null) {
pic = pic.replaceAll("/upload", "upload");
}
String sql = "insert into jiudian(name,dizhi,info,pic,tel,style) values('"+name+"','"+dizhi+"','"+info+"','"+pic+"','"+tel+"','"+style+"')";
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)
*/
public void init() throws ServletException {
// Put your code here
}
}
/**
* 添加留言
*
*/
public class AddMsgAction extends HttpServlet {
/**
* Constructor of the object.
*/
public AddMsgAction() {
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