스프링 프레임워크 - [Spring] 톰캣 서버 세팅 / MVC 프로젝트 (2)

Today

Total

Recent Comments

Recent Posts

« 2024/05 »
일	월	화	수	목	금	토
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

관리 메뉴

💻

스프링 프레임워크 - [Spring] 톰캣 서버 세팅 / MVC 프로젝트 (2) 본문

KITRI/SPRING

스프링 프레임워크 - [Spring] 톰캣 서버 세팅 / MVC 프로젝트 (2)

또효니 2020. 7. 28. 16:59

라이브러리 추가

메인페이지

index.jsp

<%@ 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>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<c:set var="root" value="${pageContext.request.contextPath}"/>
	
	<a href="${root}/member/test.do">Spring MVC Start!!!</a>
	
	<h3>회원관리</h3>
	<a href="${root}/member/register.do">회원가입</a>
</body>
</html>

HAspect.java

package com.java.aop;

import java.util.logging.Logger;

import org.aspectj.lang.ProceedingJoinPoint;

public class HAspect {
	public static Logger logger = Logger.getLogger(HAspect.class.getName());
	public static final String logMsg = "LogMsg~~~~~~~~~~~~~~~";
	
	
	public Object advice(ProceedingJoinPoint joinPoint) {
		Object obj = null;
		
		try {
			logger.info(logMsg + joinPoint.getTarget().getClass().getName() + "---" + joinPoint.getSignature().getName()); 
			obj= joinPoint.proceed();
		
		} catch (Throwable e) {
			e.printStackTrace();
		}
		return obj;
	}
}

SpringController-servlet.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.1.xsd">
	
	<!-- AOP -->
	<bean id="hAspect" class="com.java.aop.HAspect"/>
	<aop:config>
		<aop:aspect id="exAspect" ref="hAspect">
			<aop:pointcut expression="within(com.java.*)" id="pMethod"/>
			<aop:around method="advice" pointcut-ref="pMethod"/>
		</aop:aspect>
	</aop:config>

	
	
	<!-- HandlerMapping / UI요청이 들어오면 해당 클래스를 찾아라 -->
	<bean id="handlerMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
		<property name="mappings">
			<props>
				<prop key="/member/*.do">memberController</prop>
			</props>
		</property>
	</bean>
	
	<bean id="propertiesMethodNameResolver" class="org.springframework.web.servlet.mvc.multiaction.PropertiesMethodNameResolver">
		<property name="mappings">
			<props>
				<prop key="/member/test.do">testing</prop>
				<prop key="/member/register.do">register</prop>
			</props>
		</property>
	
	</bean>
	
	<!-- MemberController -->
	<bean id="memberController" class="com.java.member.controller.MemberController">
		<constructor-arg ref="memberServiceImp"/>
		<property name="methodNameResolver" ref="propertiesMethodNameResolver"/>
	</bean>
	
	<!-- MemberService -->
	<bean id="memberServiceImp" class="com.java.member.service.MemberServiceImp">
		<constructor-arg ref="memberDaoImp"/>
	</bean>
	
	<!-- MemberDAO -->
	<bean id="memberDaoImp" class="com.java.member.dao.MemberDaoImp"></bean>
	<!-- MyBatis -->
	
	<!-- MVC RequestDispatcher / forward -->
	<bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/views/"/>
		<property name="suffix" value=".jsp"></property>
	</bean>	
</beans>

MemberController.java

package com.java.member.controller;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.multiaction.MultiActionController;
import org.springframework.web.servlet.view.InternalResourceView;

import com.java.member.service.MemberService;

public class MemberController extends MultiActionController{	//Command
	private MemberService memberService;

	public MemberController() {}
	
	public MemberController(MemberService memberService) {
		this.memberService = memberService;
	}

	public void setMemberService(MemberService memberService) {
		this.memberService = memberService;
	}
	
	public ModelAndView testing(HttpServletRequest request, HttpServletResponse response) {
		System.out.println("OK");
		
		//Service - Dao / Dto - Service
		//최상위 클래스는 View
		/*
		InternalResourceView view = new InternalResourceView("/WEB-INF/member/test.jsp");
		ModelAndView mav = new ModelAndView();
		mav.addObject("msg", "hi");
		mav.setView(view);
		*/
		
		//다양한 생성자가 있기에 그에 맞춰서 사용!!!
		//ModelAndView mav = new ModelAndView(view);
		ModelAndView mav = new ModelAndView("member/test");
		mav.addObject("msg", "hi");
		
		return mav;
	}
	
