Online Courier Service System

INTRODUCTION
The Project entitled “ONLINE COURIER SERVICE SYSTEM” is a web-based

application software. Courier services means any services provided to
a customer, by a courier agency in relation to door-to-door transportation of
courier, documents, goods or articles.
Online Courier service system is software which is used manage the

work regarding the services of the courier in an effective & efficient manner.
Basically it stores the information regarding the customer and his material,
which has to be couriered.
EXISTING SYSTEM:
The system is developed to transfer the some important things and personal
messages from one place to another. It is very difficult to do this process
manually. Because The data for a particular maintained in a proper file. A
person summarizes all the data of the courier in a register. This work require a
high level of attention. Since it has to be taken that no wrong entry goes to the
register. This work may lead to errors thus resulting in the wrong entry of the
courier data packets.
Since the data maintained in the register, the modification of data cannot easily
done. The previous information has to be erased and overwritten or a new page
has to be allocated so that both the old and new data can be written in the same
page.
The summarizing of data preparation of an up to date report is very complex. It
requires a lot of hard work and searching through different register so as to
condense the data for presentation.
The existing system is not totally automated. Though the system is
computerized to a particular extent, it has to do a lot of manual work.
From the client site, the entire work was achieved manually and they manage all
billing and service manually. Because of the manual system there are many
problems occurred in the existing system. The existing system has lot of
problems such as
 It involves managing a huge amount of data each having separate data
item.
 All the work is done at a very large volume so we have a possibility of
losing data.
 To look for a particular problem, the entire system is searched.so the
process become very time consuming.
 The entire database is maintained manually which is rather tedious and
error prone.
[1]
 Time delay is more because of verification of many records for
generating reports, answering courier etc.
 More space is required to keep all the records and improper interface.
PROPOSED SYSTEM:
After a detailed study of existing system. It is evident that it doesn't fulfill the
objectives of the organization. To make the objective possibly for the
organization, it is required to have a computerized information system with the
help of which all the tasks can be processed quickly and accurately. To achieve
this, It is necessary to design and develop a new system. Proposed system is
being designed in such a way that many users can have a view with the system
simultaneously and perfect utilization of man power and resources.
Hence it is recommended to computerize the process by developing the relative
software as the world is turning into information and technology;
computerization becomes necessity in all walks of life.
Objective of the System:
The objective of “Online Courier Services System” project are as follows:
 The main objective of project is to provide users with the facility of taking
online courier service.
 Less time consuming.
 Due to the easy and secure accessing of site, multiple user access
simultaneously.
 Providing online Pickup Request.
 Easy Packet Tracking facility.
 Ensure customer satisfaction.
 To provide quick service without any delay.
 Possess complete back up services.
[2]
ANALYSIS OF SYSTEM SPECIFICATION
SYSTEM ANALYSIS:
The primary goal of the system is to improve the efficiency of the existing
system. For that the study of specification of the requirements is very essential.
For the development of the new system, a preliminary survey of the existing
system will be conducted. Investigation done whether the upgradation of the
system into an application program could solve the problems and eradicate the
inefficiency o the existing system.
FEASIBILITY STUDY:
The feasibility study is a formal proposal for a new system. Before the project is
begin, the project is to study, to determine what exactly the user wants
depending upon the result of initial investigation.
The feasibility study activity involves the analysis of the problem and collection
or relevant information relating to the software product. The main aim of
feasibility study activity is to determine whether it would be economically,
technically and operationally feasible to operate the product.
There are three aspects of feasibility study we need to analysis, there are as
follows:
1. Technical feasibility
2. Operational feasibility
3. Economical feasibility
TECHNICAL FEASIBILITY:
Evaluating the technical feasibility is the trickiest part of a feasibility
study. This is because, at this point in time, not too many detailed design of the
system, making it difficult to access issues like performance, costs on (on
account of the kind of technology to be deployed) etc. A number of issues have
to be considered while doing a technical
analysis.
i) Understand the different technologies involved in the proposed

system:
Before commencing the project, we have to be very clear about what are
the technologies that are to be required for the development of the new
system.
ii) Find out whether the organization currently possesses the required
technologies:
Is the required technology available with the organization?
[3]
If so is the capacity sufficient?
For instance –
“Will the current printer be able to handle the new reports and forms
required for the new system?”
OPERATIONAL FEASIBILITY:
Proposed projects are beneficial only if they can be turned into
information systems that will meet the organizations operating
requirements. Simply stated, this test of feasibility asks if the system will
work when it is developed and installed. Are there major barriers to
Implementation? Here are questions that will help test the operational
feasibility of a project:
Is there sufficient support for the project from management from users? If
the current system is well liked and used to the extent that persons will
not be able to see reasons for change, there may be resistance.
Are the current business methods acceptable to the user? If they are not,
Users may welcome a change that will bring about a more operational
and useful systems.
Have the user been involved in the planning and development of the
project?
Early involvement reduces the chances of resistance to the system and in
General and increases the likelihood of successful project.
Since the proposed system was to help reduce the hardships encountered.
In the existing manual system, the new system was considered to be
operational feasible.
ECONOMIC FEASIBILITY:
Economic feasibility attempts 2 weigh the costs of developing and
implementing a new system, against the benefits that would accrue from having
the new system in place. This feasibility study gives the top management the
economic justification for the new system.
A simple economic analysis which gives the actual comparison of costs and
benefits are much more meaningful in this case. In addition, this proves to be a
useful point of reference to compare actual costs as the project progresses.
There could be various types of intangible benefits on account of automation.
These could include increased customer satisfaction, improvement in product
quality better decision making timeliness of information, expediting activities,
improved accuracy of operations, better documentation and record keeping,
faster retrieval of information, better employee morale.
[4]
Design
During the software design phase, the design document is produced, based on
the customer requirements as documented in the SRS document. The main
objective o the design phase is defined as the activities carried out during the
design phase transform the SRS document into the design document. The design
document produced at the end of the design phase should be implementable
using a programming language in the subsequent phase.
The following items are designed and documented during the design phase:
Different modules required: Each module should accomplish some well-
defined task out of the overall responsibility of the software.
Controlled relationship among modules: A control relationship between two
modules essentially arises due to function calls between the two modules.
Interface among different modules: The interface between two modules
identifies the exact data items exchanged between the two modules when a one
module invokes the function of another module.
Data structure of the individual modules: Each module normally stores some
data that functions of the module need to share to accomplish the overall
responsibility of the module.
DATA FLOW DIAGRAM:
A graphical tool used to describe and analyses the movement of data through a
system manual or automated including the process, stores of data, and delays in
the system. Data flow diagrams are central tool and the basis from which other
components are developed. The transformation of data from input to output
through processes, may be described logically and independently of the physical
components associated with the system. The DFD is also known as a data flow
graph or a bubble chart.
DFDs are the model of the proposed system. They clearly should show the
requirements on which the new system should be built. Later during design
activity this is taken as the basis for drawing the system’s structure chart.
CONTEXT DIGRAM:
ONLINE COURIER DIFFERENT

USER SERVICE SYSTEM COURIER
SERVICES
[5]
LEVEL 1 DFD: ADMIN PART
ADD
EMPLOYE
ONLINE COURIER E
ADMIN LOGIN SERVICE SYSTEM
VIEW QUERY
LEVEL 1 DFD: USER PART
REGISTER
BOOKING A
ONLINE COURIER
LOGIN SERVICE SYSTEM COURIER
USER
LOGIN
BOOKING
CANCEL
PAYMENT TRACKING STATUS

DETAILS
LEVEL 1 DFD: EMPLOYEE PART
UPDATE
STATUS
ONLINE COURIER
EMPLOYEE LOGIN SERVICE SYSTEM
VIEW QUERY
VIEW BOOKING
[6]
ENTITY-RELATIONSHIP DIAGRAM(ERD):
The Entity-relationship diagram depicts a relationship between data objects. The
ERD is the notation that is used to conduct the data modeling activity. The
attributes of each data objects noted in the ERD can be described using data
object description.
ERD notation also provides a mechanism that represents the association
between objects, data modeling and the entity relationship.
Admin Admin id Offer code Validity

name
Admin Manages Offers
has has
location Courier
Admin id service name
provides
Location
Branch
Name
License No.
Branch
Courier
Service
updates
Destination Manages
branch id Regd No.
Source User id
branch id
Courier date
id Mob. No User name
Status
Track Details views User
[7]
SOFTWARE REQUIREMENTS
Front End : Java

Back End : Oracle 10g
Operating System : Windows 7
HARDWARE REQUIREMENTS
Processor : Pentium 4
Hard Disk : 20GB or above
RAM : 2GB
[8]
IMPLEMETING CRITERIA
TECHNOLOGY DESCRIPTION:
JAVA TECHNOLOGY :
Initially the language was called as “oak” but it was renamed as “Java” in 1995.
The primary motivation of this language was the need for a platform-
independent (i.e., architecture neutral) language that could be used to create
software to be embedded in various consumer electronic devices.
 Java is a programmer’s language.
 Java is cohesive and consistent.
 Except for those constraints imposed by the Internet environment,
Java gives the programmer, full control.
 Finally, Java is to Internet programming where C was to system
programming.
Importance of Java to the Internet:
Java has had a profound effect on the Internet. This is because; Java expands the
Universe of objects that can move about freely in Cyberspace. In a network, two
categories of objects are transmitted between the Server and the Personal
computer. They are: Passive information and Dynamic active programs. The
Dynamic, Self-executing programs cause serious problems in the areas of
Security and probability. But, Java addresses those concerns and by doing so,
has opened the door to an exciting new form of program called the Applet.
Java can be used to create two types of programs:

Applications and Applets: An application is a program that runs on our
Computer under the operating system of that computer. It is more or less like
one creating using C or C++. Java’s ability to create Applets makes it important.
An Applet is an application designed to be transmitted over the Internet and
executed by a Java –compatible web browser. An applet is actually a tiny Java
program, dynamically downloaded across the network, just like an image. But
the difference is, it is an intelligent program, not just a media file. It can react to
the user input and dynamically changes.
FEATURES OF JAVA:
Java is an Object-Oriented Language. As a language that has the Object-
Oriented feature, Java supports the following fundamental concepts:
Simple:
Java is simple because it does not support pointer, operator overloading any
multiple inheritances. Java is easy to write and more readable and eye catching.
Most of the concepts are draw from C++ thus making java learning simple. It
follows most of the syntaxes of C and C++. Java provides automatic garbage
[9]
collection technique ultimately recovers falsely occupies memory spaces. Which
simplifies the manual garbage collection in C and C++.
Portable:
Java environment itself is also a portable. Portable=platform independent +
Architecture Neutral. Java programs can execute in any environment or run on
any platform(Linux, Mac, Windows) for which there is a java run time
system.Java programs can be transferred over world wide.
Robust:
JAVA has been designed for writing highly reliable or robust software. Java
does automatic garbage collection, which prevents memory leaks. Java
encourages error free programming by being strictly typed and performing run
time checks.
Multithread:
Java was Multithreading means handling multiple tasks simultaneously or

parallel. Java supports multithreaded programs which is not same in many
object oriented programming language. When multithreading is implemented in
programs it need not to wait for the application to finish one task before being
another.
Java allows multiple concurrent threads of execution to be active at once. This

means that you could be listening to an audio clip while scrolling the page and
in the background downloading an image. Java contains sophisticated
synchronization primitives, that are integrated into the language to make them
easy to use and robust. The java language package provides a Thread class that
supports methods to start ,run, and stop a thread , and check on its status.
Networked:
Java is a networked, Java help in developing web based applications. The

protocol such as http and ftp are help in accessing the network. Java program
can be transferred from one computer to another computer through the network
and executed on a remote system because JAVA is networked.
Dynamic:
Java is dynamic because objects in java are always created at run time and
hence the object method linking is also done at run time. All the naming
resolutions made at run time that’s why JAVA is dynamic.
Secure:
JAVA is initially made for developing distributed application can be shared

through network. Internet is always exposed to various occur java’s aim was to
[10]
provides a various free environment for smooth execution of distributed
application. In java is no direct reference to memory space.
Architecture-Neutral:
Earlier programs are used to run on the same system where they are compiled.
Because the machine code generates by the compiler is machine specific but in
JAVA the compiler produces a byte code which can be transferred to nay
machine for execution provides that JVM must be installed there . Their goal
was “ write once, run anywhere, anytime, forever.”
Interpreted and High Performance:
Java is an interpreter language. Java’s byte code always interpreted to machine

specific code by JVM. But interpretation consumes more time as compared to
compiler. Hence performance of the language or Just In Time (JIT) compiler
introduced byte code provide an architecture neutral object file format. The
code is designed to transport programs efficiently to multiple platforms.
Java Database Connectivity:

What Is JDBC?
JDBC is a Java API for executing SQL statements. (As a point of interest,
JDBC is a trademarked name and is not an acronym; nevertheless, JDBC is
often thought of as standing for Java Database Connectivity. It consists of a set
of classes and interfaces written in the Java programming language. JDBC
provides a standard API for tool/database developers and makes it possible to
write database applications using a pure Java API using JDBC,: it is easy to
send SQL statements to virtually any relational database. One can write a single
program using the JDBC API, and the program will be able to send SQL
statements to the appropriate database. The combinations of Java and JDBC lets
a programmer write it once and run it anywhere.
Common JDBC Components:-
The JDBC API provides the following interfaces and classes:

 Driver Manager: This class manages a list of database drivers. Matches
connection requests from the java application with the proper database
driver using communication sub-protocol. The first driver that recognizes
a certain sub-protocol under JDBC will be used to establish a database
connection.
 Driver: This interface handles the communications with the database

server. You will interact directly with Driver objects very rarely. Instead,
of use Driver Manager objects, which manages objects of this type. It also
abstracts the details associated with working with Driver objects.
[11]
 Connection: This interface with all methods for contacting a database.
The connection object represents communication context, i.e., all
communication with database is through connection object only.
 Statement: You use objects created from this interface to submit the
SQL statements to the database. Some derived interfaces accept
parameters in addition to executing stored procedures.
 Result Set: These objects hold data retrieved from a database after you
execute an SQL query using Statement objects. It acts as an iterated to
allow you to move through its data.
 SQLException: This class handles any errors that occur in a database
application.
What Does JDBC Do?

All JDBC programs do the following:
1) Load the JDBC driver.

Class. for Name("sun.jdbc.odbc.JdbcOdbcDriver");
2) Specify the name and location of the database being used.

3) Connect to the database with a Connection object.
Connection con= Driver Manager. getConnection (“jdbc: odbc: omega”,
“login”, “password”);
4) Execute a SQL query using a Statement object.

Statement stmt= con.create Statement ();
5) Get the results in a ResultSet object.

Result Set rs= stmt. execute Query (“select a, b, c from table”);
6) Finish by closing the ResultSet, Statement and Connection object.

conn.close();
JDBC versus ODBC and other APIs

At this point, Microsoft's ODBC (Open Database Connectivity) API is that
probably the most widely used programming interface for accessing relational
databases. It offers the ability to connect to almost all databases on almost all
platforms.
So why not just use ODBC from Java? The answer is that you can use ODBC
from Java, but this is best done with the help of JDBC in the form of the JDBC-
[12]
ODBC Bridge, which we will cover shortly. The question now becomes "Why
do you need JDBC?" There are several answers to this question:
1. ODBC is not appropriate for direct use from Java because it uses a C
interface. Calls from Java to native C code have a number of drawbacks
in the security, implementation, robustness, and automatic portability of
applications.
2. A literal translation of the ODBC C API into a Java API would not be
desirable. For example, Java has no pointers, and ODBC makes copious
use of them, including the notoriously error-prone generic pointer "void
*". You can think of JDBC as ODBC translated into an object-oriented
interface that is natural for Java programmers.
3. ODBC is hard to learn. It mixes simple and advanced features together,
and it has complex options even for simple queries. JDBC, on the other
hand, was designed to keep simple things simple while allowing more
advanced capabilities where required.
4. A Java API like JDBC is needed in order to enable a "pure Java" solution.
When ODBC is used, the ODBC driver manager and drivers must be
manually installed on every client machine. When the JDBC driver is
written completely in Java, however, JDBC code is automatically
installable, portable, and secure on all Java platforms from network
computers to mainframes.
Two-tier and Three-tier Models:
The JDBC API supports both two-tier and three-tier models for database
access.
In the two-tier model, a Java applet or application talks directly to the database.
This requires a JDBC driver that can communicate with the particular database
management system being accessed. A user's SQL statements are delivered to
the database, and the results of those statements are sent back to the user. The
database may be located on another machine to which the user is connected via
a network. This is referred to as a client/server configuration, with the user's
machine as the client, and the machine housing the database as the server. The
network can be an Intranet, which, for example, connects employees within a
corporation, or it can be the Internet.
In the three-tier model, commands are sent to a "middle tier" of services,

which then send SQL statements to the database. The database processes the
SQL statements and sends the results back to the middle tier, which then sends
them to the user. MIS directors find the three-tier model very attractive because
the middle tier makes it possible to maintain control over access and the kinds
of updates that can be made to corporate data. Another advantage is that when
there is a middle tier, the user can employ an easy-to-use higher-level API
which is translated by the middle tier into the appropriate low-level calls.
Finally, in many cases the three-tier architecture can provide performance
advantages.
[13]
Java applet or
JAVA
Client machine Html browser
Client machine (GUI)
Application
DBMS-proprietary protocol HTTP, RMI, or CORBA

JDBC
Application calls
Server (Java)
Server machine (business
JDBC
DBMS-proprietary
Logic)
protocol
Database server
Database server
DBMS
DBMS
[ TWO TIER MODEL ] [ THREE TIER MODEL ]
Until now the middle tier has typically been written in languages such as C or
C++, which offer fast performance. However, with the introduction of
optimizing compilers that translate Java byte code into efficient machine-
specific code, it is becoming practical to implement the middle tier in Java. This
is a big plus, making it possible to take advantage of Java's robustness,
multithreading, and security features. JDBC is important to allow database
access from a Java middle tier.
JDBC Driver Types
The JDBC drivers that we are aware of at this time fit into one of four
categories:
 JDBC-ODBC bridge plus ODBC driver
 Native-API partly-Java driver
 JDBC-Net pure Java driver
 Native-protocol pure Java driver
JDBC-ODBC Bridge
If possible, use a Pure Java JDBC driver instead of the Bridge and an
ODBC driver. This completely eliminates the client configuration required by
ODBC. It also eliminates the potential that the Java VM could be corrupted by
an error in the native code brought in by the Bridge (that is, the Bridge native
library, the ODBC driver manager library, the ODBC driver library, and the
database client library).
[14]
What Is the JDBC- ODBC Bridge?
The JDBC-ODBC Bridge is a JDBC driver, which implements JDBC
operations by translating them into ODBC operations. To ODBC it appears as
a normal application program. The Bridge implements JDBC for any
database for which an ODBC driver is available. The Bridge is implemented
as the Sun jdbc odbc Java package and contains a native library used to
access ODBC. The Bridge is a joint development of Innersole and Java Soft
DATABASE:
A database management system (DBMS) is computer software designed for the
purpose of managing databases, a large set of structured data, and run
operations on the data requested by numerous users. Typical examples of
DBMSs include Oracle, DB2, Microsoft Access, Microsoft SQL Server,
Firebird, MySQL, SQLite, FileMaker and Sybase Adaptive Server Enterprise.
DBMSs are typically used by Database administrators in the creation of
Database systems. Typical examples of DBMS use include accounting, human
resources and customer support systems.
Originally found only in large companies with the computer hardware needed to
support large data sets, DBMSs have more recently emerged as a fairly standard
part of any company back office.
Description
A DBMS is a complex set of software programs that controls the

