은성이의 프로그램X파일

package member.dto;

public class MemberDTO {
 private String id;
 private String password;
 private String name;
 private String registerNumber1;
 private String registerNumber2;
 private int mileage;
 public MemberDTO() {
  super();
 }
 public MemberDTO(String id, String password, String name,
   String registerNumber1, String registerNumber2, int mileage) {
  super();
  this.id = id;
  this.password = password;
  this.name = name;
  this.registerNumber1 = registerNumber1;
  this.registerNumber2 = registerNumber2;
  this.mileage = mileage;
 }
 public String getId() {
  return id;
 }
 public void setId(String id) {
  this.id = id;
 }
 public String getPassword() {
  return password;
 }
 public void setPassword(String password) {
  this.password = password;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public String getRegisterNumber1() {
  return registerNumber1;
 }
 public void setRegisterNumber1(String registerNumber1) {
  this.registerNumber1 = registerNumber1;
 }
 public String getRegisterNumber2() {
  return registerNumber2;
 }
 public void setRegisterNumber2(String registerNumber2) {
  this.registerNumber2 = registerNumber2;
 }
 public int getMileage() {
  return mileage;
 }
 public void setMileage(int mileage) {
  this.mileage = mileage;
 }
 @Override
 public String toString() {
  return "MemberDTO [id=" + id + ", password=" + password + ", name="
    + name + ", registerNumber1=" + registerNumber1
    + ", registerNumber2=" + registerNumber2 + ", mileage="
    + mileage + "]";
 }
 @Override
 public int hashCode() {
  final int prime = 31;
  int result = 1;
  result = prime * result + ((id == null) ? 0 : id.hashCode());
  result = prime * result + mileage;
  result = prime * result + ((name == null) ? 0 : name.hashCode());
  result = prime * result
    + ((password == null) ? 0 : password.hashCode());
  result = prime * result
    + ((registerNumber1 == null) ? 0 : registerNumber1.hashCode());
  result = prime * result
    + ((registerNumber2 == null) ? 0 : registerNumber2.hashCode());
  return result;
 }
 @Override
 public boolean equals(Object obj) {
  if (this == obj)
   return true;
  if (obj == null)
   return false;
  if (getClass() != obj.getClass())
   return false;
  MemberDTO other = (MemberDTO) obj;
  if (id == null) {
   if (other.id != null)
    return false;
  } else if (!id.equals(other.id))
   return false;
  if (mileage != other.mileage)
   return false;
  if (name == null) {
   if (other.name != null)
    return false;
  } else if (!name.equals(other.name))
   return false;
  if (password == null) {
   if (other.password != null)
    return false;
  } else if (!password.equals(other.password))
   return false;
  if (registerNumber1 == null) {
   if (other.registerNumber1 != null)
    return false;
  } else if (!registerNumber1.equals(other.registerNumber1))
   return false;
  if (registerNumber2 == null) {
   if (other.registerNumber2 != null)
    return false;
  } else if (!registerNumber2.equals(other.registerNumber2))
   return false;
  return true;
 }
 
 
}

package member.model.dao;

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

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import member.dto.MemberDTO;
import member.util.DatabaseUtility;

public class MemberDAO {
 private static MemberDAO instance = new MemberDAO();
 private DatabaseUtility dbUtil;
 private MemberDAO(){
  dbUtil = DatabaseUtility.getInstance();
 }
 public MemberDAO getInstance(){
  return instance;
 }
 /*
  * id로 회원 정보를 조회하야 return 하는 메소드
  * @param id 조회할 회원 ID
  * @return
  * @throws SQLException
  */
 public MemberDTO selectMemberById(String id)throws SQLException{
  //조회된 결과가 없다면 mto에 null값이 넘어간다.
  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 id=?";
  try{
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setString(1, id);
   rset = pstmt.executeQuery();
   if(rset.next()){
    mto = new MemberDTO(rset.getString(1),rset.getString(2),rset.getString(3),rset.getString(4),rset.getString(5),rset.getInt(6));
   }
  }finally{
   dbUtil.close(rset, pstmt, conn);
  }
  return mto;
 }
 /*
  * 주민번호로 회원 정보를 조회하는 메소드
  * @param registerNumber1 주민번호 앞6자리
  * @param registerNumber2 주민번호 뒤7자리
  * @return
  * @thows SQLException
  */
 public MemberDTO selectMemberByregisterNumber(String registerNumber1, String registerNumber2)throws SQLException{
  MemberDTO mto= null;
  BasicDataSource ds = dbUtil.getDataSource();
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select id, password, name, register_number1, register_number2, mileage from member where register_Number1=? and register_Number2=?";
  try{
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setString(1, registerNumber1);
   pstmt.setString(2, registerNumber2);
   rset = pstmt.executeQuery();
   if(rset.next()){
    mto = new MemberDTO(rset.getString(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6));
   }
  }finally{
   dbUtil.close(rset, pstmt, conn);
  }
  return mto;
 }
 /*
  * 회원정보를 DB에 insert하는 메소드
  * @param mto 등록할 회원 정보
  * @throws SQLEception
  */
 public void insertMember(MemberDTO mto)throws SQLException{
  BasicDataSource ds = dbUtil.getDataSource();
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "insert into member (id, password, name, register_number1, register_number2, mileage) values(?,?,?,?,?,?)";
  
  try{
  conn = ds.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setString(1, mto.getId());
  pstmt.setString(2, mto.getPassword());
  pstmt.setString(3, mto.getName());
  pstmt.setString(4, mto.getRegisterNumber1());
  pstmt.setString(5, mto.getRegisterNumber2());
  pstmt.setInt(6, mto.getMileage());
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 삽입되었습니다.");
  }finally{
   dbUtil.close(pstmt, conn);
  }
 }
}

package member.util;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

//디비 관련과 커넥션을 만들어 놓은 클래스
//싱글톤 패턴을 사용해서 커넥션이 한번만 되도록 설정.
public class DatabaseUtility {
 //싱글톤 패턴 - 생성자에서 DataSource객체를 생성해서 instance변수에 할당.
 private BasicDataSource dataSource;
 private static DatabaseUtility instance = new DatabaseUtility();

