[Spring]クラスJdbcTemplateとBeanPropertyRowMapperを使うサンプル
説明
query(PreparedStatementCreator psc, RowMapper<T> rowMapper)
準備済みステートメントを使用して照会し、RowMapper を介して各行を結果オブジェクトにマッピングします。
@Override
public <T> List<T> query(String sql, Object[] args, RowMapper<T> rowMapper) throws DataAccessException {
return query(sql, args, new RowMapperResultSetExtractor<T>(rowMapper));
}
@Override
public <T> List<T> query(String sql, Object[] args, RowMapper<T> rowMapper) throws DataAccessException {
return query(sql, args, new RowMapperResultSetExtractor<T>(rowMapper));
}
@Override
public <T> List<T> query(String sql, Object[] args, RowMapper<T> rowMapper) throws DataAccessException {
return query(sql, args, new RowMapperResultSetExtractor<T>(rowMapper));
}
使用例
@Autowired
JdbcTemplate jdbcTemplate;
public user getInfo(String userid) {
String selectSQL = "select * from user";
RowMapper<UserData>mapper= new BeanPropertyRowMapper<UserData>(UserData.class);
List<UserData>userLst = jdbcTemplate.query(selectSQL,mapper);
return userLst.get(0);
}
@Autowired
JdbcTemplate jdbcTemplate;
public user getInfo(String userid) {
String selectSQL = "select * from user";
RowMapper<UserData>mapper= new BeanPropertyRowMapper<UserData>(UserData.class);
List<UserData>userLst = jdbcTemplate.query(selectSQL,mapper);
return userLst.get(0);
}
@Autowired
JdbcTemplate jdbcTemplate;
public user getInfo(String userid) {
String selectSQL = "select * from user";
RowMapper<UserData>mapper= new BeanPropertyRowMapper<UserData>(UserData.class);
List<UserData>userLst = jdbcTemplate.query(selectSQL,mapper);
return userLst.get(0);
}