web site of hospital management

8/9/2019 Web Site of Hospital Management

1/25

Web site of HospitalManagement

Submitted By:

Sanjeev Kanojia

(0714510084) Satyam Saxena(0714510086) Saurabh Samet(0714510090)Shailendra Rathore(0714510091)

Submitted to the Department of COMPUTER SCIENCEIn partial fulfillment of the requirements

Of the degree ofBachelor of Technology inU.P Technical University

1


2/25

College of Science and Engineering (Jhansi)U.P Technical University

2


3/25

DECLARATION

I hereby declare that submission is my own workand that, to the best of my knowledge and belief, itcontains no material previously published or written byanother person nor material which to a substantial extenthas been accepted for the award of any other degree ordiploma of the university or other institute of higherlearning, except where due acknowledgment has been

made in the text.

Signature:

Name:

Sanjeev Kanojia (0714510084)Satyam Saxena (0714510086)Shailendra Rathore (0714510091)Saurabh Samet (0714510090)

Date: 03/04/2010

3


4/25

CERTIFICATION

This is to certify that project report entitledHospital Management System (Web Side) which issubmitted by Sanjeev Kanojia, Satyam Saxena,Shailendra Rathore, Saurabh Samet in partial fulfillmentof the requirements for the award of degree ofbachelor of technology in department of COMPUTERSCIENCE U.P.Technical University, is a record of candidateown work carried out by him under our supervision. The

matter embodied in this thesis is original and has notbeen submitted for the award of any other degree.

Date: Supervisor:03/05/2010.Er.Diksha Yadav

4


5/25

ACKNOWLEDGEMENT

It gives us a great sense of pleasure to present the report of the B.Tech ProjectUndertaken during B.Tech Third Year. We Owen special debt of gratitude to professorEr.Diksha dada Department of Computer Science & Engineering, college of science &Engineering,Lucknow for his constant support and guidance throughout the course of ourwork. His sincerity, thoroughness and perseverance have been a constant source ofinspiration for us. It is only his cognizant efforts that our endeavors have been light of theday.

We take the opportunity to acknowledgement the contribution ofER.Sarika, Head ofdepartment Computer Science & Engineering, college of science & Engineering,

Jhansi for his full support and assistance during the development of the project.We also do not like to miss the opportunity to acknowledge the contribution of all

faculty members of the department for their kind assistance and cooperation during thedevelopment of our project. Last but not the least we acknowledge our friends for theircontribution in the completion of the project.

Signature: Signature:Name: Sanjeev Kanojia Name: Satyam Saxena

Roll No: 0714510084 Roll No: 0714510086

Date: 03/05/2010 Date: 03/05/2010

Signature: Signature:

Name: Saurabh Samet Name: ShailendraRathore

Roll No: 0714510090 Roll No: 0714510091

Date: 03/04/2010 Date: 03/04/2010

5


6/25

6


7/25

ABSTRACT

Hospitals Management System (HMS) manage whole working of hospitalit also show view Hospital.

As the HMS has to have a foolproof security and a robust database, it hasbeen built on mysql Server and jdk 1.6 and appropriate s/w, to requirementsof the large institutions. Hospital Management System is integrated softwarewhich caters to the operational needs of each of the department. Apart fromstoring and assembling data, it also assists in the decision-making processrelating to resource management. Easy and quick access to patient relatedinformation is another most important aspect of the system.

In this three type of pages are used

1: HTML pages which are purely static those have no server client siderequired.

2: Servlet pages whos programming based on server side.3: Active pages whos programming based on user side.

7


8/25

TABLE OF CONTENTS

TopicPage

DECLARATION

.. 2

CERTIFICATION

3

ACKNOWLEDGEMENTS

.. 4

ABSTRACT

. 5

LIST OF

TABLE

.

1 Hardwarerequirements

10

2 Software

requirements

..10

3 Milestones and Time

management.10-11LIST OF

FIGURE

..

8


9/25

FIGURE

1

13

FIGURE2

13

FIGURE

3

13

FIGURE

4

13

ER

diagram

20

1:Title of the

project

8

2:About the

project

.8

2.1 Generic Technology

keywords8

2.2 Specific Technology

keywords8

2.3Project type

keywords..8

3: Functional components of the

project.8

9


10/25

3.1 Registration

...8

3.2: Admin

Login9

3.3: Patient

Login.

9

3.4: Patient Billing Internal and

External9

4Treatment

.9

4.1.1 Pharmacy Center...

..9

4.2.2 OT Scheduling (Operation Theater)

.9

5.0Requirements

10

5.1 Hardware

requirements..

10

5.2 Software

requirements

.10

5.3 Project

Team

.10

10


11/25

6.0 Work procedure of

project.11

6.1 Introduction

Part12

6.2 Administrative

Part12

7.0 Types of

Pages

12

7.1 StaticDocuments

12

7.1.1

HTML

12

7.2 Dynamic

Pages.13

8.0 Type of file in

project.

14

8.1 Query

14

8.2 For Connectivity with

Database15

8. 3: Servlet Files (access the information)

16

11


12/25

8.4

Security

.17

9CONCLUSION

..17

12


13/25

Hospital Management System

1: Title of the project:

The title of our project is Hospital Management

2: About the project:

Hospital Management System (HMS) manage whole working of hospitalit also show view of ourHospital.

As the HMS has to have a foolproof security and a robust database, it hasbeen built on Me Server and jdk 1.6 and appropriate s/w, to requirements ofthe large institutions.HMS is integrated software which caters to theoperational needs of each of the department. Apart from storing andassembling data, it also assists in the decision-making process relating to

resource management. Easy and quick access to patient related informationis another most important aspect of the system.

2.1 Generic Technology keywords:

Databases, Programming

2.2 Specific Technology keywords:

Jdk 1.6 & mysql server

2.3 Project type keywords:

Analysis, Design, Implementation, Testing

3: Functional components of the project:

Following is a list of functionalities of the system.1: Registration2: Admin Login3: Patient Login4: Patient Billing Internal and External5: Test Report6: Treatment10: View

3.1 Registration:

When a Patient in hospital then it follow by following process:

13


14/25


15/25

5.0Requirements:

5.1 Hardware requirements:

Number Description1 PC with 80 GB hard disk and 1 GB

RAM

5.2 Software requirements:

Number Description Alternatives1 Windows 98/2000/XP

with MS officeLinux

2 MYSQL server2000/2005 /Oracle

SQL

5.3 Project Team:

5 students can complete this in 4-5 months if they work on it.

Milestones and Time management:

Number MilestoneName

MilestoneDescription

Time line Remarks

1 RequirementsSpecification

Completespecification of

the system

2-3 days Attemptshould be

made to addsome morerelevantfunctionality

2 Databasecreation

Save allentries anddata inour database

5-7 days It isimportant tofinalize onthedatabase

3 High-level andDetailedDesign

Listing downall possiblescenarios

7-9 days The scenariosshould mapto therequirementspecification

4 Implementation ofthe frontendof the system

Implementation of the mainscreen givingthe login,

10-12 days Start workingon a test planfor theEntire

15


16/25

screen thatfollows theloginGiving variousoptions.

system. Thistest plan canbeUpdated asand when

newscenarioscome tomind.

5 Integrating theFrontend withthedatabase

The update thedatabase whena patientreceived hisreport In short,the systemshould be

ready forintegrationtesting.

12-13 days

6 Testing The systemshould bethoroughlytested

14-15 days Another 2weeks shouldbe there tohandle anyissues foundduringTesting of thesystem. After

that,the finaldemo can bearranged

6.0 Work procedure of project:

The following steps will be helpful to start off the project.Study and be comfortable with technologies such as MYSQL, Jdk1.6, my

eclipse, flash SERVER

1: Make a database of all tables and fill some sample data in the tableswhich can prove helpful for running / testing of the project.

2: Create the FrontPage giving a brief description about the system and alogin box.

16


17/25

3: Create other subsystems like screens for various functions (new patiententry, viewing existing patient details, printing different reports etc...)

This Project Divide into Two Parts:

1: Introduction Part (For all) 2: Administrative Part (For Official Work).

6.1 Introduction Part:In this part:

1: Everyone can access our Hospital and he can get allinformation About Us.

2: User can see the information about Hospital.3: User cannot do any changes on Project.4: user is Able to give his identity and His introduction as a

feedback.5: All information saves in Database.

6.2 Administrative Part:

This part used by some Authorized person.

So that we click on project then user get a Login Form. After fulfill inproper manner and if it satisfies its all condition. User can not access theAdministrative Part.

7.0 Types of Pages:1: Static pages are in HTML.

2: Dynamic pages are in JSP

7.1 Static DocumentsStatic documents are fixed-content documents that are created and

stored in a server. The client can get only a copy of the document. In otherwords, the contents of the file are determined when the file is created, notwhen it is used. Of course, the contents in the server can be changed, butthe user cannot change them. When a client accesses the document, a copyof the document is sent. The user can then use a browsing program todisplay the document.

