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; }