在下面的示例中, jdbcTemplate.queryForList
返回一个Integer
对象,我们尝试将其直接转换为Long
:
public List<Customer> findAll() {
String sql = "SELECT * FROM CUSTOMER";
List<Customer> customers = new ArrayList<>();
List<Map<String, Object>> rows = jdbcTemplate.queryForList(sql);
for (Map row : rows) {
Customer obj = new Customer();
obj.setID(((Long) row.get("ID"))); // the object is an Integer
obj.setName((String) row.get("NAME"));