organization, storage, management, and retrieval of data in a database. A DBMS
includes:
A modeling language to define the schema of each database hosted in the
DBMS, according to the DBMS data model.
The four most common types of organizations are the hierarchical, network,
relational and object models. Inverted lists and other methods are also used. A
given database management system may provide one or more of the four
models. The optimal structure depends on the natural organization of the
application's data, and on the application's requirements (which include
transaction rate (speed), reliability, maintainability, scalability, and cost).
The dominant model in use today is the ad hoc one embedded in SQL, despite
the objections of purists who believe this model is a corruption of the relational
model, since it violates several of its fundamental principles for the sake of
practicality and performance. Many DBMSs also support the Open Database
Connectivity API that supports a standard way for programmers to access the
DBMS.
[15]
Data structures (fields, records, files and objects) optimized to deal with very
large amounts of data stored on a permanent data storage device (which implies
relatively slow access compared to volatile main memory).
A database query language and report writer to allow users to
interactively interrogate the database, analyze its data and update it according to
the users privileges on data.
It also controls the security of the database.
Data security prevents unauthorized users from viewing or updating the
database. Using passwords, users are allowed access to the entire database or
subsets of it called subschemas. For example, an employee database can contain
all the data about an individual employee, but one group of users may be
authorized to view only payroll data, while others are allowed access to only
work history and medical data.
If the DBMS provides a way to interactively enter and update the database, as
well as interrogate it, this capability allows for managing personal databases.
However, it may not leave an audit trail of actions or provide the kinds of
controls necessary in a multi-user organization. These controls are only
available when a set of application programs are customized for each data entry
and updating function.
A transaction mechanism, that ideally would guarantee the ACID
properties, in order to ensure data integrity, despite concurrent user accesses
(concurrency control), and faults (fault tolerance).
It also maintains the integrity of the data in the database.
The DBMS can maintain the integrity of the database by not allowing more than
one user to update the same record at the same time. The DBMS can help
prevent duplicate records via unique index constraints; for example, no two
customers with the same customer numbers (key fields) can be entered into the
database. See ACID properties for more information (Redundancy avoidance).
The DBMS accepts requests for data from the application program and
instructs the operating system to transfer the appropriate data.
When a DBMS is used, information systems can be changed much more easily
as the organization's information requirements change. New categories of data
can be added to the database without disruption to the existing system.
Organizations may use one kind of DBMS for daily transaction processing and
then move the detail onto another computer that uses another DBMS better
suited for random inquiries and analysis. Overall systems design decisions are
performed by data administrators and systems analysts. Detailed database
design is performed by database administrators.
[16]
Database servers are specially designed computers that hold the actual databases
and run only the DBMS and related software. Database servers are usually
multiprocessor computers, with RAID disk arrays used for stable storage.
Connected to one or more servers via a high-speed channel, hardware database
accelerators are also used in large volume transaction processing environments.
DBMSs are found at the heart of most database applications. Sometimes
DBMSs are built around a private multitasking kernel with built-in networking
support although nowadays these functions are left to the operating system.
SQL
Structured Query Language (SQL) is the language used to manipulate relational
databases. SQL is tied very closely with the relational model.
In the relational model, data is stored in structures called relations or tables.
SQL statements are issued for the purpose of:
Data definition: Defining tables and structures in the database (DDL used to
create, alter and drop schema objects such as tables and indexes).
Data manipulation: Used to manipulate the data within those schema objects
(DML Inserting, Updating, Deleting the data, and Querying the Database).
A schema is a collection of database objects that can include: tables, views,
indexes and sequences
List of SQL statements that can be issued against an Oracle database schema
are:
 ALTER - Change an existing table, view or index definition (DDL)
 AUDIT - Track the changes made to a table (DDL)
 COMMENT - Add a comment to a table or column in a table (DDL)
 COMMIT - Make all recent changes permanent (DML - transactional)
 CREATE - Create new database objects such as tables or views (DDL)
 DELETE- Delete rows from a database table (DML)
 DROP - Drop a database object such as a table, view or index (DDL)
 GRANT - Allow another user to access database objects such as tables or
views (DDL)
 INSERT - Insert new data into a database table (DML)
 No AUDIT - Turn off the auditing function (DDL)
 REVOKE - Disallow a user access to database objects such as tables and
views (DDL)
 ROLLBACK - Undo any recent changes to the database (DML -
Transactional)
 SELECT - Retrieve data from a database table (DML)
 TRUNCATE - Delete all rows from a database table (can not be rolled
back) (DML)
[17]
 UPDATE- Change the values of some data items in a database table
