Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
import org.springframework.jdbc.core.JdbcTemplate
import org.springframework.jdbc.core.RowMapper
import org.springframework.stereotype.Repository
class OrderRepository(private val jdbcTemplate: JdbcTemplate) {
private val rowMapper: RowMapper<Order> = RowMapper { rs, i -> Order(rs.getLong("id")) }
fun findOrderById(id: Long): Order? {
val result = jdbcTemplate.query<Order>("select * from orders where id=:id", rowMapper, id)
if (result.size > 1) throw RuntimeException("Too many results from findOrderById.")
return result.firstOrNull()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment