Project

helpl

ine.in

Project Helpine

Report

“BANQUET

HALL

BOOKING”

- 1 -

Project

helpl

ine.in

BANQUET HALL BOOKING

TABLE OF CONTENT Contents Page No. Acknowledgment 3 Declaration 4

1. Introduction & Objectives of the Project

1.1 Introduction 7

1.2 Objectives of the Project 8

1.3 Project Category 9

1.4 Drawback of Current Manual-System 10

1.5 Proposed System 11

1.6 Existing System And need For System 12

1.7 Input and output of the project 13

2. System Study

2.1 Preliminary Investigation 19

2.2 System Development Life Cycle 20 2.3 Feasibility Study 25 2.4 Economic Feasibility 26 2.5 Technical Feasibility 28

3. System Analysis

3.1 Importance of Computerized System 30

3.2 Principle of System Analysis 31

4. System Design

4.1 System Design 33

4.2 Data Modeling 36

- 2 -

Project

helpl

ine.in

4.3 E-R Diagram 38

4.4 Context Level DFD 39

4.5 Modules 45

4.6 Process Logic for Each Modules 47

4.7 Tool/Platform, Hardware and Software Requirement Specification 48

4.8 Scheduling 49

5. System Development

5.1 Source Code 52

5.2 Code Efficiency 122 6. Testing

6.1 Testing Phase 124

6.2 Level of Testing 125 6.3 Verification and Validation (V&V) 130

6.4 Test Cases 131 7. System Implementation 7.1 Post Implementation Maintenance and Review 136

7.2 Hardware Evaluation Factors 136

7.3 Software Evaluation Factors 138

7.4 Conversion and Training 139

7.5 Training Needs 140

8. Cost Estimation of the Project 141 9. GANTT & PERT CHART 142 10. Security and Validations Checks 145 11. Scope of Future Application 146 12. Conclusion 147 13. Bibliography 148

- 3 -

Project

helpl

ine.in

14. Glossary 149

- 4 -

Project

helpl

ine.in

1.1 INTRODUCTION

Banquet Hall Booking System is a Window based project which act as a bridge between

potential Banquet users and Banquet owners.

Banquet booking system provides complete listing of banquets in different districts,

where each district is further having different sectors, which may comprise of around 100

families. Each sector is having two banquet halls, one is around 5000 sq. meter and

another is 2000 sq.m. These halls can be booked by the family head person residing in

that sector.

This project is designed to provide comprehensive mechanism of Banquet hall booking

for general users.

We have complete listing of Banquets in different districts. The users just need to register

the themselves. The users can search and book the Banquet for their choice of date. It

deals with the operations of Banquet booking, how exactly the system works and who are

all involved in the system.

General users can get information about banquets, cancellation, status of booking etc,

Administrator is an authorized user he can:

• Add District Details.

• Add Sector Details.

• Updating Booking Status.

• Adding member Details.

• Report generation.

- 5 -

Project

helpl

ine.in

1.2 OBJECTIVES OF THE SYSTEM

The objective of this development effort is:-

To provide the information regarding Banquets.

To provide the information about the Booking of users choice.

To provide the functionality of Booking and Cancellation.

To provide the information of status of catering, facilities available.

To provide the facility to maintain the records of users.

Information can be easily accessed.

This system will save the time of the Users.

PURPOSE

Banquet Hall Booking a Management system with Automation System this project is

aimed at automation of a banquet hall booking and thus to develop customize software

package for Banquet halls.

- 6 -

Project

helpl

ine.in

1.3 PROJECT CATEGORY

This project is basically categorized as RDBMS. The project is based on three tier

architecture. The three tier architecture where the application is divided into three logical

constituents.

Presentation layer – In this layer mainly following pages contained:

0. Web Pages

1. User Control

2. Master Pages

Business Layer – Business Logic,

0. Result Engine

1. User permissions logic

2. Access Rights

Data Layer – Provide handling and validation of data (MS SQL Server

in this case).

0. Sql

1. Sybase

2. Oracle

3. Access

- 7 -

Project

helpl

ine.in

1.4 DRAWBACKS OF CURRENT MANUAL- SYSTEM

• The current manual system has a lot of paper work and it does not deal with exact

details.

• With the increase in database, it will become a massive job to maintain the

database.

• Requires large quantities of file cabinets, which are huge and require quite a bit of

space in the office, which can be used for storing records of previous claims.

• The retrieval of records of employees will be a tedious job.

• Lack of security for the records, anyone disarrange the records of your system.

ESTABLISH THE NEED OF NEW SYSTEM

1. Problem of Reliability: Current system is not reliable. It seems to vary in quality

from one month to the next. Some times it gives good output, but some times the

output is worst.

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

3. Problem of timeliness: In the current system the reports and output produced is

mostly late and in most of the cases it is useless because it is not on time.

4. Problem of Validity: The output and reports mostly contains misleading information.

The customer's information is sometimes not valid.

5. Problem of Economy: The current system is very costly. We have to spend lots of

money to keep the system up and going, but still not get the desired results.

6. Problem of Capacity: The current system is suffering from problem of capacity also.

The staff for organization is very less and the workload is too much. Few peoples

cannot handle all the work.

- 8 -

Project

helpl

ine.in

1.5 PROPOSED SYSTEM

1. Details: The new proposed system stores and maintains all the store details, customers details, rates details etc.

2. Calculations: The new proposed system updates tables and other information

automatically and it is very fast and accurate.

3. Registers: There is no need of keeping and maintaining database and

information manually. It remembers each and every record and we can get any

report at any time.

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

time.

5. Manpower: The new proposed system needs less manpower. Less people can

do the large work.

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

less time.

7. Reduces redundancy: The most important benefit of this system is that it

reduces the redundancy of data within the data.

8. Work load: Reduces the work load of the data store by helping in easy

updates of the products and providing them with the necessary details

together with financial transactions management.

9. Easy statements: Month-end and day-end statement easily taken out without

getting headaches on browsing through the day end statements.

- 9 -

Project

helpl

ine.in

1.6 EXISTING SYSTEM AND NEED FOR SYSTEM

The existing system is manual /machine systems where the users must have to perform

their manually. It will take more time and this whole procedure is very tedious and takes a

lot of time.

Problems of the existing system

It is limited to a single system.

It has lot of manual work (Manual work does not mean working with pen or

paper, rather includes working on spread sheets and other simple software.)

The present system is very less secure.

It unable to generate different kinds of reports.

It is difficult to maintain phone bookings and cancellations.

Does not provide global support. User cannot do the reservation from remote

place.

Retrieval of information is difficult and time consuming.

A lot of time and manual effort is required

- 10 -

Project

helpl

ine.in

1.7 INPUT AND OUTPUT OF THE PROJECT

Input To the Project

• Login Module: This is very first module. This module contains authentication

like user ID and Password

• New User’s Details: New users’ details are added by the users. If users enter their

valid details, existed user can then add booking details

• Booking Module: Booking details are added by the users.

• Feedbacks: Feedbacks can be given by the users.

• Queries: Users can enquire about the services provided by the Banquets.

Output of the Project

Administrator can give

• Availability of the banquet

• Respond users queries

• Respond user’s feedbacks

• Report generate are

I. Feedback details

II. Booking details

III. Banquet details

IV. Users details

- 11 -

Project

helpl

ine.in

SOFTWARE & HARDWARE REQUIREMENTS

The need of today’s software development is competence in a GUI based front-end tool,

which can connect to Relational Database engines. This gives the programmer the

opportunity to develop client server based commercial applications.

FRONT END

a) Java (Front End)

Java has the following properties:

• Platform independent: Java programs use the Java virtual machine as abstraction

and do not access the operating system directly. This makes Java programs

highly portable. A Java program (which is standard complaint and follows

certain rules) can run unmodified on all supported platforms, e.g. Windows or

Linux.

• Object-orientated programming language: Except the primitive data types, all

elements in Java are objects.

• Strongly-typed programming language: Java is strongly-typed, e.g. the types of

the used variables must be pre-defined and conversion to other objects is

relatively strict, e.g. must be done in most cases by the programmer.

• Interpreted and compiled language: Java source code is transferred into the

bytecode format which does not depend on the target platform. These bytecode

instructions will be interpreted by the Java Virtual machine (JVM). The JVM

contains a so called Hotspot-Compiler which translates performance critical

bytecode instructions into native code instructions.

• Automatic memory management: Java manages the memory allocation and de-

allocation for creating new objects. The program does not have direct access to

the memory. The so-called garbage collector deletes automatically objects to

which no active pointer exists.

The Java syntax is similar to C++. Java is case sensitive, e.g. variables

called myValue and myvalueare treated as different variables.

- 12 -

Project

helpl

ine.in

BACK END:-My Sql

My SQL is an application used to create computer databases for the Microsoft Windows

family of server operating systems. It provides an environment used to generate databases

that can be accessed from workstations, the web, or other media such as a personal digital

assistant (PDA). MY SQL is probably the most accessible and the most documented

enterprise database environment right now. This also means that you can learn it a little

quicker than most other database environments on the market

To start, you must have a computer that runs an appropriate operating system like

Microsoft Windows >= XP Home Edition: that includes Windows XP Home Edition,

Windows XP Professional, Windows 2000 Professional, or any version of Windows

Server 2003. In this case, you must install MY SQL Yog.

What is SQL Used for:

Using SQL one can create and maintain data manipulation objects such as table, views,

sequence etc. These data manipulation objects will be created and stored on the server's

hard disk drive, in a tablespace, to which the user has been assigned.

- 13 -

Project

helpl

ine.in

Once these data manipulation objects are created, they are used extensively in

commercial applications.

DML, DCL, DDL:

In addition to the creation of data manipulation objects, the actual manipulation of data

within these objects is done using SQL.

The SQL sentences that are used to create these objects are called DDL's or Data

Definition Language. The SQL sentences used to manipulate data within these

objects are called DML's or Data Manipulation Language. The SQL sentences,

which are used to control the behavior of these objects, are called DCL's or Data

Control Language.

- 14 -

Project

helpl

ine.in

- 15 -

Project

helpl

ine.in

2.1 PRELIMINARY INVESTIGATION System development, a process consisting of two major steps of system analysis and

design, start when management or sometimes system development personnel feel that a

new system or an improvement in the existing system is required. The system

development life cycle is classically thought of as the set of activities that analysts,

designers and users carry out to develop and implement an information system. The

system development life cycle consists of the following activities:

Preliminary investigation

Determination of system requirements

Design of system

Development of software

System testing

Implementation, evaluation, and maintenance

A request to take assistance from information system can be made for many reasons,

but in each case someone in the organization initiates the request is made, the first

system activity the preliminary investigation begins. This activity has three parts:

1) Request clarification

2) Feasibility study

3) Request approval

Request clarification: Many requests from employees and users in the

organizations are not clearly defined, therefore it becomes necessary that project

request must be examined and clarified properly before considering systems

investigation.

- 16 -

Project

helpl

ine.in

2.2 SYSTEM DEVELOPMENT LIFE CYCLE

Systems are created to solve problems. One can think of the systems approach as an

organized way of dealing with a problem. In this dynamic world, the subject System

Analysis and Design (SAD), mainly deals with the software development activities.

DEFINING A SYSTEM:- A collection of components that work together to realize some objective forms a

system. Basically there are three major components in every system, namely input,

processing and output.

In a system the different components are connected with each other and they are

interdependent. For example, human body represents a complete natural system. We are

also bound by many national systems such as political system, economic system,

educational system and so forth. The objective of the system demands that some output

is produced as a result of processing the suitable inputs.

SYSTEM LIFE CYCLE:- System life cycle is an organizational process of developing and maintaining systems. It

helps in establishing a system project plan, because it gives overall list of processes and

sub-processes required for developing a system.

System development life cycle means combination of various activities. In other words

we can say that various activities put together are referred as system development life

cycle. In the System Analysis and Design terminology, the system development life cycle

means software development life cycle.

- 17 -

Project

helpl

ine.in

Following are the different phases of software development cycle:

System study

Feasibility study

System analysis

System design

Coding

Testing

Implementation

Maintenance

- 18 -

Project

helpl

ine.in

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

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

- 19 -

Project

helpl

ine.in

A system analysis is a separation of a substance into parts for study and their

implementation and detailed examination.

Before designing any system it is important that the nature of the business and the way

it currently operates are clearly understood. The detailed examination provides the

specific data required during designing in order to ensure that all the client's

requirements are fulfilled. The investigation or the study conducted during the analysis

phase is largely based on the feasibility study. Rather it would not be wrong to say that

the analysis and feasibility phases overlap. High-level analysis begins during the

feasibility study. Though analysis is represented as one phase of the system

development life cycle (SDLC), this is not true. Analysis begins with system

initialization and continues until its maintenance. Even after successful implementation

of the system, analysis may play its role for periodic maintenance and up gradation of

the system.

One of the main causes of project failures is inadequate understanding, and one of the

main causes of inadequate understanding of the requirements is the poor planning of

system analysis.

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

questions:

What type of information is required?

What are the constraints on the investigation?

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

Keeping the above questions in mind and considering the survey conducted to

determine the need of the system, the total system was deigned and can be described as

under:

- 20 -

Project

helpl

ine.in

The three major parts of the system are:

Providing Information: The system is effectively used to provide large variety of information to the interested

customer. The major purpose of the site is to easily provide access to records of various

automobile such as car with quick update to latest modifications in the records. This

thing is not at all possible in printed material, which are updated only once a few weeks.

It also gives information about the general usage of the system for first time visitors.

The system itself works as a information provider for automobile organization.

- 21 -

Project

helpl

ine.in

2.3 FEASIBILITY STUDY The feasibility study proposes one or more conceptual solution to the problem set of the

project. In fact, it is an evaluation of whether it is worthwhile to proceed with project or

not.

Feasibility analysis usually considers a number of project alternatives, one that is chosen

as the most satisfactory solution. These alternatives also need to be evaluated in a broad

way without committing too many resources. Various steps involved in feasibility

analysis are:

1. To propose a set of solution that can realize the project goal. These solutions are

usually descriptions of what the new system should look like.

2. Evaluation of feasibility of such solutions. Such evaluation often indicates

shortcomings in the initial goals. This step is repeated as the goals are adjusted and

the alternative solutions are evaluated.

Steps in feasibility Analysis are: 1. Identify deficiency by pinpointing, missing functions, unsatisfactory performance,

Excessive cost of operations. 2. Set goals to remove these deficiencies.

