#준비

1. New-Dynamic Web Project: 04_MemberMybatis

2. mybatis-3.1.1.jar, mybatis-spring-1.2.2.jar를 WEB-INF의 lib에 복사 붙여넣기

3. web.xml의 servlet-name: memberApp

4. WEB-INF 폴더 내에 memberApp-servlet.xml 파일 생성

5. src-com.member.config에 디비 설정. (Configuration.xml, Member.xml)

6. Configuration.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>">
    <configuration>
   	 <mappers>
   	 	<mapper resource="com/member/config/Member.xml"/>
   	 </mappers>
    </configuration>
   

7. Member.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="com.member.config.Member">
   

8. com.member.controller에 Controller 생성. com.member.model에 VO, Service, DAO 생성. (인터페이스+클래스)

9. memberApp-servlet.xml에는 다음과 같이 등록 (1) 패키지 등록 <context:component-scan base-package="com.member"/>

   (2) properties 설정 <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations" value="classpath:jdbc.properties"/> </bean>

   (3) spring에서 제공하는 dataSource 설정 <bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource"> <property name="driverClass" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/> </bean>

   (4) Mybatis spring db 연동 <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">

   <property name="dataSource" ref="dataSource"/> <property name="configLocation" value="classpath:/com/member/config/Configuration.xml"/> </bean>

   (5) viewResolver 설정

   <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="WEB-INF/views/"></property> <property name="suffix" value=".jsp"></property> </bean>

   (6) sqlSession 설정

   <bean id="sqlMapper" class="org.mybatis.spring.SqlSessionTemplate"> <constructor-arg index="0" ref="sqlSessionFactoryBean" /> </bean>

10. src의 루트에 jdb.properties 파일 생성 (driver, url, username, password 설정)

    driver=oracle.jdbc.driver.OracleDriver
    url=jdbc:oracle:thin:@localhost:1521:xe
    username=scott
    password=1234
    

# '회원추가' 실행 순서

<aside> 💡 index.jsp에서 회원가입 추가 링크 클릭 ("insert.my") 하면 회원가입 폼으로 이동 ⇒ 내용 작성 후 가입 버튼을 누르면 회원가입 실행 (db에 반영)

</aside>