Adding our RowMapper and SQL query

GameJDBCRepository.java

import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;

import tutorial.springsetup.entity.Game;


@Repository
public class GameJDBCRepository extends BaseJDBCRepository {

	private final String SQL_SEARCH_BY_DESCRIPTION = "SELECT description, id, title FROM game g WHERE lower(g.description) LIKE lower(:desc);";

	private class GameRowMapper implements RowMapper<Game> {
		public Game mapRow(ResultSet rs, int rowNum) throws SQLException {
			Game game = new Game();
			game.setDescription(rs.getString("description"));
			game.setId(rs.getLong("id"));
			game.setTitle(rs.getString("title"));
			return game;
		}	
	}
}