Model2 Architecture - (2) 회원조회

1.JAVA Web Programming/[3주차]JSP+model2

Model2 Architecture - (2) 회원조회

서나브로 2019. 8. 1. 23:59

[회원검색 폼]

[검색결과 폼]

[실행화면]

1. 회원조회 폼

1) WebContent - index.jsp에 가입 url 기입

2) WebContent - findClient.jsp (검색 페이지)

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>회원검색</title> </head> <body> <h3>회원검색</h3> <form method="post" action="DispatcherServlet"> <input type="hidden" name="command" value="findClient"> 검색어 입력 <input type="text" name="keyword"> <input type="submit" value="검색"> </form> </body> </html>

3) WebContent - findClient_result.jsp (검색결과 확인 페이지)

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@page import="model.ClientDTO"%> <%@page import= "java.util.ArrayList"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> table, td, th { border: 1px solid #ddd; text-align: left; } table { border-collapse: collapse; width: 100%; } th, td { padding: 15px; } </style> </head> <body> <h3><span style="color:blue">"<%=request.getParameter("keyword") %>"</span> 검색결과</h3> <% ArrayList<ClientDTO> clientList=(ArrayList<ClientDTO>)request.getAttribute("clientList"); %> <% if(clientList.size()==0){ %> <script> alert("검색 결과가 없습니다."); location.href="http://localhost:8080/webstudy5-model2/findClient.jsp"; </script> <% } %> <table> <tr> <th>아이디</th> <th>이름</th> <th>이메일</th> <th>휴대번호</th> <th>주소</th> </tr> <% for(int i=0;i<clientList.size();i++){ ClientDTO client=clientList.get(i); %> <tr> <td><%=client.getClientId() %></td> <td><%=client.getClientName() %></td> <td><%=client.getClientEmail() %></td> <td><%=client.getClientPhone() %></td> <td><%=client.getClientAddress() %></td> </tr> <% } %> </table> </body> </html>

2. controller 변경

1) src - controller.HandlerMapping.java에 findClient추가

else if(command.equals("findClient")) c=new FindClientController();

2) src - controller.FindClientControlle.java 생성

package controller; import java.util.ArrayList; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import model.ClientDAO; import model.ClientDTO; public class FindClientController implements Controller { @Override public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception { String keyword=request.getParameter("keyword"); ArrayList<ClientDTO> clientList=ClientDAO.getInstance().findClient(keyword); request.setAttribute("clientList", clientList); return "findClient_result.jsp"; } }

3. model 변경

1) src - model.ClientDAO.java에 findclient 메소드 추가

public ArrayList<ClientDTO> findClient(String keyword) throws SQLException{ ArrayList<ClientDTO> clientList=new ArrayList<ClientDTO>(); Connection con=null; PreparedStatement pstmt=null; ResultSet rs=null; try { con=getConnection(); String sql="SELECT * FROM CLIENT WHERE clientId LIKE ? OR clientName LIKE ? OR clientEmail LIKE ? OR ClientAddress LIKE ?"; pstmt=con.prepareStatement(sql); pstmt.setString(1, "%"+keyword+"%"); pstmt.setString(2, "%"+keyword+"%"); pstmt.setString(3, "%"+keyword+"%"); pstmt.setString(4, "%"+keyword+"%"); rs=pstmt.executeQuery(); while(rs.next()) { ClientDTO client=new ClientDTO(rs.getString(1),null,rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6)); clientList.add(client); } }finally { closeAll(rs,pstmt,con); } return clientList; }