[200626.85일차] Spring boot 3 - MyBatis

프로젝트 생성

---

Table 생성

create table member(
id number primary key,
name varchar2(20),
age number
);
create sequence member_seq;  

insert into member values(member_seq.nextval,'홍길동',20);
insert into member values(member_seq.nextval,'김개똥',30);

commit;

---

DB 사용 준비

application.yaml( 기본 file로 확장자를 붙여 생성 ) / application.properties (기본적으로 있는 파일)

둘중 하나만 있으면 된다.

ojdbc6.jar

---

MybatisConfig

package com.care.root.mybatis;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
@MapperScan(basePackages = {"com.care.root.dao"})
public class MyBatisConfig {
	@Bean
	public SqlSessionFactory seqsessFactory(DataSource dataSource) throws Exception {
		final SqlSessionFactoryBean sessionFactory=new SqlSessionFactoryBean();
		sessionFactory.setDataSource(dataSource);
		return sessionFactory.getObject();
	}
	@Bean
	public SqlSessionTemplate sqlSessionTemplate(SqlSessionFactory sqlSessionFactory) {
		return new SqlSessionTemplate(sqlSessionFactory);
	}
}

---

 

---

 

 

---