基于Java Web的酒店管理系统

墨蓝 2023-09-28 10:04 151阅读 0赞

**目录**

1.系统概述

2.系统功能

3.所用数据库表

4.具体功能实现

4.1 登录功能

4.2 欢迎页面

4.3 客房列表功能

4.4 查看房型详细信息

4.5 修改客房信息

4.6 添加客房信息

4.7 住房登记

4.8 退房登记

4.9 会员信息详情

--------------------

### 1.系统概述 ###

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

### 2.系统功能 ###

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

### 3.所用数据库表 ###

1.user（员工表）

![d5abaa84b62c45009b51a2de835b52ee.png][]

2.member(会员表)

![cc4a33544cba43ff89a66544008af6c8.png][]

3.house(房型表)

![143c9eccff054401a315985a288aebe0.png][]

### 4.具体功能实现 ###

#### 4.1 登录功能 ####

![6c593d1ffeaa4888b12410c5be1aa16d.png][]

<body background="image/3.jpg">
    	<form name="form1" action="loginservlet?method=login" method="post">
    		<p id=jerry>酒店管理系统</p>
    		<table width="300" border="1" align="center" height="200">
    			<tr id="tb">
    				<td colspan="2" align="center">系统登录</td>
    			</tr>
    			<tr id="tb">
    				<td>工号</td>
    				<td><input type="text" name="username" size="20"></td>
    			</tr>
    			<tr id="tb">
    				<td>密码</td>
    				<td><input type="password" name="password" size="20"></td>
    			</tr>
    			<tr>
    			</tr>
    			<tr id="tb">
    				<td colspan="2"><input type="submit" name="submit" value="登录">
    					<a href="register.jsp">注册新用户</a></td>
    			</tr>
    		</table>
    	</form>
    
    </body>

<body background="image/3.jpg">
    	<form name="form1" action="loginservlet?method=register" method="post">
    		<p id=jerry>酒店管理系统</p>
    		<table width="300" border="1" align="center">
    			<tr>
    				<td colspan="2" align="center">注册窗口</td>
    			</tr>
    			<tr>
    				<td>用户名</td>
    				<td><input type="text" name="username"></td>
    			</tr>
    			<tr>
    				<td>密码</td>
    				<td><input type="password" name="password1"></td>
    			</tr>
    			<tr>
    				<td>确认密码</td>
    				<td><input type="password" name="password2"></td>
    			</tr>
    			<tr>
    				<td>Email</td>
    				<td><input type="text" name="email"></td>
    			</tr>
    			<tr>
    				<td colspan="2"><input type="submit" name="submit" value="注册">
    					<a href="login.jsp">返回</a></td>
    			</tr>
    		</table>
    	</form>
    </body>

loginServlet

@WebServlet(urlPatterns="/loginservlet")
    public class loginServlet extends HttpServlet{
    	@Override
    	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    		// TODO 自动生成的方法存根
    		String method=request.getParameter("method");
    		if("login".equals(method)){
    			doLogin(request,response);
    		}
    		else if("logout".equals(method)){
    			doLogout(request,response);
    		}
    		else if("register".equals(method)){
    			doAdd(request,response);
    		}
    
    	}
    	//用户注册
    	private void doAdd(HttpServletRequest request, HttpServletResponse response)throws ServletException,IOException {
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		response.setCharacterEncoding("utf-8");
    		response.setContentType("text/html;charset=utf-8");
    		String username=request.getParameter("username");
    		String password1=request.getParameter("password1");
    		String password2=request.getParameter("password2");
    		String email=request.getParameter("email");
    		if(!"".equals(username)&&password1.equals(password2)){
    			UserBean user_bean=new UserBean();
    			user_bean.add(username, password1, email);
    			System.out.println("注册成功！");
    			response.sendRedirect("login.jsp");
    		}
    		else {
    			System.out.println("注册失败！");
    			response.sendRedirect("login.jsp");
    		}
    	}
    	//登录
    	private void doLogin(HttpServletRequest request, HttpServletResponse response)throws ServletException,IOException {
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		response.setCharacterEncoding("utf-8");
    		response.setContentType("text/html;charset=utf-8");
    		String username=request.getParameter("username");
    		String password=request.getParameter("password");
    		UserBean user_bean=new UserBean();
    		if(user_bean.isExist(username)){
    			if(user_bean.valid(username, password)){
    				HttpSession session=request.getSession();
    				session.setAttribute("username",username);
    				System.out.println("登录成功");
    				response.sendRedirect("welcome.jsp");
    			}
    			else {//密码错误
    				System.out.println("登录失败1");
    				response.sendRedirect("login.jsp");
    			}
    		}
    		else {
    			System.out.println("登录失败2");
    			response.sendRedirect("login.jsp");
    		}
    	}
    	//退出登录
    	protected void doLogout(HttpServletRequest request,
    			HttpServletResponse response) throws ServletException, IOException {
    		HttpSession session = request.getSession();
    		session.removeAttribute("username");
    		System.out.println("退出成功");
    		response.sendRedirect("login.jsp");
    	}
    	@Override
    	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		doGet(request, response);
    	}
    }

