Tag: JSP

Posted on

E-Learning System Web Portal Java Project

Objective:

“e-Learning” is an educational-based java web application; this web portal helps college students to get all the resources & study materials of every course available on the online portal. All the students can access this website portal anytime and from anywhere on the internet. E-Learning System is a very good online e-learning portal compared to all web links given by Google, Bing, Yahoo, ChatGPT, or any website while searching for student course materials.

Contents

Existing System:

In Present Educational based E-learning system, students can get information from books or study materials provided by professors manually. But in this system, students may not get the related and sufficient information according to their syllabus. The above resources do not provide discussion forums between students and professors to clarify their doubts. There is no proper guidance for the students.

Proposed System

The main aim of this E-Learning system is to provide sufficient study materials to the academic students according to their syllabus from which students can easily download study materials of their relevant course. The first step is to register in order to access this website. In this system, we are providing discussion forums between students and professors where students can easily clarify their doubts. Modules of this website are Admin, professor, student, and mentor.

Modules:

Admin:

  • Admin can view all member’s details like professors/asst. professors, mentors, and students. Here each user (student/mentor/professor) can upload material.
  • The uploaded material can be verified by the admin. The admin can validate the material if the material is related to the subject. The validated materials are only visible to the students.
  • The admin can view the queries which are sent by the students to the mentors. The admin can also check how many solved queries and unsolved queries.

Student:

  • Each student must and should be registered before login. Here we have user authentication every time. Students can upload material, view material, and send queries. The upload materials first verify by the admin and then visible in the view material tab.
  • The student view uploaded material by all the users which is validated by the admin and he can download materials.
  • The student can send a query to the mentor if he/she has any doubts regarding academic subjects.

Mentor:

  • Mentor registration and login.
  • Mentors can upload material, view material, forward queries, and reply to queries. The upload materials first verify by the admin and then visible in the view material tab.
  • The Mentor view uploaded the material by all the users which is validated by the admin and he can download materials.
  • The Mentor can solve a query if he/she is unable to solve queries forward it to Asst.Professor/Professor.

Professor:

  • Professor registration and login.
  • Professor can upload material, view material, and reply to queries. The upload materials first verify by the admin and then visible in the view material tab.
  • The Professor view uploaded the material by all the users which are validated by an admin.
  • The Professor can solve a query and send it back to the mentors.

Software Requirements:

           Operating System: Windows 10/11

           Web Technologies: HTML, CSS, JavaScript

           Programming Language: Java, JSP, Servlets

           Backend Database: MySQL /Oracle 10G

           IDE / Work Bench: Eclipse/ Netbeans

Posted on

QR Code based Customer Billing System for Supermarket Shopping Project

ABSTRACT

The objective of this project is to propose a real-time capturing system that helps consumer billing for hypermart shopping using Quick Response (QR) code in Android smartphones.

EXISTING SYSTEM

Nowadays in most hypermart shops, customers have to take a long queue for billing after shopping and it’s a time-consuming process. Also, users will not be aware of the total bill amount at the time of purchase. Increase time spent at the billing counter and reduces customer satisfaction.

PROPOSED SYSTEM

When a customer entered a shopping mall or a hypermart for shopping, his smartphone will be connected to the hypermart’s server. After the successful connection with the server, he can start purchasing. At the time of shopping, the QR code should be read for bill generation. QR code pattern can be read by android smartphones at the time of adding an item to the cart. The QR code will identify the price of the product and it will automatically calculate the total price according to the quantity of the product in the cart. So QR code verifies products by capturing them through a smartphone, then decodes them and sends them to the server for authentication. When the user finishes his shopping, the total amount will be displayed on his phone as well as the cashier’s monitor. You can also visit & download the PHP, My SQL Application project on Supermarket Inventory Management System.

 This will avoid huge queues and waste of time for billing after shopping. The customer can plan his shopping whether to continue or not by viewing the purchase bills so that he can manage the bill and shopping effectively.

The project consists of two main modules.

Admin module

Admin will add the products with their price, manufacturing details, and quantity information. He can view the billing and purchase details of customers and generate daily, weekly, and monthly billing reports. Admin can add the products with their price, manufacturing details, and stock information without any duplication. Based on the arrival of new stock and purchasing the product from the stock, the stock quantity will be updated. He then generates a QR code for each product. He can view the billing and purchase details of customers. Accordingly, he can generate daily, weekly, and monthly billing reports.

User module

User can plan their shopping using this app. The user can register with the app. When he enters a hypermart, he can scan the QR code of the product and can view the corresponding product details. Then submit the quantity to be taken. He can finally submit his items in the cart to generate the bill and also have the facility to cancel items from the cart. 

This Supermarket Management and Billing System are related to the Customer Billing System for Supermarket Shopping Project. You can also visit & download the Java Application project on Supermarket Management and Billing System

SOFTWARE  REQUIREMENTS

  • Operating system:   Microsoft Windows XP/above, Android
  • Platform:   Net Beans, Eclipse
  • Front End:   JSP, Android
  • Back End:   MySQL

TABLES        

Table 1: Login

Primary key: username

Purpose: To store login details

Column

Type

Description

Username

varchar(50)

 Primary Key, Email id

Password

varchar(50)

 Password, unique password

User type

varchar(50)

 user type

Status

varchar(50)

 Status

Table 2: Customer

Primary key: customer_id

Foreign key: emailid

Purpose: To store customer details

Column

Type

Description

customer_id

int(50)

 Primary Key, customer id

customer_name

varchar(50)

Name of customer

emailid

varchar(50)

 Foreign Key , Email id

Phone_number

bigint(50)

 Phone Number of Customer

address

Text

 Address of Customer

appcode

varchar(50)

 App code

 

Table 3: Category

Primary key: category_id

Purpose: To store category details

Column

Type

Description

category_id

int(50)

 Primary Key, Category id

Categoryname

varchar(50)

 Category Name

 Table 4: stock

Primary key: stock_id

Foreign key: product_id

Purpose: To store stock details

Column

Type

Description

stock_id

int(50)

 Primary Key, Stock id

product_id

int(50)

 Foreign Key, Product id

Stockqty

bigint(50)

Quantity of Stock

Stockdate

date

Stock Added Date

Status

varchar(50)

Status

Table 5: product

Primary key: product_id

Foreign key: category_id

Purpose: To store product details 

Column

Type

Description

product_id

int(50)

 Primary Key, Product id

productname

varchar(50)

Product Name

category_id

int(50)

Foreign key, Category id

Quantity

bigint(50)

Quantity of product

manufacturingdate

date

Manufacturing Date

Expirydate

date

Expiry Date

Price

double

Price of Product

manufacturer

varchar(50)

Manufacturing company

Description

text

About the product

Madein

varchar(50)

Country name

Image

varchar(50)

Image of product

Qrcode

varchar(50)

Quick Response code

Status

varchar(50)

Status

Table 6: cart

Primary key: Cartid

Foreign key: Email

Purpose: To store cart details

Column

Type

Description

Cartid

int(11)

 Primary Key, Cart id

Email

varchar(50)

 Foreign Key, Email

Cdate

date

 

Flag

int(11)

 

Table 7: cart_item

Primary key: cart_item_id

Foreign key: Cartid , product_id

Purpose: To store cart item details

Column

Type

Description

cart_item_id

int(8)

 Primary Key, Cart item id

Cartid

int(8)

 Foreign Key, Cart id

product_id

int(8)

 Foreign Key, Product id

no_of_quantity

int(8)

 Quantity of product

 Table 8: purchase

Primary key: purchase_id

Foreign key: bill_no, Emailed, product_id

Purpose: To store  purchase details

Column

Type

Description

purchase_id

int(8)

 Primary Key, Purchase id

bill_no

int(8)

 Foreign Key, Bill No

Emailed

varchar(50)

 Foreign Key, Emailed

product_id

int(8)

 Foreign Key, Product id

purchase_date

date

 Product Purchased Date

Quantity

bigint(15)

 Quantity of product

Table 9: bill

Primary key: bill_no

Foreign key: Emailed

Purpose: To store bill details

Column

Type

Description

bill_no

int(50)

 Primary Key, Bill No

Emailed

varchar(50)

  Foreign Key, Emailed

Amount

int(50)

 Total Amount

bill_generate_date

date

Date of bill generated

Status

varchar(50)

 Status

Table 10: feedback

Primary key: feedback_id

Purpose: To store feedback details

Column

Type

Description

feedback_id

int(8)

 Primary key, Feedback id

from_id

varchar(50)

 Sender’s id

Message

varchar(50)

 Message

send_date

date

 Feedback send date

Download the complete Android app project on QR Code based Customer Billing System for Supermarket Shopping Project.

Also, Read this Sales Management System for Hypermarkets PHP & MySQL Web Application Project.

Posted on

IoT based Attendance System Project Using Blockchain and JAVA MySQL

The success of this IoT-based Attendance System app will ensure that many more parents and organizations will be motivated to use this common platform. It becomes complicated when strength is more. With the increase in technology, attendance monitoring is designed with android or web-based applications. However, the intention of this design is to provide a Blockchain-based app that can be downloaded and used by the organization with no third-party control to meddle with the data.

There is an update option to modify attendance when it’s needed. However, the modifications are recorded and tracked, just in case, it’s a fraudulent activity. Attendance is captured using IOT automatically and is entered into the blockchain which makes the data tamper-proof, secure and robust. The privacy of its users is preserved because the user ids are generated by a trusted third party. This data is available for the government for Scholarships and other related decision-making.

IOT-based Attendance System using Blockchain is an application that is made for students and faculty of a particular college to maintain students’ attendance which is captured through an IOT device(biometric) and then the attendance is stored in the Blockchain. Blockchain is used in this application to ensure safety and a tamper-free environment as the data cannot be manipulated and is used for government purposes.

Objectives

Generally, in many institutions attendance is monitored and marked using conventional systems like android or other similar web applications. Few conventional databases do not have features like checking whether any information has experienced unauthorized changes or not. In this system when the data is entered into the blockchain, no one is allowed to edit or delete the data.

This makes the application transparent and different from other web-based attendance systems as IoT is used to capture attendance through biometrics of the students in the class. Students’ poor attendance rate is one of the most challenging problems tackled by college management today. With the help of this application, student attendance rates can be improved which is also helpful for the government to take precise decisions regarding scholarship-like schemes for students with transparent data. Using blockchain and some encryption techniques, this application is made secure from any manipulations.

Student Login Page

Methodology

The fingerprint module will collect fingerprint data from multiple users and sends it over the internet to the website. The IoT-based Attendance System website is coded in HTML, and CSS, JSP has a MySQL database, and records of attendance are stored in Blockchain. By logging into the website, the student can view all their attendance records. The timestamp of students’ attendance is encrypted and stored in the blockchain.

CONCLUSION AND FUTURE SCOPE

This IoT-based Attendance System application helps to automize the attendance system and makes it easy to manage all the data. Encryption, decryption, and blockchain make the application very secure. The application has a very user-friendly UI and is made to keep UI and UX in consideration.

The future enhancement of this IoT based Attendance System application is

  • To use Ethereum to make the application up to date with the technologies
  • To generate automatic weekly and monthly reports

DATABASE TABLES SCREENSHOTS

Tables in the project.
Test case showing the home page after pasting the URL in the browser
Test case showing navbar functionalities working.
Test case showing login is done and navigated to the home page
Test case showing student registration is working.
Test case showing faculty registration
Test case showing faculty registration is working.
Test case showing attendance stored in blockchain

IoT based Attendance System Using Blockchain
Test case showing student’s attendance records.
Test case to get student report
Test case showing Student’s attendance report.
Test case showing download report is working
Test case showing all student details.
Test case showing all student’s attendance records.

Flow Chart Diagram:

Flow Chart

Architecture Diagram

Architecture Diagram

Usecase Diagram:

usecase diagram

Software Requirements

Programming Language: Java
Graphical User Interface: HTML, CSS with Bootstrap, JSP
Libraries: MYSQL connector jar file, Apache Tomcat jar file
Encryption Algorithm: SHA-256
API: JDBC
Framework: Java EE
Tool: Eclipse, MYSQL

Hardware Requirements:

IOT Fingerprint Scanner

Posted on

College Campus Students and Faculty Activities Tracker Java Project

