/*
 * 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.Vehicle;
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 sumitHome
 */
public class VehicleResultSetExtractor implements  ResultSetExtractor<Object>{
    
    public Object extractData(ResultSet rs) throws SQLException,
			DataAccessException{
                   List <Vehicle> vehicles = new ArrayList<Vehicle>();
        while (rs.next()) {
            Vehicle vehicle = new Vehicle();
          //  Address address = new Address();
            vehicle.setId(rs.getLong("id"));
            vehicle.setVehicle_number(rs.getString("vehicle_number"));
            vehicle.setVehicle_name(rs.getString("vehicle_name"));
            vehicle.setCatagoryCodeId(rs.getLong("catagory_id"));
            vehicle.setOwner_name(rs.getLong("vehicle_owner"));
            vehicle.setDriver_name(rs.getLong("vehicle_driver"));
            vehicle.setHsd_opening(rs.getDouble("hsd_opening"));
            vehicle.setLock(rs.getString("lock"));
            vehicle.setOilEntryId(rs.getLong("oil_entry_id"));
            vehicle.setLastOilVolume(rs.getDouble("last_oil_vol"));
            vehicle.setLastMeterReading(rs.getDouble("last_meter_reading"));
            vehicle.setCurrentMeterReading(rs.getDouble("current_meter_reading"));
            vehicle.setLastOilChangeDate(rs.getDate("last_oil_change_date"));
         
            vehicles.add(vehicle);
        }
        return vehicles;
    }
            
    
    
    
}