게시판 프로젝트 - database(oracle)

book_ex 계정 생성 후

각 게시물마다 고유 번호 필요 - 시퀀스 통해 이런 작업 처리

create sequence seq_board;

테이블 생성

regdate : 생성시간

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
);

데이터 추가

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

마지막에 반드시 commit; 해주기

commit;

데이터 잘 들어갔는지 확인

select * from tbl_board;

bno, regdate, updatedate는 자동 생성

---

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"
	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">
	
	<!-- Root Context: defines shared resources visible to all other web components -->
		<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
		<property name ="driverClassName" value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy">
		</property>
		<property name ="jdbcUrl" value="jdbc:log4jdbc:oracle:thin:@localhost:1521:XE"></property>
		<property name="username" value="book_ex"></property>
		<property name="password" value="1234"></property>
		</bean>
		
		<!-- HikariCP configuration -->
		<bean id ="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
		<constructor-arg ref="hikariConfig"/>
		</bean>
		
		<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>
		</bean>
		
		<mybatis-spring:scan base-package ="org.board.mapper"/>
</beans>

---

Log4jdbc 이용하는 방식으로 구성되어 있으므로log4jdbc.log4j2.properties파일 추가

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

---

DataSourceTests 클래스, JDBCTests 클래스 테스트 패키지에 추가