3. Goals must be quantified, realizable within the constraints of an organization, broken

down into sub goals agreeable to all concerned.

4. Set goals not only to remove deficiencies but also to effectively meet competition.

For instance, goals must be based on what competitors do.

- 22 -

Project

helpl

ine.in

2.4 ECONOMIC FEASIBILITY

Economic analysis is the most frequently used technique for evaluating the

effectiveness of a proposed system. More commonly known as cost / benefit analysis; in

this procedure we determine the benefits and savings that are expected from a proposed

system and compare them with costs. We found the benefits outweigh the costs; we take

a decision to design and implement the new proposed system.

During the feasibility phase, broad alternatives solutions are examined. For each

alternate solution the cost and benefits have to be examined before designing one of the

alternatives.

Broad solutions will consist of:

1. Specifications of information to be made available by the system.

2. Description of what will be done manually and what the computer will do.

3. Specification of new computing equipment needed or specification of expansion of

an existing computer.

COST AND BENEFIT ANALYSIS

Developing an IT application is an investment. Since after developing that application it

provides the organization with profits. Profits can be monetary or in the form of an

improved working environment. However, it carries risks, because in some cases an

estimate can be wrong. And the project might not actually turn out to be beneficial.

Cost benefit analysis helps to give management a picture of the cost, benefits and risks. It

usually involves comparing alternate investments.

Cost benefit determines the benefits and savings that are expected from the system and

compares them with the expected costs.

In performing cost and benefit analysis it is important to identify cost and benefits factors.

Cost and benefits can be categorized into the following categories:

- 23 -

Project

helpl

ine.in

1. Development Costs – Development costs is the costs that are incurred during the

development of the system. It is one time investment.

2. Operating Costs – Operating Costs are the expenses required for the day to day

running of the system. Examples of Operating Costs are Wages, Supplies and

Overheads.

3. Hardware/Software Costs – It includes the cost of purchasing or leasing of

computers and it’s peripherals. Software costs involves required S/W costs.

4. Personnel Costs – It is the money spent on the people involved in the development of

the system.

5. Facility Costs – Expenses that are incurred during the preparation of the physical site

where the system will be operational. These can be wiring, flooring, acoustics,

lightning, and air-conditioning.

6. Supply Costs – These are variable costs that are very proportionately with the amount

of use of paper, ribbons, disks, and the like.

BENEFITS

We can define benefits as

Profit or Benefit = Income – Costs

Benefits can be accrued by:

Increasing income, or

Decreasing costs, or

Both

- 24 -

Project

helpl

ine.in

2.5 TECHNICAL FEASIBILITY

Today, very little is technically impossible. Consequently, technical feasibility looks at

what is practical and reasonable. Technical feasibility addresses three major issues:

1. Is the proposed technology or solution practical?

2. Do we currently possess the necessary technology?

3. Do we possess the necessary technical expertise, and is the schedule reasonable?

Is the Proposed Technology or Solution Practical?

The technology for any defined solution is normally available. The question whether that

technology is mature enough to be easily applied to our problems. Some firms like to use

state-of-the-are technology, but most firms prefer to use mature and proven technology. A

mature technology has a larger customer base for obtaining advice concerning problems

and improvements.

Do We Currently Possess the Necessary Technology? Assuming the solution's required technology is practical, we must next ask ourselves, is the

technology available in our information systems shop? If the technology is available, we

must ask if we have the capacity. For instance, will our current printer be able to handle the

new reports and forms required of a new system?

If the answer to any of these questions is no, then we must ask ourselves, Can we get this

technology? The technology may be practical and available, and, yes, we need it. But we

simply may not be able to afford it at this time. Although this argument borders on

economic feasibility, it is truly technical feasibility. If we can't afford the technology, then

the alternative that requires the technology is not practical and is technically infeasible!

- 25 -

Project

helpl

ine.in

- 26 -

Project

helpl

ine.in

3.1 IMPORTANCE OF COMPUTERIZED BANQUET HALL BOOKING

There are several attributes in which the computer based information works. Broadly

the working of computer system is divided into two main groups:

♦ Transaction System

♦ Decision Support System

Transaction System: A transaction is a record of some well-defined single and usually small occurrence in

a system. Transactions are input into the computer to update the database files. It

checks the entering data for its accuracy. This means that numeric data appears in

numeric field and character data in character field. Once all the checks are made,

transaction is used to update the database. Transaction can be inputted in on-line

mode or batch mode. In on-line mode, transactions are entered and updated into the

database almost instantaneously. In batch mode, transactions are collected into

batches, which may be held for a while and inputted later.

Decision Support System: It assists the user to make analytical decision. It shows the various data in organized

way called analysis. This analysis can be made to syrdy preferences and help in

making decisions.

Computer system works out best with record maintenance. It will tell you which

customer would get how much pending/reports statements. It will also help to search

the information about a particular person by simply entering his telephone number.

User can store information as per requirement, which can be used for comparison with

other reports.

- 27 -

Project

helpl

ine.in

3.2 PRINCIPLES OF SYSTEM ANALYSIS

Principles:

1. Understand the problem before you begin to create the analysis model.

2. Develop prototypes that enable a user to understand how human machine

interaction will occur.

3. Record the origin of and the reason for every requirement.

4. Use multiple views of requirements like building data, function and behavioral

models.

5. Work to eliminate ambiguity. A Complete Structure:

The limited time and resources have restricted us to incorporate, in this project, only the

main activities that are performed in news sites, but utmost care has been taken to make

the system efficient and user friendly.

For the optimum use of practical time it is necessary that every session is planned.

Planning of this project will include the following things:

• Topic Understanding.

• Modular Break – Up of the System.

• Processor Logic for Each Module.

• Database Requirements.

Topic Understanding:

It is vital that the field of application as introduced in the project may be totally a new

field. So as soon as the project was allocated to me, I carefully went through the project to

identify the requirements of the project. Modular Break –Up of the System: Identify The Various Modules In The System.

List Them In The Right Hierarchy.

Identify Their Priority Of Development

Description Of The Modules:

- 28 -

Project

helpl

ine.in

- 29 -

Project

helpl

ine.in

4.1 SYSTEM DESIGN

The design document that we will develop during this phase is the blueprint of the

software. It describes how the solution to the customer problem is to be built. Since

solution to complex problems isn’t usually found in the first try, iterations are most likely

required. This is true for software design as well. For this reason, any design strategy,

design method, or design language must be flexible and must easily accommodate

changes due to iterations in the design. Any technique or design needs to support and

guide the partitioning process in such a way that the resulting sub-problems are as

independent as possible from each other and can be combined easily for the solution to

the overall problem. Sub-problem independence and easy combination of their solutions

reduces the complexity of the problem. This is the objective of the partitioning process.

Partitioning or decomposition during design involves three types of decisions: -

Define the boundaries along which to break;

Determine into how money pieces to break; and

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

start.

Basic design principles that enable the software engineer to navigate the design process

suggest a set of principles for software design, which have been adapted and extended in

the following list:

Free from the suffer from "tunnel vision." A good designer should consider alternative

approaches, judging each based on the requirements of the problem, the resources

available to do the job.

The design should be traceable to the analysis model. Because a single element of the

design model often traces to multiple requirements, it is necessary to have a means for

tracking how requirements have been satisfied by the design model.

The design should not repeat the same thing. Systems are constructed using a set of

design patterns, many of which have likely been encountered before. These patterns

should always be chosen as an alternative to reinvention. Time is short and resources are

- 30 -

Project

helpl

ine.in

limited! Design time should be invested in representing truly new ideas and integrating

those patterns that already exist.

The design should "minimize the intellectual distance" between the software and the

problem as it exists in the real world. That is, the structure of the software design should

(whenever possible) mimic the structure of the problem domain.

The design should exhibit uniformity and integration. A design is uniform if it appears

that one person developed the entire thing. Rules of style and format should be defined

for a design team before design work begins. A design is integrated if care is taken in

defining interfaces between design components.

The design activity begins when the requirements document for the software to be

developed is available. This may be the SRS for the complete system, as is the case if the

waterfall model is being followed or the requirements for the next "iteration" if the

iterative enhancement is being followed or the requirements for the prototype if the

prototyping is being followed. While the requirements specification activity is entirely in

the problem domain, design is the first step in moving from the problem domain toward

the solution domain. Design is essentially the bridge between requirements specification

and the final solution for satisfying the requirements.

The design of a system is essentially a blueprint or a plan for a solution for the system.

We consider a system to be a set of components with clearly defined behavior that

interacts with each other in a fixed defined manner to produce some behavior or services

for its environment. A component of a system can be considered a system, with its own

components. In a software system, a component is a software module.

The design process for software systems, often, has two levels. At the first level, the focus

is on deciding which modules are needed for the system, the specifications of these

modules, and how the modules should be interconnected. This is what is called the system

design or top-level design. In the second level, the internal design of the modules, or how

the specifications of the module can be satisfied, is decided. This design level is often

called detailed design or logic design. Detailed design essentially expands the system

- 31 -

Project

helpl

ine.in

design to contain a more detailed description of the processing logic and data structures

so that the design is sufficiently complete for coding.

Because the detailed design is an extension of system design, the system design controls

the major structural characteristics of the system. The system design has a major impact

on the testability and modifiability of a system, and it impacts its efficiency. Much of the

design effort for designing software is spent creating the system design.

The input to the design phase is the specifications for the system to be designed. Hence,

reasonable entry criteria can be that the specifications are stable and have been approved,

hoping that the approval mechanism will ensure that the specifications are complete,

consistent, unambiguous, etc. The output of the top-level design phase is the architectural

design or the system design for the software system to be built. This can be produced with

or without using a design methodology. Reasonable exit criteria for the phase could be

that the design has been verified against the input specifications and has been evaluated

and approved for quality.

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

design consists of module definitions, with each module supporting a functional

abstraction. In object-oriented design, the modules in the design represent data abstraction

(these abstractions are discussed in more detail later). In the function-oriented methods

for design and describe one particular methodology the structured design methodology in

some detail. In a function- oriented design approach, a system is viewed as a

transformation function, transforming the inputs to the desired outputs. The purpose of

the design phase is to specify the components for this transformation function, so that

each component is also a transformation function. Hence, the basic output of the system

design phase, when a function oriented design approach is being followed, is the

definition of all the major data structures in the system, all the major modules of the

system, and how the modules interact with each other.

Once the designer is satisfied with the design he has produced, the design is to be

precisely specified in the form of a document. To specify the design, specification

languages are used. Producing the design specification is the ultimate objective of the

design phase. The purpose of this design document is quite different from that of the

- 32 -

Project

helpl

ine.in

design notation. Whereas a design represented using the design notation is largely to be

used by the designer, a design specification has to be so precise and complete that it can

be used as a basis of further development by other programmers. Generally, design

specification uses textual structures, with design notation helping in understanding

4.2 DATA MODELING Introduction to data dictionary: Data dictionaries are an integral component of structured analysis, since data flow

diagrams by themselves do not fully describe the subject of the investigation . The

data flow diagrams provide the additional details about the project/system.

Data Dictionary (Definition): A data dictionary is a catalog- a repository- of the elements in a system. These elements

center on the data and the way they are structured to meet user requirements and

organization needs. A data dictionary consists of a list of all the elements composing the

data flowing through a system. The major elements are data flows, data stores , and

processes. The data dictionary stores details and descriptions of these elements.

Admin_Login Table: To store admin login details

Field Type Constraint Data Type Username Char (30) Not null Username Password Char(30) Not null Password Booking Table: To store Booking Details

Field Type Constraint Data Type Member_id Varchar (30) Primary key Member Id Email_id Varchar (70) Not Null Email Id Date_of_book Date Not Null Date of Booking Venue Varchar (100) Not Null Venue Event Varchar (100) Not Null Event Timings Date Time Not Null Timings Contact_no Number (10) Not Null Contact No Queries Varchar (100) Not Null Queries

- 33 -

Project

helpl

ine.in

Community_Hall Table: To store community Hall details

Field Type Constraint Data Type CommHall_id Varchar (10) Primary Key Community Hall

Id CommHall_Name Varchar (50) Not null Community Hall

Name CommHall_address Varchar (50) Not Null Community Hall

Address CommHall _city Varchar (50) Not Null Community Hall

City CommHall_state Varchar (50) Not Null Community Hall

State Contact_Person Varchar (50) Not Null Contact Person Contact No Number (10) Not Null Contact No Facilities Available Varchar (200) Not Null Facilities

Available Member Login Table: To store Member Details

Field Type Constraint Data Type Member_id Varchar (10) Not null Member ID Password Varchar (30) Not null Password Email Varchar (60) Not Null Email Id Booking Status Table

Field Type Constraint Data Type Comm hall_id Varchar (10) Not null Community Hall

Id Status Varchar (30) Not null Status Date_of_booking Varchar (60) Not Null Date of Booking Date_of_event

Facilities_Available Table

Field Type Constraint Data Type Faciliy_name Varchar (10) Not null Facility Facility_details Varchar (30) Not null Details cost Number Not Null Cost

- 34 -

Project

helpl

ine.in

4.3 E-R DIAGRAM

- 35 -

Project

helpl

ine.in

4.4. DATA FLOW DIAGRAM

Context Level DFD for Banquet Hall Booking

Get Booking Details

Perform Bookings and Cancellations

Add Banquet Details

Add Facilities

Get Facilities and Cost Details

Update Database

Check Bookings

Banquet Hall

Booking System

Admin Member

- 36 -

Project

helpl

ine.in

Ist Level DFD for Booking Module

Member_id Email_id

Customer

1.1 Accept the Customer

booking request

1.4 Generate

Bill

Banquet Hall

Booking System

1.2 Authenticate

The Password

Invoice

1.3 Book the Banquet

Accounts Banquet Booking Hall

Customer

- 37 -

Project

helpl

ine.in

Ist Level DFD for Entering the Banquet

ADMIN

2.1 Enter the

Banquet Details

2.2 Validate & Store in the Database

Banquet Hall

Booking System

Banquet

- 38 -

Project

helpl

ine.in

Ist Level DFD For Cancellation Module

Customer

3.1 Accept the Customer

request from user

Banquet Hall

Booking System

3.2 Check the

Validate from Booking Table

Invoice

3.3 Cancel the

booking

Accounts

Cancellation

Booking

- 39 -

Project

helpl

ine.in

Ist Level DFD for Booking Inquiries Form

Customer

4.1 Accept the Customer

request

Banquet Hall

Booking System

4.2 Check the

Database for the require

Booking Status

