Project Abstract: This Online Crime Investigation System software presents the part of an organization work as per the requirements , specifications and conditions mentioned in the user manual . This application s/w has been developed and completed successfully and also tests successfully by taking “Test Cases” It is user friendly and has all the needed menu options , which can be utilized by the user to perform the desired operations .Moreover help messages are provided which will help any authorized user from using the system without trouble.

The proposed system is not limited presently. Presently we have to login to the system online and post the complaints. We can further develop the system by using “Voice Recognition System”. So this project has got scope to get developed in the near future. The scope of the project exists throughout the life of the product development, testing and implementation.

Deployment of  Application:

1) Copy Online Crime Investigation System application folder to

F:\Tomcat5.5.9\webapps\

2) Click on start.bat in bin folder of tomcat

3) Create User in Oracle as following:

CREATE USER OCR IDENTIFIED BY OCR;

GRANT DBA TO OCR;

CONN OCR/OCR

Now place the all tables in table.txt file at the SQL Command Line

And type following command

COMMIT;

4) Create user DataSourceName(DSN) as

click  –> Start —> Control Panel—> Administrative Tools

Software Requirements:

  • Operating System: Windows 98 or above
  • Front end : HTML & JAVA SCRIPT,J2EE(JSP,servlets,Ajax),
  • Back end : Oracle 8i
  • Web Server: Tomcat 5.5.9
  • Front end  : HTML & XML
  • Middleware : J2EE(JSP)
  • Back end  : Oracle 8i
  • Application server : Web logic 7.0

Crime Investigation System Screen Shots:

1.    Crime Investigation System

HomePage

Homepage for the Crime Investigation System Application

Overview

Functional Overview

This module/screen is the Homepage for the Crime Investigation System Application.

Technical Overview

This module Admin or Police Department or Customer can login through screen and customer can register.

Navigations

Customer Login ->Customer LoginScreen

AdminLogin ->Admin Login Screen

Home ->Application Homepage

Department Login ->Department Login Screen

Registration ->Customer Registration Form

ADMIN MODULE

2.    Admin Login Screen

Admin Login Screen

2.1.1    Overview

Functional Overview

This module/screen is used to Admin Login Process.

Technical Overview

  1. This module takes the valid Admin Username and password.
  2. The particulars are valid you will get Admin Homepage otherwise it will displays the message “Invalid Login Information”.

Navigation

AdminLogin->AdminLoginScreen

Action Controls

Control
Name
Type Description Action
Login button Gets the particulars of the Admin Login Details. Admin Homepage
Clear Button Clear the fields on the form Login Screen

3.    Admin Home Screen

3.	Admin Home Screen

3.1.1    Overview

Functional Overview

This module/screen is used to operate Administration Module.

Technical Overview

  1. This module is used to create new Police Departments and updating the existed department details.
  2. This module is used to create new thief Information and updating the existed thief information
  3. Creating New Caution Information.

Navigation

AdminLoginProcess->AdminHomePage Screen

Action Controls

Control
Name
Type Description Action
New Department HyperLink Displays the New Department  registration Form Department Registration Form
All Departments HyperLink Displays the existed department details screen List of departments
New Thief Information Hyperlink Displays the New thief  registration Form Thief  Registration Form
Thief Information HyperLink Displays the existed thief details screen List of Thief Information
Caution HyperLink Displays Caution registration Screen Caution Registration Form

4.    Department Registration Screen

Department Registration Screen

4.1.1    Overview

Functional Overview

This module/screen is used to register New Department Information.

Technical Overview

  1. This module takes the valid new Department Information and Login details.
  2. These New Department particulars will be stored into “POLICE_DEPARTMENT” database table and login details into “LOGIN_MASTER” table.

Navigation

New Department->Department Registration Screen

Action Controls

Control
Name
Type Description Action
Register button Gets The new Department    information and login details from the form. Stores the department data into table POLICE_DEPARTMENTlogin details into table LOGIN_MASTER
Clear Button Clears the field in the form New Department Registration form will be displayed

