Major Project Report on PACKERS AND MOVERS by ravisharma20

VIEWS: 539 PAGES: 109

									                 PACKERS AND MOVERS




           A MAJOR PROJECT REPORT SUMITTED TO


Rajeev Gandhi Proudyogiki Vishwavidyalaya, Bhopal
     Towards partial fulfillment for the award of the degree   of

                     Bachelor of Engineering
                                  IN
          COMPUTER SCIENCE AND ENGINEERING

                         Under the Guidance of

                      Prof. Rupali Pathak


                              Submitted by
                             Ravi Sharma
                           [0863CS081045]


              Department of Computer Science & Engineering

Prestige Institute of Engineering and Science, Indore (M.P.)
                               MAY 2012
                PACKERS AND MOVERS




          A MAJOR PROJECT REPORT SUBMITTED

       Towards partial fulfillment for the award of the degree

                                  of

                     Bachelor of Engineering
                                  IN
          COMPUTER SCIENCE AND ENGINEERING

                         Under the Guidance of
                        Prof. Rupali Pathak


                              Submitted by
                  Ravi Sharma [0863CS081045]




              Department of Computer Science & Engineering

Prestige Institute of Engineering and Science, Indore (M.P.)
                               MAY 2012


                                       I
 RAJIV GANGHI PROUDYOGIKI VISHWAVIDYALAYA,
                                     BOHPAL




College Name       :   PRESTIGE INSTITUTE OF ENGINEERNING AND SCIENCE

Branch             :   Computer Science and Engineering

Year               :   Fourth Year

Semester           :   Eight Semester

Title of Project   :   PACKERS AND MOVERS

Enrollment No      :   0863CS081045, 0863CS081034, 0863CS081015, 0863CS081019

Name of Student :      Ravi Sharma, Monika Dave, Avanish Gupta, Chetna Deokar

E-mail             :   ravisharma.india@hotmail.com, er.monikadave@gmail.com,
                          erakgupta.cs@gmail.com, er.chetnadeokar@gmail.com

Name of Guide      :   Prof. Rupali Pathak

Designation        :   Head of Department, Computer Science and Engineering

Software Used in Project: Net Beans 7.1, Apache Tomcat, Glass Fish




                                                    SIGNATURE



                                                    Prof. Rupali Pathak

                                                    PROJECT GUIDE

                                                    HEAD OF THE DEPARTMENT
                                                    Computer Science & Engineering



                                             II
    PRESTIGE INSTITUTE OF ENGINEERING & SCIENCE,
                       INDORE




             CERTIFICATE OF AUTHENTICTED WORK
This is to certify that Ravi Sharma (0863CS081045) of Fourth year, Computer Science &
Engineering year 2011-12 have completed their project work on Packers and Movers and
have submitted their project report as partial fulfillment of the requirement of Rajiv Gandhi
Proudhyogiki Vishwavidyalaya, Bhopal for award of the degree of Bachelor of Engineering
(C.S.E.) It is a bona fide presentation of work by them under our guidance and supervision.

       I am fully responsible for the matter embodied in this report and it has not been submitted
elsewhere for the award of any other degree.




SIGNATURE                                                     NAME OF STUDENT

Prof. Rupali Pathak                                           Ravi Sharma

PROJECT GUIDE,                                                (0863CS081045)
HEAD OF THE DEPARTMENT
Computer Science and Engineering

Date:……………..




                                                 III
   PRESTIGE INSTITUTE OF ENGINEERING & SCIENCE,
                      INDORE




                             RECOMMENDATION


This is to certify that Ravi Sharma (0863CS081045) of Fourth year, Computer Science &
Engineering year 2011-12 have completed their project work on Packers and Movers and
have submitted their project report as partial fulfillment of the requirement of Rajiv Gandhi
Proudhyogiki Vishwavidyalaya, Bhopal for award of the degree of Bachelor of Engineering
(C.S.E.). It is a bona fide presentation of work by them under our guidance and supervision.




SIGNATURE                                                  SIGNATURE




Dr. Dilip R. Pangavhane                                    Prof. Rupali Pathak

DIRECTOR                                                   PROJECT GUIDE

PIES, INDORE                                               HEAD OF THE DEPARTMENT
                                                           Computer Science & Engineering




                                               IV
   PRESTIGE INSTITUTE OF ENGINEERING & SCIENCE,
                      INDORE




                                   CERTIFICATE


This is to certify that Ravi Sharma (0863CS081045) of Fourth year, Computer Science &
Engineering year 2011-12 have completed their project work on Packers and Movers and
have submitted their project report as partial fulfillment of the requirement of Rajiv Gandhi
Proudhyogiki Vishwavidyalaya, Bhopal for award of the degree of Bachelor of Engineering
(C.S.E.). It is a bona fide presentation of work by them under our guidance and supervision.




Internal Examiner                                                 External Examiner


Date:                                                             Date:




                                               V
                                                                    Packers and Movers   2012



                              ACKNOWLEDGEMENT
       I express my sincere gratitude towards Prof. Rupali Pathak, Head of the Department of
Computer Science & Engineering and Information Technology and also the Guide of our team
for providing us valuable support and necessary help whenever required and also helping us
explore new technologies by the help of their technical support.
       Also I would like to thank Ms. Nidhi Chhajed, Mentor of our team for providing the
necessary help.
        I also like to express My sincere gratitude towards Director Dr. Dilip R. Pangavhane,
Prestige institute of Engineering & Science, Chairman Shri. N.N.Jain, Prestige Education
Society, and Advisor Sir Prof. H.S.Mehta, for providing us valuable support.
       I forward my sincere thanks to all Teaching and Non-Teaching Staff of Computer
Science and Engineering Department, PIES, Indore for providing necessary information and kind
co-operation.
        I would like to thank my classmates for their motivation and there valuable suggestions
during the project work.
        A blind of gratitude, pleasure and great satisfaction, is what I feel to convey my ineptness
to all who have directly or indirectly contributed to the successful completion of my project
work.
       In addition I would also like to thank to Prof. Jaya Thomas, IIT Indore for there ever
ready supporting and providing us valuable information during completion of this project work.
        Finally, I express my Love and respect towards my Family Members who are my
strength in every work I do.




                                                                            Ravi Sharma
                                                                           (0863CS081045)




                                                 VI
         Packers and Movers   2012




ABSTRACT




   VII
                                                                Packers and Movers   2012



                                  ABSTRACT
      Packers and Movers is a web based application that is designed to be
deployed on internet and provide functionality to every type of user. This
application is basically a web Portal designed to get interaction between different
clients and Packing and Moving Companies. Packers and Movers is an online
platform for service seekers and service providers. We have listed excellent
packing moving service providers of India, household shifting & relocation
services providers, car transportation, office relocation, home, shop, industrial or
commercial shifting service providers of India. Our packers and movers directory
is having ultimate objective of providing information to its visitors about best
packers movers and relocation companies offering its services in India. The
reliable and swift packers and movers services providers are the best for any kind
of relocation and car transportation services. According to requirement gathered
and the technologies used to realize those requirements are best utilized to achieve
that functionality. The Packers and Movers Web Portal gives a platform through
which clients and different packing and moving companies can communicate and
use the services provided by this portal.



      Keywords:      household    shifting,        relocation   services    providers,      car
transportation, office relocation, home, shop, industrial or commercial shifting




                                            VIII
        Packers and Movers   2012




TABLE OF
CONTENTS




   IX
                                                          Packers and Movers   2012



                                   CONTENTS
Chapter     Title                                                Page No.
     Certificate of Authenticated work                           III
     Recommendation                                              IV
     Certificate                                                 V
     Acknowledgement                                             VI
     Abstract                                                    VIII
     Table of Content                                            X
     List of Figures                                             XIII

   1.       Introduction                                         1
              1.1. Background                                    2
              1.2. Problem Definition                            2
              1.3. Proposed System                               3
                    1.3.1. Objectives                            4
                    1.3.2. Purpose                               4
                    1.3.3. Scope                                 5
                    1.3.4. Applicability                         5
              1.4. Achievements                                  5
              1.5. Organization of Report                        5

   2.       Literature Review                                    6
              2.1. System Review                                 7
              2.2. Technology Used                               7
                     2.2.1. Java                                 7
                     2.2.2. MYSQL Database                       10
                     2.2.3. Net Beans Platform                   11
                     2.2.4. Net Beans IDE 7.1                    12
                     2.2.5. Apache Tomcat Server                 12
                     2.2.6. HTML                                 13
   3.       Requirement Gathering                                14
              3.1. Information Gathering                         15
              3.2. Software Requirements                         16
                     3.2.1. User Interfaces                      16
                     3.2.2. Hardware Interfaces                  16
                     3.2.3. Software Interfaces                  16
              3.3. Functional Requirements                       17
              3.4. Non Functional Requirements                   18
                     3.4.1. Software Interfaces                  18
                     3.4.2. Safety Requirements                  19
                     3.4.3. Software Quality Attributes          19



                                             X
                                                    Packers and Movers   2012


Chapter   Title                                            Page No.
   4.     Detailed Design                                  21
           4.1. System Analysis                            22
           4.2. Conceptual Models                          23
                  4.2.1. Use Case Diagram                  23
                  4.2.2. Use Case Description              24
                  4.2.3. Class Diagram                     25
                  4.2.4. Sequence diagram                  26
                  4.2.5. Collaboration diagram             29
                  4.2.6. Activity Diagram                  32
                  4.2.7. Data Flow Diagram                 38

   5.     Implementation and Testing                       43
            5.1. Implementation Phases                     44
                   5.1.1. Module Structure                 44
                   5.1.2. Data Models                      48
                   5.1.3. Database Design                  50
                   5.1.4. Entity Relation Diagram          51
            5.2. Test Cases                                52
                   5.2.1. White Box Testing                52
                   5.2.2. Unit Testing                     52
                   5.2.3. Integration Testing              53
                   5.2.4. System Testing                   53
                   5.2.5. Black Box Testing                54

   6.     Output Screens and Coding                        55
           6.1. Screen Shorts and Test Report              56
           6.2. Important Coding                           70

   7.     Conclusions                                      87
           7.1. Conclusion                                 88
           7.2. Limitation of the System                   88
           7.3. Future scope of the project                88

   A.     References                                       90
   B.     Glossary                                         93
   C.     Appendices                                       95




                                          XI
          Packers and Movers   2012




LIST OF
FIGURES




   XII
                                                           Packers and Movers   2012



                                    FIGURES