College Campus Activities Tracker deals with the tracking of both student and faculty performance and the activities done by them in and out of the college. This project can help us to know all the activities happening in the college campus area and even get to know who has scheduled the activity. Different certificates of the students based on their performance are generated department-wise and academic year-wise.

Our Students and Faculty Activities Tracker system has two users, faculty and student.

The student will upload their certificates that they have participated in other colleges and the faculty will schedule the activity and upload the respective student’s certificates to those who have participated in the activity.

College Activities Tracker is a java web application that will allow the users (both faculty and students) to upload their documents and intimating each activity (hackathon, workshops, competitions) that they participate in and out of the college with certifications as proof.

And it should also allow the user to register for ongoing or upcoming events through the form and after registration, A successfully registered message should be sent to the user to their corresponding phone number. The faculty must be allowed to check or keep track of student and faculty performance and previews the data student-wise, faculty, wise, section-wise, department-wise, event-wise, and duration wise. And faculty should be allowed to add/update the upcoming event happening in the college.

Results Page of College Activities Tracker

INTRODUCTION

College Campus Students and Faculty Activities Tracker is an application that will aid users in uploading their Documents and intimating each activity that they perform in and out of the college with Certifications as proof.

This is a centralized system that keeps track of students and faculty activities and previews the data student-wise, faculty-wise, section-wise, Department wise, Event wise, and Duration wise. It is mainly used to maintain the data for Department’s weekly report.

Modules of the Project

We have three modules in our Activities Tracker Java Project.

● Admin
● Student
● Faculty

SOFTWARE SPECIFICATION:

Software Requirement:

1. Language – Java (JDK 1.7)
2. OS – Windows 7- 32bit
3. MySql Server
4. JDBC
5. JSP

Posted on

A DBMS Project on Fingerprint-based Attendance System

In this Fingerprint-based Attendance System Database management System project, we have tried to use the knowledge that we gained in this course to make a Fingerprint-based Attendance System. Although we had aimed to implement it using hardware due to hardware constraints, we have tried to implement it online. In this DBMS system, the Faculty for a particular course switches ON the system, and the system marks attendance for the students based on their fingerprints.

Features:

This system apart from marking attendance also maintains the student’s records and the faculty members. We have tried to incorporate the following features:

Administrator: For the modification of crucial information we have created an administrator account. The Administrator only has the privilege to add/remove courses and edit profiles of students and faculty members.

Login Page: On this page, the students and faculty members can log in to their accounts and view their information.

Register Page: For students and faculty members who don’t have their accounts can create their accounts by clicking on REGISTER on the login page. The register page asks for data and creates a profile.

Timetable: This page displays the schedule of all the courses.

Attendance: On this page, a list of the currently running courses and their respective faculty is displayed. There is a slot for the faculty fingerprint. Once the faculty fingerprint matches with any one of the faculty members whose name is being displayed on the page the system automatically turns ON the database to be modified. Now the students are required to input their fingerprints and their attendance is marked.

Tools used:

  • Database Management System: MySql
  • Server for hosting the project: Apache Tomcat with port number 8080.
  • Programming scripts: Java Server Pages, Javascript, HTML, CSS.

Relation to the course:

This whole project like many other projects has two ends. The Front end consists of the GUI which has been made using our prior knowledge and the Back end consists of database interaction which we have learned in this course. We have tried to incorporate the following things that we have learned in this course.

ER Model: The basic thing that we did before starting with the project was to make an ER Model and check the feasibility of the project. This helped us in enlisting the various aspects and classify them into entities and relations.

MySql Queries: In this project we have tried to incorporate the different queries such as Insert, Create, Update, and Alter that we learned in this course.

Triggers: To let the student know about his short attendance we have tried to incorporate the concept of triggers.

System Time: We have tried to fetch the system’s current time and have used it to compare it with the time of the lectures stored in the database.

Conclusion:

While working on this project we brushed upon the knowledge we gained in this course and the hardships and problems faced in implementing such a real-time project helped us learn a lot.

Posted on

Design & Development of Tender Management System Project

Abstract:

The Tender Management System was developed to enable the vendors to get all the tender details online and provide a facility to submit the tender. This Tender Management System project was developed & designed with Java & MySQL Database.

