Softtech Computer Edu: 2012-04-01

Sprng with DAO module(example programs by madhav)

Ex1:

This below example program will describes soing simple DML operation on data.

Dept.java

package madhav;

public class Dept implements java.io.Serializable{

public int deptno;

public String dname,loc;

}

DeptDao.java

package madhav;

public interface DeptDao {

void changeLocation(int dno,String loc);

void removeDept(int dno);

}

DeptDaoImpl.java

package madhav;

import org.springframework.jdbc.core.*;

import java.util.*;

public class DeptDaoImpl implements DeptDao {

JdbcTemplate jt;

public DeptDaoImpl(JdbcTemplate jt)

{

this.jt=jt;

}

public void changeLocation(int dno,String loc)

{

jt.update("update dept set loc=? where deptno=?",

new Object[]{loc,new Integer(dno)});

}

public void removeDept(int dno)

{

jt.update("delete from dept where deptno="+dno);

}

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"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

<value>sun.jdbc.odbc.JdbcOdbcDriver</value>

</property>

<value>jdbc:odbc:goddati</value>

</property>

<value>system</value>

</property>

<value>chiruta</value>

</property>

</bean>

<constructor-arg>

</constructor-arg>

</bean>

<constructor-arg>

</constructor-arg>

</bean>

</beans>

DeptDaoTestCase.java

import madhav.*;

import org.springframework.beans.factory.*;

import org.springframework.beans.factory.xml.*;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import org.springframework.core.*;

import org.apache.commons.dbcp.BasicDataSource;

public class DeptDaoTestCase {

public static void main(String[] args) throws Exception {

DeptDao deptDao;

ApplicationContext beanfactory;

beanfactory=new ClassPathXmlApplicationContext("spring.xml");

deptDao = (DeptDao)beanfactory.getBean("deptdao");

System.out.println("testing change loc");

deptDao.changeLocation(40, "hyderabad");

System.out.println("location has been changed");

System.out.println("testing romove dept");

deptDao.removeDept(10);

System.out.println("dept no has been changed");

}

Ex2:

This program will descrtibe inserting a record by using PrepareStatementCreator object.

Dept.java

package madhav;

public class Dept implements java.io.Serializable{

public int deptno;

public String dname,loc;

}

DeptDao.java

package madhav;

public interface DeptDao {

public void changeLocation(int dno,String loc);

public void removeDept(int dno);

public int createDept(Dept d);

}

DeptDaoImpl.ajva

package madhav;

import org.springframework.jdbc.core.*;

import java.util.*;

public class DeptDaoImpl implements DeptDao {

JdbcTemplate jt;

public DeptDaoImpl(JdbcTemplate jt)

{

this.jt=jt;

}

public void changeLocation(int dno,String loc)

{

jt.update("update dept set loc=? where deptno=?",

new Object[]{loc,new Integer(dno)});

}

public void removeDept(int dno)

{

jt.update("delete from dept where deptno="+dno);

}

public int createDept(Dept d)

{

MyPreparedStatementCreater psc=new MyPreparedStatementCreater(d);

return jt.update(psc);

}

MyPreparedStatementCreater.java

package madhav;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import org.springframework.jdbc.core.*;

import java.sql.*;

public class MyPreparedStatementCreater implements PreparedStatementCreator {

Dept d;

public MyPreparedStatementCreater(Dept d)

{

this.d=d;

}

public PreparedStatement createPreparedStatement(Connection con)

throws SQLException {

// TODO Auto-generated method stub

PreparedStatement ps=con.prepareStatement("insert into dept values(?,?,?)");

ps.setInt(1,d.deptno);

ps.setString(2,d.dname);

ps.setString(3,d.loc);

return ps;

}

Sprng .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"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

<value>sun.jdbc.odbc.JdbcOdbcDriver</value>

</property>

<value>jdbc:odbc:goddati</value>

</property>

<value>system</value>

</property>

<value>chiruta</value>

</property>

</bean>

<constructor-arg>

</constructor-arg>

</bean>

<constructor-arg>

</constructor-arg>

</bean>

</beans>

DeptDaoTestCase.java

import madhav.*;

import org.springframework.beans.factory.*;

import org.springframework.beans.factory.xml.*;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import org.springframework.core.*;

import org.apache.commons.dbcp.BasicDataSource;

public class DeptDaoTestCase {

public static void main(String[] args) throws Exception {

try

{

DeptDao deptDao;

ApplicationContext beanfactory;

beanfactory=new ClassPathXmlApplicationContext("spring.xml");

deptDao = (DeptDao)beanfactory.getBean("deptdao");

Dept d=new Dept();

d.dname="newdept";

d.loc="mig";

d.deptno=70;

System.out.println("i am trying to insert dept vlaues");

deptDao.createDept(d);

System.out.println("record is inserted");

}

catch(Exception e)

{

e.printStackTrace();

}

Ex3:

This program will describes to execute sql select quiries( by using ResultSetExtractor interface object).

Dept.java

package madhav;

public class Dept implements java.io.Serializable{

public int deptno;

public String dname,loc;

}

DeptExtractor.java

package madhav;

import org.springframework.dao.DataAccessException;

import org.springframework.jdbc.core.*;

import java.sql.*;

import java.util.*;

public class DeptExtractor implements ResultSetExtractor {

public Object extractData(ResultSet rs) throws SQLException,

DataAccessException {

// TODO Auto-generated method stub

while(rs.next())

{

System.out.print("=" +rs.getInt(1));

System.out.print("=" +rs.getString(2));

System.out.print("=" + rs.getString(3));

System.out.println("================");

}

return null;

}

Testing.java

package madhav;

import org.springframework.jdbc.core.*;

public class Testing {

public JdbcTemplate jdbcTemplate;

public Testing(JdbcTemplate jdbcTemplate)

{

this.jdbcTemplate=jdbcTemplate;

}

public void extract()

{

String sql="select * from dept";

DeptExtractor dx=new DeptExtractor();

jdbcTemplate.query(sql, dx);

}

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"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

<value>sun.jdbc.odbc.JdbcOdbcDriver</value>

</property>

<value>jdbc:odbc:goddati</value>

</property>

<value>system</value>

</property>

<value>chiruta</value>

</property>

</bean>

<constructor-arg>

</constructor-arg>

</bean>

<constructor-arg>

</constructor-arg>

</bean>

</beans>

DeptExtractorTestCase.java

import madhav.Testing;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

public class DeptExtractorTestCase {

/**

* @param args

public static void main(String[] args) {

// TODO Auto-generated method stub

try

{

Testing t;

ApplicationContext beanfactory;

beanfactory=new ClassPathXmlApplicationContext("spring.xml");

t = (Testing)beanfactory.getBean("testing");

System.out.println("i am trying to extract data");

t.extract();

System.out.println("extraction is over");

}

catch(Exception e)

{

e.printStackTrace();

}

Ex4:

This example program will describes getting data by using RowCallbackHandler interface ojbect.

Dept.java

package madhav;

public class Dept implements java.io.Serializable{

public int deptno;

public String dname,loc;

}

DeptResults.java

package madhav;

import java.sql.ResultSet;

import java.sql.SQLException;

import org.springframework.jdbc.core.RowCallbackHandler;

public class DeptResults implements RowCallbackHandler{

public void processRow(ResultSet rs) throws SQLException {

// TODO Auto-generated method stub

System.out.print("=" +rs.getInt(1));

System.out.print("=" +rs.getString(2));

System.out.println("=" +rs.getString(3));

System.out.println("----------");

}

Testing.java

package madhav;

import org.springframework.jdbc.core.*;

public class Testing {

public JdbcTemplate jdbcTemplate;

public Testing(JdbcTemplate jdbcTemplate)

{

this.jdbcTemplate=jdbcTemplate;

}

public void extract()

{

String sql="select * from dept";

//DeptExtractor dx=new DeptExtractor();

DeptResults dr=new DeptResults();

jdbcTemplate.query(sql, dr);

}

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"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

<value>sun.jdbc.odbc.JdbcOdbcDriver</value>

</property>

<value>jdbc:odbc:goddati</value>

</property>

<value>system</value>

</property>

<value>chiruta</value>

</property>

</bean>

<constructor-arg>

</constructor-arg>

</bean>

<constructor-arg>

</constructor-arg>

</bean>

</beans>

DeptExtractorTestCase.java

import madhav.Testing;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

public class DeptExtractorTestCase {

/**

* @param args

public static void main(String[] args) {

// TODO Auto-generated method stub

try

{

Testing t;

ApplicationContext beanfactory;

beanfactory=new ClassPathXmlApplicationContext("spring.xml");

t = (Testing)beanfactory.getBean("testing");

System.out.println("i am trying to extract data");

t.extract();

System.out.println("extraction is over");

}

catch(Exception e)

{

e.printStackTrace();

}

Ex5:

This program will describes calling stored procedures.

Softtech Computer Edu

Java

Saturday, 7 April 2012

Sprng with DAO module(example programs by madhav)