Sr.No .   Diagrams                                                Page No.

   1.     Use case Diagram                                        23
   2.     Class Diagram                                           25
   3.     Administrator Sequence Diagram                          26
   4.     Agents Sequence Diagram                                 27
   5.     User Sequence Diagram                                   28
   6.     Collaboration Diagram for Administrator                 29
   7.     Collaboration Diagram for Agents                        30
   8.     Collaboration Diagram for Users                         31
   9.     Activity Diagram for Administrator                      32
   10.    Activity Diagram for Agents                             33
   11.    Activity Diagram for User                               34
   12.    Context Level Data Flow Diagram                         35
   13.    Level One Data Flow Diagram                             36
   14.    Level Two Data Flow Diagram for Agents Records          37
   15.    Level Two Data Flow Diagram for Feedback                38
   16.    Level Two Data Flow Diagram for Quotations              39
   17.    Module Structure                                        41
   18.    Data Models                                             42
   19.    Data Storage System                                     44
   20.    Entity Relation Diagram                                 45




                                        XIII
               Packers and Movers   2012




   CHAPTER 1

INTRODUCTION




       1
                                                                   Packers and Movers    2012


1.1   BACKGROUND
               There are lot of web sites are working for the Packers and Movers. These
      websites provides limit information to the different types of users, and these are limited
      to few Companies and Agents. A user go to this sites and give his queries and the
      company will personally contact to him and this all such process do not gives a well
      communications.
               So our web portal helps clients to search the best Packing and Moving Company.


1.2   PROBLEM DEFINITION
               The main problem that we face during shifting our goods and households is that
      either to take all the goods or to leave some of it or to sold them out. To handle such kind
      of problem the role of Packers and movers agencies comes into action. This agency
      works according to the needs and requirement of the customers and provide them the
      desirable results. The packers and movers agencies uses best quality packing materials to
      pack our goods in such a way that all goods remain in safe condition during transit &
      moving services assure the safe delivery of our goods at our destination. Relocation to
      new place needs expert packing and moving company to handle all aspects of packing
      and moving. Moving companies have all latest devices, trucks, containers to provide safe
      pack and move to the destination. Therefore to handle all the problem of packing the
      goods and moving them from one place to another the packers and movers agencies are
      hired.

               It is seen that there are many agencies are working for this and all of these
      agencies has their own websites to give their service information and a user has to visit to
      individual sites, to overcome this problem we have designed a web portal so that all the
      companies register over it and user get the information on one single site only.




                                               2
                                                                      Packers and Movers    2012


1.3   PROPOSED SYSTEM

              Packers and Movers is an online platform for service seekers and service
      providers where all the companies are available at single site as web portal and they do
      communicate directly with service seekers. In Packers and Movers we have listed
      excellent packing moving service providers of India, household shifting and relocation
      services providers, car transportation, office relocation, home, shop, industrial or
      commercial shifting service providers of India. Our packers and movers directory is
      having ultimate objective of providing information to its visitors about best packers
      movers and relocation companies offering its services in Indian destinations. The reliable
      and swift packers and movers services providers are the best for any kind of relocation
      and car transportation services.

              There are many packers and movers operating in India but all of them are not well
      established and experienced companies. It becomes difficult for you to choose best and
      reliable packers and movers in your city when you need to relocate your house, office and
      other interrelated services our mission is to offer you those packers and movers which
      provide packing moving services with full responsibility and reliability. The listed
      companies will provide door to door services within an appropriate time. Their
      professional management takes care of your every single need. These companies promise
      to provide trouble free packing and moving services with economical cost.

              Whenever you need to store your goods you don’t have to search for warehousing
      storage service providers. Now Packers and Movers also provide storage and
      warehousing storage services providers at reasonable rate with full safety and security.
      Goods can be store in stock room for short and long duration. The warehouse has an
      absolute security and climate control system.

              Relocating your house, offices, industries and corporate can be very simple and
      hassle free. Since relocation task involves lot of paper works like custom clearance,
      insurance, visa clearance, etc. Packers & Movers offers you most excellent and top class
      relocation service providers. These packers and movers operate with full efficiency and accuracy.




                                                  3
                                                                Packers and Movers   2012


1.3.1 OBJECTIVES

           The main aim of the packers and movers online application is to provide different
    services such as:

    Packing and Moving:

           The Packers and Movers companies listed here uses best quality packing
    materials to pack your goods in such a way that all goods remain in safe condition during
    transit & moving services assure the safe delivery of your goods at your destination.

    Relocation Services:

           Relocation to new place needs expert packing and moving company to handle all
    aspects of packing and moving. Moving companies have all latest devices, trucks,
    containers to provide safe pack and move to the destination.

    Car Services:

           The loving car is a major trouble while shifting to another city or far location.
    Thanks to car movers companies, that they have special car carriers to provide car
    moving, car shifting services very easy and trouble free.

    Household Shifting:

       Household shifting is to be done by the experts who know how to handle various
    household goods. Great care is needed to make safe shifting & the companies using best
    packaging materials to provide excellent house shifting services are here.



1.3.2 PURPOSE
           The purpose of this Project is to give and interactive platform for clients and
    different Packing and Moving Companies so that a best and reliable services is provided
    through this Web Portal. This Portal also giving useful information to users and
    companies that help them a lot.




                                             4
                                                                    Packers and Movers   2012


1.3.3 SCOPE
             This is a web based application so it is having much scope over the internet. It
      helps to provide best and reliable services to clients. All the small scale and big scale
      companies can access it and may spread their organization to worldwide.


1.3.4 APPLICABILITY
      Our Project is intended to be used over internet as Packers and Movers Web Portal.


1.4   ACHIEVEMENTS
      •   We understood how to work within a team.
      •   We understood how to build enterprise application.
      •   We understood how to deal with real life application.
      •   We understood how web server and database server interacts and work.


1.5   ORGANIZATION OF REPORT
             The project report till gives only the introduction to application and the
      description that follows gives you detail of what the system is and how system works.
             The most important part to follow in report is how we have realized our project
      including technologies and tools used, requirement analysis, how we planned to meet
      deadlines, software and hardware requirements.
             Various conception models including class diagram, sequence diagram, use case
      diagram, activity diagram, ER diagrams and others.
             Then follows system design that include basic modules, data design, procedural
      design, user interfaces, security issues and test cases design.
             Finally report consists of implementing and testing details and at last conclusion,
      future extension and improvements.




                                                5
              Packers and Movers   2012




  CHAPTER 2

LITERATURE
 REVIEW




      6
                                                                     Packers and Movers   2012


   2.1 SYSTEM REVIEW

       Our team has made a review at different levels to get the need and requirement of people.
Our team made aim to conduct this review is to understand the need of the project very clearly,
to do so we have made a review through several research papers and sites to search the necessary
information.
       From the review we got new ideas and views which helped us to make our plan and
strategy for the project. We also surveyed and analyzed the available software of such kind in
market and felt that there is good scope of improvisation in this field.


       Outcome of the reviewed feature that can be added to software
               1. Drawback of existing software
               2. Be realistic
               3. Consider risk factor
               4. Product should be cost effective
               5. Product should be user friendly
               6. Product must satisfy that time constraint



   2.2 TECHNOLOGY USED

       2.2.1   JAVA

               Java is a programming language originally developed by James Gosling at Sun
       Microsystems (which is now a subsidiary of Oracle Corporation) and released in 1995 as
       a core component of Sun Microsystems' Java platform. The language derives much of
       its syntax from C and C++ but has a simpler object model and fewer low-level facilities.
       Java applications are typically compiled to byte code (class file) that can run on any Java
       Virtual Machine (JVM) regardless of computer architecture. Java is general-purpose,
       concurrent, class-based, and object-oriented, and is specifically designed to have as few
       implementation dependencies as possible. It is intended to let application developers
       "write once, run anywhere". Java is considered by many as one of the most influential
       programming languages of the 20th century, and is widely used from application
       software to web applications [1] [2].



                                                  7
                                                            Packers and Movers   2012


The most important and powerful feature of java as a programming language is that it is
platform independent. The term platform independent means that java doesn't need a
specific vendor oriented platform to run. It can be run on any of the existing platforms
and would produce the same output. Thus, whether I run java on windows, UNIX, Linux
or Macintosh, I would get the same desired result. Contrast this with .net which can only
be used with windows. So, java is the only option we are left with for developing web
based application. This is because internet is a network of millions of computers having
different types of hardware and software. So, we definitely need a platform independent,
easy to understand language to develop web based applications which can be distributed
over any network and yet produce same result. That is why java is used in web
applications. In fact, java is so powerful that it is now also being used to develop mobile
applications like games [3] [4].



2.2.1.1   JAVA FEATURES
a) Simple: Java was designed to be easy for the professional programmer to learn and
   use effectively. If one has some programming experience, he will not find Java hard to
   master. If you already understand the basic concepts of object-oriented programming,
   learning Java will be even easier. Best of all, if you are an experienced C++
   programmer, moving to Java will require very little effort. Because Java inherits the
   C/C++ syntax and many of the object-oriented features of C++, most programmers
   have little trouble learning Java. Also, some of the more confusing concepts from C++
   are either left out of Java or implemented in a cleaner, more approachable manner.
   Beyond its similarities with C/C++, Java has another attribute that makes it easy to
   learn: it makes an effort not to have surprising features. In Java, there are a small
   number of clearly defined ways to accomplish a given task.
b) Object-Oriented: The object model in Java is simple and easy to extend, while
   simple types, such as integers, are kept as high-performance nonobjects. One outcome
   of this was a clean, usable, pragmatic approach to objects [5].
c) Robust: The multiplatform environment of the Web places extraordinary demands on
   a program, because the program must execute reliably in a variety of systems. Thus,




                                         8
                                                            Packers and Movers   2012


   the ability to create robust programs was given a high priority in the design of Java. To
   gain reliability, Java restricts you in a few key areas, to force you to find your
   mistakes early in program development. At the same time, Java frees you from having
   to worry about many of the most common causes of programming errors. Because
   Java is a strictly typed language, it checks your code at compile time. However, it also
   checks your code at run time.
d) Multithreaded: Java was designed to meet the real-world requirement of creating
   interactive, networked programs. To accomplish this, Java supports multithreaded
   programming, which allows you to write programs that do many things
   simultaneously. Threads are the light weight processes. The Java run-time system
   comes with an elegant yet sophisticated solution for multiprocessing synchronization
   that enables you to construct smoothly running interactive systems. Java’s easy-to-use
   approach to multithreading allows you to think about the specific behavior of your
   program, not the multitasking subsystem.
e) Architecture-Neutral: A central issue for the Java designers was that of code
   longevity and portability. One of the main problems facing programmers is that no
   guarantee exists that if you write a program today, it will run tomorrow—even on the
   same machine. Operating system upgrades, processor upgrades, and changes in core
   system resources can all combine to make a program malfunction. JAVA is base on
   the goal - “write once; run anywhere, anytime, forever.” To a great extent, this goal is
   accomplished.
f) Interpreted and High Performance: Java enables the creation of cross-platform
   programs by compiling into an intermediate representation called Java byte code. This
   code can be interpreted on any system that provides a Java Virtual Machine.
g) Distributed: Java is designed for the distributed environment of the Internet, because
   it handles TCP/IP protocols. In fact, accessing a resource using a URL is not much
   different              from                accessing                a                file.


