[스프링]MVC2방식 CRUD 게시판 만들기 3.root-context.xml 설정

* root-context.xml에 DB 연결설정하기.

1. DataSource 등록

          (DB 접속을 위한 설정정보 입력)

<bean id="dataSource"

class="org.springframework.jdbc.datasource.DriverManagerDataSource">

<property name="driverClassName"

value="com.mysql.jdbc.Driver"></property>

<property name="url"

value="jdbc:mysql://localhost:3306/chan0124?characterEncoding=utf8&useSSL=false"></property>

<property name="username" value="zerock"></property>

<property name="password" value="zerock"></property>

</bean>

2. Sqlsessionfactory 등록

(Mybatis 사용을 위한 sqlsessionfactory 커넥션 추가)

<bean id="sqlSessionFactory"

class="org.mybatis.spring.SqlSessionFactoryBean">

<property name="dataSource" ref="dataSource" />

<property name="configLocation"

value="classpath:/mybatis-config.xml"></property>

<property name="mapperLocations"

value="classpath:mappers/**/*Mapper.xml"></property>

</bean>

<bean id="sqlSession"

class="org.mybatis.spring.SqlSessionTemplate"

destroy-method="clearCache">

<constructor-arg name="sqlSessionFactory"

ref="sqlSessionFactory"></constructor-arg>

</bean>

3. Namespaces 설정

(공통네임 설정을 위한 namespace 설정)

4. 최종결과

(404 오류가 나와야 정상이다)

오류원인 : <property name="configLocation"

value="classpath:/mybatis-config.xml"></property>

<property name="mapperLocations"

value="classpath:mappers/**/*Mapper.xml"></property>  (root-context 일부..)

root-context 추가한 sqlsessionfactory 에서 지정한 설정위치 구성이 안되어있기 때문...