********************************************************************************************************************** CLASE CITA **********************************************************************************************************************<\/p>\n
package clases;<\/p>\n
import java.sql.*;
\nimport oracle.jdbc.*;
\nimport java.util.*;<\/p>\n
public class Cita{
\npublic String id_Cita=\"\";
\npublic String id_medico;
\npublic String id_paciente;
\npublic String fecha_cita;
\npublic String hora_cita;
\npublic String id_Consultorio;
\npublic int cont=0;<\/p>\n
public int nuevaCita(String nomPac,String apePac,String nomDoc,String apeDoc,String fechaCita,String horaCita){<\/p>\n
bean b=new bean();
\nCallableStatement stm=null;
\ncont++;
\ntry{
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL pcita.ingresar_cita(?,?,?,?,?,?)}\");
\nstm.setString(1,nomPac);
\nstm.setString(2,apePac);
\nstm.setString(3,nomDoc);
\nstm.setString(4,apeDoc);
\nstm.setString(5,fechaCita);
\nstm.setString(6,horaCita);
\nstm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public ArrayList consultanomPaciente(){<\/p>\n
bean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;<\/p>\n
try{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pcita.consultarCitasxPac(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
public int borrarCita(String nombre,String apellido,String nCita){<\/p>\n
bean b=new bean();
\nCallableStatement stm=null;
\ncont++;
\ntry{
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL pcita.eliminar_cita(?,?,?)}\");
\nstm.setString(1,nombre);
\nstm.setString(2,apellido);
\nstm.setString(3,nCita);
\nstm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public String consultarCitas(){<\/p>\n
String datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nCallableStatement stm = null;
\nResultSet rs;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pcita.consultar_cita(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=1;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=1;i<=numCol;i++)
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";
\ndatos=datos + \"<\/tr>\" ;
\n}
\ndatos=datos + \"<\/table>\";
\n}catch(Exception e){}
\nreturn datos;<\/p>\n
}<\/p>\n
}<\/p>\n
********************************************************************************************************************** CLASE HISTORIA CLINICA **********************************************************************************************************************<\/p>\n
package clases;
\nimport java.sql.*;
\nimport java.util.*;
\nimport oracle.jdbc.*;<\/p>\n
public class HistoriaClinica{
\npublic String id_Paciente;
\npublic String ced_Paciente;
\npublic String tipo_Sangre;
\npublic String peso;
\npublic String altura;
\npublic String riesgo;
\npublic String antecedentes;
\npublic String motivo;
\npublic int cont=0;
\npublic int result;<\/p>\n
public int nuevaHistoriaClinica(String cedPaciente,String tipoSangre,String peso,String altura,String riesgo,String antecedentes, String motivo){<\/p>\n
bean b=new bean();
\nCallableStatement stm=null;
\n\/\/cont++;
\ntry{
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL phclinica.ingresar_hc(?,?,?,?,?,?,?)}\");
\nstm.setString(1,cedPaciente);
\nstm.setString(2,tipoSangre);
\nstm.setString(3,peso);
\nstm.setString(4,altura);
\nstm.setString(5,riesgo);
\nstm.setString(6,antecedentes);
\nstm.setString(7,motivo);
\nstm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public ArrayList nomHC(){<\/p>\n
\/\/String datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\n\/\/ this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL phclinica.nomHC(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
public ArrayList consultaxCedula(String cedula){<\/p>\n
\/\/String datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\n\/\/ this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL phclinica.consultarXid(?,?)}\");
\nstm.setString(1,cedula);
\nstm.registerOutParameter(2,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(2);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
public String consultarHC(String nombre, String apellido){
\nString datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\nthis.ced_Paciente=null;
\n\/\/ this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL phclinica.consultar_hc(?,?,?)}\");
\nstm.setString(1,nombre);
\nstm.setString(2,apellido);
\nstm.registerOutParameter(3,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(3);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";<\/p>\n
}
\nthis.ced_Paciente=rs.getString(1);<\/p>\n
}
\nif(this.ced_Paciente.equals(null))
\n{<\/p>\n
return null;
\n}<\/p>\n
String compl=\"modificarHC.jsp?par=\" + this.ced_Paciente;
\ndatos=datos +\"<td><a href=\"+compl+\">Modificar<\/td>\"+\"<\/tr>\";<\/p>\n
datos=datos + \"<\/table>\";<\/p>\n
}catch(Exception e){}<\/p>\n
return datos;<\/p>\n
}<\/p>\n
public int modificarHC(String id,String peso,String altura,String riesgo,String antecedentes, String motivo){<\/p>\n
bean b = new bean();
\nCallableStatement stm = null;<\/p>\n
try{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL phclinica.modificar_hc(?,?,?,?,?,?)}\");<\/p>\n
stm.setString(1,id);
\nstm.setString(2,peso);
\nstm.setString(3,altura);
\nstm.setString(4,riesgo);
\nstm.setString(5,antecedentes);
\nstm.setString(6,motivo);
\nstm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public String consultaHC(){
\nString datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nCallableStatement stm = null;
\nResultSet rs;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL phclinica.tbhc(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=1;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=1;i<=numCol;i++){
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";
\n}
\ndatos=datos + \"<\/tr>\" ;
\n}
\ndatos=datos + \"<\/table>\";<\/p>\n
}catch(Exception e){}
\nreturn datos;<\/p>\n
}<\/p>\n
********************************************************************************************************************** CLASE HISTORIAL **********************************************************************************************************************<\/p>\n
package clases;
\nimport java.sql.*;
\nimport java.util.*;
\nimport oracle.jdbc.*;<\/p>\n
public class Historial{
\npublic String id_Historial;
\npublic String id_Empleado;
\npublic String descripcion;
\npublic String hora;
\npublic String fecha;<\/p>\n
public void setFecha(String fecha) {
\nthis.fecha = fecha;
\n}<\/p>\n
public void setHora(String hora) {
\nthis.hora = hora;
\n}<\/p>\n
public String getFecha() {
\nreturn fecha;
\n}<\/p>\n
public String getHora() {
\nreturn hora;
\n}<\/p>\n
public void setId_Empleado(String id_Empleado) {
\nthis.id_Empleado = id_Empleado;
\n}<\/p>\n
public void setId_Historial(String id_Historial) {
\nthis.id_Historial = id_Historial;
\n}<\/p>\n
public void setdescripcion(String descripcion) {
\nthis.descripcion = descripcion;
\n}<\/p>\n
public String getId_Empleado() {
\nreturn id_Empleado;
\n}<\/p>\n
public String getId_Historial() {
\nreturn id_Historial;
\n}<\/p>\n
public String getDescripcion() {
\nreturn descripcion;
\n}<\/p>\n
public void registrarHistorial(String id_Empleado, String descripcion, String hora, String fecha){
\nCallableStatement stm = null;
\nResultSet rs ;
\nbean b= new bean();<\/p>\n
try{
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL pHistorial.ingresar_historial(?,?,?,?)}\");
\nstm.setString(1,id_Empleado);
\nstm.setString(2,descripcion);
\nstm.setString(3,hora);
\nstm.setString(4,fecha);
\nstm.executeQuery();<\/p>\n
}catch (Exception e){}
\n}<\/p>\n
public String consultar() {<\/p>\n
String datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nCallableStatement stm = null;
\nResultSet rs ;<\/p>\n
try{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pGeneraSesion.consultar(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();<\/p>\n
rs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=1;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=1;i<=numCol;i++){
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";
\n}
\n}
\nb.close();<\/p>\n
}catch (Exception e){e.printStackTrace();}
\nreturn datos;
\n}<\/p>\n
public int eliminarDB() {
\nthrow new UnsupportedOperationException(\"Not supported yet.\");
\n}<\/p>\n
public int actualizarDB() {
\nreturn 0;
\n}
\n********************************************************************************************************************** CLASE MEDICINA<\/p>\n
**********************************************************************************************************************<\/p>\n
package clases;
\nimport java.sql.*;
\nimport java.util.*;
\nimport oracle.jdbc.*;<\/p>\n
public class Medicina{<\/p>\n
public String cod_Medicina=\"\";
\npublic String nombre;
\npublic String tipo;
\npublic String laboratorio;
\npublic String fecha_cad;
\npublic String stock;
\npublic String cod_farmacia;
\npublic int cont=0;
\npublic String tmp;<\/p>\n
public Medicina newMedicina(String cod_med,String nombre,String farmacia,String tipo,String laboratorio,String fechacad,String stock){<\/p>\n
Medicina m= new Medicina();<\/p>\n
m.cod_Medicina=cod_med;
\nm.nombre=nombre;
\nm.cod_farmacia=farmacia;
\nm.tipo=tipo;
\nm.laboratorio=laboratorio;
\nm.stock=stock;
\nm.fecha_cad=fechacad;<\/p>\n
return m;
\n}<\/p>\n
public int ingresarMedicina(String nombre,String farmacia,String tipo,String laboratorio,String fechacad,String stock){<\/p>\n
bean b=new bean();
\nCallableStatement stm=null;
\n\/\/cont++;
\ntry{
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL pmedicina.ingresar_medicina(?,?,?,?,?,?)}\");
\nstm.setString(1,nombre);
\nstm.setString(2,farmacia);
\nstm.setString(3,tipo);
\nstm.setString(4,laboratorio);
\nstm.setString(5,fechacad);
\nstm.setString(6,stock);
\nstm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public int modificarMedicina(String id, String stock){<\/p>\n
bean b = new bean();
\nCallableStatement stm = null;<\/p>\n
try{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pmedicina.modificar_medicina(?,?)}\");<\/p>\n
stm.setString(1,id);
\nstm.setString(2,stock);<\/p>\n
stm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public ArrayList nombreMedicinas(){<\/p>\n
\/\/String datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\n\/\/ this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pmedicina.nombreMedicinas(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
public ArrayList tipoMedicinas(){<\/p>\n
\/\/String datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\n\/\/ this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pmedicina.tipoMedicinas(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
public ArrayList labMedicinas(){<\/p>\n
\/\/String datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\n\/\/ this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pmedicina.labMedicinas(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
public ArrayList consultaxCod(String cod){<\/p>\n
\/\/String datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\n\/\/this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pmedicina.consultarXcod(?,?)}\");
\nstm.setString(1,cod);
\nstm.registerOutParameter(2,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(2);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
public int borrarMedicina(String nombre){<\/p>\n
bean b=new bean();
\nCallableStatement stm=null;
\ncont++;
\ntry{
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL sp_delete_medicina(?)}\");
\nstm.setString(1,nombre);
\nstm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public String consultarxNombre(String nombre){<\/p>\n
bean b=new bean();
\nCallableStatement stm=null;
\nString id = null;
\nResultSet rs;
\ntry{
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL pmedicina.consultarXnombre(?,?)}\");
\nstm.setString(1,nombre);
\nstm.registerOutParameter(2,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(2);
\n\/\/\u00a0\u00a0\u00a0\u00a0 ResultSetMetaData rm = null ;
\n\/\/\u00a0\u00a0\u00a0\u00a0 rm=rs.getMetaData();
\n\/\/\u00a0\u00a0\u00a0\u00a0 int numCol=rm.getColumnCount();
\nwhile(rs.next())
\nid=rs.getString(1);<\/p>\n
stm.close();
\nb.close();<\/p>\n
}catch(Exception e){}<\/p>\n
return id;
\n}<\/p>\n
public String consultaxNombre(String nombre, int cargo){
\nString datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();<\/p>\n
CallableStatement stm = null;
\nResultSet rs;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pmedicina.consultarXnombre(?,?)}\");
\nstm.setString(1,nombre);
\nstm.registerOutParameter(2,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(2);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";<\/p>\n
}
\nif(cargo==1){
\nthis.cod_Medicina=rs.getString(1);
\nString compl=\"modificarMedicina.jsp?par=\" + this.cod_Medicina;
\ndatos=datos +\"<td><a href=\"+compl+\">Modificar<\/td>\"+\"<\/tr>\";
\ndatos=datos + \"<\/tr>\" ;
\n}
\n}<\/p>\n
datos=datos + \"<\/table>\";
\n}catch(Exception e){}
\nreturn datos;<\/p>\n
}<\/p>\n
public String consultaxTipo(String tipo, int cargo){
\nString datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();<\/p>\n
CallableStatement stm = null;
\nResultSet rs;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pmedicina.consultarXtipo(?,?)}\");
\nstm.setString(1,tipo);
\nstm.registerOutParameter(2,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(2);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";
\n}<\/p>\n
if(cargo==1){
\nthis.cod_Medicina=rs.getString(1);
\nString compl=\"modificarMedicina.jsp?par=\" + this.cod_Medicina;
\ndatos=datos +\"<td><a href=\"+compl+\">Modificar<\/td>\"+\"<\/tr>\";
\ndatos=datos + \"<\/tr>\" ;
\n}<\/p>\n
}<\/p>\n
datos=datos + \"<\/table>\";
\n}catch(Exception e){}
\nreturn datos;<\/p>\n
}
\npublic String consultaxLab(String lab, int cargo){
\nString datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();<\/p>\n
CallableStatement stm = null;
\nResultSet rs;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pmedicina.consultarXlab(?,?)}\");
\nstm.setString(1,lab);
\nstm.registerOutParameter(2,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(2);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";
\n}<\/p>\n
if(cargo==1){
\nthis.cod_Medicina=rs.getString(1);
\nString compl=\"modificarMedicina.jsp?par=\" + this.cod_Medicina;
\ndatos=datos +\"<td><a href=\"+compl+\">Modificar<\/td>\"+\"<\/tr>\";
\ndatos=datos + \"<\/tr>\" ;
\n}<\/p>\n
}<\/p>\n
datos=datos + \"<\/table>\";
\n}catch(Exception e){}
\nreturn datos;<\/p>\n
}<\/p>\n
public String consultaMedicina(){
\nString datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nCallableStatement stm = null;
\nResultSet rs;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL pmedicina.tbMedicina(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";
\n}
\ndatos=datos + \"<\/tr>\" ;
\n}
\ndatos=datos + \"<\/table>\";
\n}catch(Exception e){}
\nreturn datos;<\/p>\n
}
\n}<\/p>\n
********************************************************************************************************************** CLASE PERSONAL **********************************************************************************************************************<\/p>\n
package clases;<\/p>\n
import java.sql.*;
\nimport java.util.*;
\nimport oracle.jdbc.*;<\/p>\n
\/\/import java.util.*;<\/p>\n
\/**
\n*
\n* @author
\n*\/
\npublic class Personal {
\npublic String id_personal;
\npublic String nombre;
\npublic String apellido;
\npublic String genero;
\npublic String cargo;
\npublic String horario;
\npublic String email;
\npublic String telefono;
\npublic int cont=0;<\/p>\n
public int ingresarPersonal(String cedPersonal,String nombre,String apellido,String genero,String cargo,String horario,String email,String telefono){<\/p>\n
bean b=new bean();
\nCallableStatement stm=null;
\ncont++;
\ntry{
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppersonal.ingresar_personal(?,?,?,?,?,?,?,?)}\");
\nstm.setString(1,cedPersonal);
\nstm.setString(2,nombre);
\nstm.setString(3,apellido);
\nstm.setString(4,cargo);
\nstm.setString(5,genero);
\nstm.setString(6,horario);
\nstm.setString(7,email);
\nstm.setString(8,telefono);
\nstm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public ArrayList consultanomPersonal(){<\/p>\n
\/\/String datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\n\/\/ this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppersonal.consultarnomPersonal(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
public int borrarPersonal(String id){<\/p>\n
bean b=new bean();
\nCallableStatement stm=null;
\ncont++;
\ntry{
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppersonal.eliminar_personal(?)}\");
\nstm.setString(1,id);
\nstm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public String consultaDoc(){
\nString datos=\"<table border=1 align=center> <tr>\";
\n\/\/String query=\"select nombre,apellido,cargo,genero,horario,e_mail,telefono from Personal where cargo not in('Secretaria','Conserje','Farmaceutico')\";
\nCallableStatement stm = null;
\nResultSet rs;
\ntry{
\nbean b = new bean();
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppersonal.consultar_personal_doc(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=1;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=1;i<=numCol;i++)
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";
\ndatos=datos + \"<\/tr>\" ;
\n}
\ndatos=datos + \"<\/table>\";
\n}catch(Exception e){}
\nreturn datos;<\/p>\n
}<\/p>\n
public String consultaPersonal(){
\nString datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nCallableStatement stm = null;
\nResultSet rs;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppersonal.consultar_personal(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";
\n}
\nthis.id_personal=rs.getString(1);
\nString compl=\"modificarPersonal.jsp?par=\" + this.id_personal;
\ndatos=datos +\"<td><a href=\"+compl+\">Modificar<\/td>\"+\"<\/tr>\";
\ndatos=datos + \"<\/tr>\" ;
\n}
\ndatos=datos + \"<\/table>\";
\n}catch(Exception e){}
\nreturn datos;<\/p>\n
}<\/p>\n
public int existePersonal(String nombre,String apellido, String ced){
\nbean b=new bean();
\nCallableStatement stm=null;
\nResultSet rs;
\nString id = null;
\ntry{
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppersonal.consultaSiExiste(?,?,?,?)}\");
\nstm.setString(1,nombre);
\nstm.setString(2,apellido);
\nstm.setString(3,ced);
\nstm.registerOutParameter(4,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(4);
\nwhile(rs.next())
\nid = rs.getString(1);
\nstm.close();
\nb.close();
\nif(id==null)<\/p>\n
return 0;
\nelse
\nreturn 1;
\n}catch(Exception e){return (-1);}<\/p>\n
}<\/p>\n
public int modificarPersonal(String id, String cargo, String mail, String hora, String fono,String estado){<\/p>\n
bean b = new bean();
\nCallableStatement stm = null;<\/p>\n
try{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppersonal.modificar_personal(?,?,?,?,?,?)}\");
\nstm.setString(1,id);
\nstm.setString(2,cargo);
\nstm.setString(3,hora);
\nstm.setString(4,mail);
\nstm.setString(5,fono);
\nstm.setString(6,estado);
\nstm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public ArrayList consultaXid(String id){<\/p>\n
bean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\n\/\/this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppersonal.consultarXid(?,?)}\");
\nstm.setString(1,id);
\nstm.registerOutParameter(2,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(2);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
}<\/p>\n
********************************************************************************************************************** CLASE PACIENTE **********************************************************************************************************************<\/p>\n
package clases;
\nimport java.sql.*;
\nimport java.util.*;
\nimport oracle.jdbc.*;<\/p>\n
public class Paciente {
\npublic String id_Paciente;
\npublic String nombre;
\npublic String apellido;
\npublic String edad;
\npublic String direccion;
\npublic String genero;
\npublic String email;
\npublic String telefono;
\npublic int cont=0;<\/p>\n
public int ingresarPaciente(String idPaciente,String name,String lname,String edad,String direccion,String genero,String email,String phone){
\nbean b=new bean();
\nCallableStatement stm=null;
\ntry{
\nb.connect();<\/p>\n
stm = b.getCon().prepareCall(\"{CALL ppaciente.ingresar_paciente (?,?,?,?,?,?,?,?)}\");
\nstm.setString(1,idPaciente);
\nstm.setString(2,name);
\nstm.setString(3,lname);
\nstm.setString(4,edad);
\nstm.setString(5,direccion);
\nstm.setString(6,genero);
\nstm.setString(7,email);
\nstm.setString(8,phone);
\nstm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public int existePaciente(String nombre,String apellido, String ced){
\nbean b=new bean();
\nCallableStatement stm=null;
\nResultSet rs;
\nString id = null;
\ntry{
\nb.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppaciente.consultaSiExiste (?,?,?,?)}\");
\nstm.setString(1,nombre);
\nstm.setString(2,apellido);
\nstm.setString(3,ced);
\nstm.registerOutParameter(4,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(4);
\nwhile(rs.next())
\nid = rs.getString(1);
\nstm.close();
\nb.close();
\nif(id==null)<\/p>\n
return 0;
\nelse
\nreturn 1;
\n}catch(Exception e){return (-1);}<\/p>\n
}<\/p>\n
public String consultaPaciente(String nom,String ape){
\nString datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nCallableStatement stm = null;
\nResultSet rs;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppaciente.consultar_paciente(?,?,?)}\");
\nstm.setString(1,nom);
\nstm.setString(2,ape);
\nstm.registerOutParameter(3,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(3);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";<\/p>\n
}
\nthis.id_Paciente=rs.getString(1);
\nString compl=\"modificarPaciente.jsp?par=\" + this.id_Paciente;
\ndatos=datos +\"<td><a href=\"+compl+\">Modificar<\/td>\"+\"<\/tr>\";
\ndatos=datos + \"<\/tr>\" ;
\n}<\/p>\n
datos=datos + \"<\/table>\";
\n}catch(Exception e){}
\nreturn datos;<\/p>\n
}<\/p>\n
public String tbPaciente(){
\nString datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nCallableStatement stm = null;
\nResultSet rs;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppaciente.tbPaciente(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";<\/p>\n
}
\nthis.id_Paciente=rs.getString(1);
\nString compl=\"modificarPaciente.jsp?par=\" + this.id_Paciente;
\ndatos=datos +\"<td><a href=\"+compl+\">Modificar<\/td>\"+\"<\/tr>\";
\ndatos=datos + \"<\/tr>\" ;
\n}<\/p>\n
datos=datos + \"<\/table>\";
\n}catch(Exception e){}
\nreturn datos;<\/p>\n
}<\/p>\n
public ArrayList consultacedPaciente(){<\/p>\n
\/\/String datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\n\/\/ this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppaciente.cedulaPaciente(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
public ArrayList consultanomPaciente(){<\/p>\n
\/\/String datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\n\/\/ this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppaciente.consultarnomPaciente(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
public int modificarPaciente(String id, String edad, String direc, String mail, String fono){<\/p>\n
bean b = new bean();
\nCallableStatement stm = null;<\/p>\n
try{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppaciente.modificar_paciente(?,?,?,?,?)}\");
\nstm.setString(1,id);
\nstm.setString(2,edad);
\nstm.setString(3,direc);
\nstm.setString(4,mail);
\nstm.setString(5,fono);
\nstm.executeQuery();
\nstm.close();
\nb.close();<\/p>\n
return 1;<\/p>\n
}catch(Exception e){return 0;}<\/p>\n
}<\/p>\n
public ArrayList consultaXid(String id){<\/p>\n
bean b = new bean();
\nArrayList y = new ArrayList();
\nCallableStatement stm = null;
\nResultSet rs ;
\n\/\/this.cont++;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppaciente.consultarXid(?,?)}\");
\nstm.setString(1,id);
\nstm.registerOutParameter(2,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(2);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();
\nwhile(rs.next()){
\nfor(int i=1;i<=numCol;i++){
\ny.add(rs.getString(i));
\n}
\n}
\n}catch(Exception e){
\nSystem.out.print(\"se cayo\");
\n}
\nb.close();
\nreturn y;
\n}<\/p>\n
public String consultaPaciente(){
\nString datos=\"<table border=1 align=center> <tr>\";
\nbean b = new bean();
\nCallableStatement stm = null;
\nResultSet rs;
\ntry{<\/p>\n
b.connect();
\nstm = b.getCon().prepareCall(\"{CALL ppaciente.consulta_paciente(?)}\");
\nstm.registerOutParameter(1,OracleTypes.CURSOR);
\nstm.executeQuery();
\nrs= (ResultSet)stm.getObject(1);<\/p>\n
ResultSetMetaData rm = null ;
\nrm=rs.getMetaData();
\nint numCol=rm.getColumnCount();<\/p>\n
for(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\" + rm.getColumnName(i)+\"<\/td>\";
\n}
\ndatos = datos + \"<\/tr>\" ;<\/p>\n
while(rs.next()){
\ndatos=datos + \"<tr>\";
\nfor(int i=2;i<=numCol;i++){
\ndatos=datos + \"<td>\"+rs.getString(i)+\"<\/td>\";
\n}
\ndatos=datos + \"<\/tr>\" ;
\n}
\ndatos=datos + \"<\/table>\";
\n}catch(Exception e){}
\nreturn datos;<\/p>\n
}<\/p>\n
}
\n********************************************************************************************************************** CLASE BEAN (Realiza la conexion con la Base de Datos) **********************************************************************************************************************<\/p>\n
package clases;
\nimport java.sql.*;<\/p>\n
public class bean {
\nprivate Connection con=null;
\nString dbDriver = \"oracle.jdbc.driver.OracleDriver\";<\/p>\n
public bean(){
\nsuper();
\n}<\/p>\n
public boolean connect() throws SQLException{
\ntry{
\nClass.forName(dbDriver);
\n}
\ncatch(Exception e){
\nSystem.out.println ( \"No se puede cargar el driver\" );
\ne.printStackTrace();
\n}<\/p>\n
con=DriverManager.getConnection(\"jdbc:oracle:thin:@localhost:1521:XE\",\"ccm\",\"ccm\");
\nSystem.out.println( \"Conexion establecida\");
\nreturn true;<\/p>\n
}<\/p>\n
public void close(){
\ntry{
\ncon.close();
\n}catch (SQLException sqle) {
\nSystem.out.println( \"Error al momento ce cerrar la BD\" );
\nsqle.printStackTrace();
\n}
\n}<\/p>\n
public Connection getCon() {
\nreturn con;
\n}<\/p>\n
public ResultSet execSQL<\/p>\n
(String sql) throws SQLException{<\/p>\n
Statement s = con.createStatement();
\nResultSet r = s.executeQuery(sql);
\nreturn (r == null) ? null : r;<\/p>\n
}<\/p>\n
public int updateSQL(String sql) throws SQLException{
\nStatement s = con.createStatement();
\nint r = s.executeUpdate(sql);
\nreturn (r == 0) ? 0 : r;
\n}<\/p>\n
}
\n********************************************************************************************************************** CLASE FECHAHORA (Sirve para obtener la fecha y hora actual del sistema) **********************************************************************************************************************<\/p>\n
package clases;
\nimport java.util.*;
\nimport java.text.SimpleDateFormat;<\/p>\n
public class FechaHora {
\nprivate Date curDate;
\nprivate SimpleDateFormat dateFormat;
\nprivate SimpleDateFormat dateFormat1;
\nprivate GregorianCalendar targedate;
\nprivate String nombre;<\/p>\n
public FechaHora() {
\nGregorianCalendar currentDate = new GregorianCalendar();
\ncurDate = (Date) currentDate.getTime();
\ndateFormat = new SimpleDateFormat(\"dd\/MM\/yyyy\");
\ndateFormat1 = new SimpleDateFormat(\"HH:mm:ss\");
\n}
\npublic String getFecha(){
\nreturn dateFormat.format(curDate);
\n}
\npublic String getHora(){
\nreturn dateFormat1.format(curDate);
\n}
\n}
\n**********************************************************************************************************************<\/p>\n","protected":false},"excerpt":{"rendered":"
********************************************************************************************************************** CLASE CITA ********************************************************************************************************************** package clases; import java.sql.*; import oracle.jdbc.*; import java.util.*; public class Cita{ public String id_Cita=\"\"; public String id_medico; public String id_paciente; public String fecha_cita; public String hora_cita; public String id_Consultorio; public int cont=0; public int nuevaCita(String nomPac,String apePac,String nomDoc,String apeDoc,String fechaCita,String horaCita){ bean b=new bean(); CallableStatement stm=null; cont++; try{ b.connect(); stm = […]<\/p>\n","protected":false},"author":165,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-55","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/pages\/55","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/users\/165"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/comments?post=55"}],"version-history":[{"count":6,"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/pages\/55\/revisions"}],"predecessor-version":[{"id":57,"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/pages\/55\/revisions\/57"}],"wp:attachment":[{"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/media?parent=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}