Spring 结果集提取器 [英] Spring ResultSetExtractor

问题描述

如何使用ResultSetExtractor 从数据库中检索数据?在这里，我使用 oracle 10g 作为后端.如果从员工表中搜索员工详细信息，使用 ResultSetExtractor 或 RowMapper 哪个更好?

How to use ResultSetExtractor to retrieve data from database? here I am using oracle 10g as back end. In case of searching an Employee details from Employee Table which one is better to use ResultSetExtractor or RowMapper?

推荐答案

从 Java 8 开始，还可以使用闭包 (lambdas) 作为行映射例程:

One can also use closures (lambdas) as row mapping routine since java 8:

String sql = "select first_name, last_name from PERSON where id = ?";

public Person jdbcTemplate.query(sql,(rs)->{return new Person(rs.getString("first_name"), rs.getString("last_name"));}, int id);

第一个方法参数是您的查询，第二 - 你的映射器 - 需要 Person(String, String) 构造函数.first_name"、last_name"是数据库列名称.第三 - id 的 arg，它是一个可变参数，您可以在其中放置更多参数.

First method param is your query, second - your mapper - Person(String, String) constructor is needed. "first_name", "last_name" are the db-column names. Third - the arg for the id, it's a vararg where you can put more params.

这篇关于Spring 结果集提取器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！