定制开发基于Java Web的酒店管理系统

目录

1.系统概述

定制开发此次系统功能较为简单。定制开发开发模式为：JSP++JavaBean,另外需要MyElicpe、MySQL、Tomact服务器等。

2.系统功能

定制开发本系统主要功能是管理定制开发员进行日常酒店管理操作，定制开发例如登记住房信息、定制开发查询客房信息、定制开发修改客房信息、定制开发删除客房信息、定制开发添加客房信息，定制开发另外是结算退房功能。

3.定制开发所用数据库表

1.user（员工表）

2.member(会员表)

3.house(房型表)

4.定制开发具体功能实现

4.1 登录功能

login.jsp

  1. <body background="image/3.jpg">
  2. 	<form name="form1" action="loginservlet?method=login" method="post">
  3. 		<p id=jerry>酒店管理系统</p>
  4. 		<table width="300" border="1" align="center" height="200">
  5. 			<tr id="tb">
  6. 				<td colspan="2" align="center">系统登录</td>
  7. 			</tr>
  8. 			<tr id="tb">
  9. 				<td>工号</td>
  10. 				<td><input type="text" name="username" size="20"></td>
  11. 			</tr>
  12. 			<tr id="tb">
  13. 				<td>密码</td>
  14. 				<td><input type="password" name="password" size="20"></td>
  15. 			</tr>
  16. 			<tr>
  17. 			</tr>
  18. 			<tr id="tb">
  19. 				<td colspan="2"><input type="submit" name="submit" value="登录">
  20. 					<a href="register.jsp">注册新用户</a></td>
  21. 			</tr>
  22. 		</table>
  23. 	</form>
  24.  
  25. </body>

 register.jsp

  1. <body background="image/3.jpg">
  2. 	<form name="form1" action="loginservlet?method=register" method="post">
  3. 		<p id=jerry>酒店管理系统</p>
  4. 		<table width="300" border="1" align="center">
  5. 			<tr>
  6. 				<td colspan="2" align="center">注册窗口</td>
  7. 			</tr>
  8. 			<tr>
  9. 				<td>用户名</td>
  10. 				<td><input type="text" name="username"></td>
  11. 			</tr>
  12. 			<tr>
  13. 				<td>密码</td>
  14. 				<td><input type="password" name="password1"></td>
  15. 			</tr>
  16. 			<tr>
  17. 				<td>确认密码</td>
  18. 				<td><input type="password" name="password2"></td>
  19. 			</tr>
  20. 			<tr>
  21. 				<td>Email</td>
  22. 				<td><input type="text" name="email"></td>
  23. 			</tr>
  24. 			<tr>
  25. 				<td colspan="2"><input type="submit" name="submit" value="注册">
  26. 					<a href="login.jsp">返回</a></td>
  27. 			</tr>
  28. 		</table>
  29. 	</form>
  30. </body>

loginServlet

  1. @WebServlet(urlPatterns="/loginservlet")
  2. public class loginServlet extends HttpServlet{
  3. 	@Override
  4. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  5. 		// TODO 自动生成的方法存根
  6. 		String method=request.getParameter("method");
  7. 		if("login".equals(method)){
  8. 			doLogin(request,response);
  9. 		}
  10. 		else if("logout".equals(method)){
  11. 			doLogout(request,response);
  12. 		}
  13. 		else if("register".equals(method)){
  14. 			doAdd(request,response);
  15. 		}
  16.  
  17. 	}
  18. 	//用户注册
  19. 	private void doAdd(HttpServletRequest request, HttpServletResponse response)throws ServletException,IOException {
  20. 		// TODO 自动生成的方法存根
  21. 		request.setCharacterEncoding("utf-8");
  22. 		response.setCharacterEncoding("utf-8");
  23. 		response.setContentType("text/html;charset=utf-8");
  24. 		String username=request.getParameter("username");
  25. 		String password1=request.getParameter("password1");
  26. 		String password2=request.getParameter("password2");
  27. 		String email=request.getParameter("email");
  28. 		if(!"".equals(username)&&password1.equals(password2)){
  29. 			UserBean user_bean=new UserBean();
  30. 			user_bean.add(username, password1, email);
  31. 			System.out.println("注册成功！");
  32. 			response.sendRedirect("login.jsp");
  33. 		}
  34. 		else {
  35. 			System.out.println("注册失败！");
  36. 			response.sendRedirect("login.jsp");
  37. 		}
  38. 	}
  39. 	//登录
  40. 	private void doLogin(HttpServletRequest request, HttpServletResponse response)throws ServletException,IOException {
  41. 		// TODO 自动生成的方法存根
  42. 		request.setCharacterEncoding("utf-8");
  43. 		response.setCharacterEncoding("utf-8");
  44. 		response.setContentType("text/html;charset=utf-8");
  45. 		String username=request.getParameter("username");
  46. 		String password=request.getParameter("password");
  47. 		UserBean user_bean=new UserBean();
  48. 		if(user_bean.isExist(username)){
  49. 			if(user_bean.valid(username, password)){
  50. 				HttpSession session=request.getSession();
  51. 				session.setAttribute("username",username);
  52. 				System.out.println("登录成功");
  53. 				response.sendRedirect("welcome.jsp");
  54. 			}
  55. 			else {//密码错误
  56. 				System.out.println("登录失败1");
  57. 				response.sendRedirect("login.jsp");
  58. 			}
  59. 		}
  60. 		else {
  61. 			System.out.println("登录失败2");
  62. 			response.sendRedirect("login.jsp");
  63. 		}
  64. 	}
  65. 	//退出登录
  66. 	protected void doLogout(HttpServletRequest request,
  67. 			HttpServletResponse response) throws ServletException, IOException {
  68. 		HttpSession session = request.getSession();
  69. 		session.removeAttribute("username");
  70. 		System.out.println("退出成功");
  71. 		response.sendRedirect("login.jsp");
  72. 	}
  73. 	@Override
  74. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  75. 		// TODO 自动生成的方法存根
  76. 		request.setCharacterEncoding("utf-8");
  77. 		doGet(request, response);
  78. 	}
  79. }

4.2 欢迎页面

 welcome.jsp

  1. <body background="image/3.jpg">
  2.  
  3. 	<table width="100%">
  4. 		<p id="ss" class="text">酒店管理系统</p>
  5. 		<%
  6. 			Calendar cal = Calendar.getInstance();
  7. 			SimpleDateFormat format = new SimpleDateFormat("dd日-MM月-yyyy年 HH:mm:ss");
  8. 		%>
  9. 		<tr>
  10. 			<td colspan="2" align="right">登陆成功！欢迎你，<%=(String) session.getAttribute("username")%>
  11. 			</td>
  12. 			<td align="right">
  13. 				<%
  14. 					out.println(format.format(cal.getTime()));
  15. 				%>
  16. 			</td>
  17. 		</tr>
  18.  
  19. 		<tr>
  20. 			<td colspan="3">
  21. 				<hr>
  22. 			</td>
  23. 		</tr>
  24. 		<tr>
  25. 			<td><br> <br> <br> <br> <br> <br>
  26. 			</td>
  27. 		</tr>
  28. 		<tr>
  29. 			<td colspan="3">
  30. 				<form name="form1" action="loginservlet?method=logout" method="post">
  31. 					<table width="450" height="300" border="1" align="center" id="tom">
  32. 						<tr>
  33. 							<th colspan="3" align="center">选择功能</th>
  34. 						</tr>
  35. 						<tr>
  36. 							<td><a class="a" href="pageservlet?method=showHouse">客房列表</a></td>
  37.  
  38. 							<td><a class="a" href="addhouse.jsp">添加客房</a></td>
  39. 						</tr>
  40. 						<tr>
  41. 							<td><a class="a" href="inhouse.jsp">住房登记</a></td>
  42.  
  43. 							<td><a class="a" href="pageservlet?method=showMember">退房登记</a></td>
  44. 						</tr>
  45. 						<tr>
  46. 							<td colspan="3" align="center"><input type="submit"
  47. 								name="submit" value="退出"></td>
  48. 						</tr>
  49. 					</table>
  50. 				</form>
  51. 			</td>
  52. 		</tr>
  53.  
  54. 		</div>
  55. </body>

4.3 客房列表功能

 hotelBean.java

  1. public class hotel {
  2. private String name;//房间名称
  3. private int price;//房间价格
  4. private int amount;//房间价格
  5. private String square;//房间面积
  6. private int people;//房间可住人数
  7. public final static int maxpage=4;
  8. public String getName() {
  9. 	return name;
  10. }
  11. public void setName(String name) {
  12. 	this.name = name;
  13. }
  14. public int getPrice() {
  15. 	return price;
  16. }
  17. public void setPrice(int price) {
  18. 	this.price = price;
  19. }
  20. public int getAmount() {
  21. 	return amount;
  22. }
  23. public void setAmount(int amount) {
  24. 	this.amount = amount;
  25. }
  26. public String getSquare() {
  27. 	return square;
  28. }
  29. public void setSquare(String square) {
  30. 	this.square = square;
  31. }
  32. public int getPeople() {
  33. 	return people;
  34. }
  35. public void setPeople(int people) {
  36. 	this.people = people;
  37. }
  38. }

houseDao

  1. public class houseDao {
  2. 	DBAccess db=new DBAccess();
  3. 	public ArrayList<hotel>allhotel(){//显示全部房间
  4. 		ArrayList<hotel>list=new ArrayList<hotel>();
  5. 		if(db.createConn()){
  6. 			String sql="select * from house";
  7. 			try {
  8. 				db.query(sql);
  9. 				while(db.next()){
  10. 					hotel ho=new hotel();
  11. 					ho.setName(db.getRs().getString("name"));
  12. 					ho.setPrice(db.getRs().getInt("price"));
  13. 					ho.setAmount(db.getRs().getInt("amount"));
  14. 					ho.setSquare(db.getRs().getString("square"));
  15. 					ho.setPeople(db.getRs().getInt("people"));
  16. 					list.add(ho);
  17. 				}
  18.  
  19. 			} catch (SQLException e) {
  20. 				// TODO 自动生成的 catch 块
  21. 				e.printStackTrace();
  22. 			}
  23. 			finally {
  24. 				db.closeRs();
  25. 				db.closeStm();
  26. 				db.closeConn();
  27. 			}
  28. 		}
  29. 		return list;
  30. 	}
  31. 	public hotel show(String name){//显示房间信息
  32. 		hotel ho=new hotel();
  33. 		if(db.createConn()){
  34. 			String sql="select * from house where name=?";
  35. 			try {
  36. 				db.pre=db.getConn().prepareStatement(sql);
  37. 				db.pre.setString(1, name);
  38. 				db.setRs(db.pre.executeQuery());
  39. 				if(db.getRs().next()){
  40.  
  41. 					ho.setName(db.getRs().getString("name"));
  42. 					ho.setPrice(db.getRs().getInt("price"));
  43. 					ho.setAmount(db.getRs().getInt("amount"));
  44. 					ho.setSquare(db.getRs().getString("square"));
  45. 					ho.setPeople(db.getRs().getInt("people"));
  46. 				}
  47. 			} catch (SQLException e) {
  48. 				// TODO 自动生成的 catch 块
  49. 				e.printStackTrace();
  50. 			}
  51. 			finally {
  52. 				db.closeRs();
  53. 				if(db.pre!=null){
  54. 					try {
  55. 						db.pre.close();
  56. 					} catch (SQLException e) {
  57. 						// TODO 自动生成的 catch 块
  58. 						e.printStackTrace();
  59. 					}
  60. 					db.closeConn();
  61. 				}
  62. 			}
  63. 		}
  64. 		return ho;
  65. 	}
  66. 	public boolean updatehotel(hotel ho) throws Exception{//修改房间  
  67. 		boolean flag = false;
  68. 		DBAccess db=new DBAccess();
  69. 		if(db.createConn()){
  70. 			String sql="UPDATE house SET name=?,price=?,amount=?,square=?,people=? where name=?";
  71. 			db.pre=db.getConn().prepareStatement(sql);
  72. 			db.pre.setString(1, ho.getName());
  73. 			db.pre.setInt(2, ho.getPrice());
  74. 			db.pre.setInt(3, ho.getAmount());
  75. 			db.pre.setString(4, ho.getSquare());
  76. 			db.pre.setInt(5, ho.getPeople());
  77. 			db.pre.setString(6, ho.getName());
  78. 			if(db.pre.executeUpdate() > 0) flag = true;
  79. 		}
  80. 		db.closeRs();
  81. 		db.closeStm();
  82. 		db.pre.close();
  83. 		db.closeConn();
  84. 		return flag;
  85. 	}
  86. 	public boolean updateamount(hotel ho){//更新房间数量
  87. 		boolean flag = false;
  88. 		DBAccess db=new DBAccess();
  89. 		if(db.createConn()){
  90. 			String sql="update house set amount=? where name=?";
  91. 			try {
  92. 				db.pre=db.getConn().prepareStatement(sql);
  93. 				db.pre.setInt(1,ho.getAmount() );
  94. 				db.pre.setString(2, ho.getName());
  95. 				if(db.pre.executeUpdate()>0) flag=true;
  96. 			} catch (SQLException e) {
  97. 				// TODO 自动生成的 catch 块
  98. 				e.printStackTrace();
  99. 			}finally {
  100. 				try {
  101. 					db.pre.close();
  102. 				} catch (SQLException e) {
  103. 					// TODO 自动生成的 catch 块
  104. 					e.printStackTrace();
  105. 				}
  106. 				db.closeConn();
  107. 			}
  108. 		}
  109. 		return flag;
  110. 	}
  111. 	public boolean add(hotel ho) throws Exception{//添加房间
  112. 		boolean flag = false;
  113. 		DBAccess db=new DBAccess();
  114. 		if(db.createConn()){
  115. 			String sql = "INSERT INTO house(name,price,amount,square,people) VALUES(?,?,?,?,?)";
  116. 			db.pre=db.getConn().prepareStatement(sql);
  117. 			db.pre.setString(1, ho.getName());
  118. 			db.pre.setInt(2, ho.getPrice());
  119. 			db.pre.setInt(3, ho.getAmount());
  120. 			db.pre.setString(4, ho.getSquare());
  121. 			db.pre.setInt(5, ho.getPeople());
  122. 			if(db.pre.executeUpdate() > 0) flag = true;
  123. 		}
  124. 		db.closeRs();
  125. 		db.closeStm();
  126. 		db.pre.close();
  127. 		db.closeConn();
  128. 		return flag;
  129. 	}
  130. 	public boolean delHouse(String name) throws Exception{//删除房间
  131. 		DBAccess db=new DBAccess();
  132. 		boolean flag = false;
  133. 		String sql="DELETE FROM house WHERE name = ?";
  134. 		if(db.createConn()){
  135. 			db.pre=db.getConn().prepareStatement(sql);
  136. 			db.pre.setString(1, name);
  137. 			if(db.pre.executeUpdate()>0)flag=true;
  138. 		}
  139. 		db.closeConn();
  140. 		db.closeStm();
  141. 		db.pre.close();
  142. 		db.closeRs();
  143. 		return flag;
  144. 	}
  145. 	public ArrayList<hotel> findAll(Integer page){//分页查询信息
  146. 		DBAccess  db=new DBAccess();
  147. 		ArrayList<hotel> list=new ArrayList<hotel>();
  148. 		
  149. 		try {
  150. 			if(db.createConn()){
  151. 				String sql="select  * from house limit ?,? ";
  152. 				db.pre=db.getConn().prepareStatement(sql);
  153. 				db.pre.setInt(1, (page-1)*hotel.maxpage);
  154. 				db.pre.setInt(2, hotel.maxpage);
  155. 				db.setRs(db.pre.executeQuery());
  156. 				while(db.getRs().next()){
  157. 					hotel ho=new hotel();
  158. 					ho.setName(db.getRs().getString("name"));
  159. 					ho.setPrice(db.getRs().getInt("price"));
  160. 					ho.setAmount(db.getRs().getInt("amount"));
  161. 					ho.setSquare(db.getRs().getString("square"));
  162. 					ho.setPeople(db.getRs().getInt("people"));
  163. 					list.add(ho);
  164. 				}
  165. 				db.closeRs();
  166. 				db.pre.close();
  167. 				db.closeConn();
  168. 			}
  169. 		} catch( SQLException e) {
  170. 			e.printStackTrace();
  171. 		}
  172. 		return list;
  173. 	}
  174. 	public int countPage(){//查询记录总数
  175. 		DBAccess  db=new DBAccess();
  176. 		int count=0;
  177. 		try {
  178. 			if(db.createConn()){
  179. 				String sql="select count(*) from house  ";
  180. 				db.pre=db.getConn().prepareStatement(sql);
  181. 				db.setRs(db.pre.executeQuery());
  182. 				if(db.getRs().next()){
  183. 					count=db.getRs().getInt(1);
  184. 				}
  185. 			}
  186. 		} catch( SQLException e) {
  187. 			e.printStackTrace();
  188. 		}
  189. 		finally {
  190. 			db.closeRs();
  191. 			try {
  192. 				if(db.pre!=null){
  193. 					db.pre.close();
  194. 				}
  195. 			} catch (Exception e2) {
  196. 				// TODO: handle exception
  197. 			}
  198. 			db.closeConn();
  199. 		}
  200. 		return count;
  201. 	}
  202. }

housemanageServlet

  1. @WebServlet(urlPatterns="/houseServlet")
  2. public class housemanageServlet extends HttpServlet{
  3. 	@Override
  4. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  5. 		// TODO 自动生成的方法存根
  6. 		request.setCharacterEncoding("utf-8");
  7. 		String method=request.getParameter("method");
  8. 		if("show".equals(method)){
  9. 			doShow(request,response);
  10. 		}
  11. 		else if("add".equals(method)){
  12. 			doAdd(request,response);
  13. 		}
  14. 		else if("show2".equals(method)){
  15. 			doShow2(request,response);
  16. 		}
  17. 		else if("update".equals(method)){
  18. 			doUpdate(request,response);
  19. 		}
  20. 		else if("update2".equals(method)){
  21. 			doUpdate2(request,response);
  22. 		}
  23. 		else if("delete".equals(method)){
  24. 			doDel(request,response);
  25. 		}
  26.  
  27. 	}
  28. 	//删除客房
  29. 	private void doDel(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
  30. 		// TODO 自动生成的方法存根
  31. 		request.setCharacterEncoding("utf-8");
  32. 		String name=request.getParameter("category");
  33. 		houseDao house=new houseDao();
  34. 		try {
  35. 			if(house.delHouse(name)){
  36. 				System.out.println("删除成功！");
  37. 				response.sendRedirect("showhouse.jsp");//删除之后无法立马更新数据
  38. 				return;
  39. 			}
  40. 			else {
  41. 				System.out.println("删除失败！");
  42. 				response.sendRedirect("showhouse.jsp");
  43. 			}
  44. 		} catch (Exception e) {
  45. 			// TODO 自动生成的 catch 块
  46. 			e.printStackTrace();
  47. 		}
  48. 	}
  49. 	//修改客房信息
  50. 	private void doUpdate2(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException  {
  51. 		// TODO 自动生成的方法存根
  52. 		request.setCharacterEncoding("utf-8");
  53. 		String name=request.getParameter("name");
  54. 		int price=Integer.parseInt(request.getParameter("price"));
  55. 		int amount=Integer.parseInt(request.getParameter("amount"));
  56. 		String square=request.getParameter("square");
  57. 		int people=Integer.parseInt(request.getParameter("people"));
  58. 		houseDao house=new houseDao();
  59. 		hotel ho=new hotel();
  60. 		ho.setName(name);
  61. 		ho.setPrice(price);
  62. 		ho.setAmount(amount);
  63. 		ho.setSquare(square);
  64. 		ho.setPeople(people);
  65. 		try {
  66. 			if(house.updatehotel(ho)){
  67. 				System.out.println("修改成功！");
  68. 				response.sendRedirect("showhouse.jsp");
  69. 				return;
  70. 			}
  71. 			else {
  72. 				System.out.println("修改失败！");
  73. 				response.sendRedirect("showhouse.jsp");
  74. 			}
  75. 		} catch (Exception e) {
  76. 			// TODO 自动生成的 catch 块
  77. 			e.printStackTrace();
  78. 		}
  79. 	}
  80. 	//用来重定向到修改页面
  81. 	private void doUpdate(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//重定向到 update.jsp
  82. 		// TODO 自动生成的方法存根
  83. 		request.setCharacterEncoding("utf-8");
  84. 		String name=request.getParameter("category");
  85. 		houseDao house=new houseDao();
  86. 		hotel ho=house.show(name);
  87. 		request.setAttribute("ho", ho);
  88. 		request.getRequestDispatcher("update.jsp").forward(request, response);
  89. 	}
  90. 	//显示客房具体信息
  91. 	private void doShow2(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
  92. 		// TODO 自动生成的方法存根
  93. 		request.setCharacterEncoding("utf-8");
  94. 		String name=request.getParameter("category");
  95. 		houseDao house=new houseDao();
  96. 		hotel ho=house.show(name);
  97. 		HttpSession session=request.getSession();
  98. 		session.setAttribute("ho", ho);
  99. 		response.sendRedirect("showhouse2.jsp");
  100. 	}
  101. 	//添加客房
  102. 	private void doAdd(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
  103. 		// TODO 自动生成的方法存根
  104. 		request.setCharacterEncoding("utf-8");
  105. 		String name=request.getParameter("name");
  106. 		int price=Integer.parseInt(request.getParameter("price"));
  107. 		int amount=Integer.parseInt(request.getParameter("amount"));
  108. 		String square=request.getParameter("square");
  109. 		int people=Integer.parseInt(request.getParameter("people"));
  110. 		houseDao house=new houseDao();
  111. 		hotel ho=new hotel();
  112. 		if(!"".equals(name)&&!"".equals(square)&&0!=price&&0!=amount&&people!=0){
  113. 			ho.setName(name);
  114. 			ho.setPrice(price);
  115. 			ho.setAmount(amount);
  116. 			ho.setSquare(square);
  117. 			ho.setPeople(people);
  118. 		}
  119. 		else {
  120. 			System.out.println("添加失败，信息不全");
  121. 			response.sendRedirect("addhouse.jsp");
  122. 		}
  123. 		try {
  124. 			if(house.add(ho)){
  125. 				System.out.println("添加成功！");
  126. 				response.sendRedirect("addhouse.jsp");
  127. 			}
  128. 		} catch (Exception e) {
  129. 			// TODO 自动生成的 catch 块
  130. 			e.printStackTrace();
  131. 		}
  132. 	}
  133. 	//显示所有客房信息
  134. 	private void doShow(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
  135. 		// TODO 自动生成的方法存根
  136. 		houseDao house_dao=new houseDao();
  137. 		ArrayList<hotel> house=house_dao.allhotel();
  138. 		HttpSession session=request.getSession();
  139. 		session.setAttribute("house", house);
  140. 		response.sendRedirect("showhouse.jsp");
  141. 	}
  142. 	@Override
  143. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  144. 		// TODO 自动生成的方法存根
  145. 		doGet(request, response);
  146. 	}
  147. }

