은성이의 프로그램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);
 }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="test_result.jsp" method="post">
조회 ID : <input type="text" name="id"><input type="submit" value="조회">
</form>
</body>
</html>

<%@page import="model.dto.TestDTO"%>
<%@page import="model.dao.TestDAO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
 String id = request.getParameter("id");
 TestDAO dao = TestDAO.getInstance();
 TestDTO dto = dao.selectTestById(id);
 if(dto==null){ 
%>
 조회결과가 없습니다.
<%}else{%>
조회결과<br>
ID : <%=dto.getId() %><br>
Num : <%=dto.getNum() %>
<%} %><br>
<a href="test_select.jsp">조회폼</a>
</body>
</html>

package 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 model.dto.TestDTO;

//Test 테이블과 관련된 DB로직을 처리하는 DAO클래스
public class TestDAO {
 private BasicDataSource ds; //서버(톰켓)에서 제공해 주는 객체
 //싱글턴 패턴을 사용하여 커넥션풀이 한번만 생성되도록 설정하였다. getInstance()를 통해서 객체를 받는다.
 private static TestDAO instance = new TestDAO();
 public static TestDAO getInstance(){
  return instance;
 }
 private TestDAO(){
  ds = new BasicDataSource();//객체 생성
  //프라퍼티 설정
  //1. 연결할 DB와 관련된 설정
  ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");//BasicDataSource를 사용하면 따로 드라이버 로딩을 해줄 필요가 없다. 바로 처리가능
  ds.setUrl("jdbc:oracle:thin:@127.0.0.1:1521:XE");
  ds.setUsername("scott");
  ds.setPassword("tiger");
  //2. Connection Pool 관련 설정
  ds.setInitialSize(1);//초기에 생성될 커넥션객체의 수. default : 0
  ds.setMaxActive(10);//최대 몇개의 커넥션 객체를 만들 것인지, default : 8
  ds.setMaxIdle(3);//사용되지 않고 대기하는 커넥션객체의 최대 개수. default : 0 , (풀에서 기다리고 있는 커넥션객체의 수를 지정해 주겠다)
  ds.setMinIdle(1);//사용되지 않고 대기하는 커넥션객체의 최소 개수. default : 0
  
 }
 //test 테이블의 레코드를 id를 통해 조회하는 메소드
 public TestDTO selectTestById(String id)throws SQLException{
  //중간에 예외가 발생하더라도 connection 연결은 끊어 줘야 해서 try{}finally{}를 사용했다. (try{}finally{}를 사용하지 않으면 중간에 예외가 발생했을 경우 connection연결을 하되 반납하는 작업을 할 수 없다. )
  String sql = "select id, num from test where id = ?";
  Connection conn = null;
  PreparedStatement pstmt = null;
  TestDTO dto = null;
  ResultSet rset = null;
  try {
   conn = ds.getConnection(); //커넥션 하나를 대여 받겠다.
   pstmt = conn.prepareStatement(sql);
   pstmt.setString(1, id);
   rset = pstmt.executeQuery();
   if(rset.next()){
    dto = new TestDTO(rset.getString(1), rset.getInt(2));
   }
  } finally{
   if(rset!=null) rset.close();
   if(pstmt!=null) pstmt.close();
   
   if(conn!=null) conn.close();//베이직 데이터 소스에 있는 것을 close하면 커넥션 풀로 반납한다.(connection만), 나머지는 연결을 끊음(rset, pstmt)
  }
  return dto;
 }
}

package model.dto;

public class TestDTO {
 private String id;
 private int num;
 public TestDTO(String id, int num) {
  super();
  this.id = id;
  this.num = num;
 }
 public TestDTO() {
  super();
  // TODO Auto-generated constructor stub
 }
 public String getId() {
  return id;
 }
 public void setId(String id) {
  this.id = id;
 }
 public int getNum() {
  return num;
 }
 public void setNum(int num) {
  this.num = num;
 }
 @Override
 public String toString() {
  return "TestDTO [id=" + id + ", num=" + num + "]";
 }
 @Override
 public int hashCode() {
  final int prime = 31;
  int result = 1;
  result = prime * result + ((id == null) ? 0 : id.hashCode());
  result = prime * result + num;
  return result;
 }
 @Override
 public boolean equals(Object obj) {
  if (this == obj)
   return true;
  if (obj == null)
   return false;
  if (getClass() != obj.getClass())
   return false;
  TestDTO other = (TestDTO) obj;
  if (id == null) {
   if (other.id != null)
    return false;
  } else if (!id.equals(other.id))
   return false;
  if (num != other.num)
   return false;
  return true;
 }
 
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="/myjsp/calculatorController" method="post">
피연산자1 : <input type="text" name="op1"><br>
피연산자2 : <input type="text" name="op2"><br>
연산자 :
<select name="operator">
 <option>+</option>
 <option>-</option>
 <option>/</option>
 <option>X</option>
</select><br>
<input type="submit" value="계산">
</form>
</body>
</html>

package calc.controller;

import java.io.IOException;
import java.math.BigDecimal;

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

import calc.model.CalculatorService;

public class CalculatorServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public CalculatorServlet() {
        super();
     
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request,response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //Controller
  //1.요청파라미터 조회
  String op1 = request.getParameter("op1");
  String op2 = request.getParameter("op2");
  String operator = request.getParameter("operator");
  //2. Business Logic (모델2는 비지니스 로직을 처리는 하되 클래스의 메소드를 호출해서 처리하는 식으로 처리한다.)
  CalculatorService cs = new CalculatorService();
  String resUrl = null;
  try{
   BigDecimal result = cs.calculate(op1, op2, operator);
   request.setAttribute("result", result);
   resUrl = "/model2/calc_result.jsp";
  }catch(Exception e){
   e.printStackTrace();
   request.setAttribute("error_message", "관리자에게 문의하세요"+e.getMessage());
   resUrl = "/model2/error.jsp";
  }
  //3. 응답
  RequestDispatcher requestDispatcher = request.getRequestDispatcher(resUrl);
  requestDispatcher.forward(request, response);
 }

}

package calc.model;

