Passort Automation System

8/2/2019 Passort Automation System

1/35


2/35

Passport Automation System is used in the effectivedispatch of passport to all of the applicants. This system

adopts a comprehensive approach to minimize the manualwork and schedule resources, time in a cogent manner.

The core of the system is to get the online registration formfilled by the applicant whose testament is verified for itsgenuineness by the Passport Automation System with

respect to the already existing information in the database.This forms the first and foremost step in the processing ofpassport application.

Problem Statement


3/35

After the first round of verification done by thesystem, the information is in turn forwarded to theregional administrator's office. The application is thenprocessed manually based on the report given by thesystem.

The system forwards the necessary details to thepolice for its separate verification whose report is then

presented to the administrator. The administrator will be provided with an option to

display the current status of application to theapplicant, which they can view in their onlineinterface. After all the necessary criteria has been met,the original information is added to the database andthe passport is sent to the applicant.


4/35

Scope

The System provides an online interface to the user where theycan fill in their personal details. The authority concerned with the issue of passport can use thissystem to reduce his workload and process the application in aspeedy manner.

Provide a communication platform between the applicant andthe administrator.Transfer of data between the Passport IssuingAuthority and the Local Police for verification of applicant'sinformation.

Users/Applicants will come to know their status of applicationand the date in which they must subject themselves for manualdocument verification.

Software Requirement

Specification


5/35

Technologies to be used

HTML JSP Java script Java

XML AJAX

Tools to be Used

Eclipse IDE ( Integrated DevelopmentEnvironment) Rational Rose tool ( for developing UML Patterns)


6/35

User Characteristics :

Applicant - They are the people who desires to obtain thepassport and submit the information to the database.

Administrator - He has the certain privileges to add thepassport status and to approve the issue of passport. He maycontain a group of persons under him to verify

the documents and give suggestion whether or not toapprove the dispatch of passport.

Police - He is the person who upon receiving intimationfrom the PAS, perform a personal verification of theapplicant and see if he has any criminal case against him

before or at present. He has been given with the power todecline an application by suggesting it to the Administratorif he finds any discrepancy with the applicant. Hecommunicates via this PAS.


7/35

Use Case Diagram

Activity DiagramClass Diagram

State Chart Diagrams

Interaction Diagrams

Package Diagram

Component and Deployment Diagram

UML Diagrams


8/35

Use Case Diagram


9/35

Activity Diagram


10/35

Class Diagram


11/35

Applicant

State Chart Diagrams

register

login

get,fill,sub

mit form

checkstatus


12/35

Administrator Police

get details

from admin

checkeligibility

check

consistency

set status

fwd to

police

does personal

verification

check

details

set status


13/35

Applicant PAS admin Admin panel police data storage

register into

the Passport

Automation

System(PAS)

register login detailsare stored

logincheck for authorised entry

get form

form is filled

and

submitted

store form details

authorised entry by adminform is

checked and

categorised

get submitted form

forward to panel

eligibility and

consistency

checking

report status

forward to police

police does personal verification

report status

set status

set status

check status

form is filled

and necessary

proofs

enclosed

applicant checks

status to know

whether the

application is

accepted or

denied

check status reports

issues the passport

Sequence Diagram


14/35

Applicant

PAS

admin

Admin

panel

police

datastorage

1: register

2: login detailsare stored

3: login

4: check for authorised entry

5: get form

6: store form details 7: authorised entry by admin

8: get submitted form

9: forward to panel

10: report status

11: forward to police

12: set status

13: report status

14: police does personal verification

15: set status

16: check status

17: check status reports

18: issues t he passport

Collaboration Diagram


15/35


16/35

applicant

PAS

admin

adminpanel

police

datastorage

Component Diagram


17/35

CLIENT

Applicant

PAS

SERVER

Admin

Data storage

Admin panel

POLICE

Police

verification

Deployment Diagram


18/35

User InterfaceLayer


19/35


20/35


21/35


22/35


23/35


24/35


25/35


26/35


27/35


28/35


29/35

Technical ServicesLayer


30/35


31/35

DomainLayer


32/35

To apply for a new passportTo generate form number:

Insertion of details into database:

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

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

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

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

.

.

.

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

Connection conn = DriverManager.getConnection("jdbc:odbc:alaab" ,"","");

String sql = "insert into newformdetails values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

PreparedStatement pr = conn.prepareStatement(sql);

pr.setString(1,request.getParameter("nme"));

pr.setString(2,request.getParameter("applsurname"));

pr.setString(3,request.getParameter("applname"));

pr.setString(4,request.getParameter("chsurname"));

.

.

.

pr.executeUpdate();


33/35

To renew a new Passport:

String sql2 = "select * from adminverify where formnumber='" + ppnumber + "'";Connection con2 = null;Statement st2 = null;ResultSet rs3 = null;String conn2 = "jdbc:odbc:alaab";

con2 = DriverManager.getConnection(conn2);st2 = con2.createStatement();rs3 = st2.executeQuery(sql2);String s;if (rs3.next()){int x = rs3.getInt(7);

s = rs3.getString(8);int y = rs3.getInt(9);int z = rs3.getInt(10);if (y


34/35

Status Details:

String ssql1 = "select * from adminverify where formnumber='" + pp + "' and status='yes'";

ResultSet rs3 = st2.executeQuery(ssql1);if (rs3.next()){out.println("

STATUS

YOUR PASSPORT ISPROCESSED
");s1 = rs3.getString(1);s2 = rs3.getString(5);s3 = rs3.getString(6);s4 = rs3.getString(7);
s5 = rs3.getString(8);s6 = rs3.getString(9);s7 = rs3.getString(10);out.println("FORMNUMBER " + s1 + "ISSUE DATE" + s2 + "/" + s3 + "/" + s4 + "PASSPORT NUMBER" + s5 + "CURRENT YEAR " +s6 + "EXPIRY DATE " + s2 + "/" + s3 + "/" + s7 +"");

}


35/35

ThankYou

Passort Automation System

Documents

Transcript of Passort Automation System