	public ModelAndView register(HttpServletRequest request, HttpServletResponse response) {
		return new ModelAndView("member/register");
	}
}

한글설정

Web.xml

 <!-- 한글 작업 -->
 <filter>
  	<filter-name>enCodingFilter</filter-name>
  	<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  	<init-param>
  		<param-name>encoding</param-name>
  		<param-value>UTF-8</param-value>
  	</init-param>
 </filter>
  
 <filter-mapping>
  	<filter-name>enCodingFilter</filter-name>
  	<url-pattern>/*</url-pattern>
 </filter-mapping>

회원가입 페이지

register.jsp

<%@ 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>
<c:set var="root" value="${pageContext.request.contextPath}" />
<html>
<head>
<meta charset="UTF-8">
<title>회원가입page</title>
	<link rel="stylesheet" href="${root}/css/member/joinStyle.css">
	<script type="text/javascript" src="${root}/javascript/member/register.js"></script>
</head>
<body>
	<!-- 템플릿 적용 때는 삭제 -->
	<!--<jsp:include page="../../../index.jsp"/>-->
	<br /><br />

	<form id="joinform" name="joinform" action="${root}/member/registerOk.do" method="post" 
		onsubmit="return createFrom(this)">

		<h4 style="text-align: center;">회원가입(*필수입력사항입니다.)</h4>
		<div class="menu" style="border-bottom-width: 0px;">


		<div id="id">아이디</div>
			<span>* 
				<input type="text" class="checkInfo" name="id" size="12" /> 
				<button type="button" onclick="idCheck(joinform, '${root}')">아이디 중복</button>
			</span>
		</div>

		<div class="menu " style="border-bottom-width: 0px;">
			<div id="id">비밀번호</div>
			<span>* <input type="password" class="checkInfo" name="password" size="12" />
			</span>
		</div>

		<div class="menu " style="border-bottom-width: 0px;">
			<div id="id">비밀번호확인</div>
			<span>* <input type="password" class="checkInfo" name="passwordCheck" size="12" />
			</span>
		</div>

		<div class="menu " style="border-bottom-width: 0px;">
			<div id="id">이름</div>
			<span>* <input type="text" class="checkInfo" name="name" size="12" />
			</span>
		</div>

		<div class="menu " style="border-bottom-width: 0px;">
			<div id="id">주민번호</div>
			<span>* 
				<input type="text" class="checkInfo" name="jumin1" size="6" /> 
				<span>-</span> 
				<input type="text" class="checkInfo" name="jumin2" size="7" />
			</span>
		</div>

		<div class="menu" style="border-bottom-width: 0px;">
			<div id="id" style="margin-left: 10px,">이메일</div>
			<span> 
				<input type="email" name="email" size="25" />
			</span>
		</div>


		<div class="menu" style="border-bottom-width: 0px;">
			<div id="id">우편번호</div>
			<span> 
				<input type="text" name="zipcode" size="30" /> 
				<button type="button" onclick="searchZipcode('${root}')">우편번호검색</button>
			</span>
		</div>

		<div class="menu" style="border-bottom-width: 0px;">
			<div id="id">주소</div>
			<span> <input type="text" name="address" size="50" />
			</span>
		</div>

		<div class="menu" style="border-bottom-width: 0px;">
			<div id="id">직업</div>
			<span> 
			<select name="job">
					<option>직업을 선택하세요.</option>
					<option value=' '>무직</option>
					<option value='programmer'>프로그래머</option>
					<option value='designer'>디자이너</option>
			</select>
			</span>
		</div>


		<div class="menu" style="border-bottom-width: 0px;">
			<div id="id">메일수신</div>
			<span> <input type="radio" id="yes" name="mailing" value="yes" />
				<label for="yes">yes</label> <input type="radio" id="no"
				name="mailing" value="no" /> <label for="no">no</label>
			</span>
		</div>

		<div class="menu" style="border-bottom-width: 0px;">
			<div id="id">관심분야</div>
			<span> 
				<input type="checkbox" size="12" name="interest" value="경제"/> 
				<label for="경제" >경제</label> 
				<input type="checkbox" size="12" name="interest" value="IT"/> 
				<label for="IT" >IT</label>
				<input type="checkbox" size="12" name="interest" value="음악"/>
				<label for="음악" >음악</label> 
				<input type="checkbox" size="12" name="interest" value="미술"/> 
				<label for="미술" >미술</label>
				<input type="hidden" name="resultInterest"/>
			</span>	
		</div>

		<div class="menu" style="text-align: center;">
			<span> 
				<input type="submit" value="가입" />
			 	<input type="reset" value="취소" />
			</span>
		</div>
	</form>
</body>
</html>

/css/member/joinStyle.css

@charset "UTF-8";
#joinform {
	width: 700px;
	height: 100px;
	margin: 100px auto;
}

#joinform .menu {
	border: solid 3px black;
	width: 700px;
	height: 30px;
	display: block;
	line-height: 20px;
	text-indent: 5px;
}
#id {
	border-right: solid 3px black;
	width: 120px;
	height: 30px;
	float: left;
	line-height: 30px;
}
input[type="text"], input[type="email"], input[type="password"], input[type="button"]{
	margin-top: 5px;
}
.checkInfo:focus{
	background-color:yellow;
}

registerOk.jsp

<%@ 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>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<c:set var="root" value="${pageContext.request.contextPath}"/>
	<c:if test = "${check > 0}">
		<script type="text/javascript">
			alert("회원 가입이 완료되었습니다.");
			location.href="${root}/member/register.do";
		</script>
	</c:if>

	<c:if test = "${check == 0}">
		<script type="text/javascript">
			alert("회원 가입이 완료되지 않았습니다.");
			location.href="${root}/member/register.do";
		</script>
	</c:if>
</body>
</html>

SpringController-servlet.xml

register추가 , DB연결부분 추가

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.1.xsd">
	
	<!-- AOP -->
	<bean id="hAspect" class="com.java.aop.HAspect"/>
	<aop:config>
		<aop:aspect id="exAspect" ref="hAspect">
			<aop:pointcut expression="within(com.java.*)" id="pMethod"/>
			<aop:around method="advice" pointcut-ref="pMethod"/>
		</aop:aspect>
	</aop:config>
	
	
	<!-- Spring DB -->
	<bean id="driverManagerDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
		<property name="url" value="jdbc:oracle:thin:@localhost:1521:xe"/>
		<property name="username" value="mvc"/>
		<property name="password" value = "1234"/>
	</bean>

	
	<!-- MyBatis -->
	<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="driverManagerDataSource"></property>
		<property name="mapperLocations" value="classpath:com/java/member/dao/mapper/MemberMapper.xml"></property>
	</bean>
	
	<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg ref="sqlSessionFactoryBean"/>
	</bean>

	
	<!-- member bean -->
	
	<!-- HandlerMapping / UI요청이 들어오면 해당 클래스를 찾아라 -->
	<bean id="handlerMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
		<property name="mappings">
			<props>
				<prop key="/member/*.do">memberController</prop>
			</props>
		</property>
	</bean>
	
	<bean id="propertiesMethodNameResolver" class="org.springframework.web.servlet.mvc.multiaction.PropertiesMethodNameResolver">
		<property name="mappings">
			<props>
				<prop key="/member/test.do">testing</prop>
				<prop key="/member/register.do">memberRegister</prop>
				<prop key="/member/registerOk.do">memberRegisterOk</prop>
			</props>
		</property>
	
	</bean>
	
	<!-- MemberController -->
	<bean id="memberController" class="com.java.member.controller.MemberController">
		<constructor-arg ref="memberServiceImp"/>
		<property name="methodNameResolver" ref="propertiesMethodNameResolver"/>
	</bean>
	
	<!-- MemberService -->
	<bean id="memberServiceImp" class="com.java.member.service.MemberServiceImp">
		<constructor-arg ref="memberDaoImp"/>
	</bean>
	
	<!-- MemberDAO -->
	<bean id="memberDaoImp" class="com.java.member.dao.MemberDaoImp">
		<property name="sqlSessionTemplate" ref="sqlSessionTemplate"></property>
	</bean>

	
	<!-- MVC RequestDispatcher / forward -->
	<bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/views/"/>
		<property name="suffix" value=".jsp"></property>
	</bean>
	
	
</beans>

MemberController.java

package com.java.member.controller;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.multiaction.MultiActionController;
import org.springframework.web.servlet.view.InternalResourceView;

import com.java.aop.HAspect;
import com.java.member.dto.MemberDto;
import com.java.member.service.MemberService;

public class MemberController extends MultiActionController{	//Command
	private MemberService memberService;

	public MemberController() {}
	
	public MemberController(MemberService memberService) {
		this.memberService = memberService;
	}

	public void setMemberService(MemberService memberService) {
		this.memberService = memberService;
	}
	
	public ModelAndView testing(HttpServletRequest request, HttpServletResponse response) {
		System.out.println("OK");
		
		//Service - Dao / Dto - Service
		//최상위 클래스는 View
		/*
		InternalResourceView view = new InternalResourceView("/WEB-INF/member/test.jsp");
		ModelAndView mav = new ModelAndView();
		mav.addObject("msg", "hi");
		mav.setView(view);
		*/
		
		//다양한 생성자가 있기에 그에 맞춰서 사용!!!
		//ModelAndView mav = new ModelAndView(view);
		ModelAndView mav = new ModelAndView("member/test");
		mav.addObject("msg", "hi");
		
		return mav;
	}
	
	public ModelAndView memberRegister(HttpServletRequest request, HttpServletResponse response) {
		return new ModelAndView("member/register");
	}
	
	public ModelAndView memberRegisterOk(HttpServletRequest request, HttpServletResponse response, MemberDto memberDto) {
		HAspect.logger.info(HAspect.logMsg + memberDto.toString());
		
		ModelAndView mav = new ModelAndView();
		mav.addObject("memberDto", memberDto);
		
		memberService.memberRegisterOk(mav);
		
		return mav;
	}
}

