1.Dao层(通过rid查询整条数据,返回值类型为Room)
public Room select(Integer rid) {
Room room = new Room();
String sql = "SELECT * FROM rooms WHERE rid=?";
ResultSet rs = helper.executeSql(sql,rid);
try {
while(rs.next()){
room.setRid(rs.getInt("rid"));
room.setArea(rs.getInt("area"));
room.setPrice(rs.getInt("price"));
room.setAccommodate(rs.getInt("accommodate"));
room.setAir(rs.getString("air"));
room.setStyle(rs.getString("style"));
room.setTv(rs.getString("tv"));
room.setNet(rs.getString("net"));
room.setToilet(rs.getString("toilet"));
}
rs.close();
helper.close();
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
return room;
}
2.Servlet里访问查询方法
int rid =new Integer(req.getParameter("rid"));//从jsp得到要查询的rid
Room room = service.select(rid);
req.setAttribute("room",room);
req.getRequestDispatcher("alterroom.jsp").forward(req, resp);
3.在jsp里显示输出数据
<body><%
Room room = (Room)request.getAttribute("room");
// out.println(room.getRid());
// out.println(room.getStyle());
%>
客房${room.getRid()}号的信息详情<br/>
<table border="1">
<tr> <td>编号</td><td>${room.getRid()}</td></tr>
<tr> <td>房间类型</td><td>${room.getStyle()}</td></tr>
<tr> <td>面积</td><td>${room.getArea()}</td></tr>
<tr> <td>容纳人数</td><td>${room.getAccommodate()}</td></tr>
<tr> <td>价格</td><td>${room.getPrice()}</td></tr>
<tr> <td>空调</td><td>${room.getAir()}</td></tr>
<tr> <td>电视机</td><td>${room.getTv()}</td></tr>
<tr> <td>网络</td><td>${room.getNet()}</td></tr>
<tr> <td>厕所</td><td>${room.getToilet()}</td></tr>
</table>
</body>
~~~~~~~~~~~~~~ ヾ(◍°∇°◍)ノ゙ ~~~~~~~~~~~~~~~