h) Dynamic: Java programs carry with them substantial amounts of run-time type
   information that is used to verify and resolve accesses to objects at run time. This
   makes it possible to dynamically link code in a safe and expedient manner. This is



                                         9
                                                                   Packers and Movers   2012


        crucial to the robustness of the applet environment, in which small fragments of byte
        code may be dynamically updated on a running system.


     2.2.2 MYSQL DATABASE


             MySQL is an open source Relational Database Management System. MySQL is
     very fast reliable and flexible Database Management System. It provides a very high
     performance and it is multi threaded and multi user Relational Database management
     system [6].

             MySQL is one of the most popular relational databases Management System on
     the web. The MySQL Database has become the world's most popular open
     source Database, because it is free and available on almost all the platforms. The MySQL
     can run on UNIX, window, and Mac OS. MySQL is used for the internet applications as
     it provides good speed and is very secure. MySQL was developed to manage large
     volumes of data at very high speed to overcome the problems of existing solutions.
     MySQL can be used for verity of applications but it is mostly used for the web
     applications on the internet [7].

MySQL Features

  1. MySQL are very fast and much reliable for any type of application.
  2. MySQL is very Lightweight application.
  3. MySQL command line tool is very powerful and can be used to run SQL queries against
     database.
  4. MySQL supports indexing and binary objects.
  5. It is allow changes to structure of table while server is running.
  6. MySQL has a wide user base.
  7. It is a very fast thread-based memory allocation system.
  8. MySQL Written in C and C++ language.
  9. MySQL code is tested with different compilers.
  10. MySQL is available as a separate program for use in a client/server network environment.




                                               10
                                                                Packers and Movers   2012



11. The MySQL available for the most UNIX operating platform.
12. MySQL are the available for window operating system window 98, window XP, and
   window 7.
13. Programming libraries for C, , PHP, Java etc. are available to connect to MySQL
   database [8].

MySQL Advantages:


Reliability and Performance: MySQL is very reliable and high performance relational
database management system. It can used to store many GB's of data into database.


Availability of Source: MySQL source code is available that's why now you can recompile
the source code.


Cross-Platform support: MySQL supports more than twenty different platform including
the major Linux distribution .Mac OS X, UNIX and Microsoft windows.


Large pool of Trained and Certified Developers: MySQL is very popular and it is world
most popular open source Database. So it is easy to find high quality staff around the world.


Powerful Uncomplicated software: The MySQL has most capabilities to handle most
corporate database application and used to very easy and fast [9].




   2.2.3 NET BEANS PLATEFORM

           Net Beans refers to both a platform for the development of applications for the
   network and an integrated development environment (IDE) developed using the Net
   Beans Platform [10]. The Net Beans Platform allows applications to be developed from a
   set of modular software components called modules. Net Beans refers to both
   a platform framework for Java desktop applications, and an integrated development
   environment (IDE) for developing. The Net Beans IDE is written in Java and runs




                                            11
                                                            Packers and Movers   2012


everywhere where a JVM is installed. The platform offers reusable services common to
desktop applications, allowing developers to focus on the logic specific to their
application. The Net Beans Platform provides reliable and flexible application
architecture. Your application does not have to look anything like an IDE. It can save you
years of development time. The Net Beans Platform gives you a time-tested architecture
for free. An architecture that encourages sustainable development practices. Because the
Net Beans Platform architecture is modular, it's easy to create applications that are robust
and extensible [11].



2.2.4   Net Beans IDE 7.1

        The Net Beans IDE is a free, open-source Integrated Development Environment
for software developers. The IDE runs on many platforms including Windows, Linux,
and the Mac OS. It is easy to install and use straight out of the box. The Net Beans IDE
provides developers with all the tools they need to create professional cross-platform
desktop, enterprise, web and mobile applications.



2.2.5 APACHE TOMCAT SERVER

        Apache Tomcat (or Jakarta Tomcat or simply Tomcat) is an open source servlet
container developed by the Apache Software Foundation (ASF). Tomcat implements
the Java Servlet and the Java Server Pages (JSP) specifications from Sun Microsystems,
and provides a “pure Java” HTTP web server environment for Java code to run. Tomcat
is an application server from the Apache Software Foundation that executes Java servlets
and renders Web pages that include Java Server Page coding. Described as a "reference
implementation" of the Java Servlet and the Java Server Page specifications, Tomcat is
the result of an open collaboration of developers and is available from the Apache Web
site in both binary and source versions. Tomcat can be used as either a standalone product
with its own internal Web server or together with other Web servers, including Apache,
Netscape Enterprise Server, Microsoft Internet Information Server (IIS), and
Microsoft Personal Web Server. Tomcat requires a Java Runtime Enterprise Environment




                                         12
                                                             Packers and Movers   2012


that conforms to JRE 1.1 or later. Tomcat is one of several open source collaborations
that are collectively known as Jakarta. The Tomcat server is a Java based Web
Application container that was created to run Servlets and Java Server Pages (JSP) in
Web applications. As part of Apache's open source Jakarta project, it has nearly become
the industry accepted standard reference implementation for both the Servlets and JSP
API. Tomcat server is an open source project of Java Servlet and JSP technologies
developed under the Jakarta project at the Apache Software Foundation. The most
popular tomcat server versions are: Tomcat 4.1.31, Tomcat 5.0.29 and Tomcat 6.0.11.
Tomcat4 server working with jdk 1.4, while Tomcat5 & Tomcat6 require jdk 1.5 or jdk
1.6 [12] [13].



2.2.6 HTML

       HTML,          which   stands   for Hypertext     Markup      Language,      is   the
predominant markup language for web. HTML is not a programming language, it is
a markup language. A markup language is a set of markup tags. HTML uses markup
tags to describe web pages. It provides a means to create structured documents by
denoting structural semantics for text such as headings, paragraphs, lists etc as well as for
links, quotes, and other items. It allows images and objects to be embedded and can be
used to create interactive forms. It is written in the form of HTML elements consisting of
"tags" surrounded by angle brackets within the web page content. It can include or can
load scripts in languages such as JavaScript which affect the behavior of HTML
processors like Web browsers to define the appearance and layout of text and other
material [14] [15].




                                         13
               Packers and Movers   2012




   CHAPTER 3

REQUIREMENT
 GATHERING




       14
                                                                     Packers and Movers   2012


   3.1           INFORMATION GATHERING

            Information Gathering refers to the act of understanding the nature of program. In our
   project information gathering mainly includes analyzing software development in order to
   gather information about different fields.

       It mainly includes:-

            1. About Functionalities

            2. About Database

            3. About Front-end Design

       1)        About Functionalities – Here we analyze what the essential requirements of our
       project i.e. the basic functionalities of a web portal and the different modules of a web
       portal.

       2)        About Database – In this we analyzed data about different entities considering
       their relationships. Database will be designed accordingly.

       3)        Front-End Design –The analysis give us an idea about better interactivity and
       help us to make a user friendly interface. It also helps to maintain a proper flow.



       By doing meeting with prospective clients we came to know all their requirements and
problems hidden in the system. By meeting we have understood all the requirements and
functionality that they expect from system.

            In questionnaires we asked many questions related to the different types of
competencies and how the tool will give a positive response from the subordinates. In
questionnaires we got the complete scenario of the working and rules & regulations associated
with their system.




                                                15
                                                                   Packers and Movers      2012


3.2           SOFTWARE REQUIREMENTS
      3.2.1          USER INTERFACE

              The user interface (also known as human computer interface or man-machine
  interface (MMI))        is    the   aggregate    of   means   by    which    people       the users
  interact with the system.

  For the user to use our application easily and efficiently, we will be providing a user-
  friendly GUI that contains text fields, buttons, etc.

  •      The buttons will provide options for the user to select a particular operation.

  •      The text boxes and text fields will provide a user interface to specify the option while
         selecting an action.

  •      The user needs to have an internet browser to utilize the web crawler.



      3.2.2          HARDWARE INTERFACE

              The hardware interfaces defines the hardware devices needed for an application to
  run such as type of processor and the amount of memory required.

  a) Any processor of Pentium, recommended Intel C2D processor.

  b) Free Secondary memory (Min 1 G.B. recommended free space).

  c) Min 64MB, Recommended 512 MB of Main Memory.



      3.2.3          SOFTWARE INTERFACE
      a) Client on Internet: Web Browser, Operating System (any)
      b) Data Base Server: MY SQL, Operating System (any)
      c) Development End: Net beans IDE 7.1, MY SQL, OS (Windows), Web Server.




                                              16
                                                                 Packers and Movers   2012


3.3        FUNCTIONAL REQUIREMENT
       Functional requirements define the internal workings of the software that is, the
calculations, technical details, data manipulation and processing and other specific
functionality that show how the use cases are to be satisfied. Functional requirements specify
particular behaviors of a system. A typical functional requirement will contain a unique name
and number, a brief summary, and a rationale. This information is used to help the reader
understand why the requirement is needed, and to track the requirement through the
development of the system.
       The core of the requirement is the description of the required behavior, which must
be a clear and readable description of the required behavior. This behavior may come from
organizational or business rules, or it may be discovered through elicitation sessions with
users, stakeholders, and other experts within the organization. Many requirements will be
uncovered during the use case development. When this happens, the requirements analyst
should create a placeholder requirement with a name and summary, and research the details
later, to be filled in when they are better known. Software requirements must be clear,
correct, unambiguous, specific, and verifiable

   The basic functional requirements of the system are as follows:

   •   Local Search Engine: The local search engine in this system lists all the packers and
       Movers companies that are registered in this web portal so that clients are reliably
       access the services provided by these companies.
   •    Agent Registration: Agents such as Packing and Moving companies first have to
       register on this portal so that they can view all the Quotations placed over this portal.
   •   Quotations: Clients has to place the Quotation so that a reliable and suitable
       Company directly contacts him to give the services they provided.
   •   Login system: Through this login system we are providing special services so to
       access this services a user must have to login the system.
   •   Profile Updating: Through this functionality agents can manage their profile so that
       they can update their profile if required.




                                             17
                                                                        Packers and Movers   2012


3.4           NONFUNCTIONAL REQUIREMENT

              In    systems     engineering   and        requirements   engineering,   non-functional
      requirements are requirements, which specify criteria that can be used to judge the
      operation of a system, rather than specific behaviors. This should be contrasted with
      functional requirements that specify specific behavior or functions. Typical non-
      functional requirements are reliability, scalability, and cost. Non-functional requirements
      are often called the utilities of a system.

              The basic non-functional requirements of the system are:

              •    Secure access of confidential data such as agents’ information.
              •    24 X 7 availability.
              •    Better component design to get better performance at peak time.
              •    Flexible services based architecture will be highly desirable for future
                   extension.
              •    User can see the list of tips that are provided on portal which helps them
                   during moving and packing of goods.
              •    User can calculate the distances between the cities.
              •    User can calculate the weight and volume of their goods.



      3.4.1           SOFTWARE INTERFACE

              While deciding the performance of any software, its speed, response time,
      throughput, resource utilization & efficiency must be taken into consideration.

      The Web Crawler software has:

              •    Processing speed           :          Fast

              •    Response Time              :          Medium

              •    Throughput                 :          Optimized

              •    Resource consumption :                 Medium

              •    Efficiency                 :          Very good



                                                    18
                                                             Packers and Movers   2012