MemberDto.java

Dto의 이름과 뷰의 form의 식별자(name값)과 같아야 한다.

package com.java.member.dto;

import java.sql.Date;

public class MemberDto {
    private String id;
    private String password;
    private String name;
    private String jumin1;
    private String jumin2;
    private String email;
    private String zipcode;
    private String address;
    private String job;
    private String mailing;
    private String interest;
    
    private Date registerDate; //가입날짜: Date, sysdate
    private int num;	       //시퀀스번호: .nextval
    private String memberLevel;//회원등급: 회원등급:3개(BA,AA,VIP)
   
    public MemberDto() {
	super();
    }

    public MemberDto(String id, String password, String name, String jumin1, String jumin2, String email,
	    String zipcode, String address, String job, String mailing, String interest, Date registerDate, int num,
	    String memberLevel) {
	super();
	this.id = id;
	this.password = password;
	this.name = name;
	this.jumin1 = jumin1;
	this.jumin2 = jumin2;
	this.email = email;
	this.zipcode = zipcode;
	this.address = address;
	this.job = job;
	this.mailing = mailing;
	this.interest = interest;
	this.registerDate = registerDate;
	this.num = num;
	this.memberLevel = memberLevel;
    }
    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 getJumin1() {
        return jumin1;
    }
    public void setJumin1(String jumin1) {
        this.jumin1 = jumin1;
    }
    public String getJumin2() {
        return jumin2;
    }
    public void setJumin2(String jumin2) {
        this.jumin2 = jumin2;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public String getZipcode() {
        return zipcode;
    }
    public void setZipcode(String zipcode) {
        this.zipcode = zipcode;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
    public String getJob() {
        return job;
    }
    public void setJob(String job) {
        this.job = job;
    }
    public String getMailing() {
        return mailing;
    }
    public void setMailing(String mailing) {
        this.mailing = mailing;
    }
    public String getInterest() {
        return interest;
    }
    public void setInterest(String interest) {
        this.interest = interest;
    }
    public Date getRegisterDate() {
        return registerDate;
    }
    public void setRegisterDate(Date registerDate) {
        this.registerDate = registerDate;
    }
    public int getNum() {
        return num;
    }
    public void setNum(int num) {
        this.num = num;
    }
    public String getMemberLevel() {
        return memberLevel;
    }
    public void setMemberLevel(String memberLevel) {
        this.memberLevel = memberLevel;
    }
    @Override
    public String toString() {
	return "MemberDto [id=" + id + ", password=" + password + ", name=" + name + ", jumin1=" + jumin1 + ", jumin2="
		+ jumin2 + ", email=" + email + ", zipcode=" + zipcode + ", address=" + address + ", job=" + job
		+ ", mailing=" + mailing + ", interest=" + interest + ", registerDate=" + registerDate + ", num=" + num
		+ ", memberLevel=" + memberLevel + "]";
    }    
}

[interface] MemberDao.java

memberinsert 추가

package com.java.member.dao;

import com.java.member.dto.MemberDto;

public interface MemberDao {
	public int memberinsert(MemberDto memberDto);
}

MemberDaoImp.java

memberinsert추가

package com.java.member.dao;

import org.mybatis.spring.SqlSessionTemplate;

import com.java.member.dto.MemberDto;

public class MemberDaoImp implements MemberDao {
	//My batis SqlSessionTemplate
	private SqlSessionTemplate  sqlSessionTemplate;
	
	public MemberDaoImp() {};

	
	public MemberDaoImp(SqlSessionTemplate sqlSessionTemplate) {

		this.sqlSessionTemplate = sqlSessionTemplate;
	}

	public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate) {
		this.sqlSessionTemplate = sqlSessionTemplate;
	}

	@Override
	public int memberinsert(MemberDto memberDto) {
		return sqlSessionTemplate.insert("member_insert", memberDto);
	}
}

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">

<mapper namespace="MemberDto">

	<resultMap type="com.java.member.dto.MemberDto" id="member_dto">
		<result column="num" property="num"/>
		<result column="id" property="id"/>
		<result column="password" property="password"/>
		<result column="name" property="name"/>
		<result column="jumin1" property="jumin1"/>
		<result column="jumin2" property="jumin2"/>
		<result column="email" property="email"/>
		
		<result column="zipcode" property="zipcode"/>
		<result column="address" property="saddress"/>
		<result column="job" property="job"/>
		<result column="mailing" property="mailing"/>
		<result column="interest" property="interest"/>
		<result column="member_level" property="memberLevel"/>
		<result column="register_date" property="registerDate"/>
	</resultMap>

<!-- 들어오는 것은 parameterType 나가는 것은 resultType id는 식별자, insert는 resultType 생략 -->
	<insert id="member_insert" parameterType="com.java.member.dto.MemberDto">
		insert into member values(
				member_num_seq.nextval,
				#{id},
				#{password},
				#{name},
				#{jumin1},
				#{jumin2},
				#{email},
				#{zipcode},
				#{address},
				#{job},
				#{mailing},
				#{interest},
				#{memberLevel},
				sysdate
		)
	</insert>
</mapper>

[interface] MemberService.java

package com.java.member.service;

import org.springframework.web.servlet.ModelAndView;

public interface MemberService {
	public void memberRegisterOk(ModelAndView mav);
}

MemberServiceImp.java

registerOk추가

package com.java.member.service;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.web.servlet.ModelAndView;

import com.java.aop.HAspect;
import com.java.member.dao.MemberDao;
import com.java.member.dto.MemberDto;

public class MemberServiceImp implements MemberService {
	private MemberDao memberDao;


