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;
import org.springframework.jdbc.core.simple.SimpleJdbcTemplate;



public class EmpDAO {

    private JdbcTemplate template;

    public JdbcTemplate getTemplate() {
        return template;
    }

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

    public List<Student> getAllStudents(){
         return (List<Student>) template.query("select * from test",new ResultSetExtractor(){
            @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;
                }
            });
          }


}

public class Student {
    private String name;
    private String roll;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }

    public String getRoll() {
        return roll;
    }
    public void setRoll(String roll) {
        this.roll = roll;
    }
    public void display(){
        System.out.println("Name: "+name+" Roll="+roll);
    }

}

<?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://localhost/test" />
<property name="username" value="root" />
<property name="password" value="password" />
</bean>

<bean id="jtemplate" class="org.springframework.jdbc.core.simple.SimpleJdbcTemplate">
<constructor-arg ref="ds"></constructor-arg>
</bean>

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

</beans>

import java.util.List;

import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;
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
         Resource resource=new ClassPathResource("applicationContext.xml");
            BeanFactory factory=new XmlBeanFactory(resource);

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

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

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

            }


    }