 private DatabaseUtility(){
  dataSource = new BasicDataSource();//객체 생성
  //프라퍼티 설정
  //1. 연결할 DB와 관련된 설정
  dataSource.setDriverClassName("oracle.jdbc.driver.OracleDriver");//BasicDataSource를 사용하면 따로 드라이버 로딩을 해줄 필요가 없다. 바로 처리가능
  dataSource.setUrl("jdbc:oracle:thin:@127.0.0.1:1521:XE");
  dataSource.setUsername("scott");
  dataSource.setPassword("tiger");

 }
 public static DatabaseUtility getInstance(){
  return instance;
 }
 public BasicDataSource getDataSource(){//커넥션을 가져갈 수 있도록 만듬.
  return dataSource;
 }
 public void close(Statement stmt, Connection conn){
  if(stmt!=null){
   try {
    stmt.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
  if(conn!=null){
   try {
    conn.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
 }
 public void close(ResultSet rset, Statement stmt, Connection conn){
  if(rset!=null){
   try {
    rset.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
  if(stmt!=null){
   try {
    stmt.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
  if(conn!=null){
   try {
    conn.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
 }
}

package memver.model.service;

import java.sql.SQLException;

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

public class MemberManageService {
 //회원 관리 비지니스 로직을 처리하는 Business Service 클래스
 private static MemberManageService instance = new MemberManageService();
 private MemberDAO dao;
 private MemberManageService(){
  dao = MemberDAO.getInstance();
 }
 public static MemberManageService getInstance(){
  return instance;
 }
 //가입 처리 메소드
 public void registerMember(MemberDTO mto)throws SQLException, DuplicatedIdException, DuplicatedRegisterNumberException{

  
  //1. 등록된 ID가 있는 지 체크
  //   - 이미 등록된 ID라면 DuplicatedIdException를 발생시킨다.
  if(dao.selectMemberById(mto.getId())!=null){
   throw new DuplicatedIdException(mto.getId()+"는 이미등록된 아이디 입니다.");
   
  }
  //2. 등록된 주민번호가 있는 지 체크
  //   - 이미 등록된 주민번호라면 DuplicatedRegisterNumberException 발생시킨다.
  if(dao.selectMemberByregisterNumber(mto.getRegisterNumber1(), mto.getRegisterNumber2())!=null){
   throw new DuplicatedRegisterNumberException("는 이미 가입된 주민번호 입니다.");
  }
  //3. 디비에 회원정보 등록 처리
  dao.insertMember(mto);
 }
}

package member.exception;

public class DuplicatedIdException extends Exception{
 public DuplicatedIdException(){}
 public DuplicatedIdException(String message){
  super(message);
 }
}

package member.exception;

public class DuplicatedRegisterNumberException extends Exception{
 public DuplicatedRegisterNumberException(){}
 public DuplicatedRegisterNumberException(String message){
  super(message);
 }
}