	public MemberServiceImp() {}


	public MemberServiceImp(MemberDao memberDao) {
		this.memberDao = memberDao;
	}


	public void setMemberDao(MemberDao memberDao) {
		this.memberDao = memberDao;
	}
	
	@Override
	public void memberRegisterOk(ModelAndView mav) {
		Map<String, Object> map = mav.getModelMap();
		MemberDto memberDto = (MemberDto)map.get("memberDto");
		
		memberDto.setMemberLevel("BA");
		
		int check = memberDao.memberinsert(memberDto);
		HAspect.logger.info(HAspect.logMsg + check);
		
		mav.addObject("check", check);
		mav.setViewName("member/registerOk");
		
	}
}

idCheck기능

idCheck.jsp

<%@ 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>
<html>
<head>
<meta charset="UTF-8">
<title>아이디 확인</title>
</head>
<body>
	<c:set var="root" value="${pageContext.request.contextPath}"/>
	<c:if test="${check != 0}">
		<div align="center"> 
			이미 사용중인 아이디입니다.
			<form action="${root}/member/idCheck.do" method="get">
				<input type="text" name="id"/>
				<input type="submit" value="확인"/>
			</form>
		</div>
	</c:if>

	<c:if test="${check == 0}">
		<div align="center"> 
			사용 가능한 아이디입니다.
		</div>
		
