OrderRepository1.kt

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

@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()
    }
}