#### 4.2 欢迎页面 ####

![9e0327b7c4874d44b3e52c324a9d01fa.png][]

welcome.jsp

<body background="image/3.jpg">
    
    	<table width="100%">
    		<p id="ss" class="text">酒店管理系统</p>
    		<%
    			Calendar cal = Calendar.getInstance();
    			SimpleDateFormat format = new SimpleDateFormat("dd日-MM月-yyyy年 HH:mm:ss");
    		%>
    		<tr>
    			<td colspan="2" align="right">登陆成功！欢迎你，<%=(String) session.getAttribute("username")%>
    			</td>
    			<td align="right">
    				<%
    					out.println(format.format(cal.getTime()));
    				%>
    			</td>
    		</tr>
    
    		<tr>
    			<td colspan="3">
    				<hr>
    			</td>
    		</tr>
    		<tr>
    			<td><br> <br> <br> <br> <br> <br>
    			</td>
    		</tr>
    		<tr>
    			<td colspan="3">
    				<form name="form1" action="loginservlet?method=logout" method="post">
    					<table width="450" height="300" border="1" align="center" id="tom">
    						<tr>
    							<th colspan="3" align="center">选择功能</th>
    						</tr>
    						<tr>
    							<td><a class="a" href="pageservlet?method=showHouse">客房列表</a></td>
    
    							<td><a class="a" href="addhouse.jsp">添加客房</a></td>
    						</tr>
    						<tr>
    							<td><a class="a" href="inhouse.jsp">住房登记</a></td>
    
    							<td><a class="a" href="pageservlet?method=showMember">退房登记</a></td>
    						</tr>
    						<tr>
    							<td colspan="3" align="center"><input type="submit"
    								name="submit" value="退出"></td>
    						</tr>
    					</table>
    				</form>
    			</td>
    		</tr>
    
    		</div>
    </body>

#### 4.3 客房列表功能 ####

![5aafa77eb00d4d9b94c0ff721b116589.png][]

hotelBean.java

public class hotel {
    private String name;//房间名称
    private int price;//房间价格
    private int amount;//房间价格
    private String square;//房间面积
    private int people;//房间可住人数
    public final static int maxpage=4;
    public String getName() {
    	return name;
    }
    public void setName(String name) {
    	this.name = name;
    }
    public int getPrice() {
    	return price;
    }
    public void setPrice(int price) {
    	this.price = price;
    }
    public int getAmount() {
    	return amount;
    }
    public void setAmount(int amount) {
    	this.amount = amount;
    }
    public String getSquare() {
    	return square;
    }
    public void setSquare(String square) {
    	this.square = square;
    }
    public int getPeople() {
    	return people;
    }
    public void setPeople(int people) {
    	this.people = people;
    }
    }

houseDao

public class houseDao {
    	DBAccess db=new DBAccess();
    	public ArrayList<hotel>allhotel(){//显示全部房间
    		ArrayList<hotel>list=new ArrayList<hotel>();
    		if(db.createConn()){
    			String sql="select * from house";
    			try {
    				db.query(sql);
    				while(db.next()){
    					hotel ho=new hotel();
    					ho.setName(db.getRs().getString("name"));
    					ho.setPrice(db.getRs().getInt("price"));
    					ho.setAmount(db.getRs().getInt("amount"));
    					ho.setSquare(db.getRs().getString("square"));
    					ho.setPeople(db.getRs().getInt("people"));
    					list.add(ho);
    				}
    
    			} catch (SQLException e) {
    				// TODO 自动生成的 catch 块
    				e.printStackTrace();
    			}
    			finally {
    				db.closeRs();
    				db.closeStm();
    				db.closeConn();
    			}
    		}
    		return list;
    	}
    	public hotel show(String name){//显示房间信息
    		hotel ho=new hotel();
    		if(db.createConn()){
    			String sql="select * from house where name=?";
    			try {
    				db.pre=db.getConn().prepareStatement(sql);
    				db.pre.setString(1, name);
    				db.setRs(db.pre.executeQuery());
    				if(db.getRs().next()){
    
    					ho.setName(db.getRs().getString("name"));
    					ho.setPrice(db.getRs().getInt("price"));
    					ho.setAmount(db.getRs().getInt("amount"));
    					ho.setSquare(db.getRs().getString("square"));
    					ho.setPeople(db.getRs().getInt("people"));
    				}
    			} catch (SQLException e) {
    				// TODO 自动生成的 catch 块
    				e.printStackTrace();
    			}
    			finally {
    				db.closeRs();
    				if(db.pre!=null){
    					try {
    						db.pre.close();
    					} catch (SQLException e) {
    						// TODO 自动生成的 catch 块
    						e.printStackTrace();
    					}
    					db.closeConn();
    				}
    			}
    		}
    		return ho;
    	}
    	public boolean updatehotel(hotel ho) throws Exception{//修改房间  
    		boolean flag = false;
    		DBAccess db=new DBAccess();
    		if(db.createConn()){
    			String sql="UPDATE house SET name=?,price=?,amount=?,square=?,people=? where name=?";
    			db.pre=db.getConn().prepareStatement(sql);
    			db.pre.setString(1, ho.getName());
    			db.pre.setInt(2, ho.getPrice());
    			db.pre.setInt(3, ho.getAmount());
    			db.pre.setString(4, ho.getSquare());
    			db.pre.setInt(5, ho.getPeople());
    			db.pre.setString(6, ho.getName());
    			if(db.pre.executeUpdate() > 0) flag = true;
    		}
    		db.closeRs();
    		db.closeStm();
    		db.pre.close();
    		db.closeConn();
    		return flag;
    	}
    	public boolean updateamount(hotel ho){//更新房间数量
    		boolean flag = false;
    		DBAccess db=new DBAccess();
    		if(db.createConn()){
    			String sql="update house set amount=? where name=?";
    			try {
    				db.pre=db.getConn().prepareStatement(sql);
    				db.pre.setInt(1,ho.getAmount() );
    				db.pre.setString(2, ho.getName());
    				if(db.pre.executeUpdate()>0) flag=true;
    			} catch (SQLException e) {
    				// TODO 自动生成的 catch 块
    				e.printStackTrace();
    			}finally {
    				try {
    					db.pre.close();
    				} catch (SQLException e) {
    					// TODO 自动生成的 catch 块
    					e.printStackTrace();
    				}
    				db.closeConn();
    			}
    		}
    		return flag;
    	}
    	public boolean add(hotel ho) throws Exception{//添加房间
    		boolean flag = false;
    		DBAccess db=new DBAccess();
    		if(db.createConn()){
    			String sql = "INSERT INTO house(name,price,amount,square,people) VALUES(?,?,?,?,?)";
    			db.pre=db.getConn().prepareStatement(sql);
    			db.pre.setString(1, ho.getName());
    			db.pre.setInt(2, ho.getPrice());
    			db.pre.setInt(3, ho.getAmount());
    			db.pre.setString(4, ho.getSquare());
    			db.pre.setInt(5, ho.getPeople());
    			if(db.pre.executeUpdate() > 0) flag = true;
    		}
    		db.closeRs();
    		db.closeStm();
    		db.pre.close();
    		db.closeConn();
    		return flag;
    	}
    	public boolean delHouse(String name) throws Exception{//删除房间
    		DBAccess db=new DBAccess();
    		boolean flag = false;
    		String sql="DELETE FROM house WHERE name = ?";
    		if(db.createConn()){
    			db.pre=db.getConn().prepareStatement(sql);
    			db.pre.setString(1, name);
    			if(db.pre.executeUpdate()>0)flag=true;
    		}
    		db.closeConn();
    		db.closeStm();
    		db.pre.close();
    		db.closeRs();
    		return flag;
    	}
    	public ArrayList<hotel> findAll(Integer page){//分页查询信息
    		DBAccess  db=new DBAccess();
    		ArrayList<hotel> list=new ArrayList<hotel>();
    		
    		try {
    			if(db.createConn()){
    				String sql="select  * from house limit ?,? ";
    				db.pre=db.getConn().prepareStatement(sql);
    				db.pre.setInt(1, (page-1)*hotel.maxpage);
    				db.pre.setInt(2, hotel.maxpage);
    				db.setRs(db.pre.executeQuery());
    				while(db.getRs().next()){
    					hotel ho=new hotel();
    					ho.setName(db.getRs().getString("name"));
    					ho.setPrice(db.getRs().getInt("price"));
    					ho.setAmount(db.getRs().getInt("amount"));
    					ho.setSquare(db.getRs().getString("square"));
    					ho.setPeople(db.getRs().getInt("people"));
    					list.add(ho);
    				}
    				db.closeRs();
    				db.pre.close();
    				db.closeConn();
    			}
    		} catch( SQLException e) {
    			e.printStackTrace();
    		}
    		return list;
    	}
    	public int countPage(){//查询记录总数
    		DBAccess  db=new DBAccess();
    		int count=0;
    		try {
    			if(db.createConn()){
    				String sql="select count(*) from house  ";
    				db.pre=db.getConn().prepareStatement(sql);
    				db.setRs(db.pre.executeQuery());
    				if(db.getRs().next()){
    					count=db.getRs().getInt(1);
    				}
    			}
    		} catch( SQLException e) {
    			e.printStackTrace();
    		}
    		finally {
    			db.closeRs();
    			try {
    				if(db.pre!=null){
    					db.pre.close();
    				}
    			} catch (Exception e2) {
    				// TODO: handle exception
    			}
    			db.closeConn();
    		}
    		return count;
    	}
    }