		<script type="text/javascript">
			opener.joinform.id.value="${id}";
		</script>	
	</c:if>
	
	<div align="center">
		<a href="javascript:self.close();">닫기</a>
	</div>
</body>
</html>

register.js

function idCheck(root){
	alert(root);
	if($("input[name='id']").val()==""){
		alert("아이디를 입력하세요");
		$("input[name='id']").focus();
		return false;
	}
	
	var url = root + "/member/idCheck.do?id=" + $("input[name='id']").val();
	//alert(url);
	window.open(url , "", "width=250, height=150"); 
}

SpringController-servlet.xml

idCheck.do추가

	<bean id="propertiesMethodNameResolver" class="org.springframework.web.servlet.mvc.multiaction.PropertiesMethodNameResolver">
		<property name="mappings">
			<props>
				<prop key="/member/test.do">testing</prop>
				<prop key="/member/register.do">memberRegister</prop>
				<prop key="/member/registerOk.do">memberRegisterOk</prop>
				<prop key="/member/idCheck.do">memberidCheck</prop>
			</props>
		</property>
	</bean>
    
    <bean id="propertiesMethodNameResolver" class="org.springframework.web.servlet.mvc.multiaction.PropertiesMethodNameResolver">
		<property name="mappings">
			<props>
				<prop key="/member/test.do">testing</prop>
				<prop key="/member/register.do">memberRegister</prop>
				<prop key="/member/registerOk.do">memberRegisterOk</prop>
				<prop key="/member/idCheck.do">memberidCheck</prop>
			</props>
		</property>
    </bean>

MemberController.java

memberidCheck 추가

public ModelAndView memberidCheck(HttpServletRequest request, HttpServletResponse response) {
		ModelAndView mav = new ModelAndView();
		mav.addObject("request", request);
		
		memberService.memberidCheck(mav);
		
		return mav;
}

[interface] MemberDao.java

memberidcheck추가

package com.java.member.dao;

import com.java.member.dto.MemberDto;

public interface MemberDao {
	public int memberinsert(MemberDto memberDto);
	public int memberidCheck(String id);
}

MemberDaoImp.java

memberidCheck추가

@Override
	public int memberidCheck(String id) {
		String value =  sqlSessionTemplate.selectOne("id_check",id);
		
		int check = 0;
		if(value!=null) check=1;
		
		
		return check;
}

[interface] MemberService.java

memberidCheck 추가

package com.java.member.service;

import org.springframework.web.servlet.ModelAndView;

public interface MemberService {

	public void memberRegisterOk(ModelAndView mav);
	public void memberidCheck(ModelAndView mav);
}

MemberServiceImp.java

memberidCheck 추가

@Override
	public void memberidCheck(ModelAndView mav) {
		Map<String, Object> map = mav.getModelMap();
		HttpServletRequest request = (HttpServletRequest)map.get("request");
		
		String id = request.getParameter("id");
		HAspect.logger.info(HAspect.logMsg + id);
		
		int check = memberDao.memberidCheck(id);
		HAspect.logger.info(HAspect.logMsg + check);
	
		mav.addObject("check", check);
		mav.addObject("id", id);
		mav.setViewName("member/idCheck");
	}

SpringController-servlet.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.1.xsd">
	
	<!-- AOP -->
	<bean id="hAspect" class="com.java.aop.HAspect"/>
	<aop:config>
		<aop:aspect id="exAspect" ref="hAspect">
			<aop:pointcut expression="within(com.java.*)" id="pMethod"/>
			<aop:around method="advice" pointcut-ref="pMethod"/>
		</aop:aspect>
	</aop:config>
	
	
	<!-- Spring DB -->
	<bean id="driverManagerDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
		<property name="url" value="jdbc:oracle:thin:@localhost:1521:xe"/>
		<property name="username" value="mvc"/>
		<property name="password" value = "1234"/>
	</bean>

	
	<!-- MyBatis -->
	<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="driverManagerDataSource"></property>
		<property name="mapperLocations" value="classpath:com/java/member/dao/mapper/MemberMapper.xml"></property>
	</bean>
	
	<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg ref="sqlSessionFactoryBean"/>
	</bean>

	
	<!-- member bean -->
	
