[스프링] 스프링 JdbcTemplate 사용하기

	<beans:bean name="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<beans:property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></beans:property>
		<beans:property name="url" value="jdbc:oracle:thin:@localhost:1521:xe"></beans:property>
		<beans:property name="username" value="hr"></beans:property>
		<beans:property name="password" value="1234"></beans:property>
	</beans:bean>
	
	<beans:bean name="template" class="org.springframework.jdbc.core.JdbcTemplate">
		<beans:property name="dataSource" ref="dataSource"></beans:property>
	</beans:bean>

JdbcTemplate은 반복적인 작업을 간단히 처리하기 위해 사용합니다.

기존에 방식에서 JdbcTemplate이면 2줄로 처리가 가능하기에 간편하다.

 

JdbcTemplate 순서

1. pom.xml → jdbcTemplate설정

2. servelt-context.xml → Bean(빈)설정

3. controller → jdbcTemplate @Autowired 설정

4. Constatnt 클래스 추가 → 외부에서 공통된 jdbcTemplates를 제공

5. DAO에서 커넥스풀방식 → jdbcTemplate으로 변경

 

1. pom.xml

기존 pom.xml에 아래와 같이 추가!

<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>4.1.4.RELEASE</version>
</dependency>

 

2. servelt-context.xml(내 프로젝트)

servlet-context.xml 

	<beans:bean name="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<beans:property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></beans:property>
		<beans:property name="url" value="jdbc:oracle:thin:@localhost:1521:xe"></beans:property>
		<beans:property name="username" value="hr"></beans:property>
		<beans:property name="password" value="1234"></beans:property>
	</beans:bean>
	
	<beans:bean name="template" class="org.springframework.jdbc.core.JdbcTemplate">
		<beans:property name="dataSource" ref="dataSource"></beans:property>
	</beans:bean>

 

3. controller

Bcontroller

	private JdbcTemplate template;
	
	@Autowired
	public void setTemplate(JdbcTemplate template) {
		this.template = template;
		Constant.template = this.template;
	}

 

4. Constatnt 클래스 추가

package com.all.test01.util;

import org.springframework.jdbc.core.JdbcTemplate;

public class Constant {
	public static JdbcTemplate template;
}