housemanageServlet

@WebServlet(urlPatterns="/houseServlet")
    public class housemanageServlet extends HttpServlet{
    	@Override
    	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		String method=request.getParameter("method");
    		if("show".equals(method)){
    			doShow(request,response);
    		}
    		else if("add".equals(method)){
    			doAdd(request,response);
    		}
    		else if("show2".equals(method)){
    			doShow2(request,response);
    		}
    		else if("update".equals(method)){
    			doUpdate(request,response);
    		}
    		else if("update2".equals(method)){
    			doUpdate2(request,response);
    		}
    		else if("delete".equals(method)){
    			doDel(request,response);
    		}
    
    	}
    	//删除客房
    	private void doDel(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		String name=request.getParameter("category");
    		houseDao house=new houseDao();
    		try {
    			if(house.delHouse(name)){
    				System.out.println("删除成功！");
    				response.sendRedirect("showhouse.jsp");//删除之后无法立马更新数据
    				return;
    			}
    			else {
    				System.out.println("删除失败！");
    				response.sendRedirect("showhouse.jsp");
    			}
    		} catch (Exception e) {
    			// TODO 自动生成的 catch 块
    			e.printStackTrace();
    		}
    	}
    	//修改客房信息
    	private void doUpdate2(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException  {
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		String name=request.getParameter("name");
    		int price=Integer.parseInt(request.getParameter("price"));
    		int amount=Integer.parseInt(request.getParameter("amount"));
    		String square=request.getParameter("square");
    		int people=Integer.parseInt(request.getParameter("people"));
    		houseDao house=new houseDao();
    		hotel ho=new hotel();
    		ho.setName(name);
    		ho.setPrice(price);
    		ho.setAmount(amount);
    		ho.setSquare(square);
    		ho.setPeople(people);
    		try {
    			if(house.updatehotel(ho)){
    				System.out.println("修改成功！");
    				response.sendRedirect("showhouse.jsp");
    				return;
    			}
    			else {
    				System.out.println("修改失败！");
    				response.sendRedirect("showhouse.jsp");
    			}
    		} catch (Exception e) {
    			// TODO 自动生成的 catch 块
    			e.printStackTrace();
    		}
    	}
    	//用来重定向到修改页面
    	private void doUpdate(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//重定向到 update.jsp
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		String name=request.getParameter("category");
    		houseDao house=new houseDao();
    		hotel ho=house.show(name);
    		request.setAttribute("ho", ho);
    		request.getRequestDispatcher("update.jsp").forward(request, response);
    	}
    	//显示客房具体信息
    	private void doShow2(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		String name=request.getParameter("category");
    		houseDao house=new houseDao();
    		hotel ho=house.show(name);
    		HttpSession session=request.getSession();
    		session.setAttribute("ho", ho);
    		response.sendRedirect("showhouse2.jsp");
    	}
    	//添加客房
    	private void doAdd(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		String name=request.getParameter("name");
    		int price=Integer.parseInt(request.getParameter("price"));
    		int amount=Integer.parseInt(request.getParameter("amount"));
    		String square=request.getParameter("square");
    		int people=Integer.parseInt(request.getParameter("people"));
    		houseDao house=new houseDao();
    		hotel ho=new hotel();
    		if(!"".equals(name)&&!"".equals(square)&&0!=price&&0!=amount&&people!=0){
    			ho.setName(name);
    			ho.setPrice(price);
    			ho.setAmount(amount);
    			ho.setSquare(square);
    			ho.setPeople(people);
    		}
    		else {
    			System.out.println("添加失败，信息不全");
    			response.sendRedirect("addhouse.jsp");
    		}
    		try {
    			if(house.add(ho)){
    				System.out.println("添加成功！");
    				response.sendRedirect("addhouse.jsp");
    			}
    		} catch (Exception e) {
    			// TODO 自动生成的 catch 块
    			e.printStackTrace();
    		}
    	}
    	//显示所有客房信息
    	private void doShow(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
    		// TODO 自动生成的方法存根
    		houseDao house_dao=new houseDao();
    		ArrayList<hotel> house=house_dao.allhotel();
    		HttpSession session=request.getSession();
    		session.setAttribute("house", house);
    		response.sendRedirect("showhouse.jsp");
    	}
    	@Override
    	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    		// TODO 自动生成的方法存根
    		doGet(request, response);
    	}
    }