Existing System:

  • Contractors need to submit their documents by visiting the office or centers on time.
  • Contractors have to bid for a particular tender on time by applying forms and need to wait for an approval reply.
  • The Admin Needs to post the Projects or contracts as a poster or advertisements regularly.
  • It takes a long time to access tenders or vendors’ data access.

Proposed System:

  • User Needs to Have a Network Connection.
  • New User needs to register a new vendor on the website.
  • Contractors can log in and bid for some existing tenders.
  • They need to log in using their login-id and password which they used while registration
  • To reduce paperwork, and data that are available online, using this final decision can be taken by the administration and can contact directly to such suppliers.
  • Easy to access the tenders and vendors’ data.

Software Requirements:

Language: Java
Web technologies : J2EE (JDBC/Servlets/JSP)
Front-end Design : Html, CSS, JSP, Bootstrap
Database: MYSQL
Scripting: JavaScript , CSS

Application Work Flow

Modules:

Administrator

Uploading advertisement documents
Verifying projects and contractors by using their information
Accepting and Rejecting Bids
Maintaining data and confirmation of the final report.
Update Notice Board
Make some announcement
Block or unblock some vendors or company

Company

The Company needs to get registered to proceed.
The company can log in with a valid username and password.
Apply or releases new tenders and view the status of the tender.
Make Some announcements.
Change the tender details
Documentations

Vendor

Vendors are the key persons or contractors who look for new upcoming tenders on the website
Vendors’ Functionality includes:
New Vendors can register
Login using vendor-id and password
View and update their profile
See the new open tenders and their details
Bid for a tender with an amount greater than its base price
See the bid approval or denial status

After the tender status approval, they can view and submit the documentation
Vendors can look for the important notice in the notice section

Conclusion

Our Project Tender management System Successfully Created a user-friendly environment for the tender management process.
This Project is flexible and changes can be incorporated easily.
Easy for further Modification
Saves a lot of time by doing most of the processes online
It may lead to increase profit and improve the quality of a company.
Assigns the tenders and project in a good manner and optimal way to the contractors in less time with low-cost charges.

Download the complete Design & Development of Tender Management System Project using Java, MySQL, HTML, CSS, JavaScript, Bootstrap, and J2EE.

Posted on

Online Electronic Easy Repair Java & MySQL Project Source Code & Report

Online Electronic Easy Repair Project is a web application that is developed in the Java platform by using Html, CSS, JavaScript, JSP, and Servlets. Here Students can download the complete Java & MySQL Project Source code, Project Report, PPT & Output Video.

This project deals with the features of “Easy repair of electronics”, which is developed to use an online application mode for E-Services at the doorstep.

Nowadays the usage of electronics has increased, and if there are any problems with electronics, customers need to bring the electronics for repair to the nearest technicians. To overcome the issue we have come up with an online application that will provide technicians who can repair the electronics at the doorstep.

Online Electronic Easy Repair is a supplier of local services. This provides search services, particularly for electronic devices, and is available on the internet and mobile phones. This website’s homepage includes two modules, one for customers and one for technicians. If a customer needs a service for their electronic devices, the customer can select the type of service he needs and can also select the location where the service is to be performed.

The Customer can select the technician who is available in the location and get the service done at his doorstep. Within a short period if the customer faces the same issue again then he can upload the softcopy of the invoice and can claim on the website. Our website can provide customers with one free and truthful service by checking the invoice.

The second module is only for the technicians for the purpose of registration. With valid information, the technician should register. He could thus receive opportunities for work.

OBJECTIVE

The objective of this project is

  • Build user-friendly software that customers and technicians can easily understand.
  • The application must respond to the changes quickly.
  • In heavy use, the software must perform well.
  • The application should provide services at reasonable prices to the customers.
  • To Make Technicians available 24/7 to the customers.

SCOPE

The aim of the project is to design and develop an online application that will help customers to search for a technician who can fix the electronic devices at their doorstep.

MODULES OF THE PROJECT:

  • Customer
  • Technician

Customer Sub Modules:

  • Search for Technician.
  • View Details of Technician.
  • Contact Technician.
  • Rate a Technician.

