A

MAJOR PROJECT
ON
ONLINE HOUSE RENTAL SYSTEM
This is submitted in partial fulfillment of the requirement for the degree

of

MASTER IN COMPUTER APPLICATION

by

Name: Nityashreehari Das

Regd. No.: 2005266084

UNDER THE GUIDANCE OF:

Prajwal Chandra Nayak

DEPARTMENT OF MASTER IN COMPUTER APPLICATION

TRIDENT ACADEMY OF CREATIVE TECHNOLOGY,

BHUBANESWAR
 Master in Computer Application
Trident Academy of Creative Technology

Bonafide certificate

This is to certify that the project report entitled “ONLINE HOUSE RENTAL
SYSTEM” submitted by NITYASHREEHARI DAS (2005266084) to
TRIDENT ACADEMY OF CREATIVE TECHNOLOGY, Bhubaneswar in
partial fulfillment of the requirement for the award of the degree of “MASTER
IN COMPUTER APPLICATION” is a record of bonafide work carried out
by him under the guidance of Prajwal Chandra Nayak. The project fulfills the
requirements as per the regulations of this University. The contents of this
report have not been submitted and will not be submitted either in part or in full,
for the award of any other degree / diploma and the same is certified.

Head of the Department Principal

Internal Examiner External Examiner

 Declaration

I hereby declare that the project report entitled “ONLINE HOUSE RENTAL
SYSTEM” submitted by me to TRIDENT ACADEMY OF CREATIVE
TECHNOLOGY, Bhubaneswar in partial fulfillment of the requirement for
the award of the degree of “MASTER IN COMPUTER APPLICATION” is
a record of bonafide project work carried out by me under the guidance of
PRAJWAL CHANDRA NAYAK. I further declare that the work in this
project has not been submitted and will not be submitted, either in part or in
full, for the award of any other degree / diploma in this or any other Institute /
University.

Place: Signature of the Candidate

Date: Name:
Regn. No:
 Acknowledgement
I am really indebted to Trident Academy of Creative Technology, Bhubaneswar for
providing me an opportunity to undertake this project work as partial fulfillment of the
Master’s Degree in Computer Application (MCA) curriculum.
I would like to express my heartiest gratitude to Prof. Kaustuva Chandra Dev, HOD of
MCA Department Trident Academy of Creative Technology and all the faculties of the
MCA Department for their encouraging support and guidance in carrying out this project.
I would like to express my heartiest gratitude to Prajwal Chandra Nayak for his
encouraging support and guidance in carrying out this project.
I express my sincere thanks to Juvenilia Technology pvt. ltd for permitting me to take
this project work and for their instance of the good programming technique, which helped
us to design and develop a successful Online House Rental System.
Finally, my sincere thanks to my project members my friends, mentor and all well-
wishers for their esteemed guidance, support, valuable suggestions, and constructive
criticism.

With sincere regards,

Nityashreehari Das
2005266084
MCA 4th Semester
 Abstract
Problem Definition:

The house rental issue is one of the elemental parts of society. Nowadays, it
is extremely difficult to find suitable accommodation in city areas if people search for it
physically. On the other hand, the landowner also needs to rent the house. It can be
difficult to find tenants just to hang a lease sign on a building, and as a result, they lose
money. The scopes for this project are identified to make the application development
process easier. The scope will be explained from user aspect of view and system function.

Existing System:
The consumer will face difficulty to find house rental as they does not know the
nearest house that available in Tembila. Some of them that search on certain website will
find the house rental that are far from the workplace and rarely to find the nearest one.
There is different house rental that are owned by different owners and have their own
advantage and disadvantage. It will make the consumer hard to make a wise decision to
choose the best house that suitable with them. As a customer, we want to know the
comparison for each house rental. So that we can make our mind to choose house rental.
Besides that, the consumer needs to ask the resident to help them to find the house rental.
Not all the residents know the house that available, and the owner does not advertise their
house. They only spread mouth to mouth about their rent house to others.

Need Of Proposed System:

In the proposed system all the above drawbacks are released in one single web
application. Web was chosen because it is the most popular platform and more user
friendly.
 CONTENTS
1. INTRODUCTION

INTRODUCTION TO PROJECT
EXISTING SYSTEM & ITS DISADVANTAGES
PROPOSED SYSTEM & ITS ADVANTAGES

2. SYSTEM ANALYSIS

2.1. STUDY OF THE SYSTEM

2.2. INPUT & OUTPUT REPRESENTATION
2.3. PROCESS MODELS USED WITH JUSTIFICATION
2.4. SYSTEM ARCHITECTURE

3. FEASIBILITY STUDY

3.1. TECHNICAL FEASIBILITY

3.2. OPERATIONAL FEASIBILITY
3.3. ECONOMIC FEASIBILITY

4. REQUIREMENT SPECIFICATIONS

4.1. FUNCIONAL REQUIREMENTS

4.2. PERFORMANCE REQUIREMENTS
4.3. SOFTWARE REQUIREMENTS
4.4. HARDWARE REQUIREMENTS
4.4.1. INTRODUCTION TO JAVA
4.4.2. Servlets/JSP
 4.4.3. JDBC
4.4.4. Oracle
4.4.5. HTML
4.4.6. JAVA SCRIPT

5. SYSTEM DESIGN

5.1 . INTRODUCTION
5.2 DATA FLOW DIAGRAMS
5.3 UML DIAGRAMS
5.4 E-R DIAGRAM
5.5 NORMALIZATION
5.6 DATA DICTIONARY
5.7 CODE

6. OUTPUT SCREENS

7. SYSTEM TESTING
7.1 INTRODUCTION TO TESTING
7.2 TESTING STRATEGIES

8. SYSTEM SECURITY

8.1 INTRODUCTION
8.2 SECURITY IN SOFTWARE

9. BIBLIOGRAPHY
1.1. INTRODUCTION & OBJECTIVE

The house rental issue is one of the elemental parts of society. Nowadays, it is extremely
difficult to find suitable accommodation in city areas if people search for it physically.
On the other hand, the land owner also needs to rent the house. It can be difficult to find
tenants just to hang a lease sign on a building, and as a result, they lose money . The
scopes for this project are identified to make the application development process easier.
The scope will be explained from user aspect of view and system function.

1.2. EXISTING SYSTEM

The consumer will face difficulty to find house rental as they does not know the
nearest house that available in Tembila. Some of them that search on certain website will
find the house rental that are far from the workplace and rarely to find the nearest one.
There is different house rental that are owned by different owners and have their own
advantage and disadvantage. It will make the consumer hard to make a wise decision to
choose the best house that suitable with them. As a customer, we want to know the
comparison for each house rental. So that we can make our mind to choose house rental.
Besides that, the consumer needs to ask the resident to help them to find the house rental.
Not all the residents know the house that available and the owner not advertise their
house. They only spread mouth to mouth about their rent house to others.

PROPOSED SYSTEM

In the proposed system all the above drawbacks are released in one single web
application. Web was chosen because it is the most popular platform and more user
friendly.
2.1 STUDY OF THE SYSTEM

To provide flexibility to the users, the interfaces have been developed that are accessible
through a browser. The GUI’S at the top level have been categorized as

1. Administrative user interface

2. The operational or generic user interface

The ‘administrative user interface’ concentrates on the consistent information that is practically,
part of the society activities and which needs proper authentication for the data collection.
These interfaces help the administrators with all the transactional states like Data insertion,
Data deletion and Date updation along with the extensive data search capabilities.

The ‘operational or generic user interface’ helps the end users of the system in transactions
through the existing data and required services. The operational user interface also helps the
ordinary users in managing their own information in a customized manner as per the included
flexibilities
2.2 INPUT & OUTPOUT REPRESENTETION

Input design is a part of overall system design. The main objective during the input design is
as given below:
• To produce a cost-effective method of input.
• To achieve the highest possible level of accuracy.
• To ensure that the input is acceptable and understood by the user.

INPUT STAGES:
The main input stages can be listed as below:
• Data recording
• Data transcription
• Data conversion
• Data verification
• Data control
• Data transmission
• Data validation
 • Data correction

INPUT TYPES:
It is necessary to determine the various types of inputs. Inputs can be categorized as follows:
• External inputs, which are prime inputs for the system.
• Internal inputs, which are user communications with the system.
• Operational, which are computer department’s communications to the system?
• Interactive, which are inputs entered during a dialogue.

INPUT MEDIA:
At this stage choice has to be made about the input media. To conclude about the input
media consideration has to be given to;
• Type of input
• Flexibility of format
• Speed
• Accuracy
• Verification methods
• Rejection rates
• Ease of correction
• Storage and handling requirements
• Security
• Easy to use
• Portability
Keeping in view the above description of the input types and input media, it can be said that
most of the inputs are of the form of internal and interactive. As
Input data is to be the directly keyed in by the user, the keyboard can be considered to be the
most suitable input device.
OUTPUT DESIGN:

In general are:
• External Outputs whose destination is outside the organization.
• Internal Outputs whose destination is with in organization and they are the User’s main
interface with the computer. Outputs from computer systems are required primarily to
communicate the results of processing to users. They are also used to provide a
permanent copy of the results for later consultation. The various types of outputs
• Operational outputs whose use is purely with in the computer department.
• Interface outputs, which involve the user in communicating directly with the system.

OUTPUT DEFINITION
The outputs should be defined in terms of the following points:
▪ Type of the output
▪ Content of the output
▪ Format of the output
▪ Location of the output
▪ Frequency of the output
▪ Volume of the output
▪ Sequence of the output

It is not always desirable to print or display data as it is held on a computer. It should be

decided as which form of the output is the most suitable.

For Example
• Will decimal points need to be inserted
• Should leading zeros be suppressed.

OUTPUT MEDIA:
In the next stage it is to be decided that which medium is the most appropriate for the output.
The main considerations when deciding about the output media are:

• The suitability for the device to the particular application.

• The need for a hard copy.
• The response time required.
 • The location of the users
• The software and hardware available.

Keeping in view the above description the project is to have outputs mainly coming
under the category of internal outputs. The main outputs desired according to the requirement
specification are:

The outputs were needed to be generated as a hard copy and as well as queries to be viewed
on the screen. Keeping in view these outputs, the format for the output is taken from the
outputs, which are currently being obtained after manual processing. The standard printer is to
be used as output media for hard copies.

2.3 PROCESS MODEL USED WITH JUSTIFICATION

SDLC (Spiral Model):

SDLC is nothing but Software Development Life Cycle. It is a standard which is used by
software industry to develop good software.

Stages in SDLC:
 Requirement Gathering
 Analysis
 Designing
  Coding
 Testing
 Maintenance
Requirements Gathering stage:

The requirements gathering process takes as its input the goals identified in the high-level
requirements section of the project plan. Each goal will be refined into a set of one or more
requirements. These requirements define the major functions of the intended application,
define
operational data areas and reference data areas, and define the initial data entities. Major
functions include critical processes to be managed, as well as mission critical inputs, outputs
and reports. A user class hierarchy is developed and associated with these major functions,
data areas, and data entities. Each of these definitions is termed a Requirement.
Requirements are identified by unique requirement identifiers and, at minimum, contain a
requirement title and
textual description.

These requirements are fully described in the primary deliverables for this stage: the
Requirements Document and the Requirements Traceability Matrix (RTM). The requirements
document contains complete descriptions of each requirement, including diagrams and
references to external documents as necessary. Note that detailed listings of database tables
and fields are not included in the requirements document.
The title of each requirement is also placed into the first version of the RTM, along with
the title of each goal from the project plan. The purpose of the RTM is to show that the product
components developed during each stage of the software development lifecycle are formally
connected to the components developed in prior stages.
In the requirements stage, the RTM consists of a list of high-level requirements, or goals,
by title, with a listing of associated requirements for each goal, listed by requirement title. In
this hierarchical listing, the RTM shows that each requirement developed during this stage is
formally linked to a specific product goal. In this format, each requirement can be traced to a
specific product goal, hence the term requirements traceability.
The outputs of the requirements definition stage include the requirements document, the
RTM, and an updated project plan.
 Feasibility study is all about identification of problems in a project.
 No. of staff required to handle a project is represented as Team Formation, in this case
only modules are individual tasks will be assigned to employees who are working for that
project.
 Project Specifications are all about representing of various possible inputs submitting to the
server and corresponding outputs along with reports maintained by administrator
Analysis Stage:

The planning stage establishes a bird's eye view of the intended software product, and
uses this to establish the basic project structure, evaluate feasibility and risks associated with
the project, and describe appropriate management and technical approaches.
The most critical section of the project plan is a listing of high-level product requirements, also
referred to as goals. All of the software product requirements to be developed during the
requirements definition stage flow from one or more of these goals. The minimum information
for each goal consists of a title and textual description, although additional information and
references to external documents may be included. The outputs of the project planning stage
are the configuration management plan, the quality assurance plan, and the project plan and
schedule, with a detailed listing of scheduled activities for the upcoming Requirements stage,
and high level estimates of effort for the out stages.

Designing Stage:

The design stage takes as its initial input the requirements identified in the approved
requirements document. For each requirement, a set of one or more design elements will be
produced as a result of interviews, workshops, and/or prototype efforts. Design elements
describe the desired software features in detail, and generally include functional hierarchy
diagrams, screen layout diagrams, tables of business rules, business process diagrams,
pseudo code, and a complete entity-relationship diagram with a full data dictionary. These
design elements are intended to describe the software in sufficient detail that skilled
programmers may develop the software with minimal additional input.
When the design document is finalized and accepted, the RTM is updated to show that each
design element is formally associated with a specific requirement. The outputs of the design
stage are the design document, an updated RTM, and an updated project plan.

Development (Coding) Stage:

The development stage takes as its primary input the design elements described in the
approved design document. For each design element, a set of one or more software artifacts
will be produced. Software artifacts include but are not limited to menus, dialogs, data
management forms, data reporting formats, and specialized procedures and functions.
Appropriate test cases will be developed for each set of functionally related software artifacts,
and an online help system will be developed to guide users in their interactions with the
software.
 The RTM will be updated to show that each developed artifact is linked to a specific
design element, and that each developed artifact has one or more corresponding test case
items. At this point, the RTM is in its final configuration. The outputs of the development stage
include a fully functional set of software that satisfies the requirements and design elements
previously documented, an online help system that describes the operation of the software, an
implementation map that identifies the primary code entry points for all major system functions,
a test plan that describes the test cases to be used to validate the correctness and
completeness of the software, an updated RTM, and an updated project plan.

Integration & Test Stage:

During the integration and test stage, the software artifacts, online help, and test data are
migrated from the development environment to a separate test environment. At this point, all
test cases are run to verify the correctness and completeness of the software. Successful
execution of the test suite confirms a robust and complete migration capability. During this
stage, reference data is finalized for production use and production users are identified and
linked to their appropriate roles. The final reference data (or links to reference data source
files) and production user list are compiled into the Production Initiation Plan.
 The outputs of the integration and test stage include an integrated set of software, an
online help system, an implementation map, a production initiation plan that describes
reference data and production users, an acceptance plan which contains the final suite of test
cases, and an updated project plan.

 Installation & Acceptance Test:

During the installation and acceptance stage, the software artifacts, online help, and initial
production data are loaded onto the production server. At this point, all test cases are run to
verify the correctness and completeness of the software. Successful execution of the test suite
is a prerequisite to acceptance of the software by the customer.
After customer personnel have verified that the initial production data load is correct and
the test suite has been executed with satisfactory results, the customer formally accepts the
delivery of the software.
 The primary outputs of the installation and acceptance stage include a production
application, a completed acceptance test suite, and a memorandum of customer acceptance of
the software. Finally, the PDR enters the last of the actual labor data into the project schedule
and locks the project as a permanent project record. At this point the PDR "locks" the project
by archiving all software items, the implementation map, the source code, and the
documentation for future reference.
Maintenance:
Outer rectangle represents maintenance of a project, Maintenance team will start with
requirement study, understanding of documentation later employees will be assigned work and
they will under go training on that particular assigned category.
For this life cycle there is no end, it will be continued so on like an umbrella (no ending point to
umbrella sticks).
2.4 SYSTEM ARCHITECTURE
Architecture flow:

Below architecture diagram represents mainly flow of requests from users to database
through servers. In this scenario overall system is designed in three tires separately using
three layers called presentation layer, business logic layer and data link layer. This project was
developed using 3-tire architecture.

Presentation Layer

Request Response
Business Logic
Layer

Data Link
Layer

Data Base
Feasibility Study:

Preliminary investigation examines project feasibility; the likelihood the system will be
useful to the organization. The main objective of the feasibility study is to test the Technical,
Operational and Economical feasibility for adding new modules and debugging old running
system. All systems are feasible if they are given unlimited resources and infinite time. There
are aspects in the feasibility study portion of the preliminary investigation:
• Technical Feasibility
• Operation Feasibility
Economical Feasibility

3.1 TECHNICAL FEASIBILITY

The technical issue usually raised during the feasibility stage of the investigation includes the
following:
• Does the necessary technology exist to do what is suggested?
• Do the proposed equipments have the technical capacity to hold the data required to
use the new system?
• Will the proposed system provide adequate response to inquiries, regardless of the
number or location of users?
• Can the system be upgraded if developed?
Are there technical guarantees of accuracy, reliability, ease of access and data security?

3.2 OPERATIONAL FEASIBILITY

OPERATIONAL FEASIBILITY

User-friendly

Customer will use the forms for their various transactions i.e. for adding new routes,
viewing the routes details. Also the Customer wants the reports to view the various
transactions based on the constraints. Theses forms and reports are generated as user-
friendly to the Client.
 Reliability

The package wills pick-up current transactions on line. Regarding the old transactions,
User will enter them in to the system.

Security

The web server and database server should be protected from hacking, virus etc

Portability

The application will be developed using standard open source software (Except Oracle) like
Java, tomcat web server, Internet Explorer Browser etc these software will work both on
Windows and Linux o/s. Hence portability problems will not arise.

Availability
This software will be available always.

Maintainability

The system called the ewheelz uses the 2-tier architecture. The 1st tier is the GUI, which is
said to be front-end and the 2nd tier is the database, which uses My-Sql, which is the back-
end.
The front-end can be run on different systems (clients). The database will be running at the
server. Users access these forms by using the user-ids and the passwords.

3.3 ECONOMIC FEASILITY

The computerized system takes care of the present existing system’s data flow and
procedures completely and should generate all the reports of the manual system besides a
host of other management reports.

It should be built as a web based application with separate web server and database
server. This is required as the activities are spread through out the organization customer
wants a centralized database. Further some of the linked transactions take place in
different locations.

Open source software like TOMCAT, JAVA, Mysql and Linux is used to minimize the
cost for the Customer.
4.1 FUNCTIONAL REQUIREMENTS SPECIFICATION

This application consists following modules.

1. Admin Module
2. User Module

1. Admin Module:
The ‘administrative user interface’ concentrates on the consistent information that is
practically, part of the society activities and which needs proper authentication for the
data collection. These interfaces help the administrators with all the transactional states
like Data insertion, Data deletion and Date updation along with the extensive data
search capabilities.

2. User Module:
A user can access the application by users credentials . A user can update profile and
Password ,Book a house .

4.2 PERFORMANCE REQUIREMENTS

Performance is measured in terms of the output provided by the application. Requirement

specification plays an important part in the analysis of a system. Only when the requirement
specifications are properly given, it is possible to design a system, which will fit into required
environment. It rests largely with the users of the existing system to give the requirement
specifications because they are the people who finally use the system. This is because the
requirements have to be known during the initial stages so that the system can be designed
according to those requirements. It is very difficult to change the system once it has been
designed and on the other hand designing a system, which does not cater to the requirements
of the user, is of no use.
The requirement specification for any system can be broadly stated as given below:
• The system should be able to interface with the existing system
• The system should be accurate
• The system should be better than the existing system
The existing system is completely dependent on the user to perform all the duties.
4.3 SOFTWARE REQUIREMENTS:
Operating System : Windows
Technology : Java and J2EE
Web Technologies : Html, JavaScript, CSS
IDE : Eclipse
Web Server : Tomcat
Database : MySql8.0
Java Version : J2SDK1.8, Tomcat 9.0

4.4 HARDWARE REQUIREMENTS:

Hardware : Pentium
RAM : 1GB
Additional Tools:

HTML Designing : Dream weaver Tool

Development Tool kit : My Eclipse

4.4.1. INTRODUCTION TO JAVA

About Java:

Initially the language was called as “oak” but it was renamed as “java” in [Link] primary
motivation of this language was the need for a platform-independent(i.e. architecture
neutral)language that could be used to create software to be embedded in various
consumer electronic devices.

Java is a programmer’s language

Java is cohesive and consistent
Except for those constraint imposed by the Internet environment. Java gives the
programmer, full control
Finally Java is to Internet Programming where c was to System Programming.
Importance of Java to the Internet

Java has had a profound effect on the Internet. This is because; java expands the Universe
of objects that can move about freely in Cyberspace. In a network, two categories of
objects are transmitted between the server and the personal computer. They are passive
information and Dynamic active programs. in the areas of Security and probability. But Java
addresses these concerns and by doing so, has opened the door to an exciting new form of
program called the Applet.
Applications and applets. An application is a program that runs on our Computer under
the operating system of that computer. It is more or less like one creating using C or C++
.Java’s ability to create Applets makes it important. An Applet I san application, designed to
be transmitted over the Internet and executed by a Java-compatible web browser. An
applet is a tiny Java program, dynamically downloaded across the network, just like an
image. But the difference is, it is an intelligent program, not just a media file. It can be react
to the user input and dynamically change.
Java Architecture
Java architecture provides a portable, robust, high performing environment for
development. Java provides portability by compiling the byte codes for the Java Virtual
Machine, which is then interpreted on each platform by the run-time environment. Java is a
dynamic system, able to load code when needed from a machine in the same room or
across the planet.
Compilation of code
When you compile the code, the Java compiler creates machine code (called byte code)for
a hypothetical machine called Java Virtual Machine(JVM). The JVM is supposed t executed
the byte code. The JVM is created for the overcoming the issue of probability. The code is
written and compiled for one machine and interpreted on all machines. This machine is
called Java Virtual Machine.

Compiling and interpreting java source code.

 Java
Pc Java interpreter
compiler Byte
code
Source Macintosh Java
code compiler Platform interpreter
indepen macintosh
dent
SPARC Java
Compiler interpreter
(SPARC)

During run-time the Java interpreter tricks the byte code file into thinking that it is running
on a Java Virtual Machine. In reality this could be an Intel Pentium windows 95 or sun
SPARCstation running Solaris or Apple Macintosh running system and all could receive
code from any computer through internet and run the Applets.

Simple:
Java was designed to be easy for the Professional programmer)))
to learn and to use
effectively. If you are an experienced C++ Programmer. Learning Java will oriented
features of C++. Most of the confusing concepts from C++ are either left out of Java or
implemented in a cleaner, more approachable manner. In Java there are a small number of
clearly defined ways to accomplish a given task.

Object oriented
Java was not designed to be source-code compatible with any other language. This
allowed the Java team the freedom to design with a blank state. One outcome of this was a
clean usable, pragmatic approach to objects. The object model in Java is simple and easy
to extend, while simple types, such as integers, are kept as high-performance non-objects.
 Robust
The multi-platform environment of the web places extraordinary demands on a program,
because the program must execute reliably in a variety of systems. The ability to create
robust programs. Was given a high priority in the design of Java. Java is strictly typed
language; it checks your code at compile time and runtime.

Java virtually eliminates the problems of memory management and deal location, which
is completely automatic. In a well-written Java program, all run-time errors can and should
be managed by your program.

4.4.2 Servlets/JSP
INTRODUCTION

A Servlet Is a generic server extension. a Java class that can be loaded

Dynamically to expand the functionality of a [Link] are commonly used with web
servers. Where they can take the place CGI scripts.
A servlet is similar to proprietary server extension, except that it runs inside a Java Virtual
Machine (JVM) on the server, so it is safe and portable
Servlets operate solely within the domain of the server.
Unlike CGI and Fast CGI, which use multiple processes to handle separate program or
separate requests, separate threads within web server process handle all servlets. This
means that servlets are all efficient and scalable.
Servlets are portable; both across operating systems and also across web servers. Java
Servlets offer the best possible platform for web application development.

Servlets are used as replacement for CGI scripts on a web server, they can extend any sort
of server such as a mail server that allows servlets extend its functionality perhaps by
performing a virus scan on all attached documents or handling mail filtering tasks.
Servlets provide a Java-based solution used to address the problems currently associated
with doing server-side programming including inextensible scripting solutions platform-
specific API’s and incomplete interface.
Servlets are objects that conform to a specific interface that can be plugged into a Java-
based server. Servlets are to the server-side what applets are to the server-side what
applets are to the client-side-object byte codes that can be dynamically loaded off the net.
They differ from applets in than they are faceless objects(with out graphics or a GUI
component).They serve as platform independent, dynamically loadable,plugable helper
byte code objects on the server side that can be used to dynamically extend server-side
functionality.
For example, an HTTP servlet can be used to generate dynamic HTML content when
you use servlets to do dynamic content you get the following advantages:

They’re faster and cleaner then CGI scripts

They use a standard API( the servlet API)
They provide all the advantages of Java (run on a variety of servers without needing
to be rewritten)
A t t r a c t i v e n e s s o f S e r v l e t s:
They are many features of servlets that make them easy and attractive to tuse these
include:

Easily configure using the GUI-based Admin tool]

Can be Loaded and Invoked from a local disk or remotely across the network.
Can be linked together or chained, so that on servlet can call another servlet, or
several servlets in sequence.
Can be called dynamically from within HTML, pages using server-side include-
tags.
Are secure-even when downloading across the network, the servlet security
model and servlet and box protect your system from unfriendly behavior.,
Advantages of the servlet API
One of the great advantages of the servlet API is protocol independent. It assumes
nothing about:
The protocol being used to transmit on the net
How it is loaded
The server environment it will be running in
These quantities are important, because it allows the Servlet API to be
embedded in many kinds of servers. There are other advantages to the servelt
API as well These include:
 It’s extensible-you can inherit all your functionality from the base classes made
available to you
It’s simple small, and easy to use.
Features of Servlets:
Servlets are persistent. Servlet are loaded only by the web server and can
maintain services between requests.
Servlets are fast. Since servlets only need to be l\loaded once, they offer much
better performance over their CGI counterparts.
Servlets are platform independent.
Servlets are extensible Java is a robust, object-oriented programming language,
which easily can be extended to suit your needs.
Servlets are secure
Servlets are used with a variety of client.
Servlets are classes and interfaces from tow packages,javax .servlet and
[Link] java. Servlet package contains classes t support generic, protocol-
independent [Link] classes in the [Link] package To and HTTP specific
functionality extend these classes
In Contrast an Http servlet usually does not override the service () [Link] it
overrides doGet() to handle GET requests and doPost() to handle Post requests. An Http
servlet can override either or both of these modules the service() method of HttpServlet
handles the setup and dispatching to all the doXXX() methods. Which is why it usually
should not be overridden
The remainders in the [Link] and [Link] are largely support
classes .The ServletRequest and ServletResponse classes in [Link] provide access
to generic server requests and responses while HttpServletRequest and
HttpServletResponse classes in [Link] provide access to generic server requests
and responses while HttpServletRequest and HttpServletResponse in [Link]
provide access a HTTP requests and responses . The [Link] provide contains
an HttpSession class that provides built-in session tracking functionality and Cookie class
that allows quickly setup and processing HttpCookies.
Loading Servlets:
Servlets can be loaded from their places. From a directory that is on the CLASSPATH. The
CLASSPATH of the JavaWebServer includes service root/classes/, which is where the
system classes reside