showhouse.jsp(全部)

<body background="image/3.jpg">
    	<table width="100%">
    		<p id="ss">酒店管理系统</p>
    		<%
    			Calendar cal = Calendar.getInstance();
    			SimpleDateFormat format = new SimpleDateFormat("dd日-MM月-yyyy年 HH:mm:ss");
    		%>
    		<tr>
    			<td colspan="2" align="right">登陆成功！欢迎你，<%=(String) session.getAttribute("username")%>
    			</td>
    			<td align="right">
    				<%
    					out.println(format.format(cal.getTime()));
    				%>
    			</td>
    		</tr>
    
    		<tr>
    			<td colspan="3">
    				<hr>
    			</td>
    		</tr>
    		<tr>
    			<td><a href="welcome.jsp">返回</a></td>
    		</tr>
    		<tr>
    			<td><br> <br> <br> <br> <br> <br>
    			</td>
    		</tr>
    	</table>
    	<h2 align="center">所有客房信息</h2>
    	<table width="400" height="200" border="1" align="center">
    		<tr>
    			<td align="center">房间类型</td>
    			<td align="center">房型价格</td>
    			<td align="center">可预定数量</td>
    			<td align="center">操作</td>
    		</tr>
    		<%
    			for (hotel ho : hotels) {
    		%>
    		<tr>
    			<td align="center"><%=ho.getName()%></td>
    			<td align="center"><%=ho.getPrice()%>￥</td>
    			<td align="center"><%=ho.getAmount()%></td>
    			<td><a
    				href="houseServlet?method=show2&category=<%=ho.getName()%>">查看</a>
    				<a href="houseServlet?method=update&category=<%=ho.getName()%>">修改</a>
    				<a href="houseServlet?method=delete&category=<%=ho.getName()%>">删除</a>
    			</td>
    		</tr>
    		<%
    			}
    		%>
    		<tr>
    			<td align="center" colspan="6" bgcolor="gray">
    				<%--<%=request.getAttribute("bar")  /页 --%> ${bar}/页
    			</td>
    		</tr>
    	</table>
    </body>

