<p>In this tutorial, we are implementing <b>RowMapper </b>class to map our domain objects. We then use this class to write fetch methods that return custom model objects.<br />
<img class="aligncenter wp-image-3198 size-full" src="https://dineshonjava.com/wp-content/uploads/2012/12/RowMapper.png" alt="Implementing RowMapper" width="314" height="183" /></p>
<div dir="ltr" style="text-align: justify;">
<h2>Implementing RowMapper</h2>
<p>Spring provides a RowMapper interface for mapping a single row of a ResultSet to an object. It can be used for both single and multiple row queries. It is parameterized as of Spring 3.0.</p>
<pre class="highlight">public interface RowMapper<;T>; { 
T mapRow(ResultSet rs, int rowNum) 
throws SQLException; 
} 
</pre>
<p>An interface used by <b><a href="https://dineshonjava.com/using-jdbctemplate-in-spring-chapter-33/">JdbcTemplate</a> </b>for mapping rows of a <b>ResultSet </b>on a per-row basis. Implementations of this interface perform the actual work of mapping each row to a result object, but don&#8217;t need to worry about exception handling. <b>SQLExceptions </b>will be caught and handled by the calling <a href="https://dineshonjava.com/using-jdbctemplate-in-spring-chapter-33/"><b>JdbcTemplate</b></a>.</p>
<div style="background-color: #f2f9fc; border: 1px solid #c9e6f2; border-radius: 3px; padding: 16px; line-height: 1.45;">
<p><span style="color: red; font-size: x-large; text-align: center;"><b>Popular Tutorials</b></span></p>
<ul style="text-align: left;">
<li><b><a href="https://dineshonjava.com/spring-tutorial/"><em><strong>Spring Tutorial</strong> </em></a></b></li>
<li><b><a href="https://dineshonjava.com/spring-web-mvc-framework-chapter-38/"><strong><em>Spring MVC Web Tutorial </em></strong></a></b></li>
<li><b><a href="https://dineshonjava.com/introduction-to-spring-boot-a-spring-boot-complete-guide/"><strong>Spring Boot Tutorial</strong> </a></b></li>
<li><b><a href="https://dineshonjava.com/spring-security-take-baby-step-to-secure/"><em>Spring Security Tutorial</em></a></b></li>
<li><b><a href="https://dineshonjava.com/spring-aop-tutorial-with-example-aspect-advice-pointcut-joinpoint/"><em>Spring AOP Tutorial</em></a></b></li>
<li><b><a href="https://dineshonjava.com/using-spring-jdbc-framework-chapter-32/"><em>Spring JDBC Tutorial</em></a></b></li>
<li><b><a href="https://dineshonjava.com/spring-hateoas-hypermedia-driven-restful-web-service/"><em><strong>Spring HATEOAS </strong></em></a></b></li>
<li><b><a href="https://dineshonjava.com/microservices-with-spring-boot/"><em><strong>Microservices with Spring Boot</strong></em></a></b></li>
<li><b><a href="https://dineshonjava.com/jax-rs-web-service-tutorial/"><strong><em>REST Webservice</em> </strong></a></b></li>
<li><b><a href="https://dineshonjava.com/core-java-baby-step-to-be-best-java-ian/"><em><strong>Core Java </strong></em></a></b></li>
<li><b><a href="https://dineshonjava.com/hibernate-3-on-baby-steps/"><em><strong>Hibernate Tutorial</strong></em></a></b></li>
<li><b><a href="https://dineshonjava.com/spring-batch-process-with-example/"><strong><em>Spring Batch</em> </strong></a></b></li>
</ul>
</div>
<p>Typically used either for JdbcTemplate&#8217;s query methods or for out parameters of stored procedures. <b>RowMapper </b>objects are typically stateless and thus reusable; they are an ideal choice for implementing row-mapping logic in a single place.</p>
<p>Alternatively, consider subclassing <b>MappingSqlQuery </b>from the <b>jdbc.object package</b>: Instead of working with separate JdbcTemplate and <b>RowMapper </b>objects, you can build executable query objects (containing row-mapping logic) in that style.</p>
<p>Say for example, when we are selecting records from an employee table, we will iterate over the result set to get the individual values which won’t be ideal for situations, especially in Java where we want to map records from a database to individual Java objects. Also the question of re-usability comes into the picture as the above code doesn’t represent for getting itself re-used. Spring Row Mapper interfaces come into the rescue for such situations.</p>
<div id="ads-id" align="center"></div>
<h2><b>Querying for Single Row:</b></h2>
<p>Here’s two ways to query or extract a single row record from database, and convert it into a model class(Employee).</p>
<h3><b>1. Custom RowMapper:</b></h3>
<p>In general, It’s always recommended to implement the RowMapper interface to create a custom <b>RowMapper </b>to suit your needs..<b> </b></p>
<pre class="highlight">package com.dineshonjava.sdnext.jdbc.utils; 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
 
import org.springframework.jdbc.core.RowMapper; 
 
import com.dineshonjava.sdnext.domain.Employee; 
 
/** 
 * @author Dinesh Rajput 
 * 
 */ 
