/
AlexStone
/
Java25sep
Обзор
Документация
Войти
/
AlexStone
/
Java25sep
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
SpringDvdRental/src/main/java/org/example/CustomerRepository.java
36 строк
1 KB
AlexStone
HomeWork
24 апр 2026, 08:10
24 апр 2026, 08:10
a550197
Код
Авторство
О чём код?
package org.example; import org.springframework.jdbc.core.namedparam.MapSqlParameterSource; import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate; import org.springframework.stereotype.Service; import java.util.List; @Service public class CustomerRepository { private final NamedParameterJdbcTemplate jdbcTemplate; private final CustomerMapper customerMapper; public CustomerRepository(NamedParameterJdbcTemplate jdbcTemplate, CustomerMapper customerMapper) { this.jdbcTemplate = jdbcTemplate; this.customerMapper = customerMapper; } public List<Customer> getAllCustomer () { var query = """ SELECT customer_id,first_name,last_name FROM customer """; return jdbcTemplate.query(query, customerMapper); } public List<Customer> get10Customer (int aa) { var params = new MapSqlParameterSource(); params.addValue("Number",aa); var query = """ select * from customer order by customer_id limit 10 offset (:Number); """; return jdbcTemplate.query(query,params,customerMapper); } }