@Override public Hospital recuperaHospital(Integer id) throws Exception { try { MySQL.conexion(); String sql = "SELECT * FROM hospital WHERE ID=" + id; ResultSet result = MySQL.get(sql); Hospital hospital = new Hospital(); if (result.next()) { hospital.setId(result.getInt("id")); hospital.setDireccion(result.getString("direccion")); hospital.setNombre(result.getString("nombre")); hospital.setTelefono(result.getInt("telefono")); hospital.setPersonal(result.getString("personal")); hospital.setSalas(result.getInt("salas")); } return hospital; } catch (Exception e) { e.printStackTrace(); } return null; }
@Override public ArrayList<Hospital> recuperaHospitales() { ArrayList<Hospital> listaHospitales = new ArrayList(); try { MySQL.conexion(); String sql = "SELECT * FROM hospital"; ResultSet rs = MySQL.get(sql); while (rs.next()) { Hospital hospital = new Hospital(); hospital.setId(rs.getInt("id")); hospital.setDireccion(rs.getString("direccion")); hospital.setNombre(rs.getString("nombre")); hospital.setTelefono(rs.getInt("telefono")); hospital.setPersonal(rs.getString("personal")); hospital.setSalas(rs.getInt("salas")); listaHospitales.add(hospital); } } catch (Exception e) { e.printStackTrace(); } return listaHospitales; }