Patients Information System

This web application is used by a doctor to keep track of his/her patients. It manages details of patients, their visits, durgs used by patients, investigations (tests) undergone by patients etc.

Technologies and Products used

NetBeans 5.0
Tomcat 5.5 embeded in NetBeans
Oracle10g Express Edition
Java Server Pages (JSP)
Java Beans

The following are the steps to related to be taken to run the existing part of the application :

Create pisaccount with password pis in Oracle10g Express Edition. This must be done after you log in as SYSTEM user.
```
      create user pis identified by pis;
      grant connect,resource to pis;
    
```
Create required tables in pis account by using commands in tables.sql file in project directory.
Download pis.zip and unzip it into d:\ directory. You can substitue d:\ with another path if you like.
Start NetBeans 5.0 or above
Open pis project in NetBeans using File->Open Project option.
Add Oracle Library - ojdbc14.jar to libraries of the project.
Build and deploy the project to embeded Tomcat of NetBeans using Deploy Project option in popup menu of the project (right click on project in Projects window).
Run this project - you must see index.jsp page.

Deploying Web Application In Tomcat of JBoss

The following procedure explains how to deploy a web application, developed with Tomcat that is embeded with NetBeans to Tomcat embeded, in to JBOSS application server.

You better change port number at which Tomcat in JBoss is running using JBOSS_HOME\server\default\deploy\jbossweb-tomcat55.sar\server.xml file. Change port number of HTTP Container from 8080 to 9999 ( or any other port number).
This is required as Oracle10g also uses 8080.
Copy pis.war from dist directory of pis project into JBOSS_HOME\server\default\deploy directory.
Run the application using the following url:
```
  http://localhost:9999/pis 
```
You should see home page of the application.