Java tutorial
/* * Copyright 2002-2011 the original author or authors. * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package com.kang.spring.integration.mapper; import com.kang.spring.integration.domain.Gender; import com.kang.spring.integration.domain.Person; import org.springframework.jdbc.core.RowMapper; import org.springframework.stereotype.Component; import java.sql.ResultSet; import java.sql.SQLException; /** * The result set mapper that will map the {@link ResultSet} to the {@link Person} instance * @author Amol Nayak * */ @Component public class PersonMapper implements RowMapper<Person> { /* (non-Javadoc) * @see org.springframework.jdbc.core.RowMapper#mapRow(java.sql.ResultSet, int) */ public Person mapRow(ResultSet rs, int rowNum) throws SQLException { Person person = new Person(); person.setId(rs.getInt("id")); person.setName(rs.getString("name")); person.setGender(Gender.getGenderByIdentifier(rs.getString("gender"))); person.setDateOfBirth(rs.getDate("dateOfBirth")); System.out.println(person); return person; } }