4.3 Respond to

the customer

Banquet Booking

- 40 -

Project

helpl

ine.in

IInd Level DFD for Login Module

Login Module

USER

5.1 Accept the user

Name & Password

5.2 Authenticate

The Password

Banquet Hall

Booking System

Screen Home

- 41 -

Project

helpl

ine.in

4.5 MODULES

i) Modules & Their Description The Banquet Hall Booking deals with the information System for Banquets Bookings.

This project explains about the booking of banquet halls from a short event to a complete

combination of activities, including meetings, conferences, exhibitions etc. This website

helps any authorized person to book the halls from internet and also shows the availability

of a particular hall at the chosen date and time. The project is divided into different

modules. They are follows:-

a) Administration: This module is divided into different sub-modules, they are:-

⇒ Booking

⇒ Banquets

⇒ Districts, Sectors

⇒ Services

⇒ Reports

⇒ Search

b) Users: This module is specially for Customers:-

⇒ Service Details (DJ, Lightning , Video Recording, Catering)

⇒ Availability

⇒ Booking

Banquet Details: Once the user click on this module he/she will be able to know the

Banquet details along with its mode of services, he also can know these best services by

his past records. This will also inform the customer how flexible mode of

booking/secured/punctual it is.

Password: In this module, this website is for multiple users. If a User enters a password

and the software checks its validity. If the password is valid then option is given to

change the password, otherwise “Invalid User/Password” message is displayed. There is

an option for password recovery, log out, login, new users sign in. The Administrator can

also update changes in the site after login.

- 42 -

Project

helpl

ine.in

Feedback: This module keeps track of all the feedbacks given by the users for future

records.

Reports: This module concerns with various report generation based on the Admin

request. Following types of reports are generated-

• District Details

• Banquet Details

• Booking Status

• Members Details

• Feedback Reports

Service Details: when the user clicks on this module he/she will be informed about the

detailed services the Banquet has. This website also handles various devices bookings

such as an Audio System, DJ, Lightning, Video Recording etc.

Availability: The system also keeps track the information of the booking, whether it is

available at chosen time or not.

.

- 43 -

Project

helpl

ine.in

4.6 PROCESS LOGIC FOR EACH MODULE

Process Logic of Module is a tool that may be useful in planning and evaluating projects.

Our logic model contains four components with Inputs-Outputs-Outcomes being central

to the built in response to the model:

• Situation: The context and need that gives rise to a project or initiative; logic

modules are built in response to an existing situation.

• Inputs: The resources, contributions, and investments that are made in response

to the situation. Inputs lead to Outputs.

• Outputs: The activities, products, methods, and services that reach people and

users. Outputs lead to outcomes.

• Outcomes: The results and benefits for individuals, groups, agencies,

communities and/or systems.

Report Generation

The reports generated by the administrator are:

• Banquet Details

• Booking Status

• Login Details

- 44 -

Project

helpl

ine.in

4.7 TOOLS / PLATFORM, HARDWARE AND SOFTWARE

REQUIREMENT SPECIFICATION

Hardware Interface:-

Hardware Requirements:

Number Description

1 PC with 20GB Hard-Disk and 256 MB RAM

Software Interface

Client on Internet: Window Browser, Operating System (any)

Client on Intranet: Client Software, Window Browser, Operating System (any)

Window Server: Operating System (any)

Data Base Server: SQL database 2005, Operating System (any)

Development End: JAVA with My SQL

Development Environment:-

JAVA: Application Architecture

MY SQL: Database

Rational: Design Tool

Tool :-

NETBEANS

User Interface :-

Java with My SQL

- 45 -

Project

helpl

ine.in

4.8 SCHEDULING Scheduling of a software project does not differ greatly from scheduling of any multi-

task engineering effort. Therefore, generalized project scheduling tools and techniques

can be applied with little modification to software projects.

Program evaluation and review technique (PERT) and critical path method (CPM) are

two project scheduling methods that can be applied to software development. Both

techniques are driven by information already developed in earlier project planning

activities.

Estimates of Effort A decomposition of the product function.

The selection of the appropriate process model and task set.

Decomposition of tasks.

Interdependencies among tasks may be defined using a task network. Tasks, sometimes

called the project Work Breakdown Structure (WBS) are defined for the product as a

whole or for individual functions.

Both PERT and CPM provide quantitative tools that allow the software planner to (1)

determine the critical path-the chain of tasks that determines the duration of the project;

(2) establish "most likely" time estimates for individual tasks by applying statistical

models; and (3) calculate "boundary times" that define a time window" for a particular

task.

Boundary time calculations can be very useful in software project scheduling. Slippage in

the design of one function, for example, can retard further development of other

functions. It describes important boundary times that may be discerned from a PERT or

CPM network: (I) the earliest time that a task can begin when preceding tasks are

completed in the shortest possible time, (2) the latest time for task initiation before the

minimum project completion time is delayed, (3) the earliest finish-the sum of the earliest

start and the task duration, (4) the latest finish- the latest start time added to task duration,

- 46 -

Project

helpl

ine.in

and (5) the total float-the amount of surplus time or leeway allowed in scheduling tasks so

that the network critical path maintained on schedule. Boundary time calculations lead to

a determination of critical path and provide the manager with a quantitative method for

evaluating progress as tasks are completed.

Both PERT and CPM have been implemented in a wide variety of automated tools that

are available for the personal computer. Such tools are easy to use and take the scheduling

methods described previously available to every software project manager.

- 47 -

Project

helpl

ine.in

- 48 -

Project

helpl

ine.in

5.1 SOURCE CODE Main.java

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package hotel; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; /** * * @author Rishi */ public class Mainmenu extends javax.swing.JFrame { Connection con; Statement st; String nm, main; /** * Creates new form Mainmenu */ public Mainmenu() { initComponents(); try { Class.forName("com.mysql.jdbc.Driver");

- 49 -

Project

helpl

ine.in

con=DriverManager.getConnection("jdbc:mysql://localhost:3307/bookingsystem","root","1234"); st=con.createStatement(); } catch(Exception e) { e.printStackTrace(); } } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jMenuBar2 = new javax.swing.JMenuBar(); jMenu3 = new javax.swing.JMenu(); jMenu4 = new javax.swing.JMenu(); jMenuBar3 = new javax.swing.JMenuBar(); jMenu5 = new javax.swing.JMenu(); jMenu6 = new javax.swing.JMenu(); jMenuItem1 = new javax.swing.JMenuItem(); jMenuItem2 = new javax.swing.JMenuItem(); jMenuItem3 = new javax.swing.JMenuItem(); jMenuBar4 = new javax.swing.JMenuBar(); jMenu8 = new javax.swing.JMenu(); jMenu9 = new javax.swing.JMenu(); jLabel3 = new javax.swing.JLabel(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); jMenuBar1 = new javax.swing.JMenuBar(); jMenu1 = new javax.swing.JMenu(); jMenu2 = new javax.swing.JMenu(); jMenuItem4 = new javax.swing.JMenuItem(); jMenuItem5 = new javax.swing.JMenuItem(); jMenuItem7 = new javax.swing.JMenuItem(); jMenu7 = new javax.swing.JMenu(); jMenuItem10 = new javax.swing.JMenuItem(); jMenuItem9 = new javax.swing.JMenuItem(); jMenu10 = new javax.swing.JMenu();

- 50 -

Project

helpl

ine.in

jMenuItem6 = new javax.swing.JMenuItem(); jMenu11 = new javax.swing.JMenu(); jMenuItem8 = new javax.swing.JMenuItem(); jMenu3.setText("File"); jMenuBar2.add(jMenu3); jMenu4.setText("Edit"); jMenuBar2.add(jMenu4); jMenu5.setText("File"); jMenuBar3.add(jMenu5); jMenu6.setText("Edit"); jMenuBar3.add(jMenu6); jMenuItem1.setText("jMenuItem1"); jMenuItem2.setText("jMenuItem2"); jMenuItem3.setText("jMenuItem3"); jMenu8.setText("File"); jMenuBar4.add(jMenu8); jMenu9.setText("Edit"); jMenuBar4.add(jMenu9); jLabel3.setFont(new java.awt.Font("Engravers MT", 1, 24)); // NOI18N jLabel3.setText("Online Booking System"); jLabel1.setFont(new java.awt.Font("DialogInput", 1, 48)); // NOI18N jLabel1.setForeground(new java.awt.Color(102, 51, 255)); jLabel1.setText("ALLSPARK"); jLabel2.setFont(new java.awt.Font("Engravers MT", 1, 24)); // NOI18N jLabel2.setText("Banquet Hall "); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jLabel4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Sample Pictures/1.jpg"))); // NOI18N jLabel5.setFont(new java.awt.Font("DialogInput", 1, 48)); // NOI18N jLabel5.setForeground(new java.awt.Color(153, 153, 0)); jLabel5.setText("ALLSPARK"); jLabel6.setFont(new java.awt.Font("Engravers MT", 1, 24)); // NOI18N jLabel6.setForeground(new java.awt.Color(204, 102, 0)); jLabel6.setText("Banquet Hall ");

- 51 -

Project

helpl

ine.in

jMenuBar1.setForeground(new java.awt.Color(102, 51, 255)); jMenu1.setForeground(new java.awt.Color(153, 0, 255)); jMenu1.setText("Home"); jMenu1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu1ActionPerformed(evt); } }); jMenuBar1.add(jMenu1); jMenu2.setForeground(new java.awt.Color(153, 0, 255)); jMenu2.setText("Customer"); jMenuItem4.setBackground(new java.awt.Color(153, 102, 255)); jMenuItem4.setText("Booking"); jMenuItem4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem4ActionPerformed(evt); } }); jMenu2.add(jMenuItem4); jMenuItem5.setBackground(new java.awt.Color(153, 102, 255)); jMenuItem5.setText("Cancellation"); jMenuItem5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem5ActionPerformed(evt); } }); jMenu2.add(jMenuItem5); jMenuItem7.setBackground(new java.awt.Color(153, 102, 255)); jMenuItem7.setText("Community Halls"); jMenuItem7.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem7ActionPerformed(evt); } }); jMenu2.add(jMenuItem7); jMenuBar1.add(jMenu2); jMenu7.setForeground(new java.awt.Color(153, 0, 255)); jMenu7.setText("Administration"); jMenuItem10.setBackground(new java.awt.Color(153, 102, 255)); jMenuItem10.setText("Admin"); jMenuItem10.addActionListener(new java.awt.event.ActionListener() {

- 52 -

Project

helpl

ine.in

public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem10ActionPerformed(evt); } }); jMenu7.add(jMenuItem10); jMenuItem9.setBackground(new java.awt.Color(153, 102, 255)); jMenuItem9.setText("Community Halls"); jMenuItem9.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem9ActionPerformed(evt); } }); jMenu7.add(jMenuItem9); jMenuBar1.add(jMenu7); jMenu10.setForeground(new java.awt.Color(153, 0, 255)); jMenu10.setText("Contact Us"); jMenu10.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu10ActionPerformed(evt); } }); jMenuItem6.setText("Contact US"); jMenuItem6.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem6ActionPerformed(evt); } }); jMenu10.add(jMenuItem6); jMenuBar1.add(jMenu10); jMenu11.setForeground(new java.awt.Color(153, 0, 255)); jMenu11.setText("Exit"); jMenuItem8.setText("Exit"); jMenuItem8.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem8ActionPerformed(evt); } }); jMenu11.add(jMenuItem8); jMenuBar1.add(jMenu11); setJMenuBar(jMenuBar1);

- 53 -

Project

helpl

ine.in

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(121, 121, 121) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel6) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 9, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 243, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(16, 16, 16))) .addComponent(jLabel4)) .addGap(0, 133, Short.MAX_VALUE)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(24, 24, 24) .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 186, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(70, Short.MAX_VALUE)) ); pack(); }// </editor-fold> private void jMenuItem7ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new CommunityHall().setVisible(true); } private void jMenuItem10ActionPerformed(java.awt.event.ActionEvent evt) {

- 54 -

Project

helpl

ine.in

// TODO add your handling code here: Login p=new Login(); p.setVisible(true); } private void jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: Login p=new Login(); p.setVisible(true); } private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new Mainmenu().setVisible(false); Booking o=new Booking(); o.setVisible(true); } private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new Cancellation().setVisible(true); } private void jMenu1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new Mainmenu().setVisible(true); } private void jMenu10ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new Contactus().setVisible(true); } private void jMenuItem8ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: System.exit(0); }

- 55 -

Project

helpl

ine.in

/** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(Mainmenu.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(Mainmenu.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Mainmenu.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Mainmenu.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new Mainmenu().setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3;

- 56 -

Project

helpl

ine.in

private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JMenu jMenu1; private javax.swing.JMenu jMenu10; private javax.swing.JMenu jMenu11; private javax.swing.JMenu jMenu2; private javax.swing.JMenu jMenu3; private javax.swing.JMenu jMenu4; private javax.swing.JMenu jMenu5; private javax.swing.JMenu jMenu6; private javax.swing.JMenu jMenu7; private javax.swing.JMenu jMenu8; private javax.swing.JMenu jMenu9; private javax.swing.JMenuBar jMenuBar1; private javax.swing.JMenuBar jMenuBar2; private javax.swing.JMenuBar jMenuBar3; private javax.swing.JMenuBar jMenuBar4; private javax.swing.JMenuItem jMenuItem1; private javax.swing.JMenuItem jMenuItem10; private javax.swing.JMenuItem jMenuItem2; private javax.swing.JMenuItem jMenuItem3; private javax.swing.JMenuItem jMenuItem4; private javax.swing.JMenuItem jMenuItem5; private javax.swing.JMenuItem jMenuItem6; private javax.swing.JMenuItem jMenuItem7; private javax.swing.JMenuItem jMenuItem8; private javax.swing.JMenuItem jMenuItem9; // End of variables declaration }

- 57 -

Project

helpl

ine.in

Booking.java

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package hotel; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; /** * * @author Rishi */ public class Booking extends javax.swing.JFrame { Connection con; Statement st; int i=0; String val; String radio; /** * Creates new form CommunityHalls */ public Booking() { initComponents(); buttonGroup1.add(jRadioButton4);

- 58 -

Project

helpl

ine.in

buttonGroup1.add(jRadioButton1); buttonGroup1.add(jRadioButton2); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { buttonGroup1 = new javax.swing.ButtonGroup(); jLabel3 = new javax.swing.JLabel(); jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jLabel1 = new javax.swing.JLabel(); jRadioButton4 = new javax.swing.JRadioButton(); jRadioButton1 = new javax.swing.JRadioButton(); jRadioButton2 = new javax.swing.JRadioButton(); jButton3 = new javax.swing.JButton(); jLabel2 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jButton4 = new javax.swing.JButton(); jLabel12 = new javax.swing.JLabel(); jLabel13 = new javax.swing.JLabel(); jLabel3.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N jLabel3.setForeground(new java.awt.Color(0, 0, 255)); jLabel3.setText("All Apark Booking Center"); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); setBackground(new java.awt.Color(204, 204, 255)); jTable1.setForeground(new java.awt.Color(102, 0, 204)); jTable1.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {null, null, null, null, null, null, null}, {null, null, null, null, null, null, null}, {null, null, null, null, null, null, null}, {null, null, null, null, null, null, null} }, new String [] { "Name", "Address", "City ", "State", "Person", "Contact No.", "Facilities Available" }

- 59 -

Project

helpl

ine.in

)); jTable1.setGridColor(new java.awt.Color(102, 0, 204)); jScrollPane1.setViewportView(jTable1); jButton1.setFont(new java.awt.Font("Arial", 0, 18)); // NOI18N jButton1.setForeground(new java.awt.Color(102, 0, 204)); jButton1.setText("DISPLAY DATA"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jButton2.setFont(new java.awt.Font("Arial", 0, 24)); // NOI18N jButton2.setForeground(new java.awt.Color(102, 0, 204)); jButton2.setText("Proceed"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jLabel1.setFont(new java.awt.Font("Arial", 0, 18)); // NOI18N jLabel1.setForeground(new java.awt.Color(102, 0, 204)); jLabel1.setText(" "); jRadioButton4.setForeground(new java.awt.Color(102, 0, 204)); jRadioButton4.setText("Check This Box For Basement Party"); jRadioButton4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jRadioButton4ActionPerformed(evt); } }); jRadioButton1.setForeground(new java.awt.Color(102, 0, 204)); jRadioButton1.setText("Check This Box For 1st Floor Main Hall Party"); jRadioButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jRadioButton1ActionPerformed(evt); } }); jRadioButton2.setForeground(new java.awt.Color(102, 0, 204)); jRadioButton2.setText("Check This Box For Terrace Garden Party"); jRadioButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jRadioButton2ActionPerformed(evt); } });

- 60 -

Project

helpl

ine.in

jButton3.setFont(new java.awt.Font("Arial", 0, 18)); // NOI18N jButton3.setForeground(new java.awt.Color(102, 0, 204)); jButton3.setText("Home"); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); jLabel2.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jLabel2.setForeground(new java.awt.Color(255, 0, 0)); jLabel4.setFont(new java.awt.Font("Arial", 0, 18)); // NOI18N jLabel4.setForeground(new java.awt.Color(153, 153, 0)); jLabel4.setText("For More Details About Halls And Their Availability"); jButton4.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N jButton4.setForeground(new java.awt.Color(153, 0, 51)); jButton4.setText("Check Here..."); jButton4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton4ActionPerformed(evt); } }); jLabel12.setFont(new java.awt.Font("DialogInput", 1, 48)); // NOI18N jLabel12.setForeground(new java.awt.Color(153, 153, 0)); jLabel12.setText("ALLSPARK"); jLabel13.setFont(new java.awt.Font("Engravers MT", 1, 24)); // NOI18N jLabel13.setForeground(new java.awt.Color(204, 102, 0)); jLabel13.setText("Banquet Hall "); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(1208, 1208, 1208) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 203, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addContainerGap() .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 682, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addGap(265, 265, 265) .addComponent(jButton2) .addGap(67, 67, 67)

- 61 -

Project

helpl

ine.in

.addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 99, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addGap(200, 200, 200) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel1) .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 412, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGroup(layout.createSequentialGroup() .addGap(340, 340, 340) .addComponent(jButton4)) .addGroup(layout.createSequentialGroup() .addGap(318, 318, 318) .addComponent(jLabel13)) .addGroup(layout.createSequentialGroup() .addGap(312, 312, 312) .addComponent(jButton1)) .addGroup(layout.createSequentialGroup() .addGap(332, 332, 332) .addComponent(jLabel12, javax.swing.GroupLayout.PREFERRED_SIZE, 243, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addGap(294, 294, 294) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jRadioButton1) .addComponent(jRadioButton4) .addComponent(jRadioButton2))) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addContainerGap() .addComponent(jLabel12, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel13, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 92, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 11, Short.MAX_VALUE) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jRadioButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)

- 62 -

Project

helpl

ine.in

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jRadioButton1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jRadioButton2) .addGap(6, 6, 6) .addComponent(jLabel2) .addGap(15, 15, 15) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton2) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 40, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(33, 33, 33) .addComponent(jLabel4) .addGap(18, 18, 18) .addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(15, 15, 15) .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 26, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(22, 22, 22)) ); jButton2.getAccessibleContext().setAccessibleName("BOOK"); pack(); }// </editor-fold> private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: DefaultTableModel model = (DefaultTableModel) jTable1.getModel(); // Clear the existing table int rows = model.getRowCount(); if (rows > 0) { for (int i = 0; i < rows; i++) { model.removeRow(0); } } // SQL Query String query = "SELECT * FROM community"; try { // Connect to MySQL database Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3307/bookingsystem","root","1234"); // Create SQL statement and execute query. Statement stmt = con.createStatement();

- 63 -

Project

helpl

ine.in

ResultSet rs = stmt.executeQuery(query); // Iterate through the result and display on screen while (rs.next()) { String name = rs.getString("CommHall_Name"); String add = rs.getString("CommHall_Address"); String city = rs.getString("CommHall_City"); String state = rs.getString("CommHall_State"); String person = rs.getString("CommHall_Person"); String contact = rs.getString("Contact_No."); String facilities = rs.getString("Facilities_Available"); System.out.println(name + "|" + add + "|" + city + "|" + state + "|" +person+ "|" +contact+ "|" +facilities+ "|"); model.addRow(new Object[] {name, add, city, state, person, contact, facilities}); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void jRadioButton4ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: if(jRadioButton1.isSelected()==true) { new Book("1st Floor Main Hall Party").setVisible(true); } else if(jRadioButton2.isSelected()==true) { new Book("Terrace Garden Party").setVisible(true); } else if(jRadioButton4.isSelected()==true) {

- 64 -

Project

helpl

ine.in

new Book("Basement Party").setVisible(true); } else { jLabel2.setText("Please Check a Box"); } } private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new Booking().setVisible(false); Mainmenu c=new Mainmenu(); c.setVisible(true); } private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new CommunityHall().setVisible(true); } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(Booking.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) {

- 65 -

Project

helpl

ine.in

java.util.logging.Logger.getLogger(Booking.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Booking.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Booking.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new Booking().setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.ButtonGroup buttonGroup1; private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JButton jButton4; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel12; private javax.swing.JLabel jLabel13; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JRadioButton jRadioButton1; private javax.swing.JRadioButton jRadioButton2; private javax.swing.JRadioButton jRadioButton4; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JTable jTable1; // End of variables declaration static class obj { } }

- 66 -

Project

helpl

ine.in

Book.java

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package hotel; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; /** * * @author Rishi */ public class Book extends javax.swing.JFrame { Connection con; Statement st; String rec; String b,c,d,e,f,g,h,n,j,k,l,m,p; String hall_type; /** * Creates new form Book */ public Book(String a) { initComponents(); hall_type=a; int meb=100;

- 67 -

Project

helpl

ine.in

try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3307/bookingsystem","root","1234"); st=con.createStatement(); String SQL = "SELECT * FROM booking"; // Connection string for ResultSet - rs. ResultSet rs = st.executeQuery(SQL); while(rs.next()) { meb=Integer.parseInt(rs.getString(1)); } jLabel10.setText(String.valueOf(meb+1)); jLabel11.setText(a); //Chosen Hall is passed from the previous page } catch(Exception e) { jLabel10.setText(String.valueOf("")); } } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jMenuItem1 = new javax.swing.JMenuItem(); jMenuItem2 = new javax.swing.JMenuItem(); jMenuItem3 = new javax.swing.JMenuItem(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); jLabel7 = new javax.swing.JLabel(); jLabel8 = new javax.swing.JLabel(); jLabel9 = new javax.swing.JLabel(); jButton3 = new javax.swing.JButton(); jTextField1 = new javax.swing.JTextField(); jLabel10 = new javax.swing.JLabel(); jTextField2 = new javax.swing.JTextField();

- 68 -

Project

helpl

ine.in

jComboBox1 = new javax.swing.JComboBox(); jComboBox2 = new javax.swing.JComboBox(); jComboBox3 = new javax.swing.JComboBox(); jComboBox4 = new javax.swing.JComboBox(); jComboBox5 = new javax.swing.JComboBox(); jComboBox6 = new javax.swing.JComboBox(); jButton4 = new javax.swing.JButton(); jLabel3 = new javax.swing.JLabel(); jLabel11 = new javax.swing.JLabel(); jLabel12 = new javax.swing.JLabel(); jLabel13 = new javax.swing.JLabel(); jTextField3 = new javax.swing.JTextField(); jLabel14 = new javax.swing.JLabel(); jLabel15 = new javax.swing.JLabel(); jMenuItem1.setText("jMenuItem1"); jMenuItem2.setText("jMenuItem2"); jMenuItem3.setText("jMenuItem3"); jLabel1.setFont(new java.awt.Font("Arial", 0, 18)); // NOI18N jLabel1.setForeground(new java.awt.Color(102, 0, 255)); jLabel1.setText("All Spark Community Hall Online Booking System Welcomes You"); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jLabel2.setFont(new java.awt.Font("Arial", 0, 18)); // NOI18N jLabel2.setForeground(new java.awt.Color(0, 153, 102)); jLabel2.setText("Please Enter Your Details For Booking"); jLabel4.setFont(new java.awt.Font("Times New Roman", 0, 14)); // NOI18N jLabel4.setForeground(new java.awt.Color(102, 0, 255)); jLabel4.setText("Member Id"); jLabel5.setFont(new java.awt.Font("Times New Roman", 0, 14)); // NOI18N jLabel5.setForeground(new java.awt.Color(102, 0, 255)); jLabel5.setText("Email Id"); jLabel6.setFont(new java.awt.Font("Times New Roman", 0, 14)); // NOI18N jLabel6.setForeground(new java.awt.Color(102, 0, 255)); jLabel6.setText("Date Of Booking"); jLabel7.setFont(new java.awt.Font("Times New Roman", 0, 14)); // NOI18N jLabel7.setForeground(new java.awt.Color(102, 0, 255)); jLabel7.setText("Event "); jLabel8.setFont(new java.awt.Font("Times New Roman", 0, 14)); // NOI18N jLabel8.setForeground(new java.awt.Color(102, 0, 255));

- 69 -

Project

helpl

ine.in

jLabel8.setText("Party Timings(Provide Approximately)"); jLabel9.setFont(new java.awt.Font("Times New Roman", 0, 14)); // NOI18N jLabel9.setForeground(new java.awt.Color(102, 0, 255)); jLabel9.setText("Please Write Here For Any Other Queries or Contact Us"); jButton3.setFont(new java.awt.Font("Arial", 0, 14)); // NOI18N jButton3.setForeground(new java.awt.Color(102, 0, 255)); jButton3.setText("Clear All Entries"); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); jTextField1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jTextField1ActionPerformed(evt); } }); jLabel10.setFont(new java.awt.Font("Comic Sans MS", 1, 18)); // NOI18N jTextField2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jTextField2ActionPerformed(evt); } }); jComboBox1.setFont(new java.awt.Font("Arial", 0, 11)); // NOI18N jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "DATE", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", " " })); jComboBox1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jComboBox1ActionPerformed(evt); } }); jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "MONTH", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December", " " })); jComboBox2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jComboBox2ActionPerformed(evt); } });

- 70 -

Project

helpl

ine.in

jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "YEAR", "2014", "2015", "2016", "2017", "2018", "2019", "2020" })); jComboBox4.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "SELECT", "Marriage", "Ring Ceremony", "Bussiness Party", "Kitty Party", "Birthday Party", "Satsang", "Chowki", "Other Party", " " })); jComboBox5.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "TIME", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12" })); jComboBox6.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "am/pm", "pm", "am" })); jButton4.setFont(new java.awt.Font("Arial", 0, 14)); // NOI18N jButton4.setForeground(new java.awt.Color(102, 0, 255)); jButton4.setText("BOOK"); jButton4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton4ActionPerformed(evt); } }); jLabel3.setFont(new java.awt.Font("Times New Roman", 0, 14)); // NOI18N jLabel3.setForeground(new java.awt.Color(102, 0, 255)); jLabel3.setText("Hall Chosen"); jLabel11.setFont(new java.awt.Font("Comic Sans MS", 1, 18)); // NOI18N jLabel12.setFont(new java.awt.Font("Times New Roman", 1, 18)); // NOI18N jLabel12.setForeground(new java.awt.Color(255, 0, 0)); jLabel12.setText(" "); jLabel13.setFont(new java.awt.Font("Times New Roman", 0, 14)); // NOI18N jLabel13.setForeground(new java.awt.Color(102, 0, 255)); jLabel13.setText("Contact Number"); jLabel14.setFont(new java.awt.Font("DialogInput", 1, 48)); // NOI18N jLabel14.setForeground(new java.awt.Color(153, 153, 0)); jLabel14.setText("ALLSPARK"); jLabel15.setFont(new java.awt.Font("Engravers MT", 1, 24)); // NOI18N jLabel15.setForeground(new java.awt.Color(204, 102, 0)); jLabel15.setText("Banquet Hall "); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup()

- 71 -

Project

helpl

ine.in

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(91, 91, 91) .addComponent(jButton4) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jButton3)) .addGroup(layout.createSequentialGroup() .addGap(29, 29, 29) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 511, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addComponent(jLabel14, javax.swing.GroupLayout.PREFERRED_SIZE, 243, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(50, 50, 50)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel6) .addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 46, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 235, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel13, javax.swing.GroupLayout.PREFERRED_SIZE, 151, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(87, 87, 87)) .addGroup(layout.createSequentialGroup()

- 72 -

Project

helpl

ine.in

.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 88, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(234, 234, 234))) .addGroup(layout.createSequentialGroup() .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 96, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(226, 226, 226))) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 84, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel11, javax.swing.GroupLayout.PREFERRED_SIZE, 266, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jComboBox5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jComboBox6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createSequentialGroup() .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jComboBox3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))) .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, 169, javax.swing.GroupLayout.PREFERRED_SIZE)

