Spring - Qualifier설정, Repboard 병합, JPA

 

참고 깃허브

https://github.com/sblee1031/Kosta/tree/f2cf7ea3ec2b1abdaacfc1ee8225fad35f8f7dca/ORACLE_DB_THEOTY/Oracle_DB_project/myspringboot/boardrestspring

sqlSessionFactory 설정 및 Qualifier 설정

package com.day.boardrest.configuration;

import javax.sql.DataSource;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;

import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;

@Configuration
@PropertySource("classpath:/application.properties")
public class DatabaseConfiguration {
	
	@Bean
	@ConfigurationProperties(prefix="spring.datasource.hikari")
	public HikariConfig hikariConfig() {
		return new HikariConfig();
	}
	@Bean	
	public DataSource dataSource() throws Exception {
		DataSource dataSource = new HikariDataSource(hikariConfig());
		System.out.println(dataSource.toString());
		return dataSource;
	}
	
	@Autowired
	private ApplicationContext applicationContext;
	
	@Bean
	@Qualifier("UnderscoreToCamelCase")
	public SqlSessionFactory sqlSessionFactory1(DataSource dataSource) throws Exception {
		SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
		sqlSessionFactoryBean.setDataSource(dataSource);

		sqlSessionFactoryBean.setConfigLocation(applicationContext.getResource("classpath:/mybatisConfig/mybatis-board-config.xml"));
		return sqlSessionFactoryBean.getObject();
	}
	@Bean
	@Qualifier("Underscore")
	public SqlSessionFactory sqlSessionFactory2(DataSource dataSource) throws Exception {
		SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
		sqlSessionFactoryBean.setDataSource(dataSource);

		sqlSessionFactoryBean.setConfigLocation(applicationContext.getResource("classpath:/mybatisConfig/mybatis-config.xml"));
		return sqlSessionFactoryBean.getObject();
	}

	@Bean	
	@Qualifier("UnderscoreToCamelCaseTemplate")
	public SqlSessionTemplate sqlSessionTemplate1(DataSource dataSource) throws Exception {
		return new SqlSessionTemplate(sqlSessionFactory1(dataSource));
	}
	@Bean
	@Qualifier("UnderscoreTemplate")
	public SqlSessionTemplate sqlSessionTemplate2(DataSource dataSource) throws Exception {
		return new SqlSessionTemplate(sqlSessionFactory2(dataSource));
	}
}

---

JPA

 

JPA persist() 메서드 호출시

JPA removed() 호출시

persistContext 두개의 같은 객체일 경우 

persistContext 안에 Entity 와 Table 정의

 

findAll() 메서드 호출 시 Entity 어노테이션 

@id (pk역할)

@Column(name="컬럼명")

@Transient - 영속성 무시, 비번의 경우 보완 노출 때문에..