7.1.1 HTML

Hypertext Markup Language (HTML) is a language for creating Webpages. The term markup language comes from the book publishing industry.Before a book is typeset and printed, a copy editor reads the manuscript andputs marks on it. These marks tell the compositor how to format the text. Forexample, if the copy editor wants part of a line to be printed in boldface, he

17


18/25

or she draws a wavy line under that part. In the same way, data for a Webpage are formatted for interpretation by a browser.

Figure 1

Figure 27.2 Dynamic Pages:

A dynamic document is created by a Web server whenever a browserrequests the document. When a request arrives, the Web server runs anapplication program or a script that creates the dynamic document. Theserver returns the output of the program or script as a response to thebrowser that requested the document.

Figure 3

18


19/25

Figure 48.0 Type of file in the project:

1: Dao : for query2: Database: database connectivity

3: Servlet : access the information4: VO : for Security

8.1 Query:Java is most reliable language. For use the entity in program we use thedao files by which system will understand that which entity use in whichtype of form. And how user will access its value.

package com.hcl.dao;import com.hcl.dao.*;

import com.hcl.database.*;import com.hcl.vo.AdminLoginVo;

import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;

public class AdminLogin {public boolean selectItem(AdminLoginVo AdminLogin)throws Exception{

Connection con=null;

String sql="select *from adminlogin where Username=? andPassword=?";

PreparedStatement ps=null;ResultSet rs=null;

try{

con=new Database().getConnectionData();

ps=con.prepareStatement(sql);ps.setString(1,AdminLogin.getUsername());ps.setString(2,AdminLogin.getPassword());rs=ps.executeQuery();while(rs.next()){

return true;}

19


20/25

}catch(Exception e){

throw new Exception("Exception in select item"+e);

}finally{

if(con!=null)con.close();

}return false;

}

private String AdminLogin() {

// TODO Auto-generated method stubreturn null;

}}

8.2For Connectivity with Database: In javaconnectivity with database we use dao files in this we usemysql as a database. The coding of these pages like:package com.hcl.database;import java.sql.Connection;

import java.sql.DriverManager;public class Database {

public Connection getConnectionData( ) throws Exception{Connection con=null;try{

Class.forName("com.mysql.jdbc.Driver");

con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hospital","root","");


System.out.print("hello" +e);throw new Exception("Exception in geting connection");

20


21/25

}return con;}

}

8. 3: Servlet Files (access the information):When we connect the program with data program with database then

question arise that1: How data enter in database.2: how save data will access by administrator when he/she require.

So that in java we use Servlet files. Hear we give example by whichadministrator get the information about Patient.

package com.hcl.servlet;import java.io.IOException;

import java.io.PrintWriter;import java.util.ArrayList;

import javax.servlet.RequestDispatcher;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.hcl.dao.*;import com.hcl.patVO.viewVO;import javax.servlet.RequestDispatcher.*;

public class viewServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponseresponse)

throws ServletException, IOException {

response.setContentType("text/html");PrintWriter out = response.getWriter();

viewVO Doctor_entry_form=new viewVO();

try{

ArrayList invalue=newview1().selectItem1(Doctor_entry_form);

if(invalue!=null){

21


22/25

request.setAttribute("obj1", invalue);RequestDispatcher

rd=request.getRequestDispatcher("DoctorRetrieve.jsp");rd.forward(request, response);;

}


System.out.println(e);}

}

}

8.4 Security:Java is the most secure computer programming language because in

java there is no use of pointers like C and C++. And when we discuss aboutsecurity then we have to implement some more facilities so that in thisproject we add user name and password two fields by which only thoseauthorize person use the whole project. So for providing the security we usevo file so that only administrator access the project as well as update it...

The example of VO file is

package com.hcl.vo;

public class AdminLoginVo{

String Username;String Password;public String getUsername() {

return Username;}public void setUsername(String Username) {

this.Username = Username;}public String getPassword() {

return Password;}public void setPassword(String Password) {

this.Password = Password;}

}

22


23/25

CONCLUSION:This project (HMS) so much reliable and secure this project

contains static and dynamic pages which are work on server side as well asclient side. We can use it on single user system only and it can work onserver as well as personal desktop also.

The whole project is in java which is platform independent language sothat it can run on window xp, window vista, window NT, Window 7, as well asLinux, linex, Unix and other operating system..

23


24/25

24


25/25

25