	<!-- HandlerMapping / UI요청이 들어오면 해당 클래스를 찾아라 -->
	<bean id="handlerMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
		<property name="mappings">
			<props>
				<prop key="/member/*.do">memberController</prop>
			</props>
		</property>
	</bean>
	
	<bean id="propertiesMethodNameResolver" class="org.springframework.web.servlet.mvc.multiaction.PropertiesMethodNameResolver">
		<property name="mappings">
			<props>
				<prop key="/member/test.do">testing</prop>
				<prop key="/member/register.do">memberRegister</prop>
				<prop key="/member/registerOk.do">memberRegisterOk</prop>
				<prop key="/member/idCheck.do">memberidCheck</prop>
			</props>
		</property>
	
	</bean>
	
	<!-- MemberController -->
	<bean id="memberController" class="com.java.member.controller.MemberController">
		<constructor-arg ref="memberServiceImp"/>
		<property name="methodNameResolver" ref="propertiesMethodNameResolver"/>
	</bean>
	
	<!-- MemberService -->
	<bean id="memberServiceImp" class="com.java.member.service.MemberServiceImp">
		<constructor-arg ref="memberDaoImp"/>
	</bean>
	
	<!-- MemberDAO -->
	<bean id="memberDaoImp" class="com.java.member.dao.MemberDaoImp">
		<property name="sqlSessionTemplate" ref="sqlSessionTemplate"></property>
	</bean>

	
	<!-- MVC RequestDispatcher / forward -->
	<bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/views/"/>
		<property name="suffix" value=".jsp"></property>
	</bean>	
</beans>

MemberController.java

package com.java.member.controller;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.multiaction.MultiActionController;
import org.springframework.web.servlet.view.InternalResourceView;

import com.java.aop.HAspect;
import com.java.member.dto.MemberDto;
import com.java.member.service.MemberService;

public class MemberController extends MultiActionController{	//Command
	private MemberService memberService;

	public MemberController() {}
	
	public MemberController(MemberService memberService) {
		this.memberService = memberService;
	}

	public void setMemberService(MemberService memberService) {
		this.memberService = memberService;
	}
	
	public ModelAndView testing(HttpServletRequest request, HttpServletResponse response) {
		System.out.println("OK");
		
		//Service - Dao / Dto - Service
		//최상위 클래스는 View
		/*
		InternalResourceView view = new InternalResourceView("/WEB-INF/member/test.jsp");
		ModelAndView mav = new ModelAndView();
		mav.addObject("msg", "hi");
		mav.setView(view);
		*/
		
		//다양한 생성자가 있기에 그에 맞춰서 사용!!!
		//ModelAndView mav = new ModelAndView(view);
		ModelAndView mav = new ModelAndView("member/test");
		mav.addObject("msg", "hi");
		
		return mav;
	}
	
	public ModelAndView memberRegister(HttpServletRequest request, HttpServletResponse response) {
		return new ModelAndView("member/register");
	}
	
	public ModelAndView memberRegisterOk(HttpServletRequest request, HttpServletResponse response, MemberDto memberDto) {
		HAspect.logger.info(HAspect.logMsg + memberDto.toString());
		
		ModelAndView mav = new ModelAndView();
		mav.addObject("memberDto", memberDto);
		
		memberService.memberRegisterOk(mav);
		
		return mav;
	}
	
	public ModelAndView memberidCheck(HttpServletRequest request, HttpServletResponse response) {
		ModelAndView mav = new ModelAndView();
		mav.addObject("request", request);
		
		memberService.memberidCheck(mav);
		
		return mav;
	}
}

MemberDaoImp.java

package com.java.member.dao;

import org.mybatis.spring.SqlSessionTemplate;

import com.java.member.dto.MemberDto;

public class MemberDaoImp implements MemberDao {
	//My batis SqlSessionTemplate
	private SqlSessionTemplate  sqlSessionTemplate;
	
	public MemberDaoImp() {};

	
	public MemberDaoImp(SqlSessionTemplate sqlSessionTemplate) {

		this.sqlSessionTemplate = sqlSessionTemplate;
	}

	public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate) {
		this.sqlSessionTemplate = sqlSessionTemplate;
	}

	@Override
	public int memberinsert(MemberDto memberDto) {
		return sqlSessionTemplate.insert("member_insert", memberDto);
	}
	
