<?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:p="http://www.springframework.org/schema/p"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
 http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">

<bean id="ds" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://loclahost:3306/test" />
<property name="username" value="root" />
<property name="password" value="password" />
</bean>

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="ds"></property>
</bean>

<bean id="edao" class="EmpDAO">
<property name="template" ref="jdbcTemplate"></property>
</bean>

</beans>

import java.util.List;

import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;
public class Test {

    public static void main(String[] args) {
        // TODO Auto-generated method stub
        ApplicationContext ctx=new ClassPathXmlApplicationContext("applicationContext.xml");

            EmpDAO dao=(EmpDAO)ctx.getBean("edao");

            List<Student> list=dao.getAllStudents();

            for(Student e:list)
                System.out.println(e);

            }


    }

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.ResultSetExtractor;



public class EmpDAO {

    private JdbcTemplate template;

    public void setJdbcTemplate(JdbcTemplate template) {
        this.template = template;
    }



    public List<Student> getAllStudents(){
        return template.query("select * from student",new ResultSetExtractor<List<Student>>(){
            @Override
             public List<Student> extractData(ResultSet rs) throws SQLException,
                    DataAccessException {

                List<Student> list=new ArrayList<Student>();
                while(rs.next()){
                Student e=new Student();
                e.setName(rs.getString(1));
                e.setRoll(rs.getString(2));
                list.add(e);
                }
                return list;
                }
            });
          }


}