#### 4.4 查看房型详细信息 ####

![2f85d1ee3851406783d72fa2275579db.png][]

#### 4.5 修改客房信息 ####

#### ![a6965ffd81584951ba39d3c1c724c37d.png][] 4.6 添加客房信息 ####

![ae1d83d1faad4d17962b8a1ee475b643.png][]

#### 4.7 住房登记 ####

![bdba1168633144df9d8543cebd686fb8.png][]

memberBean.java

public class member {
    private String name;//会员名
    private String tel;//手机号
    private String category;//房间类型
    private String hotelnumber;//房间号
    private int people;//入住人数
    private String money;//消费
    public String getName() {
    	return name;
    }
    public void setName(String name) {
    	this.name = name;
    }
    public String getTel() {
    	return tel;
    }
    public void setTel(String tel) {
    	this.tel = tel;
    }
    public String getCategory() {
    	return category;
    }
    public void setCategory(String category) {
    	this.category = category;
    }
    public String getHotelnumber() {
    	return hotelnumber;
    }
    public void setHotelnumber(String hotelnumber) {
    	this.hotelnumber = hotelnumber;
    }
    public int getPeople() {
    	return people;
    }
    public void setPeople(int people) {
    	this.people = people;
    }
    public String getMoney() {
    	return money;
    }
    public void setMoney(String money) {
    	this.money = money;
    }
    
    }

memberDao

public class memberDao {
    	DBAccess db=new DBAccess();
    
    	public boolean add(member me) throws Exception{//添加会员
    		boolean flag = false;
    		if(db.createConn()){
    			String sql = "INSERT INTO member(name,tel,category,hotelnumber,people,money) VALUES(?,?,?,?,?,?)";
    			db.pre=db.getConn().prepareStatement(sql);
    			db.pre.setString(1, me.getName());
    			db.pre.setString(2, me.getTel());
    			db.pre.setString(3, me.getCategory());
    			db.pre.setString(4, me.getHotelnumber());
    			db.pre.setInt(5, me.getPeople());
    			db.pre.setString(6, me.getMoney());
    			if(db.pre.executeUpdate() > 0) flag = true;
    		}
    		db.closeRs();
    		db.closeStm();
    		db.pre.close();
    		db.closeConn();
    		return flag;
    	}
    	public ArrayList<member> allmember(){//显示所有会员
    		ArrayList<member>list=new ArrayList<member>();
    		if(db.createConn()){
    			String sql="select * from member";
    			try {
    				db.query(sql);
    				while(db.next()){
    					member me=new member();
    					me.setName(db.getRs().getString("name"));
    					me.setTel(db.getRs().getString("tel"));
    					me.setCategory(db.getRs().getString("category"));
    					me.setHotelnumber(db.getRs().getString("hotelnumber"));
    					me.setPeople(db.getRs().getInt("people"));
    					me.setMoney(db.getRs().getString("money"));
    					list.add(me);
    				}
    			} catch (SQLException e) {
    				// TODO 自动生成的 catch 块
    				e.printStackTrace();
    			}
    			finally {
    				db.closeRs();
    				db.closeStm();
    				db.closeConn();
    			}
    		}
    		return list;
    	}
    	public member showpersonal(String name){//显示会员详细信息
    		member me=new member();
    		if(db.createConn()){
    			String sql="select * from member where name=?";
    			try {
    				db.pre=db.getConn().prepareStatement(sql);
    				db.pre.setString(1, name);
    				db.setRs(db.pre.executeQuery());
    				if(db.getRs().next()){
    
    					me.setName(db.getRs().getString("name"));
    					me.setTel(db.getRs().getString("tel"));
    					me.setCategory(db.getRs().getString("category"));
    					me.setHotelnumber(db.getRs().getString("hotelnumber"));
    					me.setPeople(db.getRs().getInt("people"));
    					me.setMoney(db.getRs().getString("money"));
    				}
    			} catch (SQLException e) {
    				// TODO 自动生成的 catch 块
    				e.printStackTrace();
    			}
    			finally {
    				db.closeRs();
    				if(db.pre!=null){
    					try {
    						db.pre.close();
    					} catch (SQLException e) {
    						// TODO 自动生成的 catch 块
    						e.printStackTrace();
    					}
    					db.closeConn();
    				}
    			}
    		}
    		return me;
    	}
    	public boolean delMember(String tel) throws Exception{//删除会员信息
    		DBAccess db=new DBAccess();
    		boolean flag = false;
    		String sql="DELETE FROM member WHERE tel = ?";
    		if(db.createConn()){
    			db.pre=db.getConn().prepareStatement(sql);
    			db.pre.setString(1, tel);
    			if(db.pre.executeUpdate()>0)flag=true;
    		}
    		db.closeConn();
    		db.closeStm();
    		db.pre.close();
    		db.closeRs();
    		return flag;
    	}
    	public ArrayList<member> findAll(Integer page){//分页查询信息
    		DBAccess  db=new DBAccess();
    		ArrayList<member> list=new ArrayList<member>();
    		
    		try {
    			if(db.createConn()){
    				String sql="select  * from member limit ?,? ";
    				db.pre=db.getConn().prepareStatement(sql);
    				db.pre.setInt(1, (page-1)*hotel.maxpage);
    				db.pre.setInt(2, hotel.maxpage);
    				db.setRs(db.pre.executeQuery());
    				while(db.getRs().next()){
    					member me=new member();
    					me.setName(db.getRs().getString("name"));
    					me.setTel(db.getRs().getString("tel"));
    					me.setCategory(db.getRs().getString("category"));
    					me.setHotelnumber(db.getRs().getString("hotelnumber"));
    					me.setPeople(db.getRs().getInt("people"));
    					me.setMoney(db.getRs().getString("money"));
    					list.add(me);
    				}
    				db.closeRs();
    				db.pre.close();
    				db.closeConn();
    			}
    		} catch( SQLException e) {
    			e.printStackTrace();
    		}
    		return list;
    	}
    	public int countPage(){//查询记录总数
    		DBAccess  db=new DBAccess();
    		int count=0;
    		try {
    			if(db.createConn()){
    				String sql="select count(*) from member  ";
    				db.pre=db.getConn().prepareStatement(sql);
    				db.setRs(db.pre.executeQuery());
    				if(db.getRs().next()){
    					count=db.getRs().getInt(1);
    				}
    			}
    		} catch( SQLException e) {
    			e.printStackTrace();
    		}
    		finally {
    			db.closeRs();
    			try {
    				if(db.pre!=null){
    					db.pre.close();
    				}
    			} catch (Exception e2) {
    				// TODO: handle exception
    			}
    			db.closeConn();
    		}
    		return count;
    	}
    }

membermanageServlet

@WebServlet(urlPatterns="/membermanage")
    public class membermanageServlet extends HttpServlet{
    	@Override
    	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		String method=request.getParameter("method");
    		if("inroom".equals(method)){
    			doInroom(request,response);
    		}
    		else if ("outroom".equals(method)) {
    			doOutroom(request,response);
    		}
    		else if("personalmessage".equals(method)){
    			doShowPerMessage(request,response);
    		}
    		else if("delmember".equals(method)){
    			doDelMember(request,response);
    		}
    	}
    	//退房操作
    	private void doDelMember(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		String tel=request.getParameter("tel");
    		String category=request.getParameter("category");
    		houseDao house=new houseDao();
    		memberDao member=new memberDao();
    		hotel ho=null;
    		try {
    			if(member.delMember(tel)){
    				ho=house.show(category);
    				ho.setAmount(ho.getAmount()+1);//获取房型相关信息
    				house.updateamount(ho);
    				System.out.println("退房成功！");
    				response.sendRedirect("welcome.jsp");
    				return;
    			}
    		} catch (Exception e) {
    			// TODO 自动生成的 catch 块
    			e.printStackTrace();
    		}
    	}
    	//显示会员信息
    	private void doShowPerMessage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		String name=request.getParameter("name");
    		memberDao member=new memberDao();
    		member mb=member.showpersonal(name);
    		HttpSession session=request.getSession();
    		session.setAttribute("mb", mb);
    		//request.setAttribute("mb", mb);
    		response.sendRedirect("showmemberMassage.jsp");
    		//request.getRequestDispatcher("showmemberMassage.jsp").forward(request, response);
    
    	}
    	//住房登记
    	private void doInroom(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		String name=request.getParameter("name");
    		String tel=request.getParameter("tel");
    		String category=request.getParameter("category");
    		String housenumber=request.getParameter("housenumber");
    		int people=Integer.parseInt(request.getParameter("people"));
    		String money=request.getParameter("money");
    		memberDao member =new memberDao();
    		houseDao house=new houseDao();
    		hotel ho=null;
    		if(name!=null&&tel!=null&&category!=null&&housenumber!=null&&people!=0&&money!=null){
    			member me=new member();
    			me.setName(name);
    			me.setTel(tel);
    			me.setCategory(category);
    			me.setHotelnumber(housenumber);
    			me.setPeople(people);
    			me.setMoney(money);
    			try {
    				ho=house.show(category);//根据房间类型获取房间
    				if(member.add(me)&&ho.getAmount()>0){
    					//System.out.println("添加会员成功！");
    					ho.setAmount(ho.getAmount()-1);
    					house.updateamount(ho);//更改房间数量
    					System.out.println("添加会员成功！");
    					response.sendRedirect("welcome.jsp");
    				}
    				else {
    					System.out.println("添加会员失败，没有可用的房间！");
    					response.sendRedirect("inhouse.jsp");
    				}
    			} catch (Exception e) {
    				// TODO 自动生成的 catch 块
    				e.printStackTrace();
    			}
    		}
    		else {
    			System.out.println("添加会员失败,信息不全！");
    			response.sendRedirect("inhouse.jsp");
    		}
    	}
    	//退房登记
    	private void doOutroom(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
    		// TODO 自动生成的方法存根
    		memberDao member=new memberDao();
    		ArrayList<member> me=member.allmember();
    		HttpSession session=request.getSession();
    		session.setAttribute("me", me);
    		response.sendRedirect("outhouse.jsp");
    	}
    	@Override
    	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    		// TODO 自动生成的方法存根
    		request.setCharacterEncoding("utf-8");
    		doGet(request, response);
    	}
    }