import java.math.BigDecimal;
import java.math.MathContext;
import java.math.RoundingMode;

public class CalculatorService {
 //비지니스 로직
 public BigDecimal calculate(String op1, String op2, String operator)throws NumberFormatException{
  //10/3->0.333333333333 이럴 시 소수점 처리하기 위해 BigDecimal사용
  BigDecimal num1 = new BigDecimal(op1);
  BigDecimal num2 = new BigDecimal(op2);
  BigDecimal result = null;
  //올림 : UP, CEIL, 내림 : DOWN, FLOOR, 반올림 : 5일경우 : HALF_EVEN, HALF_DOWN, HALF_UP
  MathContext mc = new MathContext(3, RoundingMode.HALF_EVEN);//소수점 이하 몇자리, 반올림 처리
  if(operator.equals("+")){
   result = num1.add(num2, mc);
  }else if(operator.equals("-")){
   result = num1.subtract(num2, mc);
  }else if(operator.equals("X")){
   result = num1.multiply(num2, mc);
  }else if(operator.equals("/")){
   result = num1.divide(num2, mc);
  }
  return result;
 }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
계산결과 : ${requestScope.result }<br>
<a href="/myjsp/model2/calc_form.jsp">계산폼</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
오류가 발생했습니다. 관리자에게 문의하세요.<br>
오류내용 : ${requestScope.error_message }
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="/myjsp/calculatorController" method="post">
피연산자1 : <input type="text" name="op1"><br>
피연산자2 : <input type="text" name="op2"><br>
연산자 :
<select name="operator">
 <option>+</option>
 <option>-</option>
 <option>/</option>
 <option>X</option>
</select><br>
<input type="submit" value="계산">
</form>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
계산결과 : ${requestScope.result }<br>
<a href="/myjsp/model2/calc_form.jsp">계산폼</a>
</body>
</html>

package calc.controller;

import java.io.IOException;
import java.math.BigDecimal;

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

import calc.model.CalculatorService;

public class CalculatorServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public CalculatorServlet() {
        super();
     
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request,response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //Controller
  //1.요청파라미터 조회
  String op1 = request.getParameter("op1");
  String op2 = request.getParameter("op2");
  String operator = request.getParameter("operator");
  //2. Business Logic (모델2는 비지니스 로직을 처리는 하되 클래스의 메소드를 호출해서 처리하는 식으로 처리한다.)
  CalculatorService cs = new CalculatorService();
  BigDecimal result = cs.calculate(op1, op2, operator);
  //3. 응답
  request.setAttribute("result", result);
  RequestDispatcher requestDispatcher = request.getRequestDispatcher("/model2/calc_result.jsp");
  requestDispatcher.forward(request, response);
 }

}

package calc.model;

import java.math.BigDecimal;
import java.math.MathContext;
import java.math.RoundingMode;

public class CalculatorService {
 //비지니스 로직
 public BigDecimal calculate(String op1, String op2, String operator){
  //10/3->0.333333333333 이럴 시 소수점 처리하기 위해 BigDecimal사용
  BigDecimal num1 = new BigDecimal(op1);
  BigDecimal num2 = new BigDecimal(op2);
  BigDecimal result = null;
  //올림 : UP, CEIL, 내림 : DOWN, FLOOR, 반올림 : 5일경우 : HALF_EVEN, HALF_DOWN, HALF_UP
  MathContext mc = new MathContext(3, RoundingMode.HALF_EVEN);//소수점 이하 몇자리, 반올림 처리
  if(operator.equals("+")){
   result = num1.add(num2, mc);
  }else if(operator.equals("-")){
   result = num1.subtract(num2, mc);
  }else if(operator.equals("X")){
   result = num1.multiply(num2, mc);
  }else if(operator.equals("/")){
   result = num1.divide(num2, mc);
  }
  return result;
 }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>회원관리</h1>
<a href='/${initParam.context_root }/register_form.jsp'>회원가입폼</a><br>
<a href='/${initParam.context_root }/login_form.jsp'>로그인폼</a>
<a href='/${initParam.context_root }/getAllMemberInfo'>전체 회원 조회</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="/${initParam.context_root }/RegisterMemberServlet1" method="post">
<table border="1">
 <tr>
  <td align="center">id</td><td><input type="text" name="id" maxlength="10" size="10"></td>
 </tr>
 <tr>
  <td align="center">pwd</td><td><input type="password" name="pwd" maxlength="4" size="4"></td>
 </tr>
 <tr>
  <td align="center">이름 : </td><td><input type="text" name="name" maxlength="10" size="10"></td>
 </tr>
 <tr>
  <td align="center">주민번호 : </td>
  <td>
   <input type="text" name="register_no" maxlength="13" size="13">-
  
  </td>
 </tr>
 <tr>
  <td colspan="2" align="center"><input type="submit" value="가입">
  <input type="reset" value="다시작성"></td>
 </tr>
</table>
</form>
</body>
</html>

package member.servlet;

import java.io.IOException;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

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

import member.dto.MemberDTO;

public class RegisterMemberServlet1 extends HttpServlet {
 
 private static final long serialVersionUID = 1L;
 private Connection connection = null;
 private PreparedStatement preparedStatement = null;

    public RegisterMemberServlet1() {
        super();
        // TODO Auto-generated constructor stub
    }
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1.요청파라미터 조회
  //2. Business Logic 처리
      //1. Connection
      //2. PreparedStatement
      //3. SQL 문 전송(insert)
      //4. close
  //3. 응답처리
      // 클라이언트로 받은 가입정보를 출력한뒤 가입처리 성공 메세지 응답.
  //1.요청 파라미터 조회
  request.setCharacterEncoding("utf-8");
  
  String id = request.getParameter("id");
  String password = request.getParameter("pwd");
  String name = request.getParameter("name");
  String registerNo = request.getParameter("register_no");
 
  int mileage = 1000;
  
