直接上代码:
public static List<UpdateRecord> getUpdateRecord() { String sql = "select * from update_record order by update_time desc limit 1"; updateRecordList = jdbcTemplate.query(sql, new MyRowMapper()); return updateRecordList; } public class MyRowMapper implements RowMapper<UpdateRecord> { @Override public UpdateRecord mapRow(ResultSet rs, int i) throws SQLException { //从结果集中将结果得到 String last_version = rs.getString("last_version"); Integer last_page = rs.getInt("last_page"); Integer last_num = rs.getInt("last_num"); String update_time = rs.getString("update_time"); //将对象封装到对象里 UpdateRecord updateRecord = new UpdateRecord(); updateRecord.setLast_version(last_version); updateRecord.setLast_page(last_page); updateRecord.setLast_num(last_num); updateRecord.setUpdate_time(update_time); return updateRecord; } }
可以得到list结果