/
psklyarov
/
test-postgres-lb
Обзор
Документация
Войти
/
psklyarov
/
test-postgres-lb
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
src/main/java/com/example/lb/repository/ItemRepository.java
45 строк
1 KB
pavelsklyarov
initial version
10 дек 2025, 11:42
10 дек 2025, 11:42
135d274
Код
Авторство
О чём код?
package com.example.lb.repository; import com.example.lb.model.DbInfo; import com.example.lb.model.Item; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import org.springframework.stereotype.Repository; import java.util.List; @Repository public class ItemRepository { private final JdbcTemplate jdbcTemplate; private static final RowMapper<Item> ITEM_ROW_MAPPER = (rs, rowNum) -> { Item item = new Item(); item.setId(rs.getLong("id")); item.setName(rs.getString("name")); item.setDescription(rs.getString("description")); return item; }; public ItemRepository(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } public List<Item> findAll() { return jdbcTemplate.query( "select id, name, description from items order by id", ITEM_ROW_MAPPER ); } public DbInfo getDbInfo() { return jdbcTemplate.queryForObject( "select inet_server_addr() as address, inet_server_port() as port, current_database() as db, version() as ver", (rs, row) -> new DbInfo( rs.getString("address"), rs.getInt("port"), rs.getString("db"), rs.getString("ver") ) ); } }