public class EmployeeMapper implements RowMapper { 
 public Employee mapRow(ResultSet rs, int rowNum) throws SQLException { 
 Employee employee = new Employee(); 
 employee.setEmpid(rs.getInt("empid")); 
 employee.setName(rs.getString("name")); 
 employee.setAge(rs.getInt("age")); 
 employee.setSalary(rs.getLong("salary")); 
 return employee; 
 } 
} 
</pre>
<p>Pass it to <b><i>queryForObject() </i></b>method, the returned result will call your custom <b><i>mapRow()</i></b> method to match the value into the property.</p>
<pre class="highlight">public Employee getEmployee(Integer empid) { 
 String SQL = "SELECT * FROM Employee WHERE empid = ?"; 
 Employee employee = (Employee) jdbcTemplateObject.queryForObject(SQL, new Object[]{empid}, new EmployeeMapper()); 
 return employee; 
} 
</pre>
<h3><b>2. BeanPropertyRowMapper:</b></h3>
<p>In Spring 2.5, comes with a handy <b>RowMapper </b>implementation called ‘<b>BeanPropertyRowMapper</b>’, which can maps a row’s column value to a property by matching their names. Just make sure both the property and column has the same name, e.g property ‘empid’ will match to column name ‘EMPID’ or with underscores ‘EMP_ID’.</p>
<pre class="highlight">public Employee getEmployee(Integer empid) { 
 String SQL = "SELECT * FROM Employee WHERE empid = ?"; 
 Employee employee = (Employee) jdbcTemplateObject.queryForObject(SQL, new Object[]{empid}, new BeanPropertyRowMapper(Employee.class)); 
 return employee; 
} 
</pre>
<h3><b>Querying for Multiple Rows:</b></h3>
<p>Now, query or extract multiple rows from database, and convert it into a List.</p>
<h4><b>1. Map it manually:</b></h4>
<p>In mutiple return rows, RowMapper is not supported in queryForList() method, you need to map it manually.</p>
<pre class="highlight">public List<;Employee>; findAll(){ 
 String sql = "SELECT * FROM Employee"; 
 
 List employees= new ArrayList(); 
 
 List rows = getJdbcTemplate().queryForList(sql); 
 for (Map row : rows) { 
 Employee employee = new Employee(); 
 employee.setEmpid((Integer)(row.get("EMPID"))); 
 employee.setName((String)row.get("NAME")); 
 employee.setAge((Integer)row.get("AGE")); 
 employee.setSalary((Long)row.get("SALARY")); 
 employees.add(employee); 
 } 
 return employees; 
} 
</pre>
<h4><b>2. BeanPropertyRowMapper:</b></h4>
<p>The simplest solution is using the BeanPropertyRowMapper class.</p>
<pre class="highlight">public List findAll(){ 
 String sql = "SELECT * FROM Employee"; 
 List employees= getJdbcTemplate().query(sql, 
 new BeanPropertyRowMapper(Employee.class)); 
 return employees; 
} 
</pre>
<div style="background-color: #f2f9fc; border-radius: 3px; border: 1px solid #c9e6f2; line-height: 1.45; padding: 16px;">
<p><b>Spring JDBC Framework Tutorial</b></p>
<ol style="text-align: left;">
<li><b><a href="https://dineshonjava.com/using-spring-jdbc-framework-chapter-32/">Spring JDBC Framework</a></b></li>
<li><b><a href="https://dineshonjava.com/using-jdbctemplate-in-spring-chapter-33/">Using JdbcTemplate in Spring</a></b></li>
<li><b><a href="https://dineshonjava.com/dao-support-classes-in-spring-chapter-35/">DAO Support Classes in Spring</a></b></li>
<li><b><a href="https://dineshonjava.com/using-namedparameterjdbctemplate-in/">Using NamedParameterJdbcTemplate in Spring with Example</a></b></li>
<li><b><a href="https://dineshonjava.com/spring-simplejdbctemplate-example/">Spring SimpleJdbcTemplate example</a></b></li>
<li><b><a href="https://dineshonjava.com/spring-simplejdbcinsert-example/">Spring SimpleJdbcInsert example</a></b></li>
<li><b><a href="https://dineshonjava.com/stored-procedure-simplejdbccall-in/">Stored Procedure with SimpleJdbcCall in Spring</a></b></li>
</ol>
</div>
<div style="text-align: center;"><b><;<;</b><b><a href="https://dineshonjava.com/using-jdbctemplate-in-spring-chapter-33/">Using JdbcTemplate</a></b><b> |<a href="https://dineshonjava.com/spring-tutorial/">index</a>| </b><b><a href="https://dineshonjava.com/dao-support-classes-in-spring-chapter-35/">DAO Support Classes</a></b><b></b><b>>;>;</b></div>
</div>
<div class="wp-post-navigation"> 
									 <div class="wp-post-navigation-pre"> 
									 <a href="https://dineshonjava.com/using-jdbctemplate-in-spring-chapter-33/">Previous</a> 
									 </div> 
									 <div class="wp-post-navigation-next"> 
									 <a href="https://dineshonjava.com/dao-support-classes-in-spring-chapter-35/">Next</a> 
									 </div> 
									</div>
<script type="text/javascript">
jQuery(document).ready(function($) {
 $.post('https://dineshonjava.com/wp-admin/admin-ajax.php', {action: 'mts_view_count', id: '635'});
});
</script>
Strategy Design Patterns We can easily create a strategy design pattern using lambda. To implement…
Decorator Pattern A decorator pattern allows a user to add new functionality to an existing…
Delegating pattern In software engineering, the delegation pattern is an object-oriented design pattern that allows…
Technology has emerged a lot in the last decade, and now we have artificial intelligence;…
Managing a database is becoming increasingly complex now due to the vast amount of data…
Overview In this article, we will explore Spring Scheduler how we could use it by…