2018_10_11 스프링 세팅 절차 mybatis config 설정 WEB.xml 설정

스프링 세팅 절차 

서버등록 

maven update 

server addand remove -> remove All

properties-> java1.8로 변경

pom.xml 

자바버전과 스프링버전을 맞게 변경

필요한 라이브러리 등록 

resorces 설정

mapping.xml설정 파일과 (board-mapping, member-mapping)

mybatis-config.xml파일을 생성 

mybatis config 설정 

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

<!– 클래스에 별명 설정 –>
<typeAliases>
<typeAlias type=“board.bean.BoardDTO” alias=“boardDTO”/>
<typeAlias type=“member.bean.MemberDTO” alias=“memberDTO”/>

</typeAliases>
<!– SQL Mapper 설정  –>
<mappers>
<!– SQL문장이 기술되는 Mapper파일 –>
<mapper resource=“mybatis/board-mapping.xml”/>
<mapper resource=“mybatis/member-mapping.xml”/>
</mappers>
</configuration>

mapping파일 설정 (ex: board-mapping)

<?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=“mybatis.boardMapper”>

<insert id=“boardWrite” parameterType=“boardDTO”>
insert into board values  
(seq_board.nextval, #{id}, #{name}, #{subject}, #{content}, 
0, sysdate)
</insert>

<update id=“updateHit” parameterType=“int”>
update board set hit = hit + 1 where seq=#{seq}
</update>

<delete id=“boardDelete” parameterType=“int”>
delete board where seq=#{seq}
</delete>

<select id=“boardView” parameterType=“int” resultType=“boardDTO”>
select * from board where seq=#{seq}
</select>

<select id=“boardList” parameterType=“java.util.Map” resultType=“boardDTO”>
<![CDATA[select * from  
(select rownum rn, tt.* from 
(select * from board order by seq desc) tt)  
where rn>=#{startNum} and rn<=#{endNum}]]>
</select>

<select id=“getTotalA” resultType=“int”>
select count(*) from board
</select>

</mapper>

다른 매핑파일이있다면 더 해준다 

WEB.xml 설정

upl 타입과 filter설정

   <servlet>
       <servlet-name>dispatcherServlet</servlet-name>
       <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
       <init-param>
           <param-name>contextConfigLocation</param-name>
           <param-value>/WEB-INF/mvc-config.xml</param-value>
       </init-param>
       <load-on-startup>1</load-on-startup>
   </servlet>

   <servlet-mapping>
       <servlet-name>dispatcherServlet</servlet-name>
       <url-pattern>*.do</url-pattern>
   </servlet-mapping>

<!– 인코딩설정 –>
<filter>
<filter-name>characterEncoding</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>characterEncoding</filter-name>
<url-pattern>*.do</url-pattern>
</filter-mapping>

MVC-Config 설정 

<mvc:annotation-driven />
<mvc:resources location=“/script/” mapping=“/script/**” />
<!– Controller 어노테이션 등록준비 –>
<context:component-scan
base-package=“board.controller”></context:component-scan>
<!– Controller 어노테이션 등록준비 –>
<context:component-scan
base-package=“member.controller”></context:component-scan>

Application-config 설정

<context:component-scan base-package=“board.*” />
<context:component-scan base-package=“member.*” />
<!– Uncomment and add your base-package here: <context:component-scan base-package=“org.springframework.samples.service”/> –>

<!– DataSource 설정 –>
<context:property-placeholder
location=“classpath:spring/db.properties” />
<bean id=“dataSource”
class=“org.springframework.jdbc.datasource.DriverManagerDataSource”>
<property name=“driverClassName”
value=“${jdbc.driverClassName}” />
<property name=“url” value=“${jdbc.url}” />
<property name=“username” value=“${jdbc.username}” />
<property name=“password” value=“${jdbc.password}” />

</bean>
<!– Stpring 마이 바티스 연동설정  –>

<bean id=“sessionFactory”
class=“org.mybatis.spring.SqlSessionFactoryBean”>
<property name=“dataSource” ref=“dataSource” />
<property name=“configLocation”
value=“classpath:mybatis/mybatis-config.xml” />
</bean>

<bean class=“org.mybatis.spring.SqlSessionTemplate”>
<constructor-arg ref=“sessionFactory” />
</bean>

Spring 폴더에 db.properties파일 추가 

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:xe
jdbc.username=jspexam
jdbc.password=m1234

테이블확인

slqdeveloper 로 변수 확인