Servlet & JSP day17 - MVC 모델을 응용한 회원정보 관리(회원탈퇴)

RemoveMemberServlet.java

☞ package : member.servlet

☞ type : Servlet - Controller 역할

 

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 void removeMemberById(String id) throws SQLException{
  dao.deleteMemberById(id);
 }
} 

 

MemberDAO.java

☞ package : member.model.dao

☞ type : class - Data Access Object(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.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 void deleteMemberById(String id) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "delete from member where id=?";
  try {
   conn = dbUtil.getDataSource().getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setString(1, id);
   pstmt.executeUpdate();
  }
  finally{
   dbUtil.close(pstmt, conn);
  }
 }
}

 

 

MemberManagerService.java

☞ package : member.model.service

☞ type : class - Business Logic을 처리(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 void removeMemberById(String id) throws SQLException{
  dao.deleteMemberById(id);
 }
}