(DML)
ORACLE SERVER:
INTRODUCTION TO ORACLE:
An Oracle database is a collection of data treated as a unit. The purpose of a
database is to store and retrieve related information. A database server is the key
to solving the problems of information management. In general, a server
reliably manages a large amount of data in a multiuser environment so that
many users can concurrently access the same data. All this is accomplished
while delivering high performance. A database server also prevents
unauthorized access and provides efficient solutions for failure recovery. Oracle
Database is the first database designed for enterprise grid computing, the most
flexible and cost effective way to manage information and applications
BASIC DATABASE CONCEPT:
A database is a corporate collection of data of data with some inherent meaning,
design, built and populated with data for a specific purpose. A database stores
data that is useful to us. This data is only a part o the entire data available in the
world around us.
To be able to successfully design and maintain data we have to do the
following.
-Identify which part of the world’s data is of interest to us
-Identify what specific object in the part of the world’s data are of interest to us.
-Identify a relationship between the objects.
Hence the object, their attributes and the relationship between them that are of
interest to us are still owed in the database that is designed built and populated
with data for a specific purpose.
CHARACTERSTICS OF DATABASE MANAGEMENT SYSTEM:
-It represents a complex relationship between data.
-Keeps a control of debtor redundancy.
-Has a centralized data dictionary for the storage of information pertaining to
data and its manipulation.
-Ensure that data can be share across applications.
-Enforces data access authorization has automatic, intelligent backup and
recovery of procedures for data.
-Have different interface via which user can manipulate data.
[18]
CODING
HOME PAGE:
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
class homepage
{
JFrame f;
JPanel p1,p2,p3,p4,p5,p6,p7,p8,p9;
JLayeredPane lp;
JLabel l1,l2,l3,l4,l5,li,li2,li3,li4,li5;
JButton b1,b2,b3,b4,b5,b6;
homepage()
{
f=new JFrame("homepage form");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
p7=new JPanel();
p8=new JPanel();
p9=new JPanel();
lp=new JLayeredPane();
b1=new JButton("Home");
b2=new JButton("Login");
b3=new JButton("Registration");
b4=new JButton("tracking");
b5=new JButton("contact us");
b6=new JButton("About us");
l1=new JLabel("WEL-COME TO OUR WEBSITE");
l2=new JLabel("Offers:");
l3=new JLabel("5% less cost on booking a courier");
l4=new JLabel("(Only for new users)");
l5=new JLabel("Thank You");
GridBagConstraints o= new GridBagConstraints();
Font f1=new Font("Palatino Linotype",Font.BOLD,20);
Font f2=new Font("Bookman Old Style",Font.BOLD,20);
Font f4=new Font("Copperplate Gothic",Font.BOLD,20);
p2.setLayout(new GridBagLayout());
li=new JLabel();
ImageIcon img=new ImageIcon("D:/project image/homet11.jpg");
li.setIcon(img);
p1.add(li);
p1.setBounds(0,0,680,200);
p1.setOpaque(false);
b1.setFont(f1);
o.fill=GridBagConstraints.HORIZONTAL;
[19]
o.gridx=0;
o.gridy=0;
p2.add(b1,o);
b2.setFont(f1);
o.gridx=1;
o.gridy=0;
p2.add(b2,o);
b3.setFont(f1);
o.gridx=2;
o.gridy=0;
p2.add(b3,o);
b4.setFont(f1);
o.gridx=3;
o.gridy=0;
p2.add(b4,o);
b5.setFont(f1);
o.gridx=4;
o.gridy=0;
p2.add(b5,o);
b6.setFont(f1);
o.gridx=5;
o.gridy=0;
p2.add(b6,o);
p2.setBackground(new Color(0,255,255));
p2.setBounds(0,190,680,55);
li2=new JLabel();
ImageIcon img2=new ImageIcon("D:/project image/homett2.jpg");
li2.setIcon(img2);
p3.add(li2);
p3.setBounds(0,233,700,125);
ImageIcon img3=new ImageIcon("D:/project image/homet3.jpg");
li3=new JLabel();
li3.setIcon(img3);
p4.add(li3);
p4.setBounds(0,355,200,125);
li4=new JLabel();
li4.setIcon(img4);
p5.setBounds(0,475,200,125);
p5.add(li4);
li5=new JLabel();
li5.setIcon(img5);
p6.add(li5);
[20]
p6.setBounds(185,356,150,250);
l1.setForeground(new Color(0,0,128));
l1.setFont(f2);
p7.add(l1);
p7.setBounds(320,357,350,75);
l2.setFont(f3);
o.gridx=1;
o.gridy=1;
p8.add(l2,o);
l3.setFont(f4);
o.gridx=1;
o.gridy=2;
p8.add(l3,o);
l4.setFont(f4);
o.gridx=1;
o.gridy=3;
p8.add(l4,o);
p8.setBounds(315,350,350,150);
l5.setFont(f2);
p9.add(l5);
p9.setBounds(500,500,150,75);
f.add(lp,BorderLayout.CENTER);
lp.add(p1,new Integer(0));
f.setSize(694,640);
f.setVisible(true);
b1.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
f.setVisible(false);
new homepage();
}
});
[21]
{
{
new loginpage();
}
});
{
{
new registrationpage();
}
});
{
{
new trackingpage();
}
});
{
{
new contactuspage();
}
});
{
{
new aboutuspage();
}
});
}
public static void main(String S[])
{
new homepage();
}
}
REGISTRATION PAGE:
import java.awt.*;
import java.sql.*;
class registrationpage implements ActionListener
{
[22]
JFrame f;
JPanel p1,p2,p3,p4,p5,p6,p7,p8;
JLayeredPane lp;
JLabel l1,l2,l3,l4,l5,l6,l7,lh,li;
JTextField tf1,tf5,tf6,tf7,tf8,tf9;
JPasswordField pf1;
JButton b1,b2,b3,b4;
JComboBox cb1,cb2,cb3;
JRadioButton rb1,rb2;
String v1,v2,v3,v4,v5,v6,v7,date;
String gender;
ButtonGroup bg;
registrationpage()
{
f=new JFrame("Registration Form");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
p7=new JPanel();
p8=new JPanel();
li=new JLabel("");
lh=new JLabel("User Registration");
l1=new JLabel("Name");
l2=new JLabel("Gender");
l3=new JLabel("Date Of Birth");
l4=new JLabel("Mobile Number");
l5=new JLabel("User id");
l6=new JLabel("password");
l7=new JLabel("E-mail id");
tf1=new JTextField(20);
cb1=new JComboBox();
pf1=new JPasswordField(20);
b1=new JButton("SUBMIT");
b2=new JButton("RESET");
b3=new JButton("Back");
b3.addActionListener(this);
rb1=new JRadioButton("male");
rb1.setActionCommand("male");
rb2=new JRadioButton("female");
rb2.setActionCommand("female");
bg=new ButtonGroup();
[23]
bg.add(rb1);
bg.add(rb2);
Font f1=new Font("Times New Roman",Font.BOLD,20);
li.setFont(f1);
ImageIcon img=new ImageIcon("D:/project image/registration.jpg");
li.setIcon(img);
p8.add(li);
p8.setBounds(0,0,600,600);
lh.setFont(f2);
p1.add(lh);
p1.setBounds(200,50,200,50);
l1.setFont(f1);
o.gridx=1;
o.gridy=1;
p2.add(l1,o);
o.gridx=2;
o.gridy=1;
p2.add(tf1,o);
l2.setFont(f1);
o.gridx=1;
o.gridy=2;
p2.add(l2,o);
p4.add(rb1);
p4.add(rb2);
o.gridx=2;
o.gridy=2;
p2.add(p4,o);
l3.setFont(f1);
o.gridx=1;
o.gridy=3;
p2.add(l3,o);
p6.add(cb1);
p6.add(cb2,);
p6.add(cb3);
for(int i=1;i<32;i++)
{
cb1.addItem(i);
}
{
[24]
cb2.addItem(i);
}
for(int i=1990;i<=2017;i++)
{
cb3.addItem(i);
}
o.gridx=2;
o.gridy=3;
p2.add(p6,o);
l4.setFont(f1);
o.gridx=1;
o.gridy=4;
p2.add(l4,o);
o.gridx=2;
o.gridy=4;
p2.add(tf5,o);
l5.setFont(f1);
o.gridx=1;
o.gridy=5;
p2.add(l5,o);
o.gridx=2;
o.gridy=5;
p2.add(tf6,o);
l6.setFont(f1);
o.gridx=1;
o.gridy=6;
p2.add(l6,o);
o.gridx=2;
o.gridy=6;
p2.add(pf1,o);
l7.setFont(f1);
o.gridx=1;
o.gridy=7;
p2.add(l7,o);
o.gridx=2;
o.gridy=7;
p2.add(tf9,o);
p2.setBounds(90,50,400,400);
b1.setFont(f3);
p5.add(b1);
b2.setFont(f3);
p5.add(b2);
[25]
p5.setBounds(175,370,200,150);
p7.add(b3);
b3.setFont(f3);
p7.add(b4);
b4.setFont(f3);
p7.setBounds(200,450,200,150);
f.setSize(600,600);
f.setVisible(true);
b1.addActionListener(new ActionListener(){
{
if(e.getSource()==b1)
{
gender=bg.getSelection().getActionCommand();
String y1=cb1.getSelectedItem().toString();
date=y1+"/"+y2+"/"+y3;
conn();
new loginpage();
JOptionPane.showMessageDialog(null,"Registered Successfully completed");
}
}
});
{
{
reset();
}
}
});
}
void conn()
{
v1=tf1.getText();
v2=tf5.getText();
v3=tf6.getText();
v4=pf1.getText();
v5=tf9.getText();
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
[26]
Connection
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","shankar
");
PreparedStatement psmt=con.prepareStatement("insert into registration
values(?,?,?,?,?,?,?)");
psmt.setString(1,v1);
psmt.setString(2,gender);
psmt.setString(3,date);
int i=psmt.executeUpdate();
catch(Exception e)
{
}
}
{
{
new homepage();
}
}
void reset()
{
tf1.setText("");
tf5.setText("");
tf6.setText("");
tf7.setText("");
pf1.setText("");
tf9.setText("");
}
public static void main(String s[])
{
new registrationpage();
}
}
LOGIN PAGE:
import java.awt.*;
import java.sql.*;
class loginpage
{
JFrame f;
JPanel p1,p2,p3,p4,p5,p6;
JLabel l1,l2,li1,lh,l4,l5;
JLayeredPane lp;
JTextField tf1;
[27]
JPasswordField pf1;
JButton b1,b2,b4;
JComboBox cb1;
String type;
loginpage()
{
f=new JFrame("Login form");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
li1=new JLabel("");
lh=new JLabel("Login");
l1=new JLabel("User Id");
l2=new JLabel("Password");
l4=new JLabel("Login type");
l5=new JLabel("click here to register");
b1=new JButton("LOGIN");
b4=new JButton("Register");
ImageIcon img1=new ImageIcon("D:/project image/log.jpg");
li1.setIcon(img1);
p1.add(li1);
p1.setBounds(0,0,500,500);
lh.setFont(f1);
p2.add(lh);
p2.setBounds(100,50,200,100);
l4.setFont(f2);
o.gridx=1;
o.gridy=0;
p3.add(l4,o);
o.gridx=2;
o.gridy=0;
p3.add(cb1,o);
String s[]={"Admin","Employee","User"};
{
cb1.addItem(s[i]);
[28]
}
l1.setFont(f2);
o.gridx=1;
o.gridy=2;
p3.add(l1,o);
o.gridx=2;
o.gridy=2;
p3.add(tf1,o);
l2.setFont(f2);
o.gridx=1;
o.gridy=3;
p3.add(l2,o);
o.gridx=2;
o.gridy=3;
p3.add(pf1,o);
p3.setOpaque(true);
p3.setBounds(0,200,500,150);
b1.setFont(f3);
p4.add(b1);
p4.setOpaque(true);
p4.setBounds(0,325,500,100);
b4.setFont(f3);
l5.setFont(f2);
o.gridx=1;
o.gridy=1;
p6.add(l5,o);
o.gridx=1;
o.gridy=2;
p6.add(b4,o);
p6.setOpaque(true);
p6.setBounds(0,365,500,75);
p5.add(b2);
b2.setFont(f3);
p5.setOpaque(true);
p5.setBounds(0,435,500,75);
lp.add(p4,new Integer(2 ));
f.setSize(500,525);
f.setVisible(true);
{
[29]
{
type=cb1.getSelectedItem().toString();
submit();
}
});
{
{
new homepage();
}
});
}
public void submit()
{
try
{
Connection
");
Statement st=con.createStatement();
if(type.equalsIgnoreCase("user"))
{
ResultSet rs=st.executeQuery("select * from registration");
while(rs.next())
{
String x1=rs.getString(5);
if(x1.equals(tf1.getText())&& x2.equals(pf1.getText()))
{
JOptionPane.showMessageDialog(null,"log in successfully complete");
new userpage();
}
}
}
else if(type.equalsIgnoreCase("admin"))
{
ResultSet rs=st.executeQuery("select * from admin");
while(rs.next())
{
{
new adminpage();
}
}
[30]
}
else if(type.equalsIgnoreCase("employee"))
{
ResultSet rs=st.executeQuery("select * from employeereg");
while(rs.next())
{
{
new employeepage();
}
}
}
}
catch(Exception e)
{
}
}
{
new loginpage();
}
}
USER PAGE:
import java.awt.*;
class userpage
{
JFrame f;
JPanel p1,p2,p3,p4,p5,p6,p7;
JLayeredPane lp;
JLabel l1,li1,li2;
JButton b1,b2,b3,b4,b5,b6,b7,b8;
userpage()
{
f=new JFrame("userpage form");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
p7=new JPanel();
b1=new JButton("Book a courier");
b2=new JButton("tracking");
b3=new JButton("Contact");
[31]
b7=new JButton("Payment");
b8=new JButton("Cancel Booking");
b6=new JButton("Log out");
l1=new JLabel("WEL-COME Sir/Mam");
p1.setLayout(new FlowLayout());
li1=new JLabel();
ImageIcon img=new ImageIcon("D:/project image/welcome.jpg");
li1.setIcon(img);
p1.add(li1);
p1.setBounds(0,0,700,200);
li2=new JLabel();
ImageIcon img2=new ImageIcon("D:/project image/userpage.jpg");
li2.setIcon(img2);
p4.add(li2);
p4.setBounds(0,225,700,350);
o.gridx=0;
o.gridy=0;
o.insets=new Insets(10,10,10,10);
p2.add(b1,o);
o.gridx=1;
o.gridy=0;
o.insets=new Insets(5,5,10,10);
p2.add(b2,o);
o.gridx=0;
o.gridy=1;
p2.add(b3,o);
o.gridx=1;
o.gridy=1;
p2.add(b7,o);
p2.setBounds(350,225,300,200);
p5.add(b4);
p5.add(b5);
p5.setBounds(450,475,200,100);
p7.add(b8);
p7.setBounds(415,370,150,100);
[32]
l1.setBackground(new Color(0,0,0));
l1.setFont(f2);
p3.add(l1);
p3.setBounds(0,200,715,25);
p6.add(b6);
p6.setBounds(610,200,100,35);
f.setSize(715,575);
f.setVisible(true);
{
{
new bookingpage();
}
});
{
{
new trackingpage();
}
});
{
{
}
});
{
{
new loginpage();
}
});
[33]
{
{
new homepage();
}
});
{
{
new paymentpage();
}
});
{
{
new bookcancelpage();
}
});
{
{
new loginpage();
}
});
}
public static void main(String S[])
{
new userpage();
}
}
BOOKING PAGE:
import java.awt.*;
import java.sql.*;
import java.rmi.server.UID;
class bookingpage
{
JFrame f;
JPanel p1,p2,p3,p4,p5,p6,p7;
JLayeredPane lp;
JLabel l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12,l13,l14,li,l,lgm;
JTextField tf1,tf5,tf7,tf8,tf9,tf11,tf12,tf14;
[34]
JTextArea tf6,tf10;
JComboBox cb1,cb2,cb3,cb4,cb5,cb6;
String date,x1;
String v1,v2,v3,v4,v5,v6,v7,v8,v9,v10,v11;
bookingpage()
{
f=new JFrame("Booking Form");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
p7=new JPanel();
lh=new JLabel("Booking Details");
li=new JLabel("");
l1=new JLabel("Parcel No.");
l2=new JLabel("Booking Date");
l3=new JLabel("From Address");
l5=new JLabel("Adress");
l6=new JLabel("State");
l7=new JLabel("Mob.No");
l8=new JLabel("To Address");
l10=new JLabel("Adress");
l11=new JLabel("State");
l13=new JLabel("Courier Details");
l14=new JLabel("Weight");
lgm=new JLabel("Gram");
tf6=new JTextArea(2,1);
tf10=new JTextArea(2,1);
[35]
l1.setFont(f1);
ImageIcon img=new ImageIcon("D:/project image/book.jpg");
li.setIcon(img);
p1.add(li);
p1.setBounds(0,0,900,700);
lh.setFont(f2);
p6.add(lh);
p6.setBounds(335,0,200,75);
o.gridx=1;
o.gridy=1;
p2.add(l1,o);
UID P_no = new UID();
x1= P_no.toString().substring(0,6).replace("-","");
tf1.setText(x1);
o.gridx=2;
o.gridy=1;
p2.add(tf1,o);
l2.setFont(f1);
o.gridx=1;
o.gridy=2;
p2.add(l2,o);
p4.add(cb1);
p4.add(cb2);
p4.add(cb3);
{
cb1.addItem(i);
}
{
cb2.addItem(i);
}
for(int i=2017;i<=2017;i++)
{
cb3.addItem(i);
}
o.gridx=2;
o.gridy=2;
p2.add(p4,o);
l3.setFont(f2);
o.gridx=1;
[36]
o.gridy=3;
p2.add(l3,o);
l4.setFont(f1);
o.gridx=1;
o.gridy=4;
p2.add(l4,o);
o.gridx=2;
o.gridy=4;
p2.add(tf5,o);
l5.setFont(f1);
o.gridx=1;
o.gridy=5;
p2.add(l5,o);
o.gridx=2;
o.gridy=5;
p2.add(tf6,o);
l6.setFont(f1);
o.gridx=1;
o.gridy=6;
p2.add(l6,o);
o.gridx=2;
o.gridy=6;
p2.add(tf7,o);
l7.setFont(f1);
o.gridx=1;
o.gridy=7;
p2.add(l7,o);
o.gridx=2;
o.gridy=7;
p2.add(tf8,o);
p2.setBounds(10,30,400,400);
l8.setFont(f2);
o.gridx=1;
o.gridy=8;
p7.add(l8,o);
l9.setFont(f1);
o.gridx=1;
o.gridy=9;
p7.add(l9,o);
o.gridx=2;
[37]
o.gridy=9;
p7.add(tf9,o);
l10.setFont(f1);
o.gridx=1;
o.gridy=10;
p7.add(l10,o);
o.gridx=2;
o.gridy=10;
p7.add(tf10,o);
l11.setFont(f1);
o.gridx=1;
o.gridy=11;
p7.add(l11,o);
o.gridx=2;
o.gridy=11;
p7.add(tf11,o);
l12.setFont(f1);
o.gridx=1;
o.gridy=12;
p7.add(l12,o);
o.gridx=2;
o.gridy=12;
p7.add(tf12,o);
l13.setFont(f2);
o.gridx=1;
o.gridy=13;
p7.add(l13,o);
l14.setFont(f1);
o.gridx=1;
o.gridy=14;
p7.add(l14,o);
o.gridx=2;
o.gridy=14;
p7.add(tf14,o);
o.gridx=3;
o.gridy=14;
p7.add(lgm,o);
p7.setBounds(400,30,450,400);
p3.add(b1);
p3.add(b2);
b1.setFont(f3);
b2.setFont(f3);
[38]
p3.setBounds(300,360,200,100);
p5.add(b3);
p5.add(b4);
b3.setFont(f3);
b4.setFont(f3);
p5.setBounds(330,410,200,100);
lp.setBounds(0,0,900,500);
f.setSize(900,500);
f.setVisible(true);
{
{
date=y1+"/"+y2+"/"+y3;
conn();
JOptionPane.showMessageDialog(null,"booked successfully");
new paymentpage();
}
}
});
{
{
reset();
}
}
});
{
{
new userpage();
}
});
{
[39]
{
new homepage();
}
});
}
void conn()
{
v1=tf1.getText();
v2=tf5.getText();
v3=tf6.getText();
v4=tf7.getText();
v5=tf8.getText();
v6=tf9.getText();
v7=tf10.getText();
v8=tf11.getText();
v9=tf12.getText();
v10=tf14.getText();
v11=tf15.getText();
try
{
Connection con=
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","shankar");
PreparedStatement psmt=con.prepareStatement("insert into booking
values(?,?,?,?,?,?,?,?,?,?,?,?)");
}
catch(Exception e)
{
}
}
void reset()
{
tf1.setText("");
tf5.setText("");
tf6.setText("");
tf7.setText("");
tf8.setText("");
tf9.setText("");
[40]
tf10.setText("");
tf11.setText("");
tf12.setText("");
tf14.setText("");
tf15.setText("");
}
{
new bookingpage();
}
}
TRACKING PAGE:
import java.awt.*;
import java.sql.*;
class trackingpage
{
JFrame f;
JPanel p1,p2,p3,p4;
JLayeredPane lp;
JLabel l1,l2,lh,li;
JTextField tf1;
JTextArea ta1;
JButton b1,b2,b3;
trackingpage()
{
f=new JFrame("Tracking Form");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
lh=new JLabel("Tracking Status");
li=new JLabel("");
l1=new JLabel("Order no.");
l2=new JLabel("STATUS");
ta1=new JTextArea(3,1);
b1=new JButton("SHOW");
b3=new JButton("home");
[41]
ImageIcon img=new ImageIcon("D:/project image/tracking.jpg");
li.setIcon(img);
p3.add(li);
p3.setBounds(0,0,500,350);
lh.setFont(f2);
p1.add(lh);
p1.setBounds(135,10,200,75);
l1.setFont(f1);
o.gridx=1;
o.gridy=1;
p2.add(l1,o);
o.gridx=2;
o.gridy=1;
p2.add(tf1,o);
b1.setFont(f3);
o.gridx=3;
o.gridy=1;
p2.add(b1,o);
l2.setFont(f1);
o.gridx=1;
o.gridy=2;
p2.add(l2,o);
o.gridx=2;
o.gridy=2;
p2.add(ta1,o);
p2.setBounds(60,30,400,200);
b2.setFont(f3);
b3.setFont(f3);
p4.add(b2);
p4.add(b3);
p4.setBounds(135,250,200,100);
f.setSize(500,350);
f.setVisible(true);
{
{
[42]
{
submit();
}
}
});
{
{
new userpage();
}
});
{
{
new homepage();
}
});
}
public void submit()
{
try
{
Connection
");
ResultSet rs=st.executeQuery("select * from statusupdate");
while(rs.next())
{
if(x1.equals(tf1.getText()))
{
ta1.setText(x2);
}
}
}
catch(Exception e)
{
}
}
{
new trackingpage();
}
}
[43]
CONTACT US PAGE:
import java.awt.*;
import java.sql.*;
class contactuspage
{
JFrame f;
JPanel p1,p2,p3,p4,p5;
JLayeredPane lp;
JLabel l1,l2,l4,l5,li,l6,lh;
JTextField tf1,tf2,tf4;
JTextArea ta1;
JComboBox cb1;
String v1,v2,v3,v4,type;
contactuspage()
{
f=new JFrame("Contact us Form");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
lh=new JLabel("Contact Us");
li=new JLabel("");
l4=new JLabel("Cell Number");
l6=new JLabel("Subject");
l5=new JLabel("Comments");
b1=new JButton("Submit");
b2=new JButton("Reset");
li.setFont(f1);
ImageIcon img=new ImageIcon("D:/project image/contact2.jpg");
li.setIcon(img);
p1.add(li);
p1.setBounds(0,0,600,435);
[44]
lh.setFont(f2);
p5.add(lh);
p5.setBounds(150,10,200,50);
l6.setFont(f1);
o.gridx=1;
o.gridy=0;
p2.add(l6,o);
o.gridx=2;
o.gridy=0;
p2.add(cb1,o);
String s[]={"complain","Feedback"};
{
cb1.addItem(s[i]);
}
l1.setFont(f1);
o.gridx=1;
o.gridy=1;
p2.add(l1,o);
o.gridx=2;
o.gridy=1;
p2.add(tf1,o);
l2.setFont(f1);
o.gridx=1;
o.gridy=2;
p2.add(l2,o);
o.gridx=2;
o.gridy=2;
p2.add(tf2,o);
l4.setFont(f1);
o.gridx=1;
o.gridy=4;
p2.add(l4,o);
o.gridx=2;
o.gridy=4;
p2.add(tf4,o);
l5.setFont(f1);
o.gridx=1;
o.gridy=6;
p2.add(l5,o);
o.gridx=2;
o.gridy=6;
[45]
p2.add(ta1,o);
p2.setBounds(40,10,400,350);
b1.setFont(f3);
p3.add(b1);
b2.setFont(f3);
p3.add(b2);
p3.setBounds(135,275,250,150);
p4.add(b3);
p4.add(b4);
b3.setFont(f3);
b4.setFont(f3);
p4.setBounds(185,345,200,100);
f.pack();
f.setSize(600,435);
f.setVisible(true);
{
{
type=cb1.getSelectedItem().toString();
conn();
JOptionPane.showMessageDialog(null,"Submitted successfully");
}
});
{
{
new loginpage();
}
});
{
{
new homepage();
}
});
}
void conn()
[46]
{
v1=tf1.getText();
v2=tf2.getText();
v3=tf4.getText();
v4=ta1.getText();
try
{
Connection
");
PreparedStatement psmt=con.prepareStatement("insert into contact values(?,?,?,?,?)");
psmt.setString(1,type);
}
catch(Exception e)
{
}
}
{
}
}
PAYMENT PAGE:
import java.awt.*;
import java.sql.*;
import java.io.*;
class paymentpage
{
JFrame f;
JLayeredPane lp;
JLabel l1,l2,l3,l4,li,lh;
JTextField tf1,tf2,tf3,tf4;
JRadioButton rb1;
ButtonGroup bg;
String ptype,x1,payment,x2,x3,amount;
paymentpage()
{
f=new JFrame("Payment Form");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
[47]
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
lh=new JLabel("Payment Details");
li=new JLabel("");
l1=new JLabel("Parcel No");
l3=new JLabel("Amount");
l4=new JLabel("Mode");
rb1=new JRadioButton("Cash on home");
rb1.setActionCommand("Cash on home");
bg.add(rb1);
b1=new JButton("save");
b4=new JButton("calculate");
ImageIcon img=new ImageIcon("D:/project image/payment.jpg");
li.setIcon(img);
p5.add(li);
p5.setBounds(0,0,600,400);
p5.setOpaque(true);
lh.setFont(f2);
p1.add(lh);
p1.setBounds(275,25,200,75);
GridBagConstraints o=new GridBagConstraints();
l1.setFont(f1);
o.gridx=1;
o.gridy=1;
p2.add(l1,o);
o.gridx=2;
o.gridy=1;
p2.add(tf1,o);
tf1.setText(x1);
l2.setFont(f1);
o.gridx=1;
o.gridy=2;
[48]
p2.add(l2,o);
o.gridx=2;
o.gridy=2;
p2.add(tf2,o);
l3.setFont(f1);
o.gridx=1;
o.gridy=3;
p2.add(l3,o);
o.gridx=2;
o.gridy=3;
p2.add(tf3,o);
o.gridx=3;
o.gridy=3;
p2.add(b4,o);
l4.setFont(f1);
o.gridx=1;
o.gridy=4;
p2.add(l4,o);
p2.setBounds(160,40,450,175);
o.gridx=2;
o.gridy=1;
p3.add(rb1,o);
p3.setBounds(175,110,400,125);
b1.setFont(f3);
p4.add(b1);
p4.setBounds(350,240,100,50);
p6.add(b2);
p6.add(b3);
b2.setFont(f3);
b3.setFont(f3);
p6.setBounds(310,300,200,100);
f.setSize(600,400);
f.setVisible(true);
[49]
{
{
ptype=bg.getSelection().getActionCommand();
typ();
}
});
{
{
new bookingpage();
}
});
{
{
new homepage();
}
});
{
{
save();
}
});
}
public void save()
{
try
{
Connection
");
ResultSet rs=st.executeQuery("select * from booking");
while(rs.next())
{
x1=rs.getString(1);
{
ResultSet rs1=st.executeQuery("select * from booking where P_no='"+x1+"'");
while(rs1.next())
{
x2=rs1.getString(11);
int val=Integer.parseInt(x2);
int money=(2*(val)+225);
[50]
amount=Integer.toString(money);
tf3.setText(amount);
x3=tf3.getText();
}
}
}
PreparedStatement psmt=con.prepareStatement("insert into payment values(?,?,?,?)");
psmt.setString(1,x1);
psmt.setString(2,x3);
psmt.setString(3,amount);
psmt.setString(4,ptype);
}
catch(Exception e)
{
}
}
public void typ()
{
if(ptype.equalsIgnoreCase("cash on home"))
{
JOptionPane.showMessageDialog(null,"Saved Successfully");
new userpage();
}
}
{
new paymentpage();
}
}
BOOKING CANCEL PAGE:
import java.awt.*;
import java.sql.*;
class bookcancelpage
{
JFrame f;
JLayeredPane lp;
JLabel l1,li,lh;
JTextField tf1;
JButton b1,b2,b3;
String parcelno;
String x1;
bookcancelpage()
{
f=new JFrame("Booking Cancel Form");
p1=new JPanel();
p2=new JPanel();
[51]
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
lh=new JLabel("Booking Cancel Details");
li=new JLabel("");
l1=new JLabel("Order No");
b1=new JButton("cancel book");
ImageIcon img=new ImageIcon("D:/project image/bookcancel.jpg");
li.setIcon(img);
p4.add(li);
p4.setBounds(0,0,600,500);
lh.setFont(f2);
p1.add(lh);
p1.setBounds(125,25,300,40);
l1.setFont(f1);
o.gridx=1;
o.gridy=1;
p2.add(l1,o);
o.gridx=2;
o.gridy=1;
p2.add(tf1,o);
o.gridx=3;
o.gridy=1;
p2.add(b1,o);
p2.setBounds(50,50,450,150);
p3.add(b2);
p3.add(b3);
b2.setFont(f3);
b3.setFont(f3);
p3.setBounds(200,300,200,100);
[52]
f.setSize(600,400);
{
conn();
}
});
{
{
new userpage();
}
});
{
{
new homepage();
}
});
f.setVisible(true);
}
public void conn()
{
parcelno=tf1.getText();
try
{
Connection
");
ResultSet rs=st.executeQuery("select * from booking");
while(rs.next())
{
x1=rs.getString(1);
System.out.println(x1);
{
ResultSet rs1=st.executeQuery("delete from booking where P_no='"+parcelno+"'");
JOptionPane.showMessageDialog(null,"Booking Canceled");
}
}
}
catch(Exception e){}
}
[53]
{
new bookcancelpage();
}
}
EMPLOYEE REGISTRATION PAGE:
import java.awt.*;
import java.sql.*;
class employeeregpage implements ActionListener
{
JFrame f;
JPanel p1,p2,p3,p4,p5,p6,p7,p8;
JLayeredPane lp;;
JLabel l1,l2,l3,l4,l5,l6,l7,l10,l11,l12,l13,lh,li;
JTextField tf1,tf2,tf5,tf6,tf7,tf8,tf9,tf10,tf11;
JPasswordField pf1;
JComboBox cb1,cb2,cb3;
JRadioButton rb1,rb2;
String v1,v2,v3,v4,v5,v6,v7,v8,v9,date;
String gender;
ButtonGroup bg;
employeeregpage()
{
f=new JFrame("EmpRegistration Form");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
p7=new JPanel();
p8=new JPanel();
lh=new JLabel("Employee Registration Form");
li=new JLabel("");
l2=new JLabel("Gender");
l3=new JLabel("Date Of Birth");
l4=new JLabel("Mobile Number");
l5=new JLabel("Employee id");
l6=new JLabel("password");
l7=new JLabel("Address");
l11=new JLabel("Qualification");
l12=new JLabel("Designation");
l13=new JLabel("Salary");
[54]
rb1=new JRadioButton("male");
rb1.setActionCommand("male");
rb2=new JRadioButton("female");
rb2.setActionCommand("female");
bg.add(rb1);
bg.add(rb2);
li.setFont(f1);
ImageIcon img=new ImageIcon("D:/project image/empreg.jpg");
li.setIcon(img);
p8.add(li);
p8.setBounds(0,0,700,700);
lh.setFont(f2);
p1.add(lh);
p1.setBounds(210,50,325,50);
l1.setFont(f1);
o.gridx=1;
o.gridy=1;
p2.add(l1,o);
o.gridx=2;
o.gridy=1;
p2.add(tf1,o);
l2.setFont(f1);
o.gridx=1;
o.gridy=2;
p2.add(l2,o);
p7.add(rb1);
p7.add(rb2);
[55]
o.gridx=2;
o.gridy=2;
p2.add(p7,o);
l3.setFont(f1);
o.gridx=1;
o.gridy=3;
p2.add(l3,o);
p6.add(cb1,o);
p6.add(cb2,o);
p6.add(cb3,o);
{
cb1.addItem(i);
}
{
cb2.addItem(i);
}
for(int i=1990;i<=2017;i++)
{
cb3.addItem(i);
}
o.gridx=2;
o.gridy=3;
p2.add(p6,o);
l4.setFont(f1);
o.gridx=1;
o.gridy=4;
p2.add(l4,o);
o.gridx=2;
o.gridy=4;
p2.add(tf5,o);
l5.setFont(f1);
o.gridx=1;
o.gridy=5;
p2.add(l5,o);
o.gridx=2;
o.gridy=5;
p2.add(tf6,o);
l6.setFont(f1);
o.gridx=1;
o.gridy=6;
p2.add(l6,o);
[56]
o.gridx=2;
o.gridy=6;
p2.add(pf1,o);
l7.setFont(f1);
o.gridx=1;
o.gridy=7;
p2.add(l7,o);
o.gridx=2;
o.gridy=7;
p2.add(tf7,o);
l10.setFont(f1);
o.gridx=1;
o.gridy=8;
p2.add(l10,o);
o.gridx=2;
o.gridy=8;
p2.add(tf8,o);
l11.setFont(f1);
o.gridx=1;
o.gridy=9;
p2.add(l11,o);
o.gridx=2;
o.gridy=9;
p2.add(tf9,o);
l12.setFont(f1);
o.gridx=1;
o.gridy=10;
p2.add(l12,o);
o.gridx=2;
o.gridy=10;
p2.add(tf10,o);
l13.setFont(f1);
o.gridx=1;
o.gridy=11;
p2.add(l13,o);
o.gridx=2;
o.gridy=11;
p2.add(tf11,o);
p2.setBounds(150,100,400,400);
b1.setFont(f3);
p4.add(b1);
[57]
b2.setFont(f3);
p4.add(b2);
p4.setBounds(205,450,250,150);
p5.add(b3);
p5.add(b4);
b3.setFont(f3);
b4.setFont(f3);
p5.setBounds(235,550,200,150);
f.pack();
f.setSize(700,700);
f.setVisible(true);
{
{
gender=bg.getSelection().getActionCommand();
date=y1+"/"+y2+"/"+y3;
sub();
}
}
});
{
{
reset();
}
}
});
{
{
new adminpage();
}
});
{
[58]
{
new homepage();
}
});
}
void sub()
{
v1=tf1.getText();
v2=tf5.getText();
v3=tf6.getText();
v4=pf1.getText();
v5=tf7.getText();
v6=tf8.getText();
v7=tf9.getText();
v8=tf10.getText();
v9=tf11.getText();
try
{
Connection
");
PreparedStatement psmt=con.prepareStatement("insert into employeereg
values(?,?,?,?,?,?,?,?,?,?,?)");
psmt.setString(2,gender);
}
catch(Exception e)
{
}
}
void reset()
{
tf1.setText("");
tf5.setText("");
tf6.setText("");
pf1.setText("");
tf7.setText("");
tf8.setText("");
tf9.setText("");
tf10.setText("");
[59]
tf11.setText("");
}
{
{
new homepage();
}
}
{
new employeeregpage();
}
}
STATUS UPDATE PAGE:
import java.awt.*;
import java.sql.*;
class updatepage
{
JFrame f;
JLayeredPane lp;
JLabel l1,l2,lh,li;
JTextField tf1;
JButton b1,b3,b4;
JTextArea ta1;
String v1,v2,x1,x2,data;
updatepage()
{
f=new JFrame("Update Form");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
lh=new JLabel("Update Status");
l1=new JLabel("Order no.");
l2=new JLabel("STATUS:");
li=new JLabel("");
b1=new JButton("update");
[60]
Font f1=new Font("Times New Roman ",Font.BOLD,20);
ImageIcon img=new ImageIcon("D:/project image/update.jpg");
li.setIcon(img);
p4.add(li);
p4.setBounds(0,0,500,400);
lh.setFont(f2);
p1.add(lh);
p1.setBounds(135,15,200,75);
l1.setFont(f1);
o.gridx=1;
o.gridy=1;
p2.add(l1,o);
o.gridx=2;
o.gridy=1;
p2.add(tf1,o);
b1.setFont(f1);
l2.setFont(f1);
o.gridx=1;
o.gridy=2;
p2.add(l2,o);
o.gridx=2;
o.gridy=2;
p2.add(ta1,o);
p2.setBounds(50,50,350,150);
b1.setFont(f3);
p3.add(b1);
p3.setBounds(205,180,100,100);
p5.add(b3);
p5.add(b4);
b3.setFont(f3);
b4.setFont(f3);
p5.setBounds(155,285,200,75);
f.setVisible(true);
[61]
f.setSize(500,400);
{
{
show();
JOptionPane.showMessageDialog(null,"Update Successfully completed");
new employeepage();
}
}
});
{
{
new employeepage();
}
});
{
{
new homepage();
}
});
}
void show()
{
v1=tf1.getText();
v2=ta1.getText();
try
{
Connection
");
ResultSet rs=st.executeQuery("select * from statusupdate");
while(rs.next())
{
data=rs.getString(1);
System.out.println(v2);
if(data.equals(tf1.getText()))
{
PreparedStatement psmt=con.prepareStatement("update statusupdate set status='"+v2+"'
where order_no='"+v1+"'");
}
else
[62]
{
PreparedStatement psmt=con.prepareStatement("insert into statusupdate values(?,?)");
}
}
}
catch(Exception e)
{
}
}
{
new updatepage();
}
}
VIEW COURIER PAGE:

import java.awt.*;
import javax.swing.table.*;
import java.sql.*;
class viewpage
{
JFrame f;
JLayeredPane lp;
JLabel l1,l2,li,lh;
JTextField tf1;
JButton b1,b2,b3;
JRadioButton rb1;
DefaultTableModel m;
JTable table;
String[]
column={"P_No","B_Date","F_Name","F_Add","F_State","FM_No","T_Name","T_Add","
T_State","TM_No","Weight","Distance"};
String x1,x2,x3,x4,x5,x6,x7,x8,x9,x10,x11,x12;
Object[][] data;
String[] row;
String parcelno;
String rdata;
viewpage()
{
f=new JFrame("ViewCourier Form");
table=new JTable();
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
[63]
lh=new JLabel("View Courier Details");
li=new JLabel("");
l1=new JLabel("Order No");
rb1=new JRadioButton("all");
b1=new JButton("View");
ImageIcon img=new ImageIcon("D:/project image/view.jpg");
li.setIcon(img);
p4.add(li);
p4.setBounds(0,0,950,600);
p4.setOpaque(true);
lh.setFont(f2);
p1.add(lh);
p1.setBounds(200,75,300,40);
l1.setFont(f1);
o.gridx=1;
o.gridy=1;
p2.add(l1,o);
o.gridx=2;
o.gridy=1;
p2.add(tf1,o);
p2.setBounds(160,80,400,150);
p5.add(rb1);
p5.add(b1);
b1.setFont(f3);
p5.setBounds(150,180,400,150);
p3.add(b2);
p3.add(b3);
b2.setFont(f3);
b3.setFont(f3);
p3.setBounds(275,500,200,100);
p6.add(table.getTableHeader());
p6.add(table);
p6.setBounds(0,285,950,500);
[64]
m=new DefaultTableModel();
m.setColumnIdentifiers(column);
table.setModel(m);
f.setSize(950,600);

{
conn();
}
});
{
{
new employeepage();
}
});
{
{
new homepage();
}
});
f.setVisible(true);
}
public void conn()
{
try
{
Connection
");
if(rb1.isSelected())
{
ResultSet rs1=st.executeQuery("select * from booking");
m.setRowCount(0);
while(rs1.next())
{
[65]
m.addRow(new Object[]{x1,x2,x3,x4,x5,x6,x7,x8,x9,x10,x11,x12});
}
}
else
{
parcelno=tf1.getText();
ResultSet rs=st.executeQuery("select * from booking where P_no='"+parcelno+"'");
m.setRowCount(0);
while(rs.next())
{
x1=rs.getString(1);
x2=rs.getString(2);
x3=rs.getString(3);
x4=rs.getString(4);
x5=rs.getString(5);
x6=rs.getString(6);
x7=rs.getString(7);
x8=rs.getString(8);
x9=rs.getString(9);
x10=rs.getString(10);
m.addRow(new Object[]{x1,x2,x3,x4,x5,x6,x7,x8,x9,x10,x11,x12});
}
}
}
}
{
new viewpage();
}
}
VIEW QUERY PAGE:
import java.awt.*;
import javax.swing.table.*;
import java.sql.*;
class viewquerypage
[66]
{
JFrame f;
JPanel p1,p2,p3,p4;
JLayeredPane lp;
JLabel li,lh;
JButton b1,b2,b3;
JRadioButton rb1;
DefaultTableModel m;
JTable table;
String[] column={"Subject","Name","Email","Mob_No","Comments"};
String x1,x2,x3,x4,x5;
Object[][] data;
String[] row;
String rdata;
viewquerypage()
{
f=new JFrame("View FeedBack/Complains");
table=new JTable();
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
lh=new JLabel("View Query");
li=new JLabel("");
ImageIcon img=new ImageIcon("D:/project image/viewquery.jpg");
li.setIcon(img);
p4.add(li);
p4.setBounds(0,0,500,400);
lh.setFont(f2);
p1.add(lh);
p1.setBounds(150,25,200,50);
p2.add(table.getTableHeader());
p2.add(table);
p2.setBounds(50,75,400,350);
p3.add(b2);
p3.add(b3);
b2.setFont(f3);
b3.setFont(f3);
p3.setBounds(175,325,200,100);
[67]
m=new DefaultTableModel();
m.setColumnIdentifiers(column);
table.setModel(m);
f.setSize(500,400);
{
{
new employeepage();
}
});
{
{
new homepage();
}
});
conn();
f.setVisible(true);
}
public void conn()
{
try
{
Connection
");
ResultSet rs=st.executeQuery("select * from contact");
while(rs.next())
{
x1=rs.getString(1);
x2=rs.getString(2);
x3=rs.getString(3);
x4=rs.getString(4);
x5=rs.getString(5);
m.addRow(new Object[]{x1,x2,x3,x4,x5});
}
}
}
{
new viewquerypage();
[68]
}
}
ABOUT US PAGE:
import java.awt.*;
class aboutuspage
{
JFrame f;
JLayeredPane lp;
JLabel l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12,lh,li;
JButton b1;
aboutuspage()
{
f=new JFrame("Tracking Form");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
li=new JLabel("");
lh=new JLabel("About Us");
l1=new JLabel("* Courier service came into being on sunday,1st january 2014.It all began
with the setting up of one offices at BBSR.");
l2=new JLabel("* Above 100 authorized collection centers and dedicated workforce of over
500 plus employess.");
l3=new JLabel("* The fast placed growth and widening network is the outcome of four basis
benifits.");
l4=new JLabel("1.speed");
l5=new JLabel("2.security");
l6=new JLabel("3.Reliability");
l7=new JLabel("4.Less price");
l8=new JLabel("* courier service commitment to provide a secure environment and also to
achive one of the best domestic courier across India.");
l9=new JLabel("* we charges depending on the distance from source to destination and also
courier size.");
l10=new JLabel("Head Office:");
l11=new JLabel("BMC Bhawani Mall unit-ii,sahid nagar,BBSR,Odisha(gm),PIN-751007");
l12=new JLabel("Thank You");
p4.setLayout(new FlowLayout(FlowLayout.RIGHT));
ImageIcon img=new ImageIcon("D:/project image/aboutus.jpg");
li.setIcon(img);
p1.add(li);
p1.setBounds(0,0,875,500);
[69]
lh.setFont(f2);
p2.add(lh);
p2.setBounds(300,15,200,75);
l1.setFont(f1);
o.gridx=1;
o.gridy=1;
p3.add(l1,o);
l2.setFont(f1);
o.gridx=1;
o.gridy=2;
p3.add(l2,o);
l3.setFont(f1);
o.gridx=1;
o.gridy=3;
p3.add(l3,o);
l4.setFont(f1);
o.gridx=1;
o.gridy=4;
p3.add(l4,o);
l5.setFont(f1);
o.gridx=1;
o.gridy=5;
p3.add(l5,o);
l6.setFont(f1);
o.gridx=1;
o.gridy=6;
p3.add(l6,o);
l7.setFont(f1);
o.gridx=1;
o.gridy=7;
p3.add(l7,o);
l8.setFont(f1);
o.gridx=1;
o.gridy=8;
p3.add(l8,o);
l9.setFont(f1);
o.gridx=1;
o.gridy=9;
p3.add(l9,o);
l10.setFont(f1);
o.gridx=1;
[70]
o.gridy=10;
p3.add(l10,o);
l11.setFont(f1);
o.gridx=1;
o.gridy=11;
p3.add(l11,o);
p3.setBounds(2,25,870,300);
l12.setFont(f2);
p4.add(l12);
p4.setBounds(500,350,175,75);
b1.setFont(f1);
p5.add(b1);
p5.setBounds(250,400,100,75);
f.setSize(890,525);
f.setVisible(true);
{
{
new homepage();
}
});
}
{
new aboutuspage();
}
}
[71]
SCREEN SHOTS
HOME PAGE:
REGISTRATION PAGE:
[72]
LOGIN PAGE:
USERPAGE:
[73]
BOOKING PAGE:
TRACKING PAGE:
[74]
CONTACT US PAGE:
PAYMENT PAGE:
[75]
BOOKING CANCEL PAGE:
ADMIN PAGE:
[76]
EMPLOYEE REGISTRATION PAGE:
VIEW QUERY PAGE:
[77]
EMPLOYEE PAGE:
UPDATE STATUS PAGE:
[78]
VIEW COURIER PAGE:
ABOUT US PAGE:
[79]
TESTING
Software testing is the process of executing a program with intension of finding
errors in the code. It is a process of evolution of system or its parts by manual or
automatic means to verify that it is satisfying specified or requirements or not.
Generally, no system is perfect due to communication problems between user
and developer, time constraints, or conceptual mistakes by developer.
To purpose of system testing is to check and find out these errors or faults as
early as possible so losses due to it can be saved.
Testing is the fundamental process of software success. Testing is not a distinct
phase in system development life cycle but should be applicable throughout all
phases i.e. design development and maintenance phase.
Testing is used to show incorrectness and considered to success when an error is
detected.
OBJECTIVES OF SOFTWARE TESTING:

The software testing is usually performed for the following objectives:-
SOFTWARE QUALITY IMPROVEMENT: The computer and the software are

mainly used for complex and critical applications and a bug or fault in software
causes severe losses. So a great consideration is required for checking for
quality of software.
VERIFICATION AND VALIDATION:-
 Verification means to test that we are building the product in right way
.i.e. aware using the correct procedure for the development of software so
that it can meet the user requirements.
 Validation means to check whether we are building the right product or
not.
Error detection techniques=Verification + Validation techniques.
SOFTWARE RELIABILTY ESTIMATION: The objective is to discover the

residual designing of errors before delivery to the customer. The failure data
during process are taken down in order to estimate the software reliability.
PRINCIPLES OF SOFTWARE TESTING:

Software testing is an extremely creative and challenging task. Some
important principles of software testing are as given below:-
 All tests should be traceable to customer requirements.
 Testing time and resources should be limited i.e. avoid redundant testing.
 It is impossible to test everything.
 Use effective resources to test.
[80]
 Test should be planned long before testing begins i.e. after requirement
phase.
 Test for invalid and unexpected input conditions as well as valid
conditions.
 Testing should begin in “in the small” and progress towards testing “in
the large”.
 For the most effective testing should be conducted by an independent
party.
 Keep software static (without change mean while) during test.
 Document test cases and test results.
 Examining what the software not doing which it expected to do and also
checking what it is doing that was not expected to do.
STRATEGY FOR SOFTWARE TESTING:

Different levels of testing are used in the test process; each level of
testing aims to test different aspects of the system.
The first level is Unit testing. In this testing, individual components are
tested to ensure that they operate correctly. It focuses on verification efforts. It
is undertaken after a module has been coded and reviewed.
The second level is Integration testing. In this testing, many tested
modules are combined into the subsystems which are then tested. The good here
is to see if the modules can be integrated properly. The objective is to test the
modules having no errors while passing the parameters, when one module
invokes the functionality of another module.
The third level is System testing. System testing is actually a series of
different tests whose primary purpose is to fully exercise computer based
system. These tests are not conducted solely by software engineers. System tests
are designed to validate a fully developed system to assure that it meets its
requirements. The test cases are therefore designed solely based on the SRS
document. There are 3 main kinds of system testing-
1. ALPHA TESTING: Carried out by the test team within the developing
organisation.
2. BETA TESTING: Performed by a friendly group of customers.
3. ACCEPTANCE TESTING: Performed by the customer.
Testing a viable candidate system that fulfils the following requirements:-
 Faster and accurate information retrieval.
 Easy registration. § Login dependent information updating.
 Correct and consistent maintenance of data and its quick retrieval.
 Smooth transition and easy access to the pages.
[81]
LIMITATIONS AND FUTURE ENHANCEMENTS
LIMITATIONS OF THE SYSTEM:
 System works in all platforms and its compatible environments.

 Online payment feature is not available.
FUTURE ENHANCEMENTS:
 It is still mature and fully dynamically. Any requirements, this project are
completed but still they want to update and modify some modules. We
are always thinking about organization requirements also growing day by
day. We always want implement something more. This project is
completed when you watch, but we want to implement more things.
 Overseas Service
 In future, security issues can be improved.
 Pickup Request On chat
 Online payment
[82]
Conclusion
Our aim is to provide these services to customers as per their
requirements.This Web Application provides to for sending the courier and
no need to visit anywhere. It saves time as it allows user to login anywhere.
Administrator has a privilege to add a employee and view the feedbacks. User
can register, login andbook a courier,and also can see the tracking status.
The application software “ONLINE COURIER SERVICE SYSTEM” has
been computed successfully and was also tested successfully by taking test
cases. The software is being developed using JAVA as front end and ORACLE
as back end in windows environment.
The goals that are achieved by the software are:

.
 Providing online Pickup Request.
 Easy Packet Tracking facility.
 Ensure customer satisfaction.
 To provide quick service without any delay.
 User friendly
 Flexible
 Less time consuming.
[83]
Bibliography
At the process time of making this project we have take reference of some
outsider sources which we want to mention here.
 The Complete Reference- Java Seventh Edition by Herbert Schildt
 Java database connectivity tutorials point
URL:http://www.tutorialspoint.com
 Software Engineering- Fourth Edition by Rajib Mall
 Database Programming with JDBC and Java by George Reese
 Java and XML by Brett McLaughlin
 Google, URL:http://www.google.co.in
[84]

Online Courier Service System

Uploaded by

Copyright:

Available Formats

Online Courier Service System

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Online Courier Service System

Uploaded by

Copyright:

Available Formats

INTRODUCTION

The Project entitled “ONLINE COURIER SERVICE SYSTEM” is a web-based

Online Courier service system is software which is used manage the

i) Understand the different technologies involved in the proposed

ONLINE COURIER DIFFERENT

LEVEL 1 DFD: USER PART

PAYMENT TRACKING STATUS

LEVEL 1 DFD: EMPLOYEE PART

Admin Admin id Offer code Validity

Admin Manages Offers

Track Details views User

Front End : Java

Java can be used to create two types of programs:

Java was Multithreading means handling multiple tasks simultaneously or

Java allows multiple concurrent threads of execution to be active at once. This

Java is a networked, Java help in developing web based applications. The

JAVA is initially made for developing distributed application can be shared

Interpreted and High Performance:

Java is an interpreter language. Java’s byte code always interpreted to machine

Java Database Connectivity:

The JDBC API provides the following interfaces and classes:

 Driver: This interface handles the communications with the database

What Does JDBC Do?

1) Load the JDBC driver.

2) Specify the name and location of the database being used.

4) Execute a SQL query using a Statement object.

5) Get the results in a ResultSet object.

6) Finish by closing the ResultSet, Statement and Connection object.

JDBC versus ODBC and other APIs

In the three-tier model, commands are sent to a "middle tier" of services,

DBMS-proprietary protocol HTTP, RMI, or CORBA

[ TWO TIER MODEL ] [ THREE TIER MODEL ]

A DBMS is a complex set of software programs that controls the

BOOKING CANCEL PAGE:

EMPLOYEE REGISTRATION PAGE:

STATUS UPDATE PAGE:

VIEW COURIER PAGE:

public void actionPerformed(ActionEvent e)

VIEW QUERY PAGE:

VIEW QUERY PAGE:

UPDATE STATUS PAGE:

OBJECTIVES OF SOFTWARE TESTING:

SOFTWARE QUALITY IMPROVEMENT: The computer and the software are

VERIFICATION AND VALIDATION:-

SOFTWARE RELIABILTY ESTIMATION: The objective is to discover the

PRINCIPLES OF SOFTWARE TESTING:

STRATEGY FOR SOFTWARE TESTING:

LIMITATIONS OF THE SYSTEM:

 System works in all platforms and its compatible environments.

The goals that are achieved by the software are:

You might also like