life drops

7/30/2019 Life Drops

1/82

Project Report on Online Blood Bank 2012-2013

Dept. Of Computer Engg. 1 G.P.T.C, Muttom

introduction


2/82



1.1 ABOUT PROJECT

Blood cannot be created by any means, it can only be collected from the

Humans i.e. donors. Recruitment of safe donors and monitoring the standards is

a challenging task. No Blood Bank, Hospital or Government can sustain health

care without adequate blood. The major concern of Blood Bank is to maintain

the Quality of Blood as well as to identify the Professional Donors. NACO

(National AIDS Control Organization) and NABH (National Accreditation

Board for hospitals and Healthcare Providers) provides standards to ensure the

quality of Blood and identify the Professional Donors. But monitoring the

standards and identifing the Professional donors manually is a challenging job.

The software available in market is useful to cater the day to day functioning of

Blood Bank but cannot enforce the standards. Bio Metric devices are also

available to detect the professional donors but not available in an integrated

form with application. Quality Checks are available but these checks are not

conducted on routine basis and also not on all bags. To overcome these issues

we designed and implemented standard enforcing mechanism in each process of

Blood Bank Management System and also integrated Bio Metrics with Donor

Registration Process to identify the Professional Donors. This not only covers

the day to day working in blood Bank but also ensures implementation of the

Blood Bank Standards.

Objective:

This is a web application allows you to access the whole information

about Blood Bank Management Software, readily scalable and adaptable to

meet the complex need of Blood Banks Who are Key Facilitator for the

Healthcare Sector, it also supports all the functionalities of Blood Bank. The

main objective of the study was to create electronic blood donor management

information system in order to assist in the management of blood donor records,

planning and share information in a more confidential, convenient and secure


3/82



way using modern technology. The blood management information system

offers functionalities to quick access to donor records collected from various

parts of the country. It enables monitoring of the results and performance of the

blood donation activity such that relevant and measurable objectives of the

organization can be checked.

Proposed System:

This system is used for maintain whole information about campus.

In this project mainly 3 modules are there.

Admin Donors Acceptors

Admin

This module focuses on the both donors & acceptors. Each member in a donor& acceptor is given a user id and password, which identifies him uniquely. The

member is given a login form. he enters the login details user id and password.

.. The options given to

Change Password Maintain donor details Maintain acceptor details Update donor details Update acceptor details Maintain blood bank cell in hospitals

Registered Users


4/82



Donor: Each member in a Donor is given a user id and password, which

identifies him uniquely. The member is given a login form. he enters the login

details user id and password. .. The options given to a each member in a staff

are

Change password Find a Blood group. Why donate blood

Acceptor: Students. In this you can store the information about Acceptors.

Change password Find a blood group. Who needs blood

General public

General public can use the system to see the facilities available. General user can only donate or receive blood by register in the site.


5/82



system study

2.1 EXISTING SYSTEM


6/82



The shortage of blood in the country remains a big question in our Indian

society. Unlike western countries, voluntary blood donations in the country

reflect abysmal figures. Some modern blood banks in the country have arisen

and have come a long way in filling this gap and improving the awareness and

importance of voluntary blood donations.

Blood cannot be created by any means, it can only be collected from the

Humans i.e. donors. Recruitment of safe donors and monitoring the standards is

a challenging task. No Blood Bank, Hospital or Government can sustain health

care without adequate blood. The major concern of Blood Bank is to maintain

the Quality of Blood as well as to identify the Professional Donors. NACO

(National AIDS Control Organization) and NABH (National Accreditation

Board for hospitals and Healthcare Providers) provides standards to ensure the

quality of Blood and identify the Professional Donors. But monitoring the

standards and identifing the Professional donors manually is a challenging job.

The software available in market is useful to cater the day to day functioning of

Blood Bank but cannot enforce the standards. Bio Metric devices are also

available to detect the professional donors but not available in an integrated

form with application. Quality Checks are available but these checks are not

conducted on routine basis and also not on all bags. To overcome these issues

we designed and implemented standard enforcing mechanism in each process of

Blood Bank Management System and also integrated Bio Metrics with Donor

Registration Process to identify the Professional Donors. This not only covers

the day to day working in blood Bank but also ensures implementation of the

Blood Bank Standards.

2.2 NEED FOR COMPUTERISATION


7/82



The existing system is suffered from lot of difficulties. Some of

they are discussed below.

There is no centralized monitoring for all the services. The data storage in the current system is not secure. It is only possible to knew the updated informations and notifications for

the donor via visiting the authorities.

An emergency situation transfusion of blood of a patient took much moretime

Almost all the services in the existing system are time consuming. The existing system has no resources for getting the details of blood

donors.

2.3 PROPOSED SYSTEM

Blood Bank is one of the important departments. It plays an important role with

blood collection and issue of blood/components. Its activities include blood

donations, blood grouping, antibody screening, antibody identification, cross

matching, blood infectious tests, component preparation, issuing compatible

blood and Blood components etc.

Blood Bank Module provides up-to-date information about total daily blood /

component stock, total daily blood requisitions and information regarding

donor. Blood bank module constitutes of, registering the donor at the hospital

premises or at the camps arranged by the Blood Bank itself .The blood bank is


8/82



helped to register a new donor and stores the details of a registered donor. It

also allows the blood request of an acceptor. If the required blood is available in

the bloodstock, the details of the corresponding blood group donor is available

for the requester.

Advantages of proposed system

The proposed system has the following advantages

All the system procedures are managed by the administrator of thesystem. It enables an effective communication within the system.

Involvement of man power is less. That is, all processing are done by thecomputer and only the needed output is given to the user.

A lot of time can be saved with the proposed system. Because a computersystem can work more fast than a human.

The proposed system provides a user friendly environment. It provides sufficient security. That is, the data in the proposed system is

protected from unauthorized access.

As the amount of papers is reduced to minimum in the proposed system,it is easy to maintain data.

The proposed system produces more efficient and accurate data. Thecomputers give fast and accurate results as there is no case of

carelessness.

The proposed system provides all the basic information about the bloodbank

Donor registration and requisition for blood is possible using the system.


9/82



SYSTEM SPECIFICATIONS

REQUIREMENT ANALYSIS

Hardware Requirements:

Processors : Pentium IV

Hard Disk : 40 GB

RAM : 256 MB

Recommended Requirements for peek performance

Processors : Pentium IV

RAM : 256 MB

Display Type : 15SVGA color monitor

Keyboard : Enhanced 104 Standard

