Java: 38-Adding-Spring-and-DataSource-Configuration

You can remove JDBC connection code form .java file and configure dataSource in spring.xml

String driver = "com.mysql.jdbc.Driver";

Class.forName(driver).newInstance();

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testdb","root","");

</bean>

Configure the dataSource in JdbcDaoImpl class.

Above configuration open new connection for every call to database.

To avoid this we can use Connection pooling.

Download dbcp and pool jars from below URL.

dbcp : http://commons.apache.org/dbcp/

Commons pool : http://commons.apache.org/pool/

Add above jars in project build path.

And configure below property in spring xml

</bean>

Circle.java

package org.yash.watertechsol.model;

public class Circle {

private int id;

private String name;

public Circle(int circleId, String name){

setId(circleId);

setName(name);

}

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

JdbcDemo.java

package org.yash.watertechsol;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import org.yash.watertechsol.dao.JdbcDaoImpl;

import org.yash.watertechsol.model.Circle;

public class JdbcDemo {

public static void main(String[] args){

//Circle circle = new JdbcDaoImpl().getCircle(1);

//System.out.println(circle.getName());

ApplicationContext context = new ClassPathXmlApplicationContext("spring.xml");

JdbcDaoImpl dao = context.getBean("jdbcDaoImpl", JdbcDaoImpl.class);

Circle circle = dao.getCircle(1);

System.out.println(circle.getName());

}

JdbcDaoImpl.java

package org.yash.watertechsol.dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Component;

import org.yash.watertechsol.model.Circle;

@Component

public class JdbcDaoImpl {

@Autowired

private DataSource dataSource;

public Circle getCircle(int circleId){

Connection conn =null;

try{

String driver = "com.mysql.jdbc.Driver";

Class.forName(driver).newInstance();

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testdb","root","");

conn = dataSource.getConnection();

PreparedStatement ps = conn.prepareStatement("select * from circle where id=?");

ps.setInt(1, circleId);

Circle circle =null;

ResultSet rs = ps.executeQuery();

if(rs.next()){

circle = new Circle(circleId, rs.getString("name"));

}

rs.close();

ps.close();

return circle;

}catch(Exception e){

throw new RuntimeException(e);

}

finally{

try {

conn.close();

} catch (Exception e2) {

// TODO: handle exception

}

public void setDataSource(DataSource dataSource) {

this.dataSource = dataSource;

}

public DataSource getDataSource() {

return dataSource;

}

spring.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:context="http://www.springframework.org/schema/context"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.0.xsd">

<context:annotation-config />

<context:component-scan base-package="org.yash.watertechsol"></context:component-scan>

</bean>

</beans>

Java

Monday, July 22, 2013

38-Adding-Spring-and-DataSource-Configuration

No comments:

Post a Comment