5.    Updating Department Details Screen

SCREEN1

5.	Updating Department Details Screen

SCREEN2

Updating Department Details Screen1

5.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Department and Updating the department  Information according  to the Department Id.

Technical Overview

  1. Click on Update then it will takes the Department Id and displays Screen2 (Popup Window).

Navigation

All Departments->Department Details

Action Controls

Control
Name
Type Description Action
Update button Displays the Department  information of selected Department Id. Displays the Department Information Screen(Screen2)
Close Button Closes the Department Modification form Displays All Department Screen (Screen1)

6.    Thief Registration Screen

Thief Registration Screen

6.1.1    Overview

Functional Overview

This module/screen is used to register New Thief Information.

Technical Overview

  1. This module takes the valid new Thief Information.
  2. These New Thief particulars will be stored into “THIEVES” database table .

Navigation

New Thieves Information->Thief Registration Screen

Action Controls

Control
Name
Type Description Action
Register Button Gets The new Department    information and login details from the form. Stores the thieves data into table THIEVES
Clear Button Clears the field in the form New Thieve Registration form will be displayed

7.    Updating Thief Details Screen

Updating Thief Details Screen

SCREEN1 

7.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Thieves and Updating the thief Information according  to thief Id.

Technical Overview

  1. Click on Update then it will takes the thief Id and displays Screen2 (Popup Window).
  2. If you select thief category then according to the selected Category it will Displays Screen3

Navigation

Thieves Information->Thieved Information

Action Controls

Control
Name
Type Description Action
Update button Displays the Thief   information of selected Thief Id. Displays the Thief Information Screen(Screen2)
Close Button Closes the Thief Modification form Displays All Department Screen (Screen1)

8.     Caution Registration Form

Caution Registration Form

7.1.2    Overview

Functional Overview

This module/screen is used to Create New Cautions.

Technical Overview

  1. This module takes the valid caution Information and will be stored into CAUTIONS Data Base Table.

Navigation

Caution->Caution Registration Form

Action Controls

Control
Name
Type Description Action
Save button Gets the required input details. caution Information and will be stored into CAUTIONSData Base
Clear Button Clears the fields data New Caution Form will be displayed

DEPARTMENT MODULE 

8.    Department Login Screen

Department Login Screen

8.1.1    Overview

Functional Overview

This module/screen is used Department Login Process.

Technical Overview

  1. This module takes the valid Username and password.
  2. The particulars are valid you will get Department Homepage otherwise it will displays the message “Invalid Login Information”.

Navigation

Department Login->Department Login Screen

Action Controls

Control
Name
Type Description Action
Login button Gets the particulars of the Department Login Details. Department   Homepage
Clear Button Clears the Form Details New Login Screen Will be displayed

  

9.    Department HomePage

Department HomePage

9.1.1    Overview

Functional Overview

This module/screen is used to process the Department operations.

Technical Overview

  1. In This module department can see his complaint details and thief information.
  2. Updating complaint status and modifying the selected thief informtaion.

Navigation

Department Login Process -> Department Homepage. 

10.    Requested Complaints

Requested Complaints

10.1.1    Overview

Functional Overview

This module/screen is used Display the complaints Information.

Technical Overview

  1. Updating the complaint status by changing the options in the Modify column.
  2. In options when the complaint status is ‘Closed’ then only you will get new option ‘ReOpen’ in the options

Navigation

Requested Complaints->Complaints Status

Action Controls

Control
Name
Type Description Action
Update button Gets the modified details. Changes the status of the complaint in COMPLAINT_REG Table

 

11.    Thief Details Screen

Thief Details Screen

11.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Thieves and Updating the thief Information according  to thief Id.

Technical Overview

  1. Click on Update then it will takes the thief Id and displays Screen2 (Popup Window).
  2. If you select thief category then according to the selected Category it will Displays Screen3