  response.setContentType("text/html;charset=utf-8");
  //Business Logic 처리
  ServletContext ctx = getServletContext();
  String url = ctx.getInitParameter("url");
  String user = ctx.getInitParameter("user");
  String dbPwd = ctx.getInitParameter("password");
  String resUrl = null;
  try {
   connection = DriverManager.getConnection(url, user, dbPwd);
   String sql = "insert into member values(?,?,?,?,?)";
   preparedStatement = connection.prepareStatement(sql);
   preparedStatement.setString(1, id);
   preparedStatement.setString(2, password);
   preparedStatement.setString(3, name);
   preparedStatement.setString(4, registerNo);
   preparedStatement.setInt(5, mileage);
   int cnt = preparedStatement.executeUpdate();
   System.out.println(cnt+"개의 행이 삽입되었습니다.");
   
    //1. Business Logic처리
   //2. 조회한 정보 request scope에 binding
   MemberDTO memberDTO = new MemberDTO(id,password,name,registerNo,mileage);
    //3. member_list.jsp로 수행이동
     request.setAttribute("memberDTO", memberDTO);
     resUrl = "/res/register_success.jsp";
  } catch (SQLException e) {
    request.setAttribute("error_message", e.getMessage());
    resUrl = "/res/error.jsp";
  } finally{
   if(preparedStatement!=null){
    try {
     preparedStatement.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if(connection!=null){
    try {
     connection.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
  }
   RequestDispatcher rdp = request.getRequestDispatcher(resUrl);
   rdp.forward(request, response);
 }

}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<c:if test="${requestScope.error_message!=null }">
<font color="red">${requestScope.error_message }</font>
</c:if>
<body>
<form action="/${initParam.context_root }/login" method="post">
<table>
 <tr>
  <td><h2>로그인</h2><p></td>
 </tr>
 <tr>
  <td>id</td><td><input type="text" name="id"></td>
 </tr>
 <tr>
  <td>password</td><td><input type="password" name="password"></td>
 </tr>
  <tr>
  <td colspan="2"><input type="submit" value="로그인"><input type="reset" value="초기화"></td>
 </tr>
</table>
</form>
</body>
</html>

package member.servlet;

import java.io.IOException;

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

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

import member.dto.MemberDTO;
 
public class LoginServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;
 private Connection connection = null;
 private PreparedStatement preparedStatement = null;
 private ResultSet rset = null;
    public LoginServlet() {
        super();
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request,response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 요청파라미터 조회
  request.setCharacterEncoding("utf-8");
  String contextRoot = getServletContext().getInitParameter("context_root");
  String id = request.getParameter("id");
  String password = request.getParameter("password");
  HttpSession session = request.getSession();
  response.setContentType("text/html;charset=utf-8");
  //Business Logic 처리
  ServletContext ctx = getServletContext();
  String url = ctx.getInitParameter("url");
  String user = ctx.getInitParameter("user");
  String dbPwd = ctx.getInitParameter("password");
 
  String sql = "select * from member where id=?";
  String resUrl=null;
  try {
   connection = DriverManager.getConnection(url, user, dbPwd);
   
   preparedStatement = connection.prepareStatement(sql);
   preparedStatement.setString(1, id);
    rset =  preparedStatement.executeQuery();
   System.out.println("로그인 성공!!");
   
      if(rset.next()) {
       if(rset.getString("password").equals(password)){
        MemberDTO memberDTO  = new MemberDTO(id, password, rset.getString(3), rset.getString(4), rset.getInt(5));
        session.setAttribute("memberDTO", memberDTO);
        response.sendRedirect("/"+contextRoot+"/res/login_success.jsp"); 
       }else{
        request.setAttribute("error_message", "패스워드가 틀렸습니다");
        resUrl = "/login_form.jsp";
       }
      }else{//id가 없는 경우
       request.setAttribute("error_message", "아이디가 틀렸습니다");
       resUrl = "/login_form.jsp";
      }
   

  } catch (SQLException e) {
    request.setAttribute("error_message", e.getMessage());
    RequestDispatcher rdp = request.getRequestDispatcher("/res/error.jsp");
    rdp.forward(request, response);

  } finally{
   if(rset!=null){
    try {
     rset.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if(preparedStatement!=null){
    try {
     preparedStatement.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if(connection!=null){
    try {
     connection.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
  }
  if(resUrl!=null){
  RequestDispatcher rdp = request.getRequestDispatcher(resUrl);
   rdp.forward(request, response);
  }
 }

}

<%@page import="member.dto.MemberDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
${sessionScope.memberDTO.id } 님환영합니다.<p>
이름 : ${sessionScope.memberDTO.name }<br>
패스워드 : ${sessionScope.memberDTO.password }<br>
주민번호 : ${sessionScope.memberDTO.registerNumber }<br>
마일리지 : ${sessionScope.memberDTO.mileage }<br>
<a href='/${initParam.context_root }/logout'>로그아웃</a>
<a href='/${initParam.context_root }/getMemberInfo'>회원정보조회(로그인한 회원의 정보)</a>
<!--<input  type="button" value="회원정보조회" onClick="location.href='/${initParam.context_root }/getMemberInfo'">   -->
</body>
</html>

package member.servlet;

import java.io.IOException;

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

import member.dto.MemberDTO;

public class GetLoginMemberInfoServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public GetLoginMemberInfoServlet() {
        super();
     
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request,response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  HttpSession httpSession = request.getSession();
  RequestDispatcher rdp =null;
  MemberDTO memberDTO=(MemberDTO)httpSession.getAttribute("memberDTO");
  String resUrl = null;
  if(memberDTO==null){
   request.setAttribute("error_message", "로그인한 정보가 없습니다.");
   resUrl = "/login_form.jsp";
  }else{
   resUrl ="/res/member_details.jsp";
  }
     rdp = request.getRequestDispatcher(resUrl);
  rdp.forward(request, response);
  
 }

}

<%@page import="member.dto.MemberDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>

<body>
<h2>회원정보수정</h2><hr><p>
<form action="/${initParam.context_root }/modifyMember" method="post">
<table width="500">
<tr>
 <td>아이디</td><td>${sessionScope.memberDTO.id }</td>
</tr>
<tr>
 <td>비밀번호</td><td><input type="text" name="password"></td>
</tr>
<tr>
 <td>이름</td><td><input type="text" name="name" value="${sessionScope.memberDTO.name }"></td>
</tr>
<tr>
 <td>주민번호</td><td><input type="text" name="register_no" value="${sessionScope.memberDTO.registerNumber }"></td>
</tr>
<tr>
 <td>마일리지 ${sessionScope.memberDTO.mileage }</td>
</tr>
<tr>
 <td colspan="2" align="center"><input type="submit" value="정보수정"><input type="reset" value="다시작성"></td>
</tr>
</table>
</form>
</body>
</html>

package member.servlet;

import java.io.IOException;

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

import member.dto.MemberDTO;

public class ModifyFormServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public ModifyFormServlet() {
        super();
     
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request,response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  HttpSession httpSession = request.getSession();
  MemberDTO memberDTO = (MemberDTO) httpSession.getAttribute("memberDTO");
  String resUrl = null;
  if(memberDTO==null){
   httpSession.setAttribute("error_message", "로그인 정보가 없습니다");
   resUrl = "/login_form.jsp";
  }else{
   resUrl = "/res/modify_form.jsp";
  }
  RequestDispatcher requestDispatcher = request.getRequestDispatcher(resUrl);
  requestDispatcher.forward(request, response);
 }

}

<%@page import="member.dto.MemberDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>

<body>
<h2>수정된 정보</h2><hr><p>
아이디 : ${sessionScope.memberDTO.id }<br>
비밀번호 : ${sessionScope.memberDTO.password }<br>
이름 : ${sessionScope.memberDTO.name }<br>
주민번호 : ${sessionScope.memberDTO.registerNumber }<br>
마일리지 : ${sessionScope.memberDTO.mileage }<br>
</body>
</html>

package member.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

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

import member.dto.MemberDTO;

public class ModifyMemberServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

 public ModifyMemberServlet() {
  super();

 }

 protected void doGet(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  request.setCharacterEncoding("utf-8");
  // 1. 파라미터 조회
  String password = request.getParameter("password");
  String name = request.getParameter("name");
  String registerNo = request.getParameter("register_no");
 

  // 2. DB연결
 
  ServletContext servletContext = getServletContext();
  String url = servletContext.getInitParameter("url");
  String user = servletContext.getInitParameter("user");
  String dbPwd = servletContext.getInitParameter("password");

  Connection connection = null;
  PreparedStatement preparedStatement = null;

  String sql = "update member set password=?, name=?, register_Number=? where id=?";
  String resUrl = null;

 
  HttpSession httpSession = request.getSession();
  MemberDTO memberDTO = (MemberDTO) httpSession.getAttribute("memberDTO");
  if (memberDTO != null) {
   //3. 회원 정보 수정 처리
   try {
    connection = DriverManager.getConnection(url, user, dbPwd);
    preparedStatement = connection.prepareStatement(sql);
    preparedStatement.setString(1, password);
    preparedStatement.setString(2, name);
    preparedStatement.setString(3, registerNo);
    preparedStatement.setString(4, memberDTO.getId());
    int cnt = preparedStatement.executeUpdate();
    System.out.println(cnt + "개의 행이 수정되었습니다.");
    //수정 정보를 session scope에 넣기
//    memberDTO.setPassword(password);
//    memberDTO.setName(name);
//    memberDTO.setRegisterNumber(registerNo);
    //아래와 같이 넣어도 된다.
    memberDTO = new MemberDTO(memberDTO.getId(), password, name, registerNo,memberDTO.getMileage());
    httpSession.setAttribute("memberDTO", memberDTO);
//    resUrl = "/res/modify_success.jsp";//아래 소스와 소스가 같아서 변경 처리 했다.
    resUrl = "/res/member_details.jsp";
   } catch (SQLException e) {
    request.setAttribute("error_message", e.getMessage());
    resUrl = "/res/error.jsp";
   } finally {
    if (preparedStatement != null) {
     try {
      preparedStatement.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }
    if (connection != null) {
     try {
      connection.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }
   }
  }else{ //로그인이 안된경우
   request.setAttribute("error_message", "로그인 정보가 없습니다. 수정 불가능 합니다.");
   resUrl = "/login_form.jsp";
  }
  RequestDispatcher requestDispatcher = request.getRequestDispatcher(resUrl);
  requestDispatcher.forward(request, response);
 }

}

<%@page import="member.dto.MemberDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>

 <h2>회원정보보기</h2><p>
 아이디 : ${sessionScope.memberDTO.id }<br>
 이름 : ${sessionScope.memberDTO.name }<br>
 주민번호 : ${sessionScope.memberDTO.registerNumber }<br>
 마일리지 : ${sessionScope.memberDTO.mileage }<br>
 <p>
  <a href="/${initParam.context_root }/modifyForm">회원정보수정</a>
  <a href="/${initParam.context_root }/removeMember">회원 탈퇴</a>
 </p>
</body>
</html>

package member.servlet;

import java.io.IOException;

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

import member.dto.MemberDTO;

public class LogoutServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

 public LogoutServlet() {
  super();

 }

 protected void doGet(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  HttpSession session = request.getSession();
  //로그인 여부 체크
  MemberDTO memberDTO = (MemberDTO) session.getAttribute("memberDTO");
  
  if (memberDTO != null) {
   session.invalidate(); //세션을 지우기

  } else {
   request.setAttribute("error_message", "먼저 로그인 해주세요");

  }

  RequestDispatcher rdp = request.getRequestDispatcher("/login_form.jsp");
  rdp.forward(request, response);

 }

}

<%@page import="member.dto.MemberDTO"%>
<%@page import="java.util.ArrayList"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>

 
<body>
<h2>모든 회원 목록조회</h2><hr><p>
<table width="500" border="1" cellspacing="0">
<tr align="center">
 <td>순번</td><td>아이디</td><td>이름</td><td>주민번호</td><td>마일리지</td>
</tr>
<c:forEach  items="${requestScope.member_list }" var="member_list" varStatus="cnt">
<tr align="center">
 <td>${cnt.count }</td><td>${member_list.id }</td><td><a href="/servlet_member/SearchMemberByID?id=${member_list.id }">${member_list.name }</a></td><td>${member_list.registerNumber }</td><td>${member_list.mileage }</td>
</tr>
</c:forEach>
</table>
</body>
</html>

package member.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

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

import member.dto.MemberDTO;

public class RemoveMemberServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public RemoveMemberServlet() {
        super();

    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request,response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  HttpSession httpSession = request.getSession();
  MemberDTO memberDTO = (MemberDTO)httpSession.getAttribute("memberDTO");
  
  //DB연결
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  ServletContext servletContext = getServletContext();
  String url = servletContext.getInitParameter("url");
  String user = servletContext.getInitParameter("user");
  String dbPwd = servletContext.getInitParameter("password");
  
  String sql = "delete from member where id=?";
  String resUrl = null;
  if(memberDTO!=null){
  try {
   connection = DriverManager.getConnection(url, user, dbPwd);
   preparedStatement = connection.prepareStatement(sql);
   preparedStatement.setString(1, memberDTO.getId());
   int cnt = preparedStatement.executeUpdate();
   System.out.println(cnt+"개의 행이 삭제 되었습니다.");
   resUrl = "/index.jsp";
   httpSession.invalidate();
   //httpSession.removeAttribute("memberDTO");
  } catch (SQLException e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   resUrl = "/res/error.jsp";
  } finally{
   if(preparedStatement!=null){
    try {
     preparedStatement.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if(connection!=null){
    try {
     connection.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
  }
 }else{
  request.setAttribute("error_message", "로그인 정보가 없습니다.");
  resUrl = "/login_form.jsp";
 }
  RequestDispatcher requestDispatcher = request.getRequestDispatcher(resUrl);
  requestDispatcher.forward(request, response);
 }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>

<c:if test="${requestScope.error_message!=null }">
실행 도중 오류가 발생했습니다.<br>
오류 내용 ${error_message }
</c:if>
<a href='/${initParam.context_root }/index.jsp'>메인페이지로 이동</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>회원관리</h1>
<a href='/${initParam.context_root }/register_form.jsp'>회원가입폼</a><br>
<a href='/${initParam.context_root }/login_form.jsp'>로그인폼</a>
<a href='/${initParam.context_root }/getAllMemberInfo'>전체 회원 조회</a>
</body>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="/${initParam.context_root }/RegisterMemberServlet1" method="post">
<table border="1">
 <tr>
  <td align="center">id</td><td><input type="text" name="id" maxlength="10" size="10"></td>
 </tr>
 <tr>
  <td align="center">pwd</td><td><input type="password" name="pwd" maxlength="4" size="4"></td>
 </tr>
 <tr>
  <td align="center">이름 : </td><td><input type="text" name="name" maxlength="10" size="10"></td>
 </tr>
 <tr>
  <td align="center">주민번호 : </td>
  <td>
   <input type="text" name="register_no" maxlength="13" size="13">
   
  
  </td>
 </tr>
 <tr>
  <td colspan="2" align="center"><input type="submit" value="가입">
  <input type="reset" value="다시작성"></td>
 </tr>
</table>
</form>
</body>
</html>

package member.servlet;

import java.io.IOException;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

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

import member.dto.MemberDTO;

public class RegisterMemberServlet1 extends HttpServlet {
 
 private static final long serialVersionUID = 1L;
 private Connection connection = null;
 private PreparedStatement preparedStatement = null;

    public RegisterMemberServlet1() {
        super();
        // TODO Auto-generated constructor stub
    }
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1.요청파라미터 조회
  //2. Business Logic 처리
      //1. Connection
      //2. PreparedStatement
      //3. SQL 문 전송(insert)
      //4. close
  //3. 응답처리
      // 클라이언트로 받은 가입정보를 출력한뒤 가입처리 성공 메세지 응답.
  //1.요청 파라미터 조회
  request.setCharacterEncoding("utf-8");
  
  String id = request.getParameter("id");
  String password = request.getParameter("pwd");
  String name = request.getParameter("name");
  String registerNo = request.getParameter("register_no");
  
  int mileage = 1000;
  
  response.setContentType("text/html;charset=utf-8");
  //Business Logic 처리
  ServletContext ctx = getServletContext();
  String url = ctx.getInitParameter("url");
  String user = ctx.getInitParameter("user");
  String dbPwd = ctx.getInitParameter("password");
  String resUrl = null;
  try {
   connection = DriverManager.getConnection(url, user, dbPwd);
   String sql = "insert into member values(?,?,?,?,?)";
   preparedStatement = connection.prepareStatement(sql);
   preparedStatement.setString(1, id);
   preparedStatement.setString(2, password);
   preparedStatement.setString(3, name);
   preparedStatement.setString(4, registerNo);
   preparedStatement.setInt(5, mileage);
   int cnt = preparedStatement.executeUpdate();
   System.out.println(cnt+"개의 행이 삽입되었습니다.");
   
    //1. Business Logic처리
   //2. 조회한 정보 request scope에 binding
   MemberDTO memberDTO = new MemberDTO(id,password,name,registerNo,mileage);
    //3. member_list.jsp로 수행이동
     request.setAttribute("memberDTO", memberDTO);
     resUrl = "/res/register_success.jsp";
  } catch (SQLException e) {
    request.setAttribute("error_message", e.getMessage());
    resUrl = "/res/error.jsp";
  } finally{
   if(preparedStatement!=null){
    try {
     preparedStatement.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if(connection!=null){
    try {
     connection.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
  }
   RequestDispatcher rdp = request.getRequestDispatcher(resUrl);
   rdp.forward(request, response);
 }

}

<%@page import="member.dto.MemberDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<c:set var="memberDTO" scope="request" value="${memberDTO }"/>
<%--
<%
 MemberDTO memberDTO = (MemberDTO)request.getAttribute("memberDTO");
%>
--%>
<h2>가입 환영합니다.</h2>
<h3>가입 시 입력한 정보입니다. </h3>
<%--  ID : <%=memberDTO.getId() %>  --%>
ID : ${requestScope.memberDTO.id }
<%-- Password : <%=memberDTO.getPassword() %>  --%>
Password :${requestScope.memberDTO.password }
<%-- 이름 : <%=memberDTO.getName() %>  --%>
이름 :${requestScope.memberDTO.name }
<%-- 주민번호 : <%=memberDTO.getRegisterNumber().substring(0,6) %>-<%=memberDTO.getRegisterNumber().substring(6) %> --%>
주민번호 :${requestScope.memberDTO.registerNumber }
<%-- 마일리지 : <%=memberDTO.getMileage() %><p> --%>
마일리지 :${requestScope.memberDTO.mileage }
<a href="/${initParam.context_root }/login_form.jsp">로그인</a>
<a href="/${initParam.context_root }/index.jsp">메인페이지</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<c:set var="error_message" scope="request" value="${error_message }"/>
<%--
<%
 String error_message = (String)request.getAttribute("error_message");
 if(error_message!=null){
%>
--%>
<font color="red">${error_message } </font>
<%--  <font color="red"><%=error_message %></font>  --%>
<%--
<%
 }
%>
--%>
<body>
<form action="/${initParam.context_root }/login" method="post">
<table>
 <tr>
  <td><h2>로그인</h2><p></td>
 </tr>
 <tr>
  <td>id</td><td><input type="text" name="id"></td>
 </tr>
 <tr>
  <td>password</td><td><input type="password" name="password"></td>
 </tr>
  <tr>
  <td colspan="2"><input type="submit" value="로그인"><input type="reset" value="초기화"></td>
 </tr>
</table>
</form>
</body>
</html>

package member.servlet;

import java.io.IOException;

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

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

import member.dto.MemberDTO;
 
public class LoginServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;
 private Connection connection = null;
 private PreparedStatement preparedStatement = null;
 private ResultSet rset = null;
    public LoginServlet() {
        super();
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request,response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 요청파라미터 조회
  request.setCharacterEncoding("utf-8");
  String id = request.getParameter("id");
  String password = request.getParameter("password");
  HttpSession session = request.getSession();
  response.setContentType("text/html;charset=utf-8");
  //Business Logic 처리
  ServletContext ctx = getServletContext();
  String url = ctx.getInitParameter("url");
  String user = ctx.getInitParameter("user");
  String dbPwd = ctx.getInitParameter("password");
 
  String sql = "select * from member where id=?";
  String resUrl=null;
  try {
   connection = DriverManager.getConnection(url, user, dbPwd);
   
   preparedStatement = connection.prepareStatement(sql);
   preparedStatement.setString(1, id);
    rset =  preparedStatement.executeQuery();
   System.out.println("로그인 성공!!");
   
      if(rset.next()) {
       if(rset.getString("password").equals(password)){
        MemberDTO memberDTO  = new MemberDTO(id, password, rset.getString(3), rset.getString(4), rset.getInt(5));
        session.setAttribute("memberDTO", memberDTO);
        response.sendRedirect("/member_servlet_text/res/login_success.jsp"); 
       }else{
        request.setAttribute("error_message", "패스워드가 틀렸습니다");
        resUrl = "/login_form.jsp";
       }
      }else{//id가 없는 경우
       request.setAttribute("error_message", "아이디가 틀렸습니다");
       resUrl = "/login_form.jsp";
      }
   

  } catch (SQLException e) {
    request.setAttribute("error_message", e.getMessage());
    RequestDispatcher rdp = request.getRequestDispatcher("/res/error.jsp");
    rdp.forward(request, response);

  } finally{
   if(rset!=null){
    try {
     rset.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if(preparedStatement!=null){
    try {
     preparedStatement.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if(connection!=null){
    try {
     connection.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
  }
  if(resUrl!=null){
  RequestDispatcher rdp = request.getRequestDispatcher(resUrl);
   rdp.forward(request, response);
  }
 }

}

<%@page import="member.dto.MemberDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<c:set var="memberDTO" scope="session" value="${memberDTO }"/>
<%--
<%

 MemberDTO memberDTO = (MemberDTO)session.getAttribute("memberDTO");
 
%>
 --%>
<body>
<%--
<%=memberDTO.getId() %>님환영합니다.<p>
이름 : <%=memberDTO.getName() %><br>
패스워드 : <%=memberDTO.getPassword() %><br>
주민번호 : <%=memberDTO.getRegisterNumber() %><br>
마일리지 : <%=memberDTO.getMileage() %><br>
--%>
${sessionScope.memberDTO.id }님환영합니다.<p>
이름 : ${sessionScope.memberDTO.name }<br>
패스워드 : ${sessionScope.memberDTO.password }<br>
주민번호 : ${sessionScope.memberDTO.registerNumber }<br>
마일리지 : ${sessionScope.memberDTO.mileage }<br>
<a href='/${initParam.context_root }/logout'>로그아웃</a>
<a href='/${initParam.context_root }/getMemberInfo'>회원정보조회(로그인한 회원의 정보)</a>
<!--<input  type="button" value="회원정보조회" onClick="location.href='/member_servlet/getMemberInfo'">   -->
</body>
</html>

package member.servlet;

import java.io.IOException;

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

import member.dto.MemberDTO;

public class GetLoginMemberInfoServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public GetLoginMemberInfoServlet() {
        super();
     
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request,response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  HttpSession httpSession = request.getSession();
  RequestDispatcher rdp =null;
  MemberDTO memberDTO=(MemberDTO)httpSession.getAttribute("memberDTO");
  String resUrl = null;
  if(memberDTO==null){
   request.setAttribute("error_message", "로그인한 정보가 없습니다.");
   resUrl = "/login_form.jsp";
  }else{
   resUrl ="/res/member_details.jsp";
  }
     rdp = request.getRequestDispatcher(resUrl);
  rdp.forward(request, response);
  
 }

}
 

<%@page import="member.dto.MemberDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%--
<%
 MemberDTO memberDTO = (MemberDTO)session.getAttribute("memberDTO");
%>

 <h2>회원정보보기</h2><p>
 아이디 : <%=memberDTO.getId() %><br>
 이름 : <%=memberDTO.getName() %><br>
 주민번호 : <%=memberDTO.getRegisterNumber().substring(0, 6) %>-<%=memberDTO.getRegisterNumber().substring(6) %><br>
 마일리지 : <%=memberDTO.getMileage() %><br>
 <p>
  <a href="/member_servlet/modifyForm">회원정보수정</a>
  <a href="/member_servlet/removeMember">회원 탈퇴</a>
 </p>
 --%>
 
 <h2>회원정보보기</h2><p>
 아이디 : ${sessionScope.memberDTO.id }<br>
 이름 : ${sessionScope.memberDTO.name }<br>
 주민번호 : ${sessionScope.memberDTO.registerNumber }<br>
 마일리지 : ${sessionScope.memberDTO.mileage }<br>
 <p>
  <a href="/${initParam.context_root }/modifyForm">회원정보수정</a>
  <a href="/${initParam.context_root }/removeMember">회원 탈퇴</a>
 </p>
</body>
</html>

package member.servlet;

import java.io.IOException;

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

import member.dto.MemberDTO;

public class ModifyFormServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public ModifyFormServlet() {
        super();
     
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request,response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  HttpSession httpSession = request.getSession();
  MemberDTO memberDTO = (MemberDTO) httpSession.getAttribute("memberDTO");
  String resUrl = null;
  if(memberDTO==null){
   httpSession.setAttribute("error_message", "로그인 정보가 없습니다");
   resUrl = "/login_form.jsp";
  }else{
   resUrl = "/res/modify_form.jsp";
  }
  RequestDispatcher requestDispatcher = request.getRequestDispatcher(resUrl);
  requestDispatcher.forward(request, response);
 }

}

<%@page import="member.dto.MemberDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<%--
<%
MemberDTO memberDTO = (MemberDTO)session.getAttribute("memberDTO");
%>
 --%>
<body>
<h2>회원정보수정</h2><hr><p>
<form action="/${initParam.context_root }/modifyMember" method="post">
<table width="500">
<tr>
 <td>아이디</td><td>${sessionScope.memberDTO.id }</td>
</tr>
<tr>
 <td>비밀번호</td><td><input type="text" name="password"></td>
</tr>
<tr>
 <td>이름</td><td><input type="text" name="name" value="${sessionScope.memberDTO.name }"></td>
</tr>
<tr>
 <td>주민번호</td><td><input type="text" name="register_no" value="${sessionScope.memberDTO.registerNumber }"></td>
</tr>
<tr>
 <td>마일리지 ${sessionScope.memberDTO.mileage }</td>
</tr>
<tr>
 <td colspan="2" align="center"><input type="submit" value="정보수정"><input type="reset" value="다시작성"></td>
</tr>
</table>
</form>
</body>
</html>

package member.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

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

import member.dto.MemberDTO;

public class ModifyMemberServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

 public ModifyMemberServlet() {
  super();

 }

 protected void doGet(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  request.setCharacterEncoding("utf-8");
  // 1. 파라미터 조회
  String password = request.getParameter("password");
  String name = request.getParameter("name");
  String registerNo = request.getParameter("register_no");
 

  // 2. DB연결
 
  ServletContext servletContext = getServletContext();
  String url = servletContext.getInitParameter("url");
  String user = servletContext.getInitParameter("user");
  String dbPwd = servletContext.getInitParameter("password");

  Connection connection = null;
  PreparedStatement preparedStatement = null;

  String sql = "update member set password=?, name=?, registerNumber=? where id=?";
  String resUrl = null;

 
  HttpSession httpSession = request.getSession();
  MemberDTO memberDTO = (MemberDTO) httpSession.getAttribute("memberDTO");
  if (memberDTO != null) {
   //3. 회원 정보 수정 처리
   try {
    connection = DriverManager.getConnection(url, user, dbPwd);
    preparedStatement = connection.prepareStatement(sql);
    preparedStatement.setString(1, password);
    preparedStatement.setString(2, name);
    preparedStatement.setString(3, registerNo);
    preparedStatement.setString(4, memberDTO.getId());
    int cnt = preparedStatement.executeUpdate();
    System.out.println(cnt + "개의 행이 수정되었습니다.");
    //수정 정보를 session scope에 넣기
//    memberDTO.setPassword(password);
//    memberDTO.setName(name);
//    memberDTO.setRegisterNumber(registerNo);
    //아래와 같이 넣어도 된다.
    memberDTO = new MemberDTO(memberDTO.getId(), password, name, registerNo,memberDTO.getMileage());
    httpSession.setAttribute("memberDTO", memberDTO);
//    resUrl = "/res/modify_success.jsp";//아래 소스와 소스가 같아서 변경 처리 했다.
    resUrl = "/res/member_details.jsp";
   } catch (SQLException e) {
    request.setAttribute("error_message", e.getMessage());
    resUrl = "/res/error.jsp";
   } finally {
    if (preparedStatement != null) {
     try {
      preparedStatement.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }
    if (connection != null) {
     try {
      connection.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }
   }
  }else{ //로그인이 안된경우
   request.setAttribute("error_message", "로그인 정보가 없습니다. 수정 불가능 합니다.");
   resUrl = "/login_form.jsp";
  }
  RequestDispatcher requestDispatcher = request.getRequestDispatcher(resUrl);
  requestDispatcher.forward(request, response);
 }

}
 

<%@page import="member.dto.MemberDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%--
<%
 MemberDTO memberDTO = (MemberDTO)session.getAttribute("memberDTO");
%>

 <h2>회원정보보기</h2><p>
 아이디 : <%=memberDTO.getId() %><br>
 이름 : <%=memberDTO.getName() %><br>
 주민번호 : <%=memberDTO.getRegisterNumber().substring(0, 6) %>-<%=memberDTO.getRegisterNumber().substring(6) %><br>
 마일리지 : <%=memberDTO.getMileage() %><br>
 <p>
  <a href="/member_servlet/modifyForm">회원정보수정</a>
  <a href="/member_servlet/removeMember">회원 탈퇴</a>
 </p>
 --%>
 
 <h2>회원정보보기</h2><p>
 아이디 : ${sessionScope.memberDTO.id }<br>
 이름 : ${sessionScope.memberDTO.name }<br>
 주민번호 : ${sessionScope.memberDTO.registerNumber }<br>
 마일리지 : ${sessionScope.memberDTO.mileage }<br>
 <p>
  <a href="/${initParam.context_root }/modifyForm">회원정보수정</a>
  <a href="/${initParam.context_root }/removeMember">회원 탈퇴</a>
 </p>
</body>
</html>

<%@page import="member.dto.MemberDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<%--
<%
MemberDTO memberDTO = (MemberDTO)session.getAttribute("memberDTO");
%>
 --%>
<body>
<%--
<h2>수정된 정보</h2><hr><p>
아이디 : <%=memberDTO.getId() %><br>
비밀번호 : <%=memberDTO.getPassword() %><br>
이름 : <%=memberDTO.getName() %><br>
주민번호 : <%=memberDTO.getRegisterNumber().substring(0, 6) %>-<%=memberDTO.getRegisterNumber().substring(6) %><br>
마일리지 : <%=memberDTO.getMileage() %><br>
 --%>
 <h2>수정된 정보</h2><hr><p>
아이디 :${sessionScope.memberDTO.id }<br>
비밀번호 :${sessionScope.memberDTO.password }<br>
이름 :  ${sessionScope.memberDTO.name }<br>
주민번호 :${sessionScope.memberDTO.registerNumber }<br>
마일리지 :${sessionScope.memberDTO.mileage }<br>
</body>
</html>

package member.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

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

import member.dto.MemberDTO;

public class RemoveMemberServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public RemoveMemberServlet() {
        super();

    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request,response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  HttpSession httpSession = request.getSession();
  MemberDTO memberDTO = (MemberDTO)httpSession.getAttribute("memberDTO");
  
  //DB연결
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  ServletContext servletContext = getServletContext();
  String url = servletContext.getInitParameter("url");
  String user = servletContext.getInitParameter("user");
  String dbPwd = servletContext.getInitParameter("password");
  
  String sql = "delete from member where id=?";
  String resUrl = null;
  if(memberDTO!=null){
  try {
   connection = DriverManager.getConnection(url, user, dbPwd);
   preparedStatement = connection.prepareStatement(sql);
   preparedStatement.setString(1, memberDTO.getId());
   int cnt = preparedStatement.executeUpdate();
   System.out.println(cnt+"개의 행이 삭제 되었습니다.");
   resUrl = "/index.jsp";
   httpSession.invalidate();
   //httpSession.removeAttribute("memberDTO");
  } catch (SQLException e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   resUrl = "/res/error.jsp";
  } finally{
   if(preparedStatement!=null){
    try {
     preparedStatement.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if(connection!=null){
    try {
     connection.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
  }
 }else{
  request.setAttribute("error_message", "로그인 정보가 없습니다.");
  resUrl = "/login_form.jsp";
 }
  RequestDispatcher requestDispatcher = request.getRequestDispatcher(resUrl);
  requestDispatcher.forward(request, response);
 }
}
 

package member.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

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

import member.dto.MemberDTO;

public class GetAllMemberInfoServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

 public GetAllMemberInfoServlet() {
  super();

 }

 protected void doGet(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  ServletContext servletContext = getServletContext();
  String url = servletContext.getInitParameter("url");
  String user = servletContext.getInitParameter("user");
  String dbPwd = servletContext.getInitParameter("password");

  Connection connection = null;
  PreparedStatement preparedStatement = null;
  ResultSet resultSet = null;
  String sql = "select * from member";
  ArrayList<MemberDTO> list = new ArrayList<MemberDTO>();
  String resUrl = null;
  try {
   connection = DriverManager.getConnection(url, user, dbPwd);
   preparedStatement = connection.prepareStatement(sql);
   resultSet = preparedStatement.executeQuery();
   while (resultSet.next()) {
    MemberDTO memberDTO = new MemberDTO(resultSet.getString(1),
      resultSet.getString(2), resultSet.getString(3),
      resultSet.getString(4), resultSet.getInt(5));
    list.add(memberDTO);
   }
   request.setAttribute("member_list", list);
   resUrl ="/member_list.jsp";
   
  } catch (SQLException e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   resUrl = "/res/error.jsp";
  } finally {
   if (resultSet != null) {
    try {
     resultSet.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if (preparedStatement != null) {
    try {
     preparedStatement.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if (connection != null) {
    try {
     connection.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }

  }
  RequestDispatcher requestDispatcher = request.getRequestDispatcher(resUrl);
  requestDispatcher.forward(request, response);
 }

}

<%@page import="member.dto.MemberDTO"%>
<%@page import="java.util.ArrayList"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<c:set var="member_list" scope="request" value="${member_list }"/>
 
<%--
<%
 ArrayList<MemberDTO> member_list = (ArrayList<MemberDTO>)request.getAttribute("member_list");
%>
--%>
<body>

<h2>모든 회원 목록조회</h2><hr><p>
<table width="500" border="1" cellspacing="0">
<tr align="center">
 <td>순번</td><td>아이디</td><td>이름</td><td>주민번호</td><td>마일리지</td>
</tr>
<%--
<%
 for(int i=0;i<member_list.size();i++){
%>
<tr align="center">
 <td><%=i+1 %></td><td><%=member_list.get(i).getId() %></td><td><a href="/servlet_member/SearchMemberByID?id=<%=member_list.get(i).getId()%>"><%=member_list.get(i).getName() %></a></td><td><%=member_list.get(i).getRegisterNumber().substring(0, 6) %>-<%=member_list.get(i).getRegisterNumber().substring(6) %></td><td><%=member_list.get(i).getMileage() %></td>
</tr>
 
<%} %>
--%>
<c:forEach items="${requestScope.member_list }" var="member_list" varStatus="cnt">
<tr align="center">
<td>${cnt.count }</td><td>${member_list.id }</td><td><a href="/servlet_member/SearchMemberByID?id=${member_list.id }">${member_list.name }</a></td><td>${member_list.registerNumber }</td><td>${member_list.mileage }</td>
</tr>
</c:forEach>
</table>

</body>
</html>