showhouse.jsp(全部)

  1. <body background="image/3.jpg">
  2. 	<table width="100%">
  3. 		<p id="ss">酒店管理系统</p>
  4. 		<%
  5. 			Calendar cal = Calendar.getInstance();
  6. 			SimpleDateFormat format = new SimpleDateFormat("dd日-MM月-yyyy年 HH:mm:ss");
  7. 		%>
  8. 		<tr>
  9. 			<td colspan="2" align="right">登陆成功！欢迎你，<%=(String) session.getAttribute("username")%>
  10. 			</td>
  11. 			<td align="right">
  12. 				<%
  13. 					out.println(format.format(cal.getTime()));
  14. 				%>
  15. 			</td>
  16. 		</tr>
  17.  
  18. 		<tr>
  19. 			<td colspan="3">
  20. 				<hr>
  21. 			</td>
  22. 		</tr>
  23. 		<tr>
  24. 			<td><a href="welcome.jsp">返回</a></td>
  25. 		</tr>
  26. 		<tr>
  27. 			<td><br> <br> <br> <br> <br> <br>
  28. 			</td>
  29. 		</tr>
  30. 	</table>
  31. 	<h2 align="center">所有客房信息</h2>
  32. 	<table width="400" height="200" border="1" align="center">
  33. 		<tr>
  34. 			<td align="center">房间类型</td>
  35. 			<td align="center">房型价格</td>
  36. 			<td align="center">可预定数量</td>
  37. 			<td align="center">操作</td>
  38. 		</tr>
  39. 		<%
  40. 			for (hotel ho : hotels) {
  41. 		%>
  42. 		<tr>
  43. 			<td align="center"><%=ho.getName()%></td>
  44. 			<td align="center"><%=ho.getPrice()%>￥</td>
  45. 			<td align="center"><%=ho.getAmount()%></td>
  46. 			<td><a
  47. 				href="houseServlet?method=show2&category=<%=ho.getName()%>">查看</a>
  48. 				<a href="houseServlet?method=update&category=<%=ho.getName()%>">修改</a>
  49. 				<a href="houseServlet?method=delete&category=<%=ho.getName()%>">删除</a>
  50. 			</td>
  51. 		</tr>
  52. 		<%
  53. 			}
  54. 		%>
  55. 		<tr>
  56. 			<td align="center" colspan="6" bgcolor="gray">
  57. 				<%--<%=request.getAttribute("bar")  /页 --%> ${bar}/页
  58. 			</td>
  59. 		</tr>
  60. 	</table>
  61. </body>

