public Rodovia buscarPorId(int id) {
String sql = "select * from rodovia where idrodovia = ?";
Rodovia r = null;
try {
PreparedStatement stmt = con.prepareStatement(sql);
stmt.setInt(1, id);
ResultSet rs = stmt.executeQuery();
if (rs.next()) {
r.setIdRodovia(rs.getInt("idrodovia"));
r.setNome(rs.getString("nome"));
r.setExtensaoKm(rs.getInt("extensaokm"));
r.setCidadeFinal(rs.getString("cidadeinicial"));
r.setCidadeFinal(rs.getString("cidadefinal"));
r.setUfInicial(rs.getString("ufinicial"));
r.setUfFinal(rs.getString("uffinal"));
// r.setSituacao(rs.getString("situacao").charAt(0));
}
stmt.close();
rs.close();
con.close();
} catch (SQLException e) {
throw new RuntimeException(e);
}
return r;
}