- 73 -

Project

helpl

ine.in

.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 266, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 96, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jComboBox4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGroup(layout.createSequentialGroup() .addGap(279, 279, 279) .addComponent(jLabel15))) .addComponent(jLabel9, javax.swing.GroupLayout.PREFERRED_SIZE, 327, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel12, javax.swing.GroupLayout.PREFERRED_SIZE, 603, javax.swing.GroupLayout.PREFERRED_SIZE)))) .addContainerGap(315, Short.MAX_VALUE)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addContainerGap() .addComponent(jLabel14, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jLabel15, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(1, 1, 1) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jLabel4, javax.swing.GroupLayout.DEFAULT_SIZE, 23, Short.MAX_VALUE) .addComponent(jLabel10, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jLabel5, javax.swing.GroupLayout.DEFAULT_SIZE, 24, Short.MAX_VALUE) .addComponent(jTextField2))

- 74 -

Project

helpl

ine.in

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 26, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jComboBox3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))) .addGap(7, 7, 7) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 21, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jComboBox4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 24, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jComboBox5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jComboBox6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel3)

- 75 -

Project

helpl

ine.in

.addComponent(jLabel11, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 81, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel13, javax.swing.GroupLayout.PREFERRED_SIZE, 19, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField3)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(jLabel9, javax.swing.GroupLayout.PREFERRED_SIZE, 29, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel12) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE))) .addComponent(jTextField1, javax.swing.GroupLayout.DEFAULT_SIZE, 153, Short.MAX_VALUE)) .addContainerGap()) ); pack(); }// </editor-fold> private void jComboBox2ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: jTextField2.setText(""); jTextField1.setText(""); jComboBox1.setSelectedItem("DATE"); jComboBox2.setSelectedItem("MONTH");

- 76 -

Project

helpl

ine.in

jComboBox3.setSelectedItem("YEAR"); jComboBox4.setSelectedItem("SELECT"); jComboBox5.setSelectedItem("TIME"); jComboBox6.setSelectedItem("am/pm"); } private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: int i=0,t=0; try { b=jLabel10.getText(); c=jTextField2.getText(); d=jComboBox1.getSelectedItem().toString(); e=jComboBox2.getSelectedItem().toString(); f=jComboBox3.getSelectedItem().toString(); g=jComboBox4.getSelectedItem().toString(); h=jComboBox5.getSelectedItem().toString(); n=jComboBox6.getSelectedItem().toString(); j=jLabel11.getText(); p=jTextField3.getText(); k=jTextField1.getText(); l=d+"-"+e+"-"+f; m=h+"-"+n; } catch(Exception e) { } try { ResultSet res=st.executeQuery("select * from booking "); while(res.next()) { if(c.equals(res.getString(2))) { i++;

- 77 -

Project

helpl

ine.in

} if(l.equals(res.getString(3))) { t++; } } }catch(Exception e) { } if(i>0 && t>0) { jLabel12.setText(" Email Id and Date of Booking already Exists"); } else if(i>0 && t==0) { jLabel12.setText(" Email Id already Exists"); } else if(i==0 && t>0) { jLabel12.setText(" Date of Booking already Exists"); } else { try { int ch=0; st.executeQuery("SELECT * FROM booking"); ch=st.executeUpdate("INSERT INTO booking(Member_Id, Email_Id, Date_of_booking, Venue, Event, Timings,Contact_No ,Queries) VALUES ('"+(b)+"','"+(c)+"','"+(l)+"','"+(j)+"','"+(g)+"','"+(m)+"','"+(p)+"','"+(k)+"')"); } catch(Exception e) { } Register d=new Register(b,c,hall_type); //Member id (say b) and emailid (say c) is thrown to the register class d.setVisible(true); } } /** * @param args the command line arguments */

- 78 -

Project

helpl

ine.in

public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(Book.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(Book.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Book.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Book.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new Book("").setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JButton jButton3; private javax.swing.JButton jButton4; private javax.swing.JComboBox jComboBox1; private javax.swing.JComboBox jComboBox2; private javax.swing.JComboBox jComboBox3;

- 79 -

Project

helpl

ine.in

private javax.swing.JComboBox jComboBox4; private javax.swing.JComboBox jComboBox5; private javax.swing.JComboBox jComboBox6; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel10; private javax.swing.JLabel jLabel11; private javax.swing.JLabel jLabel12; private javax.swing.JLabel jLabel13; private javax.swing.JLabel jLabel14; private javax.swing.JLabel jLabel15; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private javax.swing.JLabel jLabel8; private javax.swing.JLabel jLabel9; private javax.swing.JMenuItem jMenuItem1; private javax.swing.JMenuItem jMenuItem2; private javax.swing.JMenuItem jMenuItem3; private javax.swing.JTextField jTextField1; private javax.swing.JTextField jTextField2; private javax.swing.JTextField jTextField3; // End of variables declaration }

- 80 -

Project

helpl

ine.in

Registeration .java

package hotel; import java.sql.*; import javax.swing.JPasswordField; import javax.swing.JOptionPane; /** * * @author Rishi */ public class Register extends javax.swing.JFrame { Connection con; Statement st; String a,b,c,d; String hall; /** * Creates new form CustomerLogin */ public Register(String x,String y, String hall_type) { initComponents(); jTextField1.setText(y); jTextField2.setText(x); hall=hall_type; try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3307/bookingsystem","root","1234"); st=con.createStatement();

- 81 -

Project

helpl

ine.in

} catch(Exception e) { e.printStackTrace(); } } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jTextField3 = new javax.swing.JTextField(); jTextField4 = new javax.swing.JTextField(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); jTextField1 = new javax.swing.JTextField(); jTextField2 = new javax.swing.JTextField(); jButton1 = new javax.swing.JButton(); jLabel7 = new javax.swing.JLabel(); jButton3 = new javax.swing.JButton(); pass = new javax.swing.JPasswordField(); pass1 = new javax.swing.JPasswordField(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jLabel1.setFont(new java.awt.Font("Algerian", 1, 24)); // NOI18N jLabel1.setForeground(new java.awt.Color(0, 0, 204)); jLabel1.setText(" EMAIL ID PROCESS "); jLabel2.setFont(new java.awt.Font("Algerian", 0, 18)); // NOI18N jLabel2.setForeground(new java.awt.Color(0, 0, 204)); jLabel2.setText(" Please Provide a PASSWORD"); jLabel3.setForeground(new java.awt.Color(51, 51, 255)); jLabel3.setText("Email ID"); jLabel4.setForeground(new java.awt.Color(51, 51, 255)); jLabel4.setText("Member Id"); jLabel5.setForeground(new java.awt.Color(51, 51, 255)); jLabel5.setText("Password");

- 82 -

Project

helpl

ine.in

jLabel6.setForeground(new java.awt.Color(51, 51, 255)); jLabel6.setText("Confirm Password"); jTextField1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jTextField1ActionPerformed(evt); } }); jTextField2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jTextField2ActionPerformed(evt); } }); jButton1.setFont(new java.awt.Font("Arial", 0, 18)); // NOI18N jButton1.setForeground(new java.awt.Color(0, 0, 204)); jButton1.setText("SUBMIT"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jLabel7.setForeground(new java.awt.Color(255, 0, 0)); jButton3.setFont(new java.awt.Font("Arial", 0, 18)); // NOI18N jButton3.setForeground(new java.awt.Color(0, 0, 204)); jButton3.setText("HOME"); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, 455, Short.MAX_VALUE) .addGroup(layout.createSequentialGroup() .addContainerGap() .addComponent(jLabel2, javax.swing.GroupLayout.DEFAULT_SIZE, 445, Short.MAX_VALUE)) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

- 83 -

Project

helpl

ine.in

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(layout.createSequentialGroup() .addContainerGap() .addComponent(jButton1) .addGap(41, 41, 41) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 99, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(12, 12, 12)) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup() .addGap(50, 50, 50) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jLabel5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGap(79, 79, 79) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jTextField2, javax.swing.GroupLayout.DEFAULT_SIZE, 131, Short.MAX_VALUE) .addComponent(jTextField1, javax.swing.GroupLayout.DEFAULT_SIZE, 131, Short.MAX_VALUE) .addComponent(pass) .addComponent(pass1)))) .addGroup(layout.createSequentialGroup() .addGap(104, 104, 104) .addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 226, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGap(0, 0, Short.MAX_VALUE)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 51, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

- 84 -

Project

helpl

ine.in

.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(1, 1, 1) .addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 21, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(layout.createSequentialGroup() .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 33, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(pass, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(pass1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton1) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 40, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap(23, Short.MAX_VALUE)) );

- 85 -

Project

helpl

ine.in

jLabel1.getAccessibleContext().setAccessibleName("EMAIL ID PROCESS \n"); pack(); }// </editor-fold> private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: a=jTextField1.getText(); b=jTextField2.getText(); c=new String(pass.getPassword()); d=new String(pass1.getPassword()); int rows,rows1; try { if(c.equals(d)) { rows=st.executeUpdate("INSERT INTO login VALUES ('"+c+"','"+a+"','"+b+"')"); rows1=st.executeUpdate("UPDATE community as c,booking as b SET c.status='Booked',b.status='Booked' where c.CommHall_Name='"+hall+"' and b.Member_Id='"+b+"' and c.CommHall_Name=b.Venue "); if(rows==1 && rows1==1) { JOptionPane.showMessageDialog(this,"You event has been successfully booked "); new ThankYou().setVisible(true); } else { JOptionPane.showMessageDialog(this,"You are successfully regtestered"); } } else { jLabel7.setText("Passwords Do Not Match"); jTextField3.setText(""); jTextField4.setText(""); } }

- 86 -

Project

helpl

ine.in

catch(Exception e) { e.printStackTrace(); } } private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new Booking().setVisible(false); Mainmenu c=new Mainmenu(); c.setVisible(true); } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(Register.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(Register.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Register.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) {

- 87 -

Project

helpl

ine.in

java.util.logging.Logger.getLogger(Register.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new Register("","","").setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JButton jButton1; private javax.swing.JButton jButton3; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private javax.swing.JTextField jTextField1; private javax.swing.JTextField jTextField2; private javax.swing.JTextField jTextField3; private javax.swing.JTextField jTextField4; private javax.swing.JPasswordField pass; private javax.swing.JPasswordField pass1; // End of variables declaration } Cancelation.java /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package hotel; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; /** * * @author Rishi */

- 88 -

Project

helpl

ine.in

public class Cancellation extends javax.swing.JFrame { Connection con; Statement st; String b; /** * Creates new form NewJFrame */ public Cancellation() { initComponents(); try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3307/bookingsystem","root","1234"); st=con.createStatement(); String SQL = "SELECT * FROM booking"; // Connection string for ResultSet - rs. } catch(Exception e) { e.printStackTrace(); } } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jTextField1 = new javax.swing.JTextField(); jLabel3 = new javax.swing.JLabel(); jButton1 = new javax.swing.JButton(); jLabel4 = new javax.swing.JLabel(); jLabel10 = new javax.swing.JLabel(); jLabel11 = new javax.swing.JLabel(); jButton3 = new javax.swing.JButton(); jLabel1.setFont(new java.awt.Font("Arial", 0, 24)); // NOI18N jLabel1.setForeground(new java.awt.Color(102, 0, 204)); jLabel1.setText("PLEASE PROVIDE THE DETAILS FOR YOUR CANCELLATION");

- 89 -

Project

helpl

ine.in

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jLabel2.setFont(new java.awt.Font("Arial", 0, 24)); // NOI18N jLabel2.setForeground(new java.awt.Color(102, 0, 204)); jLabel2.setText("Enter The Email Id or Member Id Which You "); jLabel3.setFont(new java.awt.Font("Arial", 0, 18)); // NOI18N jLabel3.setForeground(new java.awt.Color(102, 0, 204)); jLabel3.setText("Registered With Us"); jButton1.setFont(new java.awt.Font("Arial", 0, 14)); // NOI18N jButton1.setForeground(new java.awt.Color(102, 0, 255)); jButton1.setText("CANCEL BOOKING"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jLabel4.setFont(new java.awt.Font("Comic Sans MS", 1, 18)); // NOI18N jLabel4.setForeground(new java.awt.Color(255, 102, 0)); jLabel10.setFont(new java.awt.Font("DialogInput", 1, 48)); // NOI18N jLabel10.setForeground(new java.awt.Color(153, 153, 0)); jLabel10.setText("ALLSPARK"); jLabel11.setFont(new java.awt.Font("Engravers MT", 1, 24)); // NOI18N jLabel11.setForeground(new java.awt.Color(204, 102, 0)); jLabel11.setText("BANQUET Hall "); jButton3.setFont(new java.awt.Font("Arial", 0, 14)); // NOI18N jButton3.setForeground(new java.awt.Color(102, 0, 255)); jButton3.setText("Home"); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addContainerGap() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup()

- 90 -

Project

helpl

ine.in

.addGap(0, 197, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 155, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel3)) .addGap(320, 320, 320)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addComponent(jLabel2) .addGap(173, 173, 173)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 243, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(264, 264, 264)))) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addComponent(jLabel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addContainerGap()))) .addGroup(layout.createSequentialGroup() .addGap(309, 309, 309) .addComponent(jButton1) .addGap(65, 65, 65) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 99, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(0, 0, Short.MAX_VALUE)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel11) .addGap(254, 254, 254)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(24, 24, 24) .addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

- 91 -

Project

helpl

ine.in

.addComponent(jLabel11, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(28, 28, 28) .addComponent(jLabel2) .addGap(18, 18, 18) .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(32, 32, 32) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 43, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 40, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 37, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(27, 27, 27) .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(20, 20, 20)) ); pack(); }// </editor-fold> private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: int i=0,t=0; try { b=jTextField1.getText(); ResultSet res=st.executeQuery("select * from booking where member_id='"+b+"' or email_id='"+b+"'"); while(res.next()) { i++; } } catch(Exception e) { e.printStackTrace(); } if(i>0) { try { int ch=0;

- 92 -

Project

helpl

ine.in