4.4 查看房型详细信息

4.5 修改客房信息

 4.6 添加客房信息

4.7 住房登记

 memberBean.java

  1. public class member {
  2. private String name;//会员名
  3. private String tel;//手机号
  4. private String category;//房间类型
  5. private String hotelnumber;//房间号
  6. private int people;//入住人数
  7. private String money;//消费
  8. public String getName() {
  9. 	return name;
  10. }
  11. public void setName(String name) {
  12. 	this.name = name;
  13. }
  14. public String getTel() {
  15. 	return tel;
  16. }
  17. public void setTel(String tel) {
  18. 	this.tel = tel;
  19. }
  20. public String getCategory() {
  21. 	return category;
  22. }
  23. public void setCategory(String category) {
  24. 	this.category = category;
  25. }
  26. public String getHotelnumber() {
  27. 	return hotelnumber;
  28. }
  29. public void setHotelnumber(String hotelnumber) {
  30. 	this.hotelnumber = hotelnumber;
  31. }
  32. public int getPeople() {
  33. 	return people;
  34. }
  35. public void setPeople(int people) {
  36. 	this.people = people;
  37. }
  38. public String getMoney() {
  39. 	return money;
  40. }
  41. public void setMoney(String money) {
  42. 	this.money = money;
  43. }
  44.  
  45. }

 memberDao

  1. public class memberDao {
  2. 	DBAccess db=new DBAccess();
  3.  
  4. 	public boolean add(member me) throws Exception{//添加会员
  5. 		boolean flag = false;
  6. 		if(db.createConn()){
  7. 			String sql = "INSERT INTO member(name,tel,category,hotelnumber,people,money) VALUES(?,?,?,?,?,?)";
  8. 			db.pre=db.getConn().prepareStatement(sql);
  9. 			db.pre.setString(1, me.getName());
  10. 			db.pre.setString(2, me.getTel());
  11. 			db.pre.setString(3, me.getCategory());
  12. 			db.pre.setString(4, me.getHotelnumber());
  13. 			db.pre.setInt(5, me.getPeople());
  14. 			db.pre.setString(6, me.getMoney());
  15. 			if(db.pre.executeUpdate() > 0) flag = true;
  16. 		}
  17. 		db.closeRs();
  18. 		db.closeStm();
  19. 		db.pre.close();
  20. 		db.closeConn();
  21. 		return flag;
  22. 	}
  23. 	public ArrayList<member> allmember(){//显示所有会员
  24. 		ArrayList<member>list=new ArrayList<member>();
  25. 		if(db.createConn()){
  26. 			String sql="select * from member";
  27. 			try {
  28. 				db.query(sql);
  29. 				while(db.next()){
  30. 					member me=new member();
  31. 					me.setName(db.getRs().getString("name"));
  32. 					me.setTel(db.getRs().getString("tel"));
  33. 					me.setCategory(db.getRs().getString("category"));
  34. 					me.setHotelnumber(db.getRs().getString("hotelnumber"));
  35. 					me.setPeople(db.getRs().getInt("people"));
  36. 					me.setMoney(db.getRs().getString("money"));
  37. 					list.add(me);
  38. 				}
  39. 			} catch (SQLException e) {
  40. 				// TODO 自动生成的 catch 块
  41. 				e.printStackTrace();
  42. 			}
  43. 			finally {
  44. 				db.closeRs();
  45. 				db.closeStm();
  46. 				db.closeConn();
  47. 			}
  48. 		}
  49. 		return list;
  50. 	}
  51. 	public member showpersonal(String name){//显示会员详细信息
  52. 		member me=new member();
  53. 		if(db.createConn()){
  54. 			String sql="select * from member where name=?";
  55. 			try {
  56. 				db.pre=db.getConn().prepareStatement(sql);
  57. 				db.pre.setString(1, name);
  58. 				db.setRs(db.pre.executeQuery());
  59. 				if(db.getRs().next()){
  60.  
  61. 					me.setName(db.getRs().getString("name"));
  62. 					me.setTel(db.getRs().getString("tel"));
  63. 					me.setCategory(db.getRs().getString("category"));
  64. 					me.setHotelnumber(db.getRs().getString("hotelnumber"));
  65. 					me.setPeople(db.getRs().getInt("people"));
  66. 					me.setMoney(db.getRs().getString("money"));
  67. 				}
  68. 			} catch (SQLException e) {
  69. 				// TODO 自动生成的 catch 块
  70. 				e.printStackTrace();
  71. 			}
  72. 			finally {
  73. 				db.closeRs();
  74. 				if(db.pre!=null){
  75. 					try {
  76. 						db.pre.close();
  77. 					} catch (SQLException e) {
  78. 						// TODO 自动生成的 catch 块
  79. 						e.printStackTrace();
  80. 					}
  81. 					db.closeConn();
  82. 				}
  83. 			}
  84. 		}
  85. 		return me;
  86. 	}
  87. 	public boolean delMember(String tel) throws Exception{//删除会员信息
  88. 		DBAccess db=new DBAccess();
  89. 		boolean flag = false;
  90. 		String sql="DELETE FROM member WHERE tel = ?";
  91. 		if(db.createConn()){
  92. 			db.pre=db.getConn().prepareStatement(sql);
  93. 			db.pre.setString(1, tel);
  94. 			if(db.pre.executeUpdate()>0)flag=true;
  95. 		}
  96. 		db.closeConn();
  97. 		db.closeStm();
  98. 		db.pre.close();
  99. 		db.closeRs();
  100. 		return flag;
  101. 	}
  102. 	public ArrayList<member> findAll(Integer page){//分页查询信息
  103. 		DBAccess  db=new DBAccess();
  104. 		ArrayList<member> list=new ArrayList<member>();
  105. 		
  106. 		try {
  107. 			if(db.createConn()){
  108. 				String sql="select  * from member limit ?,? ";
  109. 				db.pre=db.getConn().prepareStatement(sql);
  110. 				db.pre.setInt(1, (page-1)*hotel.maxpage);
  111. 				db.pre.setInt(2, hotel.maxpage);
  112. 				db.setRs(db.pre.executeQuery());
  113. 				while(db.getRs().next()){
  114. 					member me=new member();
  115. 					me.setName(db.getRs().getString("name"));
  116. 					me.setTel(db.getRs().getString("tel"));
  117. 					me.setCategory(db.getRs().getString("category"));
  118. 					me.setHotelnumber(db.getRs().getString("hotelnumber"));
  119. 					me.setPeople(db.getRs().getInt("people"));
  120. 					me.setMoney(db.getRs().getString("money"));
  121. 					list.add(me);
  122. 				}
  123. 				db.closeRs();
  124. 				db.pre.close();
  125. 				db.closeConn();
  126. 			}
  127. 		} catch( SQLException e) {
  128. 			e.printStackTrace();
  129. 		}
  130. 		return list;
  131. 	}
  132. 	public int countPage(){//查询记录总数
  133. 		DBAccess  db=new DBAccess();
  134. 		int count=0;
  135. 		try {
  136. 			if(db.createConn()){
  137. 				String sql="select count(*) from member  ";
  138. 				db.pre=db.getConn().prepareStatement(sql);
  139. 				db.setRs(db.pre.executeQuery());
  140. 				if(db.getRs().next()){
  141. 					count=db.getRs().getInt(1);
  142. 				}
  143. 			}
  144. 		} catch( SQLException e) {
  145. 			e.printStackTrace();
  146. 		}
  147. 		finally {
  148. 			db.closeRs();
  149. 			try {
  150. 				if(db.pre!=null){
  151. 					db.pre.close();
  152. 				}
  153. 			} catch (Exception e2) {
  154. 				// TODO: handle exception
  155. 			}
  156. 			db.closeConn();
  157. 		}
  158. 		return count;
  159. 	}
  160. }