Mouse : 3 Button Scroll Mouse

Software Requirements:

Operating System: Windows 2000/2003/XP/7

Front End : JSP using NetBeans

Back End : MS SQL Server 2005

Browser : Google chrome, IE

Other Requirement: Microsoft Word 2007


10/82




11/82



feasibility

study


12/82



Analysis is the first step towards solving the problem statement.

In this mode we studied for the feasibility of the requested system with

our colleagues and friends who were familiar with the information system

techniques. For that technical feasibility, economical feasibility and operational

feasibility need to be considered.

Feasibility study may be documented as a separated report to higher

officials of the top-level management and can be included as an appendix to the

system specification. Feasibility and risk analysis is related in many ways. If

there is more project risk, then the feasibility of reducing producing the qualitysoftware is reduced.

The study is done in these phases:

Operational feasibility Technical feasibility Economical feasibility Behavioral feasibility Software feasibility Hardware feasibility


13/82



3.1 Operational Feasibility

The current system is not user friendly. Because it is very difficult to

manage many users manually. From the operational feasibility analysis we

understand that the users of the current system are looking for a new system to

be introduced which is more user friendly, fast and has less human efforts.

The user behavior analysis shows that the proposed system is operationally

feasible.

The purpose of the operational feasibility study is to determine whether

the new system will be used if it is developed and implemented. And whether

there will be resistance from users that will undermine the possible application

benefits.

3.2 Technical Feasibility

The proposed system is a multiuser system. It is best suited in a networkhierarchy with client server architecture. But for the time being it is

implemented in a single system. So the proposed system does not require any

new technology. It needs only a single intelligent terminal and the softwares

required are Java, NetBeans, JEE and SQL server 2005.

If we wish to implement the system in a network hierarchy it does not

needs more additional technical support than in the single user system. For the

implementation of the proposed system in a network hierarchy it additionally

needs some LAN cables, two or more dump terminals and some locking

mechanisms on the resources (data).

The requirement analysis shows that the proposed system is technically

feasible.


14/82



3.3 Economical Feasibility

The proposed system can be developed under optimal expenses with the

available hardwares and softwares. Also the proposed system can reduce the

expenses in the current system. By reducing the expenses in the current system

the institution get more benefits and savings.

The economical analysis shows that the proposed system is economically

feasible.

3.4 Behavioral Feasibility

People are inherently resistant to changes and computer is known for

facilitating the changes. An estimate should be made of how strongly the user

staff reacts towards the developments of the computerized system

In the existing system more manpower is required and time factor ismore. In the proposed system both manpower and time factors are reduced and

also unnecessary burden is reduced. Thus, the remaining people are made to

engage in some other important work. Therefore, system is behaviorally

feasible.

3.5 Software Feasibility

Even though software is developed in a very high software environment,

it will be supported by many other platforms and environments with minimum

changes.


15/82



3.6 Hardware Feasibility

The software can be developed with resource already existing. Here the

consideration is that existing hardware resources support the technologies that

are to be used by the new system. No hardware was newly bought for the

project and hence. Software is said to achieve hardware feasibility


16/82



system

development

4.1 Software Features

About JSP


17/82



Java Server Pages (JSP) is a technology for developing web pages that

support dynamic content which helps developers insert java code in HTML

pages by making use of special JSP tags, most of which start with .

A Java Server Pages component is a type of Java servlet that is designed

to fulfill the role of a user interface for a Java web application. Web developers

write JSPs as text files that combine HTML or XHTML code, XML elements,

and embedded JSP actions and commands.

Using JSP, you can collect input from users through web page forms,

present records from a database or another source, and create web pages

dynamically.

JSP tags can be used for a variety of purposes, such as retrieving

information from a database or registering user preferences, accessing

JavaBeans components, passing control between pages and sharing information

between requests, pages etc.

Why Use JSP?

Java Server Pages often serve the same purpose as programs implemented using

the Common Gateway Interface (CGI). But JSP offer several advantages in

comparison with the CGI.

Performance is significantly better because JSP allows embeddingDynamic Elements in HTML Pages itself instead of having a separate

CGI files.

JSP are always compiled before it's processed by the server unlikeCGI/Perl which requires the server to load an interpreter and the target

script each time the page is requested.


18/82



JavaServer Pages are built on top of the Java Servlets API, so likeServlets, JSP also has access to all the powerful Enterprise Java APIs,

including JDBC, JNDI, EJB, JAXP etc.

JSP pages can be used in combination with servlets that handle thebusiness logic, the model supported by Java servlet template engines.

Finally, JSP is an integral part of J2EE, a complete platform for enterprise

class applications. This means that JSP can play a part in the simplest

applications to the most complex and demanding.

Advantages of JSP:

Following is the list of other advantages of using JSP over other technologies:

vs. Active Server Pages (ASP): The advantages of JSP are twofold.First, the dynamic part is written in Java, not Visual Basic or other MS

specific language, so it is more powerful and easier to use. Second, it is

portable to other operating systems and non-Microsoft Web servers.

vs. Pure Servlets: It is more convenient to write (and to modify!) regularHTML than to have plenty of println statements that generate the HTML.

vs. Server-Side Includes (SSI): SSI is really only intended for simpleinclusions, not for "real" programs that use form data, make database

connections, and the like.

vs. JavaScript: JavaScript can generate HTML dynamically on the client

but can hardly interact with the web server to perform complex tasks like

database access and image processing etc.

vs. Static HTML: Regular HTML, of course, cannot contain dynamicinformation.

Java Server Pages (JSP) is a server-side programming technology that

enables the creation of dynamic web pages and applications. This is


19/82



accomplished by embedding Java code into HTML, XML, DHTML, or other

document types. When a client such as a web browser makes a request to the

Java application container, which is typically a web server, the static page is

converted behind the scenes, and displayed as dynamic content to the viewer. It

has been speculated that JSP was released to compete with PHP, a commonly

used open-source programming language.

While JSP is sometimes associated with Active Server Pages (ASP),

these are actually two different technologies. The biggest difference is that ASP

is developed by Microsoft, and largely considered as a framework. This is due

to its ability to support a wide variety of programming languages enabled by

Microsoft's Component Object Model (COM). Created by Sun

Microsystems, JSP is considered an object-orientated programming language.

Java Server Pages technology allows Java code and select predefined

actions to be inserted into static web page content. This code is compiled at

runtime for each request made to the page. The server, Java code and/or any

custom programming that may have been implemented, is controlled by a pre-

installed software application known as a virtual machine (VM). This VM

integrates with a host operating system. The most common VM used to run JSP

applications is Java Virtual Machine (JVM).

From a technical aspect, JSP can be viewed as a high-level abstraction of

Java servlets, because they essentially run on top of them. Java Server Pages are

usually compiled by a Java compiler. This compiler either generates servlets in

the form of Java code, or byte code that can be directly executed. Since they are

capable of being interpreted as soon as requests are made, the time it takes to

convert a static page to dynamic content is often greatly reduced.
http://www.wisegeek.com/what-is-html.htmhttp://www.wisegeek.com/what-is-a-compiler.htmhttp://www.wisegeek.com/what-is-a-compiler.htmhttp://www.wisegeek.com/what-is-html.htm


20/82



Many programmers prefer JSP because it simplifies development by

allowing the insertion of Java code directly into standard text files. It is also an

independent, cross-platform, portable language that falls in line with the Java

motto of 'write once, run anywhere.' Boasting the ability to separate content

from the foundation of the page, the language allows programmers to create

new code independent of the existing work. JSP is largely considered to be a

robust and efficient technology for both the server and client side aspects of

programming.

About JAVA

Java is a high level language. It is a very powerful language. Sun was

developed by Sun Microsystems. When it was being launched it had been tested

by many people who were experts in C++ and approved Java of being a

programming language. The logo is a coffee cup. A little note to the c++

programmers, many of the functions ofjava derive from c++, but its more

cohesive and more consistent than c++. It gives programmer full control, and

reflects exactly who you program. A few of the reasons why use java

Simple Secure Portable Object oriented Robust Multithreaded Architecture neutral Interpreted High performance Distributed Dynamic
http://www.sun.com/http://www.sun.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.sun.com/http://www.sun.com/


21/82



Very powerful

Where is java used? Lets see Web servers, Internet applications/

applets, Servlets, Relational databases, Mobile technology and personal digitalassistants, Mainframe computers, Operating system that is Solaris, Orbiting

telescopes, Credit card sized smart cards, Telephones, Architectural and 3d

design, Etc And these are becoming even more and more every day due to

extensive research being done in Sun Microsystems. One important thing that

people really dont know isjava is not at all becoming obsolete. This is rather a

strange statement I heard from people but I strongly disagree with it. One more

important note Java script is not a part ofjava, Java script has been designed

and developed by someone else. The method of coding in both is different. And

Java is a programming language where as Java script is not a programming

language. But both can be used for internet. How? Well java allows user to

make applications that can work on the internet one example of such

applications is applets. Java script is like an add on for web pages.

So in a nutshell, Java is a highly professional programming language.

Not made for a beginner. Gain some knowledge about programming and

computers before starting java. As there exist a lot more than it looks. The

home page for Java is www.java.com and www.sun.com. There are a lot of

resources there to go through for beginning your step into the vast field ofjava.

A high-level programming language developed by Sun Microsystems.

Java was originally called OAK, and was designed for handheld devices and set-

top boxes. Oak was unsuccessful so in 1995 Sun changed the name to Java and

modified the language to take advantage of the burgeoning World Wide Web.

Java is an object-oriented language similar to C++, but simplified to

eliminate language features that cause common programming errors. Java
http://www.java.com/http://www.sun.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.sun.com/http://www.java.com/http://www.java.com/http://www.sun.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.java.com/http://www.sun.com/http://www.java.com/


22/82



source code files (files with a .java extension) are compiled into a format called

bytecode (files with a .class extension), which can then be executed by a Java

interpreter. Compiled Java code can run on most computers because Java

interpreters and runtime environments, known asJava Virtual Machines (VMs),

exist for most operating systems, including UNIX, the Macintosh OS, and

Windows. Bytecode can also be converted directly into machine language

instructions by a just-in-time compiler (JIT).

Java is a general purpose programming language with a number of

features that make the language well suited for use on the World Wide Web.

Small Java applications are called Java applets and can be downloaded from a

Web server and run on your computer by a Java-compatible Web browser, such

as Netscape Navigator or Microsoft Internet Explorer.

About SQL SERVER 2005

In this mode, the state variables are stored in a database server, accessible

using SQL. Session variables can be persisted across JSP process shutdowns in

this mode as well. The main advantage of this mode is it would allow the

application to balance load on a server cluster while sharing sessions between

servers.

Categories of types:

Memory: data is stored on the stack Store the data

Each variable gets its own place in memory


23/82



The .NET Framework is such a comprehensive platform that it can be a little

difficult to describe. I have heard it described as a development platform, an

execution environment, and an operating system among other things. In fact, in

some ways each of these descriptions is accurate, if not sufficiently precise.

The software industry has become much more complex since the

introduction of the Internet. Users have become both more sophisticated and

less sophisticated at the same time. (I suspect not many individual users have

undergone both metamorphoses but as a body of users this has certainly

happened). Folks who had never touched a computer less than five years ago

are now comfortably including the Internet in their daily lives. Meanwhile, the

technophile or professional computer user has become much more advanced, as

have their expectations from software.

It is this collective expectation from software that drives our industry. Each

time a software developer creates a successful new idea, they raise user

expectations for the next new feature. In a way this has been true for years. But

now software developers face the added challenge of addressing the Internet and

Internet-users in many applications that in the past were largely unconnected.

Features of SQL server

1. CLR (Common Language Runtime)

2. T-SQL (Transaction SQL) enhancements

3. Service Broker

4. Data encryption

5.SMTP mail

6.HTTP endpoints

7.Multiple Active Result Sets (MARS)

8.Dedicated administrator connection

9.SQL Server Integration Services (SSIS)


24/82



10.Database mirroring

Microsoft SQL Server 2005 includes a component named SQL CLRvia

which it integrates with .NET Framework. Unlike most other applications thatuse .NET Framework, SQL Server itself hosts the .NET Framework runtime,

i.e., memory; threading and resource management requirements of .NET

Framework are satisfied by SQLOS itself, rather than the underlying Windows

operating system. SQLOS provides deadlock detection and resolution services

for .NET code as well.

With SQL CLR, stored procedures and triggers can be written in any

managed .NET language, including C# and VB.NET. Managed code can also be

used to define UDTs which can be persisted in the database. Managed code is

compiled to .NET assemblies and after being verified for type safety, registered

at the database. After that, they can be invoked like any other procedure.

However, only a subset of the Base Class Library is available, when running

code under SQL CLR. Most APIs relating to user interface functionality are not

available.

When writing code for SQL CLR, data stored in SQL Server databases

can be accessed using the ADO.NET APIs like any other managed application

that accesses SQL Server data. However, doing that creates a new database

session, different from the one in which the code is executing. To avoid this,

SQL Server provides some enhancements to the ADO.NET provider that allows

the connection to be redirected to the same session which already hosts the

running code. Such connections are called context connections and are set by

setting context connection parameter to true in the connection string.

SQL Server also provides several other enhancements to the ADO.NET

API, including classes to work with tabular data or a single row of data as well


25/82



as classes to work with internal metadata about the data stored in the database. It

also provides access to the XML features in SQL Server, including XQuery

support. These enhancements are also available in T-SQL Procedures in

consequence of the introduction of the new XML Datatype (query,value,nodes

functions).

About GLASSFISH SERVER

GlassFish is an open-source application server project started by Sun

Microsystems for the Java EE platform and now sponsored by Oracle

Corporation. The supported version is called Oracle GlassFish Server.

GlassFish is free software,dual-licensed under two free software licences: the

Common Development and Distribution License (CDDL) and the GNU General

Public License (GPL) with the classpath exception.

GlassFish is the reference implementation of Java EE and as such

supports Enterprise JavaBeans,JPA, JavaServer Faces,JMS, RMI,JavaServerPages, servlets, etc. This allows developers to create enterprise applications that

are portable and scalable, and that integrate with legacy technologies. Optional

components can also be installed for additional services.

GlassFish is based on source code released by Sun and Oracle

Corporation's TopLinkpersistence system. It uses a derivative of Apache

Tomcat as the servlet container for serving Web content, with an added

component called Grizzly which uses Java New I/O (NIO) for scalability and

speed.

Releases
http://en.wikipedia.org/wiki/Sun_Microsystemshttp://en.wikipedia.org/wiki/Sun_Microsystemshttp://en.wikipedia.org/wiki/Java_Platform,_Enterprise_Editionhttp://en.wikipedia.org/wiki/Oracle_Corporationhttp://en.wikipedia.org/wiki/Oracle_Corporationhttp://en.wikipedia.org/wiki/Oracle_GlassFish_Serverhttp://en.wikipedia.org/wiki/Free_softwarehttp://en.wikipedia.org/wiki/Dual-licensinghttp://en.wikipedia.org/wiki/Free_software_licencehttp://en.wikipedia.org/wiki/Common_Development_and_Distribution_Licensehttp://en.wikipedia.org/wiki/GNU_General_Public_Licensehttp://en.wikipedia.org/wiki/GNU_General_Public_Licensehttp://en.wikipedia.org/wiki/GPL_linking_exception#The_classpath_exceptionhttp://en.wikipedia.org/wiki/Reference_implementationhttp://en.wikipedia.org/wiki/Enterprise_JavaBeanshttp://en.wikipedia.org/wiki/Java_Persistence_APIhttp://en.wikipedia.org/wiki/JavaServer_Faceshttp://en.wikipedia.org/wiki/Java_Message_Servicehttp://en.wikipedia.org/wiki/Remote_Method_Invocationhttp://en.wikipedia.org/wiki/JavaServer_Pageshttp://en.wikipedia.org/wiki/JavaServer_Pageshttp://en.wikipedia.org/wiki/Source_codehttp://en.wikipedia.org/wiki/Oracle_Corporationhttp://en.wikipedia.org/wiki/Oracle_Corporationhttp://en.wikipedia.org/wiki/TopLinkhttp://en.wikipedia.org/wiki/Persistence_%28computer_science%29http://en.wikipedia.org/wiki/Apache_Tomcathttp://en.wikipedia.org/wiki/Apache_Tomcathttp://en.wikipedia.org/wiki/Servlethttp://en.wikipedia.org/w/index.php?title=Grizzly_%28software%29&action=edit&redlink=1http://en.wikipedia.org/wiki/New_I/Ohttp://en.wikipedia.org/wiki/New_I/Ohttp://en.wikipedia.org/w/index.php?title=Grizzly_%28software%29&action=edit&redlink=1http://en.wikipedia.org/wiki/Servlethttp://en.wikipedia.org/wiki/Apache_Tomcathttp://en.wikipedia.org/wiki/Apache_Tomcathttp://en.wikipedia.org/wiki/Persistence_%28computer_science%29http://en.wikipedia.org/wiki/TopLinkhttp://en.wikipedia.org/wiki/Oracle_Corporationhttp://en.wikipedia.org/wiki/Oracle_Corporationhttp://en.wikipedia.org/wiki/Source_codehttp://en.wikipedia.org/wiki/JavaServer_Pageshttp://en.wikipedia.org/wiki/JavaServer_Pageshttp://en.wikipedia.org/wiki/Remote_Method_Invocationhttp://en.wikipedia.org/wiki/Java_Message_Servicehttp://en.wikipedia.org/wiki/JavaServer_Faceshttp://en.wikipedia.org/wiki/Java_Persistence_APIhttp://en.wikipedia.org/wiki/Enterprise_JavaBeanshttp://en.wikipedia.org/wiki/Reference_implementationhttp://en.wikipedia.org/wiki/GPL_linking_exception#The_classpath_exceptionhttp://en.wikipedia.org/wiki/GNU_General_Public_Licensehttp://en.wikipedia.org/wiki/GNU_General_Public_Licensehttp://en.wikipedia.org/wiki/Common_Development_and_Distribution_Licensehttp://en.wikipedia.org/wiki/Free_software_licencehttp://en.wikipedia.org/wiki/Dual-licensinghttp://en.wikipedia.org/wiki/Free_softwarehttp://en.wikipedia.org/wiki/Oracle_GlassFish_Serverhttp://en.wikipedia.org/wiki/Oracle_Corporationhttp://en.wikipedia.org/wiki/Oracle_Corporationhttp://en.wikipedia.org/wiki/Java_Platform,_Enterprise_Editionhttp://en.wikipedia.org/wiki/Sun_Microsystemshttp://en.wikipedia.org/wiki/Sun_Microsystems


26/82



Sun Microsystems launched the GlassFish project on 6 June 2005. On 4 May

2006, Project GlassFish released the first version that supports the Java EE 5

specification.

On 8 May 2007 Project SailFin was announced at JavaOne as a sub-project

under Project GlassFish. Project SailFin aims to add Session Initiation Protocol

(SIP) servlet functionality to GlassFish.[1]

On 17 September 2007 the GlassFish community released version 2 (aka Sun

Java System Application Server 9.1) with full enterprise clustering capabilities,

Microsoft-interoperable Web Services.

On 21 January 2009 Sun Microsystems and the community released version

GlassFish 2.1 (aka Sun GlassFish Enterprise Server 2.1) which serves as the

basis for the Sailfin SIP AppServer project (aka Sun Communication

Application Server).

On 10 December 2009 GlassFish v3 was released. Being the Java EE reference

implementation, this was the first application server to completely implement

Java EE 6 JSR 316. JSR 316 was however approved with reservations. In this

version GlassFish adds new features to ease migration from Tomcat to

GlassFish.[2]The other main new features are around modularity (GlassFish v3

Prelude already shipped with an Apache Felix OSGi runtime), startup time (a

few seconds), deploy-on-change (provided by NetBeans and Eclipse plugins),

and session preservation across redeployments.[3]

On 25 March 2010, soon after the acquisition of Sun Microsystems, Oracle

issued a Roadmap for versions 3.0.1, 3.1, 3.2 and 4.0 with themes revolving

around clustering, virtualization and integration with Coherence and other

Oracle technologies. The open source community remains otherwise unaffected.
http://en.wikipedia.org/wiki/SailFinhttp://en.wikipedia.org/wiki/JavaOnehttp://en.wikipedia.org/wiki/Session_Initiation_Protocolhttp://en.wikipedia.org/wiki/Servlethttp://en.wikipedia.org/wiki/GlassFish#cite_note-1http://en.wikipedia.org/wiki/GlassFish#cite_note-1http://en.wikipedia.org/wiki/GlassFish#cite_note-1http://en.wikipedia.org/wiki/Microsofthttp://en.wikipedia.org/w/index.php?title=Java_EE_6&action=edit&redlink=1http://jcp.org/en/jsr/detail?id=316http://www.oreillynet.com/onjava/blog/2007/07/jsr_316_java_ee_6_spec_approve_1.htmlhttp://en.wikipedia.org/wiki/GlassFish#cite_note-2http://en.wikipedia.org/wiki/GlassFish#cite_note-2http://en.wikipedia.org/wiki/GlassFish#cite_note-2http://en.wikipedia.org/wiki/Apache_Felixhttp://en.wikipedia.org/wiki/OSGihttp://en.wikipedia.org/wiki/GlassFish#cite_note-3http://en.wikipedia.org/wiki/GlassFish#cite_note-3http://en.wikipedia.org/wiki/GlassFish#cite_note-3http://glassfish.org/roadmaphttp://en.wikipedia.org/w/index.php?title=Coherence_%28Oracle_software%29&action=edit&redlink=1http://en.wikipedia.org/w/index.php?title=Coherence_%28Oracle_software%29&action=edit&redlink=1http://glassfish.org/roadmaphttp://en.wikipedia.org/wiki/GlassFish#cite_note-3http://en.wikipedia.org/wiki/OSGihttp://en.wikipedia.org/wiki/Apache_Felixhttp://en.wikipedia.org/wiki/GlassFish#cite_note-2http://www.oreillynet.com/onjava/blog/2007/07/jsr_316_java_ee_6_spec_approve_1.htmlhttp://jcp.org/en/jsr/detail?id=316http://en.wikipedia.org/w/index.php?title=Java_EE_6&action=edit&redlink=1http://en.wikipedia.org/wiki/Microsofthttp://en.wikipedia.org/wiki/GlassFish#cite_note-1http://en.wikipedia.org/wiki/Servlethttp://en.wikipedia.org/wiki/Session_Initiation_Protocolhttp://en.wikipedia.org/wiki/JavaOnehttp://en.wikipedia.org/wiki/SailFin


27/82



On 28 February 2011, Oracle Corporation released GlassFish v3.1. This version

introduced support for ssh-based provisioning, centralized admin, clustering and

load-balancing. It maintains its support for both the Web Profile and full Java

EE 6 Platform specifications.

On 28 July 2011, Oracle Corporation released GlassFish v3.1.1. This is fix

release for GlassFish v3.1 with multiple component updates (Weld, Mojarra,

Jersey, EclipseLink, ...), JDK 7 support, AIX support and more.

On 29 February 2012, Oracle Corporation released GlassFish v3.1.2. This

release includes bug fixes and new features including administration console

enhancements, transaction recovery from a database and new thread pool

properties.

On 17 July 2012, Oracle Corporation released GlassFish v3.1.2.2. This is a

"micro" release to address some exceptional issues in the product.

About NETBEANS

Using an Integrated Development Environment (IDE) for developing

applications saves you time by managing windows, settings, and data. In

addition, an IDE can store repetitive tasks through macros and abbreviations.

Drag-and-drop features make creating graphical user interface (GUI)

components or accessing databases easy, and highlighted code and debuggingfeatures alert you to errors in your code.

The NetBeans IDE is open source and is written in the Java programming

language. It provides the services common to creating desktop applications --

such as window and menu management, settings storage -- and is also the first

IDE to fully support JDK 6.0 features. The NetBeans platform and IDE are free


28/82



for commercial and noncommercial use, and they are supported by Sun

Microsystems.

Features and Tools

The NetBeans IDE has many features and tools for each of the Java platforms.

Those in the following list are not limited to the Java SE platform but are useful

for building, debugging, and deploying applications and applets:

Source Code Editor

Syntax highlighting for Java, JavaScript, XML, HTML, CSS, JSP, IDL Customizable fonts, colors, and keyboard shortcuts Live parsing and error marking Pop-up Javadoc for quick access to documentation Advanced code completion Automatic indentation, which is customizable Word matching with the same initial prefixes Navigation of current class and commonly used features Macros and abbreviations Goto declaration and Goto class Matching brace highlighting JumpList allows you to return the cursor to previous modification

GUI Builder

Fully WYSIWYG designer with Test Form feature


29/82



Support for visual and nonvisual forms Extensible Component Palette with preinstalled Swing and AWT

components

Component Inspector showing a component's tree and properties Automatic one-way code generation, fully customizable Support for AWT/Swing layout managers, drag-and-drop layout

customization

Powerful visual editor Support for null layout In-place editing of text labels of components, such as labels, buttons, and

text fields

JavaBeans support, including installing, using, and customizingproperties, events, and customizers

Visual JavaBean customization -- ability to create forms from anyJavaBean classes

Connecting beans using Connection wizard Zoom view ability

Database Support

Database schema browsing to see the tables, views, and stored proceduresdefined in a database

Database schema editing using wizards Data view to see data stored in tables SQL and DDL command execution to help you write and execute more

complicated SQL or DDL commands

Migration of table definitions across databases from different vendors Works with databases, such as MySQL, PostgreSQL, Oracle, IBM DB2,

Microsoft SQL Server, PointBase, Sybase, Informix, Cloudscape, Derby,

and more


30/82



The NetBeans IDE also provides full-featured refactoring tools, which allow

you to rename and move classes, fields, and methods, as well as change method

parameters. In addition, you get a debugger and an Ant-based project system.

Immediate error messages. One of the most useful features for students is the

jagged red line under erroneous statements when there's a pause in the typing.

NetBeans continuously compiles the program as you're typing it to alert you

when there's an error. It's like the continuous spell checking of some word

processors.

Indentation and braces are serious problems for beginning students. Right

clicking the source code and choosingReformat Code reformats the entire file if

nothing is selected, otherwise only the selected text. Placing the cursor beside a

brace shows the matching brace.

Renaming is one of the most common operations, and NetBeans makes this

easy -- even when renaming a variable like "a" because it parses the text and

doesn't just use a simple textual match.

Support for Java EE Technology in NetBeans IDE

NetBeans IDE has been developed in close cooperation with the Java EE

and GlassFish teams to provide the tightest integration and easiest possible use

of the Java EE specification. NetBeans IDE is the best way to quickly learn and

become productive in Java EE programming.

Annotations Instead of Deployment Descriptors

The Java EE platform simplifies deployment by removing the need for

deployment descriptors, except for the deployment descriptor required by the

servlet specification, the web.xml file. Other deployment descriptors, such as

ejb-jar.xml and entries related to web services in web.xml, are obsolete. J2EE


31/82



1.4 deployment descriptors were often complex and it was easy to make

mistakes in filling them out

Simplified EJ B Software Development

The new EJB 3.0 API makes software development easier by reducing

and simplifying the amount of work required from the developer. In other

words, fewer classes and less code. This is possible because more of the work is

now performed by the container. Here are some of the features and benefits of

the EJB 3:

Use Dependency Injection to Access Resources

Dependency injection enables an object to use annotations to request

external resources directly. This results in cleaner code because you no longer

need to clutter your code with resource creation and lookup code. You can use

resource injection in EJB components, web containers, and clients.

J ava Persistence API Model

The Java EE platform introduces the Java Persistence API, which was

developed as part of JSR-220. The Java Persistence API can also be used

outside of EJB components, for example, in web applications and application

clients, and also outside the Java EE platform, in Java SE applications.

Web Services

In the Java EE platform, the use of annotations has greatly improved and

simplified web services support. The following specifications contributed to this

area: JSR 224, Java API for XML-Based Web Services (JAX-WS) 2.0; JSR
http://jcp.org/en/jsr/detail?id=220http://jcp.org/en/jsr/detail?id=220


32/82



222, Java Architecture for XML Binding (JAXB) 2.0; and JSR 181, Web

Services Metadata for the Java Platform.

JAX-WS 2.0

JAX-WS 2.0 is the new API for web services in the Java EE platform. As

a successor to JAX-RPC 1.1, JAX-WS 2.0 retains the natural RPC

programming model while improving on several fronts: data binding, protocol

and transport independence, support for the REST style of web services, and

ease of development.

A crucial difference from JAX-RPC 1.1 is that all data binding has now

been delegated to JAXB 2.0. This allows JAX-WS-based web services to use

100 percent of XML Schema, which results in improved interoperability and

ease of use. The two technologies are well integrated, so users no longer have to

juggle two sets of tools. When starting from Java technology classes, JAXB 2.0

can generate XML Schema documents that are automatically embedded inside a

Web Service Description Language (WSDL) document, saving users from

Asynchronous Web Services

Because web service invocations take place over a network, such calls can take

unpredictable lengths of time. Many clients, especially interactive ones such as

JFC/Swing-based desktop applications, experience serious performance

degradation from having to wait for a server's response. To avoid such

performance degradation, JAX-WS 2.0 provides a new asynchronous client

API. With this API, application programmers no longer have to create threads

on their own. Instead, they can rely on the JAX-WS runtime to manage long-

running remote invocations for them.


33/82




34/82



SYSTEM DESIGN

System design involves translating information requirements and

conceptual design into technical specification and general flow of processing.

After the user requirements are identified, related information is gathered to

verify the problem and after evaluating the existing system, a new system is

proposed. The proposed system consists of various tables, their maintenanceand report generation.


35/82



In the design, the various techniques are used to present a simple efficient

system. Design phase acts as a bridge between the software requirements

specification and the implementation phase, which satisfies the requirements.

The major step in design is the preparation of input forms and the design of

all the major output forms in a manner acceptable to the user in all aspects. The

base lies in the complete understanding of the system. The data flow diagrams

explicitly specify the process flow. Table design or database design is the next

major step. Extreme care has to be given here and several concepts of

normalization have to be applied at many levels. Several degrees of validation

have to be applied to all inputs and various other operations made on the

system. Deviation, if any, has to be checked from these validation rules.

Imposing the not null constraint is one of the best examples. It has been used

in many aspects. Various other constraints are also used. Security checks refer

to avoiding unnecessary access to data that is under use and guarding data from

any malice.

5.1 INPUT DESIGN

Input design is the process of converting the user-originated input

to a computer based format. The design decision for handling input specify have

data are accepted for computer processing. Input design is a part of overall

design that needs careful attention.


36/82



The collection of input data is considered to be the most expensive

part of the system design. Since the input have to be planned in such a way so as

to get the relevant information, extreme care is taken to obtain the pertinent

information. If the data going into the system is incorrect then the processing

and outputs will magnify these errors. The goal of designing input data is to

make data entry as easy, logical and free from errors as possible.

The following are the objectives of input design:

To produce a cost effective method of input. To make the input forms understandable to the end users.

To ensure the validation of data inputs.

The nature of input data is determined partially during logical system design .

However the nature of inputs are made more explicit during the physical

design. The impact of inputs on the system is also determined.

Error has been made to ensure that input data remains accurate from the stage

at which it is recorded and documented to the stage at which it is accepted by

the computer. Validation procedures are also present to detect errors in the data

input, which is beyond control procedures. Validation procedures are designed

to check each record, data item or field against certain criteria.

5.2 OUTPUT DESIGN

The output design phase of the system design is concerned with the

conveyance of information to the end users in a user friendly manner. The

output design should be efficient, intelligible so that system relationship with

the end user is improved and thereby enhancing the process of decision making.


37/82



The output design is an ongoing activity almost from the beginning of

the project, and follows of the principles of form design. Efficient and well-

defined output design improves the relation of the system and the user, thus

facilitating decision making. The primary consideration in the design of the

output are the requirements of the information and the objectives of end users.

The system output may of any of the following

A Webpage A Document A Message

In the project titled Virtual Version, the output consists of web pages

requested by the client if the request is valid, otherwise it will show the error

page. The output design should be efficient, intelligible so that system

relationship with the end user is improved and they are by enhancing the

process of decision making .

Design is the first in the development phase for any engineered

product or system. System design is a process of evaluating alternate solution,

evaluating the choice following at the specification for the chosen alternating.

System design work follows logically system analysis. The objectives of the

system design is to improve the existing system or design a new system as the

case may be and implement the system with improved facilities.

Computer software design, approaches in the other disciplines,

changes continually as a new methods, better analysis and broader

understanding evolve. Using one of the design methods, the design steps

reduces a data design, and architectural design, and procedural design.

5.3 DATABASE DESIGN


38/82



To group the given data to give them a logical structure, a database

design is necessary. The overall objective in the development of a database is to

treat data as an organized resources and is an integrated whole.

A Database is a repository of information. It is a collection of inter

related data stored with minimum redundancy to serve many users quick and

efficiently. The general objective is to make information access easy, quick,

inexpensive and flexible for the users. In this project, we are mainly

concentrated into relational databases. Relational database stores data in tables,

which is turn, are composed of rows also known as records, columns are known

as fields. The fields in the relational models are,

Primary Key

The key which uniquely identify records. They also notify the not

null constraint.

Foreign Key

A foreign key consists of one or more columns in a table whose value

in one row uniquely identifies another row in the same or another table.

Normalization

After the conceptual level, the next level of process of database

design to organize the database structure into a good shape called

Normalization. The Normalization simplifies the entries, removing

redundancies from the system data and finally builds a data structure, which is

both flexible and adaptable to the system. The different normal forms obtained

during the database design are given below.

First Normal Form (1NF)


39/82



Second Normal Form(2 NF) Third Normal Form (3NF)

First Normal Form

A relation is said to be in first normal form if only if it is satisfies the

constraints that contain the primary key.

Second Normal Form

A relation is said to be in second normal form if and only if it satisfies all

the first normal form conditions for the primary key and every non-primary

attributes of the relation is fully dependent on its primary key alone.

Third Normal Form

A relation is said to be in third normal form if only if it is in second formand more over the non key attributes of the relation should not be depend on

other non-key attribute.


40/82



SYSTEMIMPLEMENTATION

6.1 SYSTEM TESTING

Testing is the penultimate step of software development. An elaborate

testing of data is prepared and the system is using test data. While doing testing,

errors are noted and correction is made. Thus users are trained to operate the

developed system. Both hardware and software securities are made to run the

developed system successfully.


41/82



System testing is aimed at ensuring the system works accurately before

live operation commences. Testing is vital to the system. System testing makes

a logical assumption that if all part of the system are correct, the goal will be

successfully achieved. The candidate system is subjected to a variety of tests:

Online response, Volume, Stress Recovery and Security and Usable tests. A

series of testing are performed for the proposed system is ready for user

acceptance testing. Nothing is complete without testing as it is vital success of

the system.

The entire testing process can be divided into 3 Phases

Unit Testing IntegrationTesting Final/SystemTesting

Unit Testing

Unit testing focuses verification effort on the smallest unit of software

designs the module. To check whether each module in the software works

properly so that it gives desired outputs given to the inputs. All validation and

conditions are tested in the module level in the unit test. Control paths are tested

to ensure the information properly flows into, and out of the program unit under

test. Boundary condition is tested to ensure that modules operate at boundaries.

All independent paths through the control structures ensure that all statements in

the module havebe executed at-least once.

Black Box Testing

The testing method is also called path testing . It is a test case design method

that uses the control structure of the procedural design to drive test case. In this

system, Unit testing has been successfully handled. The test data was given to


42/82



each and every module in all respects and got the desired output. Each module

has been tested found working properly.

Integration Testing

The major concerns of integration testing are developing an incremental

strategy that will limit the complexity of entire actions among components as

they are added to the system. Developing a component as they are added to the

system, developing an implementation and integration schedules that will make

modules available when needed, and designing test cases that will demonstrate

the viability of the evolving system. Though each program works individually,they should work after linking them together. This is also referred as

interfacing. Data may be lost across interface and one module can have an

adverse effect on another. Subroutines , after linking, may not do the desired

function expected by the main routine. Integration testing is a systematic

technique for constructing program structure while at same time, conducting

test to uncover errors associated with the interface. In the testing , the programs

are constructed and tested in small segments.

Data Validation Testing

Data validation is done to see whether the corresponding entries made

in the tables are correct. Proper validations are done in case of insertion and

updating of tables. If any such case arises, then proper error message or

warning, if any, has to be displayed.


43/82



The different test cases are:

Guarantee that all independent parts within a module have beexercised at least one.

Exercise all logical decision on their true/false side. Exercise all loops at their boundaries and within their operational

bounds.

Exercise internal data structure to ensure their validity. Each module was tested and the tested modules were linked and

integration test was carried out.

Password Testing

The login process is tested with some separate login trials. Password is mainly

meant for security. Incorrect will be screened. Also already crated password

wont be allowed to use again.

Test Data

The system analyst will provide the test data, specially designed to show

that the system will operate successfully in all its aspects and produce expected

result under expected conditions. Preparation of test data and the checking of

result should be carried out in conjunction with the appropriate users and

operational departments. Also extent to which the system should be tested must

be planned.

System Testing

When a system is developed , it is hoped that it performs properly. In

practice , however, some errors always occur. The main purpose of testing an

information system is to find the errors and correct them. A successful test is

one, which finds an error.


44/82



The main objectives of system testing are

To ensure during operation the system will perform as perspecification.

To make sure that system meets users requirements duringoperation.

To verify that the controls incorporated in the system functions asintended.

To see that when correct inputs are fed to the system outputs arecorrect.

To make sure that during operation, incorrect input and output willbe deleted.

The scope of the system test should include both manual operations

and computerized. Operational system testing is a comprehensive evaluation of

the programs, manual procedures, computer operations and controls. System

