Servlet & JSP day17 - MVC 모델을 응용한 회원정보 관리 (마일리지범위를 이용한 회원검색)

SearchByMileageRangeServlet.java

☞ package : member.servlet

☞ type : Servlet - Controller 역할

package member.servlet;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import member.dto.MemberDTO;
import member.model.service.MemberManagerService;

public class SearchByMileageRangeServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;
 
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  MemberManagerService mms = MemberManagerService.getInstance();
  String resUrl = null;
  try {
   ArrayList<MemberDTO> list = mms.searchMemberByMileageRange(Integer.parseInt(request.getParameter("range")), Integer.parseInt(request.getParameter("range1")));
   request.setAttribute("list", list);
   resUrl = "/res/search_result.jsp";
  } catch (Exception e) {
   e.printStackTrace();
   request.setAttribute("error_message", "입력 형태가 정확하지 않습니다");
   resUrl = "/res/error.jsp";
  }
  RequestDispatcher rdp = request.getRequestDispatcher(resUrl);
  rdp.forward(request, response);
 }

}

 

MemberManagerService.java

☞ package : member.model.dao

☞ type : class - Data Access Object(Model 역할)

package member.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import member.dto.MemberDTO;
import member.exception.DuplicatedIdException;
import member.exception.DuplicatedRegisterNumberException;
import member.model.dao.MemberDAO;

public class MemberManagerService {
 
 private static MemberManagerService instance = new MemberManagerService();
 private MemberDAO dao;
 private MemberManagerService() {
  dao = MemberDAO.getInstance();
 }
 public static MemberManagerService getInstance() {
  return instance;
 }

public ArrayList<MemberDTO> searchMemberByMileageRange(int s, int e) throws SQLException {
  return dao.selectMemberByMileageRange(s, e);
 }

 

MemberDAO.java

☞ package : member.model.service

☞ type : class - Business Logic을 처리(Model역할)

package member.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import member.dto.MemberDTO;
import member.model.service.MemberManagerService;
import member.util.DatabaseUtility;

public class MemberDAO {

 private static MemberDAO instance = new MemberDAO();
 private DatabaseUtility dbUtil;
 public static MemberDAO getInstance() {
  return instance;
 }
 private MemberDAO() {
  dbUtil = DatabaseUtility.getInstance();
 }

public ArrayList<MemberDTO> selectMemberByMileageRange(int s, int e) throws SQLException {
  ArrayList <MemberDTO> list = new ArrayList<MemberDTO>();
  MemberDTO mto = null;
  Connection conn =null;
  PreparedStatement pstmt =null;
  ResultSet rset=null;
  String sql = "select id, password, name, register_Number1, register_Number2, mileage from member where mileage between ? and ?";
  try {
   conn = dbUtil.getDataSource().getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, s);
   pstmt.setInt(2, e);
   rset = pstmt.executeQuery();
   while(rset.next()) {
    mto = new MemberDTO(rset.getString(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6));
    list.add(mto);
   }
  } finally {
   dbUtil.close(rset, pstmt, conn);
  }
  return list;
 }