知乎专栏 |
@Autowired private JdbcTemplate jdbcTemplate; @RequestMapping(value = "/jdbc") public @ResponseBody String dailyStats(@RequestParam Integer id) { String query = "SELECT id, firstname, lastname from customer where id = " + id; return jdbcTemplate.queryForObject(query, (resultSet, i) -> { System.out.println(resultSet.getLong(1)+","+ resultSet.getString(2)+","+ resultSet.getString(3)); return (resultSet.getLong(1)+","+ resultSet.getString(2)+","+ resultSet.getString(3)); }); }