2. 데이터 베이스 관련 처리 / Dummy 생성, mvc 처리

1. Spring Legacy Project를 이용하여 Project 생성

2. pom.xml 수정

3. 데이터 베이스 관련 처리

4. 스프링 MVC 처리

 

 

 

1-1 sqldeveloper

id : book_ex

pw : book_ex



create sequence seq_board;



create table tbl_board(

bno number(10, 0),

title varchar2(200) not null, 

content varchar2(2000) not null,

writer varchar2(50) not null,

regdate date default sysdate,

updatedate date default sysdate

);



alter table tbl_board add constraint pk_board

primary key (bno);



insert into tbl_board (bno, title, content, writer) values (seq_board.nextval, '테스트 제목', '테스트 내용', 'user000')



insert 여러 번 실행한 후 



select * from tbl_board; 정상으로 처리 되는지 확인 후 commit (오라클의 경우 수동으로 처리해야 함)

 

1-2

root-context.xml(root-context.xml mybatis-spring 네임페이스를 추가 )

<?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:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
		http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">
	
	<!-- Root Context: defines shared resources visible to all other web components -->

	<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
		<property name="driverClassName" 
			value="oracle.jdbc.OracleDriver"></property>
		<property name="jdbcUrl" 
			value="jdbc:oracle:thin:@localhost:1521:orcl"></property>
		<property name="username" value="book_ex"></property>
		<property name="password" value="book_ex"></property>
	</bean>
	
	<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource"
		destroy-method="close">
	    <constructor-arg ref="hikariConfig"></constructor-arg>
	</bean>
	
	<bean id="sqlSessionFactory" 
		class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>		
	</bean>
	
	<mybatis-spring:scan base-package="org.zerock.mapper"/>	
		
</beans>

 

1-3

log4jdbclog4jdbc.log4j2.properties

log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator