BLOOD BANK MANAGEMENT SYSTEM

Report submitted in partial fulfillment of the requirement for the

degree of

Bachelor of Technology
In
Computer Science & Engineering
Under the Supervision of

Mr. Gurpreet Singh

Assistant professor

By
Asha Sharma
(1122510023)
Kamya Raj
(1122510044)
Computer Science and Engineering

Accurate Institute Of Management and Technology

Greater Noida

Uttar Pradesh Technical University

Lucknow

2011-2015

1
DECLARATION

This is to certify that Report entitled “GSM based defending Robot” which is
submitted by me in partial fulfillment of the requirement for the award of degree
Bachelor of Technology in Computer Science & Engineering to Accurate Institute of
Management and Technology, Greater Noida. Uttar Pradesh Technical University,
Lucknow comprises only my own work and due acknowledgement has been made in
the text to all other material used.

Date: Name of Student:

Asha Sharma
(1122510023)
Kamya Raj
(1122510044)
Section- A .

Approved By:

HOD
Computer Science and engineering
Accurate Institute Of Management and Technology

2
Certificate

This is to certify that Report entitled “GSM based wireless defending Robot” which is
submitted by Arunesh Shankar Mishra And Himanshi Sharma in partial fulfillment of
the requirement for the award of degree Bachelor of Technology in Computer Science
& Engineering to Accurate Institute of Management and Technology, Greater Noida.
Uttar Pradesh Technical University, Lucknow is a record of the candidate own work
carried out by him under my/our supervision. The matter embodied in this thesis is
original and has not been submitted for the award of any other degree.

Date:
Mr. Gurpreet Singh
Asst. Pro.
Computer Science and engineering
Accurate Institute Of Management and Technology

Approved By:

HOD
Computer Science and engineering.
Accurate Institute Of Management and Technology

3
Acknowledgement

We’ve taken efforts in this project however, it would have not been possible without
the kind support and help of many individuals and organizations. We would like to
extend my sincere thanks to all of them. We are highly indebted to Gurpreet Singh
Saini Asst. Professor for the guidance and constant supervision as well as for
providing necessary information regarding the project and also for their support in
completing the project.
We would like to express our gratitude towards our parent and members of Accurate
Institute of Management and Technology, for their kind cooperation and
encouragement which help us in completion of the project.
Our individual thanks and gratitude goes to our respective colleague in developing the
project and people who have willingly helped us with their abilities.

Name of Students:
Asha Sharma
(1122510023)
Kamya Raj
(1122510044)
Section: A
.

4
Table of Content:

Declaration 2

Acknowledgment 4

1. Introduction & Objectives of the Project 9

1.1 Introduction 9

1.2 Objectives 10

1.3 Advantage 11

1.4 Drawback of Current Manual-System 14

1.5 Proposed System 15

1.6 Need 16

2. System Study

2.1 Preliminary Investigation 29

2.2 System Development Life Cycle 30

3. System Analysis

3.1 Importance of Computerized System 33

3.2 Principle of System Analysis 34

4. System Design

4.1 System Design 35

4.2 Data Modeling 38

4.3 E-R Diagram 41

4.4 Context Level DFD 42

4.5 Modules 48

4.6 Process Logic for Each Modules 50

4.7 Tool/Platform, Hardware and Software Requirement Specification 52

5
4.8 Scheduling 53

5. System Development

5.1 Source Code 55

5.2 Code Efficiency 191

6. Testing

6.1 Testing Phase 191

6.2 Level of Testing 193

6.3 Verification and Validation (V&V) 206

7. System Implementation

7.1 Post Implementation Maintenance and Review 207

7.2 Hardware Evaluation Factors 207
7.3 Software Evaluation Factors 208
7.4 Conversion and Training 209
7.5 Training Needs 210

8. Cost Estimation of the Project 211

9. Gantt & Pert Chart 212

10. Security and Validations 215

11. Scope of Future Application 216

12. Conclusion 218

13. Bibliography 219

14. Glossary 220

6
7
List Of Figure:

[Link] Figure Page No.

1. Figure 1-Software Development Life Cycle 32
2. Figure 2-E-R Diagram 41
3. Figure 3-Context Level DFD 42
4. Figure 4-DFD For Patient/Receiver Request 43
5. Figure 5-DFD For Donar Registration 44
6. Figure 6-DFD For Hospital Registration 45
7. Figure 7-DFD For Receiving Blood 46
8. Figure 8-DFD For Doctor Registration 47
9. Figure 9-Test Cases 198
10. Figure 10-Gant Chart 212
11. Figure 11-Pert Chart 214

8
List Of Table:

[Link] Tables Page No.

1. Data Tables 39
2. Pert Chart Tables 213

9
1. INTRODUCTION

I have tried my best to make the complicated process of the Blood banks as simple as possible using
Structured & Modular technique & Menu oriented interface. I have tried to design the software in
such a way that user may not have any difficulty in using this package & further expansion is
possible without much effort. Even though I cannot claim that this work to be entirely exhaustive,
the main purpose of my exercise is perform each user’s activity in computerized way rather than
manually which is time consuming. People will no longer get caught in hospital red tape to procure
blood. Detailed information about the blood stock position, blood group, blood components and the
procedure of getting blood is now available on the Internet. It is Web Based Blood Bank
Management System.

• Provides the stock of blood for various groups in the various blood banks.
• Provides online registration to people who are willing to donate blood.
• Gives the details of blood donation camps.
• GroupWise listing of various blood groups.
• Citizens get information about the next coming blood donation camp via post or email after
registration.
• Online submission of registration forms.
• All the process of submission of registration form is quite simple.
• Department can collect information regarding various blood groups.
• People can get registration by sitting at home.
• Before any blood donation camp the registered citizens gets all the details regarding the camp.

I am confident that this software package can be readily used by non-programming personal
avoiding human handled chance of error.

10
1.2 Objectives of the project

I am confident that this software package can be readily used by non-programming personal avoiding
human handled chance of error. This project is used by two types of users

-> Online Users.

-->Administrator.

Online users can enquire about the blood donation if he/she wants to donate or receive blood.
Doctors, Nodal Hospitals can also register through this site. Administrator can maintain daily
updates in the requests of the users, doctors, hospitals etc. Administrator is must be an authorized
user. He can further change the password. There is the facility for password recovery, logout etc. The
main objectives of the project are:

 The objective of blood bank is to collect and distribute blood

 Collect detailed description of the donors who are interested in blood donation.
 Nodal hospitals registrations.
 Rules, terms and conditions for Blood donation.

1.3. ADVANTAGE:

I have designed the given proposed system in the JSP And My Sql to automate the process of Blood
Banks. Blood donation, the voluntary act of allowing one's blood to be drawn out of body has many
advantages besides giving that wonderful feeling of saving someone's life. Most of the time it is an
act of charity, though sometimes many people donate blood for money and other incentives. The
blood donated is stored in blood banks, to be subsequently used for transfusion.

No doubt the first and foremost advantage of donating blood is the exalted feeling of saving
someone's life. If we donate the little excess blood in our body, it could save someone's life without
creating any problem for us. Instead it would help to alleviate some major health problems like heart
diseases. Blood donation is an excellent way to get rid of excess iron accumulated in our body due to
its overconsumption. Excess iron in the body can stimulate the formation of free radicals, which are

11
responsible for causing damage to body cells and tissues. Free radicals are also associated with many
diseases like heart diseases and cancer.

Iron overloading is also thought to increase the risk of heart diseases. Besides, iron oxidizes
cholesterol, which is harmful for the arteries. Hemochromatosis is a genetic disease characterized by
excess accumulation of iron in the tissues due to improper metabolism. The disease can cause
damage to many organs like pancreas, adrenal glands, etc. It may also cause diabetes, liver diseases
and heart diseases. So, donating blood on a regular basis would help you to regulate the level of iron
in your body. Studies have shown that donating blood regularly can be beneficial for the heart and
circulatory system and can reduce the risk of heart diseases, especially among young people.

Besides, blood donation also burns the extra calories and reduces your cholesterol level. After
donating blood, the count of blood cells decreases in our body, which stimulates the bone marrow to
produce new red blood cells in order to replenish the loss. So, it stimulates the production of new
blood cells and refreshes the system.
Before donating blood, your hemoglobin level will be tested. If it is low, then you will not be
allowed to donate blood. Besides hemoglobin, your blood pressure level and body weight will also
be checked. In addition, your blood will also be examined for detecting the presence of five diseases,
namely, hepatitis B, hepatitis C, Syphilis, HIV/AIDS and malaria. If you are not suffering from these
diseases, only then you will be allowed to donate your blood.

There are no major disadvantages of donating blood, except that sometimes one may experience a
drop in blood pressure due to hypovolemia (a state of reduced blood volume), which may necessitate
cancellation of donation. Sometimes, one may also experience mild nausea or dizziness for a short
while. But if you compare the health benefits and mental satisfaction that comes from saving a life,
you will feel that benefits of this act of charity is not only restricted to the recipient, but also helps
the donor immensely.

The following steps that give the detailed information of the need of proposed system are:

Performance: During past several decades, the company records are supposed to be manually
handled for all the activities. The manual handling of the record is time consuming and highly
prone to error. To improve the performance of the Company system, the computerized system is to

12
be undertaken. The computerized project is fully computerized and user friendly even that any of the
members can see the report and status of the company.

Efficiency: The basic need of the project is efficiency. The project should be efficient so that
whenever a new customer record is added, or record is modified or deleted, the record is updated
automatically.

Control: The complete control of the project is under the hands of authorized person who has the
password to access this project and illegal access is not supposed to deal with. All the control is
under the administrator and the other members have the rights to just see the records not to change
any transaction or entry.

Security: Security is the main criteria for the proposed system. Since illegal access may corrupt the
database. So security has to be given in this project.
Key Features Are:
 System Connectivity

 No data duplication

 No Paper Work Required

 Time Efficient

 Cost Efficient

 Automatic data validation

 User friendly environment

 Data security and reliability

 Fast data insertion & retrieval

 Easy performance check

13
 Maintaining records of customers & Crystal Report generation

14
1.4 DRAWBACKS OF CURRENT MANUAL- SYSTEM

 The current manual system has a lot of paper work and it does not deal with old and
new car purchase and sale.
 To maintain the records of sale and service manually, is a Time-consuming job.
 With the increase in database, it will become a massive job to maintain the database.
 Requires large quantities of file cabinets, which are huge and require quite a bit of space
in the office, which can be used for storing records of previous claims.
 The retrieval of records of employees will be a tedious job.
 Lack of security for the records, anyone disarrange the records of your system.

ESTABLISH THE NEED OF NEW SYSTEM

1. Problem of Reliability: Current system is not reliable. It seems to vary in quality from one
month to the next. Some times it gives good output, but some times the output is worst.

2. Problem of Accuracy: There are too many mistakes in reports.

3. Problem of timeliness: In the current system the reports and output produced is mostly late and
in most of the cases it is useless because it is not on time.

4. Problem of Validity: The output and reports mostly contains misleading information. The
customer's information is sometimes not valid.

5. Problem of Economy: The current system is very costly. We have to spend lots of money to
keep the system up and going, but still not get the desired results.

15
6. Problem of Capacity: The current system is suffering from problem of capacity also. The staff
for organization is very less and the workload is too much. Few peoples cannot handle all the
work.

1.5 PROPOSED SYSTEM

1. Details: The new proposed system stores and maintains all the Blood bank details,
donators details, nodal hospital details etc.

2. Calculations: The new proposed system updates tables and other information automatically
and it is very fast and accurate.

3. Registers: There is no need of keeping and maintaining salary and information manually. It
remembers each and every record and we can get any report at any time.

4. Speed: The new proposed system is very fast with 100% accuracy and saves time.

5. Manpower: The new proposed system needs less manpower. Less people can do the large
work.

6. Efficiency: The new proposed systems complete the work of many people in less time.

7. Past details: The new proposed system contains the details of every past claims taken by
the employees.

8. Reduces redundancy: The most important benefit of this system is that it reduces the
redundancy of data within the data.

9. Work load: Reduces the work load of the data store by helping in easy updates of the
products and providing them with the necessary details together with financial
transactions management.

16
10. Easy statements: Month-end and day-end statement easily taken out without getting
headaches on browsing through the day end statements.

1.6 NEED

I have designed the given proposed system in the JSPto automate the process of Blood Bank
Management System. This project is useful for the authorities who keep track of all the Blood bank
details.
The following steps that give the detailed information of the need of proposed system are:
 Performance: During past several decades, the records are supposed to be manually
handled for all activities. The manual handling of the record is time consuming and
highly prone to error. To improve the performance of the system, the computerized
system is to be undertaken. The computerized project is fully computerized and user
friendly even that any of the members can see the report and status of the Blood bank.

 Efficiency: The basic need of this website is efficiency. The website should be efficient
so that whenever a new user submits his/her details the website is updated automatically.
This record will be useful for other users instantly.

 Control: The complete control of the project is under the hands of authorized person who
has the password to access this project and illegal access is not supposed to deal with. All
the control is under the administrator and the other members have the rights to just see the
records not to change any transaction or entry.

 Security: Security is the main criteria for the proposed system. Since illegal access may
corrupt the database. So security has to be given in this project.

“Client-Server approach with XML / JSP,AJAX”

The need of today’s software development is competence in a GUI based front-end tool, which can
connect to Relational Database engines. This gives the programmer the opportunity to develop client
server based commercial applications.

17
FRONT END

JSP programming tools are complete programming environments. It allows programmers to build a
GUI program using the various on-screen controls such as buttons, text, menus, boxes etc. These
controls are placed on a form and then the processing details related with each control are filled in.

In the business world, competitive strategies have become the order of the day to improve quality,
cut costs and provide a high response customer service base. Most organizations today need to be
market driven and do a lot of value addition to their products and services. This naturally calls for
rational decision making, which requires information. Information Technology or IT provides that
effective channel to support and implement this strategy. Client/Server is the technology that
empowers the desktop, thus setting a trend for the way successful organizations will use technology
in the next decade.

18
o INTRODUCTION TO JSP

Adding dynamic content via expressions

As we saw in the previous section, any HTML file can be turned into a JSP file by changing its
extension to .jsp. Of course, what makes JSP useful is the ability to embed Java. Put the following
text in a file with .jsp extension (let us call it [Link]), place it in your JSP directory, and view it in
a browser.
<HTML>
<BODY>
Hello! The time is now <%= new [Link]() %>
</BODY>
</HTML>
Notice that each time you reload the page in the browser, it comes up with the current time.

The character sequences <%= and %> enclose Java expressions, which are evaluated at run time.

This is what makes it possible to use JSP to generate dyamic HTML pages that change in response to
user actions or vary from user to user.

Exercise: Write a JSP to output the values returned by [Link] for various system
properties such as [Link], [Link], [Link], [Link], [Link], [Link] etc.

Scriptlets
We have already seen how to embed Java expressions in JSP pages by putting them between the <
%= and %> character sequences.

But it is difficult to do much programming just by putting Java expressions inside HTML.

JSP also allows you to write blocks of Java code inside the JSP. You do this by placing your Java
code between <% and %> characters (just like expressions, but without the = sign at the start of the
sequence.)

19
This block of code is known as a "scriptlet". By itself, a scriptlet doesn't contribute any HTML
(though it can, as we will see down below.) A scriptlet contains Java code that is executed every
time the JSP is invoked.

Here is a modified version of our JSP from previous section, adding in a scriptlet.

<HTML>
<BODY>
<%
// This is a scriptlet. Notice that the "date"
// variable we declare here is available in the
// embedded expression later on.
[Link]( "Evaluating date now" );
[Link] date = new [Link]();
%>
Hello! The time is now <%= date %>
</BODY>
</HTML>

If you run the above example, you will notice the output from the "[Link]" on the server
log. This is a convenient way to do simple debugging (some servers also have techniques of
debugging the JSP in the IDE. See your server's documentation to see if it offers such a technique.)

By itself a scriptlet does not generate HTML. If a scriptlet wants to generate HTML, it can use a
variable called "out". This variable does not need to be declared. It is already predefined for
scriptlets, along with some other variables. The following example shows how the scriptlet can
generate HTML output.

<HTML>
<BODY>
<%
// This scriptlet declares and initializes "date"
[Link]( "Evaluating date now" );
[Link] date = new [Link]();
%>
Hello! The time is now
<%
// This scriptlet generates HTML output
[Link]( [Link]( date ));

20
%>
</BODY>
</HTML>

Here, instead of using an expression, we are generating the HTML directly by printing to the "out"
variable. The "out" variable is of type [Link].

Another very useful pre-defined variable is "request". It is of type

[Link]

A "request" in server-side processing refers to the transaction between a browser and the server.
When someone clicks or enters a URL, the browser sends a "request" to the server for that URL, and
shows the data returned. As a part of this "request", various data is available, including the file the
browser wants from the server, and if the request is coming from pressing a SUBMIT button, the
information the user has entered in the form fields.

The JSP "request" variable is used to obtain information from the request as sent by the browser. For
instance, you can find out the name of the client's host (if available, otherwise the IP address will be
returned.) Let us modify the code as shown:

<HTML>
<BODY>
<%
// This scriptlet declares and initializes "date"
[Link]( "Evaluating date now" );
[Link] date = new [Link]();
%>
Hello! The time is now
<%
[Link]( date );
[Link]( "<BR>Your machine's address is " );
[Link]( [Link]());
%>
</BODY>
</HTML>

A similar variable is "response". This can be used to affect the response being sent to the browser.
For instance, you can call [Link]( anotherUrl ); to send a response to the browser that

21
it should load a different URL. This response will actualy go all the way to the browser. The
browser will then send a different request, to "anotherUrl". This is a little different from some other
JSP mechanisms we will come across, for including another page or forwarding the browser to
another page.

Exercise: Write a JSP to output the entire line, "Hello! The time is now ..." but use a scriptlet for the
complete string, including the HTML tags.

Mixing Scriptlets and HTML

We have already seen how to use the "out" variable to generate HTML output from within a
scriptlet. For more complicated HTML, using the out variable all the time loses some of the
advantages of JSP programming. It is simpler to mix scriptlets and HTML.

Suppose you have to generate a table in HTML. This is a common operation, and you may want to
generate a table from a SQL table, or from the lines of a file. But to keep our example simple, we
will generate a table containing the numbers from 1 to N. Not very useful, but it will show you the
technique.

Here is the JSP fragment to do it:

<TABLE BORDER=2>
<%
for ( int i = 0; i < n; i++ ) {
%>
<TR>
<TD>Number</TD>
<TD><%= i+1 %></TD>
</TR>
<%
}
%>
</TABLE>

You would have to supply an int variable "n" before it will work, and then it will output a simple
table with "n" rows.

22
The important things to notice are how the %> and <% characters appear in the middle of the "for"
loop, to let you drop back into HTML and then to come back to the scriptlet.

The concepts are simple here -- as you can see, you can drop out of the scriptlets, write normal
HTML, and get back into the scriptlet. Any control expressions such as a "while" or a "for" loop or
an "if" expression will control the HTML also. If the HTML is inside a loop, it will be emitted once
for each iteration of the loop.

Another example of mixing scriptlets and HTML is shown below -- here it is assumed that there is a
boolean variable named "hello" available. If you set it to true, you will see one output, if you set it to
false, you will see another output.

<%
if ( hello ) {
%>
<P>Hello, world
<%
} else {
%>
<P>Goodbye, world
<%
}
%>

It is a little difficult to keep track of all open braces and scriptlet start and ends, but with a little
practice and some good formatting discipline, you will acquire competence in doing it.

Exercise: Make the above examples work. Write a JSP to output all the values returned by
[Link] with "<BR>" embedded after each property name and value. Do not output the
"<BR>" using the "out" variable.

JSP Directives

We have been fully qualifying the [Link] in the examples in the previous sections. Perhaps
you wondered why we don't just import [Link].*;

23
It is possible to use "import" statements in JSPs, but the syntax is a little different from normal Java.
Try the following example:

<%@ page import="[Link].*" %>

<HTML>
<BODY>
<%
[Link]( "Evaluating date now" );
Date date = new Date();%>
Hello! The time is now <%= date %>
</BODY>
</HTML>

The first line in the above example is called a "directive". A JSP "directive" starts with <%@
characters.

This one is a "page directive". The page directive can contain the list of all imported packages. To
import more than one item, separate the package names by commas, e.g.

<%@ page import="[Link].*,[Link].*" %>

There are a number of JSP directives, besides the page directive. Besides the page directives, the
other most useful directives are include and taglib. We will be covering taglib separately.

The include directive is used to physically include the contents of another file. The included file can
be HTML or JSP or anything else -- the result is as if the original JSP file actually contained the
included text. To see this directive in action, create a new JSP

<HTML>
<BODY>
Going to include [Link]...<BR>
<%@ include file="[Link]" %>
</BODY>
</HTML>
View this JSP in your browser, and you will see your original [Link] get included in the new JSP.

Exercise: Modify all your earlier exercises to import the [Link] packages.

24
JSP Declarations
The JSP you write turns into a class definition. All the scriptlets you write are placed inside a single method of this class.

You can also add variable and method declarations to this class. You can then use these variables
and methods from your scriptlets and expressions.

To add a declaration, you must use the <%! and %> sequences to enclose your declarations, as shown
below.

<%@ page import="[Link].*" %>

<HTML>
<BODY>
<%!
Date theDate = new Date();
Date getDate()
{
[Link]( "In getDate() method" );
return theDate;
}
%>
Hello! The time is now <%= getDate() %>
</BODY>
</HTML>
The example has been created a little contrived, to show variable and method declarations.

JSP Tags
Another important syntax element of JSP are tags. JSP tags do not use <%, but just the < character.
A JSP tag is somewhat like an HTML tag. JSP tags can have a "start tag", a "tag body" and an "end
tag". The start and end tag both use the tag name, enclosed in < and > characters. The end starts
with a / character after the < character. The tag names have an embedded colon character : in them,
the part before the colon describes the type of the tag. For instance:
<some:tag>
body
</some:tag>
If the tag does not require a body, the start and end can be conveniently merged together, as
<some:tag/>
Here by closing the start tag with a /> instead of > character, we are ending the tag immediately, and
without a body. (This syntax convention is the the same as XML.)

25
Tags can be of two types: loaded from an external tag library, or predefined tags. Predefined tags
start with jsp: characters. For instance, jsp:include is a predefined tag that is used to include other
pages.

We have already seen the include directive. jsp:include is similar. But instead of loading the text of
the included file in the original file, it actually calls the included target at run-time (the way a
browser would call the included target. In practice, this is actually a simulated request rather than a
full round-trip between the browser and the server). Following is an example of jsp:include usage

<HTML>
<BODY>
Going to include [Link]...<BR>
<jsp:include page="[Link]"/>
</BODY>
</HTML>
Try it and see what you get. Now change the "jsp:include" to "jsp:forward" and see what is the
difference. These two predefined tags are frequently very useful.

Exercise: Write a JSP to do either a forward or an include, depending upon a boolean variable (hint:
The concepts of mixing HTML and scriptlets work with JSP tags also!)

JSP Sessions
On a typical web site, a visitor might visit several pages and perform several interactions.

If you are programming the site, it is very helpful to be able to associate some data with each visitor.
For this purpose, "session"s can be used in JSP.

A session is an object associated with a visitor. Data can be put in the session and retrieved from it,
much like a Hashtable. A different set of data is kept for each visitor to the site.

Here is a set of pages that put a user's name in the session, and display it elsewhere. Try out
installing and using these.

First we have a form, let us call it [Link]

<HTML>
<BODY>
<FORM METHOD=POST ACTION="[Link]">

26
What's your name? <INPUT TYPE=TEXT NAME=username SIZE=20>
<P><INPUT TYPE=SUBMIT>
</FORM>
</BODY>
</HTML>
The target of the form is "[Link]", which saves the user's name in the session. Note the
variable "session". This is another variable that is normally made available in JSPs, just like out and
request variables. (In the @page directive, you can indicate that you do not need sessions, in which
case the "session" variable will not be made available.)
<%
String name = [Link]( "username" );
[Link]( "theName", name );
%>
<HTML>
<BODY>
<A HREF="[Link]">Continue</A>
</BODY>
</HTML>
The [Link] saves the user's name in the session, and puts a link to another page,
[Link].

[Link] shows how to retrieve the saved name.

<HTML>
<BODY>
Hello, <%= [Link]( "theName" ) %>
</BODY>
</HTML>

If you bring up two different browsers (not different windows of the same browser), or run two
browsers from two different machines, you can put one name in one browser and another name in
another browser, and both names will be kept track of.

27
My SQL

Introduction

My SQL is an application used to create computer databases for the Microsoft Windows family of
server operating systems. It provides an environment used to generate databases that can be accessed
from workstations, the web, or other media such as a personal digital assistant (PDA). MY SQL is
probably the most accessible and the most documented enterprise database environment right now.
This also means that you can learn it a little quicker than most other database environments on the
market

To start, you must have a computer that runs an appropriate operating system like Microsoft
Windows >= XP Home Edition: that includes Windows XP Home Edition, Windows XP
Professional, Windows 2000 Professional, or any version of Windows Server 2003. In this case, you
must install MY SQL Yog.
What is SQL Used for:
Using SQL one can create and maintain data manipulation objects such as table, views, sequence etc.
These data manipulation objects will be created and stored on the server's hard disk drive, in a
tablespace, to which the user has been assigned.
Once these data manipulation objects are created, they are used extensively in commercial
applications.

28
DML, DCL, DDL:

In addition to the creation of data manipulation objects, the actual manipulation of data within these
objects is done using SQL.
The SQL sentences that are used to create these objects are called DDL's or Data Definition
Language. The SQL sentences used to manipulate data within these objects are called DML's or Data
Manipulation Language. The SQL sentences, which are used to control the behavior of these objects,
are called DCL's or Data Control Language.

Data Type

Built-in data types

In My Sql, each object (such as column, variable, or parameter) has a related data type, which is an
attribute that specifies the type of data that the object can hold.

User-defined data types

My SQL supports user-defined data types too. User-defined data types provide a mechanism for
applying a name to a data type that is more descriptive of the types of values to be held in the object.
Using user-defined data type can make it easier for a programmer or database administrator to
understand the intended use of any object defined with the data type. The user-defined data types are
based on the system data types and can be used to predefine several attributes of a column, such as
its data type, length, and whether it supports NULL values. To create a user-defined data type, you
can use the sp_addtype system stored procedure or you could add one using the Enterprise Manager.
When you create a user-defined data type, you should specify the following three properties:

 Data type's name.

 Built-in data type upon which the new data type is based.
 Whether it can contain NU

29
2.1 PRELIMINARY INVESTIGATION
System development, a process consisting of two major steps of system analysis and design, start
when management or sometimes system development personnel feel that a new system or an
improvement in the existing system is required. The system development life cycle is classically
thought of as the set of activities that analysts, designers and users carry out to develop and
implement an information system. The system development life cycle consists of the following
activities:

 Preliminary investigation
 Determination of system requirements
 Design of system
 Development of software
 System testing
 Implementation, evaluation, and maintenance

A request to take assistance from information system can be made for many reasons, but in each
case someone in the organization initiates the request is made, the first system activity the
preliminary investigation begins. This activity has three parts:
1) Request clarification
2) Feasibility study
3) Request approval

Request clarification: Many requests from employees and users in the organizations are not
clearly defined, therefore it becomes necessary that project request must be examined and
clarified properly before considering systems investigation.

30
2.2 SYSTEM DEVELOPMENT LIFE CYCLE
Systems are created to solve problems. One can think of the systems approach as an organized way
of dealing with a problem. In this dynamic world, the subject System Analysis and Design (SAD),
mainly deals with the software development activities.

DEFINING A SYSTEM

A collection of components that work together to realize some objective forms a system. Basically
there are three major components in every system, namely input, processing and output.

In a system the different components are connected with each other and they are interdependent.
For example, human body represents a complete natural system. We are also bound by many
national systems such as political system, economic system, educational system and so forth. The
objective of the system demands that some output is produced as a result of processing the suitable
inputs.

SYSTEM LIFE CYCLE

System life cycle is an organizational process of developing and maintaining systems. It helps in
establishing a system project plan, because it gives overall list of processes and sub-processes
required for developing a system.

System development life cycle means combination of various activities. In other words we can say
that various activities put together are referred as system development life cycle. In the System
Analysis and Design terminology, the system development life cycle means software development
life cycle.

31
Following are the different phases of software development cycle:

 System study

 Feasibility study

 System analysis

 System design

 Coding

 Testing

 Implementation

 Maintenance

32
The Different Phases Of Software Development Life Cycle Are Shown Below.

PRELIMINARY
PRELIMINARY
INVESTIGATION
INVESTIGATION

REVIEW
REVIEWRUNNING
RUNNING DETERMINATION
DETERMINATIONOF
OF
SYSTEM
SYSTEMAND
ANDSYSTEM
SYSTEM REQUIREMENTS
REQUIREMENTS
MAINTENANCE
MAINTENANCE

DEVELOPMENT
DEVELOPMENTOF
OF
PROTOTYPE
PROTOTYPESYSTEM
SYSTEM

SYSTEM
SYSTEM DESIGN
DESIGNOF
OFSYSTEM
SYSTEM
IMPLEMENTATION
IMPLEMENTATION

DEVELOPMENT
DEVELOPMENTOF
OF
SYSTEM
SYSTEMTESTING SOFTWARE
TESTING SOFTWAREAND
ANDCODING
CODING

SYSTEM
ANALYSIS
50%
DESIGN
DESIG
N OF
SYSTE
M

30%

CODING
20%

FIG:1 SHOWING GENERAL LIFE CYCLE PROCESS AND PERCENTAGE OF TIME

DEVOTED

33
A system analysis is a separation of a substance into parts for study and their implementation and
detailed examination.

Before designing any system it is important that the nature of the business and the way it currently
operates are clearly understood. The detailed examination provides the specific data required
during designing in order to ensure that all the client's requirements are fulfilled. The investigation
or the study conducted during the analysis phase is largely based on the feasibility study. Rather it
would not be wrong to say that the analysis and feasibility phases overlap. High-level analysis
begins during the feasibility study. Though analysis is represented as one phase of the system
development life cycle (SDLC), this is not true. Analysis begins with system initialization and
continues until its maintenance. Even after successful implementation of the system, analysis may
play its role for periodic maintenance and up gradation of the system.

One of the main causes of project failures is inadequate understanding, and one of the main causes
of inadequate understanding of the requirements is the poor planning of system analysis.

Analysis requires us to recall the objectives of the project and consider following three questions:

 What type of information is required?

 What are the constraints on the investigation?

 What are the potential problems that may make the task more difficult?

3.1 IMPORTANCE OF COMPUTERIZED

There are several attributes in which the computer based information works. Broadly the working of
computer system is divided into two main groups:

 Transaction System
 Decision Support System

Transaction System:

A transaction is a record of some well-defined single and usually small occurrence in a system.
Transactions are input into the computer to update the database files. It checks the entering data for
its accuracy. This means that numeric data appears in numeric field and character data in character
field. Once all the checks are made, transaction is used to update the database. Transaction can be

34
inputted in on-line mode or batch mode. In on-line mode, transactions are entered and updated into
the database almost instantaneously. In batch mode, transactions are collected into batches, which
may be held for a while and inputted later.

Decision Support System:

It assists the user to make analytical decision. It shows the various data in organized way called
analysis. This analysis can be made to syrdy preferences and help in making decisions.

Computer system works out best with record maintenance. It will tell you which customer would get
how much pending/reports statements. It will also help to search the information about a particular
person by simply entering his telephone number. User can store information as per requirement,
which can be used for comparison with other reports.

3.2 PRINCIPLES OF SYSTEM ANALYSIS

Principles:

1. Understand the problem before you begin to create the analysis model.
2. Develop prototypes that enable a user to understand how human machine interaction will
occur.
3. Record the origin of and the reason for every requirement.
4. Use multiple views of requirements like building data, function and behavioral models.
5. Work to eliminate ambiguity.

A Complete Structure:

The limited time and resources have restricted us to incorporate, in this project, only the main
activities that are performed in news sites, but utmost care has been taken to make the system efficient
and user friendly.

For the optimum use of practical time it is necessary that every session is planned. Planning of this
project will include the following things:

35
 Topic Understanding.
 Modular Break – Up of the System.
 Processor Logic for Each Module.
 Database Requirements.

Topic Understanding:

It is vital that the field of application as introduced in the project may be totally a new field. So as
soon as the project was allocated to me, I carefully went through the project to identify the
requirements of the project.

Modular Break –Up of the System:

 Identify The Various Modules In The System.

 List Them In The Right Hierarchy.
 Identify Their Priority Of Development
 Description Of The Modules:

4.1 SYSTEM DESIGN

The design document that we will develop during this phase is the blueprint of the software. It
describes how the solution to the customer problem is to be built. Since solution to complex
problems isn’t usually found in the first try, iterations are most likely required. This is true for
software design as well. For this reason, any design strategy, design method, or design language
must be flexible and must easily accommodate changes due to iterations in the design. Any technique
or design needs to support and guide the partitioning process in such a way that the resulting sub-
problems are as independent as possible from each other and can be combined easily for the solution
to the overall problem. Sub-problem independence and easy combination of their solutions reduces
the complexity of the problem. This is the objective of the partitioning process. Partitioning or
decomposition during design involves three types of decisions: -

Define the boundaries along which to break;

Determine into how money pieces to break; and

Identify the proper level of detail when design should stop and implementation should start.

36
Basic design principles that enable the software engineer to navigate the design process suggest a set
of principles for software design, which have been adapted and extended in the following list:

Free from the suffer from "tunnel vision." A good designer should consider alternative approaches,
judging each based on the requirements of the problem, the resources available to do the job.

The design should be traceable to the analysis model. Because a single element of the design model
often traces to multiple requirements, it is necessary to have a means for tracking how requirements
have been satisfied by the design model.

The design should not repeat the same thing. Systems are constructed using a set of design patterns,
many of which have likely been encountered before. These patterns should always be chosen as an
alternative to reinvention. Time is short and resources are limited! Design time should be invested in
representing truly new ideas and integrating those patterns that already exist.

The design should "minimize the intellectual distance" between the software and the problem as it
exists in the real world. That is, the structure of the software design should (whenever possible)
mimic the structure of the problem domain.

The design should exhibit uniformity and integration. A design is uniform if it appears that one
person developed the entire thing. Rules of style and format should be defined for a design team
before design work begins. A design is integrated if care is taken in defining interfaces between
design components.

The design activity begins when the requirements document for the software to be developed is
available. This may be the SRS for the complete system, as is the case if the waterfall model is being
followed or the requirements for the next "iteration" if the iterative enhancement is being followed or
the requirements for the prototype if the prototyping is being followed. While the requirements
specification activity is entirely in the problem domain, design is the first step in moving from the
problem domain toward the solution domain. Design is essentially the bridge between requirements
specification and the final solution for satisfying the requirements.

The design of a system is essentially a blueprint or a plan for a solution for the system. We consider
a system to be a set of components with clearly defined behavior that interacts with each other in a

37
fixed defined manner to produce some behavior or services for its environment. A component of a
system can be considered a system, with its own components. In a software system, a component is a
software module.

The design process for software systems, often, has two levels. At the first level, the focus is on
deciding which modules are needed for the system, the specifications of these modules, and how the
modules should be interconnected. This is what is called the system design or top-level design. In the
second level, the internal design of the modules, or how the specifications of the module can be
satisfied, is decided. This design level is often called detailed design or logic design. Detailed design
essentially expands the system design to contain a more detailed description of the processing logic
and data structures so that the design is sufficiently complete for coding.

Because the detailed design is an extension of system design, the system design controls the major
structural characteristics of the system. The system design has a major impact on the testability and
modifiability of a system, and it impacts its efficiency. Much of the design effort for designing
software is spent creating the system design.

The input to the design phase is the specifications for the system to be designed. Hence, reasonable
entry criteria can be that the specifications are stable and have been approved, hoping that the
approval mechanism will ensure that the specifications are complete, consistent, unambiguous, etc.
The output of the top-level design phase is the architectural design or the system design for the
software system to be built. This can be produced with or without using a design methodology.
Reasonable exit criteria for the phase could be that the design has been verified against the input
specifications and has been evaluated and approved for quality.

A design can be object-oriented or function-oriented. In function-oriented design, the design consists

of module definitions, with each module supporting a functional abstraction. In object-oriented
design, the modules in the design represent data abstraction (these abstractions are discussed in more
detail later). In the function-oriented methods for design and describe one particular methodology the
structured design methodology in some detail. In a function- oriented design approach, a system is
viewed as a transformation function, transforming the inputs to the desired outputs. The purpose of
the design phase is to specify the components for this transformation function, so that each
component is also a transformation function. Hence, the basic output of the system design phase,

38
when a function oriented design approach is being followed, is the definition of all the major data
structures in the system, all the major modules of the system, and how the modules interact with each
other. Once the designer is satisfied with the design he has produced, the design is to be precisely
specified in the form of a document. To specify the design, specification languages are used.
Producing the design specification is the ultimate objective of the design phase. The purpose of this
design document is quite different from that of the design notation. Whereas a design represented
using the design notation is largely to be used by the designer, a design specification has to be so
precise and complete that it can be used as a basis of further development by other programmers.
Generally, design specification uses textual structures, with design notation helping in understanding

4.2 DATA MODELING

Introduction to data dictionary:

Data dictionaries are an integral component of structured analysis, since data flow diagrams by
themselves do not fully describe the subject of the investigation . The data flow diagrams provide
the additional details about the project/system.

Data Dictionary (Definition):

A data dictionary is a catalog- a repository- of the elements in a system. These elements center on the
data and the way they are structured to meet user requirements and organization needs. A data
dictionary consists of a list of all the elements composing the data flowing through a system . The
major elements are data flows , data stores , and processes. The data dictionary stores details and
descriptions of these elements.

39
 DATA TABLES

Login Table
Field Type constraint
Username Char(30) Not Null
Password Char(30) Not Null
Email Char(30) Not Null
Security question Char(30) Not Null
Answer Char(30) Not Null

Admin Table
Field Type constraint
Username Char(30) Not Null
Password Char(30) Not Null

Feedback table

Field Type constraint

Name Char(30) Not Null
Phone Number Not Null
Email Char(50) Not Null
Contact Char(200) Not Null

Donator’s Table

Field Type constraint

Donator Id Char (30) Not Null
Name Char (30) Not Null
Address Char (30) Not Null
City Char (30) Not Null
State Char (30) Not Null
Email Char (50) Not Null
Phone Number Not Null
Blood Group Char (30) Not Null
Physical Status Char (30) Not Null
Diabetic Bit Not Null
Blood Pressure Bit Not Null
Weight Number Not Null
Remark Number Not Null

Receiver’s table

Field Type constraint

Receiver Id Char (30) Not Null
Name Char (30) Not Null
Address Char (30) Not Null
City Char (30) Not Null
State Char (30) Not Null
Email Char (50) Not Null
Phone Number Not Null
Blood Group Char (30) Not Null
Physical Status Char (30) Not Null

40
Diabetic Bit Not Null
Blood Pressure Bit Not Null
Weight Number Not Null
Remark Number Not Null
No_of_bottles_req Number Not Null
Doctor_name Char(30) Not Null
Hospital Char (50) Not Null
Disease Char (50) Not Null

Hospital table

Field Type constraint

Hospital Name Char (50) Not Null
Address Char (60) Not Null
City Char (50) Not Null
State Char (30) Not Null
Blood_group_req Char (30) Not Null
Qty_req Char (50) Not Null
Qty_avail Number Not Null
Details Char (150) Not Null
Conatct Person Char (15) Not Null

Indians_blood Bank: Details of the blood bank in India

Field Type constraint

Bank_id Char (30) Not Null
Name Char (30) Not Null
Address Char (30) Not Null
City Char (30) Not Null
State Char (30) Not Null
Contact_person Char (30) Not Null
Email Char(50) Not Null
Phone Number Not Null
Details Char(150) Not Null

Blood_bank_stock: Stock of the Blood groups available in Rotary Blood Bank.

Field Type constraint

Bank_group Char (30) Not Null
Qty_available Char (30) Not Null
Qty_required Char (30) Not Null

Camps table: Store details of the temporary camps arranged by Rotary society

Field Type constraint

Camp_no Char (30) Not Null
Timings Char (30) Not Null
Date, day Char (30) Not Null
Place Char (30) Not null
Phone Number Not Null
Contact Person Char (50) Not Null

41
2. E-R DIAGRAM
Name
Nam Addres
e s
Date
Cit
Address y
Patient
Id Cit Request
y 1 Name
NBLOOD
1
NPatient / Receiver BANK
1
Dat
e
1

Receive
Implant s Assi
gn

Name of Dat
City
Hospital e

Address
NODAL N Nam
HOSPITAL Donat e
es Pin
1 Co
Doctor de
Id Cit
Dates y
Address 1 Doctor

Nam Pin
e Co
de 1
Cit Remove
Doctor y s
Id
1
Doctor
1

42
[

3. CONTEXT LEVEL DFD FOR

RECEIVER 2. DONOR HOSPITAL

ADMINISTRATIVE SUPPORT
SYSTEM FOR ROTARY
BLOOD BANK

4. Doctors 5. Camp

43
4. DFD for Patient/ Receiver Request

Request
Blood 1.1 Accept
the Blood
request

PATIENT

1.2
Generate
the priority
no &
Tentative
Date

ADMINISTRATI
VE SUPPORT
SYSTEM FOR
ROTARY
Patient
BLOOD BANK

Generate Upgrade
Slip Blood bank
date
Blood Bank
Screen | Print

44
[Link] FOR DONOR REGISTRATION

Fills / Register
2.1 Accepts
the Donor
Register

DONOR

ADMINISTRATI
VE SUPPORT
SYSTEM FOR
ROTARY
BLOOD BANK

Upgrade
Upgrade the Donor
HOSPITAL Address
DONOR

NODAL HOSPITAL

45
[Link] FOR HOSPITAL REGISTRATION

Request
3.1 Accept the
Registration
request

Hospital

3.2 update
the Doctors
& Facility
lists
Update

ADMINISTRATI
VE SUPPORT
SYSTEM FOR
ROTARY
BLOOD BANK

Hospital
Screen | Print

46
[Link] for Receiving Blood

Assign
Duty 5.1 Accept
Duty to a
doctor

Blood Bank

ADMINISTRATIVE SUPPORT SYSTEM

FOR ROTARY BLOOD BANK

Assign
Doctors

Collect
Blood 5.2
operate a
patient to
receive
eye
5.3 update
Blood
Bank

Patient

Blood Bank

47
[Link] for doctor registration

Apply
4:1
Accepts
Doctor data

Doctor

ADMINISTRATIVE
Informs SUPPORT SYSTEM FOR
ROTARY BLOOD BANK

Update

Print
screen

Doctor

48
4.5 MODULES
Different modules that makeup these systems are briefly described below:

Module 1: Password Module

In this module, User enters a password and the software checks its validity. If the password is valid
then option is given to change the password, otherwise “Invalid User/Password” message is
displayed.

Module 2: Creating new Entity (Users, Donators, Receivers, Patietns, Hospitals etc.)
In this module, whenever a new entity is required to be added the corresponding forms are opened
and the database is manipulated to check whether the data is already existing or not. If it already
exists, then it prompts that “Entry already existing” and if not than the data is entered with the
various validation checks.

Module 3: Modifying/Updating Existing Entities

In this module, whenever an existing entity is required to be modified the corresponding forms are
opened and the database is manipulated and the data is fetched. Now the user can made the required
changes and then accordingly, he updates the data. Again, the checks are followed in case there is
any invalid entry. For example if some purchase order has already been raised but not dispatched
than it can be modified accordingly if there is any change in the order from the customer side.

Module 4: Searching
The Search page will have controls for selecting different possible values for all of the fields, as
described above. This will search for all the donators, receivers, doctors, patients in the database
which match the given criteria.

Module 5: Donators

This module is related to donators. Database is maintained for the donators. Some persons only
enquire about it but some are really interested in donations. It is important to know about their
physical or health status

49
Module 6: Receivers
This module is related to receivers. Database is maintained for the receivers.

Module 7: Hospitals
This module is related to nodal hospitals, registration of Hospitals.

Module 8: Benefits

 Increased productivity and operational savings

 Value added services to Donors
 Donor records available on emergency blood requirements
 Blood Component Preparation made easier
 Blood Bag orders and tracking are made easier
 Blood Cross Matching now simpler and quicker
 Blood issue records updates now faster
 Blood Bags Inventory alerts
 Assist users in planning for Blood Camps

Module 9: Queries:
In this module user can query about the donations, receiving bloods, blood problems etc.

Module 10: Terms and Conditions:

This module is related to the terms and conditions for the donation, transplantation etc

Module 11: Administration screen:

The Blood Bank system will be able to differentiate between administration and normal users.
Logging in with administrator user will provide access to administrations functions which will be:
Creating Users getting the details of patients, donators, doctors etc. and then responding them

Module 12 : Validation of Data Entered by the User & Error Handling

In this module, the validity of data entered by the user during the various business processes is
checked through various validation checks. For example, there should not be any characters entered

50
in the numeric fields, likewise if there is any error occurs than it should handle that particular error
and give the required messages.

Module 13: Report Generation

In this module reports are generated for the following entities:
a) Users Reports
a) Donators Details
a) Receivers Details
a) Blood Bank Details
a) Search Donators -city ,blood group wise
a) Nodal Hospitals Registered.

Module 14: Feedbacks

In this module, Feedback details are given by the users and checked by the administrator of the site.

4.6 PROCESS LOGIC FOR EACH MODULE:

Process Logic of Module is a tool that may be useful in planning and evaluating projects. Our logic
model contains four components with Inputs-Outputs-Outcomes being central to the built in response
to the model:

 Situation: The context and need that gives rise to a project or initiative; logic modules are
built in response to an existing situation.

 Inputs: The resources, contributions, and investments that are made in response to the
situation. Inputs lead to Outputs.
 Outputs: The activities, products, methods, and services that reach people and users. Outputs
lead to outcomes.
 Outcomes: The results and benefits for individuals, groups, agencies, communities and/or
systems.

(IV) Report Generation

51
Reports that can be generated :
 Users Reports
 Donators Details
 Receivers Details
 Blood Bank Details
 Search Donators -city ,blood group wise
 Nodal Hospitals Registered.

USER

Log in

General Administrator
user
Donator
Donator
Receiver

Receivers
hospital

Patients
Patient for corneal
transplantation
Doctors
Doctor

Feedback Feed back/

Queries

Queries/FAQ Nodal
Hospital

52
4.7 TOOLS / PLATFORM, HARDWARE AND SOFTWARE
REQUIREMENT SPECIFICATION

HARDWARE

Processor : Pentium 2.4 GHz or above

Memory : 256 MB RAM or above

Cache Memory : 128 KB or above

Hard Disk : 3 GB or above [at least 3 MB free space required]

Pen Drive : 5 GB

Printer : Laser Printer

SOFTWARE

Operating System : Windows XP (Professional).

Font-End Tool : JSP,Ajax,Java Script

Back-End : My Sql

53
4.8 SCHEDULING

Scheduling of a software project does not differ greatly from scheduling of any multi- task
engineering effort. Therefore, generalized project scheduling tools and techniques can be applied
with little modification to software projects.

Program evaluation and review technique (PERT) and critical path method (CPM) are two project
scheduling methods that can be applied to software development. Both techniques are driven by
information already developed in earlier project planning activities.

Estimates of Effort

 A decomposition of the product function.

 The selection of the appropriate process model and task set.
 Decomposition of tasks.

Interdependencies among tasks may be defined using a task network. Tasks, sometimes called the
project Work Breakdown Structure (WBS) are defined for the product as a whole or for individual
functions.

Both PERT and CPM provide quantitative tools that allow the software planner to (1) determine the
critical path-the chain of tasks that determines the duration of the project; (2) establish "most likely"
time estimates for individual tasks by applying statistical models; and (3) calculate "boundary times"
that define a time window" for a particular task.

Boundary time calculations can be very useful in software project scheduling. Slippage in the design
of one function, for example, can retard further development of other functions. It describes
important boundary times that may be discerned from a PERT or CPM network: (I) the earliest time
that a task can begin when preceding tasks are completed in the shortest possible time, (2) the latest
time for task initiation before the minimum project completion time is delayed, (3) the earliest finish-
the sum of the earliest start and the task duration, (4) the latest finish- the latest start time added to
task duration, and (5) the total float-the amount of surplus time or leeway allowed in scheduling
tasks so that the network critical path maintained on schedule. Boundary time calculations lead to a

54
determination of critical path and provide the manager with a quantitative method for evaluating
progress as tasks are completed.

Both PERT and CPM have been implemented in a wide variety of automated tools that are available
for the personal computer. Such tools are easy to use and take the scheduling methods described
previously available to every software project manager.

55
5.1 SOURCE CODE

[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<script>
function validateForm()
{
if([Link]=="")
{
alert("Name should not be left blank");
[Link]();
return false;
}
else if([Link]=="")

56
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
}
</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
#Layer1 {
position:absolute;
left:428px;
top:211px;
width:492px;
height:228px;

57
z-index:1;
}
.style13 {font-size: 24px}
body {
background-image: url();
}
-->
</style></head>

<body>
<form id="form4" name="form4" method="post" action="[Link]">

<td height="18" colspan="6" align="right" valign="middle"><table width="956">

<tr>
<td width="570"><img src="images/[Link]" width="444" height="37" /></td>
<td width="375"><img src="images/[Link]" width="213" height="69" align="right" /></td>
</tr>
<tr>
<td colspan="2"><img src="images/[Link]" width="949" height="57" /></td>
</tr>
<tr>
<td colspan="2" align="right" bgcolor="#990000"><span class="style1">Email</span>
<input type="text" name="t1" />
<span class="style1">Password</span>
<input type="password" name="t2" />
<input type="submit" name="l1" value="Login" />
<a href="#" class="style1"></a></td>
</tr>
</table>

<label for="pass"></label></td>
</form>

<form id="form2" name="form2" method="post" onSubmit="return validateForm()" action="[Link]">

<table width="200" height="221">
<tr>
<td height="215"><img src="images/[Link]" width="384" height="388" /></td>

58
</tr>
</table>

<p>&nbsp;</p>
<table width="958" border="1">
<tr>
<td align="center" bgcolor="#990000"><span class="style1">Copyright&copy;&nbsp;2010 All right reserved
BloodBank</span></td>
</tr>
</table>

<div id="Layer1">
<table width="486">
<tr>
<td height="93" colspan="3" valign="middle"><div class="style13">Sign Up</div>
<div>It's free, and always will be.</div></td>
</tr>
<tr>
<td width="52">&nbsp;</td>
<td width="130">Username</td>
<td width="288"><input name="t7" type="text" size="40" />
</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>Password</td>
<td><input name="t3" type="password" size="40" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>Email</td>
<td><input name="t4" type="text" size="40" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>Security_Question</td>
<td><input name="t5" type="text" size="40" /></td>
</tr>
<tr>
<td>&nbsp;</td>

59
<td>Answer</td>
<td><input name="t6" type="text" size="40" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="s1" value="Sign Up" /></td>
</tr>
</table>
</div>
</form>
</body>
</html>
Login-([Link])

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<%
String ll=[Link]("l1");

String uu=[Link]("t1");
String pas=[Link]("t2");

[Link]("[Link]");
Connection con=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement st=[Link]();
int i=0;
if([Link]("Login"))
{
String query="select * from login where Email='"+uu+"' and Password='"+pas+"'";
ResultSet rs=[Link](query);

60
while([Link]())
{
i++;
}
}
if(i>0)
{
%>
<jsp:forward page="[Link]"/>
<%
}
else
%>
<jsp:forward page="[Link]"/>

</body>
</html>

61
Sign up

Sign [Link]([Link])

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<%
String s1=[Link]("s1");

String a=[Link]("t7");
String b=[Link]("t3");
String c=[Link]("t4");
String d=[Link]("t5");

62
String e=[Link]("t6");

[Link]("[Link]");
Connection con=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement st=[Link]();

if([Link]("Sign Up"))
{
[Link]("Insert into login(Username,Password,Email,Security_Question,Answer)
values('"+a+"','"+b+"','"+c+"','"+d+"','"+e+"')");

[Link]("[Link]");
}
%>

</body>
</html>

[Link]

63
purpose of my exercise is perform each user&rsquo;s activity in computerized way rather than manually which is time
consuming. People will no longer get caught in hospital red tape to procure blood. Detailed information about the blood
stock position, blood group, blood components and the procedure of getting blood is now available on the Internet. It is
Web Based Blood Bank Management System.</p>
<p>&bull;<span class="style10"> Provides the stock of blood for various groups in the various blood banks.<br />
&bull; Provides online registration to people who are willing to donate blood.<br />
&bull; Gives the details of blood donation camps.<br />
&bull; GroupWise listing of various blood groups.<br />
&bull; Citizens get information about the next coming blood donation camp via post or email after registration.<br />
&bull; Online submission of registration forms.<br />
&bull; All the process of submission of registration form is quite simple.<br />
&bull; Department can collect information regarding various blood groups.<br />
&bull; People can get registration by sitting at home.<br />
&bull; Before any blood donation camp the registered citizens gets all the details regarding the camp.</span></p>
<span class="style10">I am confident that this software package can be readily used by non-programming
personal avoiding human handled chance of error.</span></td>
</tr>
<tr>
<td colspan="2" class="style10"><img src="images/[Link]" width="211" height="106"
/></td>
</tr>
<tr>
<td height="154" colspan="2" class="style10">
<MARQUEE WIDTH=200 height="130" direction="up">
<em>
HelpAge India Donates money<br>
to Blood-Bank Hospital<br>
[January 23 2010] <br>
-The Hindu Cataract Surgery <br>
Camp.[January 30 2010]- The Hind</em>
</MARQUEE> </td>
</tr>
<tr>
<td colspan="8" align="right" valign="bottom" class="style10"><p><span class="style17"><span
class="style10"><a href="[Link]">Feedback</a></span></span><span class="style1"><span
class="style16"><span class="style12"><span class="style17"><span
class="style18">&nbsp;</span></span></span><span
class="style18">&nbsp;&nbsp;&nbsp;</span></span></span><span class="style10"><a
href="[Link]"><strong>Blood_Bank_Stock</strong></a></span><span class="style19"><span

64
class="style16">&nbsp;</span></span><span class="style1"><span class="style16"><span
class="style18">&nbsp;&nbsp;&nbsp;</span></span></span><span class="style10"><a href="campas_list.jsp">Camps
<strong>details</strong></a></span><span class="style1"><span class="style16"><span
class="style18">&nbsp;&nbsp;&nbsp;</span></span></span><span class="style18"><span class="style10"><a
href="[Link]">Logout</a></span></span><span class="style19"><span class="style16"><a href="#"
class="style1">&nbsp;</a></span></span></p>
</td>
</tr>
<tr>
<td height="17" colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved BloodBank</span></td>
</tr>
</table>
</form>
<span class="style10"><span class="style3">

</body>
</html>

65
[Link]([Link])

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style12 {color: #990000}
.style16 {color: #FF0000}
.style17 {font-size: 14px}
.style18 {font-size: 14}
.style19 {color: #FFFFFF; font-size: 12px; }

66
-->
</style></head>

<body>

<table width="966">

<tr>

<td colspan="8" valign="top"><p><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></p>
<p><img src="images/[Link]" width="949" height="57" align="bottom" /></p></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="186" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]" class="style1">
Hospital </a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="88" bgcolor="#990000"><div align="center" class="style1"><a href="Doctor_insert.jsp"
class="style1">Doctor</a></div></td>
<td width="103" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood Bank</a></div></td>
<td width="122" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="98" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="2"><img src="images/[Link]" width="208" height="124" /></td>
<td colspan="6" rowspan="3" align="left" valign="top" bordercolor="#D4D0C8"><p align="right"
class="style10"><a href="[Link]" class="style12">Admin</a></p>
<p align="justify" class="style17"> This is a Project work undertaken in context of partial fulfillment of the
MCA.
I have tried my best to make the complicated process of the Blood banks as simple as possible using Structured
&amp; Modular technique &amp; Menu oriented interface. I have tried to design the software in such a way that user
may not have any difficulty in using this package &amp; further expansion is possible without much effort. &nbsp;Even

67
though I cannot claim that this work to be entirely exhaustive, the main purpose of my exercise is perform each
user&rsquo;s activity in computerized way rather than manually which is time consuming. People will no longer get
caught in hospital red tape to procure blood. Detailed information about the blood stock position, blood group, blood
components and the procedure of getting blood is now available on the Internet. It is Web Based Blood Bank
Management System.</p>
<p>&bull;<span class="style10"> Provides the stock of blood for various groups in the various blood banks.<br />
&bull; Provides online registration to people who are willing to donate blood.<br />
&bull; Gives the details of blood donation camps.<br />
&bull; GroupWise listing of various blood groups.<br />
&bull; Citizens get information about the next coming blood donation camp via post or email after registration.<br />
&bull; Online submission of registration forms.<br />
&bull; All the process of submission of registration form is quite simple.<br />
&bull; Department can collect information regarding various blood groups.<br />
&bull; People can get registration by sitting at home.<br />
&bull; Before any blood donation camp the registered citizens gets all the details regarding the camp.</span></p>
<span class="style10">I am confident that this software package can be readily used by non-programming
personal avoiding human handled chance of error.</span></td>
</tr>
<tr>
<td colspan="2" class="style10"><img src="images/[Link]" width="211" height="106"
/></td>
</tr>
<tr>
<td height="154" colspan="2" class="style10">
<MARQUEE WIDTH=200 height="130" direction="up">
<em>
HelpAge India Donates money<br>
to Blood-Bank Hospital<br>
[January 23 2010] <br>
-The Hindu Cataract Surgery <br>
Camp.[January 30 2010]- The Hind</em>
</MARQUEE> </td>
</tr>
<tr>
<td colspan="8" align="right" valign="bottom" class="style10"><p><span class="style17"><span
class="style10"><a href="[Link]">Feedback</a></span></span><span class="style1"><span
class="style16"><span class="style12"><span class="style17"><span
class="style18">&nbsp;</span></span></span><span
class="style18">&nbsp;&nbsp;&nbsp;</span></span></span><span class="style10"><a
href="[Link]"><strong>Blood_Bank_Stock</strong></a></span><span class="style19"><span

68
class="style16">&nbsp;</span></span><span class="style1"><span class="style16"><span
class="style18">&nbsp;&nbsp;&nbsp;</span></span></span><span class="style10"><a href="campas_list.jsp">Camps
<strong>details</strong></a></span><span class="style1"><span class="style16"><span
class="style18">&nbsp;&nbsp;&nbsp;</span></span></span><span class="style18"><span class="style10"><a
href="[Link]">Logout</a></span></span><span class="style19"><span class="style16"><a href="#"
class="style1">&nbsp;</a></span></span></p>
</td>
</tr>
<tr>
<td height="17" colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved BloodBank</span></td>
</tr>
</table>
</form>
<span class="style10"><span class="style3">

</body>
</html>

69
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<script>
function validateForm()
{
if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

70
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();

71
return false;
}
else if([Link]==0)
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Filed should not be left blank");
[Link]();
return false;
}

else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

72
}
</script>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
-->
</style></head>

<body>
<form name="form2" method="post" onSubmit="return validateForm()" action="donar_code.jsp">
<table width="978">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="76" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="141" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="179" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Hospital </a></div></td>
<td width="141" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>

73
<td width="84" bgcolor="#990000"><div align="center" class="style1"><a href="Doctor_insert.jsp"
class="style1">Doctor</a></div></td>
<td width="98" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood- Bank</a></div></td>
<td width="117" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="106" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="2" rowspan="2"><span class="style10"><img src="images/[Link]"
width="219" height="182" /></span></td>
<td colspan="6" align="left" valign="top" bordercolor="#D4D0C8">
<table width="730" height="38" border="1">
<tr>
<td bgcolor="#999999"><div align="left" class="style1">Please Your Blood </div></td>
</tr>
</table>
<p align="left" class="style10"><img src="images/[Link]" width="735" height="12" /></p> </td>
</tr>
<tr>
<td colspan="6" align="left" valign="top">
<table width="420">
<tr>
<td width="155">Donar_id</td>
<td width="249"><label>
<input type="text" name="t1" />
</label></td>
</tr>
<tr>
<td>Name</td>
<td><label>
<input type="text" name="t2" />
</label></td>
</tr>
<tr>
<td bordercolor="1">Address </td>
<td><label>
<input type="text" name="t3" />
</label></td>

74
</tr>
<tr>
<td>City</td>
<td><label>
<input type="text" name="t4" />
</label></td>
</tr>
<tr>
<td>State</td>
<td><label>
<input type="text" name="t5" />
</label></td>
</tr>
<tr>
<td>Email</td>
<td><label>
<input type="text" name="t6" />
</label></td>
</tr>
</table> </td>
</tr>
<tr>
<td colspan="2" class="style10">
<MARQUEE WIDTH=200 height="130" direction="up">
<em>
HelpAge India Donates money<br>
to Blood-Bank Hospital<br>
[January 23 2010] <br>
-The Hindu Cataract Surgery <br>
Camp.[January 30 2010]- The Hind</em>
</MARQUEE> </td>
<td colspan="6" align="left" valign="top"
class="style10">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;
<div align="left">

75
<table width="417">
<tr>
<td width="155">Phone</td>
<td width="246">
<input type="text" name="t7" /> </td>
</tr>
<tr>
<td>Blood_Group</td>
<td>
<label>
<select name="s1">
<option selected="selected">Select</option>
<option>A+</option>
<option>O+</option>
<option>B+</option>
<option>B-</option>
<option>O-</option>
<option>A-</option>
<option>OTHER</option>
</select>
</label> </td>
</tr>
<tr>
<td>Physical_Status</td>
<td>
<select name="s2">
<option selected="selected">Select</option>
<option>HandiCap</option>
<option>Normal</option>
</select> </td>
</tr>
<tr>
<td>Diabetic</td>
<td>
<select name="s3">
<option selected="selected">Select</option>
<option>NORMAL</option>
<option>HIGH</option>
<option>LOW</option>
</select> </td>

76
</tr>
<tr>
<td>Blood_Pressure</td>
<td>
<select name="s4">
<option selected="selected">Select</option>
<option>NORMAL</option>
<option>HIGH</option>
<option>LOW</option>
</select> </td>
</tr>
<tr>
<td>Weight</td>
<td>
<input type="text" name="t8" /> </td>
</tr>
<tr>
<td>Remark</td>
<td><textarea name="t9"></textarea></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>
<label>
<input type="submit" name="Submit" value="Submit" />
</label> </td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>

</form>

77
<span class="style10"><span class="style3">
<span class="style5"></span>
</body>
</html>

Donar_code.jsp

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Doctor Details</title>
</head>

<body>
<%
String a=[Link]("t1");
String b=[Link]("t2");
String c=[Link]("t3");
String d=[Link]("t4");
String e=[Link]("t5");
String f=[Link]("t6");
String g=[Link]("t7");

String h=[Link]("s1");
String i=[Link]("s2");
String j=[Link]("s3");
String k=[Link]("s4");

String l=[Link]("t8");
String m=[Link]("t9");

[Link](a+b+c+d+e+f+g+h+i+j+k+l+m);

[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");

78
Statement st=[Link]();
[Link]("Insert into
donar(Donar_id,Name,Address,City,State,Email,Phone,Blood_Group,Physical_Status,Diabetic,Blood_Pressure,Weight,
Remark) values('"+a+"','"+b+"','"+c+"','"+d+"','"+e+"','"+f+"','"+g+"','"+h+"','"+i+"','"+j+"','"+k+"','"+l+"','"+m+"')");
[Link]("[Link]");
%>
</body>
</html>

[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<script>
function validateForm()
{
if([Link]=="")
{
alert("Field should not be left blank");

79
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;

80
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
}

</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
-->
</style></head>

<body>
<form id="form2" name="form2" method="post" onSubmit="return validateForm()" action="[Link]">
<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>

81
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="186" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]" class="style1">
Hospital </a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="88" bgcolor="#990000"><div align="center" class="style1"><a href="Doctor_insert.jsp"
class="style1">Doctor</a></div></td>
<td width="103" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood Bank</a></div></td>
<td width="122" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="98" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="2" rowspan="2"><img src="images/[Link]" width="219" height="182"
/></td>
<td colspan="6" align="left" valign="top" bordercolor="#D4D0C8">

<table width="730" height="50" border="1">

<tr>
<td bgcolor="#999999"><div align="left" class="style1">Hospital Registration </div></td>
</tr>
</table>
<p align="left" class="style10">&nbsp;</p> </td>
</tr>
<tr>
<td colspan="6" align="left" valign="top">
<table width="420">
<tr>
<td width="155">Hospital_Name</td>
<td width="249"><label>
<input type="text" name="t1" />
</label></td>

82
</tr>
<tr>
<td>Address</td>
<td><label>
<input type="text" name="t2" />
</label></td>
</tr>
<tr>
<td bordercolor="1">City</td>
<td><label>
<input type="text" name="t3" />
</label></td>
</tr>
<tr>
<td>State</td>
<td><label>
<input type="text" name="t4" />
</label></td>
</tr>
<tr>
<td>BloodGroup_req</td>
<td><label>
<input type="text" name="t5" />
</label></td>
</tr>
<tr>
<td>Qty_req</td>
<td><label>
<input type="text" name="t6" />
</label></td>
</tr>
<tr>
<td>Qty_avaliv</td>
<td><input type="text" name="t7" /></td>
</tr>
<tr>
<td>Details</td>
<td><input type="text" name="t8" /></td>
</tr>
<tr>

83
<td>Conatct_person</td>
<td><input type="text" name="t9" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="submit" name="Submit" value="Submit" /></td>
</tr>
</table> </td>
</tr>
<tr>
<td colspan="2" class="style10">
<MARQUEE WIDTH=200 height="130" direction="up">
<em>
HelpAge India Donates money<br>
to Blood-Bank Hospital<br>
[January 23 2010] <br>
-The Hindu Cataract Surgery <br>
Camp.[January 30 2010]- The Hind</em>
</MARQUEE> </td>
<td colspan="6" align="left" valign="top"
class="style10">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;
<div align="left"></div></td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>
</form>

<span class="style10"><span class="style3">

<span class="style5"></span>
</body>

84
</html>

[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<script>
function validateForm()
{
if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();

85
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
}

</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}

86
.style10 {font-size: 12px}
-->
</style></head>

<body>
<form id="form2" name="form2" method="post" onSubmit="return validateForm()" action="[Link]">
<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="186" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]" class="style1">
Hospital </a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="88" bgcolor="#990000"><div align="center" class="style1"><a href="Doctor_insert.jsp"
class="style1">Doctor</a></div></td>
<td width="103" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood Bank</a></div></td>
<td width="122" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="98" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="2" rowspan="2"><img src="images/[Link]" width="219" height="182"
/></td>
<td colspan="6" align="left" valign="top" bordercolor="#D4D0C8">

<table width="730" height="50" border="1">

87
<tr>
<td bgcolor="#999999"><div align="left" class="style1">Hospital Registration </div></td>
</tr>
</table>
<p align="left" class="style10">&nbsp;</p> </td>
</tr>
<tr>
<td colspan="6" align="left" valign="top">
<table width="420">
<tr>
<td width="155">Hospital_Name</td>
<td width="249"><label>
<input type="text" name="t1" />
</label></td>
</tr>
<tr>
<td>Address</td>
<td><label>
<input type="text" name="t2" />
</label></td>
</tr>
<tr>
<td bordercolor="1">City</td>
<td><label>
<input type="text" name="t3" />
</label></td>
</tr>
<tr>
<td>State</td>
<td><label>
<input type="text" name="t4" />
</label></td>
</tr>
<tr>
<td>BloodGroup_req</td>
<td><label>
<input type="text" name="t5" />
</label></td>
</tr>
<tr>

88
<td>Qty_req</td>
<td><label>
<input type="text" name="t6" />
</label></td>
</tr>
<tr>
<td>Qty_avaliv</td>
<td><input type="text" name="t7" /></td>
</tr>
<tr>
<td>Details</td>
<td><input type="text" name="t8" /></td>
</tr>
<tr>
<td>Conatct_person</td>
<td><input type="text" name="t9" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="submit" name="Submit" value="Submit" /></td>
</tr>
</table> </td>
</tr>
<tr>
<td colspan="2" class="style10">
<MARQUEE WIDTH=200 height="130" direction="up">
<em>
HelpAge India Donates money<br>
to Blood-Bank Hospital<br>
[January 23 2010] <br>
-The Hindu Cataract Surgery <br>
Camp.[January 30 2010]- The Hind</em>
</MARQUEE> </td>
<td colspan="6" align="left" valign="top"
class="style10">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp

89
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;
<div align="left"></div></td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>
</form>

<span class="style10"><span class="style3">

<span class="style5"></span>
</body>
</html>

[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]

90
<script>
function validateForm()
{
if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")

91
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]==0)
{
alert("Field should not be left blank");
[Link]();
return false;

92
}

else if([Link]==0)
{
alert("Field should not be left blank");
[Link]();
return false;
}

else if([Link]=="")
{
alert("Filed should not be left blank");
[Link]();
return false;
}

else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

}
</script>
<head>

93
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
-->
</style></head>

<body>
<form name="form2" method="post" onSubmit="return validateForm()" action="receiver_code.jsp">
<table width="978">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="76" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="141" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="179" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Hospital </a></div></td>
<td width="141" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="84" bgcolor="#990000"><div align="center" class="style1"><a href="Doctor_insert.jsp"
class="style1">Doctor</a></div></td>
<td width="98" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood-Bank</a></div></td>

94
<td width="117" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="106" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="2" rowspan="2"><span class="style10"><img src="images/[Link]"
width="219" height="182" /></span></td>
<td colspan="6" align="left" valign="top" bordercolor="#D4D0C8">
<table width="730" height="38" border="1">
<tr>
<td bgcolor="#999999"><div align="left" class="style1"><span class="style2">Blood Receiver Details
</span></div></td>
</tr>
</table>
<p align="left" class="style10"><img src="images/[Link]" width="735" height="12" /></p> </td>
</tr>
<tr>
<td colspan="6" align="left" valign="top">
<table width="420">
<tr>
<td width="155">Donar_id</td>
<td width="249"><label>
<input type="text" name="t1" />
</label></td>
</tr>
<tr>
<td>Name</td>
<td><label>
<input type="text" name="t2" />
</label></td>
</tr>
<tr>
<td bordercolor="1">Address </td>
<td><label>
<input type="text" name="t3" />
</label></td>
</tr>
<tr>
<td>City</td>

95
<td><label>
<input type="text" name="t4" />
</label></td>
</tr>
<tr>
<td>State</td>
<td><label>
<input type="text" name="t5" />
</label></td>
</tr>
<tr>
<td>Email</td>
<td><label>
<input type="text" name="t6" />
</label></td>
</tr>
</table> </td>
</tr>
<tr>
<td colspan="2" class="style10">
<MARQUEE WIDTH=200 height="130" direction="up">
<em>
HelpAge India Donates money<br>
to Blood-Bank Hospital<br>
[January 23 2010] <br>
-The Hindu Cataract Surgery <br>
Camp.[January 30 2010]- The Hind</em>
</MARQUEE> </td>
<td colspan="6" align="left" valign="top"
class="style10">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;
<div align="left">
<table width="417">
<tr>
<td width="155">Phone</td>

96
<td width="246">
<input type="text" name="t7" /> </td>
</tr>
<tr>
<td>Blood_Group</td>
<td>
<label>
<select name="s1">
<option>Select</option>
<option>A+</option>
<option>O+</option>
<option>B+</option>
<option>B-</option>
<option>O-</option>
<option>A-</option>
<option>OTHER</option>
</select>
</label> </td>
</tr>
<tr>
<td>Physical_Status</td>
<td>
<select name="s2">
<option selected="selected">Select</option>
<option>Handicap</option>
<option>Normal</option>
</select> </td>
</tr>
<tr>
<td>Diabetic</td>
<td>
<select name="s3">
<option>Select</option>
<option>NORMAL</option>
<option>HIGH</option>
<option>LOW</option>
</select> </td>
</tr>
<tr>
<td>Blood_Pressure</td>

97
<td>
<select name="s4">
<option>Select</option>
<option>NORMAL</option>
<option>HIGH</option>
<option>LOW</option>
</select> </td>
</tr>
<tr>
<td>Weight</td>
<td>
<input type="text" name="t8" /> </td>
</tr>
<tr>
<td>Remark</td>
<td><textarea name="t9"></textarea></td>
</tr>
<tr>
<td>NumberofBottelReq</td>
<td><input type="text" name="t10" /></td>
</tr>
<tr>
<td>Doctor_name</td>
<td><input type="text" name="t11" /></td>
</tr>
<tr>
<td>Hospital</td>
<td><input type="text" name="t12" /></td>
</tr>
<tr>
<td>Desease</td>
<td><select name="s5">
<option>Select</option>
<option>NORMAL</option>
<option>HIGH</option>
<option>LOW</option>
</select></td>
</tr>
<tr>
<td>&nbsp;</td>

98
<td>
<label>
<input type="submit" name="Submit" value="Submit" />
</label> </td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>

</form>

<span class="style10"><span class="style3">

<span class="style5"></span>
</body>
</html>
Receiver_code.jsp

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Doctor Details</title>
</head>

<body>
<%
String a=[Link]("t1");
String b=[Link]("t2");
String c=[Link]("t3");
String d=[Link]("t4");
String e=[Link]("t5");
String f=[Link]("t6");

99
String g=[Link]("t7");

String h=[Link]("s1");
String i=[Link]("s2");
String j=[Link]("s3");
String k=[Link]("s4");
String k1=[Link]("s5");

String l=[Link]("t8");
String m=[Link]("t9");
String n=[Link]("t10");
String o=[Link]("t11");
String p=[Link]("t12");

[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement st=[Link]();
[Link]("Insert into
receiver(Receiver_id,Name,Address,City,State,Email,Phone,Blood_Group,Physical_Status,Diabetic,Blood_Pressure,Wei
ght,Remark,NumberofBottelReq,Doctor_name,Hospital,Desease)
values('"+a+"','"+b+"','"+c+"','"+d+"','"+e+"','"+f+"','"+g+"','"+h+"','"+i+"','"+j+"','"+k+"','"+k1+"','"+l+"','"+m+"','"+n+"','
"+o+"','"+p+"')");
[Link]("[Link]");
%>
</body>
</html>

100
Doctor_insert.jsp

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<script>
function validateForm()
{
if([Link]=="")
{
alert("ID should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{

101
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

102
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

}
</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
-->
</style></head>

<body>
<form id="form2" name="form2" method="post" onSubmit="return validateForm()" action="Doctor_code_insert.jsp">

<table width="966">

103
<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="186" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]" class="style1">
Hospital </a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="88" bgcolor="#990000"><div align="center" class="style1"><a href="Doctor_insert.jsp"
class="style1">Doctor</a></div></td>
<td width="103" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood-Bank</a></div></td>
<td width="122" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="98" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="2" rowspan="3">
<span class="style10">
<MARQUEE WIDTH=200 height="130" direction="up">
<em>
HelpAge India Donates money<br>
to Blood-Bank Hospital<br>
[January 23 2010] <br>
-The Hindu Cataract Surgery <br>
Camp.[January 30 2010]- The Hind</em>
</MARQUEE>
</span> </td>
<td colspan="6" align="left" valign="top" bordercolor="#D4D0C8">

104
<table width="730" height="50" border="1">
<tr>
<td bgcolor="#999999"><div align="left" class="style1">Doctor Details </div></td>
</tr>
</table>
<p align="left" class="style10"><img src="images/[Link]" width="709" height="12" /></p> </td>
</tr>
<tr>
<td colspan="6" align="left" valign="top">

<table width="420">
<tr>
<td width="155">DoctorId</td>
<td width="249"><label>
<input type="text" name="t1" />
</label></td>
</tr>
<tr>
<td>Name</td>
<td><label>
<input type="text" name="t2" />
</label></td>
</tr>
<tr>
<td bordercolor="1">Address </td>
<td><label>
<input type="text" name="t3" />
</label></td>
</tr>
<tr>
<td>Email</td>
<td><label>
<input type="text" name="t4" />
</label></td>
</tr>
<tr>
<td>Phone</td>
<td><label>
<input type="text" name="t5" />
</label></td>

105
</tr>
<tr>
<td>Gender</td>
<td><label>
<input type="text" name="t6" />
</label></td>
</tr>
</table> </td>
</tr>
<tr>
<td colspan="6" align="left" valign="top"
class="style10">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;
<div align="left">
<table width="417">
<tr>
<td width="155">Qualification</td>
<td width="246"><input type="text" name="t7" /></td>
</tr>
<tr>
<td>Experience</td>
<td><input type="text" name="t8" /></td>
</tr>
<tr>
<td>Age </td>
<td><input type="text" name="t9" /></td>
</tr>
<tr>
<td>Practising at</td>
<td><input type="text" name="t10" /></td>
</tr>
<tr>
<td>Other Details</td>
<td><input type="text" name="t11" /></td>
</tr>

106
<tr>
<td>&nbsp;</td>
<td>

<input type="submit" name="Submit" value="Submit" /> </td>

</tr>
</table>
</div></td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>
</form>

<span class="style10"><span class="style3">

<span class="style5"></span>
</body>
</html>
Doctor_code_insert.jsp

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Doctor Details</title>
</head>

<body>
<%
String a=[Link]("t1");
String b=[Link]("t2");
String c=[Link]("t3");

107
String d=[Link]("t4");
String e=[Link]("t5");
String f=[Link]("t6");
String g=[Link]("t7");
String h=[Link]("t8");
String i=[Link]("t9");
String j=[Link]("t10");
String k=[Link]("t11");

[Link](a+b+c+d+e+f+g+h+i+j+k);

[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement st=[Link]();
[Link]("Insert into
doctor(DoctorId,Name,Adderess,Email,Phone,Gender,Qualification,Experience,Age,Practising_At,OtherDetails)
values('"+a+"','"+b+"','"+c+"','"+d+"','"+e+"','"+f+"','"+g+"','"+h+"','"+i+"','"+j+"','"+k+"')");
[Link]("[Link]");
%>
</body>
</html>

108
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style12 {color: #990000}
-->
</style></head>

109
<body>

<table width="966">

<tr>

<td colspan="8" valign="top"><p><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></p>
<p><img src="images/[Link]" width="949" height="57" align="bottom" /></p></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="186" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]" class="style1">
Hospital </a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="88" bgcolor="#990000"><div align="center" class="style1"><a href="Doctor_insert.jsp"
class="style1">Doctor</a></div></td>
<td width="103" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood Bank</a></div></td>
<td width="122" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="98" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>

<tr>
<td colspan="8" align="left" class="style10">

<p align="right" class="style10"><img src="images/[Link]" width="957" height="15" /></p></td>

</tr>
<tr>
<td colspan="8" align="left" valign="bottom" bgcolor="#CCCCCC" class="style10"><p class="style1">
<%@ include file="blood_1.jsp" %> </p> </td>
</tr>
<tr><td>&nbsp; </td></tr>
<tr><td>&nbsp; </td></tr>

110
<tr><td>&nbsp; </td></tr>
<tr><td>&nbsp; </td></tr>
<tr><td>&nbsp; </td></tr>
<tr><td>&nbsp; </td></tr>
<tr><td>&nbsp; </td></tr>
<tr><td>&nbsp; </td></tr>
<tr>

<td height="17" colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span

class="style1">Copyright&copy;&nbsp;2010 All right reserved BloodBank</span></td>
</tr>
</table>
</form>
<span class="style10"><span class="style3">
<span class="style5"></span>
</body>
</html>

111
[Link]
var xmlhttp;
function showUser(str)
{
xmlhttp=GetXmlHttpObject();
if(xmlhttp==null)
{
alert("Browser does not support HTTP Request");
return;
}
var url="bloodbanklist_location.jsp";
url=url+"?q="+str;
[Link]=stateChanged;
[Link]("GET",url,true);
[Link](null);
}
function stateChanged()
{
if([Link]==4)
{
[Link]("txHint").innerHTML=[Link];
}
}
function GetXmlHttpObject()
{
if([Link])
{
return new XMLHttpRequest();
}
if([Link])
{
return new ActiveXObject("[Link]");
}
return null;
}

112
Blood_1.jsp

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Ajax Example</title>
<script type="text/javascript" src="[Link]"></script>
</head>
<body>
<form>
<%
[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost/bloodbank","root","1234");
Statement statement=[Link]();
String query="select distinct State from booldbanklndian";
ResultSet rs=[Link](query);
%>
<label>
<select name= "user" onchange="showUser([Link])">
<% while([Link]()){%>
<option value="<%=[Link](1)%>" selected="selected"><%=[Link](1)%></option>
<%}%>
</select>
</label>
</form>
<div style="background-color:#FFFFFF "id="txHint"><b>Information will be listed here.</b></div>
</body>
</html>

113
Bloodbanklist_location

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title></title>
</head>

<body>
<%
String mg=[Link]("q");
[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost/bloodbank","root","1234");
Statement statement=[Link]();
String query="select * from booldbanklndian where State='"+mg+"'";
ResultSet rs=[Link](query);
%>

<table border="0" width="970">

<tr>

<td bgcolor="#999999" style="font-size:18px" align="center"><b>Bank_id</b></td>

<td bgcolor="#999999" style="font-size:18px" align="center"><b>Name</b></td>
<td bgcolor="#999999" style="font-size:18px" align="center"><b>Location</b></td>
<td bgcolor="#999999" style="font-size:18px" align="center"><b>Phone</b></td>
<%
while([Link]())
{
%>
<tr>
<td align="center"><%=[Link](1)%></td>
<td align="center"><%=[Link](3)%></td>
<td align="center"><%=[Link](4)%></td>
<td align="center"><%=[Link](5)%></td>

<%

114
}
%>

</body>
</html>
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}

115
.style6 {font-size: 12}
.style8 {font-size: 11px}
.style10 {font-size: 36px}
.style11 {font-size: 12px}
-->
</style></head>

<body>

<table width="966" border="0">

<tr>

<td colspan="8"><img src="images/[Link]" width="528" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="969" height="57" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="186" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]" class="style1">
Hospital </a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="88" bgcolor="#990000"><div align="center" class="style1"><a href="Doctor_insert.jsp"
class="style1">Doctor</a></div></td>
<td width="103" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood-Bank</a></div></td>
<td width="122" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="98" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="2"><img src="images/[Link]" width="219" height="160" /></td>
<td colspan="6" rowspan="2" align="left" valign="top"><h1>&nbsp;</h1>

116
<table width="723" align="left">
<tr>
<td width="237" height="128"><p class="style10">Contact Us</p>
<p><strong>Blood-Bank Management Pvt Ltd</strong> </p>
<p>VAISHALI SECTOR-4, <br />
<br />
<br />
<strong>T:</strong> &nbsp; +91-9868885505 <br />
<strong>E:</strong> &nbsp; <a href="[Link]
<td width="474"><img src="images/[Link]" width="466" height="174" /></td>
</tr>
</table>
<p>&nbsp;</p> </td>
</tr>
<tr>
<td colspan="2"><span class="style11"><img src="images/[Link]" width="219"
height="120" /></span></td>
</tr>
<tr>
<td colspan="2"><span class="style8">
<MARQUEE WIDTH=200 height="130" direction="up">
<em>
HelpAge India Donates money<br>
to Blood-Bank Hospital<br>
[January 23 2010] <br>
-The Hindu Cataract Surgery <br>
Camp.[January 30 2010]- The Hind</em>
</MARQUEE>
</span> </td>
<td colspan="6">&nbsp;</td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#990000"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>
</form>
<form id="form1" name="form1" method="post" action="">

117
<span class="style3">
<span class="style5">
<span class="style6">

</span>
</body>
</html>

[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {

118
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style6 {font-size: 12}
.style8 {font-size: 11px}
.style11 {font-size: 12px}
.style12 {font-size: medium}
-->
</style></head>

<body>

<table width="985" border="0">

<tr>

<td colspan="8"><p><img src="images/[Link]" width="528" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></p>
<p><img src="images/[Link]" width="969" height="57" /></p></td>
</tr>
<tr>
<td width="122" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="94" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="203" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]" class="style1">
Hospital </a></div></td>
<td width="180" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="92" bgcolor="#990000"><div align="center" class="style1"><a href="Doctor_insert.jsp"
class="style1">Doctor</a></div></td>
<td width="87" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood Bank</a></div></td>
<td width="107" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="66" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>

119
<td colspan="2"><img src="images/[Link]" width="219" height="160" /></td>
<td colspan="6" align="left" valign="top"><p class="style12">I am confident that this software package can be
readily used by non-programming personal avoiding human handled chance of error. This project is used by two types of
users<br />
<em>-&gt; Online Users.
<br />
--&gt;Administrator.</em><br />
Online users can enquire about the blood donation if he/she wants to donate or receive blood. Doctors, Nodal
Hospitals can also register through this site.&nbsp;Administrator can maintain daily updates in the requests of the users,
doctors, hospitals etc. Administrator is must be an authorized user. He can further change the password. There is the
facility for password recovery, logout etc. The main objectives of the project are:</p> </td>
</tr>
<tr>
<td colspan="2"><span class="style11"><img src="images/[Link]" width="219"
height="120" /></span></td>
<td colspan="6" align="left" valign="top"><ul>
<li class="style12">The objective of blood bank is to collect and distribute blood</li>
<li class="style12">Collect detailed description of the donors who are interested in blood donation.</li>
<li class="style12">&nbsp;Nodal hospitals registrations.</li>
<li class="style12">&nbsp;Rules, terms and conditions for Blood donation.</li>
</ul>
<p align="left"><span class="style12">I have designed the given proposed system in <strong>JSP</strong> to
automate the process of Rotary Blood Banks <br />
The complete set of rules &amp; procedures related to a blood bank generating report is called
<strong>&ldquo;</strong>Rotary Blood Bank Services<strong>&rdquo;.</strong> My project gives a brief idea
regarding automated Blood Bank activities.</span></p>
</td>
</tr>
<tr>
<td colspan="2"><span class="style8">
<MARQUEE WIDTH=200 height="130" direction="up">
<em>
HelpAge India Donates money<br>
to Blood-Bank Hospital<br>
[January 23 2010] <br>
-The Hindu Cataract Surgery <br>
Camp.[January 30 2010]- The Hind</em>
</MARQUEE>
</span> </td>

120
<td colspan="6" align="left" valign="top"><p align="justify" class="style12">The following steps that give the
detailed information of the need of proposed system are:</p>
<p align="justify" class="style12"><strong>Performance:</strong> During past several decades, the company
records are &nbsp;&nbsp;&nbsp;supposed to be manually handled for all the&nbsp;&nbsp; activities. The manual
handling of the record is time consuming and highly prone to error. To improve the performance of the blood bank, the
computerized system is to be undertaken. The computerized project is fully computerized and user friendly even that any
of the members can see the report and status of the blood bank. </p>
<p align="justify" class="style12"><strong>Efficiency:</strong> The basic need of the project is efficiency. The
project should be efficient so that whenever a new customer record is added, or record is modified or deleted, the record
is updated automatically. </p>
<p align="justify" class="style12"><strong>Control:</strong> The complete control of the project is under the
hands of authorized person who has the password to access this project and illegal access is not supposed to deal with.
All the control is under the administrator and the other members have the rights to just see the records not to change any
transaction or entry.</p>
<p align="justify" class="style12"><strong>Security:</strong> Security is the main criteria for the proposed
system. Since illegal access may corrupt the database. So security has to be given in this project. </p></td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#CC3333"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>
</form>
<span class="style3">
<span class="style5">
<span class="style6">

</span>
</body>
</html>

121
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<script>
function validateForm()
{
if([Link]=="")
{
alert("User Name should be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Password should be left blank");
[Link]();
return false;
}

122
}
</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style11 {font-size: 14px}
.style12 {color: #CCCC99}
-->
</style></head>
<body>

<form id="form1" name="frm" method="post" onSubmit="return validateForm()" action="[Link]">

<table width="966">

<tr>

<td colspan="8" bgcolor="#F198AA"><img src="images/[Link]" width="497" height="45" hspace="110"

/><img src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8" bgcolor="#F198AA"><img src="images/[Link]" width="949" height="57" align="bottom"
/></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donal</a></div></td>
<td width="186" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Nodal Hospital </a></div></td>

123
<td width="147" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="88" bgcolor="#990000"><div align="center" class="style1"><a href="Doctor_insert.jsp"
class="style1">Doctor</a></div></td>
<td width="103" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood Bank</a></div></td>
<td width="122" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="98" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="2" rowspan="3"><span class="style12">
<MARQUEE WIDTH=200 height="130" direction="up">
<em>
H<span class="style10">elpAge India Donates money<br>
to Blood-Bank Hospital<br>
[January 23 2010] <br>
-The Hindu Cataract Surgery <br>
Camp.[January 30 2010]- The Hind</span></em>
</MARQUEE>
</span> </td>
<td colspan="6" align="left" valign="top" bordercolor="#D4D0C8"><p align="right" class="style10"><a
href="#"></a></p>

<p align="justify"><img src="images/[Link]" width="336" height="41" /><img

src="images/admin_logo.gif" width="362" height="162" /></p> </td>
</tr>
<tr>
<td colspan="6" align="left" valign="top" bordercolor="1">

<p>User Id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input name="user" type="text" size="25" />
</p>
<p>Password&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input name="pass" type="password" size="25" maxlength="26" />
</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp

124
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="submit" style="background-color:#990000" "name="Submit" value="Login" />
</p> </td>
</tr>
<tr>
<td colspan="6" align="left" valign="top" class="style10"><p align="justify" class="style11">&nbsp;</p>
<p align="justify" class="style11">&nbsp;</p>
<p align="justify" class="style11">&nbsp;</p></td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>

</frm>
<span class="style10"><span class="style3">
<span class="style5"></span>

</body>
</html>

[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<%
String uu=[Link]("user");
String pas=[Link]("pass");

125
[Link]("[Link]");
Connection con=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement st=[Link]();

String query="select * from admin";

ResultSet rs=[Link](query);
String st1,st2;
while([Link]())
{
st1=[Link](1);
st2=[Link](2);

if([Link](st1) && [Link](st2))

{
%>
<jsp:forward page="[Link]"/>
<%
}
else
{

[Link]("INVILIDE USER NAME OR PASSWORD");

}
}

%>
</body>
</html>

126
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style12 {color: #990000}
.style13 {font-size: 30px}
.style14 {color: #CCCCCC}
-->

127
</style></head>

<body>

<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="186" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]" class="style1">
Hospital </a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="88" bgcolor="#990000"><div align="center" class="style1"><a href="Doctor_insert.jsp"
class="style1">Doctor</a></div></td>
<td width="103" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood- Bank</a></div></td>
<td width="122" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="98" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="8"><form id="form1" name="form1" method="post" action="">
<table width="954" height="50">
<tr>
<td align="right"><div align="center" class="style13"><span class="style14">Welcome tO Admin Report
&nbsp;</span>&nbsp;&nbsp;&nbsp;<img src="images/[Link]" width="75" height="44"
/></div></td>
</tr>

128
</table>
</form> <p align="left" class="style10"><img src="images/[Link]" width="912" height="8" /></p></td>
</tr>
<tr>
<td colspan="2" rowspan="2" class="style10">
<MARQUEE WIDTH=200 height="130" direction="up">
<em>
<span class="style14">HelpAge India Donates money</span><span class="style14"><br>
to Blood-Bank Hospital<br>
[January 23 2010] <br>
-The Hindu Cataract Surgery <br>
Camp.[January 30 2010]- The Hind</span></em>
</MARQUEE> </td>
<td colspan="6" align="left" valign="top"><form id="form2" name="form2" method="post" action="">
<table width="434">
<tr>
<td width="143">&nbsp;</td>
<td width="279">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="[Link] width="10"
height="10">
<param name="movie" value="[Link]" />
<param name="quality" value="high" />
<param name="SCALE" value="noborder" />
<embed src="[Link]" width="10" height="10" quality="high"
pluginspage="[Link]
type="application/x-shockwave-flash" scale="noborder" ></embed>
</object>
<a href="[Link]" class="style12">Blood-Bank List Report(INDIA)</a></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><a href="[Link]" class="style12">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="[Link] width="10"
height="10">
<param name="movie" value="[Link]" />
<param name="quality" value="high" />
<param name="SCALE" value="noborder" />

129
<embed src="[Link]" width="10" height="10" quality="high"
pluginspage="[Link]
type="application/x-shockwave-flash" scale="noborder" ></embed>
</object>
</a><a href="[Link]" class="style12">Blood-Receiver Report</a></td>
</tr>
<tr>
<td bordercolor="1">&nbsp;</td>
<td><a href="[Link]" class="style12">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="[Link] width="10"
height="10">
<param name="movie" value="[Link]" />
<param name="quality" value="high" />
<param name="SCALE" value="noborder" />
<embed src="[Link]" width="10" height="10" quality="high"
pluginspage="[Link]
type="application/x-shockwave-flash" scale="noborder" ></embed>
</object>
</a><a href="Donalr_new.jsp" class="style12">Donar Report</a></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><a href="[Link]" class="style12">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="[Link] width="10"
height="10">
<param name="movie" value="[Link]" />
<param name="quality" value="high" />
<param name="SCALE" value="noborder" />
<embed src="[Link]" width="10" height="10" quality="high"
pluginspage="[Link]
type="application/x-shockwave-flash" scale="noborder" ></embed>
</object>
</a><a href="doctor_list.jsp" class="style12">Doctor List Report</a></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><a href="[Link]" class="style12"> </a><a href="[Link]" class="style12">

130
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="[Link] width="10"
height="10">
<param name="movie" value="[Link]" />
<param name="quality" value="high" />
<param name="SCALE" value="noborder" />
<embed src="[Link]" width="10" height="10" quality="high"
pluginspage="[Link]
type="application/x-shockwave-flash" scale="noborder" ></embed>
</object>
</a><a href="[Link]" class="style12">Hospital Report</a></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><a href="[Link]" class="style12">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="[Link] width="10"
height="10">
<param name="movie" value="[Link]" />
<param name="quality" value="high" />
<param name="SCALE" value="noborder" />
<embed src="[Link]" width="10" height="10" quality="high"
pluginspage="[Link]
type="application/x-shockwave-flash" scale="noborder" ></embed>
</object>
</a><a href="Blood_bank_stock_input.jsp" class="style12">Blood_Bank_Stock</a></td>
</tr>
<tr>
<td height="22">&nbsp;</td>
<td>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="[Link] width="10"
height="10">
<param name="movie" value="[Link]" />
<param name="quality" value="high" />
<param name="SCALE" value="noborder" />
<embed src="[Link]" width="10" height="10" quality="high"
pluginspage="[Link]
type="application/x-shockwave-flash" scale="noborder" ></embed>
</object>

131
<a href="campas_list_input.jsp" class="style12">Camps Details</a></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><a href="[Link]" class="style12">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="[Link] width="10"
height="10">
<param name="movie" value="[Link]" />
<param name="quality" value="high" />
<param name="SCALE" value="noborder" />
<embed src="[Link]" width="10" height="10" quality="high"
pluginspage="[Link]
type="application/x-shockwave-flash" scale="noborder" ></embed>
</object>
</a><a href="[Link]" class="style12">UserListReport</a></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>
<span class="style12">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="[Link] width="10"
height="10">
<param name="movie" value="[Link]" />
<param name="quality" value="high" />
<param name="SCALE" value="noborder" />
<embed src="[Link]" width="10" height="10" quality="high"
pluginspage="[Link]
type="application/x-shockwave-flash" scale="noborder" ></embed>
</object>
</span><a href="feedback_report.jsp" class="style12">Feedback Report</a></td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td colspan="6" align="left" valign="top"
class="style10">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n

132
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;</td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" class="style10"><p><img src="images/[Link]" width="912"
height="8" /></p>
<p>&nbsp;</p></td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>
</form>
<form id="form1" name="form1" method="post" action="">

<span class="style10"><span class="style3">

</body>
</html>

133
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style13 {font-size: 30px}
.style14 {color: #CCCCCC}
.style15 {
font-size: 16px;

134
font-weight: bold;
}
-->
</style></head>

<body>

<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donal</a></div></td>
<td width="186" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1"> Hospital </a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="88" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Doctor</a></div></td>
<td width="103" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood- Bank</a></div></td>
<td width="122" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="98" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="8"><form id="form1" name="form1" method="post" action="">
<table width="954" height="50">
<tr>

135
<td align="right"><div align="center" class="style13"><span class="style14">Welcome tO Admin Report
&nbsp;</span>&nbsp;&nbsp;&nbsp;<img src="images/[Link]" width="75" height="44"
/></div></td>
</tr>
</table>
</form> <p align="left" class="style10"><img src="images/[Link]" width="912" height="8" /></p></td>
</tr>

<tr>
<td colspan="8" class="style10">

<%
[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement statement=[Link]();
String query="select * from booldbanklndian";
ResultSet rs=[Link](query);%>

<table width="954">

<tr>

<td width="116" align="center" bgcolor="" style="font-size:20px"><span class="style15">Bank_id</span></td>

<td width="75" align="center" bgcolor="" style="font-size:20px"><span class="style15">State</span></td>
<td width="127" align="center" bgcolor="" style="font-size:20px"><span class="style15">Blood-Name</span></td>
<td width="120" align="center" bgcolor="" style="font-size:20px"><span class="style15">Location</span></td>
<td width="87" align="center" bgcolor="" style="font-size:20px"><span class="style15">Phone</span></td>
<td width="191" align="center" bgcolor="" style="font-size:20px"><span class="style15">Contact_person</span></td>
<td width="103" align="center" bgcolor="" style="font-size:20px"><span class="style15">Email</span></td>
<td width="99" align="center" bgcolor="" style="font-size:20px"><span class="style15">Details</span></td>

<tr><td colspan="8"><hr ></td></tr>

<%
while([Link]())
{
%>
<tr>
<td align="center"><%=[Link](1)%></td>
<td align="center"><%=[Link](2)%></td>

136
<td align="center"><%=[Link](3)%></td>
<td align="center"><%=[Link](4)%></td>
<td align="center"><%=[Link](5)%></td>
<td align="center"><%=[Link](6)%></td>
<td align="center"><%=[Link](7)%></td>
<td align="center"><%=[Link](8)%></td>

<%

}
%>

</td>
</tr>

<tr>

<td colspan="8" align="center" valign="bottom" class="style10"><p><img src="images/[Link]" width="912"

height="8" /></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p></td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>
</form>
<form id="form1" name="form1" method="post" action="">

<span class="style10"><span class="style3">

<span class="style5"></span>
</body>
</html>

137
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style13 {font-size: 30px}
.style14 {color: #CCCCCC}
.style19 {font-size: 11px}

138
-->
</style></head>

<body>
<form id="form1" name="form1" method="post" action="">
<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donal</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1"> Hospital </a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Doctor</a></div></td>
<td width="100" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood- Bank</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="80" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="8">
</table>
<table width="954" >
<tr>

139
<td align="right"><div align="center" class="style13"><span class="style14">Welcome tO Admin Report
&nbsp;</span>&nbsp;&nbsp;&nbsp;<img src="images/[Link]" width="75" height="44"
/></div></td>
</tr>

<tr>
</p>

<td colspan="8" class="style10">

<p><img src="images/[Link]" width="912" height="8" /></p>

<table width="967">
<tr>
<tr><td colspan="17"><hr ></td></tr>
<td width="48"><span class="style19">Receiver Id</span></td>
<td width="31">Name</td>
<td width="102">Address</td>
<td width="26">City</td>
<td width="35">State</td>
<td width="40">Email</td>
<td width="59">Phone</td>
<td width="36">Blood<br />
Group</td>
<td width="59">Physical<br />
Status</td>
<td width="47">Diabetic</td>
<td width="52">Blood<br />
Pressure</td>
<td width="48">Weight</td>
<td width="51">Remark</td>
<td width="63">Numberof<br />
BottelReq</td>
<td width="70">Doctor_name</td>
<td width="48">Hospital</td>
<td width="46">Desease</td>
</tr>
<tr><td colspan="17"><hr ></td></tr>
<tr>
<%
[Link]("[Link]");

140
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement statement=[Link]();
String query="select * from receiver";
ResultSet rs=[Link](query);

while([Link]())
{
%>
<td style="font-size:12px"><%=[Link](1)%></td>
<td style="font-size:12px"><%=[Link](2)%></td>
<td style="font-size:12px"><%=[Link](3)%></td>
<td style="font-size:12px"><%=[Link](4)%></td>
<td style="font-size:12px"><%=[Link](5)%></td>
<td style="font-size:12px"><%=[Link](6)%></td>
<td style="font-size:12px"><%=[Link](7)%></td>
<td style="font-size:12px"><%=[Link](8)%></td>
<td style="font-size:12px"><%=[Link](9)%></td>
<td style="font-size:12px"><%=[Link](10)%></td>
<td style="font-size:12px"><%=[Link](11)%></td>
<td style="font-size:12px"><%=[Link](12)%></td>
<td style="font-size:12px"><%=[Link](13)%></td>
<td style="font-size:12px"><%=[Link](14)%></td>
<td style="font-size:12px"><%=[Link](15)%></td>
<td style="font-size:12px"><%=[Link](16)%></td>
<td style="font-size:12px"><%=[Link](17)%></td>
</tr>
<%
}
%>
</table>
<img src="images/[Link]" width="912" height="8" />
<p>&nbsp;</p>
<table width="961" border="1">
<tr>
<td align="center" bgcolor="#990000"><span class="style1">Copyright&copy;&nbsp;2010 All right
reserved Blood-Bank</span></td>
</tr>
</table>

</form>

141
<span class="style10"><span class="style3">
<span class="style5"></span>
</body>
</html>

142
Donalr_new.jsp

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style13 {font-size: 30px}
.style14 {color: #CCCCCC}
.style20 {font-size: 14px}
-->
</style></head>

143
<body>
<form id="form1" name="form1" method="post" action="">
<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donal</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1"> Hospital </a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Doctor</a></div></td>
<td width="100" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood- Bank</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="80" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="8">
</table>
<table width="954" >
<tr>
<td align="right"><div align="center" class="style13"><span class="style14">Welcome tO Admin Report
&nbsp;</span>&nbsp;&nbsp;&nbsp;<img src="images/[Link]" width="75" height="44"
/></div></td>
</tr>

144
<tr>
</p>

<td colspan="8" class="style10">

<p><img src="images/[Link]" width="912" height="8" /></p>

<table width="967">
<tr>
<tr><td colspan="17"><hr ></td></tr>
<td width="48"><span class="style20">Donar_id</span></td>
<td width="31"><span class="style20">Name</span></td>
<td width="102"><span class="style20">Address</span></td>
<td width="26"><span class="style20">City</span></td>
<td width="35"><span class="style20">State</span></td>
<td width="40"><span class="style20">Email</span></td>
<td width="59"><span class="style20">Phone</span></td>
<td width="36"><span class="style20">Blood<br />
Group</span></td>
<td width="59"><span class="style20">Physical<br />
Status</span></td>
<td width="47"><span class="style20">Diabetic</span></td>
<td width="52"><span class="style20">Blood<br />
Pressure</span></td>
<td width="48"><span class="style20">Weight</span></td>
<td width="51"><span class="style20">Remark</span></td>
</tr>
<tr><td colspan="17"><hr ></td></tr>
<tr>
<%
[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement statement=[Link]();
String query="select * from donar";
ResultSet rs=[Link](query);

while([Link]())
{
%>
<td style="font-size:14px"><%=[Link](1)%></td>

145
<td style="font-size:14px"><%=[Link](2)%></td>
<td style="font-size:14px"><%=[Link](3)%></td>
<td style="font-size:14px"><%=[Link](4)%></td>
<td style="font-size:14px"><%=[Link](5)%></td>
<td style="font-size:14px"><%=[Link](6)%></td>
<td style="font-size:14px"><%=[Link](7)%></td>
<td style="font-size:14px"><%=[Link](8)%></td>
<td style="font-size:14px"><%=[Link](9)%></td>
<td style="font-size:14px"><%=[Link](10)%></td>
<td style="font-size:14px"><%=[Link](11)%></td>
<td style="font-size:14px"><%=[Link](12)%></td>
<td style="font-size:14px"><%=[Link](13)%></td>

</tr>
<%
}
%>
</table>
<img src="images/[Link]" width="912" height="8" />
<p>&nbsp;</p>
<table width="961" border="1">
<tr>
<td align="center" bgcolor="#990000"><span class="style1">Copyright&copy;&nbsp;2010 All right
reserved Blood-Bank</span></td>
</tr>
</table>

</form>

<span class="style10"><span class="style3">

<span class="style5"></span>
</body>
</html>

146
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style13 {font-size: 30px}
.style14 {color: #CCCCCC}
.style20 {font-size: 14px}

147
-->
</style></head>

<body>
<form id="form1" name="form1" method="post" action="">
<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donal</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1"> Hospital </a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Doctor</a></div></td>
<td width="100" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood- Bank</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="80" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="8">
</table>
<table width="954" >
<tr>

148
<td align="right"><div align="center" class="style13"><span class="style14">Welcome tO Admin Report
&nbsp;</span>&nbsp;&nbsp;&nbsp;<img src="images/[Link]" width="75" height="44"
/></div></td>
</tr>

<tr>
</p>

<td colspan="8" class="style10">

<p><img src="images/[Link]" width="912" height="8" /></p>

<table width="967">
<tr>
<tr><td colspan="17"><hr ></td></tr>
<td width="48"><span class="style20">DoctorId</span></td>
<td width="31"><span class="style20">Name</span></td>
<td width="102"><span class="style20">Address</span></td>
<td width="26"><span class="style20">Email</span></td>
<td width="35"><span class="style20">Phone</span></td>
<td width="40"><span class="style20">Gender</span></td>
<td width="59"><span class="style20">Qualification</span></td>
<td width="36"><span class="style20">Experience</span></td>
<td width="59"><span class="style20">Age</span></td>
<td width="47"><span class="style20">Practising_At</span></td>
<td width="52"><span class="style20">OtherDetails</span></td>

</tr>
<tr><td colspan="17"><hr ></td></tr>
<tr>
<%
[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement statement=[Link]();
String query="select * from doctor";
ResultSet rs=[Link](query);

while([Link]())
{
%>
<td style="font-size:14px"><%=[Link](1)%></td>

149
<td style="font-size:14px"><%=[Link](2)%></td>
<td style="font-size:14px"><%=[Link](3)%></td>
<td style="font-size:14px"><%=[Link](4)%></td>
<td style="font-size:14px"><%=[Link](5)%></td>
<td style="font-size:14px"><%=[Link](6)%></td>
<td style="font-size:14px"><%=[Link](7)%></td>
<td style="font-size:14px"><%=[Link](8)%></td>
<td style="font-size:14px"><%=[Link](9)%></td>
<td style="font-size:14px"><%=[Link](10)%></td>
<td style="font-size:14px"><%=[Link](11)%></td>

</tr>
<%
}
%>
</table>
<img src="images/[Link]" width="912" height="8" />
<p>&nbsp;</p>
<table width="961" border="1">
<tr>
<td align="center" bgcolor="#990000"><span class="style1">Copyright&copy;&nbsp;2010 All right
reserved Blood-Bank</span></td>
</tr>
</table>

</form>

<span class="style10"><span class="style3">

<span class="style5"></span>
</body>
</html>

150
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style13 {font-size: 30px}
.style14 {color: #CCCCCC}
.style20 {font-size: 14px}

151
-->
</style></head>

<body>
<form id="form1" name="form1" method="post" action="">
<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donal</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]" class="style1">
Hospital </a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Doctor</a></div></td>
<td width="100" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood- Bank</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="80" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="8">
</table>
<table width="954" >
<tr>

152
<td align="right"><div align="center" class="style13"><span class="style14">Welcome tO Admin Report
&nbsp;</span>&nbsp;&nbsp;&nbsp;<img src="images/[Link]" width="75" height="44"
/></div></td>
</tr>

<tr>
</p>

<td colspan="8" class="style10">

<p><img src="images/[Link]" width="912" height="8" /></p>

<table width="957">
<tr>
<td width="124" align="center"><span class="style20">Hospital_Name</span></td>
<td width="103" align="center"><span class="style20">Address</span></td>
<td width="70" align="center"><span class="style20">City</span></td>
<td width="72" align="center"><span class="style20">State</span></td>
<td width="131" align="center"><span class="style20">BloodGroup_req</span></td>
<td width="92" align="center"><span class="style20">Qty_req</span></td>
<td width="100" align="center"><span class="style20">Qty_avaliv</span></td>
<td width="84" align="center"><span class="style20">Details</span></td>
<td width="123" align="center"><span class="style20">Conatct_person</span></td>
</tr>
<%
[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement statement=[Link]();
String query="select * from hospital";
ResultSet rs=[Link](query);

while([Link]())
{
%>
<tr>
<td align="center"><span style="font-size:14px"><%=[Link](1)%></span></td>
<td align="center"><span style="font-size:14px"><%=[Link](2)%></span></td>
<td align="center"><span style="font-size:14px"><%=[Link](3)%></span></td>
<td align="center"><span style="font-size:14px"><%=[Link](4)%></span></td>
<td align="center"><span style="font-size:14px"><%=[Link](5)%></span></td>

153
<td align="center"><span style="font-size:14px"><%=[Link](6)%></span></td>
<td align="center"><span style="font-size:14px"><%=[Link](7)%></span></td>
<td align="center"><span style="font-size:14px"><%=[Link](8)%></span></td>
<td align="center"><span style="font-size:14px"><%=[Link](9)%></span></td>
</tr>
<%
}
%>
</table>
<p><img src="images/[Link]" width="912" height="8" /></p>
<table width="961" border="1">
<tr>
<td align="center" bgcolor="#990000"><span class="style1">Copyright&copy;&nbsp;2010 All right
reserved Blood-Bank</span></td>
</tr>
</table>

</form>

<span class="style10"><span class="style3">

<span class="style5"></span>
</body>
</html>

154
Blood_bank_stock_input.jsp

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<script>
function validateForm()
{
if([Link]=="")
{
alert("Name should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

155
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
}
</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
#Layer1 {
position:absolute;
left:367px;
top:186px;
width:364px;
height:228px;
z-index:1;
}
.style13 {font-size: 24px}
.style14 {font-size: 12px}
.style16 {font-size: 10px}
.style17 {color: #FFFFFF; font-size: 12px; }
-->
</style></head>

<body>
<form id="form2" name="form2" method="post" onsubmit="return validateForm()" action="bloodbankstock_code.jsp">

156
<td height="18" colspan="6" align="right" valign="middle"><table width="956">
<tr>
<td width="570"><img src="images/[Link]" width="444" height="37" /></td>
<td width="375"><img src="images/[Link]" width="213" height="69" align="right" /></td>
</tr>
<tr>
<td colspan="2"><img src="images/[Link]" width="949" height="57" /></td>
</tr>
<tr>
<td colspan="2" align="right" bgcolor="#990000"><a href="#" class="style1"></a></td>
</tr>
</table>

<label for="pass"><br />

<br />
<br />
<img src="images/[Link]" width="900" height="8" />
<br />

<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

<br />
<br />
<br />
<br />

157
</label>
<div id="Layer1">
<table width="292">
<tr>
<td width="421" height="36" valign="top"><p class="style13"><strong>Blood Bank Stock</strong></p></td>
</tr>
<tr>
<td height="46" valign="top"><p class="style14"><img src="images/[Link]" width="286" height="69"
align="right" /></p></td>
</tr>
<tr>
<td>Bank_group:</td>
</tr>
<tr>
<td><input name="t1" type="text" size="35" /></td>
</tr>
<tr>
<td>Qty_available:</td>
</tr>
<tr>
<td><input name="t2" type="password" size="35" /></td>
</tr>
<tr>
<td>Qty_required:</td>
</tr>
<tr>
<td><input name="t3" type="text" size="35" /></td>
</tr>

<tr>
<td><input type="submit" name="s1" value="Summit" /></td>
</tr>
</table>

</div>
<p><img src="images/[Link]" width="1000" height="8" /></p>
<p>&nbsp;
</p>
<table width="958" border="1">
<tr>

158
<td align="center" bgcolor="#990000"><span class="style17">Copyright&copy;&nbsp;2010 All right reserved
Blood-Bank</span></td>
</tr>
</table>

</form>
</body>
</html>

159
Bloodbankstock_code.jsp

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<%
String st1=[Link]("s1");

String a=[Link]("t1");
String b=[Link]("t2");
String c=[Link]("t3");

[Link]("[Link]");
Connection con=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement st=[Link]();

if([Link]("Summit"))
{
[Link]("Insert into blood_bank_stock values('"+a+"','"+b+"','"+c+"')");

[Link]("[Link]");
}
%>

</body>
</html>

160
Campus_list_input.jsp

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<script>
function validateForm()
{
if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;

161
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
}
</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
#Layer1 {
position:absolute;
left:367px;
top:186px;

162
width:313px;
height:228px;
z-index:1;
}
.style13 {font-size: 24px}
.style14 {font-size: 12px}
.style16 {font-size: 10px}
.style17 {color: #FFFFFF; font-size: 12px; }
-->
</style></head>

<body>
<form id="form2" name="form2" method="post" onsubmit="return validateForm()"
action="campas_list_input_code.jsp">

<td height="18" colspan="6" align="right" valign="middle"><table width="956">

<tr>
<td width="570"><img src="images/[Link]" width="444" height="37" /></td>
<td width="375"><img src="images/[Link]" width="213" height="69" align="right" /></td>
</tr>
<tr>
<td colspan="2"><img src="images/[Link]" width="949" height="57" /></td>
</tr>
<tr>
<td colspan="2" align="right" bgcolor="#990000"><a href="#" class="style1"></a></td>
</tr>
</table>

<label for="pass"><br />

<br />
<br />
<img src="images/[Link]" width="900" height="8" />
<br />

<br />
<br />
<br />

163
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
</label>
<div id="Layer1">
<table width="318">

<tr>
<td width="421" height="36" valign="top"><p class="style13"><strong>Camps Details </strong><strong>Rotary
society</strong></p></td>
</tr>
<tr>
<td height="46" valign="top"><p class="style14"><img src="images/[Link]" width="286" height="69"
align="right" /></p></td>
</tr>
<tr>
<td>Camp_no:</td>
</tr>
<tr>
<td><input name="t1" type="text" size="35" /></td>
</tr>
<tr>

164
<td>Timings:</td>
</tr>
<tr>
<td><input name="t2" type="text" size="35" /></td>
</tr>
<tr>
<td>Date:</td>
</tr>
<tr>
<td><input name="t3" type="text" size="35" /></td>
</tr>

<tr>
<td>Place:</td>
</tr>
<tr>
<td><input name="t4" type="text" size="35" /></td>
</tr>
<tr>
<td>Phone</td>
</tr>
<tr>
<td><input name="t5" type="text" size="35" /></td>
</tr>
<tr>
<td>Contact_person</td>
</tr>
<tr>
<td><input name="t6" type="text" size="35" /></td>
</tr>
<tr>
<td><input type="submit" name="s1" value="Summit" /></td>
</tr>
</table>

</div>

<p><img src="images/[Link]" width="1000" height="8" /></p>

<p>&nbsp;
</p>

165
<table width="958" border="1">
<tr>
<td align="center" bgcolor="#990000"><span class="style17">Copyright&copy;&nbsp;2010 All right reserved
Blood-Bank</span></td>
</tr>
</table>

</form>

</body>
</html>

166
campas_list_input_code.jsp

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<%
String st1=[Link]("s1");

String a=[Link]("t1");
String b=[Link]("t2");
String c=[Link]("t3");
String d=[Link]("t4");
String e=[Link]("t5");
String f=[Link]("t6");

[Link]("[Link]");
Connection con=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement st=[Link]();

if([Link]("Summit"))
{
[Link]("Insert into camps_table values('"+a+"','"+b+"','"+c+"','"+d+"','"+e+"','"+f+"')");

[Link]("[Link]");
}
%>

</body>
</html>

167
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style13 {font-size: 30px}
.style14 {color: #CCCCCC}
.style20 {font-size: 14px}
-->

168
</style></head>

<body>
<form id="form1" name="form1" method="post" action="">
<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donal</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1"> Hospital </a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Doctor</a></div></td>
<td width="100" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood- Bank</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="80" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="8">
</table>
<table width="954" >
<tr>
<td align="right"><div align="center" class="style13"><span class="style14">Welcome tO Admin Report
&nbsp;</span>&nbsp;&nbsp;&nbsp;<img src="images/[Link]" width="75" height="44"
/></div></td>

169
</tr>

<tr>
</p>

<td colspan="8" class="style10">

<p><img src="images/[Link]" width="912" height="8" /></p>

<table width="957">
<tr><td colspan="5"><hr ></td></tr>
<tr>
<td width="126" ><span class="style20">Username</span></td>
<td width="105" ><span class="style20">Password</span></td>
<td width="71" ><span class="style20">Email</span></td>
<td width="73" ><span class="style20">Security_Question</span></td>
<td width="133"><span class="style20">Answer</span></td>

</tr>
<tr><td colspan="5"><hr ></td></tr>
<%
[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement statement=[Link]();
String query="select * from login";
ResultSet rs=[Link](query);

while([Link]())
{
%>
<tr>
<td ><span style="font-size:14px"><%=[Link](1)%></span></td>
<td ><span style="font-size:14px"><%=[Link](2)%></span></td>
<td ><span style="font-size:14px"><%=[Link](3)%></span></td>
<td ><span style="font-size:14px"><%=[Link](4)%></span></td>
<td ><span style="font-size:14px"><%=[Link](5)%></span></td>
</tr>
<%
}
%>

170
</table>
<p><img src="images/[Link]" width="912" height="8" /></p>
<table width="961" border="1">
<tr>
<td align="center" bgcolor="#990000"><span class="style1">Copyright&copy;&nbsp;2010 All right
reserved Blood-Bank</span></td>
</tr>
</table>

</form>

<span class="style10"><span class="style3">

<span class="style5"></span>
</body>
</html>
[Link]

171
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style13 {font-size: 30px}
.style14 {color: #CCCCCC}
.style20 {font-size: 14px}
-->
</style></head>

<body>
<form id="form1" name="form1" method="post" action="">
<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donal</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1"> Hospital </a></div></td>

172
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Doctor</a></div></td>
<td width="100" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood- Bank</a></div></td>
<td width="80" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="80" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="8">
</table>
<table width="954" >
<tr>
<td align="right"><div align="center" class="style13"><span class="style14">Welcome tO Admin Report
&nbsp;</span>&nbsp;&nbsp;&nbsp;<img src="images/[Link]" width="75" height="44"
/></div></td>
</tr>

<tr>
</p>

<td colspan="8" class="style10">

<p><img src="images/[Link]" width="912" height="8" /></p>

<table width="957">
<tr><td colspan="5"><hr ></td></tr>
<tr>
<td width="215" ><span class="style20">Name</span></td>
<td width="175" ><span class="style20">Phone</span></td>
<td width="183" ><span class="style20">Email</span></td>
<td width="238" ><span class="style20">Suggestions_Feedback</span></td>

</tr>
<tr><td colspan="5"><hr ></td></tr>
<%

173
[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement statement=[Link]();
String query="select * from feedback";
ResultSet rs=[Link](query);

while([Link]())
{
%>
<tr>
<td ><span style="font-size:14px"><%=[Link](1)%></span></td>
<td ><span style="font-size:14px"><%=[Link](2)%></span></td>
<td ><span style="font-size:14px"><%=[Link](3)%></span></td>
<td ><span style="font-size:14px"><%=[Link](4)%></span></td>

</tr>
<%
}
%>
</table>
<p><img src="images/[Link]" width="912" height="8" /></p>
<table width="961" border="1">
<tr>
<td align="center" bgcolor="#990000"><span class="style1">Copyright&copy;&nbsp;2010 All right
reserved Blood-Bank</span></td>
</tr>
</table>

</form>

<span class="style10"><span class="style3">

<span class="style5"></span>
</body>
</html>

174
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<script>
function validateForm()
{
if([Link]=="")
{
alert("Name should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}

175
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
else if([Link]=="")
{
alert("Field should not be left blank");
[Link]();
return false;
}
}
</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
#Layer1 {
position:absolute;
left:367px;
top:186px;
width:429px;
height:228px;
z-index:1;
}
.style13 {font-size: 24px}
.style14 {font-size: 12px}
.style16 {font-size: 10px}
.style17 {color: #FFFFFF; font-size: 12px; }
-->
</style></head>

<body>
<form id="form2" name="form2" method="post" onsubmit="return validateForm()" action="feedback_code.jsp">

176
<td height="18" colspan="6" align="right" valign="middle"><table width="956">
<tr>
<td width="570"><img src="images/[Link]" width="444" height="37" /></td>
<td width="375"><img src="images/[Link]" width="213" height="69" align="right" /></td>
</tr>
<tr>
<td colspan="2"><img src="images/[Link]" width="949" height="57" /></td>
</tr>
<tr>
<td colspan="2" align="right" bgcolor="#990000"><a href="#" class="style1"></a></td>
</tr>
</table>

<label for="pass"><br />

<br />
</label>
<div id="Layer1">
<table width="429">
<tr>
<td width="421" height="36" valign="top" bgcolor="#CCCCCC"><p class="style13">Feedback</p></td>
</tr>
<tr>
<td height="46" valign="top"><p class="style14">Do you have any questions, comments or suggestions? We
would be glad to hear it from you. Your feedback is important and valuable to us. </p></td>
</tr>
<tr>
<td>Name:</td>
</tr>
<tr>
<td><input name="t1" type="text" size="35" /></td>
</tr>
<tr>
<td>Phone:</td>
</tr>
<tr>
<td><input name="t2" type="text" size="35" /></td>

177
</tr>
<tr>
<td>E-mail ID:</td>
</tr>
<tr>
<td><input name="t3" type="text" size="35" /></td>
</tr>
<tr>
<td>Suggestions / Feedback:</td>
</tr>
<tr>
<td><textarea name="t4" cols="65"></textarea>
<span class="style16">Note: Please provide a valid and active e-mail ID so that we could get in touch with
you.</span></td>
</tr>
<tr>
<td><input type="submit" name="s1" value="Summit" /></td>
</tr>
</table>
</div>
<label for="pass"><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

178
<br />
</label>
<table width="958" border="1">
<tr>
<td align="center" bgcolor="#990000"><span class="style17">Copyright&copy;&nbsp;2010 All right reserved
Blood-Bank</span></td>
</tr>
</table>

</form>

</body>
</html>
feedback_code.jsp

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<%
String st1=[Link]("s1");

String a=[Link]("t1");
String b=[Link]("t2");
String c=[Link]("t3");
String d=[Link]("t4");

[Link]("[Link]");
Connection con=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement st=[Link]();

if([Link]("Summit"))

179
{
[Link]("Insert into feedback(Name,Phone,Email,Suggestions_Feedback)
values('"+a+"','"+b+"','"+c+"','"+d+"')");

[Link]("[Link]");
}
%>

</body>
</html>

180
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style13 {font-size: 30px}
.style14 {color: #CCCCCC}

181
.style15 {
font-size: 16px;
font-weight: bold;
}
-->
</style></head>

<body>

<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="186" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1"> Hospital </a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="88" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Doctor</a></div></td>
<td width="103" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood- Bank</a></div></td>
<td width="122" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="98" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="8"><form id="form1" name="form1" method="post" action="">
<table width="954" height="50">

182
<tr>
<td align="right"><div align="center" class="style13"><span class="style14">Welcome tO Admin Report
&nbsp;</span>&nbsp;&nbsp;&nbsp;<img src="images/[Link]" width="75" height="44"
/></div></td>
</tr>
</table>
</form> <p align="left" class="style10"><img src="images/[Link]" width="912" height="8" /></p></td>
</tr>

<tr>
<td colspan="8" class="style10">

<%
[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement statement=[Link]();
String query="select * from blood_bank_stock";
ResultSet rs=[Link](query);%>

<table width="954">

<tr>

<td width="116" align="center" bgcolor="" style="font-size:20px"><span class="style15">Bank_group</span></td>

<td width="75" align="center" style="font-size:20px"><span class="style15">Qty_available</span></td>
<td width="130" align="center" bgcolor="" style="font-size:20px"><span class="style15">Qty_required</span></td>

<tr><td colspan="3"><hr ></td></tr>

<%
while([Link]())
{
%>
<tr>
<td align="center"><%=[Link](1)%></td>
<td align="center"><%=[Link](2)%></td>
<td align="center"><%=[Link](3)%></td>

183
<%

}
%>

</td>
</tr>

<tr>

<td colspan="8" align="center" valign="bottom" class="style10"><p><img src="images/[Link]" width="912"

height="8" /></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p></td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>
</form>
<form id="form1" name="form1" method="post" action="">

<span class="style10"><span class="style3">

<span class="style5"></span>
</body>
</html>

184
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
.style2 {color: #00FFFF}
.style10 {font-size: 12px}
.style13 {font-size: 30px}
.style14 {color: #CCCCCC}

185
.style15 {
font-size: 16px;
font-weight: bold;
}
-->
</style></head>

<body>

<table width="966">

<tr>

<td colspan="8"><img src="images/[Link]" width="497" height="45" hspace="110" /><img

src="images/[Link]" width="209" height="62" /></td>
</tr>
<tr>
<td colspan="8"><img src="images/[Link]" width="949" height="57" align="bottom" /></td>
</tr>
<tr>
<td width="80" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Home</a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1">Donar</a></div></td>
<td width="186" bgcolor="#990000"><div align="center" class="style2"><a href="[Link]"
class="style1"> Hospital </a></div></td>
<td width="147" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Receiver</a></div></td>
<td width="88" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Doctor</a></div></td>
<td width="103" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Blood- Bank</a></div></td>
<td width="122" bgcolor="#990000"><div align="center" class="style1"><a href="[Link]"
class="style1">Contact Us</a></div></td>
<td width="98" bgcolor="#990000"><div align="center"><a href="[Link]" class="style1">About
Us</a></div></td>
</tr>
<tr>
<td colspan="8"><form id="form1" name="form1" method="post" action="">
<table width="954" height="50">

186
<tr>
<td align="right"><div align="center" class="style13"><span class="style14">Welcome tO Admin Report
&nbsp;</span>&nbsp;&nbsp;&nbsp;<img src="images/[Link]" width="75" height="44"
/></div></td>
</tr>
</table>
</form> <p align="left" class="style10"><img src="images/[Link]" width="912" height="8" /></p></td>
</tr>

<tr>
<td colspan="8" class="style10">

<%
[Link]("[Link]");
Connection connection=[Link]("jdbc:mysql://localhost:3306/bloodbank","root","1234");
Statement statement=[Link]();
String query="select * from camps_table";
ResultSet rs=[Link](query);%>

<table width="954">

<tr>

<td width="116" align="center" bgcolor="" style="font-size:20px"><span class="style15">Camp_no</span></td>

<td width="75" align="center" style="font-size:20px"><span class="style15">Timings</span></td>
<td width="130" align="center" bgcolor="" style="font-size:20px"><span class="style15">Date</span></td>
<td width="117" align="center" bgcolor="" style="font-size:20px"><span class="style15">Place</span></td>
<td width="87" align="center" bgcolor="" style="font-size:20px"><span class="style15">Phone</span></td>
<td width="191" align="center" bgcolor="" style="font-size:20px"><span class="style15">Contact_person</span></td>

<tr><td colspan="6"><hr ></td></tr>

<%
while([Link]())
{
%>
<tr>
<td align="center"><%=[Link](1)%></td>
<td align="center"><%=[Link](2)%></td>
<td align="center"><%=[Link](3)%></td>

187
<td align="center"><%=[Link](4)%></td>
<td align="center"><%=[Link](5)%></td>
<td align="center"><%=[Link](6)%></td>

<%

}
%>

</td>
</tr>

<tr>

<td colspan="8" align="center" valign="bottom" class="style10"><p><img src="images/[Link]" width="912"

height="8" /></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p></td>
</tr>
<tr>
<td colspan="8" align="center" valign="bottom" bgcolor="#990000" class="style10"><span
class="style1">Copyright&copy;&nbsp;2010 All right reserved Blood-Bank</span></td>
</tr>
</table>
</form>
<form id="form1" name="form1" method="post" action="">
<span class="style10"><span class="style3">
<span class="style5"></span>
</body>
</html>

188
[Link]

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="[Link].*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"[Link]
<html xmlns="[Link]

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-weight: bold;
}
.style1 {color: #FFFFFF}
#Layer1 {
position:absolute;
left:428px;
top:211px;
width:492px;

189
height:228px;
z-index:1;
}
.style13 {font-size: 24px}
body {
background-image: url();
}
-->
</style></head>

<body>
<%if ([Link]()==true)
[Link]([Link]("[Link]"));%>

<%[Link]();%>
<h4 align="center"> You were being Logged out </h4> <br>
<a href = "[Link]"> Login </a><br>
<b>Session ID: </b><%= [Link]()
%>

<form>
<td height="18" colspan="6" align="right" valign="middle"><table width="956">
<tr>
<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img
src="images/[Link]" width="802" height="43" /></td>
</tr>
<tr>
<td><img src="images/[Link]" width="949" height="57" /></td>
</tr>
<tr>
<td align="right" bgcolor="#990000"><span class="style1">Email</span>
<input type="text" name="t1" />
<span class="style1">Password</span>
<input type="password" name="t2" />
<a href="#" class="style1"></a></td>
</tr>
</table>

<label for="pass"></label></td>

190
</form>
<p><img src="images/[Link]" width="946" height="340" /></p>
<table width="958" border="1">
<tr>
<td align="center" bgcolor="#990000"><span class="style1">Copyright&copy;&nbsp;2010 All right reserved
BloodBank</span></td>
</tr>
</table>

</body>
</html>

191
5.2 CODE EFFICIENCY
Reviewing of Code efficiency for a module is carried out after the module is successfully compiled
and all the syntax errors eliminated. Code efficiency review is extremely cost-effective strategies for
reduction in coding errors in order to produce high quality code. Normally, two types of efficiency
are carried out on the code of a module - code optimization and code inspection. The procedure and
final objective of these two efficiency techniques are very different as discussed below.

OPTIMIZATION OF CODE

Code optimization is an informal code analysis technique. In this technique, after a module has been
coded, it is successfully compiled and all syntax errors are eliminated. Some members of the
development team are given the code a few days before the optimization meeting to read and
understand the code. Each member selects some test cases and simulates execution of the code by
hand (i.e. trace execution through each statement and function execution). The main objectives of the
optimization are to discover the algorithmic and logical errors in the code. The members note down
their findings to discuss these in a optimization meeting where the coder of the module is also
present.

Even though a code optimization is an informal analysis technique, several guidelines have evolved
over the years for making this naïve technique more effective and useful. Of course, these guidelines
are based on personal experience, common sense, and several subjective factors. Therefore are based
on personal experience, common sense, and several subjective factors. Therefore, guidelines should
be considered as examples rather than as rules to be applied dogmatically. Some of these guidelines
are the following:

The team performing the code optimization should not be either too big or too small. Ideally, it
should consist of three to seven members.

192
6.1 TESTING PHASE

One of the purposes of the testing is to validate and verify the system. Verification means checking
the system to ensure that it is doing what the function is supposed to do and Validation means
checking to ensure that system is doing what the user wants it to do.

No program or system design is perfect; communication between the user and the designer is not
always complete or clear, and time is usually short. The result is errors and more errors.
Theoretically, a newly designed system should have all the pieces in working order, but in reality,
each piece works independently. Now is the time to put all the pieces into one system and test it to
determine whether it meets the user's requirements. This is the best chance to detect and correct
errors before the system is implemented. The purpose of system testing is to consider all the likely
variations to which it will be subjected and then push the system to its limits. If we implement the
system without proper testing then it might cause the problems.

1. Communication between the user and the designer.

2. The programmer's ability to generate a code that reflects
exactly the system specification.
3. The time frame for the design.

Theoretically, a new designed system should have all the pieces in working order, but in reality, each
piece works independently. Now is the time to put all the pieces into one system and test it to
determine whether it meets the requirements of the user. The process of system testing and the steps
taken to validate and prepare a system for final implementation are:

193
6.2 LEVELS OF TESTING

The different types of testing are as follows:

UNIT TESTING

VALIDATION

INTEGRATION

SYSTEM

1. UNIT TESTING:
This is the smallest testable unit of a computer system and is normally tested
using the white box testing. The author of the programs usually carries out unit tests.

2. INTEGRATION TESTING:
In integration testing, the different units of the system are integrated together to
form the complete system and this type of testing checks the system as whole to ensure that it is
doing what is supposed to do. The testing of an integrated system can be carried out top-down,
bottom-up, or big-bang. In this type of testing, some parts will be tested with white box testing and
some with black box testing techniques. This type of testing plays very important role in increasing
the systems productivity. We have checked our system by using the integration testing techniques.

194
3. SYSTEM TESTING:
A part from testing the system to validate the functionality of software against
the requirements, it is also necessary to test the non-functional aspect of the system. Some examples
of non-functional tools include tests to check performance, data security, usability/user friendliness,
volume, load/stress that we have used in our project to test the various modules.

System testing consists of the following steps:

1. Program(s) testing.
2. String testing.
3. System testing.
4. System documentation.
5. User acceptance testing.

4. FIELD TESTING:
This is a special type of testing that may be very important in some projects. Here
the system is tested in the actual operational surroundings. The interfaces with other systems and the
real world are checked. This type of testing is very rarely used. So far our project is concerned; we
haven't tested our project using the field testing.

5. ACCEPTANCE TESTING:
After the developer has completed all rounds of testing and he is satisfied
with the system, then the user takes over and re-tests the system from his point of view to judge
whether it is acceptable according to some previously identified criteria. This is almost always a
tricky situation in the project because of the inherent conflict between the developer and the user. In
this project, it is the job of the bookstores to check the system that whether the made system fulfills
the goals or not.

195
WHY SYSTEM TESTING?

Testing is vital to the success of the system. System testing makes a logical assumption that if
all the parts of the system are correct, the goal will be successfully achieved. Inadequate testing
results in two types of problems:

1. The time lag between the cause and the appearance of the problem.
2. The effect of system errors on the files and records within the system.

ACTIVITY NETWORK FOR SYSTEM TESTING

The test plan entails the following activities:

1. Prepare test plan.
2. Specify conditions for user acceptance testing.
3. Prepare test data for program testing.
4. Prepare test data for transaction path testing.
5. Plan user training.
6. Compile/assemble programs.
7. Prepare job performance aids.
8. Prepare operational documents.

PREPARE TEST: A workable test plan must be prepared in accordance with established design
specifications. It includes the following items:
 Outputs expected from the system.
 Criteria for evaluating outputs.
 A volume of test data.
 Procedure for using test data.
 Personnel and training requirements.

SPECIFY CONDITIONS FOR USER ACCEPTANCE TESTING

Planning for user acceptance testing calls for the analyst and the user to agree on conditions for the
test.

196
PREPARE TEST DATA FOR PROGRAM TESTING
As each program is coded, test data are prepared and documented to ensure that all aspects of the
program are properly tested.

PREPARE TEST DATA FOR TRANSACTION PATH TESTING

This activity develops the data required for testing every condition and transactions to be introduced
into the system. The path of each transaction from origin to destination is carefully tested reliable
results.

PLAN USER TRAINING

User training is designed to prepare the user for testing and converting the system. User involvement
and training take place parallel with programming for three reasons:

• The system group has time available to spend on training while the programs are being
written.
• Initiating a user-training program gives the systems group a clearer image of the user's
interest in the new system.
• A trained user participates more effectively in system testing.

The training plan is followed by preparation of the user training manual and other text materials.
COMPILE / ASSEMBLE PROGRAMS
All programs have to be compiled / assembled for testing.

PREPARE JOB PERFORMANCE AIDS

In this activity the materials to be used by personnel to run the system are specified and scheduled. This
includes a display of materials.

PREPARE OPERATIONAL DOCUMENTS

During the test plan stage, all operational documents are finalized including copies of the operational
formats required by the candidate system.

197
SYSTEMS TESTING

The computer department to ensure that the system functions as specified does this testing. This testing is
important to ensure that a working system is handed over to the user for acceptance testing.

ACCEPTANCE TESTING

The user to ensure that the system functions, as the user actually wanted performs this testing. With
prototyping techniques, this stage becomes very much a formality to check the accuracy and completeness
of processing. The screen layouts and output should already have been tested during the prototyping
phase.

An error in the program code can remain undetected indefinitely. To prevent this from happening
the code was tested at various levels. To successfully test a system, each condition, and
combinations of conditions had to be tested. Each program was tested and linked to other programs.
This unit of program is tested and linked to other units and so on until the complete system has been
tested.

The purpose of testing is to ensure that each program is fully tested. To do so a test plan had to be
created. The test plan consists of a number of test runs such as the valid paths through the code, and
the exception and error handling paths. For each test run there is a list of conditions tested, the test
data used and the result expected. The test plan was then reviewed to check that each path through
the code is tested correctly. It is the responsibility of the programmer to collect the data that will
produce the required test condition.

198
Fig. 9 TEST CASES
TEST DATA
Specifications
for
Sumsungmrc.
com user
form1
Test Date 10-jun-12 Programmer name: Self

Sumsung
Mobile Service
Tested By: Self Project Name Centre
Management
System

User ID Customer ID the fields are

[Link]
enter only
numeric
( Length upto 8
digit )

User Name the fields are

[Link]
enter only letters,
numeric, special
characters and no
space are
allowed( Length
upto 32
characters)

Password the fields are

required
minimum 6
character.

Email @ site extension the fields are

[Link]
enter only
letters,numeric
values,special
characters. no
spaces are
allowed ( Length
upto 40
characters)

Security Question select Select Option

Answer the fields are

[Link]
enter only letters,
spaces, No
numeric & special
characters are

199
allowed( Length
upto 32
characters)

Positive Test cases for User Detiails form

T.C T.C RESUL
PRE-CONDITION T.C DATA EXPECTED ACTUAL
ID DESCRIPTION T
User should be on Will accept only
Check the
[Link] numeric upto 8 digit .
1 functionality of Ok Pass
User Details? And is on Customer ID are
User ID
Customer ID 1234 required

the fields are

[Link] enter
User should be on
Check the only letters, numeric,
[Link]
1 functionality of special characters Ok Pass
User Details? And is on User
User Name field and no space are
Name Field
allowed( Length upto
32 characters)
pawan_123

the fields are

[Link] enter
User should be on
Check the only letters, numeric,
[Link]
2 functionality of special characters Ok Pass
User Details? And is on User
User Name field and no space are
Name Field
allowed( Length upto
32 characters)
pawangupta

User should be on
Check the the fields are
[Link]
1 functionality of required minimum 6 Ok Pass
User Details? And is on
Password field character.
Password Field pkg2007
User should be on
Check the the fields are
[Link]
2 functionality of required minimum 6 Ok Pass
User Details? And is on
Password field character.
Password Field 1235678

the fields are

[Link] enter
only letters,numeric
User should be on Check the
values,special
1 [Link] SITE functionality of Ok Pass
characters. no
And is on Email Id Field Email Id field
spaces are allowed (
pawan_voda@indiatim Length upto 40
[Link] characters)
the fields are
[Link] enter
only letters,numeric
User should be on Check the
values,special
2 [Link] SITE functionality of Ok Pass
characters. no
And is on Email Id Field Email Id field
spaces are allowed (
Length upto 40
pkg2007@[Link] characters)

200
the fields are
[Link] enter
User should be on
Check the only letters, spaces,
[Link]
1 functionality of No numeric & Ok Pass
User Details? And is on
Anwer field special characters
Answer Field
are allowed( Length
upto 32 characters)
maya

the fields are

[Link] enter
User should be on
Check the only letters, spaces,
[Link]
2 functionality of No numeric & Ok Pass
User Details? And is on
Anwer field special characters
Answer
are allowed( Length
upto 32 characters)
pannalal
Negative Test cases for User Details form

T.C T.C RESUL

PRE-CONDITION T.C DATA EXPECTED ACTUAL
ID DESCRIPTION T
User should be on Will accept only
Check the
[Link] numeric upto 8 digit .
1 functionality of Invalid Fail
User Details? And is on Customer ID are
User ID
Customer ID rksss1 required

the fields are

[Link] enter
User should be on
Check the only letters, numeric,
[Link]
1 functionality of special characters Invalid Fail
User Details? And is on User
User Name field and no space are
Name Field
allowed( Length upto
32 characters)
space

User should be on
Check the the fields are
[Link]
1 functionality of required minimum 6 Ok Fail
User Details? And is on
Password field character.
Password Field p123

the fields are

[Link] enter
only letters,numeric
User should be on Check the
values,special
1 [Link] SITE functionality of Ok Fail
characters. no
And is on Email Id Field Email Id field
spaces are allowed (
Length upto 40
space characters)

the fields are

[Link] enter
User should be on
Check the only letters, spaces,
[Link]
1 functionality of No numeric & Ok Fail
User Details? And is on
Anwer field special characters
Answer Field
are allowed( Length
upto 32 characters)
112333

201
Test cases of customer details
TEST DATA
Specifications
for
[Link]
m add customer
details
Programmer
Test Date 27-4-2010 Pawan Kumar
name:
Administrative
Support System
Tested By: Pawan Kumar Project Name For Sumsung
Mobile Repairing
Centre

Customer ID Customer ID the fields are

[Link] enter
only numeric
( Length upto 8
digit )
First Name the fields are
[Link] enter
only letters, No
spaces, No hyphens,
no apostrophes,No
numeric & special
characters are
allowed( Length upto
16 characters)

Last Name the fields are

[Link] enter
only letters, No
spaces, No hyphens,
no apostrophes,No
numeric & special
characters are
allowed( Length upto
16 characters)

Address the fields are

[Link] enter
only letters,
spaces, hyphens,
and apostrophes.
No numeric &
special characters
are allowed( Length
upto 132
characters)

City the fields are

[Link] enter
only letters,
spaces,
allowed( Length
upto 20 characters)

202
Phone No. only 8 or 10 digit
You may use
numbers

Email @ site the fields are

extension [Link] enter
only letters,numeric
values,special
characters. no
spaces are allowed
( Length upto 40
characters)

Product the fields are

[Link] enter
only letters, spaces,
numeric & special
characters are
allowed( Length upto
32 characters)

Positive Test cases for Add Customer Detiails

form
T.C ACT
PRE-CONDITION T.C DESCRIPTION T.C DATA EXPECTED RESULT
ID UAL
User should be on
Will accept only numeric
[Link] Check the functionality
1 1234 upto 8 digit . Customer Ok Pass
/cusomerDetails? And is on of Customer ID
ID are required
Customer ID

Will accept only letters,

No spaces, No hyphens,
User should be on
no apostrophes,No
[Link] Check the functionality
1 Pawan numeric & special Ok Pass
/cusomerDetails? And is on of First_Name field
characters are allowed.
First_Name Field
Length upto 16
characters.
Will accept only letters,
No spaces, No hyphens,
User should be on
no apostrophes,No
[Link] Check the functionality
2 Raman numeric & special Ok Pass
/cusomerDetails? And is on of First_Name field
characters are allowed.
First_Name Field
Length upto 16
characters.
Will accept only letters,
No spaces, No hyphens,
User should be on
no apostrophes,No
[Link] Check the functionality
3 Rameshwar numeric & special Ok Pass
/cusomerDetails? And is on of First_Name field
characters are allowed.
First_Name Field
Length upto 16
characters.

1 User should be on Check the functionality Gupta Will accept only letters, Ok Pass
[Link] of Last_Name field No spaces, No hyphens,
/cusomerDetails? And is on no apostrophes,No
Last_Name Field numeric & special
characters are allowed.

203
Length upto 16
characters.
Will accept only letters,
No spaces, No hyphens,
User should be on
no apostrophes,No
[Link] Check the functionality
2 numeric & special Ok Pass
/cusomerDetails? And is on of Last_Name field
characters are allowed.
Last_Name Field
Length upto 16
Verma characters.
Will accept only letters,
No spaces, No hyphens,
User should be on
no apostrophes,No
[Link] Check the functionality
3 numeric & special Ok Pass
/cusomerDetails? And is on of Last_Name field
characters are allowed.
Last_Name Field
Length upto 16
Gangadhartilak characters.

Will accept only letters,

User should be on
spaces, hyphens, and
[Link] Check the functionality
1 [Link] Ok Pass
/cusomerDetails? And is on of Address field
upto 132 characters.
Address
uttam nagar name are required.
Will accept only letters,
User should be on
spaces, hyphens, and
[Link] Check the functionality
2 [Link] Ok Pass
/cusomerDetails? And is of Address field
Rz-7A/K SHANKAR upto 132 characters.
onAddress
PARK name are required.
Will accept only letters,
User should be on
spaces, hyphens, and
[Link] Check the functionality
3
/cusomerDetails? And is of Address field RZ-7A/K [Link] Ok Pass
upto 132 characters.
onAddress
name are required.

User should be on
Will accept only letters,
[Link] Check the functionality
1 [Link] upto 20 Ok Pass
/cusomerDetails? And is on of City field
characters.
City Patna
User should be on
Will accept only letters,
[Link] Check the functionality
2 [Link] upto 20 Ok Pass
/cusomerDetails? And is on of City field
characters.
city New Delhi

User should be on
[Link] Check the functionality Will accept only numeric
1 Ok Pass
/cusomerDetails? And is on of Phone number upto 8 or 10 digit .
Phone number 9899988235
User should be on
[Link] Check the functionality Will accept only numeric
2 Ok Pass
/cusomerDetails? And is on of Phone number upto 8 or 10 digit .
Phone number 112555111

the fields are

[Link] enter only
User should be on letters,numeric
Check the functionality
1 [Link] SITE values,special Ok Pass
of Email Id field
And is on Email Id Field characters. no spaces
pawan_voda@i are allowed ( Length
[Link] upto 40 characters)
the fields are
[Link] enter only
User should be on letters,numeric
Check the functionality
2 [Link] SITE values,special Ok Pass
of Email Id field
And is on Email Id Field characters. no spaces
pkg2007@gmail are allowed ( Length
.com upto 40 characters)

the fields are

User should be on [Link] enter only
[Link] Check the functionality letters, numeric, special
1 Ok Pass
/cusomerDetails? And is on of Product characters,no space are
Product Field allowed( Length upto 32
SUMSUNG-5800 characters)

204
the fields are
User should be on [Link] enter only
[Link] Check the functionality letters, numeric, special
2 Ok Pass
/cusomerDetails? And is on of Product characters,no space are
Product allowed( Length upto 32
SUMSUNG-1110i characters)
Negative Test cases for Add Customer Details form

T.C ACT
PRE-CONDITION T.C DESCRIPTION T.C DATA EXPECTED RESULT
ID UAL
User should be on
Will accept only numeric
[Link] Check the functionality Inval
1 upto 8 digit . Customer Fail
/cusomerDetails? And is on of Customer ID id
ID are required
Customer ID

Will accept only letters,

No spaces, No hyphens,
User should be on
no apostrophes,No
[Link] Check the functionality Inval
1 numeric & special Fail
/cusomerDetails? And is on of First_Name field id
characters are allowed.
First_Name Field
Length upto 16
p gupta characters.
Will accept only letters,
No spaces, No hyphens,
User should be on
no apostrophes,No
[Link] Check the functionality Inval
2 numeric & special Fail
/cusomerDetails? And is on of First_Name field id
characters are allowed.
First_Name Field
Length upto 16
p1111 characters.
Will accept only letters,
No spaces, No hyphens,
User should be on
no apostrophes,No
[Link] Check the functionality Inval
3 numeric & special Fail
/cusomerDetails? And is on of First_Name field id
characters are allowed.
First_Name Field
Length upto 16
111gg characters.

Will accept only letters,

No spaces, No hyphens,
User should be on
no apostrophes,No
[Link] Check the functionality
1 numeric & special Ok Fail
/cusomerDetails? And is on of Last_Name field
characters are allowed.
Last_Name Field
Length upto 16
gru characters.
Will accept only letters,
No spaces, No hyphens,
User should be on
no apostrophes,No
[Link] Check the functionality
2 numeric & special Ok Fail
/cusomerDetails? And is on of Last_Name field
characters are allowed.
Last_Name Field
Length upto 16
V111 characters.
Will accept only letters,
No spaces, No hyphens,
User should be on
no apostrophes,No
[Link] Check the functionality
3 numeric & special Ok Fail
/cusomerDetails? And is on of Last_Name field
characters are allowed.
Last_Name Field
Length upto 16
g_p_pta characters.

Will accept only letters,

User should be on
spaces, hyphens, and
[Link] Check the functionality Inval
1 [Link] Fail
/cusomerDetails? And is on of Address field id
upto 132 characters.
+Address
Space name are required.

User should be on Will accept only letters,

[Link] Check the functionality [Link] upto 80 Inval
1 Fail
/cusomerDetails? And is on of City field characters. name are id
City 1112 required.
User should be on Will accept only letters,
Check the functionality Inval
2 [Link] [Link] upto 80 Fail
of City field id
/cusomerDetails? And is on P_atna characters. name are

205
city required.

User should be on Will accept only numeric

[Link] Check the functionality upto 8 or digit . Inval
1 Fail
/cusomerDetails? And is on of Phone number Customer ID are id
Phone number 45 456 required
User should be on
Will accept only numeric
[Link] Check the functionality Inval
2 upto or digit . Customer Fail
/cusomerDetails? And is on of Phone number id
ID are required
Phone number mobileno

the fields are

[Link] enter only
User should be on letters,numeric
Check the functionality
1 [Link] SITE values,special Ok Fail
of Email Id field
And is on Email Id Field characters. no spaces
are allowed ( Length
space upto 40 characters)

the fields are

User should be on [Link] enter only
[Link] Check the functionality letters, numeric, special
1 Ok Fail
/cusomerDetails? And is on of Product characters,no space are
Product Field allowed( Length upto 32
N 111 characters)

206
6.3 VERIFICATION AND VALIDATION (V&V)

The objectives of verification, validity activities are to assess and improve the quality of the work
products generated during development and modification of the software. Quality depends upon the
various attributes like correctness, completeness, consistency, reliability, usefulness, usability,
efficiency and conformance to standards.

The terms verification and validation are used synonymously. These are defined as under: -

Verification: “Are we building the product right?”

Validation: “Are we building the right product?”

Verification activities include proving, testing, and reviews. Validation is the process of evaluating
software at the end of the software development to ensure compliance with the software
requirements. Testing is a common method of validation. Clearly, for high reliability we need to
perform both activities. Together, they are often called V&V activities.

The major V&V activities for software development are inspection, reviews, and testing (both static
and dynamic). The V&V plan identifies the different V&V tasks for the different phases and
specifies how these tasks contribute to the project V&V goals. The methods to be used for
performing these V&V activities, the responsibilities and milestones for each of these activities,
inputs and outputs for each V&V task, and criteria for evaluating the outputs are also specified.

The two major V&V approaches are testing and inspections. Testing is an activity that can be
generally performed only on code. It is an important activity and is discussed in detail in a later
chapter. Inspection is a more general activity that can be applied to any work product, including
code. Many of the V&V tasks are such that for them, an inspection type of activity is the only
possible way to perform the tasks (e.g. trace ability and document evaluation). Due to this,
inspections play a significant role in verification.

207
7.1 SYSTEM IMPLEMENTATION MAINTENANCE AND REVIEW

As we know, creating software is one thing and the implementation of the created software is
another. The process of implementing software is much difficult as compared to the task of creating
the project. First we have to implement the software on a small scale for removing the bugs and other
errors in the project and after removing them we can implement the software on a large scale.

Before we think in terms of implementing the Software on a large basis, we must consider the
Hardware requirements.

Whenever we develop software or project a certain hardware and software is being used by the
programmer for developing the project. The hardware and software to be used by the programmer for
developing the project should be such that it would result in the development of a project, which
would satisfy all the basic needs for which the project has been created by the programmer. The
Hardware should be such that cost constraints of the Client should also be taken into account without
affecting the performance.

7.2 HARDWARE EVALUATION FACTORS

When we evaluate computer hardware, we should first investigate specific physical and performance
characteristics for each hardware component to be acquired. These specific questions must be answered
concerning many important factors. These hardware evaluation factors questions are summarized in the
below figure.

Notice that there is much more to evaluating hardware than determining the fastest and cheapest
computing device. For e.g. the question of possible obsolescence must be addressed by making a
technology evaluation. The factor of ergonomics is also very important. Ergonomics is the science and
technology that tries to ensure that computers and other technologies are "user-friendly", that is safe,
comfortable and easy to use. Connectivity is another important evaluation factor, since so many
computer systems are now interconnected within wide area or local area telecommunications networks.

208
1) Performance
2) Cost
3) Reliability
4) Availability
5) Compatibility
6) Modularity
7) Technology
8) Ergonomics
9) Connectivity
10) Environmental requirements
11) Software
12) Support

7.3 SOFTWARE EVALUATION FACTORS

Software can be evaluated according to many factors similar to the hardware evaluation. Thus the
factors of performance, cost, reliability, compatibility, modularity, technology, ergonomics, and
support should be used to evaluate proposed software acquisitions. In addition, however, the
software evaluation factors are summarized in below figure. For e.g. some software packages
require too much memory capacity and are notoriously slow, hard to use, or poorly documented.
They are not a good selection for most end users, even if offered at attractive prices.

SOFTWARE EVALUATION FACTORS:

1. EFFICIENCY: is the software a well-written system of computer instructions that

does not use much memory capacity or CPU time?
2. FLEXIBILITY: can it handle its processing assignments easily without major
modifications?
3. SECURITY: does it provide control procedures for errors, malfunctions and improper
use?

209
4. LANGUAGE: do our computer programmers and users write it in a programming
language that is used?
5. DOCUMENTATION: is the s/w well documented? Does it include helpful user
instructions?
6. HARDWARE: does existing hardware have the features required to best use this
software?
7. Other characteristics of hardware such as its performance, what about the cost, how
much is reliable and etc.

7.4 CONVERSION AND TRAINING

An important aspect of is to make sure that the new design is implemented to establish standards.
The term implementation has different meanings, ranging form the conversion of a basic application
to a complete replacement of a computer system. Implementation is used here to mean the process of
converting a new or revise system into an operational one. Conversion is one aspect of
implementation. Conversion means changing form one system to another. The objective is to put the
tested system into operation while holding costs, risks, and personnel irritation to a minimum. It
involves creating computer-compatible files, training the operation staff, and installing terminal and
hardware. A critical aspect of conversion is not disrupting the functioning of the organization.

When a new system is used over and old, existing and running one, there are always compatibility
errors. These errors are caused because of the lack of equipment or personnel to work the new
system. Running any specified system at an organization does require some or other hardware or, in
this case, software requirement as well.

Conversion is one aspect of implementation review & software maintenance.

There are three types of implementation:

1. Implementation of a computer system to replace a manual system. The problems

encountered are converting files, training users, creating accurate files and verifying printouts
for integrity.

2. Implementation of a new computer system to replace an existing one. This is usually a

difficult conversion. If not properly planned there can be many problems. Some large
computer systems have taken as long as year to convert.

210
3. Implementation of a modified application to replace an existing one, using the same
computer. This type of conversion is relatively easy to handle, provided there are no major
changes in the files.

7.5 TRAINING NEEDS

Training needs refer to the gaining of knowledge required for running the system.

First of all the system is a computer based system therefore the person should have good knowledge
about computer and its working.
He should know how to use software's on the computer.

For a better usage and working of the software the organization should appoint a person who has
good knowledge of all the required softwares. The organization gets a person trained through
different institutes present in the market. The training should be as per the above requirements.

211
8. COST ESTIMATION OF THE PROJECT

Cost in a project is due to the requirements for software, hardware, and human resources. Hardware
resources are computer time, terminal time and memory required for the project. Software resources
include the tools and compilers needed during development. The bulk of cost of software
development is due to human resources needed. Cost estimates are determined in terms of person-
months (PM).

Total No. Of Persons Involved In This Project:

1. Administrator

2. Senior Programmer

3. Junior Programmers

Since this Project will complete in 4 months

COST ESTIMATE: (Salary of Project Manager + Salary of Senior Programmer + 2 * Salary of

Junior Programmer) * 2

212
9. GANTT & PERT CHART

GANT CHART
Gantt charts mainly used to allocate resources to activities. The resources allocated to activities
include staff, hardware, and software. Gantt charts (named after its developer Henry Gantt) are
useful for resource planning. A Gantt chart is special type of bar chart where each bar represents an
activity. The bars are drawn along a timeline. The length of each bar is proportional to the duration
of the time planned for the corresponding activity.

Gantt chart is a project scheduling technique. Progress can be represented easily in a Gantt chart, by
coloring each milestone when completed. The project will start in the month of January and end after
4 months at the end of April.

System Design

Detailed Design

Coding

Unit Testing

Test Plan

Testing

Sept. Oct. Nov. Dec.

Fig. 10.

213
Pert Chart

PERT (Project Evaluation and Review Technique) charts consist of a network of boxes and arrows.
The boxes represent activities and the arrows represent task dependencies.

1. PERT chart represents the statistical variations in the project estimates assuming a normal
distribution. Thus in a PERT chart instead of making a single estimate for each task,
pessimistic, likely, and optimistic estimates are also made. The boxes of PERT charts are
usually annotated with the pessimistic, likely, and optimistic estimates for every task. Since
all possible completion times between the minimum and maximum durations for every task
have to be considered, there are many critical paths, depending on the permutations of the
estimates for each task. This makes critical path analysis in PERT charts very complex. A
critical path in a PERT chart is shown by using thicker arrows. The PERT chart
representation of the Blood Bank Management System problem of Figure A. is shown
in Figure B.

Task ES EF LS LF ST
Specification Part 0 15 0 15 0
Design Database
Part 15 60 15 60 0
Design GUI Part 15 45 90 120 75
Code Database
Part 60 165 60 165 0
Code GUI Part 45 90 120 165 75
Integrate and Test 165 285 165 285 0
Write User Manual 15 75 225 285 210

Different Tasks for the Blood Management System shown in above table.

214
Design Code
Database part Database part
40, 45, 60 95,105,120

Specification Integrated
12, 15, 20 And test
100,120,140 Finish
0
Design GUI Code
part GUI part
24, 30, 38 4538,, 52

Write user
Manual
50, 60, 70

FIGURE 11 : PERT Chart representation of the Blood Bank Management System.

PERT charts are a more sophisticated form of activity chart. In activity diagrams only the estimated
task durations are represented. Since the actual durations might vary from the estimated durations,
the utility of the activity diagrams is limited.

215
10. SECURITY AND VALIDATION CHECKS

In this project we have used following validation checks.

 While entering the data into the form it will check for the name of the client is properly filled
& it should not be null.

 Whenever we enter the data for the new customer, company, or user will automatically check
the details from the database tables and also generate the connection number automatically.

 Similarly in the complaint table complaint number will generate automatically.

 Entered text / number should not exceed the limit (width).

 Almost for all fields we have used the validation for example if name of the fields requires
the text type of data then it will check for the string and if the data is numeric then it will
check if the number entered is proper numeric or not.

JSP Provides Security

 Evidence-based security (authentication)

 Based on user identity and code identity
 Configurable policies
 Imperative and declarative interfaces

216
11. SCOPE OF FUTURE APPLICATION

This website will be developed for the Online interested in information about Blood donation.
Utmost care and back-up procedures must be established to ensure 100% successful implementation
of the Online Blood Bank Management System. In case of system failure, the organization should be
in a position to process the transaction with another organization or if the worst comes to the worst, it
should be in a position to complete it manually.

The decision to automate generally depends on the needs to have accurate, consistent and timely data
in a variety of reporting formats. But the most important factor that should be considered is –

 Be sure to take future growth into consideration and evaluate whether the software
package could be modified if the organization expands in the future or you need to revise
the system.

 The next generation of Windows-based computerized systems would be changing the

way owners and management think about running their businesses. It would a powerful
tool that gives them more ways to get their financial Information so that they can better
manage and grow their business.

 The next generation of systems would take advantage of the latest technologies, including
Microsoft Windows XP and Orcale11i to offer access and integrate with all aspects of a
business. Keeping this in view we could develop systems that would work efficiently and
integrate seamlessly in virtually any industry setting, even up to mid-sized corporations
and divisions of larger organizations.

 Consider another setting, where the users are not comfortable on computers, for such
users we can develop systems where the users can have their own personalized menu
setup in the accounting software so that they no longer have to search around to find what
they need.

217
 Now consider the Internet. This wide open information exchange network comes with
many benefits for businesses, including breaking down physical barriers as to where
he/she can consult to the companies.

 Adding other capabilities can be added time to time. These are

 Application may be installed client server.
 Application can upgraded according to Employees Requirements with little changes
made
 Application may be transferred to latest RDMBS like Oracle with little changes in
current code. Use for Security purpose

NOTE: In a nutshell we have a lot of scope to further enhance the futures and functionalities
of the proposed Solution.

218
12. CONCLUSION

This project is designed to meet the requirements of the users for Blood Bank Management system It
has been developed in JSP,AJAX, keeping in mind the specifications of the system.

For designing the system we have used simple data flow diagrams.

Overall the project teaches us the essential skills like:

 Using system analysis and design techniques like data flow diagram in designing the system.
 Understanding the database handling and query processing using My SQL .

219
13. BIBLIOGRAPHY

1. Senn James A : Analysis and Design of Information Systems, McGraw Hill, International Ed,
1989.

2. O'Brien Jamea A : Management Information Systems, Galgotia Publications Pvt Ltd,

New Delhi, 1998.

3. Laudon & Laudon : Management Information Systems, Organisation and Technology,

PHI, New Delhi, 1998.

4. Wetherebe James : Systems Analysis and Design, Galgotia Publications Pvt Ltd, New
Delhi, 1990

220
14. GLOSSARY
TEXT BOX

A text Box control, sometimes called an edit field or edit control, displays information entered at
design time, entered by the user, or assigned to the control in code at run time.

BUTTON

Use a Command Button control to begin, interrupt, or end a process. When chosen, a Command
Button appears pushed in and so is sometimes called a push button.

LIST BOX

A List Box control displays a list of items from which the user can select one or more. If the number
of items exceeds the number that can be displayed, a scroll bar is automatically added to the List Box
control.

LABEL

A Label control is a graphical control you can use to display text that a user can’t change directly.

GROUPBOX

A GROUPBOX control provides an identifiable grouping for controls. You can also use a Frame to
subdivide a form functionally – for example, to separate groups of Option Button controls.

COMBO BOX

A Combo Box control combines the features of a text box and a list box. This control allows the user
to select an item either by typing text into the combo box, or by selecting it from the list.

TIMER

A Timer control can execute code at regular intervals by causing a Timer event to occur. The Timer
control, invisible to the user, is useful for background processing.

PICTURE BOX

The primary use for the Picture Box control is to display a picture to the user. The actual picture that
is displayed is determined by the picture property. The picture property contains the file name (and
optional path) for the picture file that you wish to display.

221
DATA GRID CONTROL

The DATA Grid control displays and operates on tabular data. It allows complete flexibility to sort,
merge, and format tables containing strings and pictures. When bound to a Data control, MSFlexGrid
displays read-only data.

DATE AND TIME PICKER CONTROL

A Date and Time Picker (DTP) Control provides a simple and intuitive interface through which to
exchange data and time information with a user. For example, with a DTP control you can ask the
user to enter a data and then retrieve his or her selection with ease.

OPTION BUTTON

An Option Button control displays an option that can be turned on or off.

IMAGE CONTROL

Use the Image control to display a graphic. An Image control can display a graphic from an icon,
bitmap or metafile, as well as enhanced metafile, JPEG, or GIF files.

CHECK BOX CONTROL

A Check Box indicates whether a particular condition is on or off. We use check

boxes in an application to give users true/false or yes/no options. Because check boxes
work independently of each other, a user can select any number of check boxes at the
same time.

222