Technician Sub Modules:

  • Register.
  • Login.
  • Update Profile.

Output Screens:

  • Home Page
  • Technician Registration Page

  • Technician Login Page
  • Technician Home Page
  • Admin Login Page
  • Admin Home Page
  • View & Activate Technician
  • Customer Registration Page
  • Customer Home Page
  • Book page with the help of a map

  • View Booking Page
  • Status Page
  • Generate Bill Page

  • Generate Form
  • View Bill Page
  • View History Page
  • E-Waste Page
  • Give Rating Form page
  • View Rating Page
  • Collect E-Waste Page

Functional Requirements

This project contains three modules

  1. Admin
  2. Technician
  3. Customer

Admin:

In this project, Admin Is the owner of this web application. Admin maintains the web application. We have an Admin login form, admin login to web application with respective username and password. Admin view and check the technician’s details. After verification, Admin activates the technicians. Admin collects electronic waste (E-waste) like broken and useless materials for recycling.

Technician:

A technician is a professional worker with inappropriate technology. In this Project, the technician fills out the registration form with valid information. Admin decides (activate) the technician for a web application. A technician can log in to the web application after activation only. The technician can view the customer bookings and accept the customer booking requests. Technicians can accept customer requests when customers are from the same location. Technicians generate an online bill with a unique booking id, and with that unique booking id technician collects the payment from customers. A technician can view the customer ratings for his work.

Customer:

The main module in this project is the customer. A customer has to register for booking a technician for his/her home electronic repair. Customer log in to web application with a belonging username and password. A customer books the technician for his/her belonging device work. A customer can enter the exact location (latitude and longitude) with the help of Google Maps. A customer has the option to view the ratings of a technician before comes to work. A customer checks the status of whether a technician accepts the booking request or not. A customer views the generated bill and pays the amount through an online service. Customer can view their booking history by clicking on history. After the Completion of a technician work a customer wants, he/her can give a rating to a booking technician. If a customer has electronic wastage he/her can send that wastage to an admin.          

Download the complete Online Electronic Easy Repair Java & MySQL Project Source code, synopsis, UML Diagrams, Project document, PPT & Output Video.

Posted on

Online Job Portal Java Project Report & Source Code

Objectives of the project:

  • Registration
  • Login
  • Authenticating
  • Updating Profile
  • Posting a job and removing or modifying job
  • Searching for a job
  • Taking online exam
  • Feedback

LITERATURE SURVEY

There are many applications developed related to this Online Job Portal, but, however, these systems are very complex for their own purpose. Most of them do not have the centralized database and easy access to users. So in this project, we are implementing this application through a centralized database and easy-to-use access for job seekers and job providers. The administrator is the primary actor to maintain the database, and also accepts comments from job providers and job seekers to improve and develop the application’s graphical user interface. Registered job seekers can also take the company online exam. In addition, qualified applicants can be classified according to this system based on their qualifications and company requirements.

Limitations

• The current Online Job Portal system is not a fully computerized and manual system for entering job candidates and job provider data and managing it.
• There is no centralized database maintenance
• There is no easy access to records of people seeking work in particular
• Job seekers can not easily navigate through the database

Benefits

• It is a fully automated system for managing the Online Job Portal database
• This system provides centralized database maintenance
• This system provides easy access to certain job seekers or their complete details
This system gives job seekers easy to navigate through the application to get more information in the most secure way.

IMPLEMENTATION

5.1. MODULES

The system is divided into three major parts depending upon the requirement they are.

  • 1) Administrator
  • 2) Job Provider
  • 3) Job Seeker

Administrator

All the users are controlled by admin. Administrator services are

  1. view job providers
  2. view job seekers
  3. view feedback

Examination

The job providers prepared questions and update the providers and conduct examinations to the job seekers and also send the particular examination results.

And the job seeker searches the particular job then attends the exam and also views his results after completion of the exam.

Software Requirements: 

Operating System: Windows XP/2003 or Linux/Solaris

User Interface: HTML, CSS

Client-side Scripting: JavaScript

Programming Language: Java

Web Applications: JDBC, JSP

IDE/ Workbench: Eclipse with My Eclipse Plug-in