3.4.2          SAFETY REQUIREMENTS
        The database has to be saved from being corrupted. The backup of the database
should be taken automatically after regular intervals of time.


3.4.3          SOFTWARE QUALITY ATTRIBUTES


a) Reliability: The reliability is the mean time to failure; accordingly to have higher
    reliability the mean time to failure should be very large. This software provides
    relevant results and these results would be quick.


b) Usability: Usability refers to circumstances or area where the software can be used
    efficiently. Also the database should be easily and efficiently accessed.



c) Scalability: Scalability refers to the way that whether the web crawler is to scale the
    maximum of the entire web. It should fetch the maximum number of web documents.


d) Availability: The most recent and updated data from the database must be available
    to the search engine.



e) Correctness: The user must get the accurate reply to the query he has asked for. The
    data deliver to the user must correct and up to the mark.


f) Flexibility: With some minor adjustments the Web Crawler system should be
    suitable for various scenarios. However, it is important to remember that crawling is
    established within a specific framework.




                                         19
                                                           Packers and Movers   2012


g) High Performance: The system needs to be scalable with a minimum of thousand
   pages/second and extending up to millions of pages for each run on low cost
   hardware. Note that here; the quality and efficiency of disk access are crucial to
   maintaining high performance.


h) Fault Tolerance: This may cover various aspects. As the system interacts with
   several servers at once, specific problems emerge. First, it should at least be able to
   process invalid HTML code, deal with unexpected Web server behavior and select
   good communication protocols etc. The goal here is to avoid this type of problem
   and, by force of circumstance, to be able to ignore such problems completely.
   Second, crawling processes may take days or weeks, and it is imperative that the
   system can handle failure, stopped processes or interruptions in network services,
   keeping data loss to a minimum. Finally, the system should be persistent, which
   means periodically switching large data structures from memory to the disk (e.g.
   restart after failure).



i) Maintainability: An appropriate interface is necessary for monitoring the crawling
   process, including download speed, statistics on the pages and amounts of data
   stored. In online mode, the administrator may adjust the speed of a given crawler, add
   or delete processes, stop the system, add or delete system nodes and supply the black
   list of domains not to be visited, etc.




                                         20
             Packers and Movers   2012




 CHAPTER 4

DETAILED
 DESIGN




     21
                                                             Packers and Movers     2012


4.1    SYSTEM ANALYSIS

       The goal of systems analysis is to determine where the problem is in attempt to
fix the system. This step involves breaking down the system in different pieces and
drawing diagrams to analyze the situation. Analysts project goals, breaking down
functions that need to be created, and attempt to engage users so that definite
requirements can be defined.



Design: In systems design functions and operations are described in detail, including
screen layouts, business rules, process diagrams and other documentation. The output of
this stage will describe the new system as a collection of modules or subsystems.



Coding: Modular and subsystem programming code will be accomplished during this
stage. This stage is intermingled with the next in that individual modules will need testing
before integration to the main project. Planning in software life cycle involves setting
goals, defining targets, establishing schedules, and estimating budgets for an entire
software project.



Testing: The code is tested at various levels in software testing. Unit, system and user
acceptance testing are often performed. This is a grey area as many different opinions
exist as to what the stages of testing are and how much if any iteration occurs. Iteration is
not generally part of the waterfall model, but usually some occurs at this stage.



Operations and Maintenance: The deployment of the system includes changes and
enhancements before the decommissioning or sunset of the system. Maintaining the
system is an important aspect of SDLC. As key personnel change positions in the
organization, new changes will be implemented, which will require




                                         22
                                            Packers and Movers   2012


 4.2      CONCEPTUAL MODELS
 4.2.1 USE CASE DIAGRAMS
                       PACKERS AND MOVERS
                         Login


                       Agent Mgmt.


                     Quotation Mgmt.


                     Add Packer Mover
Agent                                                      Administrator
                       Service Mgmt.


                       Feedback Mgmt.



                       Quotation View


                        Registration


                        Profile Updating


                         Use Services


Clients                 Give Quotation


                       Search Packers
                          Movers


                         Give Feedback




                             23
                                                            Packers and Movers   2012


          4.2.2 USE CASE DESCRIPTION


Actor         Action Performed      System Response

Administrator Login                 After successful login it will show the Admin Home
                                    Page. For Various Administrator operations.
              Agent Management      To manages the Agents list such as adding, updating
                                    and deleting from list.
              Quotation             To view the Quotations and to delete it as it is
              Management            serviced.
              Service Management    To manage the system functionality and services, and
                                    also the database management.
              Feedback Management   To view the feedback and delete it if required from
                                    database.

Agents        Registration          To access the Web portal services first agents has to
                                    register to this site.
              Login                 After successful login it will show the Agent Home
                                    Page. For Various Agent operations.
              Quotation View        To review the Quotation placed by clients.

              Search Packers and    Search Packers and Movers companies registered on
              Movers                this web portal.
              Profile Updating      To see own profile and to do changes if required and
                                    update the changes over database.

Clients       Use Services          To access various services provided on this web
                                    portal.
              Quotation             Place the Quotation with its full details so that
                                    reliable agents will contact to you directly.
              Search Packers and    Search Packers and Movers companies registered on
              Movers                this web portal.
              Feedback              To give feedback.




                                        24
                                                 Packers and Movers    2012


4.2.3 CLASS DIAGRAM


                                         Login

                                  # Username: varchar
                                  # Password: varchar
   Agent/Company
                                  #dopost ()
                                  # doget ()
# conn: connection
# rs: resultset                   +login ()
# stmt: Statement                                                        Search
# Name org.: string
# Address :varchar                                              # conn: connection
# City: varchar                                                 # rs: resultset
# Phone:int                                                     # stmt: Statement
# Pin-Code: int                                                 # City: varchar
# Email: varchar                                                # Services: String
# Services: String
                                                                #dopost()
#dopost()                                                       #doget()
#doget()                                                        + View Companies ()
+ Agent Registration ()
+ View Companies ()
+ Delete Agents ()
+ Update Agents ()              User/Clients

                          # Name: string
                          # Address :varchar                          Feed Back
                          # City: varchar
     Quotation            # Phone:int                        # conn: connection
                          # Email: varchar                   # rs: resultset
# conn: connection                                           # stmt: Statement
# rs: resultset           #dopost()                          # Name: string
# stmt: Statement         #doget()                           # Address :varchar
# Name :string                                               # City: varchar
# Address :varchar                                           # Phone:int
# Service: varchar                                           # Email: varchar
#Shift- from: varchar                                        # Experience: String
#Shift-to: varchar                                           # Comments: String
#Service –Date: Date
                                                             #dopost()
#dopost()                                                    #doget()
#doget()                                                     + Add Feedback ()
+ Add Quotation ()                                           + View Feedback ()
+ View Quotation ()                                          + Delete Feedback ()
+ Delete Quotations ()



                           25
                                                                      Packers and Movers   2012


        4.2.4 SEQUENCE DIAGRAM

Sequence Diagram for Administrator:


         Start           Admin           Quotation            Agent             Feedback          Database
                          GUI             Mgmt.               Mgmt.              Mgmt.




            Login Success Quotation Mgmt.       View/Delete

Admin


            Login Fail                                           Update Done



                             Agents Mgmt.                       View, Delete, Update



                                 Changes Done                         Updated




                             Feed Back Mgmt.                                           View/Delete



                                                                                       Done




                 Exit




                                                26
                                                                       Packers and Movers      2012


Sequence Diagram for Agent:


        Start           Registration          Admin            Quotation          Profile             Database
                                               GUI


            Register

                                Registration Success

Agent
                               Registration Fail                                  Saved to Database

            Registered




           Login Success                           Quotation               Search Quotations

                                                                           View

                Login Fail




                                                   Profile View
                                                                                            Do Changes

                                                        Updated
                                                                                        Changes Done
                 Exit




                                                   27
                                                                         Packers and Movers      2012


Sequence Diagram for Clients:


          Start       Directory          Quotation           Packers &             Feedback              Database
                                                              Movers




           Go To Directory     Quotation             Give Quotation

Clients
                             Given

                                                                      Quotation Saved



                             Packers and Movers                          Search



                              View                                        List after Search




                             Feed Back                                                   Fill the Form



                                                                                              Saved
                              Feedback Given


              Exit




                                                  28
                                                                          Packers and Movers    2012


COLLABRATION DIAGRAM
Collaboration diagram for Administrator:


              1: Go to Home
                                     Home Page


     Admin        12: Exit
                    11: Redirect to Home              2: Go to Login


                                              Login

                            3: Loin Success              4: Login Fail


                                     Admin Home Page




  5: To View Quotation         6: To give Profile                                           10: Redirect

                                                                     7: To search Packers
                      8: Redirect                         9: Redirect        & Movers

                                                                                                Feedback
      Quotation                                       Agents

5.1: Search                                                                                      7.2: View
                5.2: View/Delete                                         6.2: Cancel             or Delete

               Quotations           6.1: Do Changes            6.3: Update        7.1: Search



        Quotation                                   Registered                                Feedback
       Information                                  Companies                                Information




                                                    29
                                                                          Packers and Movers    2012


Collaboration diagram for Agent:


              1: Go to Home
                                     Home Page


     Agent        12: Exit
                    11: Redirect to Home              2: Go to Login


                                              Login

                            3: Loin Success             4: Login Fail


                                      Agent Home Page




  5: To View Quotation        6: To give Profile                                               10: Redirect

                                                                    7: To search Packers
                      8: Redirect                         9: Redirect       & Movers

                                                                                           Search Packers &
      Quotation                                       Profile
                                                                                               Movers

5.1: Search                                                                                      7.2: View

                5.2: View                                               6.2: Cancel

               Quotations           6.1: Do Changes             6.3: Update      7.1: Search


        Quotation                                     Profile                               Registered
       Information                                 Information                              Companies




                                                   30
                                                                              Packers and Movers     2012


Collaboration diagram Clients:


                 1: Go to Home
                                       Home Page


     Client        10: Exit
                     9: Redirect to Home                 2: Go to Directory


                                               Directory




  3: To fill Quotation               4: To give Feedback                                            8: redirect

                                                                        5: To search Packers
                         6: Redirect                           7: Redirect      & Movers

                                                                                               Search Packers &
     Quotation                                           Feedback
                                                                                                   Movers

3.1: Quotation                                                                                        5.2: View

Placed                 3.2: Cancel                                      4.2: Cancel

                                         4.1: Feedback                                5.1: Search
                                               Given

          Quotation                                    Feedback                                 Registered
         Information                                  Information                               Companies




                                                         31
                                                                 Packers and Movers        2012


      4.2.5 ACTIVITY DIAGRAM

Activity diagram for Administrator:




                                      Login                 Login fail


                                       Valid

                                                 Login Success

                              Administrator Home Page

                                                                                   Exit


                                       Select



      Agent Management          Quotation Management             Feedback Management



           Agents                     Quotation                          Feedback
           Review                      Review                             Review


                     No                              No                                   No
          Update,                      Delete                             Delete
          Delete


               Yes                             Yes                            Yes




                                           32
                                                                   Packers and Movers   2012


Basic flow for Administrator is as follows:

   1. Administrator enters his correct Login ID and password to enter in his Administrator
       Home Page.
   2. The condition is checked that weather the Login ID or password is correct or not if it fails
       then it shows a message and redirect to login page again for entering the correct Login ID
       and password.
   3. If the Login is success then Administrator enters into his Home page for various
       operations to perform.
   4. Then he has to select one of the Modules from list Module.
   5. When Agent Management is selected, he can view list of Agents that are registered over
       this portal.
   6. He selects one from them and does the operations such as addition, deletion, and updating
       the agents and saves it to database.
   7. These changes are permanent and can be viewed by others also.
   8. When Quotation Management is selected, he can view list of Quotations that are placed
       by user over this portal.
   9. He selects one from them and view and if required delete it from database.
   10. When Feedback Management is selected, he can view list of Feedback that are given by
       user over this portal.
   11. He selects one from them and view and if required delete it from database.
   12. He also performs required operation according to feedback given from users.
   13. At the end Administrator Logout from his Home page.




                                               33
                                                            Packers and Movers   2012


Activity diagram for Agent:




                                Registration           No



                                  Login
                                                       Login Fail


                                  Valid


                                            Login Success

                              Agent Home Page

                                                                         Exit


                                   Select



            Profile               Quotation                  Registered Companies



           Profile               Quotation                      Companies
           Details                Review                         Review
                      No


           Add,
          Update




                                       34
                                                                   Packers and Movers   2012


Basic flow for Agents is as follows:

   1. Firstly an Agent has to register their company on this web portal by giving all his basic
       information such as Company Name, Address, city, state, pin code, contact name, phone
       number, email ID, password, service type, and mobile number.
   2. When he successfully registers he has a login ID and password.
   3. Agent enters his correct Login ID and password to enter in his Agent Home Page.
   4. The condition is checked that weather the Login ID or password is correct or not if it fails
       then it shows a message and redirect to login page again for entering the correct Login ID
       and password.
   5. If the Login is success then Agent enters into his Home page for various operations to
       perform.
   6. Then he has to select one of the Modules from list Module.
   7. When Profile updating is selected, he can view his own information.
   8. He does the operations such as addition, and updating the profile and saves it to database.
   9. These changes are permanent and can be viewed by others also.
   10. When Quotation is selected, he can view list of Quotations that are placed by user over
       this portal.
   11. He selects one from them and views the detailed information about quotation from
       database.
   12. When Registered Companies is selected, he can view list of all Registered Companies.
   13. He selects one from them and view details of it from database.
   14. He also directly communicates to the users who have placed the quotation to give
       required services accordingly.
   15. At the end Agent Logout from his Home page.




                                               35
                                                     Packers and Movers    2012


Activity diagram for Client:




                               Home Page




                                Directory

                                                                  Exit


                                 Select



            Search               Quotation                  Feedback




         View Packers &          Quotation                Feedback
            Movers                 Form                     Form

                                                No                        No

                                    Fill                      Fill
                                 Quotation                 Feedback
           Agents
           Review

                                          Yes                    Yes

                     Exit




                                     36
                                                                    Packers and Movers   2012


Basic flow for Clients is as follows:

   1. Firstly Clients enters into Home Page of our web portal where he can see all the basic

       information about the web portal and services that he can access through this website.

   2. For the search of the service providers he has to go to the Directory page where he can

       search the service providers city vice and also view other useful information that are

       provided through this website.

   3. After entering to directory he has to select one of the Modules from list Module.

   4. When Search Packers and Movers are selected, he can view list of all the available

       Packers and Moving Companies.

   5. When Quotation is selected, quotations Form is available.

   6. He provides the information such as Name, Email ID, Mobile number, Service type, Shift

       from, Shift to, service date, contact time, and other details by submitting Quotation.

   7. When Feedback is selected, Feedback Form is available.

   8. He provides the information such as Name, Email ID, Mobile number, Experience,

       Comments, and other details by submitting Feedback.

   9. At the end Client exits from the site.




                                                37
                                                        Packers and Movers   2012


      4.2.6 DATA FLOW DIAGRAM


Context level Data Flow Diagram:




      Administrator                                                   Clients




                   All Rights
                                   0   Context Level

                                                            Enquiry

                Registration       Packers and Movers



           Agent




                                         38
                                                           Packers and Movers   2012


Level One Data Flow Diagram:




                   Give                          0                                Save
       Clients                              Feedback      Retrieve

                                   Search                                 FEEDBACK


                                                1
                                 Register     Search
                                              Agents
   Administrator
                                 Give                                    QUOTATION
                                                 2            Retrieve          Save

                           View             Quotation

                                                                                Retrieve
      Agent


                                 Register        3                        AGENTS RECORD

                                              Agent                               Save
                                            Registratio
                          Update



                                                                      LOGIN INFORMATION
                                                 4
                          Does                             Retrieve               Save
                                             Log in




                                            39
                                                                         Packers and Movers   2012


Level Two Data Flow Diagram for Agents Record:




                           Registration              Registration
       Agent                                            Form

                                                                               Registered
                                  Profile Review
                      Do
    Administrator


                                                                        Registered Company
                           Log-in         Check                            Information

                            GUI

                                          Valid              Register

                Search

                                           Login Information                       Search



                                           Delete/Update
                         Agents
                         Review

                                                   Search




                                                                              Search
            Clients                          Directory                       Packers &
                                                                              Movers




                                                    40
                                                                  Packers and Movers   2012


Level Two Data Flow Diagram for Feedback:




                            Fill Feedback       Feedback
        Clients                                   Form

                                                                        Feedback
                                                                        Given




                                                                  Feedback
                                                                  Information




                                                            Search           Delete
                                               Quotation
                  Log-in           Success      Review
                   GUI



          Check                  View/Delete
                                                       Administrator
                         Valid

                  Log-in

             Information




                                               41
                                                                   Packers and Movers   2012


Level Two Data Flow Diagram for Quotation:




                              Fill Quotation      Quotation
        Clients                                     Form

                                                                         Quotation
                                                                         Placed




                                                                    Quotation
                  Agent                                             Information

                      View

                      Quotations

                                                              Search          Delete
                                                 Quotation
                  Log-in           View           Review
                  Form



         Check                     View/Delete
                                                         Administrator
                           Valid

                  Log-in

             Information




                                                 42
                Packers and Movers   2012




    CHAPTER 5

IMPLEMENTATION
 AND TESTING




        43
                                                                   Packers and Movers   2012


            5.1   IMPLEMENTATION PHASES
            5.1.1 MODULE STRUCTURE

                               PACKERS AND MOVERS


HOME                     DIRECTORY                         LOGIN                    REGISTRATION



ABOUT US                       SEARCH PACKERS & MOVERS                      ADMINISTRATOR


CLIENTS                              FEEDBACK                                    Feedback Management

                                                                                   Agent Management
 FAQ’s                               SERVICES

                                                                                 Quotation Management
Feed Back                                City Distances

SERVICES                                                                          Service Management
                                       Moving Calculator

    Packing Services
                                           Box Sizes                         AGENTS/COMPANIES

    Moving services
                                  INFORMATION                                     Registered Company

   Relocation Services                                                                   Review
                                         For Individuals

      Office Shifting                                                              Quotation Review
                                       For Moving Companies

                                                                                    Profile Updating
   Unpacking Services                   Conversion Tables

                                                                                    New Registration
     Loading Services                            Indian Electricity Guide


   Unloading Services                             Distance and Height


                                                Weight and Temperature

                                                Measurement and Volume



                                            44
                                                                 Packers and Movers   2012


   Basic Modules Input and Output System:
1. Registration Module:

      To access our services an Agent has first have to register to the system by providing all
      the required information.

      Input to this module:

      1. Company Name
      2. Address
      3. City
      4. State
      5. Pin Code
      6. Name
      7. Phone Number
      8. Email ID
      9. Password
      10. Service type
      11. Mobile Number

      Output of the module:

      1. Register entry conformed or failure


2. Login Module:

      To go to the required home page for various operation login is important.

      Input to this module:

      1. Login ID
      2. Password

      Output of the module:

      1. Successful login or Login failure




                                               45
                                                                    Packers and Movers   2012


3. Search Module:

      To get the suitable service provider user has to search it.

      Input to this module:

      1. City name

      Output of the module:

      1. Company Name

      2. Address

      3. City

      4. State

      5. Pin Code

      6. Name

      7. Phone Number

      8. Email ID

      9. Password

      10. Service type

      11. Mobile Number


4. Quotation Module

      A client gives the quotation for required service seekers.

      Input to this module:

      1. Name

      2. Service type
      3. Email ID
      4. Mobile Number
      5. Shift from




                                                46
                                                 Packers and Movers   2012


     6. Shift to
     7. Service Date
     8. Contact Time
     9. Details

     Output of the module:

     1. Quotation successfully placed.


5. Feedback Module

     A Client also may give the feedback.

     Input to this module:

     1. Name

     2. Company

     3. Address

     4. City

     5. Pin Code

     6. Email Id

     7. Phone Number

     8. Experience

     9. Comments

     Output of the module:

     1. Feedback successfully given




                                            47
                                                        Packers and Movers   2012


        5.1.2 DATA MODELS


   Login Data Model:


Column name      Data Type   Description
Name             Varchar     Name who Login
User_id          Varchar     Required User ID to Log in to System
Password         Varchar     Key for successful Login



   Agent Data Model:


Column name      Data Type   Description
Name_org         Varchar     Name of the Organization or Company
Address          Varchar     Address of the Company Location
City             Varchar     City of the Company
State            Varchar     State of the Company
Pin_code         Number      Pin Code Number of the City
Name             Varchar     Name of the Person to Contact
Phone            Number      Valid Phone Number for communication
Email_ID         Varchar     Valid Email ID
Password         Varchar     Key for successful login
Service_type     Varchar     Type Services that the Company Provides
Mobile_no.       Number      Valid Mobile Number for communication




                                   48
                                                         Packers and Movers   2012


   Quotation Data Model:


Column name       Data Type   Description
Service_type      Varchar     Type Services that the Company Provides
Name              Varchar     Name of the Person to Contact
Email_ID          Varchar     Valid Email ID
Mobile_no.        Number      Valid Mobile Number for communication
Shift_from        Varchar     City from where to Shift
Shift_to          Varchar     City to Shift there
Service_Date      Date        The Date on which to shift
Contact_time      Date        The time when to meeting is to be done
Reference         Varchar     Reference of the person
Details           Varchar     Other Details that are required


   Feedback data Model:



Column name       Data Type   Description
Name              Varchar     Name of the Person to Contact
Company           Varchar     Name of the Organization or Company
Address           Varchar     Address of the Company Location
City              Varchar     City of the Company
Pin_code          Number      Pin Code Number of the City
Email_ID          Varchar     Valid Email ID
Phone             Number      Valid Phone Number for communication
Experience        Varchar     Experience details if there
Comments          Varchar     Comments if he wishes




                                    49
                                                       Packers and Movers   2012


      5.1.3 DATA STORAGE SYSTEM


The Database Design and Disk Storage System:




                                       HARD DISK

                                 PACKERS & MOVERS




                                                                            LOGIN
                                                                            SCHEMA
                             QUOTATION             FEEDBACK
                                                                            Email-ID
      AGENT                  SCHEMA                SCHEMA
                                                                            Password
      SCHEMA                 Name                  Name
      Name                   Address               Address
      Address                Phone No.             City
      City                   Email-ID              Pin Code
      State                  Service               Phone No.
      Pin Code               Mobile No             Email-ID
      Phone No.              Shift From            Experience
      Email-ID               Shift to              Comments
      Password               Service Date
      Service




                                            50
                                                                                            Packers and Movers     2012


               5.1.4 ENTITY RELATION DIAGRAM

     Entity Relation Diagram:




                                                                                        Name                     Experience
      Name                 City
                                            1   Phone

                                            N                                                   N
  Address                Client
                                                                      Gives                              Feedback
                                        N

                          N       N
      Email_id                                    Has                                                               Comments


                                                                              N        PACKERS &
                                                                                        MOVERS
                          G                               S
                          i                               e                                         N
                          v                               a
                          e                               r                                     H
                          s                               c                                     a
                                                          h                                     s

                                                                                                           Name org.

 Service
                     N                                                                 N
                                                                                                                          Address
                                                                                                    N
Details           Quotation                             Review                             Agents/Company                   City
                                       N                                          1

 Shift From                                                                                 1
                                                                                                                            State

              Shift to                     Service Date                           Does
                                                                                                                          Phone

                                                                 1
                                                 Login                                                           E-mail

                                      User-ID             Password                    Service           Password


                                                                 51
                                                                          Packers and Movers   2012


       5.2      TEST CASES
       5.2.1 WHITE BOX TESTING

       Using the white-box testing techniques, a software engineer can design test case that [16]:

       •     Exercise independent paths within a module or unit
       •     Exercise logical decisions on both their true and false side
       •     Execute loops at their boundaries and within their operational bounds
       •     Exercise internal data structures to ensure their validity


       5.2.2 UNIT TESTING

       Code is written by people, and we make mistakes. Bugs to prevent us from shipping bugs
to our users, we test our software to verify that it works as it should. Java developers have
learned that not all testing is created equal. In addition to traditional functional testing, many
shops are adopting developer testing techniques such as unit testing. These leading craftsmen
create specific, automated tests to verify the accuracy and function of code while it's being
written - or even before it's written - because they want to catch bugs early. Better still, new tools
and processes make unit testing even more attractive to Java developers.

       Unit Testing in Java is written to show how to write good tests — tests that are concise
and to the point, expressive, useful, and maintainable. Inspired by Roy Osherove's bestselling
The Art of Unit Testing, this focuses on tools and practices specific to the Java world. It
introduces you to emerging techniques like behavior-driven development and specification by
example, and shows you how to add robust practices into your toolkit.

       If you're already doing unit testing, you'll learn the current state of the art, along with the
insights and experience of expert author Lasse Koskela. If these practices are new to you, you'll
get started on the right foot as you learn to write tests that build on more than a decade of
community experience [17].




                                                   52
                                                                      Packers and Movers   2012


        5.2.3 INTEGRATION TESTING
        Once unit tested components are delivered we then integrate them together. These
“integrated” components are tested to weed out errors and bugs caused due to the integration. This is
a very important step in the Software Development Life Cycle.

        It is possible that different programmers developed different components. A lot of bugs
emerge during the integration step. In most cases a dedicated testing team focuses on Integration
Testing [18].

        Prerequisites for Integration Testing:

        Before we begin Integration Testing it is important that all the components have been
successfully unit tested.

        Integration Testing Steps:

        Integration Testing typically involves the following Steps:

        •   Step 1: Create a Test Plan
        •   Step 2: Create Test Cases and Test Data
        •   Step 3: If applicable create scripts to run test cases
        •   Step 4: Once the components have been integrated execute the test cases
        •   Step 5: Fix the bugs if any and re test the code
        •   Step 6: Repeat the test cycle until the components have been successfully integrated


        5.2.4 SYSTEM TESTING

        The prerequisites for System Testing are:

        •   All the components should have been successfully Unit Tested
        •   All the components should have been successfully integrated and Integration
        •   Testing should be completed
        •   An Environment closely resembling the production environment should be created.
        •   When necessary, several iterations of System Testing are done in multiple environments.




                                                    53
                                                                        Packers and Movers   2012


        Steps needed to do System Testing:

        The following steps are important to perform System Testing:

        •      Step 1: Create a System Test Plan
        •      Step 2: Create Test Cases
        •      Step 3: Carefully Build Data used as Input for System Testing
        •      Step 3: If applicable create scripts to
                   -   Build environment and
                   -   to automate Execution of test cases
        •      Step 4: Execute the test cases
        •      Step 5: Fix the bugs if any and re test the code
        •      Step 6: Repeat the test cycle as necessary



        5.2.5 BLACK BOX TESTING
        Black box testing takes an external perspective of the test object to derive test cases. These
tests can be functional or non-functional, though usually functional. The test designer selects valid
and invalid input and determines the correct output. There is no knowledge of the test object's
internal structure. This method of test design is applicable to all levels of software testing: unit,
integration, functional testing, system and acceptance. The higher the level, and hence the bigger and
more complex the box, the more one is forced to use black box testing to simplify. While this method
can uncover unimplemented parts of the specification, one cannot be sure that all existent paths are
tested [19].




                                                         54
                Packers and Movers   2012




    CHAPTER 6

OUTPUT SCREENS
 AND CODING




        55
                                                                  Packers and Movers   2012


   6.1         SCREEN SHOTS AND TEST REPORT




                                      Figure 6.1: Home Page

This is the Home Page of our Website giving the basic information about our web portal and all
the useful links of other related pages are given in this page.




                                                 56
                                                                 Packers and Movers   2012




                                 Figure 6.2: Directory Page

This is the Directory Page of our Website where user can search the different Packers and
Movers Companies available and also gives the other important services and useful tips for both
companies and users.




                                              57
                                                                  Packers and Movers   2012




                             Figure 6.3: Fraud Information Page

This is the Fraud Information Page of our Website giving the basic information about fraud
companies as the goods are precious to clients and awaking the users from frauds.




                                               58
                                                                  Packers and Movers   2012




                                 Figure 6.4: Quotation Page

This is the Quotation Page of our Website by giving the suitable information user placed a
quotation and the available service provider may contact accordingly.




                                               59
                                                              Packers and Movers   2012




                                  Figure 6.5: Feedback Page

This is the Feedback Page of our Website by giving the suitable information user gives his
feedback to administrator for the future development.




                                               60
                                                                   Packers and Movers   2012




                                Figure 6.6: Distance Calculator

Through Distance calculator user can calculate the distance between the Major cities of India.




                                               61
                                Packers and Movers   2012




Figure 6.7: Moving Calculator



             62
                                Packers and Movers   2012




Figure 6.8: Box Size and Rate




             63
                                                                   Packers and Movers   2012




                                    Figure 6.9: Login Page

This Page provides the login facility for the registered Agents and Administrator. If the Agent is
a registered user then the login page directs to its Home page. Else shows the message that
                                 incorrect.
entered Login ID and password is incorrect




                                               64
                                                                 Packers and Movers   2012




                           Figure 6.10: Administrator Home Page

The Administrator Home pages shows the links of the available modules and actions that an
administrator can perform. Under feedback management admin can see the feedback and delete
                               see
it. In Agent management he can see all the registered agents and can add, delete and update the
agent’s information if required. In Quotation management admin can see the Quotation and
delete it.




                                              65
                                                                Packers and Movers   2012




                           Figure 6.11: Agent management Page

Through Agent Management the Administrator see the list of all agents that are logged in this
                                                              mail
web portal. Administrator choose one out of them by writing e-mail id and the details will be
                                                                   changes
displayed and then he use to perform the operation over it and the changes done on database as
permanent.




                                             66
                                                                 Packers and Movers   2012




                         Figure 6.12: Quotation management Page

Through Quotation Management the Administrator sees the list of all Quotation that is places
over this web portal. Administrator choose one out of them by writing name and the details will
be displayed and then he use to perform the operation over it and the changes done on database
as permanent.




                                              67
                                                                    Packers and Movers    2012




                                 Figure 6.13: Agent Home Page

The Agent Home pages shows the links of the available modules and actions that an Agent can
perform. Under Profile updating Agent can see his profile information and can update his
                                                                               client
information if required. In Quotation can see the Quotation and contact to the clients.




                                                68
                                                                Packers and Movers   2012




                                Figure 6.14: Profile Update

Through Profile Update the Agent can view its own Profile and make changes over it if required
and save the changes as permanent and it is then saved to database and the changes are viewed
by others also.




                                             69
                                                                              Packers and Movers       2012


      6.2           IMPORTANT CODING

Coding for agent.jsp page:

<form action="agentdb.jsp">

<%@ page import="java.sql.*"%>

<%

String city=request.getParameter("txtSearch");

Class.forName("com.mysql.jdbc.Driver");

Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/pnm","root","root");

PreparedStatement ps=con.prepareStatement("select nameorg, address,city,phnno,emailid from agent ");

ResultSet rs=ps.executeQuery();

%>

<table style="width: 100%" border="1" width="7" cellspacing="3" cellpadding="2"><tr>

            <td style="width: 126px"><font color="red"><strong>Name </strong></font> </td>

            <td style="width: 126px"> <font color="red"><strong>Address</strong></font> </td>

            <td style="width: 126px"><font color="red"><strong>City</strong></font></td>

            <td style="width: 126px"><font color="red"><strong>Contact No.</strong></font></td>

             <td style="width: 126px"><font color="red"><strong>Email Id</strong></font></td>

      </tr></table>

<%