membermanageServlet

  1. @WebServlet(urlPatterns="/membermanage")
  2. public class membermanageServlet extends HttpServlet{
  3. 	@Override
  4. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  5. 		// TODO 自动生成的方法存根
  6. 		request.setCharacterEncoding("utf-8");
  7. 		String method=request.getParameter("method");
  8. 		if("inroom".equals(method)){
  9. 			doInroom(request,response);
  10. 		}
  11. 		else if ("outroom".equals(method)) {
  12. 			doOutroom(request,response);
  13. 		}
  14. 		else if("personalmessage".equals(method)){
  15. 			doShowPerMessage(request,response);
  16. 		}
  17. 		else if("delmember".equals(method)){
  18. 			doDelMember(request,response);
  19. 		}
  20. 	}
  21. 	//退房操作
  22. 	private void doDelMember(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
  23. 		// TODO 自动生成的方法存根
  24. 		request.setCharacterEncoding("utf-8");
  25. 		String tel=request.getParameter("tel");
  26. 		String category=request.getParameter("category");
  27. 		houseDao house=new houseDao();
  28. 		memberDao member=new memberDao();
  29. 		hotel ho=null;
  30. 		try {
  31. 			if(member.delMember(tel)){
  32. 				ho=house.show(category);
  33. 				ho.setAmount(ho.getAmount()+1);//获取房型相关信息
  34. 				house.updateamount(ho);
  35. 				System.out.println("退房成功！");
  36. 				response.sendRedirect("welcome.jsp");
  37. 				return;
  38. 			}
  39. 		} catch (Exception e) {
  40. 			// TODO 自动生成的 catch 块
  41. 			e.printStackTrace();
  42. 		}
  43. 	}
  44. 	//显示会员信息
  45. 	private void doShowPerMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
  46. 		// TODO 自动生成的方法存根
  47. 		request.setCharacterEncoding("utf-8");
  48. 		String name=request.getParameter("name");
  49. 		memberDao member=new memberDao();
  50. 		member mb=member.showpersonal(name);
  51. 		HttpSession session=request.getSession();
  52. 		session.setAttribute("mb", mb);
  53. 		//request.setAttribute("mb", mb);
  54. 		response.sendRedirect("showmemberMassage.jsp");
  55. 		//request.getRequestDispatcher("showmemberMassage.jsp").forward(request, response);
  56.  
  57. 	}
  58. 	//住房登记
  59. 	private void doInroom(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
  60. 		// TODO 自动生成的方法存根
  61. 		request.setCharacterEncoding("utf-8");
  62. 		String name=request.getParameter("name");
  63. 		String tel=request.getParameter("tel");
  64. 		String category=request.getParameter("category");
  65. 		String housenumber=request.getParameter("housenumber");
  66. 		int people=Integer.parseInt(request.getParameter("people"));
  67. 		String money=request.getParameter("money");
  68. 		memberDao member =new memberDao();
  69. 		houseDao house=new houseDao();
  70. 		hotel ho=null;
  71. 		if(name!=null&&tel!=null&&category!=null&&housenumber!=null&&people!=0&&money!=null){
  72. 			member me=new member();
  73. 			me.setName(name);
  74. 			me.setTel(tel);
  75. 			me.setCategory(category);
  76. 			me.setHotelnumber(housenumber);
  77. 			me.setPeople(people);
  78. 			me.setMoney(money);
  79. 			try {
  80. 				ho=house.show(category);//根据房间类型获取房间
  81. 				if(member.add(me)&&ho.getAmount()>0){
  82. 					//System.out.println("添加会员成功！");
  83. 					ho.setAmount(ho.getAmount()-1);
  84. 					house.updateamount(ho);//更改房间数量
  85. 					System.out.println("添加会员成功！");
  86. 					response.sendRedirect("welcome.jsp");
  87. 				}
  88. 				else {
  89. 					System.out.println("添加会员失败，没有可用的房间！");
  90. 					response.sendRedirect("inhouse.jsp");
  91. 				}
  92. 			} catch (Exception e) {
  93. 				// TODO 自动生成的 catch 块
  94. 				e.printStackTrace();
  95. 			}
  96. 		}
  97. 		else {
  98. 			System.out.println("添加会员失败,信息不全！");
  99. 			response.sendRedirect("inhouse.jsp");
  100. 		}
  101. 	}
  102. 	//退房登记
  103. 	private void doOutroom(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
  104. 		// TODO 自动生成的方法存根
  105. 		memberDao member=new memberDao();
  106. 		ArrayList<member> me=member.allmember();
  107. 		HttpSession session=request.getSession();
  108. 		session.setAttribute("me", me);
  109. 		response.sendRedirect("outhouse.jsp");
  110. 	}
  111. 	@Override
  112. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  113. 		// TODO 自动生成的方法存根
  114. 		request.setCharacterEncoding("utf-8");
  115. 		doGet(request, response);
  116. 	}
  117. }

4.8 退房登记

4.9 会员信息详情

 

 初入java web很多知识还没有深入，对本系统有很多不足的地方，功能也比较单一，在后面会陆续对本系统功能进一步完善，如有不妥的地方，欢迎大家交流！

网站建设定制开发 软件系统开发定制 定制软件开发 软件开发定制 定制app开发 app开发定制 app开发定制公司 电商商城定制开发 定制小程序开发 定制开发小程序 客户管理系统开发定制 定制网站 定制开发 crm开发定制 开发公司 小程序开发定制 定制软件 收款定制开发 企业网站定制开发 定制化开发 android系统定制开发 定制小程序开发费用 定制设计 专注app软件定制开发 软件开发定制定制 知名网站建设定制 软件定制开发供应商 应用系统定制开发 软件系统定制开发 企业管理系统定制开发 系统定制开发