知识点：
1 JDBC依赖，oracle支持依赖
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.4.0-atlassian-hosted</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
2 掌握RowMapper<Grade> rowMapper = new BeanPropertyRowMapper<>(Grade.class);映射。
class GradeRowMapper implements RowMapper<Grade> {
@Override
public Grade mapRow(ResultSet rs, int rowNum) throws SQLException {
Grade g = new Grade();
g.setId(rs.getInt(“id”));
g.setGradeNm(rs.getString(“grade_nm”));
g.setTeacherId(rs.getInt(“teacher_id”));
return g;
}
}
工程浏览：