使用rowMapper将jsonb列映射到java模型

import org.springframework.jdbc.core.RowMapper;
import com.fasterxml.jackson.databind.ObjectMapper;

public class JsonbRowMapper<T> implements RowMapper<T> {
    private final Class<T> type;
    private final ObjectMapper objectMapper;

    public JsonbRowMapper(Class<T> type, ObjectMapper objectMapper) {
        this.type = type;
        this.objectMapper = objectMapper;
    }

    @Override
    public T mapRow(ResultSet rs, int rowNum) throws SQLException {
        String json = rs.getString("jsonb_column_name");
        try {
            return objectMapper.readValue(json, type);
        } catch (IOException e) {
            throw new SQLException("Failed to parse JSON", e);
        }
    }
}

import org.springframework.jdbc.core.JdbcTemplate;

public class ExampleDao {
    private final JdbcTemplate jdbcTemplate;
    private final JsonbRowMapper<ExampleModel> rowMapper;

    public ExampleDao(JdbcTemplate jdbcTemplate, JsonbRowMapper<ExampleModel> rowMapper) {
        this.jdbcTemplate = jdbcTemplate;
        this.rowMapper = rowMapper;
    }

    public ExampleModel getExampleModelById(int id) {
        String sql = "SELECT jsonb_column_name FROM example_table WHERE id = ?";
        return jdbcTemplate.queryForObject(sql, new Object[]{id}, rowMapper);
    }
}