jdbccountrydao.java

extjs sample with spring

package demo.repository;

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

import demo.domain.Country;
import demo.ajax.SortInfo;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport;
import org.springframework.jdbc.core.simple.ParameterizedRowMapper;

/**
 * @version 1.0
 */
public class JdbcCountryDao extends SimpleJdbcDaoSupport implements CountryDao {

    protected final Log logger = LogFactory.getLog(getClass());

     public List<Country> getCountryList(SortInfo sort) {

        if(sort.getSort() == null) {
            sort.setSort("code");
        }

        logger.info( String.format("Getting Country List - sorted on %s (%s)", sort.getSort(), sort.getDir()));

        List<Country> countries = getSimpleJdbcTemplate().query(
                "select code, name, continent, population, gnp from country order by " + sort.getSort() + " " + sort.getDir(),
                new CountryMapper());
        return countries;

    }

    private static class CountryMapper implements ParameterizedRowMapper<Country> {
        public Country mapRow(ResultSet rs, int rowNum) throws SQLException {
            Country country = new Country();
            country.setCode(rs.getString("code"));
            country.setName(rs.getString("name"));
            country.setContinent(rs.getString("continent"));
            country.setPopulation(rs.getInt("population"));
            country.setGnp(rs.getDouble("gnp"));
            return country;
        }
    }

}