Database: Oracle

Server Deployment: Apache Tomcat 6.0

Screen Shots:

  • HOME PAGE
  • LOG-IN PAGE
  • ADMIN PAGE
  • JOB PROVIDERS IN DB
  • JOB SEEKERS IN DB
  • FEEDBACK PAGE
  • JOB PROVIDER PAGE
  • UPDATE PROFILE PAGE
  • ADD NEW VACANCY PAGE
  • SEARCH JOB SEEKER PAGE
  • RESULT PAGE FOR SEARCH JOB SEEKERS
  • EXAM MANAGEMENT PAGE
  • PREPARE EXAM PAPER PAGE
  • PREPARING QUESTIONS PAGE
  • ADDING QUESTIONS PAGE
  • RESULT PAGE FOR SEARCH JOBS
  • EXAM MANAGEMENT PAGE
  • TAKING EXAM PAGE

TEST CASE REPORTS 

Name of the page: Admin Login

Sno TEST CASE Expected Result Actual Output Remarks
 1 New Admin logged on without sign in. Should return a message sign in  before log in. Sign in First Success
2. Invalid password Enter correct password Wrong password Success
3. Invalid username Invalid User Enter valid name Success
4. Special character entered in password field. Verify your password You Entered Invalid password Success

Name of the page: Job provider Login 

Sno TEST CASE Expected Result Actual Output Remarks
 1 New provider tried to log on without sign up. Should return a message sign up  before log in.   Failure
2. Invalid password Enter correct password Wrong password Success
3. Invalid username Invalid User Enter valid name Success
4. Special character entered in password field. Verify your password You Entered Invalid password Failure

 Job Seeker Login 

Sno TEST CASE Expected Result Actual Output Remarks
 1 New seeker tried to log on without sign up. Should return a message sign up  before log in.   Failure
2. Invalid password Enter correct password Wrong password Success
3. Invalid username Invalid User Enter valid name Success
4. Special character entered in password field. Verify your password You Entered Invalid password Failure

Name of the page: Exam Management 

Sno TEST CASE Expected Result Actual Output Remarks
 1 Provider tried to add exam paper without scheduling Schedule first NULL Failure
2. Seeker tried to write same exam again exam already taken Can Write Failure
3. Displaying a message after time up in exam Time up Time up Success
4. Selecting exam before scheduling date Invalid test NULL Failure

 

Posted on

Booking Photography Java Project

Abstract:

Booking photography is a project which will enable customers or clients to book professional photographers online. It is difficult for those who want to book a photography session to request their favorite photographer since the process was done manually. By having this system, it will be easier for them to make their booking.

Booking Photography Java Project

Existing System:

In the existing system process of booking photography sessions was done manually by phone calls or drop-by at their place. It is hard to track the availability of the photographer and to manage all the bookings made by customers.

Booking Photography Gallery Page

Proposed System:

In the proposed system all the data is maintained in the database which is safe and easy to retrieve. Users can book the photographer anytime and anywhere. Users can know the location of the photo shoot.

Modules:

User:

The user module can get register as a new user and login for booking. Users can book their favorite photographer. Users are able to view the status of the booking. Able to check the availability timetable of the photographer

Admin:

Admin can get a login. Admin can add or change the bookings. Admin can check and approve or cancel customer’s booking.

Software Requirements:

Language:           Java

Web technologies:           JEE (Servlets/JSP)

Front-end Design:           Html, CSS, JSP, Bootstrap

Database:           MYSQL

Scripting:           JavaScript

Conclusion:

Booking photography is a system that satisfied the requirement of the user by booking the photographer from their location. This system fulfilled the desire of the users to select the photo shoot at their dream place. Users can know the status of their booking in the system.                  

Posted on

Online Crime Investigation System Project in Java

Project Abstract: This Online Crime Investigation System software presents the part of an organization’s 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 the “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 the Online Crime Investigation System application folder to

F:\Tomcat5.5.9\webapps\

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

3) Create a User in Oracle as follows:

CREATE USER OCR IDENTIFIED BY OCR;

GRANT DBA TO OCR;

CONN OCR/OCR

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

And type the 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)
  • 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.