ch=st.executeUpdate("update booking set status='Cancelled' where Member_Id='"+b+"' or email_id='"+b+"' "); if(ch==1) { jLabel4.setText("Your Booking Has Been Cancelled Thanks For Booking With All Spark Community Hall "); } else { jLabel4.setText("Your Booking Has Not Been Cancelled There Was Some Error "); } } catch(Exception e) { e.printStackTrace(); } } else { jLabel4.setText(" Email Id Or Member Id is Not Registered with Us Please Contact The Community Hall "); } } private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new Booking().setVisible(false); Mainmenu c=new Mainmenu(); c.setVisible(true); } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) {

- 93 -

Project

helpl

ine.in

javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(Cancellation.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(Cancellation.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Cancellation.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Cancellation.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new Cancellation().setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JButton jButton1; private javax.swing.JButton jButton3; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel10; private javax.swing.JLabel jLabel11; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JTextField jTextField1; // End of variables declaration }

- 94 -

Project

helpl

ine.in

Communityhalls.java

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package hotel; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; /** * * @author Rishi */ public class CommunityHall extends javax.swing.JFrame { /** * Creates new form Booking */ public CommunityHall() { initComponents(); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() {

- 95 -

Project

helpl

ine.in

jLabel1 = new javax.swing.JLabel(); jLabel10 = new javax.swing.JLabel(); jLabel11 = new javax.swing.JLabel(); jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jButton3 = new javax.swing.JButton(); jLabel1.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N jLabel1.setForeground(new java.awt.Color(153, 153, 0)); jLabel1.setText("Community Hall"); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jLabel10.setFont(new java.awt.Font("DialogInput", 1, 48)); // NOI18N jLabel10.setForeground(new java.awt.Color(153, 153, 0)); jLabel10.setText("ALLSPARK"); jLabel11.setFont(new java.awt.Font("Engravers MT", 1, 24)); // NOI18N jLabel11.setForeground(new java.awt.Color(204, 102, 0)); jLabel11.setText("Banquet Hall "); jTable1.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {null, null, null, null, null, null, null}, {null, null, null, null, null, null, null}, {null, null, null, null, null, null, null}, {null, null, null, null, null, null, null} }, new String [] { "Hall Name", "Address", "City", "Status", "Facilities Available", "Incharge", "Contact No." } )); jScrollPane1.setViewportView(jTable1); jButton1.setFont(new java.awt.Font("Times New Roman", 0, 18)); // NOI18N jButton1.setForeground(new java.awt.Color(0, 0, 255)); jButton1.setText("View Hall Details"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jButton2.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N jButton2.setForeground(new java.awt.Color(0, 0, 255)); jButton2.setText("Home"); jButton2.addActionListener(new java.awt.event.ActionListener() {

- 96 -

Project

helpl

ine.in

public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jButton3.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N jButton3.setForeground(new java.awt.Color(0, 0, 255)); jButton3.setText("Go For Booking"); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addContainerGap() .addComponent(jScrollPane1) .addContainerGap()) .addGroup(layout.createSequentialGroup() .addGap(182, 182, 182) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 180, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jButton3) .addGap(27, 27, 27) .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(77, Short.MAX_VALUE)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel11) .addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 243, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(219, 219, 219)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(40, 40, 40)

- 97 -

Project

helpl

ine.in

.addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jLabel11, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(41, 41, 41) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 37, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 47, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 47, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(34, 34, 34)) ); pack(); }// </editor-fold> private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: DefaultTableModel model = (DefaultTableModel) jTable1.getModel(); // Clear the existing table int rows = model.getRowCount(); if (rows > 0) { for (int i = 0; i < rows; i++) { model.removeRow(0); } } // SQL Query String query = "SELECT * FROM community"; try { // Connect to MySQL database Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3307/bookingsystem","root","1234"); // Create SQL statement and execute query. Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(query); // Iterate through the result and display on screen while (rs.next()) {

- 98 -

Project

helpl

ine.in

String name = rs.getString("CommHall_Name"); String add = rs.getString("CommHall_Address"); String city = rs.getString("CommHall_City"); String state = rs.getString("CommHall_State"); String person = rs.getString("CommHall_Person"); String contact = rs.getString("Contact_No."); String facilities = rs.getString("Facilities_Available"); String status = rs.getString("status"); System.out.println(name + "|" + add + "|" + city + "|" + state + "|" +person+ "|" +contact+ "|" +facilities+ "|"); model.addRow(new Object[] {name, add, city, status, facilities, person, contact}); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new CommunityHall().setVisible(false); Booking b = new Booking(); b.setVisible(true); } private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new Mainmenu().setVisible(true); } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName());

- 99 -

Project

helpl

ine.in

break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(CommunityHall.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(CommunityHall.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(CommunityHall.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(CommunityHall.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new CommunityHall().setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel10; private javax.swing.JLabel jLabel11; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JTable jTable1; // End of variables declaration }

- 100 -

Project

helpl

ine.in

Admin.java

package hotel; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.awt.event.ActionListener; /** * * @author Rishi */ public class Login extends javax.swing.JFrame { Connection con; Statement st; public Login() { initComponents(); try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3307/bookingsystem","root","1234"); st=con.createStatement(); } catch(Exception e) {

- 101 -

Project

helpl

ine.in

e.printStackTrace(); } } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jLabel4 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); user = new javax.swing.JRadioButton(); admin = new javax.swing.JRadioButton(); jLabel6 = new javax.swing.JLabel(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jTextField1 = new javax.swing.JTextField(); jTextField2 = new javax.swing.JTextField(); jButton1 = new javax.swing.JButton(); jLabel3 = new javax.swing.JLabel(); jLabel8 = new javax.swing.JLabel(); jLabel9 = new javax.swing.JLabel(); jButton2 = new javax.swing.JButton(); jLabel4.setFont(new java.awt.Font("Arial", 1, 24)); // NOI18N jLabel4.setForeground(new java.awt.Color(102, 0, 255)); jLabel4.setText("Community Hall "); jLabel5.setFont(new java.awt.Font("Arial", 0, 24)); // NOI18N jLabel5.setForeground(new java.awt.Color(102, 0, 255)); jLabel5.setText("Online Booking System"); user.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N user.setForeground(new java.awt.Color(153, 153, 0)); user.setText("User"); admin.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N admin.setForeground(new java.awt.Color(153, 153, 0)); admin.setText("Admin"); jLabel6.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N jLabel6.setForeground(new java.awt.Color(102, 0, 255)); jLabel6.setText("Login As:"); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

- 102 -

Project

helpl

ine.in

setBackground(new java.awt.Color(51, 51, 255)); jLabel1.setFont(new java.awt.Font("Arial", 0, 18)); // NOI18N jLabel1.setForeground(new java.awt.Color(102, 0, 255)); jLabel1.setText("Adminname"); jLabel2.setFont(new java.awt.Font("Arial", 0, 18)); // NOI18N jLabel2.setForeground(new java.awt.Color(102, 0, 255)); jLabel2.setText("Password"); jTextField2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jTextField2ActionPerformed(evt); } }); jButton1.setFont(new java.awt.Font("Chiller", 1, 14)); // NOI18N jButton1.setForeground(new java.awt.Color(102, 0, 255)); jButton1.setText("LOGIN"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jLabel3.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jLabel3.setForeground(new java.awt.Color(255, 0, 0)); jLabel8.setFont(new java.awt.Font("DialogInput", 1, 48)); // NOI18N jLabel8.setForeground(new java.awt.Color(153, 153, 0)); jLabel8.setText("ALLSPARK"); jLabel9.setFont(new java.awt.Font("Engravers MT", 1, 24)); // NOI18N jLabel9.setForeground(new java.awt.Color(204, 102, 0)); jLabel9.setText("Banquet Hall "); jButton2.setFont(new java.awt.Font("Comic Sans MS", 1, 14)); // NOI18N jButton2.setForeground(new java.awt.Color(102, 0, 255)); jButton2.setText("Home"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

- 103 -

Project

helpl

ine.in

.addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(216, 216, 216) .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 243, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGap(165, 165, 165) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 306, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createSequentialGroup() .addGap(20, 20, 20) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel2) .addComponent(jLabel1)) .addGap(85, 85, 85) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)))) .addGap(11, 11, 11)) .addComponent(jLabel9, javax.swing.GroupLayout.Alignment.TRAILING)))) .addGroup(layout.createSequentialGroup() .addGap(234, 234, 234) .addComponent(jButton1) .addGap(44, 44, 44) .addComponent(jButton2))) .addContainerGap(153, Short.MAX_VALUE)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup()

- 104 -

Project

helpl

ine.in

.addGap(30, 30, 30) .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(28, 28, 28) .addComponent(jLabel9, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 55, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(8, 8, 8) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel1)) .addGap(5, 5, 5) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel2)) .addGap(53, 53, 53) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap(80, Short.MAX_VALUE)) ); pack(); }// </editor-fold> private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { String name=null,pass=null; name=jTextField1.getText(); pass=jTextField2.getText(); try {

- 105 -

Project

helpl

ine.in

ResultSet res=st.executeQuery("select * from Adminlogin where Username='"+name+"' and Password='"+pass+"'"); int i=0; while(res.next()) { i++; } if(i>0) { new Login().setVisible(false); Admin o=new Admin(); o.setVisible(true); } else { jLabel3.setText("Invalid Adminname or Password"); jTextField1.setText(""); jTextField2.setText(""); } } catch(Exception ett) { ett.printStackTrace(); } } private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new Mainmenu().setVisible(true); } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {

- 106 -

Project

helpl

ine.in

if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(Login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(Login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new Login().setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JRadioButton admin; private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel8; private javax.swing.JLabel jLabel9; private javax.swing.JTextField jTextField1; private javax.swing.JTextField jTextField2; private javax.swing.JRadioButton user; // End of variables declaration }

- 107 -

Project

helpl

ine.in

Contactus.java

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package hotel; /** * * @author Rishi */ public class Contactus extends javax.swing.JFrame { /** * Creates new form Contactus */ public Contactus() { initComponents(); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jLabel2 = new javax.swing.JLabel(); jLabel1 = new javax.swing.JLabel();

- 108 -

Project

helpl

ine.in

jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); jLabel7 = new javax.swing.JLabel(); jLabel8 = new javax.swing.JLabel(); jLabel9 = new javax.swing.JLabel(); jLabel10 = new javax.swing.JLabel(); jLabel11 = new javax.swing.JLabel(); jButton3 = new javax.swing.JButton(); jButton4 = new javax.swing.JButton(); jLabel2.setFont(new java.awt.Font("Engravers MT", 1, 24)); // NOI18N jLabel2.setText("Community Hall "); jLabel1.setFont(new java.awt.Font("DialogInput", 1, 48)); // NOI18N jLabel1.setForeground(new java.awt.Color(102, 51, 255)); jLabel1.setText("ALLSPARK"); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N jLabel3.setForeground(new java.awt.Color(102, 0, 204)); jLabel3.setText("Contact Us At"); jLabel4.setText("All Apark Community Hall"); jLabel5.setText("C-57, The Real Road Cross"); jLabel6.setText("Madam Bikaji Cama Palace"); jLabel7.setText("New Delhi-110063"); jLabel8.setText(" 779795895,898957565"); jLabel9.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N jLabel9.setForeground(new java.awt.Color(153, 0, 153)); jLabel9.setText("Phone No.:"); jLabel10.setFont(new java.awt.Font("DialogInput", 1, 48)); // NOI18N jLabel10.setForeground(new java.awt.Color(153, 153, 0)); jLabel10.setText("ALLSPARK"); jLabel11.setFont(new java.awt.Font("Engravers MT", 1, 24)); // NOI18N jLabel11.setForeground(new java.awt.Color(204, 102, 0)); jLabel11.setText("Community Hall "); jButton3.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N jButton3.setForeground(new java.awt.Color(102, 0, 255)); jButton3.setText("Home");

- 109 -

Project

helpl

ine.in

jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); jButton4.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N jButton4.setForeground(new java.awt.Color(102, 0, 255)); jButton4.setText("EXIT"); jButton4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton4ActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(90, 90, 90) .addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 243, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGroup(layout.createSequentialGroup() .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(layout.createSequentialGroup() .addComponent(jButton3) .addGap(34, 34, 34) .addComponent(jButton4) .addGap(10, 10, 10)) .addGroup(layout.createSequentialGroup() .addComponent(jLabel9) .addGap(18, 18, 18) .addComponent(jLabel8))) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addContainerGap(49, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()

- 110 -

Project

helpl

ine.in

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel6) .addComponent(jLabel5) .addGroup(layout.createSequentialGroup() .addGap(10, 10, 10) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel4) .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)))) .addGap(127, 127, 127)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addComponent(jLabel7) .addGap(149, 149, 149)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addComponent(jLabel11) .addGap(31, 31, 31)))) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jLabel11, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(38, 38, 38) .addComponent(jLabel3) .addGap(13, 13, 13) .addComponent(jLabel4) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel5) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel6) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel7) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel9) .addComponent(jLabel8)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 30, Short.MAX_VALUE)

- 111 -

Project

helpl

ine.in

.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(26, 26, 26)) ); pack(); }// </editor-fold> private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: new Booking().setVisible(false); Mainmenu c=new Mainmenu(); c.setVisible(true); } private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: System.exit(0); } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(Contactus.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) {

- 112 -

Project

helpl

ine.in

java.util.logging.Logger.getLogger(Contactus.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Contactus.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Contactus.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new Contactus().setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JButton jButton3; private javax.swing.JButton jButton4; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel10; private javax.swing.JLabel jLabel11; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private javax.swing.JLabel jLabel8; private javax.swing.JLabel jLabel9; // End of variables declaration }

- 113 -

Project

helpl

ine.in

Thankyou.java /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package hotel; /** * * @author Rishi */ public class ThankYou extends javax.swing.JFrame { /** * Creates new form ThankYou */ public ThankYou() { initComponents(); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jLabel1.setBackground(new java.awt.Color(204, 0, 153)); jLabel1.setFont(new java.awt.Font("Arial", 3, 24)); // NOI18N jLabel1.setForeground(new java.awt.Color(102, 0, 255)); jLabel1.setText(" THANK YOU"); jLabel2.setFont(new java.awt.Font("Arial", 3, 24)); // NOI18N jLabel2.setForeground(new java.awt.Color(102, 0, 255)); jLabel2.setText("FOR BOOKING WITH ALLSPARK"); jButton1.setFont(new java.awt.Font("Arial", 2, 18)); // NOI18N

- 114 -

Project

helpl

ine.in

jButton1.setForeground(new java.awt.Color(102, 0, 255)); jButton1.setText("Home"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jButton2.setFont(new java.awt.Font("Arial", 2, 18)); // NOI18N jButton2.setForeground(new java.awt.Color(102, 0, 255)); jButton2.setText("Exit"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jLabel3.setFont(new java.awt.Font("DialogInput", 1, 48)); // NOI18N jLabel3.setForeground(new java.awt.Color(153, 153, 0)); jLabel3.setText("ALLSPARK"); jLabel4.setFont(new java.awt.Font("Engravers MT", 1, 24)); // NOI18N jLabel4.setForeground(new java.awt.Color(204, 102, 0)); jLabel4.setText("Banquet Hall "); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(0, 35, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addComponent(jLabel4) .addGap(66, 66, 66)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(67, 67, 67) .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 228, javax.swing.GroupLayout.PREFERRED_SIZE))

- 115 -

Project

helpl

ine.in

.addGroup(layout.createSequentialGroup() .addGap(100, 100, 100) .addComponent(jButton1) .addGap(35, 35, 35) .addComponent(jButton2))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 87, javax.swing.GroupLayout.PREFERRED_SIZE)) .addComponent(jLabel2, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 382, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(32, 32, 32)))) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 243, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(82, 82, 82)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(16, 16, 16) .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(28, 28, 28) .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 42, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(37, 37, 37) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 38, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 38, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap(41, Short.MAX_VALUE)) ); pack(); }// </editor-fold> private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

