String sql = "select * from room where room.build_id=?";
List roomList = this.jdbcTemplate.query(sql, new Object[]{buildid}, new RoomMapper());
//定义RoomMapper类继承 RowMapper
public class RoomMapper implements RowMapper {
public Object mapRow(ResultSet rs, int index) throws SQLException {
RoomDto roomDto = new RoomDto();
roomDto.setRoomid(rs.getLong("roomid"));
roomDto.setRoomName(rs.getString("roomName"));
roomDto.setBuildid(rs.getLong("build_id"));
roomDto.setBuildName(rs.getString("buildName"));
roomDto.setStateid(rs.getLong("state_id"));
roomDto.setState(rs.getString("state"));
return roomDto;
}
}
List roomList = this.jdbcTemplate.query(sql, new Object[]{buildid}, new RoomMapper());
//定义RoomMapper类继承 RowMapper
public class RoomMapper implements RowMapper {
public Object mapRow(ResultSet rs, int index) throws SQLException {
RoomDto roomDto = new RoomDto();
roomDto.setRoomid(rs.getLong("roomid"));
roomDto.setRoomName(rs.getString("roomName"));
roomDto.setBuildid(rs.getLong("build_id"));
roomDto.setBuildName(rs.getString("buildName"));
roomDto.setStateid(rs.getLong("state_id"));
roomDto.setState(rs.getString("state"));
return roomDto;
}
}