| @@ -0,0 +1,15 @@ | ||
| <?xml version="1.0" encoding="UTF-8"?> | ||
| <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0"> | ||
| <display-name>SanProject</display-name> | ||
| <welcome-file-list> | ||
| <welcome-file>index.html</welcome-file> | ||
| <welcome-file>index.htm</welcome-file> | ||
| <welcome-file>index.jsp</welcome-file> | ||
| <welcome-file>default.html</welcome-file> | ||
| <welcome-file>default.htm</welcome-file> | ||
| <welcome-file>default.jsp</welcome-file> | ||
| </welcome-file-list> | ||
| <session-config> | ||
| <session-timeout>1</session-timeout> | ||
| </session-config> | ||
| </web-app> |
| @@ -0,0 +1,173 @@ | ||
| <%@ page language="java" contentType="text/html; charset=UTF-8" | ||
| pageEncoding="UTF-8"%> | ||
| <%@ page session="true"%> | ||
|
|
||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> | ||
|
|
||
| <!DOCTYPE html> | ||
| <html lang="en"> | ||
| <head> | ||
| <meta charset="utf-8"> | ||
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> | ||
| <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
| <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags --> | ||
| <meta name="description" content=""> | ||
| <meta name="author" content=""> | ||
| <link rel="icon" href="../../favicon.ico"> | ||
|
|
||
| <title>Pulse | Add New Patient</title> | ||
|
|
||
|
|
||
| <link href="css/bootstrap.min.css" rel="stylesheet"> | ||
|
|
||
| <script type="text/javascript" src="js/jquery-2.2.3.min.js"></script> | ||
| <script type="text/javascript" src="js/jquery-ui.js"></script> | ||
|
|
||
| <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" | ||
| url="jdbc:mysql://localhost/Stude" user="root" password=" " /> | ||
|
|
||
| <sql:query dataSource="${snapshot}" var="result"> | ||
| SELECT * from Students where regNumber = ? | ||
| <sql:param value="${param.regNumber}"></sql:param> | ||
| </sql:query> | ||
|
|
||
|
|
||
| </head> | ||
|
|
||
| <body> | ||
|
|
||
| <nav class="navbar navbar-inverse navbar-fixed-top"> | ||
| <div class="container-fluid"> | ||
| <div class="navbar-header"> | ||
| <button type="button" class="navbar-toggle collapsed" | ||
| data-toggle="collapse" data-target="#navbar" aria-expanded="false" | ||
| aria-controls="navbar"> | ||
| <span class="sr-only">Toggle navigation</span> <span | ||
| class="icon-bar"></span> <span class="icon-bar"></span> <span | ||
| class="icon-bar"></span> | ||
| </button> | ||
| <a class="navbar-brand" href="index.jsp"><i><strong>Pulse</strong></i></a> | ||
| </div> | ||
| <div id="navbar" class="navbar-collapse collapse"> | ||
| <ul class="nav navbar-nav navbar-right"> | ||
| <li><a href="doctorhome.jsp">History</a></li> | ||
| <li><a href="#">Settings</a></li> | ||
| <li><a href="#">Profile</a></li> | ||
| <li><a href="#">Help</a></li> | ||
| </ul> | ||
| <form class="navbar-form navbar-right"> | ||
| <input type="text" class="form-control" | ||
| placeholder="Search Reg No." name="regNumber"> | ||
| </form> | ||
| </div> | ||
| </div> | ||
| </nav> | ||
|
|
||
|
|
||
| <div class="container"> | ||
| <hr> | ||
| <br> | ||
| <div class="col-md-8 col-md-offset-2"> | ||
| <p class="lead text-center">Use the following search bar to get | ||
| the details of the patient</p> | ||
| <p class="lead small text-center">Ensure you enter the | ||
| Registration Number correctly, then press the Submit Button to post | ||
| the request</p> | ||
|
|
||
|
|
||
| <form class="form-inline col-md-8 col-md-offset-4" role="form" | ||
| method="post"> | ||
| <div class="form-group"> | ||
| <label class="sr-only" for="regNumber">Registration Number</label> | ||
| <input type="text" placeholder="Search Reg No." | ||
| class="form-control" id="regNumber" name="regNumber"> | ||
| </div> | ||
| <button title="Search Database for the Student Details" | ||
| type="submit" class="btn btn-success">Query</button> | ||
| </form> | ||
|
|
||
| <hr> | ||
| <hr> | ||
| <form action="AddPatient" class="form-horizontal" method="POST"> | ||
| <table class="table table-striped"> | ||
| <c:forEach var="row" items="${result.rows}"> | ||
|
|
||
| <div class="form-group"> | ||
| <label class="col-sm-2 control-label">Registration Number</label> | ||
|
|
||
| <div class="col-sm-6"> | ||
| <input name="regNumber" type="text" class="form-control" | ||
| placeholder="Reg. Number" value="${row.regNumber}" readonly> | ||
| </div> | ||
| </div> | ||
| <div class="form-group"> | ||
| <label class="col-sm-2 control-label">First Name</label> | ||
|
|
||
| <div class="col-sm-6"> | ||
| <input name="firstName" type="text" class="form-control" | ||
| placeholder="First Name" value="${row.firstName}" readonly> | ||
| </div> | ||
| </div> | ||
|
|
||
| <div class="form-group"> | ||
| <label class="col-sm-2 control-label">Last Name</label> | ||
|
|
||
| <div class="col-sm-6"> | ||
| <input name="lastName" type="text" class="form-control" | ||
| placeholder="Last Name" value="${row.lastName}" readonly> | ||
| </div> | ||
| </div> | ||
| <div class="form-group"> | ||
| <label class="col-sm-2 control-label">Gender</label> | ||
|
|
||
| <div class="col-sm-6"> | ||
| <input name="gender" type="text" class="form-control" | ||
| placeholder="Gender" value="${row.gender}" readonly> | ||
| </div> | ||
| </div> | ||
| <div class="form-group"> | ||
| <label class="col-sm-2 control-label">Faculty</label> | ||
|
|
||
| <div class="col-sm-6"> | ||
| <input name="faculty" type="text" class="form-control" | ||
| placeholder="Faculty" value="${row.faculty}" readonly> | ||
| </div> | ||
| </div> | ||
|
|
||
| <div class="form-group"> | ||
| <label class="col-sm-2 control-label">Department</label> | ||
|
|
||
| <div class="col-sm-6"> | ||
| <input name="department" type="text" class="form-control" | ||
| placeholder="Department" value="${row.department}" readonly> | ||
| </div> | ||
| </div> | ||
|
|
||
| <div class="form-group"> | ||
| <label class="col-sm-2 control-label">Doctor's Name</label> | ||
|
|
||
| <div class="col-sm-6"> | ||
| <input name="doctor" type="text" class="form-control" | ||
| placeholder="Doctor's Name"> | ||
| </div> | ||
| </div> | ||
|
|
||
|
|
||
| <div> | ||
|
|
||
| <button id="btnSubmit" type="submit" | ||
| class="btn btn-primary col-md-8">Add to Queue</button> | ||
| <button id="btnCancel" type="reset" | ||
| class="btn btn-danger pull-right col-md-3">Cancel</button> | ||
|
|
||
| </div> | ||
|
|
||
| </c:forEach> | ||
| </table> | ||
| </form> | ||
| </div> | ||
|
|
||
| </div> | ||
| </html> |
| @@ -0,0 +1,107 @@ | ||
| <%@ page session="true" pageEncoding="UTF-8"%> | ||
| <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> | ||
|
|
||
| <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" | ||
| url="jdbc:mysql://localhost/Stude" user="root" password=" " /> | ||
|
|
||
|
|
||
| <sql:query dataSource="${snapshot}" var="result"> | ||
| SELECT ChemistQueue.regNumber, Students.firstName, Students.lastName, Students.gender from ChemistQueue | ||
| join Students where ChemistQueue.regNumber=Students.regNumber order by ChemistQueue.time; | ||
| </sql:query> | ||
|
|
||
| <html> | ||
|
|
||
| <head> | ||
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> | ||
| <link href="css/bootstrap.min.css" rel="stylesheet"> | ||
| <link href="css/dashboard.css" rel="stylesheet"> | ||
| <script type="text/javascript" src="js/date_time.js"></script> | ||
| <title>Pulse | Queue</title> | ||
| <% | ||
| response.setIntHeader("Refresh", 10); | ||
| %> | ||
| </head> | ||
|
|
||
| <body> | ||
|
|
||
| <nav class="navbar navbar-inverse navbar-fixed-top"> | ||
| <div class="container-fluid"> | ||
| <div class="navbar-header"> | ||
| <button type="button" class="navbar-toggle collapsed" | ||
| data-toggle="collapse" data-target="#navbar" aria-expanded="false" | ||
| aria-controls="navbar"> | ||
| <span class="sr-only">Toggle navigation</span> <span | ||
| class="icon-bar"></span> <span class="icon-bar"></span> <span | ||
| class="icon-bar"></span> | ||
| </button> | ||
| <a class="navbar-brand" href="ReceptionistHome.jsp"><i><strong>Pulse</strong></i></a> | ||
| </div> | ||
| <div id="navbar" class="navbar-collapse collapse"> | ||
| <ul class="nav navbar-nav navbar-right"> | ||
| <li><a href="chemisthome.jsp">Main</a></li> | ||
| <li><a href="#">Settings</a></li> | ||
| <li><a href="#">Profile</a></li> | ||
| <li><a href="#">Help</a></li> | ||
| <li><a href="ReceptionistHome.jsp">Home</a></li> | ||
| </ul> | ||
| <form class="navbar-form navbar-right"> | ||
| <input type="text" class="form-control" placeholder="Search..."> | ||
| </form> | ||
| </div> | ||
| </div> | ||
| </nav> | ||
| <div class="row"> | ||
| <div class="col-sm-3 col-md-2 sidebar"> | ||
| <ul class="nav nav-sidebar"> | ||
| <li class="active"><a href="#">Overview <span | ||
| class="sr-only">(current)</span></a></li> | ||
| <li><a href="#">Reports</a></li> | ||
| <li><a href="#">Analytics</a></li> | ||
| <li><a href="#">Export</a></li> | ||
| </ul> | ||
|
|
||
|
|
||
| </div> | ||
| </div> | ||
| <div class="col-sm-8 col-sm-offset-3"> | ||
| <h2 class="sub-header pull-left"> | ||
| Chemist | ||
| <h2 class="sub-header pull-right"> | ||
| <span id="date_time"></span> | ||
| <script type="text/javascript"> | ||
| window.onload = date_time('date_time'); | ||
| </script> | ||
| </h2> | ||
| </h2> | ||
| </div> | ||
| <div class="table-responsive col-sm-8 col-sm-offset-2"> | ||
| <table class="table table-striped table-hover"> | ||
| <thead> | ||
| <tr> | ||
| <th>Reg. Number</th> | ||
| <th>First Name</th> | ||
| <th>Last Name</th> | ||
| <th>Gender</th> | ||
| </tr> | ||
| </thead> | ||
| <tbody> | ||
|
|
||
| <c:forEach var="student" items="${result.rows}"> | ||
| <tr> | ||
|
|
||
| <td><a | ||
| href="pharmacy.jsp?regNumber=<c:out value="${student.regNumber}"/>"><c:out | ||
| value="${student.regNumber}" /></a></td> | ||
| <td><c:out value="${student.firstName}" /> | ||
| <c:out | ||
| value="${student.firstName}" /></td> | ||
| <td><c:out value="${student.lastName}" /></td> | ||
| <td><c:out value="${student.gender}" /></td> | ||
|
|
||
| </tr> | ||
| </c:forEach> | ||
| </table> | ||
| </body> | ||
| </html> |
| @@ -0,0 +1,176 @@ | ||
| /* | ||
| * Globals | ||
| */ | ||
|
|
||
| /* Links */ | ||
|
|
||
|
|
||
|
|
||
| html, | ||
| body { | ||
| background: url(./images/pulse.jpg) no-repeat center center fixed; | ||
| -webkit-background-size: cover; | ||
| -moz-background-size: cover; | ||
| -o-background-size: cover; | ||
| background-size: cover; | ||
| } | ||
|
|
||
| a, | ||
| a:focus, | ||
| a:hover { | ||
| color: #fff; | ||
| } | ||
|
|
||
| /* Custom default button */ | ||
| .btn-default, | ||
| .btn-default:hover, | ||
| .btn-default:focus { | ||
| color: #333; | ||
| text-shadow: none; /* Prevent inheritance from `body` */ | ||
| background-color: #fff; | ||
| border: 1px solid #fff; | ||
| } | ||
|
|
||
|
|
||
| /* | ||
| * Base structure | ||
| */ | ||
|
|
||
| html, | ||
| body { | ||
| height: 100%; | ||
| background-color: #333; | ||
| } | ||
| body { | ||
| background-size: cover; | ||
| color: #fff; | ||
| text-align: center; | ||
| text-shadow: 0 1px 3px rgba(0,0,0,.5); | ||
| } | ||
|
|
||
| /* Extra markup and styles for table-esque vertical and horizontal centering */ | ||
| .site-wrapper { | ||
| display: table; | ||
| width: 100%; | ||
| height: 100%; /* For at least Firefox */ | ||
| min-height: 100%; | ||
| -webkit-box-shadow: inset 0 0 100px rgba(0,0,0,.5); | ||
| box-shadow: inset 0 0 100px rgba(0,0,0,.5); | ||
| } | ||
| .site-wrapper-inner { | ||
| display: table-cell; | ||
| vertical-align: top; | ||
| } | ||
| .cover-container { | ||
| margin-right: auto; | ||
| margin-left: auto; | ||
| } | ||
|
|
||
| /* Padding for spacing */ | ||
| .inner { | ||
| padding: 30px; | ||
| } | ||
|
|
||
|
|
||
| /* | ||
| * Header | ||
| */ | ||
| .masthead-brand { | ||
| margin-top: 10px; | ||
| margin-bottom: 10px; | ||
| } | ||
|
|
||
| .masthead-nav > li { | ||
| display: inline-block; | ||
| } | ||
| .masthead-nav > li + li { | ||
| margin-left: 20px; | ||
| } | ||
| .masthead-nav > li > a { | ||
| padding-right: 0; | ||
| padding-left: 0; | ||
| font-size: 16px; | ||
| font-weight: bold; | ||
| color: #fff; /* IE8 proofing */ | ||
| color: rgba(255,255,255,.75); | ||
| border-bottom: 2px solid transparent; | ||
| } | ||
| .masthead-nav > li > a:hover, | ||
| .masthead-nav > li > a:focus { | ||
| background-color: transparent; | ||
| border-bottom-color: #a9a9a9; | ||
| border-bottom-color: rgba(255,255,255,.25); | ||
| } | ||
| .masthead-nav > .active > a, | ||
| .masthead-nav > .active > a:hover, | ||
| .masthead-nav > .active > a:focus { | ||
| color: #fff; | ||
| border-bottom-color: #fff; | ||
| } | ||
|
|
||
| @media (min-width: 768px) { | ||
| .masthead-brand { | ||
| float: left; | ||
| } | ||
| .masthead-nav { | ||
| float: right; | ||
| } | ||
| } | ||
|
|
||
|
|
||
| /* | ||
| * Cover | ||
| */ | ||
|
|
||
| .cover { | ||
| padding: 0 20px; | ||
| } | ||
| .cover .btn-lg { | ||
| padding: 10px 20px; | ||
| font-weight: bold; | ||
| } | ||
|
|
||
|
|
||
| /* | ||
| * Footer | ||
| */ | ||
|
|
||
| .mastfoot { | ||
| color: #999; /* IE8 proofing */ | ||
| color: rgba(255,255,255,.5); | ||
| } | ||
|
|
||
|
|
||
| /* | ||
| * Affix and center | ||
| */ | ||
|
|
||
| @media (min-width: 768px) { | ||
| /* Pull out the header and footer */ | ||
| .masthead { | ||
| position: fixed; | ||
| top: 0; | ||
| } | ||
| .mastfoot { | ||
| position: fixed; | ||
| bottom: 0; | ||
| } | ||
| /* Start the vertical centering */ | ||
| .site-wrapper-inner { | ||
| vertical-align: middle; | ||
| } | ||
| /* Handle the widths */ | ||
| .masthead, | ||
| .mastfoot, | ||
| .cover-container { | ||
| width: 100%; /* Must be percentage or pixels for horizontal alignment */ | ||
| } | ||
| } | ||
|
|
||
| @media (min-width: 992px) { | ||
| .masthead, | ||
| .mastfoot, | ||
| .cover-container { | ||
| width: 700px; | ||
| } | ||
| } |
| @@ -0,0 +1,105 @@ | ||
| /* | ||
| * Base structure | ||
| */ | ||
|
|
||
| /* Move down content because we have a fixed navbar that is 50px tall */ | ||
| body { | ||
| padding-top: 50px; | ||
| } | ||
|
|
||
|
|
||
| /* | ||
| * Global add-ons | ||
| */ | ||
|
|
||
| .sub-header { | ||
| padding-bottom: 10px; | ||
| border-bottom: 1px solid #eee; | ||
| } | ||
|
|
||
| /* | ||
| * Top navigation | ||
| * Hide default border to remove 1px line. | ||
| */ | ||
| .navbar-fixed-top { | ||
| border: 0; | ||
| } | ||
|
|
||
| /* | ||
| * Sidebar | ||
| */ | ||
|
|
||
| /* Hide for mobile, show later */ | ||
| .sidebar { | ||
| display: none; | ||
| } | ||
| @media (min-width: 768px) { | ||
| .sidebar { | ||
| position: fixed; | ||
| top: 51px; | ||
| bottom: 0; | ||
| left: 0; | ||
| z-index: 1000; | ||
| display: block; | ||
| padding: 20px; | ||
| overflow-x: hidden; | ||
| overflow-y: auto; /* Scrollable contents if viewport is shorter than content. */ | ||
| background-color: #f5f5f5; | ||
| border-right: 1px solid #eee; | ||
| } | ||
| } | ||
|
|
||
| /* Sidebar navigation */ | ||
| .nav-sidebar { | ||
| margin-right: -21px; /* 20px padding + 1px border */ | ||
| margin-bottom: 20px; | ||
| margin-left: -20px; | ||
| } | ||
| .nav-sidebar > li > a { | ||
| padding-right: 20px; | ||
| padding-left: 20px; | ||
| } | ||
| .nav-sidebar > .active > a, | ||
| .nav-sidebar > .active > a:hover, | ||
| .nav-sidebar > .active > a:focus { | ||
| color: #fff; | ||
| background-color: #428bca; | ||
| } | ||
|
|
||
|
|
||
| /* | ||
| * Main content | ||
| */ | ||
|
|
||
| .main { | ||
| padding: 20px; | ||
| } | ||
| @media (min-width: 768px) { | ||
| .main { | ||
| padding-right: 40px; | ||
| padding-left: 40px; | ||
| } | ||
| } | ||
| .main .page-header { | ||
| margin-top: 0; | ||
| } | ||
|
|
||
|
|
||
| /* | ||
| * Placeholder dashboard ideas | ||
| */ | ||
|
|
||
| .placeholders { | ||
| margin-bottom: 30px; | ||
| text-align: center; | ||
| } | ||
| .placeholders h4 { | ||
| margin-bottom: 0; | ||
| } | ||
| .placeholder { | ||
| margin-bottom: 20px; | ||
| } | ||
| .placeholder img { | ||
| display: inline-block; | ||
| border-radius: 50%; | ||
| } |
| @@ -0,0 +1,9 @@ | ||
| body { | ||
| min-height: 2000px; | ||
| padding-top: 70px; | ||
| } | ||
| #btnSubmit, | ||
| #btnCancel{ | ||
| display: inline-block; | ||
| vertical-align: top; | ||
| } |
| @@ -0,0 +1,40 @@ | ||
| body { | ||
| padding-top: 40px; | ||
| padding-bottom: 40px; | ||
| background-color: #eee; | ||
| } | ||
|
|
||
| .form-signin { | ||
| max-width: 330px; | ||
| padding: 15px; | ||
| margin: 0 auto; | ||
| } | ||
| .form-signin .form-signin-heading, | ||
| .form-signin .checkbox { | ||
| margin-bottom: 10px; | ||
| } | ||
| .form-signin .checkbox { | ||
| font-weight: normal; | ||
| } | ||
| .form-signin .form-control { | ||
| position: relative; | ||
| height: auto; | ||
| -webkit-box-sizing: border-box; | ||
| -moz-box-sizing: border-box; | ||
| box-sizing: border-box; | ||
| padding: 10px; | ||
| font-size: 16px; | ||
| } | ||
| .form-signin .form-control:focus { | ||
| z-index: 2; | ||
| } | ||
| .form-signin input[type="email"] { | ||
| margin-bottom: -1px; | ||
| border-bottom-right-radius: 0; | ||
| border-bottom-left-radius: 0; | ||
| } | ||
| .form-signin input[type="password"] { | ||
| margin-bottom: 10px; | ||
| border-top-left-radius: 0; | ||
| border-top-right-radius: 0; | ||
| } |
| @@ -0,0 +1,31 @@ | ||
| <%@ page language="java" contentType="text/html; charset=UTF-8" | ||
| pageEncoding="UTF-8"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> | ||
| <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> | ||
| <html> | ||
| <head> | ||
| <meta charset="utf-8"> | ||
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> | ||
| <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> | ||
|
|
||
| <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" | ||
| url="jdbc:mysql://localhost/Stude" user="root" password=" " /> | ||
|
|
||
| <sql:update dataSource="${snapshot}" var="result"> | ||
| delete from ChemistQueue where regNumber = ? | ||
| <sql:param value="${param.regNumber}"></sql:param> | ||
| </sql:update> | ||
|
|
||
| <title>Delete from Chemist Queue</title> | ||
| </head> | ||
| <body> | ||
| <c:if test="${result==1}"> | ||
| <font size="5" color='green'> Congratulations ! Data deleted | ||
| successfully.</font> | ||
| <a href="chemisthome.jsp">Go Home</a> | ||
| <c:redirect url="chemisthome.jsp" /> | ||
| </c:if> | ||
| </body> | ||
| </html> |
| @@ -0,0 +1,30 @@ | ||
| <%@ page language="java" contentType="text/html; charset=UTF-8" | ||
| pageEncoding="UTF-8"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> | ||
| <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> | ||
| <html> | ||
| <head> | ||
| <meta charset="utf-8"> | ||
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> | ||
| <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> | ||
| <title>Insert title here</title> | ||
|
|
||
| <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" | ||
| url="jdbc:mysql://localhost/Stude" user="root" password=" " /> | ||
|
|
||
| <sql:update dataSource="${snapshot}" var="result"> | ||
| delete from ReceptionistQueue where regNumber = ? | ||
| <sql:param value="${param.regNumber}"></sql:param> | ||
| </sql:update> | ||
| </head> | ||
| <body> | ||
| <c:if test="${result==1}"> | ||
| <font size="5" color='green'> Congratulations ! Data deleted | ||
| successfully.</font> | ||
| <a href="doctorhome.jsp">Go Home</a> | ||
| <c:redirect url="doctorhome.jsp" /> | ||
| </c:if> | ||
| </body> | ||
| </html> |
| @@ -0,0 +1,109 @@ | ||
| <%@ page language="java" contentType="text/html; charset=UTF-8" | ||
| pageEncoding="UTF-8"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> | ||
| <%@ page session="true"%> | ||
| <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> | ||
| <html> | ||
| <head> | ||
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> | ||
| <title>Pulse | Diagnosis & Prescription</title> | ||
| <link href="css/bootstrap.min.css" rel="stylesheet"> | ||
|
|
||
| <link href="font-awesome/css/font-awesome.min.css" rel="stylesheet"> | ||
| <script> | ||
| function confirmGo(m, u) { | ||
| if (confirm(m)) { | ||
| window.location = u; | ||
| } | ||
| } | ||
| </script> | ||
|
|
||
| <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" | ||
| url="jdbc:mysql://localhost/Stude" user="root" password=" " /> | ||
|
|
||
| <sql:query dataSource="${snapshot}" var="result"> | ||
| select * from ReceptionistQueue where regNumber = ? | ||
| <sql:param value="${param.regNumber}"></sql:param> | ||
|
|
||
| </sql:query> | ||
| </head> | ||
| <body> | ||
|
|
||
| <nav class="navbar navbar-inverse navbar-fixed-top"> | ||
| <div class="container-fluid"> | ||
| <div class="navbar-header"> | ||
| <button type="button" class="navbar-toggle collapsed" | ||
| data-toggle="collapse" data-target="#navbar" aria-expanded="false" | ||
| aria-controls="navbar"> | ||
| <span class="sr-only">Toggle navigation</span> <span | ||
| class="icon-bar"></span> <span class="icon-bar"></span> <span | ||
| class="icon-bar"></span> | ||
| </button> | ||
| <a class="navbar-brand" href="index.jsp"><i | ||
| class="fa fa-fw fa-lg fa-heartbeat" style="color: white"></i></a> | ||
| </div> | ||
| <div id="navbar" class="navbar-collapse collapse"> | ||
| <ul class="nav navbar-nav navbar-right"> | ||
| <li><a href="doctorhome.jsp">Back</a></li> | ||
| <li><a href="#">Settings</a></li> | ||
| <li><a href="#">Profile</a></li> | ||
| <li><a href="#">Help</a></li> | ||
| </ul> | ||
| <form class="navbar-form navbar-right"> | ||
| <input type="text" class="form-control" placeholder="Search Reg No." | ||
| name="regNumber"> | ||
| </form> | ||
| </div> | ||
| </div> | ||
| </nav> | ||
|
|
||
| <div class="container"> | ||
|
|
||
| <div class="col-sm-6 col-sm-offset-3"> | ||
| <div class=""> | ||
| <h2 class="sub-header pull-left"> | ||
| <br> Use the forms below to capture the patient's Diagnosis | ||
| and Prescription <br> | ||
| </h2> | ||
|
|
||
|
|
||
| </div> | ||
|
|
||
| <div> | ||
| <form action="SendToPharmacist" method="POST"> | ||
| <div class="col-sm-6"> | ||
| <input name="regNumber" type="text" class="form-control" | ||
| value="${param.regNumber}" hidden> | ||
| </div> | ||
| <div class="form-group"> | ||
| <label for="Diagnosis">Diagnosis</label> | ||
| <textarea class="form-control" rows="5" id="diagnosis" | ||
| name="diagnosis"></textarea> | ||
| </div> | ||
| <br> <br> | ||
| <div class="form-group"> | ||
| <label for="Prescription">Prescription</label> | ||
| <textarea class="form-control" rows="5" id="prescription" | ||
| name="prescription"></textarea> | ||
| </div> | ||
| <div> | ||
| <button id="btnSubmit" type="submit" | ||
| class="btn btn-success col-md-3">Save</button> | ||
|
|
||
| <a class="btn btn-info btn-sm col-sm-3 col-sm-offset-1" | ||
| href='history.jsp?regNumber=<c:out value="${param.regNumber}"/>'>View History</a> | ||
|
|
||
|
|
||
| <a class="btn btn-danger btn-sm col-sm-offset-1" | ||
| href="javascript:confirmGo('Sure to dequeue this patient?','delete.jsp?regNumber=<c:out value="${param.regNumber}"/>')">DeQueue</a> | ||
|
|
||
| </div> | ||
|
|
||
| </form> | ||
|
|
||
| </div> | ||
| </div> | ||
| </div> | ||
| </body> | ||
| </html> |
| @@ -0,0 +1,116 @@ | ||
| <%@ page session="true" pageEncoding="UTF-8"%> | ||
| <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> | ||
|
|
||
| <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" | ||
| url="jdbc:mysql://localhost/Stude" user="root" password=" " /> | ||
|
|
||
|
|
||
| <sql:query dataSource="${snapshot}" var="result"> | ||
| SELECT * from ReceptionistQueue order by time; | ||
| </sql:query> | ||
|
|
||
| <!DOCTYPE html> | ||
|
|
||
| <head> | ||
| <meta charset="utf-8"> | ||
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> | ||
| <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> | ||
| <link href="css/bootstrap.min.css" rel="stylesheet"> | ||
| <link href="css/dashboard.css" rel="stylesheet"> | ||
| <script type="text/javascript" src="js/date_time.js"></script> | ||
|
|
||
| <script> | ||
| function confirmGo(m, u) { | ||
| if (confirm(m)) { | ||
| window.location = u; | ||
| } | ||
| } | ||
| </script> | ||
| <title>Pulse | Queue</title> | ||
| <% | ||
| response.setIntHeader("Refresh", 10); | ||
| %> | ||
| </head> | ||
|
|
||
| <body> | ||
|
|
||
| <nav class="navbar navbar-inverse navbar-fixed-top"> | ||
| <div class="container-fluid"> | ||
| <div class="navbar-header"> | ||
| <button type="button" class="navbar-toggle collapsed" | ||
| data-toggle="collapse" data-target="#navbar" aria-expanded="false" | ||
| aria-controls="navbar"> | ||
| <span class="sr-only">Toggle navigation</span> <span | ||
| class="icon-bar"></span> <span class="icon-bar"></span> <span | ||
| class="icon-bar"></span> | ||
| </button> | ||
| <a class="navbar-brand" href="ReceptionistHome.jsp"><i><strong>Pulse</strong></i></a> | ||
| </div> | ||
| <div id="navbar" class="navbar-collapse collapse"> | ||
| <ul class="nav navbar-nav navbar-right"> | ||
| <li><a href="doctorhome.jsp">History</a></li> | ||
| <li><a href="#">Settings</a></li> | ||
| <li><a href="#">Profile</a></li> | ||
| <li><a href="#">Help</a></li> | ||
| <li><a href="ReceptionistHome.jsp">Home</a></li> | ||
| </ul> | ||
| <form class="navbar-form navbar-right"> | ||
| <input type="text" class="form-control" placeholder="Search..."> | ||
| </form> | ||
| </div> | ||
| </div> | ||
| </nav> | ||
| <div class="row"> | ||
| <div class="container col-xs-3 col-xs-2 sidebar"> | ||
| <ul class="nav nav-sidebar"> | ||
| <li class="active"><a href="#">Overview <span | ||
| class="sr-only">(current)</span></a></li> | ||
| <li><a href="#">Reports</a></li> | ||
| <li><a href="#">Analytics</a></li> | ||
| <li><a href="#">Export</a></li> | ||
| </ul> | ||
|
|
||
|
|
||
| </div> | ||
| </div> | ||
| <div class="container"> | ||
| <h2 class="sub-header pull-left"> | ||
| History | ||
| <h2 class="sub-header pull-right"> | ||
| <span id="date_time"></span> | ||
| <script type="text/javascript"> | ||
| window.onload = date_time('date_time'); | ||
| </script> | ||
| </h2> | ||
| </h2> | ||
| </div> | ||
| <div | ||
| class="table-responsive col-md-8 col-lg-8 col-lg-offset-2 col-md-offset-1"> | ||
| <table class="table table-responsive table-striped table-hover"> | ||
| <thead> | ||
| <tr> | ||
| <th>Reg.Number</th> | ||
| <th>First Name</th> | ||
| <th>Last Name</th> | ||
| <th>Gender</th> | ||
| </tr> | ||
| </thead> | ||
| <tbody> | ||
|
|
||
| <c:forEach var="student" items="${result.rows}"> | ||
| <tr> | ||
| <td><a | ||
| href="diagnosis.jsp?regNumber=<c:out value="${student.regNumber}"/>"><c:out | ||
| value="${student.regNumber}" /></a></td> | ||
| <td><c:out value="${student.firstName}" /></td> | ||
| <td><c:out value="${student.lastName}" /></td> | ||
| <td><c:out value="${student.gender}" /></td> | ||
| <td><a class="btn btn-danger btn-sm" | ||
| href="javascript:confirmGo('Sure to dequeue this patient?','delete.jsp?regNumber=<c:out value="${student.regNumber}"/>')">DeQueue</a></td> | ||
| </tr> | ||
| </c:forEach> | ||
| </table> | ||
| </body> | ||
| </html> |
| @@ -0,0 +1,16 @@ | ||
| // Bordered & Pulled | ||
| // ------------------------- | ||
|
|
||
| .@{fa-css-prefix}-border { | ||
| padding: .2em .25em .15em; | ||
| border: solid .08em @fa-border-color; | ||
| border-radius: .1em; | ||
| } | ||
|
|
||
| .pull-right { float: right; } | ||
| .pull-left { float: left; } | ||
|
|
||
| .@{fa-css-prefix} { | ||
| &.pull-left { margin-right: .3em; } | ||
| &.pull-right { margin-left: .3em; } | ||
| } |
| @@ -0,0 +1,11 @@ | ||
| // Base Class Definition | ||
| // ------------------------- | ||
|
|
||
| .@{fa-css-prefix} { | ||
| display: inline-block; | ||
| font: normal normal normal 14px/1 FontAwesome; // shortening font declaration | ||
| font-size: inherit; // can't have font-size inherit on line above, so need to override | ||
| text-rendering: auto; // optimizelegibility throws things off #1094 | ||
| -webkit-font-smoothing: antialiased; | ||
| -moz-osx-font-smoothing: grayscale; | ||
| } |
| @@ -0,0 +1,6 @@ | ||
| // Fixed Width Icons | ||
| // ------------------------- | ||
| .@{fa-css-prefix}-fw { | ||
| width: (18em / 14); | ||
| text-align: center; | ||
| } |
| @@ -0,0 +1,17 @@ | ||
| /*! | ||
| * Font Awesome 4.2.0 by @davegandy - http://fontawesome.io - @fontawesome | ||
| * License - http://fontawesome.io/license (Font: SIL OFL 1.1, CSS: MIT License) | ||
| */ | ||
|
|
||
| @import "variables.less"; | ||
| @import "mixins.less"; | ||
| @import "path.less"; | ||
| @import "core.less"; | ||
| @import "larger.less"; | ||
| @import "fixed-width.less"; | ||
| @import "list.less"; | ||
| @import "bordered-pulled.less"; | ||
| @import "spinning.less"; | ||
| @import "rotated-flipped.less"; | ||
| @import "stacked.less"; | ||
| @import "icons.less"; |
| @@ -0,0 +1,13 @@ | ||
| // Icon Sizes | ||
| // ------------------------- | ||
|
|
||
| /* makes the font 33% larger relative to the icon container */ | ||
| .@{fa-css-prefix}-lg { | ||
| font-size: (4em / 3); | ||
| line-height: (3em / 4); | ||
| vertical-align: -15%; | ||
| } | ||
| .@{fa-css-prefix}-2x { font-size: 2em; } | ||
| .@{fa-css-prefix}-3x { font-size: 3em; } | ||
| .@{fa-css-prefix}-4x { font-size: 4em; } | ||
| .@{fa-css-prefix}-5x { font-size: 5em; } |
| @@ -0,0 +1,19 @@ | ||
| // List Icons | ||
| // ------------------------- | ||
|
|
||
| .@{fa-css-prefix}-ul { | ||
| padding-left: 0; | ||
| margin-left: @fa-li-width; | ||
| list-style-type: none; | ||
| > li { position: relative; } | ||
| } | ||
| .@{fa-css-prefix}-li { | ||
| position: absolute; | ||
| left: -@fa-li-width; | ||
| width: @fa-li-width; | ||
| top: (2em / 14); | ||
| text-align: center; | ||
| &.@{fa-css-prefix}-lg { | ||
| left: (-@fa-li-width + (4em / 14)); | ||
| } | ||
| } |
| @@ -0,0 +1,25 @@ | ||
| // Mixins | ||
| // -------------------------- | ||
|
|
||
| .fa-icon() { | ||
| display: inline-block; | ||
| font: normal normal normal 14px/1 FontAwesome; // shortening font declaration | ||
| font-size: inherit; // can't have font-size inherit on line above, so need to override | ||
| text-rendering: auto; // optimizelegibility throws things off #1094 | ||
| -webkit-font-smoothing: antialiased; | ||
| -moz-osx-font-smoothing: grayscale; | ||
| } | ||
|
|
||
| .fa-icon-rotate(@degrees, @rotation) { | ||
| filter: progid:DXImageTransform.Microsoft.BasicImage(rotation=@rotation); | ||
| -webkit-transform: rotate(@degrees); | ||
| -ms-transform: rotate(@degrees); | ||
| transform: rotate(@degrees); | ||
| } | ||
|
|
||
| .fa-icon-flip(@horiz, @vert, @rotation) { | ||
| filter: progid:DXImageTransform.Microsoft.BasicImage(rotation=@rotation, mirror=1); | ||
| -webkit-transform: scale(@horiz, @vert); | ||
| -ms-transform: scale(@horiz, @vert); | ||
| transform: scale(@horiz, @vert); | ||
| } |
| @@ -0,0 +1,14 @@ | ||
| /* FONT PATH | ||
| * -------------------------- */ | ||
|
|
||
| @font-face { | ||
| font-family: 'FontAwesome'; | ||
| src: url('@{fa-font-path}/fontawesome-webfont.eot?v=@{fa-version}'); | ||
| src: url('@{fa-font-path}/fontawesome-webfont.eot?#iefix&v=@{fa-version}') format('embedded-opentype'), | ||
| url('@{fa-font-path}/fontawesome-webfont.woff?v=@{fa-version}') format('woff'), | ||
| url('@{fa-font-path}/fontawesome-webfont.ttf?v=@{fa-version}') format('truetype'), | ||
| url('@{fa-font-path}/fontawesome-webfont.svg?v=@{fa-version}#fontawesomeregular') format('svg'); | ||
| // src: url('@{fa-font-path}/FontAwesome.otf') format('opentype'); // used when developing fonts | ||
| font-weight: normal; | ||
| font-style: normal; | ||
| } |
| @@ -0,0 +1,20 @@ | ||
| // Rotated & Flipped Icons | ||
| // ------------------------- | ||
|
|
||
| .@{fa-css-prefix}-rotate-90 { .fa-icon-rotate(90deg, 1); } | ||
| .@{fa-css-prefix}-rotate-180 { .fa-icon-rotate(180deg, 2); } | ||
| .@{fa-css-prefix}-rotate-270 { .fa-icon-rotate(270deg, 3); } | ||
|
|
||
| .@{fa-css-prefix}-flip-horizontal { .fa-icon-flip(-1, 1, 0); } | ||
| .@{fa-css-prefix}-flip-vertical { .fa-icon-flip(1, -1, 2); } | ||
|
|
||
| // Hook for IE8-9 | ||
| // ------------------------- | ||
|
|
||
| :root .@{fa-css-prefix}-rotate-90, | ||
| :root .@{fa-css-prefix}-rotate-180, | ||
| :root .@{fa-css-prefix}-rotate-270, | ||
| :root .@{fa-css-prefix}-flip-horizontal, | ||
| :root .@{fa-css-prefix}-flip-vertical { | ||
| filter: none; | ||
| } |
| @@ -0,0 +1,29 @@ | ||
| // Spinning Icons | ||
| // -------------------------- | ||
|
|
||
| .@{fa-css-prefix}-spin { | ||
| -webkit-animation: fa-spin 2s infinite linear; | ||
| animation: fa-spin 2s infinite linear; | ||
| } | ||
|
|
||
| @-webkit-keyframes fa-spin { | ||
| 0% { | ||
| -webkit-transform: rotate(0deg); | ||
| transform: rotate(0deg); | ||
| } | ||
| 100% { | ||
| -webkit-transform: rotate(359deg); | ||
| transform: rotate(359deg); | ||
| } | ||
| } | ||
|
|
||
| @keyframes fa-spin { | ||
| 0% { | ||
| -webkit-transform: rotate(0deg); | ||
| transform: rotate(0deg); | ||
| } | ||
| 100% { | ||
| -webkit-transform: rotate(359deg); | ||
| transform: rotate(359deg); | ||
| } | ||
| } |
| @@ -0,0 +1,20 @@ | ||
| // Stacked Icons | ||
| // ------------------------- | ||
|
|
||
| .@{fa-css-prefix}-stack { | ||
| position: relative; | ||
| display: inline-block; | ||
| width: 2em; | ||
| height: 2em; | ||
| line-height: 2em; | ||
| vertical-align: middle; | ||
| } | ||
| .@{fa-css-prefix}-stack-1x, .@{fa-css-prefix}-stack-2x { | ||
| position: absolute; | ||
| left: 0; | ||
| width: 100%; | ||
| text-align: center; | ||
| } | ||
| .@{fa-css-prefix}-stack-1x { line-height: inherit; } | ||
| .@{fa-css-prefix}-stack-2x { font-size: 2em; } | ||
| .@{fa-css-prefix}-inverse { color: @fa-inverse; } |
| @@ -0,0 +1,16 @@ | ||
| // Bordered & Pulled | ||
| // ------------------------- | ||
|
|
||
| .#{$fa-css-prefix}-border { | ||
| padding: .2em .25em .15em; | ||
| border: solid .08em $fa-border-color; | ||
| border-radius: .1em; | ||
| } | ||
|
|
||
| .pull-right { float: right; } | ||
| .pull-left { float: left; } | ||
|
|
||
| .#{$fa-css-prefix} { | ||
| &.pull-left { margin-right: .3em; } | ||
| &.pull-right { margin-left: .3em; } | ||
| } |
| @@ -0,0 +1,11 @@ | ||
| // Base Class Definition | ||
| // ------------------------- | ||
|
|
||
| .#{$fa-css-prefix} { | ||
| display: inline-block; | ||
| font: normal normal normal 14px/1 FontAwesome; // shortening font declaration | ||
| font-size: inherit; // can't have font-size inherit on line above, so need to override | ||
| text-rendering: auto; // optimizelegibility throws things off #1094 | ||
| -webkit-font-smoothing: antialiased; | ||
| -moz-osx-font-smoothing: grayscale; | ||
| } |
| @@ -0,0 +1,6 @@ | ||
| // Fixed Width Icons | ||
| // ------------------------- | ||
| .#{$fa-css-prefix}-fw { | ||
| width: (18em / 14); | ||
| text-align: center; | ||
| } |
| @@ -0,0 +1,13 @@ | ||
| // Icon Sizes | ||
| // ------------------------- | ||
|
|
||
| /* makes the font 33% larger relative to the icon container */ | ||
| .#{$fa-css-prefix}-lg { | ||
| font-size: (4em / 3); | ||
| line-height: (3em / 4); | ||
| vertical-align: -15%; | ||
| } | ||
| .#{$fa-css-prefix}-2x { font-size: 2em; } | ||
| .#{$fa-css-prefix}-3x { font-size: 3em; } | ||
| .#{$fa-css-prefix}-4x { font-size: 4em; } | ||
| .#{$fa-css-prefix}-5x { font-size: 5em; } |
| @@ -0,0 +1,19 @@ | ||
| // List Icons | ||
| // ------------------------- | ||
|
|
||
| .#{$fa-css-prefix}-ul { | ||
| padding-left: 0; | ||
| margin-left: $fa-li-width; | ||
| list-style-type: none; | ||
| > li { position: relative; } | ||
| } | ||
| .#{$fa-css-prefix}-li { | ||
| position: absolute; | ||
| left: -$fa-li-width; | ||
| width: $fa-li-width; | ||
| top: (2em / 14); | ||
| text-align: center; | ||
| &.#{$fa-css-prefix}-lg { | ||
| left: -$fa-li-width + (4em / 14); | ||
| } | ||
| } |
| @@ -0,0 +1,25 @@ | ||
| // Mixins | ||
| // -------------------------- | ||
|
|
||
| @mixin fa-icon() { | ||
| display: inline-block; | ||
| font: normal normal normal 14px/1 FontAwesome; // shortening font declaration | ||
| font-size: inherit; // can't have font-size inherit on line above, so need to override | ||
| text-rendering: auto; // optimizelegibility throws things off #1094 | ||
| -webkit-font-smoothing: antialiased; | ||
| -moz-osx-font-smoothing: grayscale; | ||
| } | ||
|
|
||
| @mixin fa-icon-rotate($degrees, $rotation) { | ||
| filter: progid:DXImageTransform.Microsoft.BasicImage(rotation=#{$rotation}); | ||
| -webkit-transform: rotate($degrees); | ||
| -ms-transform: rotate($degrees); | ||
| transform: rotate($degrees); | ||
| } | ||
|
|
||
| @mixin fa-icon-flip($horiz, $vert, $rotation) { | ||
| filter: progid:DXImageTransform.Microsoft.BasicImage(rotation=#{$rotation}); | ||
| -webkit-transform: scale($horiz, $vert); | ||
| -ms-transform: scale($horiz, $vert); | ||
| transform: scale($horiz, $vert); | ||
| } |
| @@ -0,0 +1,14 @@ | ||
| /* FONT PATH | ||
| * -------------------------- */ | ||
|
|
||
| @font-face { | ||
| font-family: 'FontAwesome'; | ||
| src: url('#{$fa-font-path}/fontawesome-webfont.eot?v=#{$fa-version}'); | ||
| src: url('#{$fa-font-path}/fontawesome-webfont.eot?#iefix&v=#{$fa-version}') format('embedded-opentype'), | ||
| url('#{$fa-font-path}/fontawesome-webfont.woff?v=#{$fa-version}') format('woff'), | ||
| url('#{$fa-font-path}/fontawesome-webfont.ttf?v=#{$fa-version}') format('truetype'), | ||
| url('#{$fa-font-path}/fontawesome-webfont.svg?v=#{$fa-version}#fontawesomeregular') format('svg'); | ||
| //src: url('#{$fa-font-path}/FontAwesome.otf') format('opentype'); // used when developing fonts | ||
| font-weight: normal; | ||
| font-style: normal; | ||
| } |
| @@ -0,0 +1,20 @@ | ||
| // Rotated & Flipped Icons | ||
| // ------------------------- | ||
|
|
||
| .#{$fa-css-prefix}-rotate-90 { @include fa-icon-rotate(90deg, 1); } | ||
| .#{$fa-css-prefix}-rotate-180 { @include fa-icon-rotate(180deg, 2); } | ||
| .#{$fa-css-prefix}-rotate-270 { @include fa-icon-rotate(270deg, 3); } | ||
|
|
||
| .#{$fa-css-prefix}-flip-horizontal { @include fa-icon-flip(-1, 1, 0); } | ||
| .#{$fa-css-prefix}-flip-vertical { @include fa-icon-flip(1, -1, 2); } | ||
|
|
||
| // Hook for IE8-9 | ||
| // ------------------------- | ||
|
|
||
| :root .#{$fa-css-prefix}-rotate-90, | ||
| :root .#{$fa-css-prefix}-rotate-180, | ||
| :root .#{$fa-css-prefix}-rotate-270, | ||
| :root .#{$fa-css-prefix}-flip-horizontal, | ||
| :root .#{$fa-css-prefix}-flip-vertical { | ||
| filter: none; | ||
| } |
| @@ -0,0 +1,29 @@ | ||
| // Spinning Icons | ||
| // -------------------------- | ||
|
|
||
| .#{$fa-css-prefix}-spin { | ||
| -webkit-animation: fa-spin 2s infinite linear; | ||
| animation: fa-spin 2s infinite linear; | ||
| } | ||
|
|
||
| @-webkit-keyframes fa-spin { | ||
| 0% { | ||
| -webkit-transform: rotate(0deg); | ||
| transform: rotate(0deg); | ||
| } | ||
| 100% { | ||
| -webkit-transform: rotate(359deg); | ||
| transform: rotate(359deg); | ||
| } | ||
| } | ||
|
|
||
| @keyframes fa-spin { | ||
| 0% { | ||
| -webkit-transform: rotate(0deg); | ||
| transform: rotate(0deg); | ||
| } | ||
| 100% { | ||
| -webkit-transform: rotate(359deg); | ||
| transform: rotate(359deg); | ||
| } | ||
| } |
| @@ -0,0 +1,20 @@ | ||
| // Stacked Icons | ||
| // ------------------------- | ||
|
|
||
| .#{$fa-css-prefix}-stack { | ||
| position: relative; | ||
| display: inline-block; | ||
| width: 2em; | ||
| height: 2em; | ||
| line-height: 2em; | ||
| vertical-align: middle; | ||
| } | ||
| .#{$fa-css-prefix}-stack-1x, .#{$fa-css-prefix}-stack-2x { | ||
| position: absolute; | ||
| left: 0; | ||
| width: 100%; | ||
| text-align: center; | ||
| } | ||
| .#{$fa-css-prefix}-stack-1x { line-height: inherit; } | ||
| .#{$fa-css-prefix}-stack-2x { font-size: 2em; } | ||
| .#{$fa-css-prefix}-inverse { color: $fa-inverse; } |
| @@ -0,0 +1,17 @@ | ||
| /*! | ||
| * Font Awesome 4.2.0 by @davegandy - http://fontawesome.io - @fontawesome | ||
| * License - http://fontawesome.io/license (Font: SIL OFL 1.1, CSS: MIT License) | ||
| */ | ||
|
|
||
| @import "variables"; | ||
| @import "mixins"; | ||
| @import "path"; | ||
| @import "core"; | ||
| @import "larger"; | ||
| @import "fixed-width"; | ||
| @import "list"; | ||
| @import "bordered-pulled"; | ||
| @import "spinning"; | ||
| @import "rotated-flipped"; | ||
| @import "stacked"; | ||
| @import "icons"; |
| @@ -0,0 +1,107 @@ | ||
| <%@ page language="java" contentType="text/html; charset=UTF-8" | ||
| pageEncoding="UTF-8"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> | ||
| <%@ page session="true"%> | ||
| <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> | ||
| <html> | ||
| <head> | ||
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> | ||
| <title>Pulse | Diagnosis & Prescription</title> | ||
| <link href="css/bootstrap.min.css" rel="stylesheet"> | ||
|
|
||
| <link href="font-awesome/css/font-awesome.min.css" rel="stylesheet"> | ||
| <script> | ||
| function confirmGo(m, u) { | ||
| if (confirm(m)) { | ||
| window.location = u; | ||
| } | ||
| } | ||
| </script> | ||
|
|
||
| <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" | ||
| url="jdbc:mysql://localhost/Stude" user="root" password=" " /> | ||
|
|
||
| <sql:query dataSource="${snapshot}" var="result"> | ||
| select * from ChemistQueue where regNumber = ? | ||
| <sql:param value="${param.regNumber}"></sql:param> | ||
|
|
||
| </sql:query> | ||
| </head> | ||
| <body> | ||
|
|
||
| <nav class="navbar navbar-inverse navbar-fixed-top"> | ||
| <div class="container-fluid"> | ||
| <div class="navbar-header"> | ||
| <button type="button" class="navbar-toggle collapsed" | ||
| data-toggle="collapse" data-target="#navbar" aria-expanded="false" | ||
| aria-controls="navbar"> | ||
| <span class="sr-only">Toggle navigation</span> <span | ||
| class="icon-bar"></span> <span class="icon-bar"></span> <span | ||
| class="icon-bar"></span> | ||
| </button> | ||
| <a class="navbar-brand" href="index.jsp"><i | ||
| class="fa fa-fw fa-lg fa-heartbeat" style="color: white"></i></a> | ||
| </div> | ||
| <div id="navbar" class="navbar-collapse collapse"> | ||
| <ul class="nav navbar-nav navbar-right"> | ||
| <li><a href="doctorhome.jsp">Back</a></li> | ||
| <li><a href="#">Settings</a></li> | ||
| <li><a href="#">Profile</a></li> | ||
| <li><a href="#">Help</a></li> | ||
| </ul> | ||
| <form class="navbar-form navbar-right"> | ||
| <input type="text" class="form-control" placeholder="Search Reg No." | ||
| name="regNumber"> | ||
| </form> | ||
| </div> | ||
| </div> | ||
| </nav> | ||
|
|
||
| <div class="container"> | ||
|
|
||
| <div class="col-sm-6 col-sm-offset-3"> | ||
| <div class=""> | ||
| <h2 class="sub-header pull-left"> | ||
| <br> These are the Medical records for the Patient | ||
| <c:forEach var="student" items="${result.rows}"> | ||
| <c:out value="${student.regNumber}" /> at <c:out | ||
| value="${student.time}" /> | ||
| </c:forEach> | ||
| <br> | ||
| </h2> | ||
|
|
||
|
|
||
| </div> | ||
|
|
||
| <div> | ||
| <form method="POST"> | ||
| <div class="form-group"> | ||
| <label for="Diagnosis">Diagnosis</label> | ||
| <textarea class="form-control" rows="5" id="diagnosis" | ||
| name="diagnosis" value="${student.diagnosis}" readonly> | ||
| <c:forEach var="student" items="${result.rows}"> | ||
| <c:out value="${student.diagnosis}" /> | ||
| </c:forEach> | ||
| </textarea> | ||
|
|
||
| </div> | ||
| <br> <br> | ||
| <div class="form-group"> | ||
| <label for="Prescription">Prescription</label> | ||
| <textarea class="form-control" rows="5" id="prescription" | ||
| name="prescription" value="${student.prescription}" readonly> | ||
| <c:forEach var="student" items="${result.rows}"> | ||
| <c:out value="${student.prescription}" /> | ||
| </c:forEach></textarea> | ||
|
|
||
| </div> | ||
|
|
||
|
|
||
| </form> | ||
|
|
||
| </div> | ||
| </div> | ||
| </div> | ||
| </body> | ||
| </html> |
| @@ -0,0 +1,100 @@ | ||
| <%@ page session="true" pageEncoding="UTF-8"%> | ||
| <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> | ||
|
|
||
| <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" | ||
| url="jdbc:mysql://localhost/Stude" user="root" password=" " /> | ||
|
|
||
|
|
||
| <sql:query dataSource="${snapshot}" var="result"> | ||
| SELECT * from ChemistQueue order by time; | ||
| </sql:query> | ||
|
|
||
| <html> | ||
|
|
||
| <head> | ||
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> | ||
| <link href="css/bootstrap.min.css" rel="stylesheet"> | ||
| <link href="css/dashboard.css" rel="stylesheet"> | ||
|
|
||
| <script type="text/javascript" src="js/date_time.js"></script> | ||
| <title>Pulse | Queue</title> | ||
| <% | ||
| response.setIntHeader("Refresh", 10); | ||
| %> | ||
| </head> | ||
|
|
||
| <body> | ||
|
|
||
| <nav class="navbar navbar-inverse navbar-fixed-top"> | ||
| <div class="container-fluid"> | ||
| <div class="navbar-header"> | ||
| <button type="button" class="navbar-toggle collapsed" | ||
| data-toggle="collapse" data-target="#navbar" aria-expanded="false" | ||
| aria-controls="navbar"> | ||
| <span class="sr-only">Toggle navigation</span> <span | ||
| class="icon-bar"></span> <span class="icon-bar"></span> <span | ||
| class="icon-bar"></span> | ||
| </button> | ||
| <a class="navbar-brand" href="ReceptionistHome.jsp"><i><strong>Pulse</strong></i></a> | ||
| </div> | ||
| <div id="navbar" class="navbar-collapse collapse"> | ||
| <ul class="nav navbar-nav navbar-right"> | ||
| <li><a href="doctorhome.jsp">Main</a></li> | ||
| <li><a href="#">Settings</a></li> | ||
| <li><a href="#">Profile</a></li> | ||
| <li><a href="#">Help</a></li> | ||
| <li><a href="ReceptionistHome.jsp">Home</a></li> | ||
| </ul> | ||
| <form class="navbar-form navbar-right"> | ||
| <input type="text" class="form-control" placeholder="Search..."> | ||
| </form> | ||
| </div> | ||
| </div> | ||
| </nav> | ||
| <div class="row"> | ||
| <div class="col-sm-3 col-md-2 sidebar"> | ||
| <ul class="nav nav-sidebar"> | ||
| <li class="active"><a href="#">Overview <span | ||
| class="sr-only">(current)</span></a></li> | ||
| <li><a href="#">Reports</a></li> | ||
| <li><a href="#">Analytics</a></li> | ||
| <li><a href="#">Export</a></li> | ||
| </ul> | ||
|
|
||
|
|
||
| </div> | ||
| </div> | ||
| <div class="col-sm-8 col-sm-offset-3"> | ||
| <h2 class="sub-header pull-left"> | ||
| Todays Queue: | ||
| <h2 class="sub-header pull-right"> | ||
| <span id="date_time"></span> | ||
| <script type="text/javascript"> | ||
| window.onload = date_time('date_time'); | ||
| </script> | ||
| </h2> | ||
| </h2> | ||
| </div> | ||
| <div class="table-responsive col-sm-8 col-sm-offset-2"> | ||
| <table class="table table-striped table-hover"> | ||
| <thead> | ||
| <tr> | ||
| <th>Reg. Number</th> | ||
| <th>Time</th> | ||
| </tr> | ||
| </thead> | ||
| <tbody> | ||
|
|
||
| <c:forEach var="student" items="${result.rows}"> | ||
| <tr> | ||
|
|
||
| <td><c:out value="${student.regNumber}" /></td> | ||
|
|
||
| <td><a href='history.jsp?regNumber=<c:out value="${student.regNumber}" />'><c:out value="${student.time}" /></a></td> | ||
|
|
||
| </tr> | ||
| </c:forEach> | ||
| </table> | ||
| </body> | ||
| </html> |
| @@ -0,0 +1,133 @@ | ||
| <%@ page language="java" contentType="text/html; charset=UTF-8" | ||
| pageEncoding="UTF-8"%> | ||
| <%@ page session="false" %> | ||
| <!DOCTYPE html> | ||
| <html lang="en"> | ||
| <head> | ||
| <meta charset="utf-8"> | ||
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> | ||
| <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
| <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags --> | ||
| <meta name="description" content=""> | ||
| <meta name="author" content="Shalom Nyendes"> | ||
|
|
||
|
|
||
| <title>Pulse | Egerton UniversityMedicalDepartment</title> | ||
|
|
||
| <!-- Bootstrap core CSS --> | ||
| <link href="css/bootstrap.min.css" rel="stylesheet"> | ||
|
|
||
| <!-- IE10 viewport hack for Surface/desktop Windows 8 bug --> | ||
| <link href="../../assets/css/ie10-viewport-bug-workaround.css" | ||
| rel="stylesheet"> | ||
|
|
||
| <!-- Custom styles for this template --> | ||
| <link href="css/cover.css" rel="stylesheet"> | ||
| <link href="css/signin.css" rel="stylesheet"> | ||
|
|
||
| <style> | ||
| body { | ||
| background: url(images/pulse_line.jpg) no-repeat center center fixed; | ||
| -webkit-background-size: cover; | ||
| -moz-background-size: cover; | ||
| -o-background-size: cover; | ||
| } | ||
| </style> | ||
|
|
||
|
|
||
| </head> | ||
|
|
||
| <body> | ||
| <div class="site-wrapper"> | ||
|
|
||
| <div class="site-wrapper-inner"> | ||
|
|
||
| <div class="cover-container"> | ||
|
|
||
| <div class="masthead clearfix"> | ||
| <div class="inner"> | ||
| <h3 class="masthead-brand">Pulse</h3> | ||
| <nav> | ||
| <ul class="nav masthead-nav"> | ||
| <li class="active"><a href="#">About</a></li> | ||
| <li><a href="#">Services</a></li> | ||
| <li><a href="#">Privacy</a></li> | ||
| <li><a href="#">T&C</a></li> | ||
| <li><a href="Developers.jsp">{{ Credits }}</a></li> | ||
| </ul> | ||
| </nav> | ||
| </div> | ||
| </div> | ||
|
|
||
|
|
||
| <div class="inner cover"> | ||
|
|
||
| <div class="col-md-8 col-md-offset-3"> | ||
| <div class="panel panel-default"> | ||
| <div class="panel-heading"> | ||
| <% | ||
| if (request.getAttribute("errors") != null) { | ||
| %> | ||
| <div> | ||
| <p>Ensure you input a valid username and password to login</p> | ||
| </div> | ||
| <% | ||
| } | ||
| %> | ||
| <h3 class="panel-title">Check In</h3> | ||
| </div> | ||
| <div class="panel-body"> | ||
| <form method="POST" role="form" action="Login"> | ||
| <fieldset> | ||
| <div class="form-group"> | ||
| <input class="form-control" placeholder="Username" | ||
| name="username" type="text"> | ||
| </div> | ||
| <div class="form-group"> | ||
| <input class="form-control" placeholder="Password" | ||
| name="password" type="password" value=""> | ||
| </div> | ||
|
|
||
| <input class="btn btn-lg btn-success btn-block" type="submit" | ||
| value="Login"> | ||
|
|
||
| </fieldset> | ||
| </form> | ||
| </div> | ||
| </div> | ||
| </div> | ||
|
|
||
| </div> | ||
|
|
||
| <div class="mastfoot"> | ||
| <div class="inner"> | ||
| <p class="lead small"> | ||
| <i>Pulse © 2016 - Transforming Lives Through Proper | ||
| Health Care. An Affiliate of <a href="http://www.egerton.ac.ke">Egerton | ||
| University</a> | ||
| </i> | ||
| </p> | ||
| </div> | ||
| </div> | ||
|
|
||
| </div> | ||
|
|
||
| </div> | ||
|
|
||
| </div> | ||
|
|
||
| <!-- Bootstrap core JavaScript | ||
| ================================================== --> | ||
| <!-- Placed at the end of the document so the pages load faster --> | ||
| <script | ||
| src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script> | ||
| <script> | ||
| window.jQuery | ||
| || document | ||
| .write('<script src="../../assets/js/vendor/jquery.min.js"><\/script>') | ||
| </script> | ||
| <script src="js/bootstrap.min.js"></script> | ||
|
|
||
| <script src="../../assets/js/ie10-viewport-bug-workaround.js"></script> | ||
| </body> | ||
| </html> |
| @@ -0,0 +1,28 @@ | ||
| function date_time(id) { | ||
| date = new Date; | ||
| year = date.getFullYear(); | ||
| month = date.getMonth(); | ||
| months = new Array('January', 'February', 'March', 'April', 'May', 'June', | ||
| 'Jully', 'August', 'September', 'October', 'November', 'December'); | ||
| d = date.getDate(); | ||
| day = date.getDay(); | ||
| days = new Array('Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', | ||
| 'Friday', 'Saturday'); | ||
| h = date.getHours(); | ||
| if (h < 10) { | ||
| h = "0" + h; | ||
| } | ||
| m = date.getMinutes(); | ||
| if (m < 10) { | ||
| m = "0" + m; | ||
| } | ||
| s = date.getSeconds(); | ||
| if (s < 10) { | ||
| s = "0" + s; | ||
| } | ||
| result = '' + days[day] + ' ' + months[month] + ', ' + d + ' ' + year + ' ' | ||
| + h + ':' + m + ':' + s; | ||
| document.getElementById(id).innerHTML = result; | ||
| setTimeout('date_time("' + id + '");', '1000'); | ||
| return true; | ||
| } |
| @@ -0,0 +1,13 @@ | ||
| // This file is autogenerated via the `commonjs` Grunt task. You can require() this file in a CommonJS environment. | ||
| require('../../js/transition.js') | ||
| require('../../js/alert.js') | ||
| require('../../js/button.js') | ||
| require('../../js/carousel.js') | ||
| require('../../js/collapse.js') | ||
| require('../../js/dropdown.js') | ||
| require('../../js/modal.js') | ||
| require('../../js/tooltip.js') | ||
| require('../../js/popover.js') | ||
| require('../../js/scrollspy.js') | ||
| require('../../js/tab.js') | ||
| require('../../js/affix.js') |
| @@ -0,0 +1,106 @@ | ||
| <%@ page session="true" pageEncoding="UTF-8"%> | ||
| <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> | ||
| <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> | ||
|
|
||
| <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" | ||
| url="jdbc:mysql://localhost/Stude" user="root" password=" " /> | ||
|
|
||
|
|
||
| <sql:query dataSource="${snapshot}" var="result"> | ||
| SELECT prescription from ChemistQueue where regNumber = ? | ||
| <sql:param value="${param.regNumber}"></sql:param> | ||
| </sql:query> | ||
|
|
||
|
|
||
| <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> | ||
| <html> | ||
| <head> | ||
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> | ||
| <title>Pulse | Pharmacy</title> | ||
|
|
||
| <link href="css/bootstrap.min.css" rel="stylesheet"> | ||
|
|
||
| <link href="font-awesome/css/font-awesome.min.css" rel="stylesheet"> | ||
| <script> | ||
| function confirmGo(m, u) { | ||
| if (confirm(m)) { | ||
| window.location = u; | ||
| } | ||
| } | ||
| </script> | ||
|
|
||
| </head> | ||
| <body> | ||
|
|
||
| <nav class="navbar navbar-inverse navbar-fixed-top"> | ||
| <div class="container-fluid"> | ||
| <div class="navbar-header"> | ||
| <button type="button" class="navbar-toggle collapsed" | ||
| data-toggle="collapse" data-target="#navbar" aria-expanded="false" | ||
| aria-controls="navbar"> | ||
| <span class="sr-only">Toggle navigation</span> <span | ||
| class="icon-bar"></span> <span class="icon-bar"></span> <span | ||
| class="icon-bar"></span> | ||
| </button> | ||
| <a class="navbar-brand" href="index.jsp"><i | ||
| class="fa fa-fw fa-lg fa-heartbeat" style="color: white"></i></a> | ||
| </div> | ||
| <div id="navbar" class="navbar-collapse collapse"> | ||
| <ul class="nav navbar-nav navbar-right"> | ||
| <li><a href="pharmacy.jsp">Back To ChemistQueue</a></li> | ||
| <li><a href="#">Settings</a></li> | ||
| <li><a href="#">Profile</a></li> | ||
| <li><a href="#">Help</a></li> | ||
| </ul> | ||
| <form class="navbar-form navbar-right"> | ||
| <input type="text" class="form-control" placeholder="Search Reg No." | ||
| name="regNumber"> | ||
| </form> | ||
| </div> | ||
| </div> | ||
| </nav> | ||
|
|
||
| <div class="container"> | ||
|
|
||
| <div class="col-sm-6 col-sm-offset-3"> | ||
| <div class=""> | ||
| <h2 class="sub-header pull-left"> | ||
| <br> Please give the patient the following drugs<br> | ||
| </h2> | ||
|
|
||
|
|
||
| </div> | ||
|
|
||
| <div> | ||
| <form method="POST"> | ||
|
|
||
|
|
||
| <div class="form-group"> | ||
| <label for="Prescription">Prescription</label> | ||
|
|
||
| <textarea class="form-control" rows="5" id="prescription" | ||
| name="prescription" readonly> | ||
| <c:forEach var="student" items="${result.rows}"> | ||
| <c:out value="${student.prescription}" /> | ||
| </c:forEach> | ||
| </textarea> | ||
|
|
||
| </div> | ||
| <div> | ||
|
|
||
|
|
||
|
|
||
| <a class="btn btn-danger btn-sm" | ||
| href="javascript:confirmGo('Sure to dequeue this patient?','delChemist.jsp?regNumber=<c:out value="${param.regNumber}"/>')">DeQueue</a> | ||
|
|
||
|
|
||
| </div> | ||
|
|
||
|
|
||
| </form> | ||
|
|
||
| </div> | ||
| </div> | ||
| </div> | ||
| </body> | ||
| </html> |
| @@ -0,0 +1,33 @@ | ||
| JarIndex-Version: 1.0 | ||
|
|
||
| mysql-connector-java-5.1.40-bin.jar | ||
| com | ||
| com/mysql | ||
| com/mysql/fabric | ||
| com/mysql/fabric/hibernate | ||
| com/mysql/fabric/jdbc | ||
| com/mysql/fabric/proto | ||
| com/mysql/fabric/proto/xmlrpc | ||
| com/mysql/fabric/xmlrpc | ||
| com/mysql/fabric/xmlrpc/base | ||
| com/mysql/fabric/xmlrpc/exceptions | ||
| com/mysql/jdbc | ||
| com/mysql/jdbc/authentication | ||
| com/mysql/jdbc/configs | ||
| com/mysql/jdbc/exceptions | ||
| com/mysql/jdbc/exceptions/jdbc4 | ||
| com/mysql/jdbc/integration | ||
| com/mysql/jdbc/integration/c3p0 | ||
| com/mysql/jdbc/integration/jboss | ||
| com/mysql/jdbc/interceptors | ||
| com/mysql/jdbc/jdbc2 | ||
| com/mysql/jdbc/jdbc2/optional | ||
| com/mysql/jdbc/jmx | ||
| com/mysql/jdbc/log | ||
| com/mysql/jdbc/profiler | ||
| com/mysql/jdbc/util | ||
| org | ||
| org/gjt | ||
| org/gjt/mm | ||
| org/gjt/mm/mysql | ||
|
|
| @@ -0,0 +1,40 @@ | ||
| Manifest-Version: 1.0 | ||
| Ant-Version: Apache Ant 1.8.2 | ||
| Created-By: 1.5.0_22-b03 (Sun Microsystems Inc.) | ||
| Built-By: pb2user | ||
| Specification-Title: JDBC | ||
| Specification-Version: 4.2 | ||
| Specification-Vendor: Oracle Corporation | ||
| Implementation-Title: MySQL Connector Java | ||
| Implementation-Version: 5.1.40 | ||
| Implementation-Vendor-Id: com.mysql | ||
| Implementation-Vendor: Oracle | ||
| Bundle-Vendor: Oracle Corporation | ||
| Bundle-Classpath: . | ||
| Bundle-Version: 5.1.40 | ||
| Bundle-Name: Oracle Corporation's JDBC Driver for MySQL | ||
| Bundle-ManifestVersion: 2 | ||
| Bundle-SymbolicName: com.mysql.jdbc | ||
| Export-Package: com.mysql.jdbc;version="5.1.40";uses:="com.mysql.jdbc. | ||
| log,javax.naming,javax.net.ssl,javax.xml.transform,org.xml.sax",com.m | ||
| ysql.jdbc.jdbc2.optional;version="5.1.40";uses:="com.mysql.jdbc,com.m | ||
| ysql.jdbc.log,javax.naming,javax.sql,javax.transaction.xa",com.mysql. | ||
| jdbc.log;version="5.1.40",com.mysql.jdbc.profiler;version="5.1.40";us | ||
| es:="com.mysql.jdbc",com.mysql.jdbc.util;version="5.1.40";uses:="com. | ||
| mysql.jdbc.log",com.mysql.jdbc.exceptions;version="5.1.40",com.mysql. | ||
| jdbc.exceptions.jdbc4;version="5.1.40";uses:="com.mysql.jdbc",com.mys | ||
| ql.jdbc.interceptors;version="5.1.40";uses:="com.mysql.jdbc",com.mysq | ||
| l.jdbc.integration.c3p0;version="5.1.40",com.mysql.jdbc.integration.j | ||
| boss;version="5.1.40",com.mysql.jdbc.configs;version="5.1.40",org.gjt | ||
| .mm.mysql;version="5.1.40",com.mysql.fabric.jdbc;version="5.1.40";use | ||
| s:="com.mysql.jdbc" | ||
| Import-Package: javax.net,javax.net.ssl;version="[1.0.1, 2.0.0)";resol | ||
| ution:=optional,javax.xml.parsers, javax.xml.stream,javax.xml.transfo | ||
| rm,javax.xml.transform.dom,javax.xml.transform.sax,javax.xml.transfor | ||
| m.stax,javax.xml.transform.stream,org.w3c.dom,org.xml.sax,org.xml.sax | ||
| .helpers;resolution:=optional,javax.naming,javax.naming.spi,javax.sql | ||
| ,javax.transaction.xa;version="[1.0.1, 2.0.0)";resolution:=optional,c | ||
| om.mchange.v2.c3p0;version="[0.9.1.2, 1.0.0)";resolution:=optional,or | ||
| g.jboss.resource.adapter.jdbc;resolution:=optional,org.jboss.resource | ||
| .adapter.jdbc.vendor;resolution:=optional | ||
|
|
| @@ -0,0 +1,2 @@ | ||
| com.mysql.jdbc.Driver | ||
| com.mysql.fabric.jdbc.FabricMySQLDriver |
| @@ -0,0 +1,104 @@ | ||
| package com.SanProject.servlets; | ||
|
|
||
| import java.io.IOException; | ||
| import java.io.PrintWriter; | ||
| import java.sql.Connection; | ||
| import java.sql.DriverManager; | ||
| import java.sql.PreparedStatement; | ||
| import java.sql.SQLException; | ||
| import java.sql.Statement; | ||
| import java.util.Calendar; | ||
|
|
||
| import javax.servlet.RequestDispatcher; | ||
| import javax.servlet.ServletException; | ||
| import javax.servlet.annotation.WebServlet; | ||
| import javax.servlet.http.Cookie; | ||
| import javax.servlet.http.HttpServlet; | ||
| import javax.servlet.http.HttpServletRequest; | ||
| import javax.servlet.http.HttpServletResponse; | ||
|
|
||
| /** | ||
| * Servlet implementation class AddPatient | ||
| */ | ||
| @WebServlet("/AddPatient") | ||
| public class AddPatient extends HttpServlet { | ||
| private static final long serialVersionUID = 1L; | ||
|
|
||
| /** | ||
| * @see HttpServlet#HttpServlet() | ||
| */ | ||
| public AddPatient() { | ||
| super(); | ||
| // TODO Auto-generated constructor stub | ||
| } | ||
|
|
||
| /** | ||
| * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse | ||
| * response) | ||
| */ | ||
| protected void doGet(HttpServletRequest request, | ||
| HttpServletResponse response) throws ServletException, IOException { | ||
| // TODO Auto-generated method stub | ||
| } | ||
|
|
||
| /** | ||
| * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse | ||
| * response) | ||
| */ | ||
| protected void doPost(HttpServletRequest request, | ||
| HttpServletResponse response) throws ServletException, IOException { | ||
| PrintWriter out = response.getWriter(); | ||
| response.setContentType("text/html"); | ||
| String first_name, last_name, faculty, department, doctor, gender, regNumber; | ||
| first_name = request.getParameter("firstName"); | ||
| last_name = request.getParameter("lastName"); | ||
| faculty = request.getParameter("faculty"); | ||
| department = request.getParameter("department"); | ||
| doctor = request.getParameter("doctor"); | ||
| gender = request.getParameter("gender"); | ||
| regNumber = request.getParameter("regNumber"); | ||
| Calendar calendar = Calendar.getInstance(); | ||
| java.sql.Timestamp time = new java.sql.Timestamp(calendar.getTime() | ||
| .getTime()); | ||
|
|
||
| Connection conn = null; | ||
| try { | ||
| // HttpSession session = request.getSession(false); | ||
| Cookie[] cookie = request.getCookies(); | ||
|
|
||
| Class.forName("com.mysql.jdbc.Driver"); | ||
| conn = DriverManager.getConnection("jdbc:mysql://localhost/Stude", | ||
| "root", " "); | ||
| out.print("Connected to DB Successfully \n"); | ||
| PreparedStatement state = conn | ||
| .prepareStatement("insert into ReceptionistQueue values(?,?,?,?,?,?)"); | ||
| state.setString(1, regNumber); | ||
| state.setString(2, first_name); | ||
| state.setString(3, last_name); | ||
| state.setString(4, gender); | ||
| state.setString(5, doctor); | ||
| state.setTimestamp(6, time); | ||
| state.executeUpdate(); | ||
| // response.sendRedirect("AddPatient.jsp"); | ||
| if (cookie != null) { | ||
| String name = cookie[0].getValue(); | ||
| if (!name.equals("") || name != null) { | ||
| RequestDispatcher dispatcher = request | ||
| .getRequestDispatcher("ReceptionistHome.jsp"); | ||
| // response.sendRedirect("ReceptionistHome.jsp"); | ||
| dispatcher.forward(request, response); | ||
| out.println("Patient added Successfully"); | ||
|
|
||
| } | ||
| } else { | ||
| out.println("Login first"); | ||
| response.sendRedirect("index.jsp"); | ||
| } | ||
|
|
||
| } catch (SQLException | ClassNotFoundException e) { | ||
| out.println("SQLException:" + e.getMessage()); | ||
| } | ||
|
|
||
| } | ||
|
|
||
| } |
| @@ -0,0 +1,116 @@ | ||
| package com.SanProject.servlets; | ||
|
|
||
| import java.io.IOException; | ||
| import java.io.PrintWriter; | ||
| import java.sql.Connection; | ||
| import java.sql.DriverManager; | ||
| import java.sql.PreparedStatement; | ||
| import java.sql.ResultSet; | ||
| import java.sql.SQLException; | ||
|
|
||
| import javax.servlet.RequestDispatcher; | ||
| import javax.servlet.ServletException; | ||
| import javax.servlet.annotation.WebServlet; | ||
| import javax.servlet.http.Cookie; | ||
| import javax.servlet.http.HttpServlet; | ||
| import javax.servlet.http.HttpServletRequest; | ||
| import javax.servlet.http.HttpServletResponse; | ||
| import javax.servlet.http.HttpSession; | ||
|
|
||
| /** | ||
| * Servlet implementation class Login | ||
| */ | ||
| @WebServlet("/Login") | ||
| public class Login extends HttpServlet { | ||
| private static final long serialVersionUID = 1L; | ||
|
|
||
| /** | ||
| * @see HttpServlet#HttpServlet() | ||
| */ | ||
| public Login() { | ||
| super(); | ||
| // TODO Auto-generated constructor stub | ||
| } | ||
|
|
||
| /** | ||
| * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse | ||
| * response) | ||
| */ | ||
| protected void doGet(HttpServletRequest request, | ||
| HttpServletResponse response) throws ServletException, IOException { | ||
| // TODO Auto-generated method stub | ||
| } | ||
|
|
||
| /** | ||
| * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse | ||
| * response) | ||
| */ | ||
| protected void doPost(HttpServletRequest request, | ||
| HttpServletResponse response) throws ServletException, IOException { | ||
|
|
||
| PrintWriter out = response.getWriter(); | ||
| response.setContentType("text/html"); | ||
| // request.setAttribute("errors", false); | ||
|
|
||
| String username = request.getParameter("username"); | ||
| String password = request.getParameter("password"); | ||
| Connection conn = null; | ||
| try { | ||
|
|
||
| Class.forName("com.mysql.jdbc.Driver"); | ||
| conn = DriverManager.getConnection("jdbc:mysql://localhost/Stude", | ||
| "root", " "); | ||
| System.out.print("Successfully Connected"); | ||
|
|
||
| // We extract the value of the column "Role" from the DB, based on the Username and Password Combination entered in by the user | ||
| PreparedStatement state = conn | ||
| .prepareStatement("SELECT Role FROM Users WHERE userName = ? AND passWord= ?"); | ||
|
|
||
| state.setString(1, username); | ||
| state.setString(2, password); | ||
|
|
||
| ResultSet rs = state.executeQuery(); | ||
| if (rs.next()) { | ||
|
|
||
| // We check the String from the value extracted from the DB | ||
| String userRole = rs.getString("Role"); | ||
|
|
||
| // If the string equals "Admin", we redirect the user to the "Register.jsp" page | ||
| if("Admin".equals(userRole)){ | ||
| // HttpSession session = request.getSession(); | ||
| // session.setAttribute("user", username); | ||
| Cookie cookie = new Cookie("user", username); | ||
| response.addCookie(cookie); | ||
|
|
||
| RequestDispatcher dispatcher = request | ||
| .getRequestDispatcher("Register.jsp"); | ||
| dispatcher.forward(request, response); | ||
|
|
||
|
|
||
| } | ||
| //If the value of the string equals "Reception", we redirect the user to the "Developers.jsp" Page | ||
| else if("Reception".equals(userRole)){ | ||
| // HttpSession session = request.getSession(); | ||
| // session.setAttribute("user", username); | ||
| Cookie cookie = new Cookie("user", username); | ||
| response.addCookie(cookie); | ||
| RequestDispatcher dispatcher = request | ||
| .getRequestDispatcher("Developers.jsp"); | ||
| dispatcher.forward(request, response); | ||
|
|
||
| } | ||
|
|
||
| } else { | ||
| // If the user entered the wrong username+password combination, we redirect them to the login page | ||
| out.println("Wrong username and password combo"); | ||
| request.setAttribute("errors", true); | ||
| RequestDispatcher dispatcher = request | ||
| .getRequestDispatcher("index.jsp"); | ||
| dispatcher.forward(request, response); | ||
| } | ||
| } catch (SQLException | ClassNotFoundException e) { | ||
| out.println("SQLException:" + e.getMessage()); | ||
| } | ||
| } | ||
|
|
||
| } |
| @@ -0,0 +1,80 @@ | ||
| package com.SanProject.servlets; | ||
|
|
||
| import java.io.IOException; | ||
| import java.io.PrintWriter; | ||
| import java.sql.Connection; | ||
| import java.sql.DriverManager; | ||
| import java.sql.PreparedStatement; | ||
| import java.sql.SQLException; | ||
| import java.util.Calendar; | ||
|
|
||
| import javax.servlet.RequestDispatcher; | ||
| import javax.servlet.ServletException; | ||
| import javax.servlet.annotation.WebServlet; | ||
| import javax.servlet.http.HttpServlet; | ||
| import javax.servlet.http.HttpServletRequest; | ||
| import javax.servlet.http.HttpServletResponse; | ||
|
|
||
| /** | ||
| * Servlet implementation class SendToPharmacist | ||
| */ | ||
| @WebServlet("/SendToPharmacist") | ||
| public class SendToPharmacist extends HttpServlet { | ||
| private static final long serialVersionUID = 1L; | ||
|
|
||
| /** | ||
| * @see HttpServlet#HttpServlet() | ||
| */ | ||
| public SendToPharmacist() { | ||
| super(); | ||
| // TODO Auto-generated constructor stub | ||
| } | ||
|
|
||
| /** | ||
| * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse | ||
| * response) | ||
| */ | ||
| protected void doGet(HttpServletRequest request, | ||
| HttpServletResponse response) throws ServletException, IOException { | ||
| // TODO Auto-generated method stub | ||
| } | ||
|
|
||
| /** | ||
| * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse | ||
| * response) | ||
| */ | ||
| protected void doPost(HttpServletRequest request, | ||
| HttpServletResponse response) throws ServletException, IOException { | ||
| PrintWriter out = response.getWriter(); | ||
| response.setContentType("text/html"); | ||
| String regNumber = request.getParameter("regNumber"); | ||
| String diagnosis = request.getParameter("diagnosis"); | ||
| String prescription = request.getParameter("prescription"); | ||
| Calendar calendar = Calendar.getInstance(); | ||
| java.sql.Timestamp time = new java.sql.Timestamp(calendar.getTime() | ||
| .getTime()); | ||
| Connection conn = null; | ||
| try { | ||
| Class.forName("com.mysql.jdbc.Driver"); | ||
| conn = DriverManager.getConnection("jdbc:mysql://localhost/Stude", | ||
| "root", " "); | ||
| System.out.println("Connected successfully to DB"); | ||
| PreparedStatement state = conn | ||
| .prepareStatement("insert into ChemistQueue values(?,?,?,?)"); | ||
| state.setString(1, regNumber); | ||
| state.setString(2, prescription); | ||
| state.setString(3, diagnosis); | ||
| state.setTimestamp(4, time); | ||
| state.executeUpdate(); | ||
| RequestDispatcher dispatcher = request | ||
| .getRequestDispatcher("doctorhome.jsp"); | ||
| dispatcher.forward(request, response); | ||
| out.println("Registered Successfully"); | ||
|
|
||
| } catch (SQLException | ClassNotFoundException e) { | ||
| out.println("SQLException :" + e.getMessage()); | ||
| } | ||
|
|
||
| } | ||
|
|
||
| } |
| @@ -0,0 +1,102 @@ | ||
| # | ||
| # Charset Mappings | ||
| # | ||
| # Java Encoding MySQL Name (and version, '*' | ||
| # denotes preferred value) | ||
| # | ||
|
|
||
| javaToMysqlMappings=\ | ||
| US-ASCII = usa7,\ | ||
| US-ASCII = ascii,\ | ||
| Big5 = big5,\ | ||
| GBK = gbk,\ | ||
| SJIS = sjis,\ | ||
| EUC_CN = gb2312,\ | ||
| EUC_JP = ujis,\ | ||
| EUC_JP_Solaris = >5.0.3 eucjpms,\ | ||
| EUC_KR = euc_kr,\ | ||
| EUC_KR = >4.1.0 euckr,\ | ||
| ISO8859_1 = *latin1,\ | ||
| ISO8859_1 = latin1_de,\ | ||
| ISO8859_1 = german1,\ | ||
| ISO8859_1 = danish,\ | ||
| ISO8859_2 = latin2,\ | ||
| ISO8859_2 = czech,\ | ||
| ISO8859_2 = hungarian,\ | ||
| ISO8859_2 = croat,\ | ||
| ISO8859_7 = greek,\ | ||
| ISO8859_7 = latin7,\ | ||
| ISO8859_8 = hebrew,\ | ||
| ISO8859_9 = latin5,\ | ||
| ISO8859_13 = latvian,\ | ||
| ISO8859_13 = latvian1,\ | ||
| ISO8859_13 = estonia,\ | ||
| Cp437 = *>4.1.0 cp850,\ | ||
| Cp437 = dos,\ | ||
| Cp850 = Cp850,\ | ||
| Cp852 = Cp852,\ | ||
| Cp866 = cp866,\ | ||
| KOI8_R = koi8_ru,\ | ||
| KOI8_R = >4.1.0 koi8r,\ | ||
| TIS620 = tis620,\ | ||
| Cp1250 = cp1250,\ | ||
| Cp1250 = win1250,\ | ||
| Cp1251 = *>4.1.0 cp1251,\ | ||
| Cp1251 = win1251,\ | ||
| Cp1251 = cp1251cias,\ | ||
| Cp1251 = cp1251csas,\ | ||
| Cp1256 = cp1256,\ | ||
| Cp1251 = win1251ukr,\ | ||
| Cp1257 = cp1257,\ | ||
| MacRoman = macroman,\ | ||
| MacCentralEurope = macce,\ | ||
| UTF-8 = utf8,\ | ||
| UnicodeBig = ucs2,\ | ||
| US-ASCII = binary,\ | ||
| Cp943 = sjis,\ | ||
| MS932 = sjis,\ | ||
| MS932 = >4.1.11 cp932,\ | ||
| WINDOWS-31J = sjis,\ | ||
| WINDOWS-31J = >4.1.11 cp932,\ | ||
| CP932 = sjis,\ | ||
| CP932 = *>4.1.11 cp932,\ | ||
| SHIFT_JIS = sjis,\ | ||
| ASCII = ascii,\ | ||
| LATIN5 = latin5,\ | ||
| LATIN7 = latin7,\ | ||
| HEBREW = hebrew,\ | ||
| GREEK = greek,\ | ||
| EUCKR = euckr,\ | ||
| GB2312 = gb2312,\ | ||
| LATIN2 = latin2 | ||
|
|
||
| # | ||
| # List of multibyte character sets that can not | ||
| # use efficient charset conversion or escaping | ||
| # | ||
| # This map is made case-insensitive inside CharsetMapping | ||
| # | ||
| # Java Name MySQL Name (not currently used) | ||
|
|
||
| multibyteCharsets=\ | ||
| Big5 = big5,\ | ||
| GBK = gbk,\ | ||
| SJIS = sjis,\ | ||
| EUC_CN = gb2312,\ | ||
| EUC_JP = ujis,\ | ||
| EUC_JP_Solaris = eucjpms,\ | ||
| EUC_KR = euc_kr,\ | ||
| EUC_KR = >4.1.0 euckr,\ | ||
| Cp943 = sjis,\ | ||
| Cp943 = cp943,\ | ||
| WINDOWS-31J = sjis,\ | ||
| WINDOWS-31J = cp932,\ | ||
| CP932 = cp932,\ | ||
| MS932 = sjis,\ | ||
| MS932 = cp932,\ | ||
| SHIFT_JIS = sjis,\ | ||
| EUCKR = euckr,\ | ||
| GB2312 = gb2312,\ | ||
| UTF-8 = utf8,\ | ||
| utf8 = utf8,\ | ||
| UnicodeBig = ucs2 |
| @@ -0,0 +1,19 @@ | ||
| # | ||
| # Settings to maintain Connector/J 3.0.x compatibility | ||
| # (as much as it can be) | ||
| # | ||
|
|
||
| emptyStringsConvertToZero=true | ||
| jdbcCompliantTruncation=false | ||
| noDatetimeStringSync=true | ||
| nullCatalogMeansCurrent=true | ||
| nullNamePatternMatchesAll=true | ||
| transformedBitIsBoolean=false | ||
| dontTrackOpenResources=true | ||
| zeroDateTimeBehavior=convertToNull | ||
| useServerPrepStmts=false | ||
| autoClosePStmtStreams=true | ||
| processEscapeCodesForPrepStmts=false | ||
| useFastDateParsing=false | ||
| populateInsertRowWithDefaultValues=false | ||
| useDirectRowUnpack=false |
| @@ -0,0 +1,6 @@ | ||
| # | ||
| # Settings to maintain Connector/J 5.0.x compatibility | ||
| # (as much as it can be) | ||
| # | ||
|
|
||
| useDirectRowUnpack=false |
| @@ -0,0 +1,4 @@ | ||
| # Basic properties for clusters | ||
| autoReconnect=true | ||
| failOverReadOnly=false | ||
| roundRobinLoadBalance=true |
| @@ -0,0 +1,25 @@ | ||
| # | ||
| # Properties for optimal usage in ColdFusion | ||
| # | ||
| # Automagically pulled in if "autoConfigureForColdFusion" is "true" | ||
| # which is the default configuration of the driver | ||
| # | ||
|
|
||
| # | ||
| # CF uses a _lot_ of RSMD.isCaseSensitive() - this optimizes it | ||
| # | ||
|
|
||
| useDynamicCharsetInfo=false | ||
|
|
||
| # | ||
| # CF's pool tends to be "chatty" like DBCP | ||
| # | ||
|
|
||
| alwaysSendSetIsolation=false | ||
| useLocalSessionState=true | ||
|
|
||
| # | ||
| # CF's pool seems to loose connectivity on page restart | ||
| # | ||
|
|
||
| autoReconnect=true |
| @@ -0,0 +1,6 @@ | ||
| # Settings for 'max-debug' style situations | ||
| profileSQL=true | ||
| gatherPerfMetrics=true | ||
| useUsageAdvisor=true | ||
| logSlowQueries=true | ||
| explainSlowQueries=true |
| @@ -0,0 +1,34 @@ | ||
| # | ||
| # A configuration that maximizes performance, while | ||
| # still staying JDBC-compliant and not doing anything that | ||
| # would be "dangerous" to run-of-the-mill J2EE applications | ||
| # | ||
| # Note that because we're caching things like callable statements | ||
| # and the server configuration, this bundle isn't appropriate | ||
| # for use with servers that get config'd dynamically without | ||
| # restarting the application using this configuration bundle. | ||
|
|
||
| cachePrepStmts=true | ||
| cacheCallableStmts=true | ||
|
|
||
| cacheServerConfiguration=true | ||
|
|
||
| # | ||
| # Reduces amount of calls to database to set | ||
| # session state. "Safe" as long as application uses | ||
| # Connection methods to set current database, autocommit | ||
| # and transaction isolation | ||
| # | ||
|
|
||
| useLocalSessionState=true | ||
| elideSetAutoCommits=true | ||
| alwaysSendSetIsolation=false | ||
|
|
||
| # Can cause high-GC pressure if timeouts are used on every | ||
| # query | ||
| enableQueryTimeouts=false | ||
|
|
||
| # Bypass connection attribute handling during connection | ||
| # setup | ||
| connectionAttributes=none | ||
|
|
| @@ -0,0 +1,13 @@ | ||
| # | ||
| # Solaris has pretty high syscall overhead, so these configs | ||
| # remove as many syscalls as possible. | ||
| # | ||
|
|
||
| # Reduce recv() syscalls | ||
|
|
||
| useUnbufferedInput=false | ||
| useReadAheadInput=false | ||
|
|
||
| # Reduce number of calls to getTimeOfDay() | ||
|
|
||
| maintainTimeStats=false |