#### 4.8 退房登记 ####

![bb68c3f2594349c4b0a2173fb02477f8.png][]

#### 4.9 会员信息详情 ####

![bd382c53d4b641a1bf98b19e8ca7b1ed.png][]

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

--------------------

[d5abaa84b62c45009b51a2de835b52ee.png]: https://img-blog.csdnimg.cn/d5abaa84b62c45009b51a2de835b52ee.png
[cc4a33544cba43ff89a66544008af6c8.png]: https://img-blog.csdnimg.cn/cc4a33544cba43ff89a66544008af6c8.png
[143c9eccff054401a315985a288aebe0.png]: https://img-blog.csdnimg.cn/143c9eccff054401a315985a288aebe0.png
[6c593d1ffeaa4888b12410c5be1aa16d.png]: https://img-blog.csdnimg.cn/6c593d1ffeaa4888b12410c5be1aa16d.png
[9e0327b7c4874d44b3e52c324a9d01fa.png]: https://img-blog.csdnimg.cn/9e0327b7c4874d44b3e52c324a9d01fa.png
[5aafa77eb00d4d9b94c0ff721b116589.png]: https://img-blog.csdnimg.cn/5aafa77eb00d4d9b94c0ff721b116589.png
[2f85d1ee3851406783d72fa2275579db.png]: https://img-blog.csdnimg.cn/2f85d1ee3851406783d72fa2275579db.png
[a6965ffd81584951ba39d3c1c724c37d.png]: https://img-blog.csdnimg.cn/a6965ffd81584951ba39d3c1c724c37d.png
[ae1d83d1faad4d17962b8a1ee475b643.png]: https://img-blog.csdnimg.cn/ae1d83d1faad4d17962b8a1ee475b643.png
[bdba1168633144df9d8543cebd686fb8.png]: https://img-blog.csdnimg.cn/bdba1168633144df9d8543cebd686fb8.png
[bb68c3f2594349c4b0a2173fb02477f8.png]: https://img-blog.csdnimg.cn/bb68c3f2594349c4b0a2173fb02477f8.png
[bd382c53d4b641a1bf98b19e8ca7b1ed.png]: https://img-blog.csdnimg.cn/bd382c53d4b641a1bf98b19e8ca7b1ed.png