24.05.01숙제

[이규혁]

메인 index화면

서블릿

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

package database; import java.io.IOException; import java.util.ArrayList; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;   @SuppressWarnings("serial") @WebServlet("/study/database/LoginLastFiveGuysList") public class LoginLastFiveGuysList extends HttpServlet {       @Override     protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {         LoginDAO dao = new LoginDAO();                  ArrayList<LoginVO> vos2 = dao.getLoginFiveList();         System.out.println("vos2 : " + vos2);                  request.setAttribute("vos2", vos2);                  String viewPage = "/index.jsp";         RequestDispatcher dispatcher2 = request.getRequestDispatcher(viewPage);         dispatcher2.forward(request, response);     } } Colored by Color Scripter

cs

DAO

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

public ArrayList<LoginVO> getLoginFiveList() {             ArrayList<LoginVO> vos2 = new ArrayList<LoginVO>();                          try {                 sql = "select * from hoewon order by idx desc limit 5;";                 pstmt = conn.prepareStatement(sql);                 rs = pstmt.executeQuery();                                              while(rs.next()) {                     vo = new LoginVO();                     vo.setIdx(rs.getInt("idx"));                     vo.setMid(rs.getString("mid"));                     vo.setPwd(rs.getString("pwd"));                     vo.setName(rs.getString("name"));                     vo.setAge(rs.getInt("age"));                     vo.setGender(rs.getString("gender"));                     vo.setAddress(rs.getString("address"));                     vos2.add(vo);                 }                     } catch (Exception e) {                 System.out.println("SQL 오류(최근 5명 회원) : " + e.getMessage());             } finally {                 rsClose();             }             return vos2;         }         Colored by Color Scripter

cs

index

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

<table class="table table-hover">                     <tr class="table-success">                         <th>번호</th>                         <th>아이디</th>                         <th>성명</th>                         <th>나이</th>                         <th>성별</th>                         <th>주소</th>                     </tr>                     <c:forEach var="vo" items="${vos2}" varStatus="st">                         <tr class="table-primary">                             <td>${vo.idx}</td>                             <td>${vo.mid}</td>                             <td>${vo.name}</td>                             <td>${vo.age}</td>                             <td>${vo.gender}</td>                             <td>${vo.address}</td>                         </tr>                     </c:forEach>                     <tr><td colspan="6" class="m-0 p-0"></td></tr>                 </table>     Colored by Color Scripter

cs

[행복]

내용 좋네요.
DB의 자료들 가져오는 연습은 꾸준히 많이 하시고요..
화면 깔끔한게 아주 좋습니다. 수고하셨어요