From the <SERVICE_ROOT/servlets/[Link] is not in the server’s classpath. A class

loader is used to create servlets form this [Link] servlets can be added-existing
servlets can be recompiled and the server will notice these changes. From a remote
[Link] this a code base like [Link] is required in addtion to the
servlet’s class [Link] to the admin Gui docs on servlet section to see how to set this
up.
Loading Remote Servlets
Remote servlets can be loaded by:

Configuring the admin Tool to setup automatic loading of remote servlets.

Selectiong up server side include tags in .html files
Defining a filter chain Configuration

Invoking Servlets
A servlet invoker is a servlet that invokes the “server” method on a named [Link] the
servlet is not loaded in the server,then the invoker first loades the servlet(either form local
disk or from the network) and the then invokes the “service” [Link] like applets,local
servlets in the server can be identified by just the class [Link] other words, if a servlet
name is not [Link] is treated as local.
A Client can Invoke Servlets in the Following Ways:
The client can ask for a document that is served by the servlet.
The client(browser) can invoke the servlet directly using a URL, once it has been
mapped using the SERVLET ALIASES Section of the admin GUI
The servlet can be invoked through server side include tags.
The servlet can be invoked by placing it in the servlets/directory
The servlet can be invoked by using it in a filter chain
The Servlet Life Cycle:-
The Servlet life cycle is one of the most exciting features of [Link] life cycle is a
powerful hybrid of the life cycles used in CGI programming and lower-level NSAPI and
ISAPI programming.

The servlet life cycle allows servlet engines to address both the performance and resource
problems of CGI and the security concents of low level server API programming.

Servlet life cycle is highly flexible Servers hava significant leeway in how they choose to
support [Link] only hard and fast rule is that a servlet engine must confor to the
following life cycle contact:

Create and initialize the servlets

Handle zero or more service from clients
Destroy the servlet and then garbage Collects it.
It’s perfectly legal for a servlet t be loaded, created an initialzed in its own JVM,only to be
destroyed an dgarbage collected without hancdling any clientrequest or after handling just
one request
The most common and most sensible life cycle implemntations for HTTP servelts are:
Single java virtual machine and astatine persistence.
Init and Destroy:-

Just like Applets servlets can define init() and destroy() methods, A servlets
init(ServiceConfig) method is called by the server immediately after the server constructs
the servlet’s [Link] on the server and its configuration, this can be at any of
these times
When the server states
When the servlet is first requested, just before the service() method is invoked
At the request of the server administrator
In any case, nit() is guaranteed to be called before the servlet handles its first request
The init() method is typically used to perform servlet initialization creating or loading objects
that are used by the servlet in handling of its request. In order to providing a new servlet
any information about itself and its environment, a server has to call a servelts init() method
and pass an object that implement the ServletConfig interface.
This ServletConfig object supplies a servlet with information about its initialization
[Link] parameters are given to the servlets and are not associated with any
single [Link] can specify initial values, such as where a counter should begin
counting, or default values, perhaps a template to use when not specified by the request,
The server calls a servlet’s destroy() method when the servlet is about to be unloaded. In
the destroy() method, a servlet should free any resources it has acquired that will not be
garbage collected. The destroy() method also gives a servlet a chance to write out its
unsaved. cached information or any persistent information that should be read during the
next call to init().
Session Tracking:

HTTP is a stateless protocol, it provides no way for a server to recognize that a sequence
of requests is all from the same client. This causes a problem for application such as
shopping cart applications. Even in chat application server can’t know exactly who’s making
a request of several clients.

The solution for this is for client to introduce itself as it makes each request, Each clients
needs to provide a unique identifier that lets the server identify it, or it needs to give some
information that the server can use to properly handle the request, There are several ways
to send this introductory information with each request Such as:

USER AUTHORIZATION:

One way to perform session tracking is to leverage the information that comes with
User authorization. When a web server restricts access to some of its resources to only
those clients that log in using a recognized username and password. After the client logs in,
the username is available to a servlet through getRemoteUser()
Wean use the username to track the session. Once a user has logged in, the browser
remembers her username and resends the name and password as the user views new
pages on the site. A servlet can identify the user through her username and they’re by
Track her session.
The biggest advantage of using user authorization to perform session tracking is that it’s
easy to implement. Simply tell the protect a set of pages, and use getRemoteUser() to
identify each [Link] advantage is that the technique works even when the user
accesses your site form or exists her browser before coming back.

The biggest disadvantage of user authrization is that it requires each user to register for an
account and then log in in each time the starts visiting your site. Most users will tolerate
registering and lagging in as a necessary evil when they are accessing sensitive
information, but its all overkill for simple session [Link] problem with user
authorization is that a user cannot simultaneously maintain more than one session at the
same site.

Hidden Form Fields:

One way to support anonymous session tracking is to use hidden from fields. As the name
implies, these are fields added to an HTML, form that are not displayed in the client’s
browser, They are sent back to the server when the form that contains them is submitted.

In a sense, hidden form fields define constant variables for a form. To a servlet receiving a
submitted form, there is no difference between a hidden fields and a visible filed.

As more and more information is associated with a clients session . It can become
burdensome to pass it all using hidden form fields. In these situations it’s possible to pass
on just a unique session ID that identifies as particular clients session.

That session ID can be associated with complete information about its session that is
stored on the server.

The advantage of hidden form fields is their ubiquity and support for anonymity. Hidden
fields are supported in all the popular browsers, they demand on special server
requirements, and they can be used with clients that haven’t registered or logged in.

The major disadvantage with this technique, however is that works only for a sequence of
dynamically generated forms, The technique breaks down immediately with static
documents, emailed documents book marked documents and browser shutdowns.

URL Rewriting:

URL rewriting is another way to support anonymous session tracking, With URL
rewriting every local URL the user might click on is dynamically modified. or rewritten, to
include extra, information. The extra information can be in the deform of extra path
information, added parameters, or some custom, [Link] change. Due to the
limited space available in rewriting a URL, the extra information is usually limited to a
unique session.

Each rewriting technique has its own advantage and disadvantage

Using extra path information works on all servers, and it works as a target for forms that
use both the Get and Post methods. It does not work well if the servlet has to use the extra
path information as true path information

The advantages and disadvantages of [Link] closely match those of hidden form
fileds,The major difference is that URL rewriting works for all dynamically created
documents, such as the Help servlet, not just forms. With the right server support, custom
URL rewriting can even work for static documents.

Persistent Cookies:

A fourth technique to perform session tracking involves persistent cookies. A cookie is a bit
of information. sent by a web server to a browser that can later be read back form that
browser. When a browser receives a cookie, it saves the cookie and there after sends the
cookie back to the server each time it accesses a page on that server, subject to certain
rules. Because a cookie’s value can uniquely identify a client, cookies are often used for
session tracking.

Persistent cookies offer an elegant, efficient easy way to implement session tracking.
Cookies provide as automatic an introduction for each request as we could hope for. For
each request, a cookie can automatically provide a client’s session ID or perhaps a list of
clients performance. The ability to customize cookies gives them extra power and
versatility.

The biggest problem with cookies is that browsers don’t always accept cookies sometimes
this is because the browser doesn’t support cookies. More often its because

The browser doesn’t support cookies. More often its because the user has specifically
configured the browser to refuse cookies.
The power of serves:

The power of servlets is nothing but the advantages of servlets over other approaches,
which include portability, power, efficiency, endurance, safety
elegance,integration,extensibility and flexibility.

Portability:

As servlets are written in java and conform to a well defined and widely accepted
[Link] are highly portable across operating systems and across server implementation

We can develop a servlet on a Windows NT machine running the java web server and later
deploy it effortlessly on a high-end UNIX server running apache. With servlets we can really
“write once, serve everywhere”

Servlet portability is not the stumbling block it so often is with applets, for two reasons

First,Servlet portability is not mandatory i.e. servlets has to work only on server machines
that we are using for development and deployment

Second, servlets avoid the most error-prone and inconstancy implemented portion of the
java languages.

Power:

Servlets can harness the full power of the core java. API’s: such as Networking and Url
access, multithreading, image manipulation, data compression, data base connectivity,
internationalization, remote method invocation(RMI) CORBA connectivity, and object
serialization, among others,

Efficiency and Endurance:

Servlet invocation is highly efficient, Once a servlet is loaded it generally remains in the
server’s memory as a single object instance, There after the server invokes the servelt to
handle a request using a simple, light weighted method invocation .Unlike the CGI, there’s
no process to spawn or interpreter to invoke, so the servlet can begin handling the request
almost immediately, Multiple, concurrent requests are handled the request almost
immediately. Multiple, concurrent requests are handled by separate threads, so servlets are
highly scalable.

Servlets in general are enduring objects. Because a servlets stays in the server’s memory
as a single object instance. it automatically maintains its state and can hold onto external
resources, such as database connections.

Safety:

Servlets support safe programming practices on a number of levels.

As they are written in java,servlets inherit the strong type safety of the java language. In
addition, the servlet API is implemented to be type safe. Java’s automatic garbage
collection and lack of pointers mean that servlets are generally safe from memory
management problems like dangling pointers invalid pointer references and memory leaks.

Servlets can handle errors safely, due to java’s exception – handling mechanism. If a
servlet divides by zero or performs some illegal operations, it throws an exception that can
be safely caught and handled by the server.

A server can further protect itself from servlets through the use of java security
manager.A server can execute its servlets under the watch of a strict security manager.

Elegance:

The elegance of the servlet code is striking. Servlet code is clean, object oriented
modular and amazingly simple one reason for this simplicity is the served API itself. Which
includes methods and classes to handle many of the routine chores of servlet development.
Even advanced to operations like cookie handling and session tracking tracking are
abstracted int convenient classes.

Integration:

Servlets are tightly integrated with the server. This integration allows a servlet to
cooperate with the server in two ways . for e.g.: a servlet can use the server to translate file
paths, perform logging, check authorization, perform MIME type mapping and in some
cases even add users to the server’s user database.

Extensibility and Flexibility:

 The servlet API is designed to be easily extensible. As it stands today the API includes
classes that are optimized for HTTP servlets. But later it can be extended and optimized for
another type of servlets. It is also possible that its support for HTTP servlets could be
further enhanced.

Servlets are also quite flexible, Sun also introduced java server pages. which offer a way to
write snippets of servlet code directly with in a static HTML page using syntax similar to
Microsoft’s Active server pages (ASP)

4.4.3 JDBC

