Hikari Connection pool 이해

설정1

<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
		<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
		<property name="jdbcUrl" value="jdbc:oracle:thin:@localhost:1521:XE"></property>
		<property name="username" value="edu"></property>
		<property name="password" value="1234"></property>
</bean>

<-- hikari는 Connection pool 역할 --> 
<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
		<constructor-arg ref="hikariConfig"></constructor-arg>
</bean>

<!-- 컨넥션 풀이 sqlSession을 통해서 DB를 연결 -->  

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>
</bean>

설정2

• src/main/java/com.thein.mapper 패키지의 BoardMapper.java의 파일명
  = src/main/resources/com.thein.mapper 패키지에서 BoardMapper.xml 매핑!

BoardMapper.xml 예시

<?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="com.theinedu.mapper.BoardMapper">
	<select id="getList" resultType="com.theinedu.domain.BoardVO">
		<![CDATA[
			SELECT * FROM board
		]]>
	</select>
</mapper>

BoardMapper.java 예시

public interface BoardMapper {
//반드시 메서드 이름은 BoardMapper.xml의 id와 일치해야 된다.
public List getList();
}

BoardServiceImp 예시

@Service
public class BoardServiceImp implements BoardService{

  @Autowired
  private BoardMapper boardMapper;

  @Override
  public List<BoardVO> getList() {

      return boardMapper.getList();
  }	

}

BoardService 인터페이스

public interface BoardService {
List getList();
}