CollegeMapper.java

package com.sunilos.annotation.dao;

import java.sql.ResultSet;

import java.sql.SQLException;

import org.springframework.jdbc.core.RowMapper;

import com.sunilos.dto.College;

/**

 * Maps CollegeDTO object to ResultSet

 *

 * @since 01 Jan 2015

 * @author SunilOS

 * @version 1.0

 * @Copyright (c) SunilOS

 */

public class CollegeMapper implements RowMapper<College> {

    /**

     * Maps ResultSet to Account object

     */

    public College mapRow(ResultSet rs, int args) throws SQLException {

        College dto = new College();

        dto.setId(rs.getLong("id"));

        dto.setName(rs.getString("name"));

        dto.setAddress(rs.getString("address"));

        dto.setState(rs.getString("state"));

        dto.setCity(rs.getString("city"));

        dto.setCity(rs.getString("city"));

        dto.setPhoneNo(rs.getString("PHONE_NO"));

        dto.setCreatedBy(rs.getString("CREATED_BY"));

        dto.setCreatedBy(rs.getString("MODIFIED_BY"));

        return dto;

    }

}