Spring Series – Learn JDBC integration by Example
Overview
In this article we will discuss about the JDBC feature provided by the Spring framework. We will be concentrating more on the implementation and configuration part. This guide will help the developers to follow the steps and implement JDBC using Spring framework.
DAO Basics
DAO stands for data access object which is commonly used for database interaction.DAOs exist to provide a means to read and write data to the database and they should expose this functionality through an interface by which the rest of the application will access them.
Spring JBDC
Spring has its own JDBC framework which helps us to clean up JDBC code by shouldering the burden of resource management and error handling. This leaves you free to concentrate on the statements and queries to get your data to and from the database.
Spring’s data access frameworks incorporate a template class known as JdbcTemplate. A JdbcTemplate only needs Datasource to start working.
Following code snippet shows the creation of JdbcTemplate.
JdbcTemplate template = new JdbcTemplate(myDataSource);
Following code snippet shows the wiring of DAO beans with JdbcTemplate.
<bean id=”jdbcTemplate”
class=”org.springframework.jdbc.core.JdbcTemplate”>
<property name=”dataSource”><ref bean=”dataSource”/></property>
</bean>
<bean id=”studentDao” class=”StudentDaoJdbc”>
<property name=”jdbcTemplate”><ref bean=”jdbcTemplate”/></property>
</bean>
<bean id=”courseDao” class=”CourseDaoJdbc”>
<property name=”jdbcTemplate”><ref bean=”jdbcTemplate”/></property>
</bean>
Following is an example of accessing the database using spring JDBC template.
- The first component is an interface (StudentDAO) to define the method to be implemented. Here the method is to insert the student details.
package com.techalpine.dao;
public interface StudentDAO {
public void insertStudent(String, String);
}
- The next component is the implementation class of the above mentioned interface (StudentDAOImpl). It implements the insert method by using JDBC template.
package com.techalpine.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
public class StudentDAOImpl implements StudentDAO {
private JdbcTemplate jdbcTemplate;
public void setDataSource(DataSource dataSource) {
this.jdbcTemplate = new JdbcTemplate(dataSource);
}
public void insertStudent(String name, String address) {
// Specify SQL query for insert
String query = “INSERT INTO STUDENT (name,address) VALUES (?,?)”;
// Specify the method to be called
jdbcTemplate.update(query, new Object[] );
}
}
- The third component is the configuration file (xml) to define the data source and wiring the beans.
<?xml version=”1.0″ encoding=”UTF-8″?>
<beans xmlns=”http://www.springframework.org/schema/beans”
xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”xsi:schemaLocation=”http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd”>
<bean id=”dataSource” destroy-method=”close” class=”org.apache.commons.dbcp.BasicDataSource”>
<property name=”driverClassName” value=”org.hsqldb.jdbcDriver”/>
<property name=”url” value=”jdbc:hsqldb:hsql://localhost”/>
<property name=”username” value=”techalpine”/>
<property name=”password” value=”techalpine”/>
</bean>
<bean id=”studentDAO” class=”com.techalpine.dao.StudentDAOImpl”>
<property name=”dataSource” ref=”dataSource”/>
</bean>
</beans>
- Now the final part is a standalone java class (java) to test the sample. The main class retrieve the bean from spring container and then call the insert method to insert the student data.
package com.techalpine.dao;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public class Student {
public static void main(String[] args) {
ApplicationContext context = new ClassPathXmlApplicationContext(“student.xml”);
StudentDAO studentDAO = (StudentDAO) context.getBean(“studentDAO”);
studentDAO.insertStudent(“Amit”,”Delhi”);
}
}
Conclusion
This article is for the developers who wants to jump into coding without wasting much time on the theoretical part. We have tried to keep the theoretical part minimum and explain more on the coding and configuration. Hope this will help the developers’ community.
