/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bestray.transtracking.dao.mapper;

import com.bestray.trastrack.domain.Code;
import com.bestray.trastrack.domain.Country;
import com.bestray.trastrack.domain.State;
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.ResultSetExtractor;

/**
 *
 * @author Girija Sahu
 */
public class StateResultSetExtractor implements ResultSetExtractor<Object>  {

    public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
        List<State> stateList = new ArrayList<State>();
        while (rs.next()) {
            State state = new State();
            state.setId(rs.getLong("id"));
            state.setName(rs.getString("name"));
            stateList.add(state);
        }
        return stateList;
    }
    
}