testing is the process of checking is the developed system is working according

to the original objectives and requirements. All testing needs to be conducted

in accordance to the test conditions specified earlier.

Acceptance Testing

Undertaken in this project. An acceptance test has objectives of

selling the user on the validity and reliability of the system it verifies that the

system procedures operate to system specification and that the integrity of vital

data is maintained. I tested the system with a large collection of records. The

system is found to be user friendly and working efficiently. All the above

testing was successfully done.

6.2 CHANGE OVER


45/82



The software is developed in JEE which make the system reliable

and compatible with the other environments. The application proves better

extensibility and flexibility for future enhancement. Any further requirements

application is possible with the same future guaranteed . The design of the

software is such a way that the addition of any new module is possible without

affecting the integrity of the present system.

Some suggestion to improve the functioning of the system

1. The provision to remember the user name and password for the user incase confusion arises.

2. Online help (FAQ) can be attached to the system to make the systemmore user-friendly.


46/82



conclusion

Anything cannot be ended in a single step. It is the fact that nothing is

permanent in the world. So, these utility also has some future enhancement in

the evergreen and booming IT industry. Change is inevitable. Almost every

project is subjected to change depending on the clients requirements. Since

Student management system is subjected to change, there is always a scope for


47/82



further enhancement. The system and the architecture of the proposed system is

a compatible one, so addition of new modules can be done without much

difficulty. Since these module has its unique properties it can extend further to

make the system a complete one.

The software was implemented and tested with real and were font to be

error free. Also, the system is protected from any unauthorized access. All the

necessary validations are carried out on this project, so that any kind of users

can make use of this software and necessary message makes them conscious of

the error they have made

This project incorporates with almost all requirements of its objectives.

Using JSP, Net Beans and SQL server 2005 the project is developed and tested

successfully. The performance of the new system is more efficient as compared

to the old one.

Within limited time span we have tried our best level to develop our

application package General college information and drafts. We are not

demanding that this project has no drawbacks, but we are sure that it is unique

of its nature. The new computerized system will be an effective alternative to

the existing system.


48/82



bibliography

Web Resources

http://www.w3schools.comhttp://www.wikipedia.orghttp://www.google.com

Book References
http://www.w3schools.com/http://www.w3schools.com/http://www.w3schools.com/http://www.wikipedia.org/http://www.wikipedia.org/http://www.wikipedia.org/http://www.google.com/http://www.google.com/http://www.google.com/http://www.google.com/http://www.wikipedia.org/http://www.w3schools.com/


49/82



Java2 : The Complete Reference, Herbert Schildt , Tata McGrawHillPublications

Microsoft SQL Server Black Book by Patrick Dalton, Prentic HallPublications

Software Engineering and Application by Rogger S. Pressman, TMHPublications.


50/82



aPPENDIX

Data bases are usually used for storing the data related to a particular

project. The data is stored separately from the main project code which give

flexibility to change the code whenever it needs timely maintenance. The data is

stored in a tabular format where a single table consists of inter related data.


51/82




52/82



DATA FLOW

DIAGRAM

Level 0


53/82



Level 1

LEVEL 2 -ADMIN


54/82




55/82



LEVEL 2-DONOR


56/82



LEVEL 2-ACCEPTOR


57/82



DATA BaSE

STRUCTURE

DONOR REGISTRATION


58/82



BLOOD REQUEST


59/82



BLOOD STOCK

CONTACTUS


60/82



FEEDBACK

LOGIN

BLOOD BANK REGISTRATION


61/82




62/82



SOURCE CODE

HOME


63/82




64/82



Variantcolor by FCT


65/82



d

LIFE DROPS

Welcome To Life Drops Blood Bank


66/82



February 14, 2013

This is Donation of blood, is a sign of

kindness and care for the fellow human beings. There is no gift more valuble

than a gift of blood,as it is actually a gift of life for person who receives it. Life

Drops Blood Bank is an online edge for bringing mutually giving blood donors

and patients who needs blood in India.

You can go to the nearest government approved blood

centre, which is based on voluntary non/remunerated blood donation and make

your significant contribution to saving life of a patient by donat ing

blood. Your contribution is extremely valuable to us.


67/82



Username:

Password:

Donor

Blood Bank

&nbsp

;


68/82




69/82



Contact

Us|

AboutUs|

Terms and Conditions

LOGIN VERIFICATION


70/82



Document : loginvarification

Created on : Jan 23, 2013, 2:15:58 PM

--%>


71/82



if(uname.equals(rs.getString("username").trim())&&

pword.equals(rs.getString("password").trim()))

{

session.setAttribute("lid",id);

category=rs.getString("category").trim();

f=1;

break;

}

}

if(f==1)

{

if(uname.equals("Admin"))

{

response.sendRedirect("AdminHome.jsp");

}

else if(opt.equals("Donor")&& category.equals("Donor"))

{


response.sendRedirect("DonorHome.jsp");

}

else if(opt.equals("Blood Bank")&& category.equals("BloodBank"))

{



72/82



}

else

{

response.sendRedirect("index.jsp?msg=Invalid category");

}

}

else

{

response.sendRedirect("index.jsp?msg=Invalid username or password");

}

%>


73/82



String pword=request.getParameter("pass");

String opt=request.getParameter("opt");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection

con=DriverManager.getConnection("jdbc:odbc:lifedrops","sa","reshma");

String qry="select * from login";

Statement st=con.createStatement();

ResultSet rs=st.executeQuery(qry);

String category="";

int f=0;

int id=0;

while(rs.next())

{

id= rs.getInt("refid");

if(uname.equals(rs.getString("username").trim())&&

pword.equals(rs.getString("password").trim()))

{


category=rs.getString("category").trim();

f=1;

break;

}

}

if(f==1)


74/82



{

if(uname.equals("Admin"))

{


}

else if(opt.equals("Donor")&& category.equals("Donor"))

{


response.sendRedirect("DonorHome.jsp");

}

else if(opt.equals("Blood Bank")&& category.equals("BloodBank"))

{


}

else

{

response.sendRedirect("index.jsp?msg=Invalid category");

}

}

else

{

response.sendRedirect("index.jsp?msg=Invalid username or password");

}


75/82



%>


76/82



FORMS

HOME PAGE


77/82



BLOOD STOCK


78/82



FEEDBACK


79/82



GENERAL INFO


80/82



TERMS AND CONDITIONS


81/82



VIEW BLOOD REQUESTS


82/82


life drops

Documents