package enefro.interop.SQL; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.LinkedList; import enefro.interop.bean.AppointmentBean; public class AppointmentSQL { public static LinkedList getAppointmentsByPractitioner(String idPrac) { LinkedList listAppointments=new LinkedList(); try { Class.forName("org.postgresql.Driver"); String usuario = "enefro_owner"; String password = "enefro_owner"; String url = "jdbc:postgresql://gibserv.us.es:4502/enefro"; Connection conexion = DriverManager.getConnection(url, usuario, password); Statement st = conexion.createStatement(); ResultSet rs = st.executeQuery("SELECT * FROM " + "((((e_appointmentactivity left join e_appointmentregistry on appo_id=appr_appointmentacti) " + "INNER JOIN e_activity ON appo_base_acti = acti_id) INNER JOIN e_plan ON appo_id_plan=plan_id) " + "LEFT JOIN e_clinicalregistry ON appr_base_crir=crir_id) WHERE appo_citadocon = (SELECT usua_id " + "FROM e_usuario INNER JOIN e_person ON usua_persona=pers_id WHERE pers_document = '"+idPrac+"')"); while (rs.next()) { AppointmentBean appointment = new AppointmentBean(); appointment = new AppointmentBean(); appointment.setIdCita(rs.getInt("appo_id")); appointment.setIdPlan(rs.getInt("appo_id_plan")); appointment.setIdPaciente(rs.getInt("plan_pacienteusuario")); appointment.setIdProfesional(rs.getInt("appo_citadocon")); appointment.setLocalizacion(rs.getString("acti_location")); appointment.setFechaInicio(rs.getDate("acti_startdate")); appointment.setCausa(rs.getString("acti_problemaa")); appointment.setDescripcion(rs.getString("acti_description")); appointment.setObserMed(rs.getString("appo_observacionpriv")); appointment.setObserEnf(rs.getString("appo_observacionenfe")); appointment.setComenPac(rs.getString("crir_comentarios")); listAppointments.add(appointment); } rs.close(); st.close(); conexion.close(); } catch (Exception e) { e.printStackTrace(); } return listAppointments; } } e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.


SERVICIO WEB PARA EL ACCESO A INFORMACIÓN SANITARIA DE PACIENTES RENALES

: Pedrera Jiménez, Miguel
: Grado en Ingeniería de las Tecnologías de Telecomunicación
Contenido del proyecto:
Directorio raíz  >  codigo  >  ServicioWebFHIR  >  src  >  main  >  java  >  enefro  >  interop  >  SQL  >  AppointmentSQL.java