@Override
public void altaHospitales(Hospital hospital) {
try {
MySQL.conexion();
Integer id = MySQL.insertOne("hospital");
MySQL.updateOne(id, "hospital", "nombre", hospital.getNombre());
MySQL.updateOne(id, "hospital", "direccion", hospital.getDireccion());
MySQL.updateOne(id, "hospital", "telefono", "" + hospital.getTelefono());
MySQL.updateOne(id, "hospital", "personal", "" + hospital.getPersonal());
MySQL.updateOne(id, "hospital", "salas", "" + hospital.getSalas());
MySQL.desconexion();
} catch (Exception ex) {
Logger.getLogger(HospitalDAOMysql.class.getName()).log(Level.SEVERE, null, ex);
}
}
@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;
}