/*
 * 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.Address;
import com.bestray.trastrack.domain.ClientUser;
import com.bestray.trastrack.domain.VehicleOwner;
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 user3
 */
public class VehicleOwnerResultSetExtractor implements ResultSetExtractor<Object>{
     public Object extractData(ResultSet rs) throws SQLException, DataAccessException{
                   List <VehicleOwner> owners = new ArrayList<VehicleOwner>();
                   //List <Address> ownerlist = new ArrayList<Address>();
                   
                   while(rs.next()){
                       VehicleOwner owner = new VehicleOwner();
                       //Address address = new Address();
                       owner.setId(rs.getLong("id"));
                       owner.setOwnername(rs.getString("name"));
                       owner.setAddressid(rs.getLong("address_id"));
                       owner.setOwnercontact1(rs.getLong("contact_1"));
                       owner.setOwnercontact2(rs.getLong("contact_2"));
                       owner.setOwnercontact3(rs.getLong("contact_3"));
                       //address.setCity(rs.getString("city"));
                       //address.setAddress1(rs.getString("address1"));
                       owner.setEmail(rs.getString("email"));
                       owner.setOpeningbal(rs.getDouble("opening_balance"));
                       owner.setOpeningbaltype(rs.getString("opening_balance_type"));
                       owner.setLock(rs.getString("lock_ind"));
                       //owner.setOwneraddress1(address);
                       owners.add(owner);
                   }
                   return owners;
    }
    
}