What is JDBC?
any relational database. One can write a single program using the JDBC API,and the JDBC
is a Java Api for executing SQL,Statements(As a point of interest JDBC is trademarked
name and is not an acronym; nevertheless,Jdbc is often thought of as standing for Java
Database Connectivity. It consists of a set of classes and interfaces written in the Java
Programming language. JDBC provides a standard API for tool/database developers and
makes it possible to write database applications using a pure Java API

Using JDBC, it is easy to send SQL statements to virtually program will be able to send
SQL. statements to the appropriate database. The Combination of Java and JDBC lets a
programmer writes it once and run it anywhere.

What Does JDBC Do?

Simply put,JDBC makes it possible to do three things

o Establish a connection with a database

o Send SQL statements
o Process the results
o JDBC Driver Types
o The JDBC drivers that we are aware of this time fit into one of four categories
o JDBC-ODBC Bridge plus ODBC driver
o Native-API party-java driver
o JDBC-Net pure java driver
o Native-protocol pure Java driver

An individual database system is accessed via a specific JDBC driver that implements the
[Link] interface. Drivers exist for nearly all-popular RDBMS systems, through few
are available for free. Sun bundles a free JDBC-ODBC bridge driver with the JDK to allow
access to a standard ODBC,data sources, such as a Microsoft Access database, Sun
advises against using the bridge driver for anything other than development and very
limited development.

JDBC drivers are available for most database platforms, from a number of vendors and
in a number of different flavors. There are four driver categories

Type 01-JDBC-ODBC Bridge Driver

Type 01 drivers use a bridge technology to connect a java client to an ODBC database
service. Sun’s JDBC-ODBC bridge is the most common type 01 driver. These drivers
implemented using native code.

Type 02-Native-API party-java Driver

Type 02 drivers wrap a thin layer of java around database-specific native code libraries
for Oracle databases, the native code libraries might be based on the OCI(Oracle call
Interface) libraries, which were originally designed for c/c++ programmers, Because type-
02 drivers are implemented using native code. in some cases they have better performance
than their all-java counter parts. They add an element of risk, however, because a defect in
a driver’s native code section can crash the entire server
 Type 03-Net-Protocol All-Java Driver

Type 03 drivers communicate via a generic network protocol to a piece of custom

middleware. The middleware component might use any type of driver to provide the actual
database access. These drivers are all java, which makes them useful for applet
deployment and safe for servlet deployment

Type-04-native-protocol All-java Driver

Type o4 drivers are the most direct of the lot. Written entirely in java, Type 04 drivers
understand database-specific networking. protocols and can access the database directly
without any additional software

JDBC-ODBC Bridge

If possible use a Pure Java JDBC driver instead of the Bridge and an ODBC driver. This
completely eliminates the client configuration required by [Link] also eliminates the potential
that the Java VM could be corrupted by an error in the native code brought in by the
Bridge(that is, the Bridge native library, the ODBC driver manager library, library, the ODBC
driver library, and the database client library)
WHAT IS The JDBC-ODBE Bridge ?
The JDBC-ODBC Bridge is a Jdbc driver, which implements JDBC operations by translating
them into ODBC operations. To ODBC it appears as a normal application program. The Bridge
is implemented as the [Link] Java package and contains a native library used to
access ODBC. The Bridge is joint development of Intersolv and Java Soft

4.4.4 Oracle

Oracle is a relational database management system, which organizes data in the form of
tables. Oracle is one of many database servers based on RDBMS model, which manages a
seer of data that attends three specific things-data structures, data integrity and data
manipulation.
 With oracle cooperative server technology we can realize the benefits of open, relational
systems for all the applications. Oracle makes efficient use of all systems resources, on all
hardware architecture; to deliver unmatched performance, price performance and scalability.
Any DBMS to be called as RDBMS has to satisfy [Link]’s rules.

Features of Oracle:
Portable
The Oracle RDBMS is available on wide range of platforms ranging from PCs to super
computers and as a multiuser loadable module for Novel NetWare, if you develop application
on system you can run the same application on other systems without any modifications.

Compatible
Oracle commands can be used for communicating with IBM DB2 mainframe RDBMS
that is different from Oracle, which is Oracle compatible with DB2. Oracle RDBMS is a high
performance fault tolerant DBMS, which is specially designed for online transaction processing
and for handling large database applications.

Multithreaded Server Architecture

Oracle adaptable multithreaded server architecture delivers scalable high performance
for very large number of users on all hardware architecture including symmetric
multiprocessors (sumps) and loosely coupled multiprocessors. Performance is achieved by
eliminating CPU, I/O, memory and operating system bottlenecks and by optimizing the Oracle
DBMS server code to eliminate all internal bottlenecks.

Oracle has become the most popular RDBMS in the market because of its ease of use
• Client/server architecture.
• Data independence.
• Ensuring data integrity and data security.
• Managing data concurrency.
 • Parallel processing support for speed up data entry and online transaction processing
used for applications.
• DB procedures, functions and packages.

[Link]’s Rules
These rules are used for valuating a product to be called as relational database
management systems. Out of 12 rules, a RDBMS product should satisfy at least 8 rules + rule
called rule 0 that must be satisfied.

RULE 0: Foundation Rule

For any system to be advertised as, or claimed to be relational DBMS should manage
database with in it self, with out using an external language.

RULE 1: Information Rule

All information in relational database is represented at logical level in only one way as
values in tables.

RULE 2: Guaranteed Access

Each and every data in a relational database is guaranteed to be logically accessibility
by using to a combination of table name, primary key value and column name.

RULE 3: Systematic Treatment of Null Values

Null values are supported for representing missing information and inapplicable
information. They must be handled in systematic way, independent of data types.

RULE 4: Dynamic Online Catalog based Relation Model

The database description is represented at the logical level in the same way as ordinary
data so that authorized users can apply the same relational language to its interrogation as
they do to the regular data.

RULE 5: Comprehensive Data Sub Language

 A relational system may support several languages and various models of terminal use.
However, there must be one language whose statement can express all of the following:
Data Definitions, View Definitions, Data Manipulations, Integrity, Constraints,
Authorization, and transaction boundaries.

RULE 6: View Updating

Any view that is theoretical can be updatable if changes can be made to the tables that
effect the desired changes in the view.

RULE 7: High level Update, Insert and Delete

The capability of handling a base relational or derived relational as a single operand
applies not only retrieval of data also to its insertion, updating, and deletion.

RULE 8: Physical Data Independence

Application program and terminal activities remain logically unimpaired whenever any
changes are made in either storage representation or access method.

RULE 9: Logical Data Independence

Application programs and terminal activities remain logically unimpaired whenever any
changes are made in either storage representation or access methods.

RULE 10: Integrity Independence

Integrity constraints specific to particular database must be definable in the relational
data stored in the catalog, not in application program.

RULE 11: Distributed Independence

Whether or not a system supports database distribution, it must have a data sub-
language that can support distributed databases without changing the application program.
RULE 12: Non Sub-Version
If a relational system has low level language, that low language cannot use to
subversion or bypass the integrity rules and constraints expressed in the higher level relational
language.

Oracle supports the following Codd’s Rules

Rule 1: Information Rule (Representation of information)-YES.
Rule 2: Guaranteed Access-YES.
Rule 3: Systematic treatment of Null values-YES.
Rule 4: Dynamic on-line catalog-based Relational Model-YES.
Rule 5: Comprehensive data sub language-YES.
Rule 6: View Updating-PARTIAL.
Rule 7: High-level Update, Insert and Delete-YES.
Rule 8: Physical data Independence-PARTIAL.
Rule 9: Logical data Independence-PARTIAL.
Rule 10: Integrity Independence-PARTIAL.
Rule 11: Distributed Independence-YES.
Rule 12: Non-subversion-YES.

4.4.5 HTML

Hypertext Markup Language (HTML), the languages of the world wide web(WWW),
allows users to produces web pages that included text, graphics and pointer to other web
pages (Hyperlinks).

HTML is not a programming language but it is an application of ISO Standard 8879,

SGML(Standard Generalized Markup Language),but
Specialized to hypertext and adapted to the Web. The idea behind Hypertext one point to
another point. We can navigate through the information based on out interest and
 preference. A markup language is simply a series of items enclosed within the elements
should be displayed.

Hyperlinks are underlined or emphasized works that load to other documents or some
portions of the same document.

Html can be used to display any type of document on the host computer, which can be
geographically at a different location. It is a versatile language and can be used on any
platform or desktop

HTML provides tags(special codes) to make the document look attractive.

HTML provides are not case-sensitive. Using graphics,fonts,different sizes, color, etc.. can
enhance the presentation of the document. Anything
That is not a tag is part of the document itself.

Basic Html Tags:

<!-- --> Specific Comments.
<A>………</A> Creates Hypertext links.
<B>………</B> Creates hypertext links.
<Big>……..</Big> Formats text in large-font
<Body>…….</Body> contains all tags and text in the Html-document
<Center>……</Center> Creates Text
<DD>………..</DD> Definition of a term.
<TABLE>……</TABLE> creates table
<Td>………..</Td> indicates table data in a table.
<Tr>………..</Tr> designates a table row
<Th>……….</Th> creates a heading in a table.

A D V A N T A G E S:-

A HTML document is small and hence easy to send over the [Link] is small
because it does not include formatted information.
HTML is platform independent
HTML tags are not case-sensitive.
4.4.6 JAVA SCRIPT

The Java Script Language

JavaScript is a compact, object-based scripting language for developing client and server
internet applications. Netscape Navigator 2.0 interprets JavaScript statements embedded
directly in an HTML page. and Livewire enables you to create server-based applications
similar to common gateway interface(cgi) programs.

In a client application for Navigator, JavaScript statements embedded in an HTML Page

can recognize and respond to user events such as mouse clicks form
Input, and page navigation.
For example, you can write a JavaScript function to verify that users enter valid information
into a form requesting a telephone number or zip code. Without any network transmission, an
Html page with embedded Java Script can interpret the entered text and alert the user with a
message dialog if the input is invalid or you can use JavaScript to perform an action (such as
play an audio file, execute an applet, or communicate with a plug-in) in response to the user
opening or exiting a page.
5.1 INTRODUCTION

Systems design
Introduction: Systems design is the process or art of defining the architecture,

components, modules, interfaces, and data for a system to satisfy specified requirements. One

could see it as the application of systems theory to product development. There is some

overlap and synergy with the disciplines of systems analysis, systems architecture and

systems engineering.
 5.2 DATA FLOW DIAGRAMS

Context Level
Admin User
 Level One

Admin
User id,
pwd

1.1

Login
login

1.2

Add House House

1.3
Resolve
 Contact

5.3 UML DIAGRAMS

Unified Modeling Language:

The Unified Modeling Language allows the software engineer to express an analysis model
using the modeling notation that is governed by a set of syntactic semantic and pragmatic
rules.

A UML system is represented using five different views that describe the system from distinctly
different perspective. Each view is defined by a set of diagram, which is as follows.
• User Model View
i. This view represents the system from the users perspective.
ii. The analysis representation describes a usage scenario from the end-
users perspective.

• Structural model view

i. In this model the data and functionality are arrived from inside the system.
ii. This model view models the static structures.
 • Behavioral Model View
It represents the dynamic of behavioral as parts of the system, depicting the
interactions of collection between various structural elements described in the
user model and structural model view.

• Implementation Model View

In this the structural and behavioral as parts of the system are represented as
they are to be built.

• Environmental Model View

In this the structural and behavioral aspects of the environment in which the
system is to be implemented are represented.

UML is specifically constructed through two different domains they are:

✓ UML Analysis modeling, this focuses on the user model and structural model views of
the system.
✓ UML design modeling, which focuses on the behavioral modeling, implementation
modeling and environmental model views.

Use case Diagrams represent the functionality of the system from a user’s point of view. Use
cases are used during requirements elicitation and analysis to represent the functionality of the
system. Use cases focus on the behavior of the system from external point of view.

Actors are external entities that interact with the system. Examples of actors include users like
administrator, bank customer …etc., or another system like central database.
 UML DIAGRAMS

Activity Diagram:
Home

Login Good View

Options House

Add User Contact

Index
Page
Add House Validate Register

User
Home Login
View Admin
booking Opinions View Profile
User
Options
View Update Profile
Contact
View password
View
Customer
 Logout

Sequence Diagram:

Home Register View Book Contact

House House

Create ()

Register ()

Book ()
 Contact ()

Usecase Diagrams:
Login

View
house

Book a
House

View Profile

Update
Password

Update
Profile

View Booking

Home
 Registered
User
Cancel (Normal)
Booking

Guest

Usecase Diagram:

Addhouse

View Booking

EditHouse

Delate House

Admin View User

User Profile

Update Profile
 Normal User

Class Diagram

5.4 ER-Modeling:

5.5. NORMALIZATION

A Database is a collection of interrelated data stored with a minimum of redundancy to

serve many applications. The database design is used to group data into a number of
tables and minimizes the artificiality embedded in using separate files. The tables are
organized to:

Reduced duplication of data.

Simplify functions like adding, deleting, modifying data etc..,
Retrieving data
Clarity and ease of use
 More information at low cost

Normalization

Normalization is built around the concept of normal forms. A relation is said to be

in a particular normal form if it satisfies a certain specified set of constraints on the kind of
functional dependencies that could be associated with the relation. The normal forms are
used to ensure that various types of anomalies and inconsistencies are not introduced into
the database.

First Normal Form:

A relation R is in first normal form if and only if all underlying domains contained
atomic values only.

Second Normal Form:

A relation R is said to be in second normal form if and only if it is in first normal

form and every non-key attribute is fully dependent on the primary key.

Third Normal Form:

A relation R is said to be in third normal form if and only if it is in second normal

form and every non key attribute is non transitively depend on the primary key.

5.6. DATA DICTI0NARY

/*
SQLyog Community Edition- MySQL GUI v6.07
Host - 5.0.45-community-nt : Database - friendzavenue
-- MySQL dump 10.13 Distrib 8.0.27, for Win64 (x86_64)
--
-- Host: localhost Database: onlinehouserent
-- ------------------------------------------------------
-- Server version 8.0.27

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE,
SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `tbladmin`
--

DROP TABLE IF EXISTS `tbladmin`;

/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbladmin` (
`id` int NOT NULL AUTO_INCREMENT,
`email_id` varchar(100) DEFAULT NULL,
`uname` varchar(100) DEFAULT NULL,
`upass` varchar(100) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbladmin`
--

LOCK TABLES `tbladmin` WRITE;

/*!40000 ALTER TABLE `tbladmin` DISABLE KEYS */;
INSERT INTO `tbladmin` VALUES (1,'admin@[Link]','admin','java@1991','2022-01-26
05:21:44','2022-02-13 10:33:40');
/*!40000 ALTER TABLE `tbladmin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tblcaptcha`
--

DROP TABLE IF EXISTS `tblcaptcha`;

/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblcaptcha` (
`captcha` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tblcaptcha`
--

LOCK TABLES `tblcaptcha` WRITE;

/*!40000 ALTER TABLE `tblcaptcha` DISABLE KEYS */;
INSERT INTO `tblcaptcha` VALUES ('18991');
/*!40000 ALTER TABLE `tblcaptcha` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tblcontact`
--

DROP TABLE IF EXISTS `tblcontact`;

/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblcontact` (
`contact_id` int NOT NULL AUTO_INCREMENT,
`name` varchar(200) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`subject` varchar(100) DEFAULT NULL,
`message` varchar(500) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tblcontact`
--

LOCK TABLES `tblcontact` WRITE;

/*!40000 ALTER TABLE `tblcontact` DISABLE KEYS */;
INSERT INTO `tblcontact` VALUES (3,'Myadmin','admin@[Link]','incury','fgadfsg','2022-08-30
05:30:00');
/*!40000 ALTER TABLE `tblcontact` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tblcustomer`
--

DROP TABLE IF EXISTS `tblcustomer`;

/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblcustomer` (
`id` int NOT NULL,
`full_name` varchar(100) DEFAULT NULL,
`email_id` varchar(100) DEFAULT NULL,
`mobile_no` varchar(100) DEFAULT NULL,
`gender` varchar(45) DEFAULT NULL,
`address` varchar(400) DEFAULT NULL,
`pincode` varchar(100) DEFAULT NULL,
`uname` varchar(100) DEFAULT NULL,
`upass` varchar(100) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tblcustomer`
--

LOCK TABLES `tblcustomer` WRITE;

/*!40000 ALTER TABLE `tblcustomer` DISABLE KEYS */;
INSERT INTO `tblcustomer` VALUES
(666695,'Rice','prajwalchnayak@[Link]','8480288040','Female','NUAGAN GRAM, PO:-
GOVINDPUR','754003','admin','1234','2022-08-30 00:37:17','2022-08-29 23:09:09');
/*!40000 ALTER TABLE `tblcustomer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tblhouse`
--

DROP TABLE IF EXISTS `tblhouse`;

/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tblhouse` (
`id` int NOT NULL,
`hname` varchar(200) DEFAULT NULL,
`type` varchar(200) DEFAULT NULL,
`price` varchar(200) DEFAULT NULL,
`bed` varchar(200) DEFAULT NULL,
`bath` varchar(200) DEFAULT NULL,
`sqft` varchar(200) DEFAULT NULL,
`address` varchar(200) DEFAULT NULL,
`owname` varchar(200) DEFAULT NULL,
`owmobile` varchar(200) DEFAULT NULL,
`img` mediumblob,
`desc` varchar(45) DEFAULT NULL,
`status` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tblhouse`
--

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-09-01 16:40:17

 5.8 CODE
[Link]
<!DOCTYPE html>
<html lang="en">

<head>
<meta charset="utf-8">
<title>Makaan </title>
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<meta content="" name="keywords">
<meta content="" name="description">

<!-- Favicon -->

<link href="img/[Link]" rel="icon">

<!-- Google Web Fonts -->

<link rel="preconnect" href="[Link]
<link rel="preconnect" href="[Link] crossorigin>
<link
href="[Link]
wght@700;800&display=swap" rel="stylesheet">

<!-- Icon Font Stylesheet -->

<link href="[Link]
awesome/5.10.0/css/[Link]" rel="stylesheet">
<link href="[Link]
[Link]" rel="stylesheet">

<!-- Libraries Stylesheet -->

<link href="lib/animate/[Link]" rel="stylesheet">
<link href="lib/owlcarousel/assets/[Link]" rel="stylesheet">

<!-- Customized Bootstrap Stylesheet -->

<link href="css/[Link]" rel="stylesheet">

<!-- Template Stylesheet -->

<link href="css/[Link]" rel="stylesheet">
</head>

<body>
<div class="container-xxl bg-white p-0">
<jsp:include page="[Link]"></jsp:include>
<!-- Header Start -->
<div class="container-fluid header bg-white p-0">
<div class="row g-0 align-items-center flex-column-reverse flex-md-
row">
<div class="col-md-6 p-5 mt-lg-5">
<h1 class="display-5 animated fadeIn mb-4">Find A <span
class="text-primary">Perfect Home</span> To Live With Your Family</h1>
<p class="animated fadeIn mb-4 pb-2">Vero elitr justo clita
lorem. Ipsum dolor at sed stet
sit diam no. Kasd rebum ipsum et diam justo clita et kasd
rebum sea elitr.</p>
 <a href="" class="btn btn-primary py-3 px-5 me-3 animated
fadeIn">Get Started</a>
</div>
<div class="col-md-6 animated fadeIn">
<div class="owl-carousel header-carousel">
<div class="owl-carousel-item">
<img class="img-fluid" src="img/[Link]" alt="">
</div>
<div class="owl-carousel-item">
<img class="img-fluid" src="img/[Link]" alt="">
</div>
</div>
</div>
</div>
</div>
<!-- Header End -->
<!-- Category Start -->
<div class="container-xxl py-5">
<div class="container">
<div class="text-center mx-auto mb-5 wow fadeInUp" data-wow-
delay="0.1s" style="max-width: 600px;">
<h1 class="mb-3">Property Types</h1>
<p>Eirmod sed ipsum dolor sit rebum labore magna erat. Tempor
ut dolore lorem kasd vero ipsum sit eirmod sit. Ipsum diam justo sed rebum vero
dolor duo.</p>
</div>
<div class="row g-4">
<div class="col-lg-3 col-sm-6 wow fadeInUp" data-wow-
delay="0.1s">
<a class="cat-item d-block bg-light text-center rounded p-
3" href="">
<div class="rounded p-4">
<div class="icon mb-3">
<img class="img-fluid" src="img/icon-
[Link]" alt="Icon">
</div>
<h6>Apartment</h6>
<span>123 Properties</span>
</div>
</a>
</div>
<div class="col-lg-3 col-sm-6 wow fadeInUp" data-wow-
delay="0.3s">
<a class="cat-item d-block bg-light text-center rounded p-
3" href="">
<div class="rounded p-4">
<div class="icon mb-3">
<img class="img-fluid" src="img/[Link]"
alt="Icon">
</div>
<h6>Villa</h6>
<span>123 Properties</span>
</div>
</a>
</div>
<div class="col-lg-3 col-sm-6 wow fadeInUp" data-wow-
delay="0.5s">
 <a class="cat-item d-block bg-light text-center rounded p-
3" href="">
<div class="rounded p-4">
<div class="icon mb-3">
<img class="img-fluid" src="img/[Link]"
alt="Icon">
</div>
<h6>Home</h6>
<span>123 Properties</span>
</div>
</a>
</div>
<div class="col-lg-3 col-sm-6 wow fadeInUp" data-wow-
delay="0.7s">
<a class="cat-item d-block bg-light text-center rounded p-
3" href="">
<div class="rounded p-4">
<div class="icon mb-3">
<img class="img-fluid" src="img/icon-
[Link]" alt="Icon">
</div>
<h6>Office</h6>
<span>123 Properties</span>
</div>
</a>
</div>
<div class="col-lg-3 col-sm-6 wow fadeInUp" data-wow-
delay="0.1s">
<a class="cat-item d-block bg-light text-center rounded p-
3" href="">
<div class="rounded p-4">
<div class="icon mb-3">
<img class="img-fluid" src="img/icon-
[Link]" alt="Icon">
</div>
<h6>Building</h6>
<span>123 Properties</span>
</div>
</a>
</div>
<div class="col-lg-3 col-sm-6 wow fadeInUp" data-wow-
delay="0.3s">
<a class="cat-item d-block bg-light text-center rounded p-
3" href="">
<div class="rounded p-4">
<div class="icon mb-3">
<img class="img-fluid" src="img/icon-
[Link]" alt="Icon">
</div>
<h6>Townhouse</h6>
<span>123 Properties</span>
</div>
</a>
</div>
<div class="col-lg-3 col-sm-6 wow fadeInUp" data-wow-
delay="0.5s">
 <a class="cat-item d-block bg-light text-center rounded p-
3" href="">
<div class="rounded p-4">
<div class="icon mb-3">
<img class="img-fluid" src="img/icon-
[Link]" alt="Icon">
</div>
<h6>Shop</h6>
<span>123 Properties</span>
</div>
</a>
</div>
<div class="col-lg-3 col-sm-6 wow fadeInUp" data-wow-
delay="0.7s">
<a class="cat-item d-block bg-light text-center rounded p-
3" href="">
<div class="rounded p-4">
<div class="icon mb-3">
<img class="img-fluid" src="img/icon-
[Link]" alt="Icon">
<!-- Property List Start -->
<div class="container-xxl py-5">
<div class="container">
<div class="row g-0 gx-5 align-items-end">
<div class="col-lg-6">
<div class="text-start mx-auto mb-5 wow slideInLeft" data-
wow-delay="0.1s">
<h1 class="mb-3">Property Listing</h1>
<p>Eirmod sed ipsum dolor sit rebum labore magna erat.
Tempor ut dolore lorem kasd vero ipsum sit eirmod sit diam justo sed rebum.</p>
</div>
</div>
<div class="col-lg-6 text-start text-lg-end wow slideInRight"
data-wow-delay="0.1s">
<ul class="nav nav-pills d-inline-flex justify-content-end
mb-5">
<li class="nav-item me-2">
<a class="btn btn-outline-primary active" data-bs-
toggle="pill" href="#tab-1">Featured</a>
</li>
<li class="nav-item me-2">
<a class="btn btn-outline-primary" data-bs-
toggle="pill" href="#tab-2">For Sell</a>
</li>
<li class="nav-item me-0">
<a class="btn btn-outline-primary" data-bs-
toggle="pill" href="#tab-3">For Rent</a>
</li>
</ul>
</div>
</div>
<div class="tab-content">
<div id="tab-1" class="tab-pane fade show p-0 active">
<div class="row g-4">
<div class="col-lg-4 col-md-6 wow fadeInUp" data-wow-
delay="0.1s">
<div class="property-item rounded overflow-hidden">
 <div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Sell</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Appartment</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6 wow fadeInUp" data-wow-
delay="0.3s">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Rent</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Villa</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6 wow fadeInUp" data-wow-
delay="0.5s">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
 <a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Sell</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Office</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6 wow fadeInUp" data-wow-
delay="0.1s">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Rent</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Building</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6 wow fadeInUp" data-wow-
delay="0.3s">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
 <a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Sell</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Home</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6 wow fadeInUp" data-wow-
delay="0.5s">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Rent</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Shop</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-12 text-center wow fadeInUp" data-wow-
delay="0.1s">
<a class="btn btn-primary py-3 px-5" href="">Browse
More Property</a>
</div>
 </div>
</div>
<div id="tab-2" class="tab-pane fade show p-0">
<div class="row g-4">
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Sell</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Appartment</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Rent</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Villa</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
 </div>
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Sell</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Office</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Rent</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Building</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Sell</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Home</div>
</div>
 <div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Rent</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Shop</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-12 text-center">
<a class="btn btn-primary py-3 px-5" href="">Browse
More Property</a>
</div>
</div>
</div>
<div id="tab-3" class="tab-pane fade show p-0">
<div class="row g-4">
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
 <div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Sell</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Appartment</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Rent</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Villa</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Sell</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Office</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
 </div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Rent</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Building</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Sell</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Home</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
 <small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="property-item rounded overflow-hidden">
<div class="position-relative overflow-hidden">
<a href=""><img class="img-fluid"
src="img/[Link]" alt=""></a>
<div class="bg-primary rounded text-white
position-absolute start-0 top-0 m-4 py-1 px-3">For Rent</div>
<div class="bg-white rounded-top text-
primary position-absolute start-0 bottom-0 mx-4 pt-1 px-3">Shop</div>
</div>
<div class="p-4 pb-0">
<h5 class="text-primary mb-3">$12,345</h5>
<a class="d-block h5 mb-2" href="">Golden
Urban House For Sell</a>
<p><i class="fa fa-map-marker-alt text-
primary me-2"></i>123 Street, New York, USA</p>
</div>
<div class="d-flex border-top">
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-ruler-combined text-primary me-2"></i>1000 Sqft</small>
<small class="flex-fill text-center border-
end py-2"><i class="fa fa-bed text-primary me-2"></i>3 Bed</small>
<small class="flex-fill text-center py-
2"><i class="fa fa-bath text-primary me-2"></i>2 Bath</small>
</div>
</div>
</div>
<div class="col-12 text-center">
<a class="btn btn-primary py-3 px-5" href="">Browse
More Property</a>
</div>div></div>div></div></div>
<!-- Property List End -->

<!-- Call to Action Start -->

<div class="container-xxl py-5">
<div class="container">
<div class="bg-light rounded p-3">
<div class="bg-white rounded p-4" style="border: 1px dashed
rgba(0, 185, 142, .3)">
<div class="row g-5 align-items-center">
<div class="col-lg-6 wow fadeIn" data-wow-delay="0.1s">
<img class="img-fluid rounded w-100" src="img/call-
[Link]" alt="">
</div>
<div class="col-lg-6 wow fadeIn" data-wow-delay="0.5s">
<div class="mb-4">
 <h1 class="mb-3">Contact With Our Certified
Agent</h1>
<p>Eirmod sed ipsum dolor sit rebum magna erat.
Tempor lorem kasd vero ipsum sit sit diam justo sed vero dolor duo.</p>
</div>
<a href="" class="btn btn-primary py-3 px-4 me-
2"><i class="fa fa-phone-alt me-2"></i>Make A Call</a>
<a href="" class="btn btn-dark py-3 px-4"><i
class="fa fa-calendar-alt me-2"></i>Get Appoinment</a>
</div>div>div>div>div>div>
<!-- Call to Action End -->

<!-- Team Start -->

<div class="container-xxl py-5">
<div class="container">
<div class="text-center mx-auto mb-5 wow fadeInUp" data-wow-
delay="0.1s" style="max-width: 600px;">
<h1 class="mb-3">Property Agents</h1>
<p>Eirmod sed ipsum dolor sit rebum labore magna erat. Tempor
ut dolore lorem kasd vero ipsum sit eirmod sit. Ipsum diam justo sed rebum vero
dolor duo.</p>
</div>
<div class="row g-4">
<div class="col-lg-3 col-md-6 wow fadeInUp" data-wow-
delay="0.1s">
<div class="team-item rounded overflow-hidden">
<div class="position-relative">
<img class="img-fluid" src="img/[Link]" alt="">
<div class="position-absolute start-50 top-100
translate-middle d-flex align-items-center">
<a class="btn btn-square mx-1" href=""><i
class="fab fa-facebook-f"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-twitter"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-instagram"></i></a>
</div>
</div>
<div class="text-center p-4 mt-3">
<h5 class="fw-bold mb-0">Full Name</h5>
<small>Designation</small>
</div>
</div>
</div>
<div class="col-lg-3 col-md-6 wow fadeInUp" data-wow-
delay="0.3s">
<div class="team-item rounded overflow-hidden">
<div class="position-relative">
<img class="img-fluid" src="img/[Link]" alt="">
<div class="position-absolute start-50 top-100
translate-middle d-flex align-items-center">
<a class="btn btn-square mx-1" href=""><i
class="fab fa-facebook-f"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-twitter"></i></a>
 <a class="btn btn-square mx-1" href=""><i
class="fab fa-instagram"></i></a>
</div>
</div>
<div class="text-center p-4 mt-3">
<h5 class="fw-bold mb-0">Full Name</h5>
<small>Designation</small>
</div>
</div>
</div>
<div class="col-lg-3 col-md-6 wow fadeInUp" data-wow-
delay="0.5s">
<div class="team-item rounded overflow-hidden">
<div class="position-relative">
<img class="img-fluid" src="img/[Link]" alt="">
<div class="position-absolute start-50 top-100
translate-middle d-flex align-items-center">
<a class="btn btn-square mx-1" href=""><i
class="fab fa-facebook-f"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-twitter"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-instagram"></i></a>
</div>
</div>
<div class="text-center p-4 mt-3">
<h5 class="fw-bold mb-0">Full Name</h5>
<small>Designation</small>
</div>
</div>
</div>
<div class="col-lg-3 col-md-6 wow fadeInUp" data-wow-
delay="0.7s">
<div class="team-item rounded overflow-hidden">
<div class="position-relative">
<img class="img-fluid" src="img/[Link]" alt="">
<div class="position-absolute start-50 top-100
translate-middle d-flex align-items-center">
<a class="btn btn-square mx-1" href=""><i
class="fab fa-facebook-f"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-twitter"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-instagram"></i></a>
</div>
</div>
<div class="text-center p-4 mt-3">
<h5 class="fw-bold mb-0">Full Name</h5>

<small>Designation</small></div>div></div></div>div>div>
<!-- Team End -->
<!-- Testimonial Start -->
<div class="container-xxl py-5">
<div class="container">
<div class="text-center mx-auto mb-5 wow fadeInUp" data-wow-
delay="0.1s" style="max-width: 600px;">
<h1 class="mb-3">Our Clients Say!</h1>
 <p>Eirmod sed ipsum dolor sit rebum labore magna erat. Tempor
ut dolore lorem kasd vero ipsum sit eirmod sit. Ipsum diam justo sed rebum vero
dolor duo.</p>
</div>
<div class="owl-carousel testimonial-carousel wow fadeInUp" data-
wow-delay="0.1s">
<div class="testimonial-item bg-light rounded p-3">
<div class="bg-white border rounded p-4">
<p>Tempor stet labore dolor clita stet diam amet ipsum
dolor duo ipsum rebum stet dolor amet diam stet. Est stet ea lorem amet est kasd
kasd erat eos</p>
<div class="d-flex align-items-center">
<img class="img-fluid flex-shrink-0 rounded"
src="img/[Link]" style="width: 45px; height: 45px;">
<div class="ps-3">
<h6 class="fw-bold mb-1">Client Name</h6>
<small>Profession</small>
</div>
</div>
</div>
</div>
<div class="testimonial-item bg-light rounded p-3">
<div class="bg-white border rounded p-4">
<p>Tempor stet labore dolor clita stet diam amet ipsum
dolor duo ipsum rebum stet dolor amet diam stet. Est stet ea lorem amet est kasd
kasd erat eos</p>
<div class="d-flex align-items-center">
<img class="img-fluid flex-shrink-0 rounded"
src="img/[Link]" style="width: 45px; height: 45px;">
<div class="ps-3">
<h6 class="fw-bold mb-1">Client Name</h6>
<small>Profession</small>
</div>
</div>
</div>
</div>
<div class="testimonial-item bg-light rounded p-3">
<div class="bg-white border rounded p-4">
<p>Tempor stet labore dolor clita stet diam amet ipsum
dolor duo ipsum rebum stet dolor amet diam stet. Est stet ea lorem amet est kasd
kasd erat eos</p>
<div class="d-flex align-items-center">
<img class="img-fluid flex-shrink-0 rounded"
src="img/[Link]" style="width: 45px; height: 45px;">
<div class="ps-3">
<h6 class="fw-bold mb-1">Client Name</h6>
<small>Profession</small>
</div>div>div>div></div>div>div>
<!-- Testimonial End -->

<jsp:include page="[Link]"></jsp:include>

<!-- Back to Top -->

<a href="#" class="btn btn-lg btn-primary btn-lg-square back-to-top"><i
class="bi bi-arrow-up"></i></a>
 </div>

<!-- JavaScript Libraries -->

<script src="[Link]
<script
src="[Link]
</script>
<script src="lib/wow/[Link]"></script>
<script src="lib/easing/[Link]"></script>
<script src="lib/waypoints/[Link]"></script>
<script src="lib/owlcarousel/[Link]"></script>

<!-- Template Javascript -->

<script src="js/[Link]"></script>
</body>

</html>
[Link]:
<!-- Spinner Start -->
<div id="spinner" class="show bg-white position-fixed translate-middle w-
100 vh-100 top-50 start-50 d-flex align-items-center justify-content-center">
<div class="spinner-border text-primary" style="width: 3rem; height:
3rem;" role="status">
<span class="sr-only">Loading...</span>
</div>
</div>
<!-- Spinner End -->

<!-- Navbar Start -->

<div class="container-fluid nav-bar bg-transparent">

<%
if ((String) [Link]("uname") != null) {
%>
<nav class="navbar navbar-expand-lg bg-white navbar-light py-0 px-4">
<a href="[Link]" class="navbar-brand d-flex align-items-center
text-center">
<div class="icon p-2 me-2">
<img class="img-fluid" src="img/[Link]" alt="Icon"
style="width: 30px; height: 30px;">
</div>
<h1 class="m-0 text-primary">Makaan</h1>
</a>
<button type="button" class="navbar-toggler" data-bs-
toggle="collapse" data-bs-target="#navbarCollapse">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarCollapse">
<div class="navbar-nav ms-auto">
<a href="[Link]" class="nav-item nav-link
active">Home</a>
<a href="[Link]" class="nav-item nav-link">About</a>
<div class="nav-item dropdown">
<a href="#" class="nav-link dropdown-toggle" data-bs-
toggle="dropdown">Property</a>
 <div class="dropdown-menu rounded-0 m-0">
<a href="[Link]" class="dropdown-
item">Property List</a>
<a href="[Link]" class="dropdown-
item">Property Type</a>
<a href="[Link]" class="dropdown-
item">Property Agent</a>
</div>
</div>

<a href="[Link]" class="nav-item nav-link">Contact</a>

<div class="nav-item dropdown">

<a href="#" class="nav-link dropdown-toggle" data-bs-
toggle="dropdown"><%=[Link]("uname")%></a>
<div class="dropdown-menu rounded-0 m-0">
<a href="[Link]" class="dropdown-
item">MyProfile</a>
<a href="[Link]" class="dropdown-
item">MyBooking</a>
<a href="[Link]"
class="dropdown-item">Setting</a>
<a href="[Link]" class="dropdown-
item">Logout</a>
</div>
</div>
</nav>

<%
} else {

%>
<nav class="navbar navbar-expand-lg bg-white navbar-light py-0 px-4">
<a href="[Link]" class="navbar-brand d-flex align-items-center
text-center">
<div class="icon p-2 me-2">
<img class="img-fluid" src="img/[Link]" alt="Icon"
style="width: 30px; height: 30px;">
</div>
<h1 class="m-0 text-primary">Makaan</h1>
</a>
<button type="button" class="navbar-toggler" data-bs-
toggle="collapse" data-bs-target="#navbarCollapse">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarCollapse">
<div class="navbar-nav ms-auto">
<a href="[Link]" class="nav-item nav-link
active">Home</a>
<a href="[Link]" class="nav-item nav-link">About</a>
<div class="nav-item dropdown">
<a href="#" class="nav-link dropdown-toggle" data-bs-
toggle="dropdown">Property</a>
<div class="dropdown-menu rounded-0 m-0">
<a href="[Link]" class="dropdown-
item">Property List</a>
 <a href="[Link]" class="dropdown-
item">Property Type</a>
<a href="[Link]" class="dropdown-
item">Property Agent</a>
</div>
</div>
<div class="nav-item dropdown">
<a href="#" class="nav-link dropdown-toggle" data-bs-
toggle="dropdown">Customer</a>
<div class="dropdown-menu rounded-0 m-0">
<a href="[Link]" class="dropdown-
item">CustomerLogin</a>
<a href="[Link]" class="dropdown-
item">CustomerRegiser</a>

</div>
</div>
<a href="[Link]" class="nav-item nav-
link">AdminLogin</a>
<a href="[Link]" class="nav-item nav-link">Contact</a>
</div>
<a href="[Link]" class="btn btn-primary px-3 d-none
d-lg-flex">Login</a>
</div>
</nav>
<%} %>
</div>
<!-- Navbar End -->
[Link]
<!-- Footer Start -->
<div class="container-fluid bg-dark text-white-50 footer pt-5 mt-5 wow
fadeIn" data-wow-delay="0.1s">
<div class="container py-5">
<div class="row g-5">
<div class="col-lg-3 col-md-6">
<h5 class="text-white mb-4">Get In Touch</h5>
<p class="mb-2"><i class="fa fa-map-marker-alt me-
3"></i>123 Street, New York, USA</p>
<p class="mb-2"><i class="fa fa-phone-alt me-3"></i>+012
345 67890</p>
<p class="mb-2"><i class="fa fa-envelope me-
3"></i>info@[Link]</p>

</div>
</div>
<div class="col-lg-3 col-md-6">
<h5 class="text-white mb-4">Quick Links</h5>
<a class="btn btn-link text-white-50" href="">About Us</a>
<a class="btn btn-link text-white-50" href="">Contact
Us</a>
<a class="btn btn-link text-white-50" href="">Our
Services</a>
<a class="btn btn-link text-white-50" href="">Privacy
Policy</a>
<a class="btn btn-link text-white-50" href="">Terms &
Condition</a>
 </div>
<div class="col-lg-3 col-md-6">
<h5 class="text-white mb-4">Photo Gallery</h5>
<div class="row g-2 pt-2">
<div class="col-4">
<img class="img-fluid rounded bg-light p-1"
src="img/[Link]" alt="">
</div>
<div class="col-4">
<img class="img-fluid rounded bg-light p-1"
src="img/[Link]" alt="">
</div>
<div class="col-4">
<img class="img-fluid rounded bg-light p-1"
src="img/[Link]" alt="">
</div>
<div class="col-4">
<img class="img-fluid rounded bg-light p-1"
src="img/[Link]" alt="">
</div>
<div class="col-4">
<img class="img-fluid rounded bg-light p-1"
src="img/[Link]" alt="">
</div>
<div class="col-4">
<img class="img-fluid rounded bg-light p-1"
src="img/[Link]" alt="">
</div>
</div>
</div>
<div class="col-lg-3 col-md-6">
<h5 class="text-white mb-4">Newsletter</h5>
<p>Dolor amet sit justo amet elitr clita ipsum elitr
est.</p>
<div class="position-relative mx-auto" style="max-width:
400px;">
<input class="form-control bg-transparent w-100 py-3
ps-4 pe-5" type="text" placeholder="Your email">
<button type="button" class="btn btn-primary py-2
position-absolute top-0 end-0 mt-2 me-2">SignUp</button>
</div>
</div>
</div>
</div>
<div class="container">
<div class="copyright">
<div class="row">
<div class="col-md-6 text-center text-md-start mb-3 mb-md-
0">
&copy; <a class="border-bottom" href="#">Your Site
Name</a>, All Right Reserved.
Designed By <a class="border-bottom"
href="[Link] Codex</a>
</div>
<div class="col-md-6 text-center text-md-end">
<div class="footer-menu">
<a href="">Home</a>
 <a href="">Cookies</a>
<a href="">Help</a>
<a href="">FQAs</a>
</div></div></div></div>div></div>
<!-- Footer End -->

[Link]
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Makaan</title>
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<meta content="" name="keywords">
<meta content="" name="description">
<!-- Favicon -->
<link href="img/[Link]" rel="icon">
<!-- Google Web Fonts -->
<link rel="preconnect" href="[Link]
<link rel="preconnect" href="[Link] crossorigin>
<link
href="[Link]
wght@700;800&display=swap" rel="stylesheet">

<!-- Icon Font Stylesheet -->

<link href="[Link]
awesome/5.10.0/css/[Link]" rel="stylesheet">
<link href="[Link]
[Link]" rel="stylesheet">

<!-- Libraries Stylesheet -->

<link href="lib/animate/[Link]" rel="stylesheet">
<link href="lib/owlcarousel/assets/[Link]" rel="stylesheet">

<!-- Customized Bootstrap Stylesheet -->

<link href="css/[Link]" rel="stylesheet">

<!-- Template Stylesheet -->

<link href="css/[Link]" rel="stylesheet">
</head>

<body>
<div class="container-xxl bg-white p-0">
<jsp:include page="[Link]"></jsp:include>
<!-- Header Start -->

<br><br>
<br><br>
<jsp:include page="[Link]"></jsp:include>
<!-- Back to Top -->
<a href="#" class="btn btn-lg btn-primary btn-lg-square back-to-top"><i
class="bi bi-arrow-up"></i></a>
</div>

<!-- JavaScript Libraries -->

 <script src="[Link]
<script
src="[Link]
</script>
<script src="lib/wow/[Link]"></script>
<script src="lib/easing/[Link]"></script>
<script src="lib/waypoints/[Link]"></script>
<script src="lib/owlcarousel/[Link]"></script>

<!-- Template Javascript -->

<script src="js/[Link]"></script>
</body>
</html>
[Link]
<!DOCTYPE html>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Makaan</title>
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<meta content="" name="keywords">
<meta content="" name="description">
<!-- Favicon -->
<link href="img/[Link]" rel="icon">

<!-- Google Web Fonts -->

<link rel="preconnect" href="[Link]
<link rel="preconnect" href="[Link] crossorigin>
<link
href="[Link]
wght@700;800&display=swap" rel="stylesheet">
<!-- Icon Font Stylesheet -->
<link href="[Link]
awesome/5.10.0/css/[Link]" rel="stylesheet">
<link href="[Link]
[Link]" rel="stylesheet">
<!-- Libraries Stylesheet -->
<link href="lib/animate/[Link]" rel="stylesheet">
<link href="lib/owlcarousel/assets/[Link]" rel="stylesheet">
<!-- Customized Bootstrap Stylesheet -->
<link href="css/[Link]" rel="stylesheet">
<!-- Template Stylesheet -->
<link href="css/[Link]" rel="stylesheet">
</head>
<body>
<div class="container-xxl bg-white p-0">
<jsp:include page="[Link]"></jsp:include>
<!-- Header Start -->
<br><br>
<div class="bg-light py-3">
<div class="container">
<div class="row">
 <div class="col-md-12 mb-0">
<a href="[Link]">Home</a> <span class="mx-2
mb-0">/</span> <strong
class="text-black">Admin Login</strong>
</div>
</div>
</div>
</div>
<div class="site-section">
<div class="container">
<div class="row">
<div class="col-md-6 col-sm-6 col-xs-12">
<img src="img/[Link]" style="width:
550px; height: 300px;"></img>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="panel panel-warning shadow p-3 mb-
5">
<div class="panel-heading">Admin
Login</div>
<div class="panel-body">
<%
String credential = (String)
[Link]("credential");
if (credential != null) {

[Link]("credential");
%>
<div class="alert alert-danger"
id="danger">You have enter
wrong credentials.</div>
<%
}
%>
<%
String captchaCode = (String)
[Link]("verificationCode");
if (captchaCode != null) {

[Link]("verificationCode");
%>
<div class="alert alert-info"
id="info">You have enter
wrong verification
code.</div>
<%
}
%>
<form action="AdminLogin"
method="post">
<div class="form-group">
<label for="uname">User
Name:</label> <input type="text"
class="form-
control" id="uname" placeholder="Enter username"
name="uname"
required>
 </div>
<div class="form-group">
<label
for="upass">Password:</label> <input type="password"
class="form-
control" id="upass" placeholder="Enter password"
name="upass"
required maxlength="12">
</div>
<%
String captcha = null;
Connection connection =
[Link]();
Statement statement =
[Link]();
ResultSet resultset =
[Link]("select captcha from tblcaptcha");
if ([Link]()) {
captcha =
[Link](1);
}
%>

<div class="row">
<div class="col-sm-6">
<label
for="vercode">Verification Code:</label> <input

type="password" class="form-control" id="vercode"

placeholder="Enter captcha code here" name="vercode">

</div>
<div class="col-sm-6">
<label
for="vercode">Copy the Code:</label><br>

<h5><%=captcha%></h5></div></div>
<button type="submit" value="Login" class="btn btn-primary">
<span class="glyphicon
glyphicon-log-in"></span> Login
</button>
<input type="reset"
class="btn btn-danger" value="Cancel">

</form></div></div>div>div></div></div></div>
<br><br>
<jsp:include page="[Link]"></jsp:include>
<!-- Back to Top -->
<a href="#" class="btn btn-lg btn-primary btn-lg-square back-to-top"><i
class="bi bi-arrow-up"></i></a>
</div>
<!-- JavaScript Libraries -->
<script src="[Link]
<script src="lib/wow/[Link]"></script>
<script src="lib/easing/[Link]"></script>
<script src="lib/waypoints/[Link]"></script>
<script src="lib/owlcarousel/[Link]"></script>
 <!-- Template Javascript -->
<script src="js/[Link]"></script>
</body>

</html>
[Link]
<!DOCTYPE html>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<html lang="en">

<head>
<meta charset="utf-8">
<title>Makaan</title>
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<meta content="" name="keywords">
<meta content="" name="description">

<!-- Favicon -->

<link href="img/[Link]" rel="icon">

<!-- Google Web Fonts -->

<link rel="preconnect" href="[Link]
<link rel="preconnect" href="[Link] crossorigin>
<link
href="[Link]
wght@700;800&display=swap" rel="stylesheet">

<!-- Icon Font Stylesheet -->

<link href="[Link]
awesome/5.10.0/css/[Link]" rel="stylesheet">
<link href="[Link]
[Link]" rel="stylesheet">

<!-- Libraries Stylesheet -->

<link href="lib/animate/[Link]" rel="stylesheet">
<link href="lib/owlcarousel/assets/[Link]" rel="stylesheet">

<!-- Customized Bootstrap Stylesheet -->

<link href="css/[Link]" rel="stylesheet">

<!-- Template Stylesheet -->

<link href="css/[Link]" rel="stylesheet">
</head>

<body>
<div class="container-xxl bg-white p-0">
<jsp:include page="[Link]"></jsp:include>
<!-- Header Start -->

<br><br>

<div class="right_col" role="main">

<div class="">
<div class="page-title">
 <div class="title_left">
<h3>
<i class="fa fa-user"></i> Profile
</h3>
</div>
</div>
<div class="clearfix"></div>
<div class="row">
<div class="col-md-12 col-sm-12 ">
<div class="x_panel">
<div class="x_title">
<h2>Profile Information</h2>
<div class="clearfix"></div>
</div>
<%
ResultSet resultset =
[Link]("select * from tbladmin where uname='"
+ [Link]("uname") +
"' and email_id='" + [Link]("email") + "'");
if ([Link]()) {
%>
<div class="x_content">
<div class="col-md-12 col-sm-12
profile_left shadow p-3 mb-5">
<form id="demo-form2" data-parsley-
validate
class="form-horizontal form-
label-left">

<div class="item form-group">

<label class="col-form-
label col-md-3 col-sm-3 label-align"><strong><i
class="fa
fa-user"></i> Account Information</strong></label>
</div>
<div class="item form-group">
<label class="col-form-
label col-md-3 col-sm-3 label-align">Email</label>
<div class="col-md-8
col-sm-8 ">
<input
class="form-control" type="text"

value="<%=[Link]("email_id")%>" readonly>
</div></div><div class="item form-group">
<label class="col-form-label col-md-3 col-sm-3 label-align">User Name</label>
<div class="col-md-8 col-sm-8 ">
<input class="form-control" type="text" value="<%=[Link]("uname")%>"
readonly></div></div>
<div class="item form-group">
<label class="col-form-
label col-md-3 col-sm-3 label-align">Password</label>
<div class="col-md-8
col-sm-8 ">
<input
class="form-control" type="password"
 value="<%=[Link]("upass")%>">
</div>
</div>
<div class="item form-group">
<label class="col-form-
label col-md-3 col-sm-3 label-align">Created At</label>
<div class="col-md-8
col-sm-8 ">
<input
class="form-control" type="text"

value="<%=[Link]("created_at")%>" readonly></div>
</div>
<div class="item form-group">
<label class="col-form-
label col-md-3 col-sm-3 label-align">Updated At</label>
<div class="col-md-8
col-sm-8 ">
<input
class="form-control" type="text"

value="<%=[Link]("updated_at")%>" readonly>
</div>
</div>
<div class="ln_solid"></div>
</form>
</div>
</div>
</div><%}%>div>div></div>div>div>
</div>
<br><br>
<jsp:include page="[Link]"></jsp:include>
<!-- Back to Top -->
<a href="#" class="btn btn-lg btn-primary btn-lg-square back-to-top"><i
class="bi bi-arrow-up"></i></a>
</div>

<!-- JavaScript Libraries -->

<script src="[Link]
<script
src="[Link]
</script>
<script src="lib/wow/[Link]"></script>
<script src="lib/easing/[Link]"></script>
<script src="lib/waypoints/[Link]"></script>
<script src="lib/owlcarousel/[Link]"></script>
<!-- Template Javascript -->
<script src="js/[Link]"></script>
</body>
</html>

[Link]
<!DOCTYPE html>
<%@page import="[Link]"%>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Makaan</title>
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<meta content="" name="keywords">
<meta content="" name="description">
<!-- Favicon -->
<link href="img/[Link]" rel="icon">
<!-- Google Web Fonts -->
<link rel="preconnect" href="[Link]
<link rel="preconnect" href="[Link] crossorigin>
<link
href="[Link]
wght@700;800&display=swap" rel="stylesheet">
<!-- Icon Font Stylesheet -->
<link href="[Link]
awesome/5.10.0/css/[Link]" rel="stylesheet">
<link href="[Link]
[Link]" rel="stylesheet">

<!-- Libraries Stylesheet -->

<link href="lib/animate/[Link]" rel="stylesheet">
<link href="lib/owlcarousel/assets/[Link]" rel="stylesheet">

<!-- Customized Bootstrap Stylesheet -->

<link href="css/[Link]" rel="stylesheet">

<!-- Template Stylesheet -->

<link href="css/[Link]" rel="stylesheet">
</head>

<body>
<div class="container-xxl bg-white p-0">
<jsp:include page="[Link]"></jsp:include>
<!-- Header Start -->

<br><br><br>
<div class="bg-light py-3">
<div class="container">
<div class="row">
<div class="col-md-12 mb-0">
<a href="[Link]">Home</a> <span class="mx-2
mb-0">/</span> <strong
class="text-black">Create Customer
Account</strong>
</div>
</div>
</div>
</div>
<div class="site-section">
<div class="container">
<%
String customerAccount = (String)
[Link]("customer-account");
if (customerAccount != null) {
[Link]("customer-account");
 %>
<div class="alert alert-info" id="info">Customer account
created successfully.</div>
<%
}
%>

<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="panel panel-warning shadow p-3 mb-
5">
<div class="panel-heading">Customer
Account</div>
<div class="panel-body">
<form action="CustomerRegiser"
method="post" name="customerForm">
<div class="row">
<%
int customerId =
[Link]();
%>
<div class="form-group
col-md-6">
<label
for="customerId">Customer Id:</label> <input
type="text"
class="form-control" id="customerId"

placeholder="Customer Id" name="customerId"

value="<%=customerId%>" readonly>
</div>
<div class="form-group
col-md-6"">
<label
for="cname">Full Name:</label> <input type="text"

class="form-control" id="cname" placeholder="Full Name"

name="cname" required

onkeypress="return lettersValidate(event)">
</div>
</div>
<div class="row">
<div class="form-group
col-md-6">
<label
for="email">Email Id:</label> <input type="text"

class="form-control" id="email" placeholder="Email Id"

name="email" required onblur="return validateEmail()">

<span
id="emailloc"></span>
</div>
 <div class="form-group
col-md-6">
<label
for="mobile">Mobile No:</label> <input type="text"

class="form-control" id="mobile" placeholder="Mobile No"

name="mobile" required

onkeypress="return numberValidate(event)" maxlength="10">

</div>
</div>
<div class="form-group">
<label
for="gender">Select Gender:</label> <select
class="form-
control" id="gender" name="gender">

<option>Male</option>

<option>Female</option></select></div><div class="row">
<div class="form-group
col-md-6"><label for="address">Address:</label><textarea class="form-control"
id="address"
placeholder="Address" name="address" required maxlength="60"></textarea>
</div><div class="form-group col-md-6">
<label for="pincode">Pincode:</label> <input type="text"

class="form-control" id="pincode"

placeholder="Enter Pincode" name="pincode" required

oninput="limitNumber(this)" maxlength="6">
</div>
</div>
<div class="row">
<div class="form-group
col-md-6">
<label
for="uname">User Name:</label> <input type="text"

class="form-control" id="uname" placeholder="Enter username"

name="uname" required

onkeypress="return lettersValidate(event)">
</div>
<div class="form-group
col-md-6">
<label
for="upass">Password:</label> <input type="password"

class="form-control" id="upass" placeholder="Enter password"

name="upass" required oninput="limitChar(this)"

maxlength="12"></div>
</div>
<input type="submit" value="Create Account"
class="btn btn-
primary"> <input type="reset"
class="btn btn-danger"
value="Cancel">
</form>
</div>
</div>
</div>
</div>
<p>
<strong>Important Note -</strong>
</p>
<p>1) Name,User Name only allowed in character format.</p>
<p>2) Password length is upto 12 character & digit.</p>
<p>3) 10 digit mobile number allowed only.</p>
</div>
</div>
<br><br>
<jsp:include page="[Link]"></jsp:include>
<!-- Back to Top -->
<a href="#" class="btn btn-lg btn-primary btn-lg-square back-to-top"><i
class="bi bi-arrow-up"></i></a>
</div>
<!-- JavaScript Libraries -->
<script src="[Link]
<script
src="[Link]
</script>
<script src="lib/wow/[Link]"></script>
<script src="lib/easing/[Link]"></script>
<script src="lib/waypoints/[Link]"></script>
<script src="lib/owlcarousel/[Link]"></script>
<!-- Template Javascript -->
<script src="js/[Link]"></script>
</body>
</html>

[Link]
<!DOCTYPE html>
<html lang="en">

<head>
<meta charset="utf-8">
<title>Makaan</title>
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<meta content="" name="keywords">
<meta content="" name="description">

<!-- Favicon -->

<link href="img/[Link]" rel="icon">

<!-- Google Web Fonts -->

<link rel="preconnect" href="[Link]
 <link rel="preconnect" href="[Link] crossorigin>
<link
href="[Link]
wght@700;800&display=swap" rel="stylesheet">

<!-- Icon Font Stylesheet -->

<link href="[Link]
awesome/5.10.0/css/[Link]" rel="stylesheet">
<link href="[Link]
[Link]" rel="stylesheet">

<!-- Libraries Stylesheet -->

<link href="lib/animate/[Link]" rel="stylesheet">
<link href="lib/owlcarousel/assets/[Link]" rel="stylesheet">

<!-- Customized Bootstrap Stylesheet -->

<link href="css/[Link]" rel="stylesheet">

<!-- Template Stylesheet -->

<link href="css/[Link]" rel="stylesheet">
</head>

<body>
<div class="container-xxl bg-white p-0">
<jsp:include page="[Link]"></jsp:include>
<!-- Header Start -->

<br><br>

<!-- Header Start -->

<div class="container-fluid header bg-white p-0">
<div class="row g-0 align-items-center flex-column-reverse flex-md-
row">
<div class="col-md-6 p-5 mt-lg-5">
<h1 class="display-5 animated fadeIn mb-4">Property Agent</h1>
<nav aria-label="breadcrumb animated fadeIn">
<ol class="breadcrumb text-uppercase">
<li class="breadcrumb-item"><a href="#">Home</a></li>
<li class="breadcrumb-item"><a href="#">Pages</a></li>
<li class="breadcrumb-item text-body active" aria-
current="page">Property Agent</li>
</ol>
</nav>
</div>
<div class="col-md-6 animated fadeIn">
<img class="img-fluid" src="img/[Link]" alt="">
</div>
</div>
</div>
<!-- Header End -->
<!-- Team Start -->
<div class="container-xxl py-5">
<div class="container">
<div class="text-center mx-auto mb-5 wow fadeInUp" data-wow-
delay="0.1s" style="max-width: 600px;">
<h1 class="mb-3">Property Agents</h1>
 <p>Eirmod sed ipsum dolor sit rebum labore magna erat. Tempor
ut dolore lorem kasd vero ipsum sit eirmod sit. Ipsum diam justo sed rebum vero
dolor duo.</p>
</div>
<div class="row g-4">
<div class="col-lg-3 col-md-6 wow fadeInUp" data-wow-
delay="0.1s">
<div class="team-item rounded overflow-hidden">
<div class="position-relative">
<img class="img-fluid" src="img/[Link]" alt="">
<div class="position-absolute start-50 top-100
translate-middle d-flex align-items-center">
<a class="btn btn-square mx-1" href=""><i
class="fab fa-facebook-f"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-twitter"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-instagram"></i></a>
</div>
</div>
<div class="text-center p-4 mt-3">
<h5 class="fw-bold mb-0">Full Name</h5>
<small>Designation</small>
</div>
</div>
</div>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-facebook-f"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-twitter"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-instagram"></i></a>
</div>

<a class="btn btn-square mx-1" href=""><i

class="fab fa-twitter"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-instagram"></i></a>
</div>
</div>
<div class="text-center p-4 mt-3">
<h5 class="fw-bold mb-0">Full Name</h5>
<small>Designation</small>
</div>
</div>
</div>
<div class="col-lg-3 col-md-6 wow fadeInUp" data-wow-
delay="0.7s">
<div class="team-item rounded overflow-hidden">
<div class="position-relative">
<img class="img-fluid" src="img/[Link]" alt="">
<div class="position-absolute start-50 top-100
translate-middle d-flex align-items-center">
<a class="btn btn-square mx-1" href=""><i
class="fab fa-facebook-f"></i></a>
<a class="btn btn-square mx-1" href=""><i
class="fab fa-twitter"></i></a>
 <a class="btn btn-square mx-1" href=""><i
class="fab fa-instagram"></i></a>
</div>
</div>
<div class="text-center p-4 mt-3">
<h5 class="fw-bold mb-0">Full Name</h5>
<small>Designation</small>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Team End -->

<br><br>
<jsp:include page="[Link]"></jsp:include>

<!-- Back to Top -->

<a href="#" class="btn btn-lg btn-primary btn-lg-square back-to-top"><i
class="bi bi-arrow-up"></i></a>
</div>

<!-- JavaScript Libraries -->

<script src="[Link]
<script
src="[Link]
</script>
<script src="lib/wow/[Link]"></script>
<script src="lib/easing/[Link]"></script>
<script src="lib/waypoints/[Link]"></script>
<script src="lib/owlcarousel/[Link]"></script>

<!-- Template Javascript -->

<script src="js/[Link]"></script>
</body>

</html>
[Link]
package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

import [Link];

/**
* Servlet implementation class AdminLogin
*/
@WebServlet("/AdminLogin")
public class AdminLogin extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException,
IOException {
try {
String uname = [Link]("uname");
String pass = [Link]("upass");
String vercode = [Link]("vercode");
String captchaDB = null;
HttpSession hs = [Link]();
String tokens = [Link]().toString();
Random random = new Random();
int newRandomCaptcha = [Link](9000) + 10000;
Connection con = [Link]();
Statement st = [Link]();
ResultSet captchResultSet = [Link]("select * from
tblcaptcha");
if ([Link]()) {
captchaDB = [Link](1);
}
if ([Link](vercode)) {
ResultSet resultset = [Link]("select * from tbladmin where uname='" + uname
+ "' AND upass='" + pass + "'");
if ([Link]()) {
[Link]("uname",[Link]("uname"));
[Link]("email", [Link]("email_id"));
int update = [Link]("update
tblcaptcha set captcha='"+ newRandomCaptcha + "'");
[Link]("[Link]?_tokens='" + tokens + "'");
} else {
String message = "You have enter wrong credentials";
[Link]("credential", message);
[Link]("[Link]");
int update = [Link]("update
tblcaptcha set captcha='"+ newRandomCaptcha + "'");
}
} else {
String message = "You have enter invalid verification code";
[Link]("verificationCode", message);
[Link]("[Link]");
int update = [Link]("update tblcaptcha set
captcha='"+ newRandomCaptcha + "'");
}
} catch (Exception e) {
// TODO: handle exception
}
}}
[Link]
package [Link];

import [Link];
import [Link];
import [Link];
import [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

import [Link];

/**
* Servlet implementation class AdminChangePassword
*/
@WebServlet("/AdminChangePassword")
public class AdminChangePassword extends HttpServlet {
private static final long serialVersionUID = 1L;

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException,

IOException {
String cpassword = [Link]("cpassword");
String password = [Link]("password");
String confpass = [Link]("confpass");
String pass = "";
HttpSession session = [Link]();
try {
Connection con = [Link]();
Statement statement = [Link]();
ResultSet resultset = [Link]("select upass from tbladmin where upass='" +
cpassword+ "' and uname='" + [Link]("uname") + "'");
if ([Link]()) {
pass = [Link](1);
}
if ([Link](confpass)) {
if ([Link](cpassword)) {
int i = [Link]("update tbladmin set upass='" + password + "'
where uname='" + [Link]("uname") + "' ");
String message = "Password change successfully.";
[Link]("password-change-success", message);
[Link]("[Link]");
} else {
String message = "Old password does not match.";
[Link]("password-change-fail", message);
[Link]("[Link]");
}
} else {
String message = "New password and confirm password does not match.";
[Link]("password-not-match", message);
 [Link]("[Link]");
}
} catch (Exception e) {
[Link]();
}
}}
[Link]
package [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

import [Link];

/**
* Servlet implementation class CustomerRegiser
*/
@WebServlet("/CustomerRegiser")
public class CustomerRegiser extends HttpServlet {
private static final long serialVersionUID = 1L;

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException,

IOException {
int customerId=[Link]([Link]("customerId"));
String cname=[Link]("cname");
String email=[Link]("email");
String mobile=[Link]("mobile");
String gender=[Link]("gender");
String address=[Link]("address");
String pincode=[Link]("pincode");
String uname=[Link]("uname");
String upass=[Link]("upass");
HttpSession hs=[Link]();
try {
int addCustomer=[Link]("insert into
tblcustomer(id,full_name,email_id,mobile_no,gender,address,pincode,uname,upass)
values('"+customerId+"','"+cname+"','"+email+"','"+mobile+"','"+gender+"','"+address+"','"+pincode+"','"+uname+"','"+upass
+"')");
if(addCustomer>0) {
String message="Customer account created successfully.";
[Link]("customer-account", message);
[Link]("[Link]");
}
}catch(Exception e) {
[Link]();
}
}

}
[Link]
package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

public class DatabaseConnection {

public static Connection connection;

public static Connection getConnection() {

try {
[Link]("[Link]");
connection = [Link]("jdbc:mysql://localhost:3306/onlinehouserent",
"root", "123456789");
} catch (Exception e) {
[Link]();
}
return (connection);
}

public static ResultSet getResultFromSqlQuery(String SqlQueryString) {

ResultSet rs = null;
try {
if (connection == null) {
getConnection();
}
rs = [Link]().executeQuery(SqlQueryString);
} catch (Exception ex) {
[Link]();
}
return rs;
}

public static int insertUpdateFromSqlQuery(String SqlQueryString) {

int i = 2;
try {
if (connection == null) {
getConnection();
}
i = [Link]().executeUpdate(SqlQueryString);

} catch (Exception ex) {

[Link]();
}
return i;
}

public static void CloseConnection() {

if (connection != null) {
try {
 [Link]();
} catch (SQLException ex) {
[Link]();
}
}
}

public static int generateCustomerId() {

int cid = 0;
Random random=new Random();
cid = [Link](999999);
[Link]("Customer Id " + cid);
return cid;
}

public static int generateMedicineId() {

int mid = 0;
Random random=new Random();
mid = [Link]((9999 - 100) + 1) + 10;
[Link]("Medicine Id " + mid);
return mid;
}
}
7.1 INTRODUCTION TO TESTING

Introduction to Testing:

Testing is a process, which reveals errors in the program. It is the major quality measure
employed during software development. During software development. During testing, the
program is executed with a set of test cases and the output of the program for the test cases is
evaluated to determine if the program is performing as it is expected to perform.

7.2 TESTING IN STRATEGIES

In order to make sure that the system does not have errors, the different levels of
testing strategies that are applied at differing phases of software development are:

Unit Testing:

Unit Testing is done on individual modules as they are completed and become
executable. It is confined only to the designer's requirements.

Each module can be tested using the following two Strategies:

Black Box Testing:

In this strategy some test cases are generated as input conditions that fully execute
all functional requirements for the program. This testing has been uses to find errors in the
following categories:

Incorrect or missing functions

Interface errors
Errors in data structure or external database access
Performance errors
Initialization and termination errors.
In this testing only the output is checked for correctness.
The logical flow of the data is not checked.
White Box testing:

In this the test cases are generated on the logic of each module by drawing flow
graphs of that module and logical decisions are tested on all the cases. It has been uses to
generate the test cases in the following cases:

✓ Guarantee that all independent paths have been Executed.

✓ Execute all logical decisions on their true and false Sides.
✓ Execute all loops at their boundaries and within their operational bounds
✓ Execute internal data structures to ensure their validity.
Integrating Testing :
Integration testing ensures that software and subsystems work together a whole. It
tests the interface of all the modules to make sure that the modules behave properly
when integrated together.
System Testing :
Involves in-house testing of the entire system before delivery to the user. It's aim is to
satisfy the user the system meets all requirements of the client's specifications.

Acceptance Testing :

It is a pre-delivery testing in which entire system is tested at client's site on real world data
to find errors.
Test Approach :
Testing can be done in two ways:

Bottom up approach
Top down approach
Bottom up Approach:

Testing can be performed starting from smallest and lowest level modules and proceeding
one at a time. For each module in bottom up testing a short program executes the module and
provides the needed data so that the module is asked to perform the way it will when embedded
with in the larger system. When bottom level modules are tested attention turns to those on the next
level that use the lower level ones they are tested individually and then linked with the previously
examined lower level modules.

Top down approach:

This type of testing starts from upper level modules. Since the detailed activities
usually performed in the lower level routines are not provided stubs are written. A stub is a
module shell called by upper level module and that when reached properly will return a
message to the calling module indicating that proper interaction occurred. No attempt is
made to verify the correctness of the lower level module.
Validation:

The system has been tested and implemented successfully and thus ensured that all the
requirements as listed in the software requirements specification are completely fulfilled. In
case of erroneous input corresponding error messages are displayed
 8.1 INTRODUCTION

System Security:

Setting Up Authentication for Web Applications

Introduction:
To configure authentication for a Web Application, use the <login-config> element of the
[Link] deployment descriptor. In this element you define the security realm containing the
user credentials, the method of authentication, and the location of resources for authentication.
8.2 SECURITY IN SOFTWARE

To set up authentication for Web Applications:

1. Open the [Link] deployment descriptor in a text editor or use the Administration
Console. Specify the authentication method using the <auth-method> element. The
available options are:

BASIC

Basic authentication uses the Web Browser to display a username/password dialog

box. This username and password is authenticated against the realm.
FORM

Form-based authentication requires that you return an HTML form containing the
username and password. The fields returned from the form elements must be:
j_username and j_password, and the action attribute must be j_security_check. Here is
an example of the HTML coding for using FORM authentication:
<form method="POST" action="j_security_check">
<input type="text" name="j_username">
<input type="password" name="j_password">
</form>
The resource used to generate the HTML form may be an HTML page, a JSP, or a
servlet. You define this resource with the <form-login-page> element.

The HTTP session object is created when the login page is served. Therefore, the
[Link]() method returns FALSE when called from pages served after successful
authentication.
9. BIBLIOGRAPHY

References for the Project Development Were Taken From the following
Books and Web Sites.

JAVA Technologies

JAVA Complete Reference

Java Script Programming by Yehuda Shiran

Mastering JAVA Security

JAVA2 Networking by Pistoria

JAVA Security by Scotl oaks

Head First EJB Sierra Bates

J2EE Professional by Shadab siddiqui

JAVA server pages by Larne Pekowsley

JAVA Server pages by Nick Todd

HTML

HTML Black Book by Holzner

JDBC

Java Database Programming with JDBC by Patel moss.

Software Engineering by Roger Pressman