{"id":63,"date":"2009-03-01T19:33:16","date_gmt":"2009-03-01T23:33:16","guid":{"rendered":"http:\/\/blog.espol.edu.ec\/sccm\/?page_id=63"},"modified":"2009-03-01T20:12:02","modified_gmt":"2009-03-02T00:12:02","slug":"paginas-jsp","status":"publish","type":"page","link":"https:\/\/blog.espol.edu.ec\/sccm\/paginas-jsp\/","title":{"rendered":"Paginas jsp"},"content":{"rendered":"

\u00a0<\/p>\n

**********************************************************************************************************************<\/span><\/span><\/div>\n
PAGINA PRINCIPAL\/PAGINA DE INGRESO<\/span><\/span><\/div>\n
**********************************************************************************************************************<\/span><\/span><\/div>\n
\u00a0<\/span><\/div>\n
\u00a0<\/span><%--<\/span><\/span><\/div>\n
Document : index<\/span><\/span><\/div>\n
Created on : 06\/01\/2009, 06:01:19 PM<\/span><\/span><\/div>\n

\u00a0<\/p>\n

Author : cltsmalc<\/span><\/span><\/p>\n

\u00a0<\/p>\n

--%><\/span><\/span><\/div>\n

<jsp:useBean id=\"db\" scope=\"request\" class=\"clases.bean\"\/><\/p>\n

<jsp:setProperty name=\"db\" property=\"*\"\/><\/p>\n

<jsp:useBean id=\"cuenta\" scope=\"request\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-8\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

\u00a0<\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/div><\/p>\n

\u00a0<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"sidebar\"><\/p>\n

<div id=\"login\" class=\"boxed\"><\/p>\n

<h2 class=\"title\">Ingreso de usuarios<\/h2><\/p>\n

<div class=\"content\"><\/p>\n

<form method=\"post\" id=\"form1\" name=\"form1\" action=\"ingreso.jsp\"><\/p>\n

User:<br><input name=\"user\" type=\"text\"><br><\/p>\n

Password:<input name=\"pass\" type=\"password\"><br><\/p>\n

<%--<\/p>\n

String user, pass, cargo;<\/p>\n

user=request.getParameter(\"user\");<\/p>\n

pass=request.getParameter(\"password\");<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

--%><\/p>\n

<input id=\"login_button\" value=\"login\" type=\"submit\"><\/p>\n

\u00a0<\/p>\n

<\/form><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<\/p>\n

<div class=\"story\"><\/p>\n

<img src=\"images\/family.jpg\" alt=\"\" width=\"180\" height=\"160\" class=\"left\" \/><\/p>\n

<p><strong>Bienvenido<\/strong> <\/p><\/p>\n

<p>Ingresando al sistema ud podra acceder a las opciones del usuario, podra realizar las consultas permitidas asi como realizar las modificaciones pertinentes <\/p><\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/span><\/span><\/p>\n

\u00a0<\/p>\n

**********************************************************************************************************************<\/span><\/p>\n

PAGINA\u00a0VALIDA INGRESO<\/span><\/p>\n

**********************************************************************************************************************<\/span><\/p>\n

\u00a0\u00a0<%@page contentType=\"text\/html\"%><%@page pageEncoding=\"UTF-8\"%><\/span><\/span><\/span><\/p>\n

<\/div>\n

\u00a0<\/p>\n

<\/span><\/p>\n

\u00a0<\/p>\n

<\/span><\/span><\/div>\n

<\/p>\n

\u00a0<\/span><\/span><%@ page import=\"java.util.*\"%><\/span><\/p>\n
<\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/span><\/div>\n

<\/span>\u00a0<\/p>\n

<\/span><\/span><\/span><\/span><\/div>\n

\u00a0<\/p>\n

\u00a0<\/span><\/div>\n

\u00a0<\/p>\n

<\/span><%@ page import=\"java.sql.*\"%><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/span><\/span><%@ page import=\"javax.swing.*\"%><\/p>\n

\u00a0<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Personal\" scope=\"application\" class=\"clases.Personal\"\/><\/p>\n

<jsp:setProperty name=\"Personal\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

\u00a0<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html><\/p>\n

<head><\/p>\n

<meta http-equiv=\"Content-Type\" content=\"text\/html; charset=UTF-8\"><\/p>\n

<title>Pagina de ingreso al Sistema<\/title><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<h1>JSP Page<\/h1><\/p>\n

\u00a0<%<\/p>\n

HttpSession sesion_actual=request.getSession(true);<\/p>\n

sesion_actual.invalidate();<\/p>\n

%><\/p>\n

\u00a0<%<\/p>\n

\u00a0String user = request.getParameter(\"user\");<\/p>\n

String pass = request.getParameter(\"pass\");<\/p>\n

ArrayList y=Cuenta.consultarUsuario(user, pass);<\/p>\n

Cuenta.setUser(user);<\/p>\n

Cuenta.setPass(pass);<\/p>\n

\u00a0if(y.size()==0){<\/p>\n

JOptionPane.showMessageDialog(null, \"Ingreso del usuario y\/o password incorrectos\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

%><\/p>\n

<jsp:forward page=\"index.jsp\" \/><\/p>\n

<% }<\/p>\n

\u00a0<\/p>\n

String cedula=(String)y.get(0);<\/p>\n

String cargo=(String)y.get(1);<\/p>\n

\u00a0Cuenta.setCargo(cargo);<\/p>\n

Cuenta.setIdempleado(cedula);<\/p>\n

\u00a0if (Cuenta.getCargo().equals(\"Medico\")){<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Inicio Sesion\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

%><\/p>\n

<jsp:forward page=\"pMedico.jsp\" \/><\/p>\n

<% }<\/p>\n

else if(Cuenta.getCargo().equals(\"Secretaria\")){<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Inicio Sesion\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

<jsp:forward page=\"pSecretaria.jsp\" \/><\/p>\n

<%}<\/p>\n

else if(Cuenta.getCargo().equals(\"Farmaceutico\")){<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Inicio Sesion\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

%><\/p>\n

<jsp:forward page=\"pFarmaceutico.jsp\" \/><\/p>\n

\u00a0<\/p>\n

<%}<\/p>\n

else if(Cuenta.getCargo().equals(\"Administrador\")){<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Inicio Sesion\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

%><\/p>\n

<jsp:forward page=\"pAdministrador.jsp\" \/><\/p>\n

<%}<\/p>\n

else{<\/p>\n

JOptionPane.showMessageDialog(null, \"Ingreso del usuario y\/o password incorrectos\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

%><\/p>\n

<jsp:forward page=\"index.jsp\" \/><\/p>\n

<% }<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA\u00a0CREA CONEXION<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

\u00a0<%--Document : conectCreated on : 14-feb-2015, 16:43:37Author : root--%><\/p>\n
<\/span><\/span><\/div>\n

<\/span><\/span><\/div>\n

<\/p>\n

\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<HTML><\/p>\n

<HEAD><TITLE>Consultas por Atributos<\/TITLE><\/HEAD><\/p>\n

<BODY><\/p>\n

<%@ page language=\"Java\" import=\"java.sql.*\" %><\/p>\n

<jsp:useBean id=\"db\" scope=\"request\" class=\"clases.bean\" \/><\/p>\n

<%@ page import=\"java.util.ArrayList,clases.*\" %><\/p>\n

<jsp:setProperty name=\"db\" property=\"*\" \/><\/p>\n

\u00a0<%<\/p>\n

db.connect();<\/p>\n

\u00a0%><\/p>\n

<\/body><\/p>\n

<\/HTML><\/p>\n

\u00a0<\/p>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0<\/span><\/div>\n

\u00a0<\/p>\n

<\/span>***********************************************************************************************************************\u00a0<\/div>\n

<\/span><\/p>\n

<\/span><\/span><\/span><\/span><\/span>\u00a0<\/p>\n

<\/span><\/p>\n

PAGINA DEL ADMISTRADOR<\/div>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

<%--<\/span><\/p>\n

\u00a0Document : pAdministrador<\/span><\/p>\n

Created on : 14-feb-2015, 15:01:51<\/span><\/div>\n
Author : root<\/span><\/div>\n

\u00a0<\/p>\n

--%><\/span><\/p>\n

\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/div>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<jsp:useBean id=\"personal\" scope=\"application\" class=\"clases.Personal\"\/><\/p>\n

<jsp:setProperty name=\"personal\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<% personal.cont=0; %><\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"sidebar\"><\/p>\n

<div id=\"updates\" class=\"boxed\"><\/p>\n

<h2 class=\"title\">Opciones de Usuario<\/h2><\/p>\n

<div class=\"content\"><\/p>\n

<ul><\/p>\n

<li><\/p>\n

<p><a href=\"newPersonal.jsp\">Ingresar nuevo Personal <\/a><\/p><\/p>\n

<\/li><\/p>\n

<li><\/p>\n

<p><a href=\"tbConsultas.jsp\">Consultar Tablas<\/a><\/p><\/p>\n

<\/li><\/p>\n

\u00a0<li><\/p>\n

<p><a href=\"cierrasesion.jsp\">Cerrar Sesion<\/a><\/p><\/p>\n

<\/li><\/p>\n

\u00a0<\/ul><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

\u00a0<\/div><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

<div class=\"story\"><\/p>\n

<p><strong>Bienvenido <%=Cuenta.getUser()%><\/strong> <\/p><\/p>\n

<p>A la derecha encontrara las opciones que puede realizar<\/p><\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Mo<\/p>\n

ntalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA DEL FARMACEUTICO<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<%--<\/span><\/p>\n

\u00a0Document : pAdministrador<\/span><\/p>\n

Created on : 14-feb-2015, 15:01:51<\/span><\/div>\n
Author : root<\/span><\/div>\n

\u00a0<\/p>\n

--%><\/span><\/p>\n

\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/div>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"medicina\" scope=\"application\" class=\"clases.Medicina\"\/><\/p>\n

<jsp:setProperty name=\"medicina\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<% medicina.cont=0; %><\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/div><\/p>\n

\u00a0<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"sidebar\"><\/p>\n

\u00a0<div id=\"updates\" class=\"boxed\"><\/p>\n

<h2 class=\"title\">Opciones de Usuario<\/h2><\/p>\n

<div class=\"content\"><\/p>\n

<ul><\/p>\n

<li><\/p>\n

<p><a href=\"tbMedicinaF.jsp\">Consultar Medicina <\/a><\/p><\/p>\n

<\/li><\/p>\n

\u00a0\u00a0<li><\/p>\n

<p><a href=\"newMedicina.jsp\">Ingresar Medicina<\/a><\/p><\/p>\n

<\/li><\/p>\n

<li><\/p>\n

<p><a href=\"cierrasesion.jsp\">Cerrar Sesion<\/a><\/p><\/p>\n

<\/li><\/p>\n

\u00a0<\/ul><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

\u00a0<\/div><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

<div class=\"story\"><\/p>\n

<p><strong>Bienvenido <%=Cuenta.getUser()%><\/strong> <\/p><\/p>\n

<img src=\"images\/farm.gif\" alt=\"\" width=\"110\" height=\"120\" class=\"left\" \/><\/p>\n

<p>A la derecha encontrara las opciones que puede realizar<\/p><\/p>\n

\u00a0<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

\u00a0<\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA DEL MEDICO<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

\u00a0<%--<\/span><\/p>\n

\u00a0Document : pAdministrador<\/span><\/p>\n

Created on : 14-feb-2015, 15:01:51<\/span><\/div>\n
Author : root<\/span><\/div>\n

\u00a0<\/p>\n

--%><\/span><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/div>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<jsp:useBean id=\"hc\" scope=\"application\" class=\"clases.HistoriaClinica\"\/><\/p>\n

<jsp:setProperty name=\"hc\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"medicina\" scope=\"application\" class=\"clases.Medicina\"\/><\/p>\n

<jsp:setProperty name=\"medicina\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"personal\" scope=\"application\" class=\"clases.Personal\"\/><\/p>\n

<jsp:setProperty name=\"personal\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

<% hc.cont=0; %><\/p>\n

<% medicina.cont=0;%><\/p>\n

<\/div><\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"sidebar\"><\/p>\n

\u00a0<div id=\"updates\" class=\"boxed\"><\/p>\n

<h2 class=\"title\">Opciones de Usuario<\/h2><\/p>\n

<div class=\"content\"><\/p>\n

<ul><\/p>\n

<li><\/p>\n

<p><a href=\"newHC.jsp\">Crear Historia Clinica <\/a><\/p><\/p>\n

<\/li><\/p>\n

\u00a0<li><\/p>\n

<p><a href=\"tbHC.jsp\">Consultar Historia Clinica<\/a><\/p><\/p>\n

<\/li><\/p>\n

\u00a0<li><\/p>\n

<p><a href=\"tbMedicinaF.jsp\">Consultar Medicinas<\/a><\/p><\/p>\n

<\/li><\/p>\n

\u00a0<li><\/p>\n

<p><a href=\"tbDoctores.jsp\">Consultar otros Doctores<\/a><\/p><\/p>\n

<\/li><\/p>\n

<li><\/p>\n

<p><a href=\"cierrasesion.jsp\" >Cerrar Sesion<\/a><\/p><\/p>\n

<\/li><\/p>\n

\u00a0<\/ul><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

\u00a0<\/div><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

<div class=\"story\"><\/p>\n

<p><strong>Bienvenido\/a <%=Cuenta.getUser()%> <\/strong> <\/p><\/p>\n

\u00a0<\/p>\n

<img src=\"images\/medico.gif\" alt=\"\" width=\"110\" height=\"120\" class=\"left\" \/><\/p>\n

<p>En el menu de la derecha encontrara las opciones que puede realizar<\/p><\/p>\n

\u00a0<\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA DE LA SECRETARIA<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/span><\/div>\n

\u00a0<\/p>\n

<\/span><\/span>\u00a0<\/p>\n

<%--<\/span><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

Document : pSecretaria<\/span><\/p>\n

Created on : 14-feb-2015, 15:01:51<\/span><\/div>\n
Author : root<\/span><\/div>\n

\u00a0<\/p>\n

--%><\/span><\/p>\n

\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/div>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<jsp:useBean id=\"cita\" scope=\"application\" class=\"clases.Cita\"\/><\/p>\n

<jsp:setProperty name=\"cita\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"paciente\" scope=\"application\" class=\"clases.Paciente\"\/><\/p>\n

<jsp:setProperty name=\"paciente\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

<\/div><\/p>\n

<% cita.cont=0;<\/p>\n

paciente.cont=0;<\/p>\n

%><\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"sidebar\"><\/p>\n

<div id=\"updates\" class=\"boxed\"><\/p>\n

<h2 class=\"title\">Opciones de Usuario<\/h2><\/p>\n

<div class=\"content\"><\/p>\n

<ul><\/p>\n

<%--<li><\/p>\n

<p><a href=\"newPago.jsp\">Registrar Pago <\/a><\/p><\/p>\n

<\/li>--%><\/p>\n

<li><\/p>\n

<p><a href=\"newPaciente.jsp\">Ingresar Nuevo Paciente<\/a><\/p><\/p>\n

<\/li><\/p>\n

<li><\/p>\n

<p><a href=\"tbPaciente.jsp\">Consultar Pacientes<\/a><\/p><\/p>\n

<\/li><\/p>\n

<li><\/p>\n

<p><a href=\"newCita.jsp\">Crear Cita<\/a><\/p><\/p>\n

<\/li><\/p>\n

<li><\/p>\n

<p><a href=\"deleteCita.jsp\">Cancelar Cita<\/a><\/p><\/p>\n

<\/li><\/p>\n

<li><\/p>\n

<p><a href=\"tbDoctores.jsp\">Consultar Medicos<\/a><\/p><\/p>\n

<\/li><\/p>\n

<li><\/p>\n

<p><a href=\"cierrasesion.jsp\">Cerrar Sesion<\/a><\/p><\/p>\n

<\/li><\/p>\n

<\/ul><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

<div class=\"story\"><\/p>\n

<p><strong>Bienvenida <%=Cuenta.getUser()%><\/strong> <\/p><\/p>\n

<img src=\"images\/secre.gif\" alt=\"\" width=\"110\" height=\"120\" class=\"left\" \/><\/p>\n

<p>En el menu de la derecha encontrara las opciones que puede realizar<\/p><\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

\u00a0<\/p>\n

<\/html><\/p>\n

***********************************************************************************************************************<\/p>\n

PAGINA DE CONSULTAS<\/p>\n

***********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

\u00a0<\/span><\/div>\n

\u00a0<\/p>\n

<\/span><\/span><%--<\/span><\/p>\n

\u00a0<\/p>\n

Document : tbConsultas<\/span><\/p>\n

Created on : 14-feb-2015, 15:01:51<\/span><\/div>\n
Author : root<\/span><\/div>\n

\u00a0<\/p>\n

--%><\/span><\/p>\n

\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/div>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<%@ page import=\"java.util.ArrayList, clases.*\" %><\/p>\n

<%@ page language=\"Java\" import=\"java.sql.*\" %><\/p>\n

<jsp:useBean id=\"medicina\" scope=\"application\" class=\"clases.Medicina\"\/><\/p>\n

<jsp:setProperty name=\"medicina\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"personal\" scope=\"application\" class=\"clases.Personal\"\/><\/p>\n

<jsp:setProperty name=\"personal\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"paciente\" scope=\"application\" class=\"clases.Paciente\"\/><\/p>\n

<jsp:setProperty name=\"paciente\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"hc\" scope=\"application\" class=\"clases.HistoriaClinica\"\/><\/p>\n

<jsp:setProperty name=\"hc\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"cita\" scope=\"application\" class=\"clases.Cita\"\/><\/p>\n

<jsp:setProperty name=\"cita\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

<\/div><\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

<div class=\"story\"><\/p>\n

<h2 align=\"center\" class=\"tabla\">Seleccione la Tabla que desea consultar<\/h2><\/p>\n

<form id='boton' method='post'><\/p>\n

<table border=2 align=\"center\" cellpadding=\"2\" cellspacing=\"2\"<\/p>\n

face=\"Gergia\" width=\"85%\" ><\/p>\n

<tr><\/p>\n

<td>Tabla:<\/td><td><select name=\"op\"><option>Historial<\/option><option>Personal<\/option> <option>Paciente<\/option> <option>Cita<\/option> <option>Historia Clinica<\/option><option>Medicina<\/option> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

<\/table><\/p>\n

<br><br><\/p>\n

<input id=\"Buscar_button\" value=\"Buscar\" type=\"submit\" ><\/br><\/br><\/p>\n

<%<\/p>\n

if(personal.cont > 1){<\/p>\n

String op = request.getParameter(\"op\");<\/p>\n

String s;<\/p>\n

if(op.equals(\"Paciente\")){<\/p>\n

s=paciente.tbPaciente();<\/p>\n

out.println(s);<\/p>\n

}<\/p>\n

if(op.equals(\"Personal\")){<\/p>\n

s=personal.consultaPersonal();<\/p>\n

out.println(s);<\/p>\n

}<\/p>\n

if(op.equals(\"Cita\")){<\/p>\n

s=cita.consultarCitas();<\/p>\n

out.println(s);<\/p>\n

}<\/p>\n

if(op.equals(\"Historia Clinica\")){<\/p>\n

s=hc.consultaHC();<\/p>\n

out.println(s);<\/p>\n

}<\/p>\n

if(op.equals(\"Medicina\")){<\/p>\n

s=medicina.consultaMedicina();<\/p>\n

out.println(s);<\/p>\n

}<\/p>\n

if(op.equals(\"Historial\")){<\/p>\n

s = Historial.consultar();<\/p>\n

out.println(s);<\/p>\n

}<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Consulto la tabla:\"+op+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

\u00a0}else{personal.cont=2;}<\/p>\n

\u00a0%><\/p>\n

<\/form><\/p>\n

<br><br><\/p>\n

<form id='Regresar' action='pAdministrador.jsp' method='post'><\/p>\n

<input id=\"Regresar\" value=\"Regresar\" type=\"submit\"><\/p>\n

\u00a0<\/form><\/p>\n

\u00a0<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA CONSULTA DOCTORES<\/p>\n

**********************************************************************************************************************<\/p>\n

<%--<\/span><\/p>\n

Document : tbDoctores<\/span><\/p>\n

Created on : 14-feb-2015, 15:01:51<\/span><\/div>\n
Author : root<\/span><\/div>\n

\u00a0<\/p>\n

--%><\/span><\/p>\n

\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/div>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<%@ page import=\"java.util.ArrayList, clases.*\" %><\/p>\n

<%@ page language=\"Java\" import=\"java.sql.*\" %><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"personal\" scope=\"application\" class=\"clases.Personal\"\/><\/p>\n

<jsp:setProperty name=\"personal\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitionaneral\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

<\/div><\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<\/p>\n

<div class=\"story\"><\/p>\n

<h1 align=\"center\" class=\"tabla\">DOCTORES<\/h1><\/p>\n

<%<\/p>\n

String s = personal.consultaDoc();<\/p>\n

out.println(s);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Consulto la tabla Personal (Medicos)\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

if(Cuenta.getCargo().equals(\"Secretaria\")){<\/p>\n

%><\/p>\n

<form id='Regresar' action='pSecretaria.jsp' method= 'post'><\/p>\n

<input id=\"Regresar\" value=\"Regresar\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<% }else{%><\/p>\n

<form id='Regresar' action='pMedico.jsp' method= 'post'><\/p>\n

<input id=\"Regresar\" value=\"Regresar\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<%}%><\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

**********************************************************************************************************************<\/span><\/div>\n
PAGINA CONSULTA HISTORIAS CLINICAS<\/span><\/div>\n
**********************************************************************************************************************<\/span><\/div>\n

\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/span><\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/p>\n

<%@ page import=\"java.util.ArrayList, clases.*\" %><\/span><\/div>\n
<%@ page language=\"Java\" import=\"java.sql.*\" %><\/span><\/div>\n

\u00a0<\/p>\n

<jsp:useBean id=\"hc\" scope=\"application\" class=\"clases.HistoriaClinica\"\/><jsp:setProperty name=\"hc\" property=\"*\" \/><\/span><\/div>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

<\/div><\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

<%<\/p>\n

ArrayList pac= hc.nomHC();<\/p>\n

%><\/p>\n

<div class=\"story\"><\/p>\n

<h1 align=\"center\" class=\"tabla\">Seleccione los datos del Paciente que desea buscar<\/h1><\/p>\n

<form method='post'><\/p>\n

<table border=2 align=\"center\" cellpadding=\"2\" cellspacing=\"2\"<\/p>\n

face=\"Gergia\" width=\"85%\"><\/p>\n

<tr><\/p>\n

<td>Nombre del Paciente:<\/td><td><select name=\"pac\"><% for (int k=0; k<pac.size()\/2; k++){ %><option><%=(String)pac.get(2*k) + \" \" + (String)pac.get(2*k+1)%><\/option> <% } %> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

<\/table><\/p>\n

<br><br><\/p>\n

\u00a0<\/p>\n

<input id=\"Buscar_button\" value=\"Buscar\" type=\"submit\" ><\/br><\/br><\/p>\n

<%<\/p>\n

if(hc.cont >1){<\/p>\n

String nombre=request.getParameter(\"pac\");<\/p>\n

String nompac[] = nombre.split(\" \");<\/p>\n

String s=hc.consultarHC(nompac[0],nompac[1]);<\/p>\n

if(!s.equals(null))<\/p>\n

out.println(s);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Consulto la Historia Clinica de:\"+nompac[0]+\" \"+nompac[1]+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

}<\/p>\n

else{<\/p>\n

hc.cont=2;<\/p>\n

}<\/p>\n

%><\/p>\n

<\/form><\/p>\n

<form id='Regresar' action='pMedico.jsp' method='post'><\/p>\n

<br><br><br><input id=\"Regresar\" value=\"Regresar\" type=\"submit\"><\/br><\/br><\/br><\/p>\n

<\/form><\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

*********************************************************************************************************************<\/p>\n

PAGINA CONSULTA MEDICINAS<\/p>\n

**********************************************************************************************************************<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n
<%@ page import=\"java.util.ArrayList, clases.*\" %><\/span><\/div>\n

\u00a0<\/p>\n

<%@ page language=\"Java\" import=\"java.sql.*\" %><\/span><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"medicina\" scope=\"application\" class=\"clases.Medicina\"\/><\/span><\/div>\n

<jsp:setProperty name=\"medicina\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

\u00a0<\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<div class=\"story\"><\/p>\n

\u00a0<h2 align=\"center\" class=\"tabla\">Seleccione el Campo por el que desea buscar<\/h2><\/p>\n

\u00a0<form id='boton' method='post'><\/p>\n

<br> <\/br><\/p>\n

<table border=2 align=\"center\" cellpadding=\"2\" cellspacing=\"2\"<\/p>\n

face=\"Gergia\" width=\"85%\" ><\/p>\n

\u00a0<tr><\/p>\n

<td>Campo:<\/td><td><select name=\"op\"><option>Nombre<\/option> <option>Tipo<\/option> <option>Lab Farmaceutico<\/option> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

\u00a0<%<\/p>\n

if(medicina.cont > 1){<\/p>\n

String nombre,tipo,lab;<\/p>\n

String op = null;<\/p>\n

op = request.getParameter(\"op\");<\/p>\n

medicina.tmp = op;<\/p>\n

\u00a0<\/p>\n

if(op.equals(\"Nombre\")){<\/p>\n

\u00a0<\/p>\n

ArrayList name= medicina.nombreMedicinas();<\/p>\n

\u00a0\u00a0%><\/p>\n

<tr><\/p>\n

<td>Nombre:<\/td><td><select name=\"name\"> <% for (int k=0; k<name.size(); k++){ %><option><%=(String)name.get(k)%><\/option> <% } %> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

\u00a0<br><br><\/p>\n

<%<\/p>\n

String s;<\/p>\n

nombre=request.getParameter(\"name\");<\/p>\n

if(Cuenta.getCargo().equals(\"Farmaceutico\")){<\/p>\n

s=medicina.consultaxNombre(nombre,1);}<\/p>\n

else{s=medicina.consultaxNombre(nombre,0);}<\/p>\n

out.println(s);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Consulto la medicina:\"+nombre+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

\u00a0<\/p>\n

}<\/p>\n

\u00a0<\/p>\n

if(op.equals(\"Tipo\")){<\/p>\n

ArrayList tip= medicina.tipoMedicinas();<\/p>\n

\u00a0%><\/p>\n

<tr><\/p>\n

<td>Tipo:<\/td><td><select name=\"tipo\"> <% for (int k=0; k<tip.size(); k++){ %><option><%=(String)tip.get(k)%><\/option> <% } %> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

\u00a0<%<\/p>\n

String s;<\/p>\n

tipo=request.getParameter(\"tipo\");<\/p>\n

if(Cuenta.getCargo().equals(\"Farmaceutico\")){<\/p>\n

s=medicina.consultaxTipo(tipo,1);}<\/p>\n

else{ s=medicina.consultaxTipo(tipo,0);}<\/p>\n

out.println(s);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Consulto las medicinas del tipo:\"+tipo+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

\u00a0<\/p>\n

}<\/p>\n

if(op.equals(\"Lab Farmaceutico\")){<\/p>\n

ArrayList labf= medicina.labMedicinas();<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

<tr><\/p>\n

<td>Laboratorio Farmaceutico:<\/td><td><select name=\"lab\"> <% for (int k=0; k<labf.size(); k++){ %><option><%=(String)labf.get(k)%><\/option> <% } %> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

<%<\/p>\n

String s;<\/p>\n

lab=request.getParameter(\"lab\");<\/p>\n

if(Cuenta.getCargo().equals(\"Farmaceutico\")){<\/p>\n

s=medicina.consultaxLab(lab,1);}<\/p>\n

else{s=medicina.consultaxLab(lab,0);}<\/p>\n

out.println(s);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Consulto las medicinas del Laboratorio:\"+lab+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

\u00a0<\/p>\n

}<\/p>\n

}else{medicina.cont=2;}<\/p>\n

\u00a0%><\/p>\n

<\/table><\/p>\n

<br><\/p>\n

<input id=\"Buscar_button\" value=\"Buscar\" type=\"submit\" >&nbsp <\/form><\/p>\n

<%<\/p>\n

if(Cuenta.getCargo().equals(\"Farmaceutico\")){<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

<form id='Regresar' action='pFarmaceutico.jsp' method= 'post'><\/p>\n

<input id=\"Regresar\" value=\"Regresar\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<% }else{%><\/p>\n

<form id='Regresar' action='pMedico.jsp' method= 'post'><\/p>\n

<input id=\"Regresar\" value=\"Regresar\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<%}%><\/p>\n

\u00a0<\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

\u00a0**********************************************************************************************************************<\/p>\n

PAGINA CONSULTA PACIENTES<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n
<%@ page import=\"java.util.ArrayList, clases.*\" %><\/span><\/div>\n

\u00a0<\/p>\n

<%@ page language=\"Java\" import=\"java.sql.*\" %><\/span><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"paciente\" scope=\"application\" class=\"clases.Paciente\"\/><\/span><\/div>\n

<jsp:setProperty name=\"paciente\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<% ArrayList pac= paciente.consultanomPaciente();<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<\/p>\n

<div class=\"story\"><\/p>\n

\u00a0<\/p>\n

<h1 align=\"center\" class=\"tabla\">Ingrese los datos del Paciente<\/h1><\/p>\n

\u00a0<\/p>\n

<form method='post'><\/p>\n

<table border=2 align=\"center\" cellpadding=\"2\" cellspacing=\"2\"<\/p>\n

face=\"Gergia\" width=\"85%\"><\/p>\n

<tr><\/p>\n

<td>Nombre del Paciente:<\/td><td><select name=\"pac\"> <% for (int k=0; k<pac.size()\/2; k++){ %><option><%=(String)pac.get(2*k) + \" \" + (String)pac.get(2*k+1)%><\/option> <% } %> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

<\/table><\/p>\n

<br><br><\/p>\n

<input id=\"Buscar_button\" value=\"Buscar\" type=\"submit\" ><\/br><\/br><\/p>\n

\u00a0<\/p>\n

<%<\/p>\n

if(paciente.cont >1){<\/p>\n

String nombre=request.getParameter(\"pac\");<\/p>\n

String nompac[] = nombre.split(\" \");<\/p>\n

String s=paciente.consultaPaciente(nompac[0],nompac[1]);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Consulto los datos del Paciente:\"+nompac[0]+\",\"+nompac[1]+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

out.println(s);<\/p>\n

\u00a0<\/p>\n

}<\/p>\n

else{<\/p>\n

paciente.cont=2;<\/p>\n

}<\/p>\n

%><\/p>\n

<\/form><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<form id='Regresar' action='pSecretaria.jsp' method='post'><\/p>\n

<input id=\"Regresar\" value=\"Regresar\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

\u00a0\u00a0<\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

\u00a0<\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA CONSULTA PERSONAL<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n
<%@ page import=\"java.util.ArrayList, clases.*\" %><\/span><\/div>\n

\u00a0<\/p>\n

<%@ page language=\"Java\" import=\"java.sql.*\" %><\/span><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"personal\" scope=\"application\" class=\"clases.Personal\"\/><\/span><\/div>\n

<jsp:setProperty name=\"personal\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

<%personal.cont=0;%><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

\u00a0<\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<div class=\"story\"><\/p>\n

<h1 align=\"center\" class=\"tabla\">Personal del Centro Medico<\/h1><\/p>\n

<%<\/p>\n

String s = personal.consultaPersonal();<\/p>\n

out.println(s);<\/p>\n

\/\/Historial.registrarHistorial(Cuenta.getIdempleado(),\"Consulto la tabla personalmedicina:\"+nombre+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

<form id='Regresar' action='pAdministrador.jsp' method='post'><\/p>\n

<input id=\"Regresar\" value=\"Regresar\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

\u00a0<\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

\u00a0**********************************************************************************************************************<\/p>\n

PAGINA CREA CITA<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n
<%@ page import=\"javax.swing.*\"%><\/span><\/div>\n

\u00a0<\/p>\n

<%@ page import=\"java.util.*\"%><\/span><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"cita\" scope=\"application\" class=\"clases.Cita\"\/><\/span><\/div>\n

<jsp:setProperty name=\"cita\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"paciente\" scope=\"application\" class=\"clases.Paciente\"\/><\/p>\n

<jsp:setProperty name=\"paciente\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"personal\" scope=\"application\" class=\"clases.Personal\"\/><\/p>\n

<jsp:setProperty name=\"personal\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<link rel=\"stylesheet\" type=\"text\/css\" media=\"all\" href=\"calendar-blue.css\" title=\"win2k-cold-1\" \/><\/p>\n

<script type=\"text\/javascript\" src=\"calendar.js\"><\/script><\/p>\n

<script type=\"text\/javascript\" src=\"calendar-es.js\"><\/script><\/p>\n

<script type=\"text\/javascript\" src=\"calendar-setup.js\"><\/script><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

<% ArrayList pac= paciente.consultanomPaciente();<\/p>\n

ArrayList per= personal.consultanomPersonal();<\/p>\n

%><\/p>\n

<div class=\"story\"><\/p>\n

<h1 align=\"center\" class=\"title\"><strong>Ingrese los Datos de la nueva Cita<\/strong><\/h1><br><\/p>\n

<form method='post'><\/p>\n

<table border=2 align=\"center\" cellpadding=\"2\" cellspacing=\"2\"<\/p>\n

face=\"Gergia\" width=\"85%\" ><\/p>\n

<tr><\/p>\n

<td>Nombre del Paciente:<\/td><td><select name=\"pac\"><% for (int k=0; k<pac.size()\/2; k++){ %><option><%=(String)pac.get(2*k) + \" \" + (String)pac.get(2*k+1)%><\/option> <% } %> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Nombre del Doctor:<\/td><td><select name=\"doc\"><% for (int i=0; i<per.size()\/2; i++){ %><option><%=(String)per.get(2*i) + \" \" + (String)per.get(2*i+1)%><\/option> <% } %> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

\u00a0<\/p>\n

<tr><\/p>\n

<td>Fecha:(dd\/mm\/yy)<\/td><td><\/p>\n

<!-- formulario con el campo de texto y el bot\u00c3\u00b3n para lanzar el calendario--><\/p>\n

<form action=\"#\" method=\"get\"><\/p>\n

<input type=\"text\" name=\"date\" id=\"campo_fecha\" \/><\/p>\n

<input type=\"button\" id=\"lanzador\" value=\"...\" \/><\/p>\n

<\/form><\/p>\n

<!-- script que define y configura el calendario--><\/p>\n

<script type=\"text\/javascript\"><\/p>\n

Calendar.setup({<\/p>\n

inputField : \"campo_fecha\", \/\/ id del campo de texto<\/p>\n

ifFormat : \"%d\/%m\/%Y\", \/\/ formato de la fecha que se escriba en el campo de texto<\/p>\n

button : \"lanzador\" \/\/ el id del bot\u00c3\u00b3n que lanzar\u00c3\u00a1 el calendario<\/p>\n

});<\/p>\n

<\/script><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Hora:<\/td><td><select name=\"hora\"> <% for ( int j=8; j<=20; j++){ %><option><%=j%><\/option><% } %> <\/select> h:00<\/td><\/p>\n

<\/tr><\/p>\n

<\/table><\/p>\n

<br><br><\/p>\n

\u00a0<\/p>\n

<input id=\"Guardar_button\" value=\"Guardar\" type=\"submit\" ><\/p>\n

<%<\/p>\n

if(cita.cont>1){<\/p>\n

String nombre_Pac,nombre_Doc,hora,fecha;<\/p>\n

String arregloPac[];<\/p>\n

String arregloDoc[];<\/p>\n

nombre_Pac=request.getParameter(\"pac\");<\/p>\n

hora = request.getParameter(\"hora\") + \":00\";<\/p>\n

nombre_Doc = request.getParameter(\"doc\");<\/p>\n

arregloPac = nombre_Pac.split(\" \");<\/p>\n

arregloDoc = nombre_Doc.split(\" \");<\/p>\n

fecha = request.getParameter(\"date\");<\/p>\n

int resultado = cita.nuevaCita(arregloPac[0],arregloPac[1],arregloDoc[0],arregloDoc[1],fecha,hora);<\/p>\n

if (resultado == 1){<\/p>\n

JOptionPane.showMessageDialog(null, \"Cita creada exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Ingreso una Cita con los datos:\"+arregloPac[0]+\",\"+arregloPac[1]+\",\"+arregloDoc[0]+\",\"+arregloDoc[1]+\",\"+fecha+\",\"+hora+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

response.sendRedirect(\"pSecretaria.jsp\");<\/p>\n

}<\/p>\n

else{<\/p>\n

JOptionPane.showMessageDialog(null, \"Cita no fue creada exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

}<\/p>\n

}else{cita.cont=2;}<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/form><\/p>\n

<form id='Regresar' action='pSecretaria.jsp' method='post'><\/p>\n

<input id=\"Regresar_button\" value=\"Regresar\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

\u00a0**********************************************************************************************************************<\/p>\n

PAGINA CREA HISTORIA CLINICA<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n
<%@ page import=\"javax.swing.*\"%><\/span><\/div>\n

\u00a0<\/p>\n

<%@ page import=\"java.util.*\"%><\/span><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"hc\" scope=\"application\" class=\"clases.HistoriaClinica\"\/><\/span><\/div>\n

<jsp:setProperty name=\"hc\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"paciente\" scope=\"application\" class=\"clases.Paciente\"\/><\/p>\n

<jsp:setProperty name=\"paciente\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<%<\/p>\n

ArrayList ced= paciente.consultacedPaciente();<\/p>\n

if(ced.size()==0){<\/p>\n

JOptionPane.showMessageDialog(null, \"Todos los pacientes ya tienen una Historia Clinica creada\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

response.sendRedirect(\"pMedico.jsp\");<\/p>\n

}<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<\/p>\n

<div class=\"story\"><\/p>\n

<h1 align=\"center\" class=\"title\"><strong>Ingrese los Datos de la Nueva Historia Clinica<\/strong><\/h1><br><\/p>\n

<form method='post'><\/p>\n

<table border=2 align=\"center\" cellpadding=\"2\" cellspacing=\"2\"<\/p>\n

face=\"Gergia\" width=\"85%\" ><\/p>\n

<tr><\/p>\n

<td>Cedula del Paciente:<\/td><td><select name=\"ced\"> <% for (int k=0; k<ced.size(); k++){ %><option><%=(String)ced.get(k)%><\/option> <% } %> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Tipo de Sangre:<\/td><td><select name=\"tSangre\"><\/p>\n

<option>A+<\/option><\/p>\n

<option>A-<\/option><\/p>\n

<option>B+<\/option><\/p>\n

<option>B-<\/option><\/p>\n

<option>AB+<\/option><\/p>\n

<option>AB-<\/option><\/p>\n

<option>O+<\/option><\/p>\n

<option>O-<\/option><\/p>\n

<\/select><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Peso:<\/td><td><input name=\"peso\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Altura:<\/td><td><input name=\"altura\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Riesgo:<\/td><td><input name=\"riesgo\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Antecedente:<\/td><td><input name=\"antec\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Motivo Consulta:<\/td><td><input name=\"motivo\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<\/table><\/p>\n

<br><br><\/p>\n

\u00a0<\/p>\n

<input id=\"Guardar_button\" value=\"Guardar\" type=\"submit\" ><\/p>\n

<%<\/p>\n

\u00a0<\/p>\n

if (hc.cont > 1){<\/p>\n

String cedPac,tipoSangre,peso,altura,riesgo,antec,motivo;<\/p>\n

cedPac=request.getParameter(\"ced\");<\/p>\n

tipoSangre =request.getParameter(\"tSangre\");<\/p>\n

peso =request.getParameter(\"peso\");<\/p>\n

altura =request.getParameter(\"altura\");<\/p>\n

riesgo =request.getParameter(\"riesgo\");<\/p>\n

antec = request.getParameter(\"antec\");<\/p>\n

motivo = request.getParameter(\"motivo\");<\/p>\n

int resultado=hc.nuevaHistoriaClinica(cedPac,tipoSangre,peso,altura,riesgo,antec,motivo);<\/p>\n

if (resultado == 1){<\/p>\n

JOptionPane.showMessageDialog(null, \"Historia Clinica ingresada exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Ingreso una nueva Historia Clinica con los datos: \"+tipoSangre+\",\"+peso+\",\"+altura+\",\"+riesgo+\",\"+antec+\",\"+motivo+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

hc.cont=0;<\/p>\n

response.sendRedirect(\"pMedico.jsp\");<\/p>\n

}<\/p>\n

else{<\/p>\n

JOptionPane.showMessageDialog(null, \"Historia Clinica no fue ingresada exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

}<\/p>\n

}else{hc.cont=2;}<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/form><\/p>\n

<form id='Regresar' action='pMedico.jsp' method='post'><\/p>\n

<input id=\"Regresar_button\" value=\"Regresar\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA CREA\u00a0MEDICINA<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n
<%@ page import=\"Sesion.Persona\" %><\/span><\/div>\n

\u00a0<\/p>\n

<%@ page import=\"javax.swing.*\"%><\/span><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"medicina\" scope=\"application\" class=\"clases.Medicina\"\/><\/span><\/div>\n

<jsp:setProperty name=\"medicina\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<link rel=\"stylesheet\" type=\"text\/css\" media=\"all\" href=\"calendar-blue.css\" title=\"win2k-cold-1\" \/><\/p>\n

<script type=\"text\/javascript\" src=\"calendar.js\"><\/script><\/p>\n

<script type=\"text\/javascript\" src=\"calendar-es.js\"><\/script><\/p>\n

<script type=\"text\/javascript\" src=\"calendar-setup.js\"><\/script><\/p>\n

\u00a0<\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<\/p>\n

<div class=\"story\"><\/p>\n

<h1 align=\"center\" class=\"title\"><strong>Ingrese los Datos de la nueva Medicina<\/strong><\/h1><br><\/p>\n

<form id='boton' method='post'><\/p>\n

\u00a0<\/p>\n

<table border=2 align=\"center\" cellpadding=\"2\" cellspacing=\"2\"<\/p>\n

face=\"Gergia\" width=\"85%\" ><\/p>\n

<tr><\/p>\n

<td>Farmacia No:<\/td><td><select name=\"Farmacia\"><option>1<\/option> <option>2<\/option> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Nombre:<\/td><td><input name=\"name\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Tipo:<\/td><td><input name=\"tipo\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Lab Farmaceutico:<\/td><td><input name=\"lab\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Fecha de caducidad:(dd\/mm\/yy)<\/td><td><\/p>\n

\u00a0<\/p>\n

<!-- formulario con el campo de texto y el bot\u00c3\u00b3n para lanzar el calendario--><\/p>\n

<form action=\"#\" method=\"get\"><\/p>\n

<input type=\"text\" name=\"date\" id=\"campo_fecha\" \/><\/p>\n

<input type=\"button\" id=\"lanzador\" value=\"...\" \/><\/p>\n

<\/form><\/p>\n

<!-- script que define y configura el calendario--><\/p>\n

<script type=\"text\/javascript\"><\/p>\n

Calendar.setup({<\/p>\n

inputField : \"campo_fecha\", \/\/ id del campo de texto<\/p>\n

ifFormat : \"%d\/%m\/%Y\", \/\/ formato de la fecha que se escriba en el campo de texto<\/p>\n

button : \"lanzador\" \/\/ el id del bot\u00c3\u00b3n que lanzar\u00c3\u00a1 el calendario<\/p>\n

});<\/p>\n

<\/script><\/p>\n

<\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Stock:<\/td><td><input name=\"stock\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<\/table><\/p>\n

<br><br><\/p>\n

<input id=\"Guardar_button\" name=\"Guardar_but\" value=\"Guardar\" type=\"submit\"><\/p>\n

<%<\/p>\n

if (medicina.cont > 1){<\/p>\n

String farmacia, nombre, tipo, lab, fecha, stock;<\/p>\n

farmacia=request.getParameter(\"Farmacia\");<\/p>\n

nombre=request.getParameter(\"name\");<\/p>\n

tipo=request.getParameter(\"tipo\");<\/p>\n

stock = request.getParameter(\"stock\");<\/p>\n

fecha = request.getParameter(\"date\");<\/p>\n

lab = request.getParameter(\"lab\");<\/p>\n

\u00a0<\/p>\n

int resultado = medicina.ingresarMedicina(nombre,farmacia,tipo,lab,fecha,stock);<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

if (resultado == 1){<\/p>\n

JOptionPane.showMessageDialog(null, \"Medicina ingresada exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Ingreso una Cita con los datos:\"+nombre+\",\"+farmacia+\",\"+tipo+\",\"+lab+\",\"+fecha+\",\"+stock+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

medicina.cont++;<\/p>\n

response.sendRedirect(\"pFarmaceutico.jsp\");<\/p>\n

}<\/p>\n

else{<\/p>\n

JOptionPane.showMessageDialog(null, \"Medicina no fue ingresada exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

\u00a0<\/p>\n

}<\/p>\n

}else{medicina.cont=2;}<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\/\/ response.sendRedirect(\"newMedicina.jsp\");<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

<\/form><\/p>\n

\u00a0<\/p>\n

<br><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<form id='regresar' action='pFarmaceutico.jsp' method='post'><\/p>\n

\u00a0<\/p>\n

<input id=\"Regresar_button\" value=\"<-- Regresar al menu principal\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<br><\/p>\n

\u00a0<\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

\u00a0*********************************************************************************************************************<\/p>\n

PAGINA CREA\u00a0PACIENTE<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n
<%@ page import=\"javax.swing.*\"%><\/span><\/div>\n

\u00a0<\/p>\n

<jsp:useBean id=\"paciente\" scope=\"application\" class=\"clases.Paciente\"\/><\/span><\/p>\n

\u00a0<\/p>\n

<jsp:setProperty name=\"paciente\" property=\"*\" \/><\/span><\/div>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<\/p>\n

<div class=\"story\"><\/p>\n

<h1 align=\"center\" class=\"title\"><strong>Ingrese los Datos del nuevo Paciente<\/strong><\/h1><br><\/p>\n

<form method='post'><\/p>\n

<table border=2 align=\"center\" cellpadding=\"2\" cellspacing=\"2\"<\/p>\n

face=\"Gergia\" width=\"85%\" ><\/p>\n

<tr><\/p>\n

<td>Cedula del Paciente:<\/td><td><input name=\"ced\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Nombre:<\/td><td><input name=\"name\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Apellido:<\/td><td><input name=\"lname\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Edad:<\/td><td><input name=\"edad\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Direccion:<\/td><td><input name=\"direc\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Genero:<\/td><td>M<input name=\"r1\" type=\"radio\" value=\"M\"> F<input name=\"r1\" type=\"radio\" value=\"F\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Email:<\/td><td><input name=\"email\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Telefono:<\/td><td><input name=\"telefono\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<\/table><\/p>\n

<br><br><\/p>\n

\u00a0<\/p>\n

<input id=\"Guardar_button\" value=\"Guardar\" type=\"submit\" ><\/p>\n

<%<\/p>\n

if(paciente.cont>1){<\/p>\n

String ced=request.getParameter(\"ced\");<\/p>\n

String nombre=request.getParameter(\"name\");<\/p>\n

String apellido=request.getParameter(\"lname\");<\/p>\n

String edad = request.getParameter(\"edad\");<\/p>\n

String dir = request.getParameter(\"direc\");<\/p>\n

String genero = request.getParameter(\"r1\");<\/p>\n

String email = request.getParameter(\"email\");<\/p>\n

String telefono = request.getParameter(\"telefono\");<\/p>\n

int existe = paciente.existePaciente(nombre, apellido,ced);<\/p>\n

if(existe == 0){<\/p>\n

int resultado = paciente.ingresarPaciente(ced, nombre, apellido, edad, dir, genero, email, telefono);<\/p>\n

if (resultado == 1){<\/p>\n

JOptionPane.showMessageDialog(null, \"Paciente ingresado exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Ingreso una Cita con los datos:\"+ced+\",\"+nombre+\",\"+apellido+\",\"+edad+\",\"+dir+\",\"+genero+\",\"+email+\",\"+telefono+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

response.sendRedirect(\"pSecretaria.jsp\");<\/p>\n

}<\/p>\n

else{<\/p>\n

JOptionPane.showMessageDialog(null, \"Paciente no fue ingresada exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

}<\/p>\n

}else<\/p>\n

JOptionPane.showMessageDialog(null, \"Actualmente ya se encuentra registrado el paciente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

}else{paciente.cont=2;}<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/form><\/p>\n

<form id='Regresar' action='pSecretaria.jsp' method='post'><\/p>\n

<input id=\"Regresar_button\" value=\"Regresar\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

\u00a0<\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA CREA\u00a0PERSONAL<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n
<%@ page import=\"javax.swing.*\"%><\/span><\/div>\n

\u00a0<\/p>\n

<jsp:useBean id=\"personal\" scope=\"application\" class=\"clases.Personal\"\/><\/span><\/p>\n

\u00a0<\/p>\n

<jsp:setProperty name=\"personal\" property=\"*\" \/><\/span><\/div>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<\/p>\n

<div class=\"story\"><\/p>\n

<h1 align =\"center\" class=\"title\"><strong>Ingrese los Datos del Nuevo Personal<\/strong><\/h1><br><\/p>\n

<form method ='post'><\/p>\n

<table border=2 align=\"center\" cellpadding=\"2\" cellspacing=\"2\"<\/p>\n

face=\"Gergia\" width=\"85%\" ><\/p>\n

<tr><\/p>\n

<td>Cedula del Personal:<\/td><td><input name=\"ced\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Nombre:<\/td><td><input name=\"name\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Apellido:<\/td><td><input name=\"lname\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Genero:<\/td><td>M<input name=\"r1\" type=\"radio\" value=\"M\"> F<input name=\"r1\" type=\"radio\" value=\"F\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Cargo:<\/td><td><select name=\"cargo\"><\/p>\n

<option>Farmaceutico<\/option><\/p>\n

<option>Conserje<\/option><\/p>\n

<option>Cardiologo<\/option><\/p>\n

<option>Pediatra<\/option><\/p>\n

<option>Endocrinologo<\/option><\/p>\n

<option>Secretaria<\/option><\/p>\n

<option>Gastroenterologo<\/option><\/p>\n

\u00a0<\/p>\n

<\/select><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Email:<\/td><td><input name=\"email\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Telefono:<\/td><td><input name=\"telefono\" type=\"text\"><\/td><\/p>\n

<\/tr><\/p>\n

<tr><\/p>\n

<td>Horario:<\/td><td><select name=\"horario\"> <option>8:00-12:00<\/option><\/p>\n

<option>12:00-16:00<\/option><\/p>\n

<option>16:00-20:00<\/option><\/p>\n

<option>8:00-20:00<\/option><\/p>\n

<\/select><\/td><\/p>\n

<\/tr><\/p>\n

\u00a0<\/p>\n

<\/table><\/p>\n

<br><br><\/p>\n

\u00a0<\/p>\n

<input id=\"Guardar_button\" value=\"Guardar\" type=\"submit\" ><\/p>\n

<%<\/p>\n

if(personal.cont>1){<\/p>\n

String ced,nombre,apellido,cargo,genero,email,telefono,horario;<\/p>\n

ced=request.getParameter(\"ced\");<\/p>\n

nombre=request.getParameter(\"name\");<\/p>\n

apellido=request.getParameter(\"lname\");<\/p>\n

cargo = request.getParameter(\"cargo\");<\/p>\n

genero = request.getParameter(\"r1\");<\/p>\n

email = request.getParameter(\"email\");<\/p>\n

telefono = request.getParameter(\"telefono\");<\/p>\n

horario = request.getParameter(\"horario\");<\/p>\n

int existe = personal.existePersonal(nombre, apellido, ced);<\/p>\n

if(existe == 0){<\/p>\n

int resultado = personal.ingresarPersonal(ced, nombre, apellido, genero, cargo, horario, email, telefono);<\/p>\n

if (resultado == 1){<\/p>\n

if(cargo.equals(\"Secretaria\")){<\/p>\n

Cuenta.nuevaCuenta(\"\", nombre+apellido,nombre,\"Secretaria\");<\/p>\n

}else if(cargo.equals(\"Farmaceutico\")){<\/p>\n

Cuenta.nuevaCuenta(\"\", nombre+apellido,nombre,\"Farmaceutico\");<\/p>\n

}else Cuenta.nuevaCuenta(\"\", nombre+apellido,nombre,\"Medico\");<\/p>\n

JOptionPane.showMessageDialog(null, \"Personal ingresado exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Ingreso un nuevo Personal con los datos:\"+ced+\",\"+nombre+\",\"+apellido+\",\"+genero+\",\"+cargo+\",\"+horario+\",\"+email+\",\"+telefono+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

}<\/p>\n

else{<\/p>\n

JOptionPane.showMessageDialog(null, \"Personal no fue ingresado exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

}<\/p>\n

}else{JOptionPane.showMessageDialog(null, \"El personal se encuentra actualmente registrado\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);}<\/p>\n

}<\/p>\n

else{personal.cont=2;}<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

<\/form><\/p>\n

\u00a0<\/p>\n

<form id='Regresar' action='pAdministrador.jsp' method='post'><\/p>\n

<input id=\"Regresar_button\" value=\"Regresar\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

********************************************************************************************************************** PAGINA\u00a0MODIFICA\u00a0PERSONAL **********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n
<%@ page import=\"javax.swing.*\"%><\/span><\/div>\n

\u00a0<\/p>\n

<%@ page import=\"java.util.*\"%><\/span><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"personal\" scope=\"application\" class=\"clases.Personal\"\/><\/span><\/div>\n

<jsp:setProperty name=\"personal\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<\/p>\n

<div class=\"story\"><\/p>\n

<h1 align=\"center\" class=\"title\"><strong>Ingrese los Datos que desea modificar<\/strong><\/h1><br><\/p>\n

<form iid='boton' method='post'><\/p>\n

\u00a0<\/p>\n

<%<\/p>\n

String id=request.getParameter (\"par\");<\/p>\n

ArrayList arreglo=personal.consultaXid(id);<\/p>\n

\u00a0<\/p>\n

out.println(\"<table border=2 align='center' cellpadding='2' cellspacing='2' face='Gergia' width='85%'>\");<\/p>\n

out.println(\"<tr><td>Cedula:<\/td><td><input name='ced' type ='text' size='25' value='\"+(String)arreglo.get(1)+\"' DISABLED><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Nombre<\/td><td><input name='name' type='text' size='25' value='\"+(String)arreglo.get(2)+\"'DISABLED><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Apellido:<\/td><td><input name='lname' type='text' size='25' value='\"+(String)arreglo.get(3)+\"'DISABLED><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Cargo:<\/td><td><input name='cargo' type='text' size='25' value='\"+(String)arreglo.get(4)+\"'><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Genero:<\/td><td><input name='genero' type='text' size='25' value='\"+(String)arreglo.get(5)+\"'DISABLED><\/td><\/br>\");<\/p>\n

out.println(\"<tr><td>Horario:<\/td><td><input name='hora' type='text' size='25'value='\"+(String)arreglo.get(6)+\"'><\/td><\/br>\");<\/p>\n

out.println(\"<tr><td>Mail:<\/td><td><input name='mail' type='text' size='25'value='\"+(String)arreglo.get(7)+\"'><\/td><\/br>\");<\/p>\n

out.println(\"<tr><td>Telefono:<\/td><td><input name='fono' type='text' size='25'value='\"+(String)arreglo.get(8)+\"'><\/td><\/br>\");<\/p>\n

out.println(\"<tr><td>Estado:<\/td><td><input name='estado' type='text' size='25'value='\"+(String)arreglo.get(9)+\"'><\/td><\/br>\");<\/p>\n

out.println(\"<\/table>\");<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

<input id=\"Guardar_button\" value=\"Guardar\" type= \"submit\"><\/p>\n

<%<\/p>\n

if(personal.cont > 2){<\/p>\n

String cargo= request.getParameter(\"cargo\") ;<\/p>\n

String mail= request.getParameter(\"mail\") ;<\/p>\n

String hora= request.getParameter(\"hora\") ;<\/p>\n

String fono= request.getParameter(\"fono\") ;<\/p>\n

String estado= request.getParameter(\"estado\") ;<\/p>\n

int resultado=personal.modificarPersonal(id,cargo,mail,hora,fono,estado);<\/p>\n

if (resultado == 1){<\/p>\n

JOptionPane.showMessageDialog(null, \"Personal modificado exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Modifico el Personal: \"+id+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

personal.cont=0;<\/p>\n

response.sendRedirect(\"tbConsultas.jsp\");<\/p>\n

}<\/p>\n

else{<\/p>\n

JOptionPane.showMessageDialog(null, \"Personal no pudo ser modificado\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

}<\/p>\n

}else{personal.cont=3;}<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/form><\/p>\n

\u00a0<\/p>\n

<br><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<form id='regresar' action='tbPersonal.jsp' method='post'><\/p>\n

\u00a0<\/p>\n

<input id=\"Regresar_button\" value=\"<-- Regresar al menu principal\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<br><\/p>\n

\u00a0<\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

\u00a0**********************************************************************************************************************<\/p>\n

PAGINA\u00a0MODIFICA\u00a0HISTORIA CLINICA<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/p>\n

\u00a0<\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n
<%@ page import=\"javax.swing.*\"%><\/span><\/div>\n

\u00a0<\/p>\n

<%@ page import=\"java.util.*\"%><\/span><\/p>\n

\u00a0<\/p>\n

<jsp:useBean id=\"hc\" scope=\"application\" class=\"clases.HistoriaClinica\"\/><\/span><\/div>\n

<jsp:setProperty name=\"hc\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

<\/div><\/p>\n

\u00a0<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<div class=\"story\"><\/p>\n

<h1 align=\"center\" class=\"title\"><strong>Ingrese los Datos de la Historia Clinica<\/strong><\/h1><br><\/p>\n

<form iid='boton' method='post'><\/p>\n

\u00a0<%<\/p>\n

String id=request.getParameter (\"par\");<\/p>\n

ArrayList arreglo=hc.consultaxCedula(id);<\/p>\n

\u00a0<\/p>\n

out.println(\"<table border=2 align='center' cellpadding='2' cellspacing='2' face='Gergia' width='85%'>\");<\/p>\n

out.println(\"<tr><td>Cedula:<\/td><td><input name='idm' type ='text' size='25' value='\"+(String)arreglo.get(1)+\"' DISABLED><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Tipo de Sangre:<\/td><td><input name='tSangre' type='text' size='25' value='\"+(String)arreglo.get(2)+\"'DISABLED><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Peso:<\/td><td><input name='peso' type='text' size='25' value='\"+(String)arreglo.get(3)+\"'><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Altura:<\/td><td><input name='altura' type='text' size='25' value='\"+(String)arreglo.get(4)+\"'><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Riesgo del Paciente:<\/td><td><input name='riesgo' type='text' size='25' value='\"+(String)arreglo.get(5)+\"'><\/td><\/br>\");<\/p>\n

out.println(\"<tr><td>Antecedentes Personales:<\/td><td><input name='antec' type='text' size='25'value='\"+(String)arreglo.get(6)+\"'><\/td><\/br>\");<\/p>\n

out.println(\"<tr><td>Motivo de Consulta:<\/td><td><input name='motivo' type='text' size='25' value='\"+(String)arreglo.get(7)+\"'><\/td><\/br>\");<\/p>\n

out.println(\"<\/table>\");<\/p>\n

%><\/p>\n

<input id=\"Guardar_button\" value=\"Guardar\" type= \"submit\"><\/p>\n

<%<\/p>\n

String peso,altura,riesgo,antec,motivo;<\/p>\n

if(hc.cont > 3){<\/p>\n

peso = request.getParameter(\"peso\");<\/p>\n

altura = request.getParameter(\"altura\");<\/p>\n

riesgo =request.getParameter(\"riesgo\");<\/p>\n

antec = request.getParameter(\"antec\");<\/p>\n

motivo = request.getParameter(\"motivo\");<\/p>\n

\u00a0<\/p>\n

int resultado=hc.modificarHC(id,peso,altura,riesgo,antec,motivo);<\/p>\n

if (resultado == 1){<\/p>\n

JOptionPane.showMessageDialog(null, \"Historia Clinica modificada exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Modifico la Historia Clinica del Paciente: \"+id+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

hc.cont=0;<\/p>\n

response.sendRedirect(\"tbHC.jsp\");<\/p>\n

}<\/p>\n

else{<\/p>\n

JOptionPane.showMessageDialog(null, \"Historia Clinica no modificada\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

}<\/p>\n

}else{hc.cont=4;}<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/form><\/p>\n

\u00a0<\/p>\n

<br><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<form id='regresar' action='pMedico.jsp' method='post'><\/p>\n

\u00a0<\/p>\n

<input id=\"Regresar_button\" value=\"<-- Regresar al menu principal\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<br><\/p>\n

\u00a0<\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA\u00a0MODIFICA\u00a0MEDICINA<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/div>\n
<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n

\u00a0<\/p>\n

<%@ page import=\"javax.swing.*\"%><\/span><\/p>\n

\u00a0<\/p>\n

<%@ page import=\"java.util.*\"%><\/span><\/div>\n

<jsp:useBean id=\"medicina\" scope=\"application\" class=\"clases.Medicina\"\/><\/p>\n

<jsp:setProperty name=\"medicina\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0div class=\"story\"><\/p>\n

<h1 align=\"center\" class=\"title\"><strong>Ingrese los Datos de la Medicina<\/strong><\/h1><br><\/p>\n

<form iid='boton' method='post'><\/p>\n

\u00a0<%<\/p>\n

String id=request.getParameter (\"par\");<\/p>\n

ArrayList arreglo=medicina.consultaxCod(id);<\/p>\n

\u00a0<\/p>\n

out.println(\"<table border=2 align='center' cellpadding='2' cellspacing='2' face='Gergia' width='85%'>\");<\/p>\n

out.println(\"<tr><td>Nombre<\/td><td><input name='name' type='text' size='25' value='\"+(String)arreglo.get(1)+\"'DISABLED><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Tipo:<\/td><td><input name='tipo' type='text' size='25' value='\"+(String)arreglo.get(3)+\"'DISABLED><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Laboratorio Farmaceutico:<\/td><td><input name='lab' type='text' size='25' value='\"+(String)arreglo.get(4)+\"'DISABLED><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Fecha Caducidad:<\/td><td><input name='fecha' type='text' size='25' value='\"+(String)arreglo.get(5)+\"'DISABLED><\/td><\/br>\");<\/p>\n

out.println(\"<tr><td>Stock:<\/td><td><input name='stock' type='text' size='25'value='\"+(String)arreglo.get(6)+\"'><\/td><\/br>\");<\/p>\n

out.println(\"<\/table>\");<\/p>\n

%><\/p>\n

<input id=\"Guardar_button\" value=\"Guardar\" type= \"submit\"><\/p>\n

<%<\/p>\n

String stock;<\/p>\n

if(medicina.cont>3){<\/p>\n

stock=request.getParameter(\"stock\");<\/p>\n

int resultado=medicina.modificarMedicina(id,stock);<\/p>\n

if (resultado == 1){<\/p>\n

JOptionPane.showMessageDialog(null, \"Medicina modificada exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

medicina.cont=0;<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Modifico el stock de la Medicina: \"+id+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

response.sendRedirect(\"tbMedicinaF.jsp\");<\/p>\n

}<\/p>\n

\u00a0<\/p>\n

else{<\/p>\n

JOptionPane.showMessageDialog(null, \"Historia Clinica no modificada\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

}<\/p>\n

}else{medicina.cont=4;}<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/form><\/p>\n

\u00a0<\/p>\n

<br><\/p>\n

\u00a0<\/p>\n

<form id='regresar' action='tbMedicinaF.jsp' method='post'><\/p>\n

<input id=\"Regresar_button\" value=\"<-- Regresar al menu principal\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<br><\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

\u00a0<\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA\u00a0MODIFICA\u00a0PACIENTE<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

<\/span>\u00a0<\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/div>\n
<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n

\u00a0<\/p>\n

<%@ page import=\"javax.swing.*\"%><\/span><\/p>\n

\u00a0<\/p>\n

<%@ page import=\"java.util.*\"%><\/span><\/div>\n

<jsp:useBean id=\"paciente\" scope=\"application\" class=\"clases.Paciente\"\/><\/p>\n

<jsp:setProperty name=\"paciente\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<\/p>\n

<div class=\"story\"><\/p>\n

<h1 align=\"center\" class=\"title\"><strong>Ingrese los Datos del Paciente<\/strong><\/h1><br><\/p>\n

<form iid='boton' method='post'><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<%<\/p>\n

String id=request.getParameter (\"par\");<\/p>\n

ArrayList arreglo=paciente.consultaXid(id);<\/p>\n

\u00a0<\/p>\n

out.println(\"<table border=2 align='center' cellpadding='2' cellspacing='2' face='Gergia' width='85%'>\");<\/p>\n

out.println(\"<tr><td>Cedula:<\/td><td><input name='id' type ='text' size='25' value='\"+(String)arreglo.get(1)+\"' DISABLED><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Nombre<\/td><td><input name='name' type='text' size='25' value='\"+(String)arreglo.get(2)+\"'DISABLED><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Apellido:<\/td><td><input name='lname' type='text' size='25' value='\"+(String)arreglo.get(3)+\"'DISABLED><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Edad:<\/td><td><input name='edad' type='text' size='25' value='\"+(String)arreglo.get(4)+\"'><\/td><\/tr><\/br>\");<\/p>\n

out.println(\"<tr><td>Direccion:<\/td><td><input name='dir' type='text' size='25' value='\"+(String)arreglo.get(5)+\"'><\/td><\/br>\");<\/p>\n

out.println(\"<tr><td>Genero:<\/td><td><input name='gen' type='text' size='25'value='\"+(String)arreglo.get(6)+\"'DISABLED><\/td><\/br>\");<\/p>\n

out.println(\"<tr><td>Mail:<\/td><td><input name='mail' type='text' size='25'value='\"+(String)arreglo.get(7)+\"'><\/td><\/br>\");<\/p>\n

out.println(\"<tr><td>Telefono:<\/td><td><input name='fono' type='text' size='25'value='\"+(String)arreglo.get(8)+\"'><\/td><\/br>\");<\/p>\n

out.println(\"<\/table>\");<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

<input id=\"Guardar_button\" value=\"Guardar\" type= \"submit\"><\/p>\n

<%<\/p>\n

if(paciente.cont > 2){<\/p>\n

String edad= request.getParameter(\"edad\") ;<\/p>\n

String dir= request.getParameter(\"dir\") ;<\/p>\n

String mail= request.getParameter(\"mail\") ;<\/p>\n

String fono= request.getParameter(\"fono\") ;<\/p>\n

int resultado=paciente.modificarPaciente(id,edad,dir,mail,fono);<\/p>\n

if (resultado == 1){<\/p>\n

JOptionPane.showMessageDialog(null, \"Paciente modificada exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Modifico el Paciente: \"+id+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

paciente.cont=0;<\/p>\n

response.sendRedirect(\"tbPaciente.jsp\");<\/p>\n

}<\/p>\n

else{<\/p>\n

JOptionPane.showMessageDialog(null, \"Paciente no pudo ser modificado\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

}<\/p>\n

}else{paciente.cont=3;}<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

<\/form><\/p>\n

\u00a0<\/p>\n

<br><\/p>\n

<form id='regresar' action='pSecretaria.jsp' method='post'><\/p>\n

\u00a0<input id=\"Regresar_button\" value=\"<-- Regresar al menu principal\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<br><\/p>\n

\u00a0<\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA\u00a0BORRA CITA<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

<\/span><\/p>\n

<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%><\/span><\/div>\n
<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/span><\/div>\n
\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/span><\/div>\n

\u00a0<\/p>\n

<%@ page import=\"javax.swing.*\"%><\/span><\/p>\n

\u00a0<\/p>\n

<%@ page import=\"java.util.*\"%><\/span><\/div>\n

<jsp:useBean id=\"cita\" scope=\"application\" class=\"clases.Cita\"\/><\/p>\n

<jsp:setProperty name=\"cita\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/p>\n

<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/p>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"><\/p>\n

<head><\/p>\n

<meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-4\" \/><\/p>\n

<title>Sistema de Control de Centro Medico<\/title><\/p>\n

<meta name=\"keywords\" content=\"\" \/><\/p>\n

<meta name=\"description\" content=\"\" \/><\/p>\n

<link href=\"default.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<div id=\"header\"><\/p>\n

<div id=\"logo\"><\/p>\n

<h1><p>Centro Medico<\/p><\/h1><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<div id=\"menu\"><\/p>\n

<marquee behavior=\"alternate\"><label for=\"inputtext4\"><h2><font color=\"navy\"<\/font>&nbsp &nbsp LA SALUD ES DE TODOS<\/h2><\/label><\/p>\n

<\/marquee><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<div id=\"content\"><\/p>\n

<div id=\"main\"><\/p>\n

<div id=\"welcome\" class=\"post\"><\/p>\n

<h2 class=\"title\">Sistema de Control de Centro Medico<\/h2><\/p>\n

\u00a0<\/p>\n

<div class=\"story\"><\/p>\n

<%<\/p>\n

String s=cita.consultarCitas();<\/p>\n

out.println(s);<\/p>\n

ArrayList cit= cita.consultanomPaciente();<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

<h1 align=\"center\" class=\"title\"><strong>Ingrese los datos del Paciente para eliminar su cita<\/strong><\/h1><br><\/p>\n

<form method='post'><\/p>\n

\u00a0<\/p>\n

<table border=2 align=\"center\" cellpadding=\"2\" cellspacing=\"2\"<\/p>\n

face=\"Gergia\" width=\"85%\"><\/p>\n

<tr><\/p>\n

<td>Cita:<\/td><td><select name=\"cit\"> <% for (int k=0; k<cit.size()\/3; k++){ %><option><%=(String)cit.get(3*k) + \" \" + (String)cit.get(3*k+1) + \" \" + (String)cit.get(3*k+2)%><\/option> <% } %> <\/select><\/td><br><\/p>\n

<\/tr><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/table><\/p>\n

<br><br><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<input id=\"Borrar_button\" value=\"Borrar Cita\" type=\"submit\" ><\/p>\n

<%<\/p>\n

if(cita.cont>1){<\/p>\n

String date = request.getParameter(\"cit\");<\/p>\n

String arrdate[] = date.split(\" \");<\/p>\n

int resultado = cita.borrarCita(arrdate[1],arrdate[2],arrdate[0]);<\/p>\n

\u00a0<\/p>\n

if (resultado == 1){<\/p>\n

String s1=cita.consultarCitas();<\/p>\n

JOptionPane.showMessageDialog(null, \"Cita eliminada exitosamente\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Elimino la cita numero: \"+arrdate[0]+\".\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

response.sendRedirect(\"pSecretaria.jsp\");<\/p>\n

}<\/p>\n

else{<\/p>\n

JOptionPane.showMessageDialog(null, \"Cita no fue eliminada\",\"Mensaje del Sistema!!\",JOptionPane.INFORMATION_MESSAGE);<\/p>\n

}<\/p>\n

}else{cita.cont=2;}<\/p>\n

\u00a0<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

<\/form><\/p>\n

<form id='Regresar' action='pSecretaria.jsp' method='post'><\/p>\n

<input id=\"Regresar_button\" value=\"Regresar\" type=\"submit\"><\/p>\n

<\/form><\/p>\n

<p><em><strong>\"Centro Medico al servicio de su salud.\"<\/strong><\/em><\/p><\/p>\n

<p>Direccion: Juan Montalvo y San Martin<\/p><\/p>\n

<p>Telefonos: 2345987 - 2398056<\/p><\/p>\n

<p>mail: cmedico@salud.com<\/p><\/p>\n

<\/div><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<\/div><\/p>\n

<div id=\"footer\"><\/p>\n

<p id=\"legal\">Bases de Datos I - All Rights Reserved.<\/p><\/p>\n

<p>Designed by Alexis Larraga , Estefania Arias, Lissette Cabello, Alberto Santos<\/p><\/p>\n

\u00a0<\/p>\n

<\/div><\/p>\n

<\/body><\/p>\n

<\/html><\/p>\n

**********************************************************************************************************************<\/p>\n

PAGINA\u00a0CIERRA CESION<\/p>\n

**********************************************************************************************************************<\/p>\n

\u00a0<\/p>\n

<\/span><\/p>\n

<%@page contentType=\"text\/html\"%><\/span><\/span><\/div>\n
<%@page pageEncoding=\"UTF-8\"%><\/span><\/span><\/div>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

<\/p>\n
<\/span><\/div>\n

<\/span><\/span><\/div>\n

<\/p>\n

\u00a0<\/span><\/span><\/div>\n

\u00a0<\/p>\n

<\/span><\/span><\/span><\/span><\/p>\n

\u00a0<\/div>\n
<jsp:useBean id=\"Cuenta\" scope=\"application\" class=\"Sesion.Cuenta\"\/><\/span><\/div>\n
<jsp:setProperty name=\"Cuenta\" property=\"*\" \/><\/span><\/div>\n
\u00a0<\/span><\/div>\n

\u00a0<\/p>\n

<jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/><\/span><\/p>\n

\u00a0<\/p>\n

<jsp:setProperty name=\"FechaHora\" property=\"*\" \/><\/span><\/div>\n

<jsp:useBean id=\"Historial\" scope=\"application\" class=\"clases.Historial\"\/><\/p>\n

<jsp:setProperty name=\"Historial\" property=\"*\" \/><\/p>\n

\u00a0<!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"<\/p>\n

\"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\"><\/p>\n

<html><\/p>\n

<head><\/p>\n

<meta http-equiv=\"Content-Type\" content=\"text\/html; charset=UTF-8\"><\/p>\n

<title>Pagina de ingreso al Sistema<\/title><\/p>\n

<\/head><\/p>\n

<body><\/p>\n

<h1>JSP Page<\/h1><\/p>\n

<%<\/p>\n

HttpSession sesion_actual=request.getSession(true);<\/p>\n

sesion_actual.invalidate();<\/p>\n

%><\/p>\n

\u00a0<\/p>\n

<%<\/p>\n

\u00a0<\/p>\n

Historial.registrarHistorial(Cuenta.getIdempleado(),\"Cerro Sesion\",FechaHora.getHora(),FechaHora.getFecha());<\/p>\n

%><\/p>\n

<jsp:forward page=\"index.jsp\" \/><\/p>\n

\u00a0\u00a0<\/body><\/p>\n

<\/html><\/p>\n

\u00a0<\/span><\/span><\/span><\/div>\n

\u00a0<\/p>\n

<\/span><\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/div>\n

\u00a0<\/p>\n

<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/div>\n

\u00a0<\/p>\n

<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\u00a0 ********************************************************************************************************************** PAGINA PRINCIPAL\/PAGINA DE INGRESO ********************************************************************************************************************** \u00a0 \u00a0<%-- Document : index Created on : 06\/01\/2009, 06:01:19 PM \u00a0 Author : cltsmalc \u00a0 --%> <jsp:useBean id=\"db\" scope=\"request\" class=\"clases.bean\"\/> <jsp:setProperty name=\"db\" property=\"*\"\/> <jsp:useBean id=\"cuenta\" scope=\"request\" class=\"Sesion.Cuenta\"\/> <jsp:setProperty name=\"cuenta\" property=\"*\" \/> <jsp:useBean id=\"FechaHora\" scope=\"application\" class=\"clases.FechaHora\"\/> <jsp:setProperty name=\"FechaHora\" property=\"*\" \/> \u00a0 <html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\"> <head> <meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-8\" […]<\/p>\n","protected":false},"author":161,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-63","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/pages\/63","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\/161"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/comments?post=63"}],"version-history":[{"count":8,"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/pages\/63\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/pages\/63\/revisions\/68"}],"wp:attachment":[{"href":"https:\/\/blog.espol.edu.ec\/sccm\/wp-json\/wp\/v2\/media?parent=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}