2012-4-30 servlet을 이용한 회원가입하기

프로그래밍/JSP Programming 2012. 4. 30. 10:02

dynamic web project
- member_servlet

- servlet class
package : member.servlet
name : RegiserMemberServlet
url-mapping : /register_member

package member.servlet;

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

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

/**
* Servlet implementation class RegiserMemberServlet
*/
public class RegiserMemberServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private Connection connection = null;
private PreparedStatement preparedStatement = null;

    public RegiserMemberServlet() {
        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 registerNo1 = request.getParameter("register_no1");
  String registerNo2 = request.getParameter("register_no2");
  String registerNo = registerNo1+registerNo2;
  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");
  PrintWriter printWriter = 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+"개의 행이 삽입되었습니다.");

   printWriter = response.getWriter();

printWriter.println("아이디 : "+id+" ");
 printWriter.println("패스워드 : "+password+" ");
 printWriter.println("이름 : "+name+" ");
 printWriter.println("주민번호 : "+registerNo+" ");
 printWriter.println("마일리지 : "+mileage+" ");
 printWriter.println("가입에 성공하셨습니다. ");
 printWriter.println("<a href='/member_servlet/login_form.jsp'>로그인</a>");

} catch (SQLException e) {
printWriter = response.getWriter();

printWriter.println("가입실패!. ");
 printWriter.println(e.getMessage()+" ");
 printWriter.println("<a href='/member_servlet/register_form.html'>가입하기</a>");

  } finally{
   if(printWriter !=null){
    printWriter.close();
   }
   if(preparedStatement!=null){
    try {
     preparedStatement.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   if(connection!=null){
    try {
     connection.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
  }
}

}

html
WebContent
이름 : register_form.html

class
package : member.dto
class : MemberDTO

package member.dto;

public class MemberDTO {
private String id;
private String password;
private String name;
private String registerNumber;
private int mileage;
public MemberDTO() {
  super();
}
public MemberDTO(String id, String password, String name,
   String registerNumber, int mileage) {
  super();
  this.id = id;
  this.password = password;
  this.name = name;
  this.registerNumber = registerNumber;
  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 getRegisterNumber() {
  return registerNumber;
}
public void setRegisterNumber(String registerNumber) {
  this.registerNumber = registerNumber;
}
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 + ", registerNumber=" + registerNumber + ", 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
    + ((registerNumber == null) ? 0 : registerNumber.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 (registerNumber == null) {
   if (other.registerNumber != null)
    return false;
  } else if (!registerNumber.equals(other.registerNumber))
   return false;
  return true;
}

}

'프로그래밍 > JSP Programming' 카테고리의 다른 글

2012-4-30 로그인 & 로그아웃하기 (0)	2012.04.30
2012-4-30 jsp를 활용한 회원등록하기 (0)	2012.04.30
2012-4-27 eclipse와 DB연결해서 Driver Loading 시키기[실습] (0)	2012.04.27
eclipse에서 DB연동하기 (0)	2012.04.27
2012-4 27 session scope[실습] (0)	2012.04.27