스프링 세팅 절차
서버등록
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 로 변수 확인