Navigation

Thieves Information->Thieve Information

Action Controls

Control
Name
Type Description Action
Update button Displays the Thief   information of selected Thief Id. Displays the Thief Information Screen(Screen2)
Close Button Closes the Thief Modification form Displays All Department Screen (Screen1)

 

12. Customer Information

Customer Information

11.1.2    Overview

Functional Overview

This module/screen is used to Display all registered Customer Details

Navigation

Customer Information->Customers Information Screen

CUSTOMER MODULE 

12.    Customer Registration Screen

Customer Registration Scree

12.1.1    Overview

Functional Overview

This module/screen is used to Customer Registration.

Technical Overview

  1. This module takes the valid new Customer Information and Login details.
  2. These New Customer particulars will be stored into “CUSTOMER_MASTER” database table and login details in “LOGIN_MASTER”.

Navigation

Registration->Customer Registration Screen

Action Controls

Control
Name
Type Description Action
Register Button Gets The new Customer information and login details from the form. Stores the employee data into table CUSTOMER_MASTER
Clear Button Clears the field in the form New Registration form will be displayed

13.    Customer Login Screen

13.	Customer Login Screen

13.1.1    Overview

Functional Overview

This module/screen is used Customer Login Process.

Technical Overview

  1. This module takes the valid Username and password.
  2. If The particulars are valid you will get Department Homepage otherwise it will displays the message “Invalid Login Information”.
  3. If you forgot your password then click on Forget Password option.

Navigation

Customer Login->Customer Login Screen

Action Controls

Control
Name
Type Description Action
Login button Gets the particulars of the Customer  Login Details. Customer    Homepage
Clear Button Clears the Form Details New Login Screen Will be displayed

 

14.    Customer HomePage

Customer HomePage

14.1.1    Overview

Functional Overview

This module/screen is used to process the Customer operations.

Technical Overview

  1. In this module customer can register his complaints and update the complaints.
  2. Customer can modify the complaint information, if the status is “Pending”.
  3. Checking the status of the complaints.
  4. Displaying all department details.
  5. Displaying all thief information.
  6. Changing the personal details.
  7. changing the password.

Navigation

Customer  Login Process -> Customer  Homepage

15.    Complaint Registration Screen

Complaint Registration Screen

15.1.1    Overview

Functional Overview

This module/screen is used to register the new Complaint

Technical Overview

  1. This module takes the valid new Complaint Information.
  2. These New Complaint particulars will be stored into “COMPLAINT_REG” database table.

Navigation

Complaint Registration->Complaint Registration Screen

Action Controls

Control
Name
Type Description Action
Register button Gets The new Compliant   from the form. Stores the Complaint data into table COMPLAINT_REG
Clear Button Clears the field in the form New Complaint  Registration form will be displayed

16.    Thief Details Screen

Thief Details Screen

16.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Thieves Information.

Navigation

Thieve Information->Thieve Information

17.    Department Details Screen

 Department Details Screen

17.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Departments Information.

Navigation

Departments->Department Information

18.    Changing Customer Profile

Changing Customer Profile

18.1.1    Overview

Functional Overview

This module/screen is used to Change the Customer Information.

Technical Overview

  1. This module takes the modified Customer Information from (Screen1).
  2. These New modified   particulars will be updated into “CUSTOMER_MASTER” database table.
  3. If u want update these modified details then click on “Update” in SCREEN1
  4. If you want to change the password then click on “Change Password” then “SCREEN2” will be displayed

Navigation

Change Profile->Customer Information

19.    Complaint Status Details Screen

 Complaint Status Details Screen

19.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Complaints.

Technical Overview

  1. This module takes the valid search options like datewise and compliant type.
  2. According to the selected search option the complaints will be displayed.
  3. Click on “Show All” button, If no option selected then it will display all complaints information.
  4. Click on “Search”  button without selecting any search option then it will display message “Select Valid Search option”

Navigation

Complaint Status->Complaint Information.