- 116 -

Project

helpl

ine.in

// TODO add your handling code here: new Mainmenu().setVisible(true); } private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: System.exit(0); } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(ThankYou.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(ThankYou.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(ThankYou.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(ThankYou.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */

- 117 -

Project

helpl

ine.in

java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new ThankYou().setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; // End of variables declaration }

- 118 -

Project

helpl

ine.in

5.2 CODE EFFICIENCY Reviewing of Code efficiency for a module is carried out after the module is successfully

compiled and all the syntax errors eliminated. Code efficiency review is extremely cost-

effective strategies for reduction in coding errors in order to produce high quality code.

Normally, two types of efficiency are carried out on the code of a module - code

optimization and code inspection. The procedure and final objective of these two

efficiency techniques are very different as discussed below.

OPTIMIZATION OF CODE

Code optimization is an informal code analysis technique. In this technique, after a

module has been coded, it is successfully compiled and all syntax errors are eliminated.

Some members of the development team are given the code a few days before the

optimization meeting to read and understand the code. Each member selects some test

cases and simulates execution of the code by hand (i.e. trace execution through each

statement and function execution). The main objectives of the optimization are to

discover the algorithmic and logical errors in the code. The members note down their

findings to discuss these in a optimization meeting where the coder of the module is also

present.

Even though a code optimization is an informal analysis technique, several guidelines

have evolved over the years for making this naïve technique more effective and useful. Of

course, these guidelines are based on personal experience, common sense, and several

subjective factors. Therefore are based on personal experience, common sense, and

several subjective factors. Therefore, guidelines should be considered as examples rather

than as rules to be applied dogmatically. Some of these guidelines are the following:

The team performing the code optimization should not be either too big or too small.

Ideally, it should consist of three to seven members.

- 119 -

Project

helpl

ine.in

- 120 -

Project

helpl

ine.in

6.1 TESTING PHASE One of the purposes of the testing is to validate and verify the system. Verification means

checking the system to ensure that it is doing what the function is supposed to do and

Validation means checking to ensure that system is doing what the user wants it to do.

No program or system design is perfect; communication between the user and the

designer is not always complete or clear, and time is usually short. The result is errors and

more errors. Theoretically, a newly designed system should have all the pieces in working

order, but in reality, each piece works independently. Now is the time to put all the pieces

into one system and test it to determine whether it meets the user's requirements. This is

the best chance to detect and correct errors before the system is implemented. The

purpose of system testing is to consider all the likely variations to which it will be

subjected and then push the system to its limits. If we implement the system without

proper testing then it might cause the problems.

1. Communication between the user and the designer.

2. The programmer's ability to generate a code that reflects exactly the system

specification.

3. The time frame for the design.

Theoretically, a new designed system should have all the pieces in working order, but in

reality, each piece works independently. Now is the time to put all the pieces into one

system and test it to determine whether it meets the requirements of the user.

The process of system testing and the steps taken to validate and prepare a system

for final implementation are:

- 121 -

Project

helpl

ine.in

6.2 LEVELS OF TESTING

The different types of testing are as follows:

1. UNIT TESTING: This is the smallest testable unit of a computer system and is normally tested using

the white box testing. The author of the programs usually carries out unit tests.

2. INTEGRATION TESTING:

In integration testing, the different units of the system are integrated together to form the

complete system and this type of testing checks the system as whole to ensure that it is

doing what is supposed to do. The testing of an integrated system can be carried out top-

down, bottom-up, or big-bang. In this type of testing, some parts will be tested with white

box testing and some with black box testing techniques. This type of testing plays very

important role in increasing the systems productivity. We have checked our system by

using the integration testing techniques.

3. SYSTEM TESTING:

A part from testing the system to validate the functionality of software against the

requirements, it is also necessary to test the non-functional aspect of the system. Some

examples of non-functional tools include tests to check performance, data security,

UNIT TESTING

VALIDATION

INTEGRATION

SYSTEM

- 122 -

Project

helpl

ine.in

usability/user friendliness, volume, load/stress that we have used in our project to test the

various modules.

System testing consists of the following steps:

1. Program(s) testing.

2. String testing.

3. System testing.

4. System documentation.

5. User acceptance testing.

4. FIELD TESTING: This is a special type of testing that may be very important in some projects. Here the

system is tested in the actual operational surroundings. The interfaces with other systems

and the real world are checked. This type of testing is very rarely used. So far our project

is concerned; we haven't tested our project using the field testing.

5. ACCEPTANCE TESTING:

After the developer has completed all rounds of testing and he is satisfied with the

system, then the user takes over and re-tests the system from his point of view to judge

whether it is acceptable according to some previously identified criteria. This is almost

always a tricky situation in the project because of the inherent conflict between the

developer and the user. In this project, it is the job of the bookstores to check the system

that whether the made system fulfills the goals or not.

WHY SYSTEM TESTING? Testing is vital to the success of the system. System testing makes a logical assumption

that if all the parts of the system are correct, the goal will be successfully achieved.

Inadequate testing results in two types of problems:

1. The time lag between the cause and the appearance of the problem.

2. The effect of system errors on the files and records within the system.

- 123 -

Project

helpl

ine.in

ACTIVITY NETWORK FOR SYSTEM TESTING

The test plan entails the following activities:

1. Prepare test plan.

2. Specify conditions for user acceptance testing.

3. Prepare test data for program testing.

4. Prepare test data for transaction path testing.

5. Plan user training.

6. Compile/assemble programs.

7. Prepare job performance aids.

8. Prepare operational documents.

PREPARE TEST : A workable test plan must be prepared in accordance with

established design specifications. It includes the following items:

• Outputs expected from the system.

• Criteria for evaluating outputs.

• A volume of test data.

• Procedure for using test data.

• Personnel and training requirements.

SPECIFY CONDITIONS FOR USER ACCEPTANCE TESTING

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

conditions for the test.

PREPARE TEST DATA FOR PROGRAM TESTING

As each program is coded, test data are prepared and documented to ensure that all

aspects of the program are properly tested.

PREPARE TEST DATA FOR TRANSACTION PATH TESTING

This activity develops the data required for testing every condition and transactions to be

introduced into the system. The path of each transaction from origin to destination is

carefully tested reliable results.

- 124 -

Project

helpl

ine.in

PLAN USER TRAINING

User training is designed to prepare the user for testing and converting the system. User

involvement and training take place parallel with programming for three reasons:

• The system group has time available to spend on training while the programs are

being written.

• Initiating a user-training program gives the systems group a clearer image of the

user's interest in the new system.

• A trained user participates more effectively in system testing.

The training plan is followed by preparation of the user training manual and other text

materials.

COMPILE / ASSEMBLE PROGRAMS

All programs have to be compiled / assembled for testing.

PREPARE JOB PERFORMANCE AIDS

In this activity the materials to be used by personnel to run the system are specified and

scheduled. This includes a display of materials.

PREPARE OPERATIONAL DOCUMENTS

During the test plan stage, all operational documents are finalized including copies of the

operational formats required by the candidate system.

SYSTEMS TESTING

The computer department to ensure that the system functions as specified does this testing.

This testing is important to ensure that a working system is handed over to the user for

acceptance testing.

ACCEPTANCE TESTING

The user to ensure that the system functions, as the user actually wanted performs this testing.

With prototyping techniques, this stage becomes very much a formality to check the accuracy

and completeness of processing. The screen layouts and output should already have been

tested during the prototyping phase.

- 125 -

Project

helpl

ine.in

An error in the program code can remain undetected indefinitely. To prevent this from

happening the code was tested at various levels. To successfully test a system, each

condition, and combinations of conditions had to be tested. Each program was tested and

linked to other programs. This unit of program is tested and linked to other units and so

on until the complete system has been tested.

The purpose of testing is to ensure that each program is fully tested. To do so a test plan

had to be created. The test plan consists of a number of test runs such as the valid paths

through the code, and the exception and error handling paths. For each test run there is a

list of conditions tested, the test data used and the result expected. The test plan was then

reviewed to check that each path through the code is tested correctly. It is the

responsibility of the programmer to collect the data that will produce the required test

condition.

- 126 -

Project

helpl

ine.in

6.3 VERIFICATION AND VALIDATION (V&V) The objectives of verification, validity activities are to assess and improve the quality of

the work products generated during development and modification of the software.

Quality depends upon the various attributes like correctness, completeness, consistency,

reliability, usefulness, usability, efficiency and conformance to standards.

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

under: -

Verification: “Are we building the product right?”

Validation: “Are we building the right product?”

Verification activities include proving, testing, and reviews. Validation is the process of

evaluating software at the end of the software development to ensure compliance with the

software requirements. Testing is a common method of validation. Clearly, for high

reliability we need to perform both activities. Together, they are often called V&V

activities.

The major V&V activities for software development are inspection, reviews, and testing

(both static and dynamic). The V&V plan identifies the different V&V tasks for the

different phases and specifies how these tasks contribute to the project V&V goals. The

methods to be used for performing these V&V activities, the responsibilities and

milestones for each of these activities, inputs and outputs for each V&V task, and criteria

for evaluating the outputs are also specified.

The two major V&V approaches are testing and inspections. Testing is an activity that

can be generally performed only on code. It is an important activity and is discussed in

detail in a later chapter. Inspection is a more general activity that can be applied to any

work product, including code. Many of the V&V tasks are such that for them, an

inspection type of activity is the only possible way to perform the tasks (e.g. trace ability

and document evaluation). Due to this, inspections play a significant role in verification.

- 127 -

Project

helpl

ine.in

6.4 TEST CASES

TEST DATA Specifications for

Banquet Hall Booking user

form1

Test Date Programmer name: MANISH

Tested By: Manish Project NAME: Banquet Hall Booking

Username

the fields are required.Can enter only letters, spaces, No numeric & special characters are allowed( Length upto 32 characters)

Password password length

> than 6 alphanumeric

Don't use your Name or ID

Address the fields are required.Can enter only letters, numeric values,spaces, hyphens, and apostrophes, special characters are allowed( Length upto 32 characters)

Email Id @ site extension

the fields are required.Can enter only letters,numeric values,special characters. no spaces are allowed ( Length upto 32 characters)

Security Question Select One Use 4 characters or

more- not case sensitive

Answer

- 128 -

Project

helpl

ine.in

Positive Test cases for Add Agency

T.C ID PRE-CONDITION T.C DESCRIPTION T.C DATA EXPECTED ACTUAL RESULT

1 User should be on https://

BanquetHallBooking And is on UserName Field

Check the functionality of UserName field

Ravi

the fields are required.Can enter only letters, spaces,

No numeric & special characters are allowed(

Length upto 32 characters)

Ok Pass

2

User should be on https://https://

BanquetHallBooking And is on UserName Field

Check the functionality of UserName field

A 2

the fields are required.Can enter only letters, spaces,

No numeric & special characters are allowed(

Length upto 32 characters)

Ok Pass

3

User should be on https://https://

BanquetHallBooking And is on UserName Field

Check the functionality of UserName field

A Ravi

the fields are required.Can enter only letters, spaces,

No numeric & special characters are allowed(

Length upto 32 characters)

Ok Pass

4

User should be on https://BanquetHallBooking

/registration? And is on Password Field

Check the functionality of password text box avhjklhm

Will accept 6 to 32 characters.Capitalisation matters. and don't use

your name ID.

Ok Pass

5

User should be on https://BanquetHallBooking

/registration? And is on Password Field

Check the functionality of password text box 654321

Will accept 6 to 32 characters.Capitalisation matters. and don't use

your name or ID.

Ok Pass

6

User should be on https://BanquetHallBooking

/registration?And is on Password Field

Check the functionality of password text box

2207**

Will accept 6 to 32 characters.Capitalisation matters. and don't use

your name or ID.

Ok Pass

7

User should be on https://BanquetHallBooking

/registration? And is on Password Field

Check the functionality of password text box

Chinnu1312**

Will accept 6 to 32 characters.Capitalisation matters. and don't use

your name or ID.

Ok Pass

8

User should be on https://EXPRESS

DELIVERY,COURIER AND SHIPPING SERVICES SITE And is on Branch Address

Field

Check the functionality of Branch Address field

Nangloi

the fields are required.Can enter only letters, numeric values,spaces, hyphens, and apostrophes, special characters are allowed(

Length upto 32 characters)

Ok Pass

- 129 -

Project

helpl

ine.in

9 User should be on

https://MANAGEMENT And is on address Field

Check the functionality of Address field

477/7 Arya Mohalla

the fields are required.Can enter only letters, numeric values,spaces, hyphens, and apostrophes, special characters are allowed(

Length upto 32 characters)

Ok Pass

10

User should be on https://EXPRESS

DELIVERY,COURIER AND SHIPPING SERVICES SITE And is on Branch Address

Field

Check the functionality of Branch Address field 448/7

the fields are required.Can enter only letters, numeric values,spaces, hyphens, and apostrophes, special characters are allowed(

Length upto 32 characters)

Ok Pass

11

User should be on https:/https://

BanquetHallBooking And is on Email Id Field

Check the functionality of Email Id field

singh.kumar48@gmail.com

the fields are required.Can enter only letters,numeric values,special characters. no spaces are allowed (

Length upto 32 characters)

Ok Pass

12

User should be on https:/https://

BanquetHallBooking And is on Email Id Field

Check the functionality of Email Id field

ravi@gmail.com

the fields are required.Can enter only letters,numeric values,special characters. no spaces are allowed (

Length upto 32 characters)

Ok Pass

13

User should be on https://BanquetHallBooking

/registration? And is on Security Question 2 field

Check the functionality of Security Question

Drop Down List -Select one- Either select one from

drop list or type one Invalid Fail

14

User should be on https://BanquetHallBooking

/registration? And is onAnswer field

Check the functionality of Answer

text box blank Will accept anything.But

not blank Invalid Fail

Negative Test cases for

registration form

T.C ID PRE-CONDITION T.C DESCRIPTION T.C DATA EXPECTED ACTUAL RESULT

1

User should be on https://BanquetHallBooking

/registration?And is on UserName Field

Check the functionality of Name field

A

Will accept only letters, spaces, hyphens, and

apostrophes.Length upto 32 characters. name are

required.

Invalid Fail

2

User should be on https://BanquetHallBooking

/registration? And is on userName Field

Check the functionality of Name field

Akhila's

Will accept only letters, spaces, hyphens, and

apostrophes.Length upto 32 characters. name are

required.

Invalid Fail

3

User should be on https://BanquetHallBooking

/registration?And is on userName Field

Check the functionality of Name field

Satish

Will accept only letters, spaces, hyphens, and

apostrophes.Length upto 32 characters.name are

required.

Invalid Fail

4

User should be on https://BanquetHallBooking

/registration?And is on userName Field

Check the functionality of Name field

'

Will accept only letters, spaces, hyphens, and

apostrophes.Length upto 32 characters. name are

required.

Invalid Fail

- 130 -

Project

helpl

ine.in

5

User should be on https://BanquetHallBooking

/registration? And is on Password Field

Check the functionality of password text box 2#

Will accept 6 to 32 characters.Capitalisation matters. and don't use

your name or ID.

Invalid Fail

6

User should be on https://BanquetHallBooking

/registration? And is on Password Field

Check the functionality of password text box a123

Will accept 6 to 32 characters.Capitalisation matters. and don't use

your name or ID.

Invalid Fail

7

User should be on https://BanquetHallBooking

/registration? And is on Email Field

Check the functionality of ID of sign up option akhila@yahoo.com

Will accept only letters, numbers, underscores, and one dot (.) .The ID

must be available.

Invalid Fail

8

User should be on https://BanquetHallBooking

/registration? And is on Email Field

Check the functionality of ID of sign up option #akhila@yahoo.com

Will accept only letters, numbers, underscores, and one dot (.) .The ID

must be available.

Invalid Fail

9

User should be on https://BanquetHallBooking

/registration? And is on Password Field

Check the functionality of password text box 2#

Will accept 6 to 32 characters.Capitalisation matters. and don't use

your name or ID.

Invalid Fail

10

User should be on https://BanquetHallBooking

/registration? And is on Password Field

Check the functionality of password text box a123

Will accept 6 to 32 characters.Capitalisation matters. and don't use

your name or ID.

Invalid Fail

11

User should be on https://BanquetHallBooking

/registration? And is on Security Question 2 field

Check the functionality of Security Question

Drop Down List -Select one- Either select one from

drop list or type one Invalid Fail

12

User should be on https://BanquetHallBooking

/registration? And is onAnswer field

Check the functionality of Answer

text box blank Will accept anything.But

not blank Invalid Fail

- 131 -

Project

helpl

ine.in

- 132 -

Project

helpl

ine.in

7.1 SYSTEM IMPLEMENTATION MAINTENANCE AND REVIEW

As we know, creating software is one thing and the implementation of the created

software is another. The process of implementing software is much difficult as compared

to the task of creating the project. First we have to implement the software on a small

scale for removing the bugs and other errors in the project and after removing them we

can implement the software on a large scale. Before we think in terms of implementing

the Software on a large basis, we must consider the Hardware requirements.

Whenever we develop software or project a certain hardware and software is being used

by the programmer for developing the project. The hardware and software to be used by

the programmer for developing the project should be such that it would result in the

development of a project, which would satisfy all the basic needs for which the project

has been created by the programmer. The Hardware should be such that cost constraints

of the Client should also be taken into account without affecting the performance.

7.2 HARDWARE EVALUATION FACTORS

When we evaluate computer hardware, we should first investigate specific physical and

performance characteristics for each hardware component to be acquired. These specific

questions must be answered concerning many important factors. These hardware evaluation

factors questions are summarized in the below figure.

Notice that there is much more to evaluating hardware than determining the fastest and

cheapest computing device. For e.g. the question of possible obsolescence must be addressed

by making a technology evaluation. The factor of ergonomics is also very important.

Ergonomics is the science and technology that tries to ensure that computers and other

technologies are "user-friendly", that is safe, comfortable and easy to use. Connectivity is

another important evaluation factor, since so many computer systems are now interconnected

within wide area or local area telecommunications networks.

- 133 -

Project

helpl

ine.in

Hardware Evaluation Factors:-

1) Performance

2) Cost

3) Reliability

4) Availability

5) Compatibility

6) Modularity

7) Technology

8) Ergonomics

9) Connectivity

10) Environmental requirements

11) Software

12) Support

- 134 -

Project

helpl

ine.in

7.3 SOFTWARE EVALUATION FACTORS

Software can be evaluated according to many factors similar to the hardware evaluation.

Thus the factors of performance, cost, reliability, compatibility, modularity, technology,

ergonomics, and support should be used to evaluate proposed software acquisitions. In

addition, however, the software evaluation factors are summarized in below figure. For

e.g. some software packages require too much memory capacity and are notoriously

slow, hard to use, or poorly documented. They are not a good selection for most end

users, even if offered at attractive prices.

Software Evaluation factors:-

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

instructions that does not use much memory capacity or CPU time?

2. FLEXIBILITY: can it handle its processing assignments easily without major

modifications?

3. SECURITY: does it provide control procedures for errors, malfunctions and

improper use?

4. LANGUAGE: do our computer programmers and users write it in a

programming language that is used?

5. DOCUMENTATION: is the s/w well documented? Does it include helpful

user instructions?

6. HARDWARE: does existing hardware have the features required to best use

this software?

7. Other characteristics of hardware such as its performance, what about the cost,

how much is reliable and etc.

- 135 -

Project

helpl

ine.in

7.4 CONVERSION AND TRAINING An important aspect of is to make sure that the new design is implemented to establish

standards. The term implementation has different meanings, ranging form the conversion

of a basic application to a complete replacement of a computer system. Implementation is

used here to mean the process of converting a new or revise system into an operational

one. Conversion is one aspect of implementation. Conversion means changing form one

system to another. The objective is to put the tested system into operation while holding

costs, risks, and personnel irritation to a minimum. It involves creating computer-

compatible files, training the operation staff, and installing terminal and hardware. A

critical aspect of conversion is not disrupting the functioning of the organization.

When a new system is used over and old, existing and running one, there are always

compatibility errors. These errors are caused because of the lack of equipment or

personnel to work the new system. Running any specified system at an organization does

require some or other hardware or, in this case, software requirement as well.

Conversion is one aspect of implementation review & software maintenance. There are three types of implementation:

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

encountered are converting files, training users, creating accurate files and

verifying printouts for integrity.

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

usually a difficult conversion. If not properly planned there can be many

problems. Some large computer systems have taken as long as year to convert.

3. Implementation of a modified application to replace an existing one, using the

same computer. This type of conversion is relatively easy to handle, provided

there are no major changes in the files.

- 136 -

Project

helpl

ine.in

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

First of all the system is a computer based system therefore the person should have good

knowledge about computer and it’s working. He should know how to use software's on

the computer.

For a better usage and working of the software the organization should appoint a person

who has good knowledge of all the required software’s. The organization gets a person

trained through different institutes present in the market. The training should be as per the

above requirements.

- 137 -

Project

helpl

ine.in

8. COST ESTIMATION OF THE PROJECT

Cost in a project is due to the requirements for software, hardware, and human resources.

Hardware resources are computer time, terminal time and memory required for the

project. Software resources include the tools and compilers needed during development.

The bulk of cost of software development is due to human resources needed. Cost

estimates are determined in terms of person-months (PM).

Total No. Of Persons Involved In This Project:

1. Administrator

2. Senior Programmer

3. Junior Programmers

4. On line Users. Since this Project will complete in 4 months COST ESTIMATE: (Salary of Project Manager + Salary of Senior Programmer + 2 * Salary of Junior Programmer) * 2

- 138 -

Project

helpl

ine.in

9. GANTT & PERT CHART GANT CHART

A Gantt chart is a graphical representation of the duration of tasks against the

progression of time. A Gantt chart is a useful tool for planning and scheduling projects

A Gantt chart is a type of bar chart that illustrates a project schedule. Gantt charts

illustrate the start and finish dates of the terminal elements and summary elements of a

project. Terminal elements and summary elements comprise the work breakdown

structure of the project. Some Gantt charts also show the dependency.

Gantt chart is a project scheduling technique. Progress can be represented easily in a

Gantt chart, by coloring each milestone when completed. The project will start in the

month of June and end after 4 months at the end of September.

June July Aug Sep

Paper Composition

Presentation Prep

Presentation

Testing Review

Testing

Planning

Research

Video Development

- 139 -

Project

helpl

ine.in

PERT CHART PERT (Project Evaluation and Review Technique) charts consist of a network of boxes

and arrows. The boxes represent activities and the arrows represent task dependencies.

PERT is a method to analyze the involved tasks in completing a given project, especially

the time needed to complete each task, and identifying the minimum time needed to

complete the total project.

A PERT chart is a project management tool used to schedule, organize, and coordinate

tasks within a project. PERT stands for Program Evaluation Review Technique, a

methodology developed by the U.S. Navy in the 1950s to manage the Polaris submarine

missile program. A similar methodology, the Critical Path Method (CPM) was developed

for project management in the private sector at about the same time. A critical path in a

PERT chart is shown by using thicker arrows.

Steps in the PERT Planning Process

PERT planning involves the following steps:

1. Identify the specific activities and milestones.

2. Determine the proper sequence of the activities.

3. Construct a network diagram.

4. Estimate the time required for each activity.

5. Determine the critical path.

6. Update the PERT chart as the project progresses.

- 140 -

Project

helpl

ine.in

FIGURE B: PERT Chart representation of the Banquet Hall Booking. PERT charts are a more sophisticated form of activity chart. In activity diagrams only the

estimated task durations are represented. Since the actual durations might vary from the

estimated durations, the utility of the activity diagrams is limited.

- 141 -

Project

helpl

ine.in

10. SECURITY AND VALIDATION CHECKS

The security measures have been taken in a bid to make the software full proof in

terms of various activities:-

1. Authorization of the user as well as administrator

2. Input Validations of the forms

3. Output Validations of the result

4. Login timing to maintain the Session management

5. Logout timing of the user

6. Data Security

7. Software Security

8. Hardware Security

9. Illegal copying should be restricted

These are the few measures that are taken into account to meet the security measures

while developing a project for an organization.

- 142 -

Project

helpl

ine.in

11. FUTURE SCOPE & PROPOSED ENHANCEMENT OF THE

PROJECT

DRAWBACKS:

1. No automatic backup facilities available.

2. To run the application Internet Explorer 5.0 and above is required.

3. High bandwidth is required for as the transaction rate is high and third party gateway.

PROPOSED ENHANCEMENT:

1. Data backup facility will be introduced.

2. GIS information system can be implemented for the route search.

3. Graphical richness is required for the more user interactivity.

- 143 -

Project

helpl

ine.in

12. CONCLUSION Banquet Hall Booking has been developed in JAVA, keeping in mind the specifications

of the system.

For designing the system we have used simple data flow diagrams. Overall the project teaches us the essential skills like: Using system analysis and design techniques like data flow diagram in designing the

system.

Understanding the database handling and query processing using My Sql.

- 144 -

Project

helpl

ine.in

13. BIBLIOGRAPHY

BOOKS;

1. Mathew MacDonal Beninning Java 2.0 in My Sql 2005: From Novice to

Professional, First edition Apress Publication – 2006

2. Damon Armstrong: Pro Java 2.0: Website programming, First edition

3. Alison Batter: Sams Teach Yourself SQL database 2005 express in 24 hours, First

edition

4. Joseph Schmuller: Sams Teach Yourself UML in 24 Hours, Third edition

5. Ron, Patton, “ Software Testing”, Second Edition, Pearson

- 145 -

Project

helpl

ine.in

14. GLOSSARY TEXT BOX A text Box control, sometimes called an edit field or edit control, displays information

entered at design time, entered by the user, or assigned to the control in code at run time.

BUTTON

Use a Command Button control to begin, interrupt, or end a process. When chosen, a

Command Button appears pushed in and so is sometimes called a push button.

LIST BOX

A List Box control displays a list of items from which the user can select one or more. If

the number of items exceeds the number that can be displayed, a scroll bar is

automatically added to the List Box control.

LABEL

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

directly.

GROUPBOX

A GROUPBOX control provides an identifiable grouping for controls. You can also use a

Frame to subdivide a form functionally – for example, to separate groups of Option

Button controls.

COMBO BOX

A Combo Box control combines the features of a text box and a list box. This control

allows the user to select an item either by typing text into the combo box, or by selecting

it from the list.

TIMER

- 146 -

Project

helpl

ine.in

A Timer control can execute code at regular intervals by causing a Timer event to occur.

The Timer control, invisible to the user, is useful for background processing.

PICTURE BOX

The primary use for the Picture Box control is to display a picture to the user. The actual

picture that is displayed is determined by the picture property. The picture property

contains the file name (and optional path) for the picture file that you wish to display.

DATA GRID CONTROL

The DATA Grid control displays and operates on tabular data. It allows complete

flexibility to sort, merge, and format tables containing strings and pictures. When bound

to a Data control, MSFlexGrid displays read-only data.

DATE AND TIME PICKER CONTROL

A Date and Time Picker (DTP) Control provides a simple and intuitive interface through

which to exchange data and time information with a user. For example, with a DTP

control you can ask the user to enter a data and then retrieve his or her selection with

ease.

OPTION BUTTON

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

IMAGE CONTROL

Use the Image control to display a graphic. An Image control can display a graphic from

an icon, bitmap or metafile, as well as enhanced metafile, JPEG, or GIF files.

CHECK BOX CONTROL

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

an application to give users true/false or yes/no options. Because check boxes work

independently of each other, a user can select any number of check boxes at the same

time.

- 147 -