서블릿 - 회원가입과 로그인

회원가입 : registration.html

<!DOCTYPE html>

<html>

<head>

window.onload = function(){

appendYear();

appendMonth();

appendDay();

$(function() {

$("#Datepicker").datepicker({

showOn: "both",

buttonImage: "button.png",

buttonImageOnly: true

});

}

function checkId(){

var checkId = $("input[name='memId']").val();

if(checkId != "" && typeof checkId != "undefined"){

spath ="http://localhost:8080/memberservlet/checkIdProc?memId="+checkId;

$.ajax({

url : spath,

dataType:'text',

type:'get',

success : function(data) {

alert(data)

},

error : function(data){

alert("err")

}

});

}

function appendYear(){

var date = new Date();

var year = date.getFullYear();

var selectValue = document.getElementById("year"); //대상의 id

var optionIndex = 0;

for(var i=year-100;i<=year;i++){

selectValue.add(new Option(i+"년",i),optionIndex++);

}

function appendMonth(){

var selectValue = document.getElementById("month"); //대상의 id

var optionIndex = 0;

for(var i=1;i<=12;i++){

selectValue.add(new Option(i+"월",i),optionIndex++);

}

function appendDay(){

var selectValue = document.getElementById("day"); //대상의 id

var optionIndex = 0;

for(var i=1;i<=31;i++){

selectValue.add(new Option(i+"일",i),optionIndex++);

}

$(function() {

$( "#memBirthPicker" ).datepicker({

dateFormat: 'yy-mm-dd'

});

</script>

</head>

<body>

<table>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>

</tr>

<tr>

<td>

<!-- <input type="hidden" name="memBirth">

<option>- 선택하세요 -</option>

</select>

<option>- 선택하세요 -</option>

</select>

<option>- 선택하세요 -</option>

</select> -->

</td>

</tr>

<tr>

<td>

<input type="radio" name="memGender" value="0">여성

<input type="radio" name="memGender" value="1">남성

</td>

</tr>

<tr>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

<br>

</form>

</body>

</html>

아이디 중복확인 서블릿 : checkIdProc.java

package member.action;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import member.bean.MemberDTO;

import member.dao.MemberDAO;

public class checkIdProc extends HttpServlet {

@Override

public void init() throws ServletException {

}

@Override

protected void doGet(HttpServletRequest request,

HttpServletResponse response)

throws ServletException, IOException {

PrintWriter out = response.getWriter();

MemberDAO memberDAO = new MemberDAO();

String memId = request.getParameter("memId");

MemberDTO memberDTO = new MemberDTO();

memberDTO=memberDAO.isExistId(memId); // member DB에 memId가 있는지 확인

response.setContentType("text/xml; charset=UTF-8");

if(memberDTO == null){

response.getWriter().print("no");

}else{

response.getWriter().print(memberDTO.getMemId());

}

@Override

public void destroy() {

}

회원 객체 : MemberDTO

package member.bean;

public class MemberDTO {

private String memName;

private String memId;

private String memPwd;

private String memBirth;

private int memGender;

private String memZipcode;

private String memAddr;

private String memEmail;

private String memHomePhone;

private String memCellPhone;

private String memType;

private String memGrade;

private String memPoint;

private String logtime;

public String getMemName() {

return memName;

}

public void setMemName(String memName) {

this.memName = memName;

}

public String getMemId() {

return memId;

}

public void setMemId(String memId) {

this.memId = memId;

}

public String getMemPwd() {

return memPwd;

}

public void setMemPwd(String memPwd) {

this.memPwd = memPwd;

}

public String getMemBirth() {

return memBirth;

}

public void setMemBirth(String memBirth) {

this.memBirth = memBirth;

}

public int getMemGender() {

return memGender;

}

public void setMemGender(int memGender) {

this.memGender = memGender;

}

public String getMemZipcode() {

return memZipcode;

}

public void setMemZipcode(String memZipcode) {

this.memZipcode = memZipcode;

}

public String getMemAddr() {

return memAddr;

}

public void setMemAddr(String memAddr) {

this.memAddr = memAddr;

}

public String getMemEmail() {

return memEmail;

}

public void setMemEmail(String memEmail) {

this.memEmail = memEmail;

}

public String getMemHomePhone() {

return memHomePhone;

}

public void setMemHomePhone(String memHomePhone) {

this.memHomePhone = memHomePhone;

}

public String getMemCellPhone() {

return memCellPhone;

}

public void setMemCellPhone(String memCellPhone) {

this.memCellPhone = memCellPhone;

}

public String getMemType() {

return memType;

}

public void setMemType(String memType) {

this.memType = memType;

}

public String getMemGrade() {

return memGrade;

}

public void setMemGrade(String memGrade) {

this.memGrade = memGrade;

}

public String getMemPoint() {

return memPoint;

}

public void setMemPoint(String memPoint) {

this.memPoint = memPoint;

}

public String getLogtime() {

return logtime;

}

public void setLogtime(String logtime) {

this.logtime = logtime;

}

데이터 접근 객체 : MemberDAO

package member.dao;

import java.io.IOException;

import java.io.Reader;

import java.util.List;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import member.bean.MemberDTO;

public class MemberDAO {

// singleton

private static MemberDAO instance;

private SqlSessionFactory factory;

public static MemberDAO getInstance() {

if (instance == null) {

synchronized (MemberDAO.class) {

instance = new MemberDAO();

}

return instance;

}

// constructor

public MemberDAO() {

//InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");

try {

Reader reader = Resources.getResourceAsReader("mybatis-config.xml");

factory = new SqlSessionFactoryBuilder().build(reader);

} catch (IOException e) {

e.printStackTrace();

}

public MemberDTO isExistId(String memId) {

SqlSession sqlSession = factory.openSession();

return sqlSession.selectOne("memberSQL.isExistId", memId);

}

// 유저 등록

/* public void userWrite(UserDTO userDto) {

SqlSession sqlSession = factory.openSession();

sqlSession.insert("userSQL.userWrite", userDto);

sqlSession.commit();

sqlSession.close();

// userSQL 이라는 namespace안에 userWrite라는 mapper를 찾아간다. (in userMapper.xml)

} // userWrite()

// 유저 삭제

public void userDelete(UserDTO userDto) {

SqlSession sqlSession = factory.openSession();

sqlSession.delete("userSQL.userDelete", userDto);

sqlSession.commit();

sqlSession.close();

} // userDelete()

// 유저 리스트

public List<UserDTO> getUserList() {

SqlSession sqlSession = factory.openSession();

List<UserDTO> list = sqlSession.selectList("userSQL.getUserList");

sqlSession.close();

return list;

} // getUserList()

// 유저정보 얻어오기

public UserDTO getUser(String id) {

UserDTO userDto = new UserDTO();

SqlSession sqlSession = factory.openSession();

userDto = sqlSession.selectOne("userSQL.getUser", id);

sqlSession.close();

return userDto;

}

// 유저 업데이트

public int updateUser(UserDTO userDto) {

int su = 0;

SqlSession sqlSession = factory.openSession();

su = sqlSession.update("userSQL.updateUser", userDto);

sqlSession.commit();

sqlSession.close();

return su;

}*/

}

memberMapper.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

select * from member where memId=#{memId}

</select>

</mapper>

DBClose

package member.dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class DBClose {

public static void close(Connection conn, PreparedStatement pstmt) {

try {

if(pstmt!=null) pstmt.close();

if(conn!=null) conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

public static void close(Connection conn, PreparedStatement pstmt, ResultSet rs) {

try {

if(rs!=null) rs.close();

if(pstmt!=null) pstmt.close();

if(conn!=null) conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

</typeAliases>

</dataSource>

</environment>

</environments>

</mappers>

</configuration>

web.xml

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">

<display-name>memberservlet</display-name>

<welcome-file-list>

<welcome-file>index.html</welcome-file>

<welcome-file>index.htm</welcome-file>

<welcome-file>index.jsp</welcome-file>

<welcome-file>default.html</welcome-file>

<welcome-file>default.htm</welcome-file>

<welcome-file>default.jsp</welcome-file>

</welcome-file-list>

<servlet-name>checkId</servlet-name>

<servlet-class>member.action.checkIdProc</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>checkId</servlet-name>

<url-pattern>/checkIdProc</url-pattern>

</servlet-mapping>

</web-app>