๊ด€๋ฆฌ ๋ฉ”๋‰ด

CoDream

์˜ˆ์•ฝ ํŽ˜์ด์ง€๋กœ LIST๊ฐ€ ์•ˆ ๋„˜์–ด๊ฐ€...๐Ÿ˜ต‍๐Ÿ’ซ ๋ณธ๋ฌธ

๐Ÿ’ปํŒ€ ํ”„๋กœ์ ํŠธ

์˜ˆ์•ฝ ํŽ˜์ด์ง€๋กœ LIST๊ฐ€ ์•ˆ ๋„˜์–ด๊ฐ€...๐Ÿ˜ต‍๐Ÿ’ซ

์ฝ”์ž  2024. 5. 26. 21:14
728x90
๋ฐ˜์‘ํ˜•

 

๐Ÿค” ํ•˜๊ณ  ์‹ถ์€ ๊ฒƒ

 

์ˆ™์†Œ ์ƒ์„ธ ํŽ˜์ด์ง€์—์„œ ๋„˜์–ด์˜จ ์‚ฌ์šฉ์ž๊ฐ€ ์„ ํƒํ•œ ์ •๋ณด(์˜ˆ์•ฝ๋‚ ์งœ, ๊ฒŒ์ŠคํŠธ์ธ์›)

DB์—์„œ ๊ฐ€์ ธ์˜จ ํ•ด๋‹น ์ˆ™์†Œ์˜ ์ •๋ณด, ํ˜ธ์ŠคํŠธ์˜ ์ •๋ณด

๋ฉค๋ฒ„์˜ ์นด๋“œ ์ •๋ณด

์œ„ ์ •๋ณด๋“ค์„ ์˜ˆ์•ฝ ํŽ˜์ด์ง€๋กœ ๋„˜๊ฒจ ์ •๋ณด๋“ค์„ ๋ณด์ด๊ฒŒ ํ•˜๋ คํ•จ.

๐Ÿคจ ์ด๋ ‡๊ฒŒ ํ•˜๋ฉด ๋  ๊ฒƒ ๊ฐ™์€๋ฐ

์„ ํƒํ•œ ์ •๋ณด(์˜ˆ์•ฝ๋‚ ์งœ, ๊ฒŒ์ŠคํŠธ์ธ์›) 

ReservationVo vo = new ReservationVo();
	vo.setRoomNo(roomNo);
	vo.setInDate(inDate);
	vo.setOutDate(outDate);
	vo.setGuestCount(guestCount);
    
req.setAttribute("vo", vo);

 

DB์—์„œ ๊ฐ€์ ธ์˜จ ํ•ด๋‹น ์ˆ™์†Œ์˜ ์ •๋ณด, ํ˜ธ์ŠคํŠธ์˜ ์ •๋ณด

List<ReservationVo> roomDetail = rs.getRoomDetail(roomNo);

req.setAttribute("roomDetail", roomDetail);

 

๋ฉค๋ฒ„์˜ ์นด๋“œ ์ •๋ณด

List<CardVo> cardVoList = rs.getCardList(loginMemNo);

req.setAttribute("cardVoList", cardVoList);

 

๐Ÿฅฒ ์•„๋‹ˆ์˜€๋„ค...

๋ชจ๋“  ์ •๋ณด๋ฅผ JSP๋กœ ๋„˜๊ธฐ๊ณ  ๋ธŒ๋ผ์šฐ์ €๋ฅผ ์ผฐ๋Š”๋ฐ... ์˜ค๋ฅ˜๊ฐ€ ๋‚จ.

๊ณ„์† ' DB์—์„œ ๊ฐ€์ ธ์˜จ ํ•ด๋‹น ์ˆ™์†Œ์˜ ์ •๋ณด, ํ˜ธ์ŠคํŠธ์˜ ์ •๋ณด' ๋“ค์ด NULL๋กœ ๋‚˜์˜ด..

์ด์œ ๊ฐ€ ๋ญ๋žŒ...ใ… ใ… 

๐Ÿง ์ด๊ฑฐ๋‹ค!

ํ˜น์‹œ๋‚˜... ReservationVo๊ฐ€ ์ค‘๋ณต๋˜์„œ ๊ทธ๋Ÿฐ๊ฐ€...ํ•˜๊ณ 

๋ฐ์ดํ„ฐ๋ฅผ ํ•˜๋‚˜๋กœ ๋ญ‰์ณ๋ดค์Œ...

ํ˜น์‹œ๋‚˜๊ฐ€ ์—ญ์‹œ๋‚˜์˜€๋‚˜๋ณด๋‹ค...ใ…Žใ…Žใ…Ž

์˜ˆ์•ฝํŽ˜์ด์ง€๋กœ ๋‚ด๊ฐ€ ์›ํ•˜๋Š” ์ •๋ณด๋“ค์ด ๋ชจ๋‘ ๋„˜์–ด์˜ค๋Š” ๊ฒƒ์„ ํ™•์ธ ํ•  ์ˆ˜ ์žˆ์—ˆ์Œ:) ํ•˜ํ•ณ

String roomNo = req.getParameter("roomNo");
String inDate = req.getParameter("inDate");
String outDate = req.getParameter("outDate");
String guestCount = req.getParameter("guestCount");
String sum = req.getParameter("sum");

ReservationService rs = new ReservationService();
List<CardVo> cardVoList = rs.getCardList(loginMemNo);
List<ReservationVo> roomDetail = rs.getRoomDetail(roomNo);
			
ReservationVo roomInfo = roomDetail.get(0);
ReservationVo vo = new ReservationVo();

vo.setRoomNo(roomNo);
vo.setInDate(inDate);
vo.setOutDate(outDate);
vo.setGuestCount(guestCount);
vo.setRoomImg(roomInfo.getRoomImg());
vo.setHostName(roomInfo.getHostName());
vo.setHostProfile(roomInfo.getHostProfile());
vo.setHostEnrollDate(roomInfo.getHostEnrollDate());
vo.setRoomName(roomInfo.getRoomName());
vo.setWeekdayPrice(roomInfo.getWeekdayPrice());
vo.setWeekendPrice(roomInfo.getWeekendPrice());
vo.setStayDay(roomInfo.getStayDay());
vo.setSum(roomInfo.getSum());
			
req.setAttribute("vo", vo);
req.setAttribute("cardVoList", cardVoList);

 

 

728x90
๋ฐ˜์‘ํ˜•