	@Override
	public int memberidCheck(String id) {
		String value =  sqlSessionTemplate.selectOne("id_check",id);
		
		int check = 0;
		if(value!=null) check=1;
		
		
		return check;
	}	
}

MemberServiceImp.java

package com.java.member.service;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.web.servlet.ModelAndView;

import com.java.aop.HAspect;
import com.java.member.dao.MemberDao;
import com.java.member.dto.MemberDto;

public class MemberServiceImp implements MemberService {
	private MemberDao memberDao;


	public MemberServiceImp() {}


	public MemberServiceImp(MemberDao memberDao) {
		this.memberDao = memberDao;
	}


	public void setMemberDao(MemberDao memberDao) {
		this.memberDao = memberDao;
	}
	
	@Override
	public void memberRegisterOk(ModelAndView mav) {
		Map<String, Object> map = mav.getModelMap();
		MemberDto memberDto = (MemberDto)map.get("memberDto");
		
		memberDto.setMemberLevel("BA");
		
		int check = memberDao.memberinsert(memberDto);
		HAspect.logger.info(HAspect.logMsg + check);
		
		mav.addObject("check", check);
		mav.setViewName("member/registerOk");
		
	}
	
	@Override
	public void memberidCheck(ModelAndView mav) {
		Map<String, Object> map = mav.getModelMap();
		HttpServletRequest request = (HttpServletRequest)map.get("request");
		
		String id = request.getParameter("id");
		HAspect.logger.info(HAspect.logMsg + id);
		
		int check = memberDao.memberidCheck(id);
		HAspect.logger.info(HAspect.logMsg + check);
	
		mav.addObject("check", check);
		mav.addObject("id", id);
		mav.setViewName("member/idCheck");
	}	
}

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">

<mapper namespace="MemberDto">

	<resultMap type="com.java.member.dto.MemberDto" id="member_dto">
		<result column="num" property="num"/>
		<result column="id" property="id"/>
		<result column="password" property="password"/>
		<result column="name" property="name"/>
		<result column="jumin1" property="jumin1"/>
		<result column="jumin2" property="jumin2"/>
		<result column="email" property="email"/>
		
		<result column="zipcode" property="zipcode"/>
		<result column="address" property="saddress"/>
		<result column="job" property="job"/>
		<result column="mailing" property="mailing"/>
		<result column="interest" property="interest"/>
		<result column="member_level" property="memberLevel"/>
		<result column="register_date" property="registerDate"/>
	</resultMap>

<!-- 들어오는 것은 parameterType 나가는 것은 resultType id는 식별자, insert는 resultType 생략 -->
	<insert id="member_insert" parameterType="com.java.member.dto.MemberDto">
		insert into member values(
				member_num_seq.nextval,
				#{id},
				#{password},
				#{name},
				#{jumin1},
				#{jumin2},
				#{email},
				#{zipcode},
				#{address},
				#{job},
				#{mailing},
				#{interest},
				#{memberLevel},
				sysdate
		)
	</insert>
	
	 <select id="id_check" parameterType="java.lang.String" resultType="java.lang.String">
		select id from member 
				  where id = #{id}
	</select>
</mapper>

'KITRI > SPRING' 카테고리의 다른 글

스프링 프레임워크 - [Spring] MVC 프로젝트(4) : 로그인/아웃, 회원정보수정, 삭제 (0)	2020.07.30
스프링 프레임워크 - [Spring] MVC 프로젝트(3) : 우편번호 검색 (0)	2020.07.29
스프링 프레임워크 - [Spring] 톰캣 서버 세팅 / MVC 프로젝트 (1) (0)	2020.07.28
스프링 프레임워크 - [Spring] DB연동 / 실습:은행(Bank) 프로그램 (0)	2020.07.27
스프링 프레임워크 - [Spring] AOP (2) / 공통 클래스(Aspect), 공통 함수(Advice), 핵심코드(JoinPoint) (0)	2020.07.27

'KITRI/SPRING' Related Articles

Comments

💻

스프링 프레임워크 - [Spring] 톰캣 서버 세팅 / MVC 프로젝트 (2) 본문

스프링 프레임워크 - [Spring] 톰캣 서버 세팅 / MVC 프로젝트 (2)

라이브러리 추가

메인페이지

한글설정

회원가입 페이지

idCheck기능

'KITRI > SPRING' 카테고리의 다른 글

티스토리툴바