while(rs.next())

  {

  %>

<table style="width: 100%" border="1" width="7" cellspacing="3" cellpadding="2"><tr>

       <%

       int i=0;

       %>

            <td style="width: 126px"><%out.println(rs.getString(1));%></td>

            <td style="width: 126px"><%out.println(rs.getString(2));%></td>

            <td style="width: 126px"><%out.println(rs.getString(3));%></td>




                                                         70
                                                                                 Packers and Movers   2012


               <td style="width: 126px"><%out.println(rs.getString(4));%></td>

               <td style="width: 126px"><%out.println(rs.getString(5));%></td>

       </tr></table>

<% }           %>

Coding for agent.java:

package pack;

import java.sql.*;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

   public class Feedback extends HttpServlet (

      protected void processRequest(HttpServletRequest request, HttpServletResponse response)

       throws ServletException, IOException {

       response.setContentType("text/html;charset=UTF-8");

       PrintWriter out = response.getWriter();

       try {    }

            finally {

           out.close();

       }

  }

  /**

   * Handles the HTTP <code>POST</code> method.

   * @param request servlet request

   * @param response servlet response

   * @protected void doPost(HttpServletRequest request, HttpServletResponse response)




                                                           71
                                                                             Packers and Movers   2012


  throws ServletException, IOException {

response.setContentType("text/html;charset=UTF-8");

PrintWriter out = response.getWriter();

 Connection con = null;

       PreparedStatement ps = null;

       ResultSet rs = null;

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

String company=request.getParameter("txtCompany");

String address=request.getParameter("txtAddress");

String city=request.getParameter("txtCity");

String pin=request.getParameter("txtPin");

String email=request.getParameter("txtEmail");

String phone=request.getParameter("txtPhone");

String fax=request.getParameter("txtfax");

String experince=request.getParameter("exp");

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

try{

Class.forName("com.mysql.jdbc.Driver");

con= DriverManager.getConnection("jdbc:mysql://localhost:3306/pnm","root","root");

 ps= con.prepareStatement("Insert into feed Values(?,?,?,?,?,?,?,?,?,?)");

 ps.setString(1,name);

  ps.setString(2,company);

  ps.setString(3,address);

  ps.setString(4,city);

  ps.setString(5,pin);

  ps.setString(6,email);

  ps.setString(7,phone);

  ps.setString(8,fax);




                                                     72
                                                             Packers and Movers   2012


             ps.setString(9,experince);

             ps.setString(10,comments);

             ps.executeUpdate();

             con.close();

             out.print("connection close");

             response.sendRedirect("thankufeed.jsp");

     }

         catch (Exception e)

         {

     Out.println(“Error ”+ e.printStackTrace();)
       }

     }

     @Override

     public String getServletInfo() {

         return "Short description";

     }

}

Coding for Login.jsp:

<script>

function validate(){

var userid=document.form.user.value;

var password=document.form.pass.value;

if(userid==" "){

alert("Enter Username!");

    return false;

}

if(password==" "){

alert("Enter Password!");




                                                        73
                                                                        Packers and Movers   2012


    return false;

}

return true;

}

</script>

<form name="form" action="Login1" >

<table>

<tr><td>Username:</td><td><input type="text" name="userid"></td></tr>

<tr><td>Password:</td><td><input type="password" name="password"></td></tr>

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

</table>

</form>

Coding for Login.java:

package pack;

import java.sql.*;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

/**

*

* @author sony

*/

public class Login1 extends HttpServlet {




                                                   74
                                                                                 Packers and Movers       2012


   public Login1()

       {

super();

       }

  /**

   * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.

   * @param request servlet request

   * @param response servlet response

   * @throws ServletException if a servlet-specific error occurs

   * @throws IOException if an I/O error occurs

   */

  protected void processRequest(HttpServletRequest request, HttpServletResponse response)

           throws ServletException, IOException {

      response.setContentType("text/html;charset=UTF-8");

       PrintWriter out = response.getWriter();

  }

  // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the
code.">

  /**

   * Handles the HTTP <code>GET</code> method.

   * @param request servlet request

   * @param response servlet response

   * @throws ServletException if a servlet-specific error occurs

   * @throws IOException if an I/O error occurs

   */

  @Override

  protected void doGet(HttpServletRequest request, HttpServletResponse response)

           throws ServletException, IOException {




                                                         75
                                                                                Packers and Movers    2012


      processRequest(request, response);

 }

 /**

 * Handles the HTTP <code>POST</code> method.

*/

 protected void doPost(HttpServletRequest request, HttpServletResponse response)

        throws ServletException, IOException {

        response.setContentType("text/html;charset=UTF-8");

     PrintWriter out = response.getWriter();

 HttpSession session = request.getSession(true);

      Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

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

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

      session.setAttribute("userid", userid);

      out.print(userid);

     // out.println("<input type = hidden name = userid value = userid+("userid")+ size = 10 / >");

 if (userid==null || password==null)

     response.sendRedirect("login");

      try{

      out.print("i m here ");

        Class.forName("com.mysql.jdbc.Driver");

      con= DriverManager.getConnection("jdbc:mysql://localhost:3306/pnm","root","root");

      ps= con.prepareStatement("select * from login where userid='"+userid+"' and password='"+password+"'");

        rs=ps.executeQuery();

        {

         int count=0;




                                                         76
                                                                              Packers and Movers   2012


                while(rs.next())

            {

                     count++;

            }

                      if(count>0)

            {

                 if (userid.equals("admin") && password.equals("password"))

                 {

        session.setAttribute("username",userid);

        response.sendRedirect("admin.jsp");

    }

                 else

                 {

                     session.setAttribute("username",userid);

                     response.sendRedirect("agents.jsp");

                 }

                 }

            else

            {

                        response.sendRedirect("login.jsp");

            }

        }

        con.close();

}

            catch(Exception e) {       }

    }

    @Override

    public String getServletInfo() {




                                                                77
                                                                                Packers and Movers     2012


         return "Short description";

     }

}

Coding for agentupdate.jsp:

<%@ page import="java.sql.*"%>

<%

Connection con = null;

    PreparedStatement ps = null;

    ResultSet rs = null;

         String name = request.getParameter("Search");

         Class.forName("com.mysql.jdbc.Driver");

         con= DriverManager.getConnection("jdbc:mysql://localhost:3306/pnm","root","root");

     ps=con.prepareStatement("select nameorg, address,city,state,name,phnno,emailid from agent where
emailid='"+name+"'");

         rs=ps.executeQuery();

         %>

<%

while(rs.next())

     {

     %>

         <table width="90%" cellpsacing="2" cellpadding="2" border="0" bgcolor="c7e8ff">

         <tr> <tr>

         <td width="23%" height="30" align="right" valign="middle" bgcolor="#BFDFEE"><span>Company
Name</span></td>

          <td width="2%" height="30" align="center" valign="middle"
bgcolor="#BFDFEE"><strong>:</strong></td>

               <td width="75%" height="30" bgcolor="#BFDFEE"><span style="padding-left:10Px;">

                     <input name="nameorg" type="text" id="txtnameorg" value="<%out.println(rs.getString(1));%>"
/>




                                                          78
                                                                               Packers and Movers     2012


            <span id="rfvnameorg" style="color:Red;visibility:hidden;">*</span></span></td>

         </tr>

          <tr>

          <td width="23%" height="30" align="right" valign="middle"
bgcolor="#BFDFEE"><span>Address</span></td>

          <td width="2%" height="30" align="center" valign="middle"
bgcolor="#BFDFEE"><strong>:</strong></td>

          <td width="75%" height="30" bgcolor="#BFDFEE"><span style="padding-left:10Px;">

                 <input name="add" type="text" id="txtAddress" value="<%out.println(rs.getString(2));%>" />

            <span id="rfvAddress" style="color:Red;visibility:hidden;">*</span></span></td>

         </tr>

          <tr>

          <td width="23%" height="30" align="right" valign="middle"
bgcolor="#BFDFEE"><span>city</span></td>

          <td width="2%" height="30" align="center" valign="middle"
bgcolor="#BFDFEE"><strong>:</strong></td>

          <td width="75%" height="30" bgcolor="#BFDFEE"><span style="padding-left:10Px;">

                 <input name="city" type="text" id="txtCity" value="<%out.println(rs.getString(3));%>" />

            <span id="rfvCity" style="color:Red;visibility:hidden;">*</span></span></td>

         </tr>

          <tr>

          <td width="23%" height="30" align="right" valign="middle"
bgcolor="#BFDFEE"><span>State</span></td>

          <td width="2%" height="30" align="center" valign="middle"
bgcolor="#BFDFEE"><strong>:</strong></td>

          <td width="75%" height="30" bgcolor="#BFDFEE"><span style="padding-left:10Px;">

                 <input name="state" type="text" id="txtState" value="<%out.println(rs.getString(4));%>" />

            <span id="rfvState" style="color:Red;visibility:hidden;">*</span></span></td>

         </tr>

          <tr>




                                                        79
                                                                              Packers and Movers     2012


          <td width="23%" height="30" align="right" valign="middle" bgcolor="#BFDFEE"><span>Contact
Person</span></td>

          <td width="2%" height="30" align="center" valign="middle"
bgcolor="#BFDFEE"><strong>:</strong></td>

          <td width="75%" height="30" bgcolor="#BFDFEE"><span style="padding-left:10Px;">

                 <input name="namep" type="text" id="txtContperson" value="<%out.println(rs.getString(5));%>"
/>

            <span id="rfvContperson" style="color:Red;visibility:hidden;">*</span></span></td>

         </tr>

           <tr>

          <td width="23%" height="30" align="right" valign="middle" bgcolor="#BFDFEE"><span>Contact
No.</span></td>

          <td width="2%" height="30" align="center" valign="middle"
bgcolor="#BFDFEE"><strong>:</strong></td>

          <td width="75%" height="30" bgcolor="#BFDFEE"><span style="padding-left:10Px;">

                 <input name="phnno" type="text" id="txtContno" value="<%out.println(rs.getString(6));%>" />

            <span id="rfvContno" style="color:Red;visibility:hidden;">*</span></span></td>

         </tr>

            <tr>

          <td width="23%" height="30" align="right" valign="middle" bgcolor="#BFDFEE"><span>Email
Id</span></td>

          <td width="2%" height="30" align="center" valign="middle"
bgcolor="#BFDFEE"><strong>:</strong></td>

          <td width="75%" height="30" bgcolor="#BFDFEE"><span style="padding-left:10Px;">

                 <input name="mail" type="text" id="txtMail" value="<%out.println(rs.getString(7));%>" />

            <span id="rfvMail" style="color:Red;visibility:hidden;">*</span></span></td>

         </tr>       </table>

<%

}

%>

<input type="submit" value="Delete" name="delete" />




                                                       80
                                                                            Packers and Movers   2012


<td colspan="2" bgcolor="c7e8ff">&nbsp;</td></tr>

</tbody></table>

</div>

Coding for agentupdate.java:

package pack;

import java.sql.*;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class Update1 extends HttpServlet {

  protected void processRequest(HttpServletRequest request, HttpServletResponse response)

          throws ServletException, IOException {

      response.setContentType("text/html;charset=UTF-8");

      PrintWriter out = response.getWriter();

      try {

      } finally {

          out.close();

      }

  }

  @Override

  protected void doPost(HttpServletRequest request, HttpServletResponse response)

          throws ServletException, IOException {

      // processRequest(request, response);

      response.setContentType("text/html;charset=UTF-8");

      PrintWriter out = response.getWriter();



                                                      81
                                                                           Packers and Movers   2012


     Connection con = null;

 PreparedStatement ps = null;

 ResultSet rs = null;

    String nameorg = request.getParameter("name");

    String address = request.getParameter("add");

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

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

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

    String name=request.getParameter("namec");

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

    String emailid=request.getParameter("mail");

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

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

    try{

        Class.forName("com.mysql.jdbc.Driver");

        con= DriverManager.getConnection("jdbc:mysql://localhost:3306/pnm","root","root");

      out.print("come");

        ps= con.prepareStatement("UPDATE agent SET address=?,city=?,state=?,pin=?,name=?,phnno=?
,emailid=?,password=?,servicetype=? where nameorg='"+nameorg+"'");

        ps.setString(1,address);

        out.print("i m here");

        ps.setString(2,city);

        ps.setString(3,state);

        ps.setString(4,pin);

        ps.setString(5,name);

        ps.setString(6,phnno);

        ps.setString(7,emailid);

        ps.setString(8,pass);




                                                      82
                                                                                Packers and Movers      2012


            ps.setString(9,sertype);

            ps.executeUpdate();

            out.print("no. of row effectet=");

            con.close();

            out.print("connection close");

            response.sendRedirect("profileupdation.jsp");

    }

        catch (Exception e)

        {

e.printStackTrace();

        }

    }

    @Override

    public String getServletInfo() {

        return "Short description";

    }

}

Coding for quotation.jsp:

<%@ page import="java.sql.*"%>

<%

             String city=request.getParameter("txtCity");

            Class.forName("com.mysql.jdbc.Driver");

        Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/pnm","root","root");

     PreparedStatement ps=con.prepareStatement("select
sertype,name,email,mobile,shiftfrom,shiftto,servicedate,contacttime,details from user where shiftfrom='"+city+"'");

        ResultSet rs=ps.executeQuery();

%>

<table style="width: 100%" border="1" width="7" cellspacing="3" cellpadding="2">




                                                            83
                                                                              Packers and Movers   2012


         <tr>

         <td style="width: 126px"><font color="red"><strong>Service</strong></font> </td>

         <td style="width: 126px"> <font color="red"><strong> Name</strong></font> </td>

          <td style="width: 126px"><font color="red"><strong>Mobile</strong></font></td>

          <td style="width: 126px"><font color="red"><strong>Email</strong></font></td>

           <td style="width: 126px"><font color="red"><strong>Shift From</strong></font></td>

            <td style="width: 126px"><font color="red"><strong>Shift To</strong></font></td>

            <td style="width: 126px"><font color="red"><strong>Service Date</strong></font></td>

            <td style="width: 126px"><font color="red"><strong>Contact Time</strong></font></td>

            <td style="width: 126px"><font color="red"><strong>details</strong></font></td>

      </tr></table>

<%

while(rs.next())

  {

  %>

<table style="width: 100%" border="1" width="7" cellspacing="3" cellpadding="2"><tr>

         <td style="width: 126px"><%out.println(rs.getString(1));%></td>

         <td style="width: 126px"><%out.println(rs.getString(2));%></td>

          <td style="width: 126px"><%out.println(rs.getString(3));%></td>

          <td style="width: 126px"><%out.println(rs.getString(4));%></td>

           <td style="width: 126px"><%out.println(rs.getString(5));%></td>

           <td style="width: 126px"><%out.println(rs.getString(6));%></td>

           <td style="width: 126px"><%out.println(rs.getString(7));%></td>

           <td style="width: 126px"><%out.println(rs.getString(8));%></td>

            <td style="width: 126px"><%out.println(rs.getString(9));%></td>

</tr></table>

<% }     %>




                                                       84
                                                                            Packers and Movers   2012


Coding for quotation.java:

package pack;

import java.sql.*;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class viewquotation extends HttpServlet {

  protected void processRequest(HttpServletRequest request, HttpServletResponse response)

          throws ServletException, IOException {

      response.setContentType("text/html;charset=UTF-8");

      PrintWriter out = response.getWriter();

      try {

      } finally {

          out.close();

      }

  }

  @Override

  protected void doPost(HttpServletRequest request, HttpServletResponse response)

          throws ServletException, IOException {

 response.setContentType("text/html;charset=UTF-8");

 PrintWriter out = response.getWriter();

 Connection con = null;

 PreparedStatement ps = null;

 ResultSet rs = null;

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



                                                       85
                                                                               Packers and Movers   2012


        out.print(name);

        try

        {

         Class.forName("com.mysql.jdbc.Driver");

        con= DriverManager.getConnection("jdbc:mysql://localhost:3306/pnm","root","root");

        ps=con.prepareStatement("Delete from user where name='"+name+"'");

        ps.executeUpdate();

        response.sendRedirect("reviewquotation.jsp");

            }

        catch(Exception e)

        {

            e.printStackTrace();

        }

    }

    @Override

    public String getServletInfo() {

        return "Short description";

    }

}




                                                         86
               Packers and Movers   2012




   CHAPTER 7

CONCLUSIONS




       87
                                                                      Packers and Movers   2012


    7.1          CONCLUSION

       According to requirement gathered and the technologies used to realize those
requirements are best utilized to achieve that functionality. The Packers and Movers Web Portal
gives a platform through which clients and different packing and moving companies can
communicate and use the services provided by this portal.



    7.2          LIMITATION OF THE SYSTEM

    Constraints:

          •   A System has limit users and agents.
          •   GUI is only in English.
          •   Application and forma is not responsible for entries provided may be wrong.
          •   There is no Payment modes is Provided for the Portal.



    7.3          FUTURE SCOPE OF THE PROJECT

              This application can be further used in developing many new applications such as
Property broker application. We can listed excellent packers movers and property brokers of
India. We can also list packers movers and other service providers of india according to the city
such as Agra, Ahmedabad, Allahabad, Ambala, Amritsar, Bangalore, Bhatinda, Bhopal,
Bhubaneshwar, Bikaner, Chandigarh, Chennai, Cochin, Coimbatore, Dehradun, Delhi,
Faridabad, Ghaziabad, Goa, Gurgaon, Gandhi Dham, Guwahati, Gwalior, Hissar, Hyderabad,
Indore, Jaipur, Jamnagar, Kanpur, Kolkata, Kurukshetra, Lucknow, Ludhiana, Madurai,
Mangalore, Mumbai, Nagpur, Noida, Panipat, Pathankot, Patiala, with their head offices or
branches which are considered reliable, trustworthy and efficient in providing packing moving
and other services.




                                                88
         Packers and Movers   2012




REFERENCES




    89
                                                                             Packers and Movers       2012



                                 REFERENCE BOOKS
[1]    "Programming Language Popularity", 2009, Retrieved 2009-01-16.

[2]    "TIOBE Programming Community Index", 2009, Retrieved 2009-05-06.


[3]    Gosling, James; and McGilton, Henry (May 1996). "The Java Language Environment".

[4]    Gosling, James; Joy, Bill; Steele, Guy; and Bracha, Gilad. "The Java Language Specification, 2nd Edition".

[5]    "Dr. Alan Kay on the Meaning of "Object-Oriented Programming"", 2003, Retrieved 11 February 2010.

[6]    Beaulieu, Alan (April 2009). Mary E Treseler. ed. Learning SQL (2nd ed.).

[7]    Darwen, Hugh (2005-04-15). "More on Relational Algebra versus Calculus".

[8]    Codd, Edgar F (June 1970). "A Relational Model of Data for Large Shared Data Banks".

[9]    ANSI/ISO/IEC     International   Standard   (IS).   Database   Language     SQL—Part      2:   Foundation
       (SQL/Foundation). 1999.

[10]   "A Brief History of NetBeans", Netbeans.org.Retrieved 2008-05-17.

[11]   "Web & Java EE", Netbeans.org.Retrieved 2008-05-17.

[12]   "Apache Tomcat 7.0 - Changelog" Retrieved 2012-04-05

[13]   "Apache Tomcat Versions", Retrieved 2011-11-12.

[14]   Conformance: requirements and recommendations. W3.org. Retrieved on 2012-02-16.

[15]   Tim Berners-Lee, "Information Management: A Proposal." CERN (March 1989, May 1990).

[16]   Introduction, Code Coverage Analysis, Steve Cornett

[17]   Binder Robert V. (1999) Testing Object Oriented System: Objects Pattern and Tools.

[18]   Beizer, Boris (1990). Software Testing Techniques (Second ed.). New York: Van Nostrand Reinhold.
       pp. 21,430. ISBN 0-442-20672-0

[19]   Bach, James (June 1999). "Risk and Requirements-Based Testing" (PDF). Computer 32 (6): 113–114.
       Retrieved 2008-08-19




                                                      90
                                               Packers and Movers   2012



                           REFERENCE SITES


[20]   http://www.w3schools.com

[21]   http://www.wikipedia.com

[22]   http://www.netbeans.org

[23]   http://www.java.com

[24]   http://www.packersandmover.com

[25]   http://www.packersindia.com

[26]   http://www.agrawalmovers.com

[27]   http://www.moversindia.com

[28]   http://www.mapesofindia.com

[29]   http://www.moversindia.com

[30]   java.com/en/download/index.jsp

[31]   docs.oracle.com/javase/tutorial/

[32]   ww.roseindia.net/java/

[33]   www.netbeans.org/




                                          91
        Packers and Movers   2012




GLOSSARY




   92
                                              Packers and Movers   2012



                    GLOSSARY
JSP     :   Java Server Page

Admin   :   Administrator

MMI     :   Man Machine Interface

C2D     :   Core to Duo Processor

IDE     :   Integrated Development Environment

SQL     :   Structured Query Language

HTML    :   Hyper Text Markup Language

SDLC    :   Software Development Life Cycle

UML     :   Unified Modeling Language

GUI     :   Graphical User Interface

H/W     :   Hardware

S/W     :   Software

CPU     :   Central Processing Unit

DFD     :   Data Flow Diagram

UML     :   Unified Modeling Language

WBS     :   Work Breakdown Structure

DVD     :   Digital Versatile Disk

RAM     :   Random Access Memory




                               93
         Packers and Movers   2012




APPENDICES




    94
                                                               Packers and Movers   2012



                                     APPENDICES


Appendices include complete DVD with all the applications required for the proper working of
the application.



The DVD contains:

   1. Software to run the project.
   2. Project Source Code
   3. Read me document for initial information
   4. Prerequisites and environment to run Project properly.




                                              95

								
To top