Minor Project 1 - Report

Download as pdf or txt
Download as pdf or txt
You are on page 1of 71

PROJECT APPROVAL SYSTEM

MINOR PROJECT – I REPORT

Submitted in partial fulfillment of the requirement for the Degree of


Bachelors of Engineering in Computer Science & Engineering.

Submitted To:

RAJIV GANDHI PRODYOGIKI


VISHWAVIDYALAYA, BHOPAL (M.P.)

Submitted By:
Subhankar Samui(0129CS171018)

Under The Guidance of:

Prof.Monika Raghuwanshi.
(Assistant Professor, Computer Science Department)

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING

BHABHA ENGINEERING RESEARCH INSTITUTE

Bhopal ; Madhya Pradesh.

SESSION: 2020 -2021


DEPARTMENT OF COMPUTER SCIENCE &
ENGINEERING

CERTIFICATE

This is to certify that Subhankar Samui Students of CSE VII Semester of


“BHABHA ENGINEERING RESEARCH INSTITUTE,Bhopal” has
completed the Minor Project – I titled “PROJECT MANAGEMENT
SYSTEM` ”, as per the syllabus and has submitted a satisfactory report on this
project as a partial fulfillment towards the award of degree of Bachelor of
Engineering in Computer Science and Engineering under Rajiv Gandhi
Proudyogiki Vishwavidyalaya, Bhopal.

Prof. Monika Raghuwanshi Prof. Manish Rai Dr. Tripti Arjariya


------------------------------------ ------------------------ ---------------------------
Asst. Professor (CSE) HOD (CSE) Asst. Professor (CSE)
BERI, Bhopal BERI, Bhopal BERI, Bhopal

II
DECLARATION

We the undersigned solemnly declare that the project report “PROJECT MANAGEMENT
SYSTEM” is based on my own work carried out during the course of our study under the
supervision of Miss.Monika Raghuwanshi, Asst. Professor, CSE.

We assert the statements made and conclusions drawn are the outcomes of my own work. I
further certify that
1. The work contained in the report is original and has been done by us under the general
supervision of our supervisor.
2. The work has not been submitted to any other Institution for any other degree / diploma
/ certificate in this university or any other University of India or abroad.
3. We have followed the guidelines provided by the university in writing the report.

Whenever we have used materials (data, theoretical analysis, and text) from other sources, we
have given due credit to them in the text of the report and giving their details in the references.

Subhankar Samui(0129CS171018)
------------------------------------------

III
ACKNOWLEDGEMENT

In this semester, we have completed our project on “PROJECT MANAGEMENT SYSTEM”.


During this time, all the group members collaboratively worked on the project and learnt about the
industry standards that how projects are being developed in IT Companies. We also understood
the importance of teamwork while creating a project and got to learn the new technologies on
which we are going to work in near future.

We gratefully acknowledge for the assistance, cooperation guidance and clarification provided by
“Prof.Monika Raghuwanshi” during the development of our project. We would also like to
thank our Head of Department Prof.Manish Rai and our asst. professor Dr.Tripti Arjariya
mam for giving us an opportunity to develop this project. Their continuous motivation and
guidance helped us overcome the different obstacles for completing the Project.

We perceive this as an opportunity and a big milestone in our career development. We will strive
to use gained skills and knowledge in our best possible way and we will work to improve them.

Subhankar Samui (0129CS171018) ----------------------------------------

IV
LIST OF FIGURES
S. Figure No. Name of Figure Page
No. No.
1 Figure. 3.1 SDLC Phase 6
2 Figure. 3.2 Advantage of Oracle 8
3 Figure. 3.3 Agile Process 9
4 Figure. 3.4 DFD Level 0 11
5 Figure. 3.5 DFD Level 1 12
6 Figure. 3.6 DFD Level 2 13
7 Figure. 3.7 ER Diagram for Project Approval System 14
8 Figure. 3.8 Use Case Diagram for Project Approval System 15
9 Figure. 5.1 Screenshot of Homepage 46
10 Figure. 5.2 Screenshot of Admin Dashboard 47
11 Figure. 5.3 Screenshot of Registered HOD List 47
12 Figure. 5.4 Screenshot of Faculty Registration 48
13 Figure. 5.5 Screenshot of Student Registration Page 48
14 Figure. 5.6 Screenshot of HOD Login Page 49
15 Figure. 5.7 Screenshot of HOD Homepage 49
16 Figure. 5.8 Screenshot of HOD view Project Status 50
17 Figure. 5.9 Screenshot of Faculty Login Page 50
18 Figure. 5.10 Screenshot of view Project Details Page 51
19 Figure. 5.11 Screenshot of Faculty view Project Status 51
20 Figure. 5.12 Screenshot of Student Login Page 52
21 Figure. 5.13 Screenshot of Feedback Page 52
22 Figure. 5.14 Screenshot of Project uploading Page 53
23 Figure. 5.15 Screenshot of page to show Uploaded Files 53
24 Figure. 5.16 Screenshot of Success Page 54

V
LIST OF TABLES
S. Table No. Name of Figure Page
No. No.
1 Table 3.1 Admin Login Table 16
2 Table 3.2 HOD Login Table 16
3 Table 3.3 Faculty Login Table 16
4 Table 3.4 Student Login Table 17
5 Table 3.5 Table to keep Project Approval Details by HOD 17
6 Table 3.6 Table to keep Project Details 17
7 Table 3.7 Table to keep Project Feedback Details by Faculty 18
8 Table 6.1 Software Requirements 55
9 Table 6.2 Hardware Requirements 55

VI
LIST OF ABBREVIATIONS

S. No. Abbreviation. Full Form


1 HTML Hypertext Mark Up Language
2 SDLC Software Development Life Cycle
3 CSS Cascading Style Sheets
4 HOD Head of The Department
5 SRS Software Requirement System
6 PPT Power Point Presentation
7 JSP Java Server Pages
8 ERD Entity Relationship Diagram
9 DFD Data Flow Diagram
10 XML Extensible Markup Language
11 JS Java Script
12 VS Visual Studio
13 RAM Random Access Memory
14 HTTP Hyper Text Transfer Protocol

VII
ABSTRACT

PROJECT APPROVAL SYSTEM” is to adopt the benefits of computer. The


computerization of the system wills fastens the working skill of employers. They will
able to do much more work than manual working system. The valuable data is easily
portable we can easily transfer it from one place to another by e-mails.

Project Management has developed in order to plan, co-ordinate and control the complex
and diverse activities of modern industrial and commercial projects. All projects share
one common characteristic - the projection of ideas and activities into new endeavours.

The purpose of project management is to foresee or predict as many dangers and


problems as possible; and to plan, organize and control activities so that the project is
completed as successfully as possible in spite of all the risks.

The ever-present element of risk and uncertainty means that events and tasks leading to
completion can never be foretold with absolute accuracy. For some complex or advanced
projects, even the possibility of successful completion might be of serious doubt.

Project management is intended to help you anticipate and understand potential issues and
problems and, armed with the necessary information and knowledge, prepare, organize,
plan, and coordinate activities so you can complete and successfully deliver the project.

Project management helps organizations approach projects in measurable and distinct


stages the better to meet deadlines, expectations, and budget and with the least risk and
number of issues.

Project management is a set of knowledge, practices, techniques, and tools aimed at


delivering project goals in a timely and predictable manner, making you better prepared if
ever problems crop up.

Project management has developed over the years, and involves various activities before
a project is completed. Objectives should be specific so they are measurable, and
although there may be one major project objective, there may be minor objectives
throughout the project.

VIII
TABLE OF CONTENTS

FIRST PAGE (Same as Cover Page)…...


CERTIFICATE .............................................. II
DECLARATION .......................................... III
ACKNOWLEDGEMENT .............................IV
LIST OF FIGURES ....................................... V
LIST OF TABLES .........................................VI
LIST OF ABBREVIATIONS ....................... VII
ABSTRACT................................................. VIII
INDEX (with Page No.).................................IX

CHAPTER TOPIC PAGE NO.


Chapter I INTRODUCTION 1-3
1.1 Overview………………………………………………... 1
1.2 Problem Statement……………………………………… 1
1.3 Objective of Project…………………………………….. 2
1.4 Applications or Scope…………………………………... 2
1.5 Organization of Report…………………………………. 2
Chapter II LITERATURE SURVEY…………………………….. 4-5
Chapter III METHODOLOGY……………………………………. 6-18
3.1 Background / Overview of Methodology………………. 6
3.2 Project Platforms used in Project ………………………. 7
3.3 Proposed Methodology ………………………………… 8
3.4 Project Modules………………………………………… 9
3.5 Diagrams (ER, Use Case DFD, etc.)…………………… 11
Chapter IV IMPLEMENTATION………………………………… 19-45
4.1 Main Functions with explanation………………………. 19
4.2 Coding with explanation……………………………….. 20
Chapter V RESULTS……………………………………………… 46-54
Chapter VI USER MANUAL……………………………………… 55-57
6.1 Software Requirements…………………………………. 55
6.2 Hardware Requirements………………………………... 55
6.3 Steps to RUN the Project……………………………….. 56

IX
Chapter VII CONCLUSION & FUTURE SCOPE……………….. 58-59
7.1 Conclusion……………………………………………… 58
7.2 Future Work……………………………………………. 59
Chapter VIII REFERENCES………………………………………... 60

X
Project Approval System

CHAPTER I
INTRODUCTION

OVERVIEW

In today’s life, Computer has developed a lot. It has made many things possible which
are supposed to be impossible in the past. The reason to develop the software “.
PROJECT APPROVAL SYSTEM” is to adopt the benefits of computer.

The computerization of the system wills fastens the working skill of employers. They
will able to do much more work than manual working system. The valuable data is
easily portable we can easily transfer it from one place to another by e-mails. It takes
only a few second instead of two and three days.

Thus, it is more advanced and safe technique than transferring data by post. As well as
high speed computerization will also enhances the accuracy of the work 80 times.

Everyone manages projects, whether as a certified project manager managing a


portfolio or as a team player managing work processes as needed. And in our world of
do more with less, finding methods and best practices to enhance your efficiency is
essential.

That’s why we created this project management guide to help you learn the basics,
discover useful strategies that you can implement today, get started on your next
project with a range of pre-built templates, and gain the resources needed to manage
all the work you do.

PROBLEM STATEMENT
Academic Project management is a major issue which is faced by many educational
institutes in India, the main reason for this is there is no automated system followed in
any institute. College management/staff gathers all the project reports and project sources
from students and store them physically in some locations probably libraries. To
overcome this practical problem and also to make the process easy we developed a
secured intranet application which is useful for each and every institute.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 1


Project Approval System

OBJECTIVE OF PROJECT

The application should allow the student to login and upload/enter all his details
regarding project such as project abstract, White papers, SRS, PPTs, Sources etc. All this
details must be maintained in database. HOD or the head of the projects can directly
search of any project. We must provide roles based authentication in this project for high
level security. User can view all the documents online.

APPLICATIONS OR SCOPE

The computerization of the system wills fastens the working skill of employers. They will
able to do much more work than manual working system. The valuable data is easily
portable we can easily transfer it from one place to another by e-mails. It takes only a few
second instead of two and three days. Thus, it is more advanced and safe technique than
transferring data by post. As well as high speed computerization will also enhances the
accuracy of the work 80 times.

This helps further to establish an error free environment. Working on computer also helps
to prevent your data from unauthorized access. It is more reliable in transferring data
far away from organization. It will also help to student of distant education.

Using the software, it is possible to search the data of a particular student in a few
second by only clicking on a button. But it may takes one hour or more to research it in
a resister, manually. The student may get information or submit their fee. Thus, the main
objective of developing this software is to create a safe, fast, error free working
environment which is more users friendly and beneficial for the organization.

ORGANIZATION OF SYNOPSIS

Organization of project synopsis is mainly the synopsis itself which is divided into six
chapters each explaining the process, resources and methods used in designing the
project. A short description of the individual chapter is as follows :-

CHAPTER I INTRODUCTION:

It mainly focuses on the overview of the project, the problem statement and the necessity
of the Project Approval System. It also focuses on the objective of the project with its
area of applications and scope and why it’s needed.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 2


Project Approval System

CHAPTER II LITERATURE SURVEY:

Surveying the existing solutions of our problems and its pros and cons. Keeping in
mind the need of the project and why it’s useful we have proposed a system which
fulfills the requirement of the stakeholders. Also we have mentioned the idea behind
developing this project.

CHAPTER III METHODOLOGY:

Methodology of this project is Agile process and SDLC and it needs to provide
processes to ensure the product quality. This chapter focuses on the methodology
used in the development of project and reasons to select the particular
methodology and the method of data collection, system analysis and the table
specification.

CHAPTER IV IMPLEMENTATION:

Implementation contains the explanation of the main functions of the project .


It also defines the coding used in developing the project.

CHAPTER V RESULTS:

Result shows all the different panel of the system. Here all the screenshots of the
system has been displayed with explanation.

CHAPTER VI USER MANUAL:

It mainly defines the requirements and analysis phase of the project. It contains the
requirements of the system which is hardware and software requirements. It also
defines the steps to run the project .How can we execute our project and get the
required task done. It also contains application/.exe of the project.

CHAPTER VII CONCLUSION AND FUTURE SCOPE:

Under this chapter which is described as conclusion describes the outcome of our
project .It also describes the future enhancements which can be done in our project .

CHAPTER VIII REFERENCES:


Under this chapter the reference link has been provided.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI . BHOPAL 3


Project Approval System

CHAPTER II
LITERATURE SURVEY

In today’s life, Computer has developed a lot. It has made many things possible
which are supposed to be impossible in the past. The reason to develop the
software.“PROJECT APPROVAL SYSTEM” is to adopt the benefits of
computer.The computerization of the system will fasten the working skill of student.
They will able to do much more work than manual working system. The valuable
data is easily portable we can easily transfer it from one place to another by e-mails.
It takes only a few second instead of two and three days.

Thus, it is more advanced and safe technique than transferring data by post. As well
as high speed computerization will also enhances the accuracy of the work 80
times. This helps further to establish an error free environment.Working on
computer also helps to prevent your data from unauthorized access. It is more
reliable in transferring data far away from organization. It will also help to student
of distant education.Using the software, it is possible to search the data of a
particular student in a few second by only clicking on a button. But it may take one
hour or more to research it in a resister, manually. Thus, the main objective of
developing this software is to create a safe, fast, error free working environment
which is more users friendly and beneficial for the organization.

PRESENT SITUATION:

• Lack of clear goals and success criteria.


• Lack of communication.
• Budgeting issues.
• Inadequate skills of team members.
• Lack of accountability.
• Scope creep.
• Inadequate risk management.
• Unrealistic deadlines.
• The limited engagement of stakeholders.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 4


Project Approval System

After understanding the need of this project we are developing a software for
maintaining the records on a single platform and ease the work of faculty and
student in the college. A Project Approval System helps college management and
the students to handle the projects easily. The project management software
allows easy management of projects and records of students in detail. The system
will provide ease of administration by performing all the work on a computer
system thereby maintaining the reliability and safety of the data maintained and
provide a fast and efficient interface for easy access and updation of data.

WHY PROJECT APPROVAL SYSTEM:


Academic Project management is a major issue which is faced by many educational
institutes, the main reason for this is there is no automated system followed in any
institute. College management/staff gathers all the project reports and project
sources from students and store them physically in some locations probably
libraries. To overcome this practical problem and also to make the process easy we
developed a secured intranet application which is useful for each. This software
system is designed to help in managing various projects for a company. It allows
easy management and tracking of various projects running in the organization and
the people assigned to these projects. This project can also be modified to suit
student projects management system, that includes various projects assigned to
students and the students working on each project. This software system allows
for easy project management and tracking activities in those projects. An
administrator has the overall control of this system that allows him to create and
remove projects as per the requirement. Allocate start and completion dates for
those projects, allocate people to work on those projects and that track the project
progress. It is an effective software system to help manage these activities in a
corporate or college.

BENEFITS OF PROJECT APPROVAL SYSTEM:

• Effortless project planning

• Balanced resource management

• Pipeline forecasting

• Improved team collaboration

• Effective internal & external communication

• Effective resource management

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 5


Project Approval System

CHAPTER III
METHODOLOGY

OVERVIEW OF METHODOLOGY
System Development Life Cycle
(SDLC):
It’s the most common process adopted to develop a project and not surprisingly, this
project is following this model too. To be precise, waterfall model is being applied.
Waterfall model is a sequential model process where the input of a phase actually
results from the previous phase.

Figure 3.1: SDLC Phases

There are five phases in this model and the first phase is the planning stage. The
planning stage determines the objectives of the project and whether the project should be
given the green light to proceed. This is where the proposal submission comes into
picture. After obtaining the approval, the next phase is analysis. Gathering and analysing
the system and user requirements is essential for entry to the design step. With the
user requirements gathering completed, there is a need to prepare the resources for the
project. Be it software or hardware components, careful consideration and selection is to
be taken care at this stage. The decision on the appropriate resources to be used is further
elaborated under the subsections below. The next step is to design the system and
database structure.Results from the analysis and preparation that were concluded from
the previous stage are put into action. With the user requirements in mind, the flow of
the system is planned and the user interface is designed to suit their easy navigation
needs. After completing the design, actual coding begins. Database is created and codes
are written.
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ;. BHOPAL 6
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ;. BHOPAL 6
Project Approval System

PROJECT PLATFORMS USED IN PROJECT

LANGUAGE SELECTION:
➢ JAVA (JSP) & JAVASCRIPT
There are many scripting languages available in the market. VBScript, Perl, ASP and
PHP are some of those commonly used. Yet for this project, JSP & JS is the language
that is utilized for the coding piece. Being a widely-used open source language, it is free
for everyone to use and is especially suited for web development. JavaScript is a dynamic
computer programming language. It is lightweight and most commonly used as a part of
the web pages, whose implementation allows a client-side script to interact with a user
and to make dynamic pages. It is an interpreted programming language with object-
oriented capabilities. Inconclusion, Java prides itself in its powerful features which
include strong memory management, high performance, backward compatibility, and top-
nod security just name a few. Java finds itself being used in a multitude of domains
including mobile application development, w eb development, and system programming.
But its highlight is its ability to make small modules or applets for applications.

➢ HTML & CSS

HTML is the most widely used language to write web pages are linked together.
Hypertext.as its name suggests, HTML is a Markup Language which means you use
HTML to simply "mark-up" a text document with tags that tell a Web browser how to
structure it to display.Cascading Style Sheets (CSS) is a stylesheet language used to
describe the presentation of a document written in HTML or XML. CSS describes how
elements should be rendered on screen, on paper, in speech, or on other media.

DATABASE SELECTION :
 ORACLE
There are a variety of databases that we can select from the market. The widely used
databases are Microsoft Access, Microsoft SQL, Oracle and MySQL. Microsoft Access
does not encourage concurrent usage and it may be inefficient, as the database needs to
be saved into one file. It is also unable to process high speed and large size database as
compared to ORACLE.
Oracle is a product from Oracle corporation, that provides a relational database
management system. Oracle’s RDBMS supports any kind of data models, and has
different product editions such as Standard Edition, Enterprise Edition, Express Edition,
and Personal Edition, among which the user gets to choose the database system
depending on their need. Oracle products are scalable and secure, with high
performance ability, compared to other databases available in the market.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 7


Project Approval System

Figure 3.2: Advantages of using Oracle

PROPOSED METHODOLOGY
Agile is one of the world’s most widely used and recognized software development
framework. Most of the organizations have adopted it in some form or the other but
there is still a long way to go in the maturity of their adoption programs. The sole aim of
this series of tutorials is to onboard technology and non-technology professionals into the
Agile World.
We will take you through the agile journey in a step by step manner until you
understand the philosophy behind using Agile, its advantages and how to practice it.
This series aims to equip and enable the readers to apply Agile and Scrum learning
into their work.

Once we examine that the project is feasible, we undertake project planning. The table
below describes how we planned our project.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 8


Project Approval System

Figure 3.3: Agile Process

PROJECT MODULES
The Project Approval System has been modularized into following modules.

 ADMIN LOGIN MODULE:

This module is for the administrators of the whole project from where admins can control
the whole server and the database. Administrator will get a very own login page to login
as administrator and from there they can directly use the database and see all the data
with all the students and faculty information. Admin can also control the access and select
the faculty for a particular project.

 LANDING NOTIFICATION PAGE:

The page contains is the landing page of the site where both the faculty and the students
will get their login option and notification released for anyone from college. This page
will also contain for the login link of admin login and the other modules link like about,
contact etc.

 USER’S LOGIN MODULE:

This module gives the facility to login for faculty and Students both in their respective
profiles they can access their own data according to their accessibility and permissions.
Here, everyone gets their very own personalized Dashboard to control their functionality
easily. Students can control the filling of their data and faculty can view that data of any
student under them.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 9


Project Approval System

 REPORT MODULE:

This module generates report to the higher authorities of the system.

 UPLOAD MODULE :

Using this module the students can upload their project.

 DOWNLOAD MODULE:

Using this module the various usersof the system can download the project for
reviewing it.

 STUDENT REGISTER MODULE:

Registration module will contain the registration form and the methodology for the
working of the registration of a user as a student, Registration of the Faculty and HOD
will be done by the Administrator only. This module will also check the various entries
entered by the student at the time of the registration that they are valid to their parameters
or not.

 HOD APPROVAL MODULE:

This module will only allow the HOD to view the data of the student and mark the
performance of the student .This module also under take the permission, weather to
approve the project of the student or not .The HOD can also review which project is
assigned to which student and their performance and can also contact with the faculty.

 FACULTY GUIDANCE MODULE:

This module will allow the faculty to assign projects to the various student. The faculty
can also view the data and mark the performance of the students. The faculty can also
check the various entries entered by the student and validate it.

 DATA EXPORT MODULE:

This module will allow the HOD and the faculty to take the backup of the database in a
excel format from database of their managing class all the data of the students can be
exported to get the printed format of the data for the purpose of formalities and so on.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 10


Project Approval System

DATA FLOW DIAGRAM

Figure 3.4: DFD LEVEL 0

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 11


Project Approval System

Figure 3.5: DFD LEVEL 1

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 12


Project Approval System

Figure 3.6: DFD LEVEL 2

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 13


Project Approval System

ENTITY RELATIONSHIP DIAGRAM

Figure 3.7: ER DIAGRAM for Project Approval System

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 14


Project Approval System

USE CASE DIAGRAM

Figure 3.8: Use Case Diagram for Project Approval System

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 15


Project Approval System

SYSTEM TABLE
Admin Section

NAME NULL? TYPE

USERNAME NOT NULL VARCHAR2(30)

PASSWORD NOT NULL VARCHAR2(50)

Table 3.1: Admin login Table

HOD Section

NAME NULL? TYPE

HOD_NAME NOT NULL VARCHAR2(30)

USER_NAME NOT NULL VARCHAR2(30)

PASSWORD NOT NULL VARCHAR2(30)

MOBILE_NO NOT NULL NUMBER(10)

DEPARTMENT NOT NULL VARCHAR2(30)

Table 3.2: HOD login Table

Faculty Section

NAME NULL? TYPE

FACULTY_NAME NOT NULL VARCHAR2(30)

USER_NAME NOT NULL VARCHAR2(30)

PASSWORD NOT NULL VARCHAR2(30)

MOBILE_NO NOT NULL NUMBER(10)

DEPARTMENT NOT NULL VARCHAR2(30)

Table 3.3: Faculty login Table

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 16


Project Approval System

Student Section

NAME NULL? TYPE

STUDENT_NAME NOT NULL VARCHAR2(30)

USER_NAME NOT NULL VARCHAR2(30)

PASSWORD NOT NULL VARCHAR2(30)

MOBILE_NO NOT NULL NUMBER(10)

DEPARTMENT NOT NULL VARCHAR2(30)

SEMESTER NOT NULL NUMBER(5)

YEAR NOT NULL NUMBER(5)

Table 3.4: Student login Table

Project Section

NAME NULL? TYPE

STUDENT_NAME NOT NULL VARCHAR2(30)

PROJECTTITLE NOT NULL VARCHAR2(30)

STATUS NOT NULL VARCHAR2(30)

DESCRIPTION NUMBER(255)

Table 3.5: Table to keep project approval details by HOD

NAME NULL? TYPE

ID NOT NULL VARCHAR2(30)

STUDENT_NAME NOT NULL VARCHAR2(50)

FILE_NAME NOT NULL VARCHAR2(50)

FILE_DATA NOT NULL BLOB

DESCRIPTION VARCHAR2(255)

Table 3.6: Table to keep project details

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 17


Project Approval System

NAME NULL? TYPE

STUDENTNAME NOT NULL VARCHAR2(30)

PROJECTTITLE NOT NULL VARCHAR2(50)

FEEDBACK NOT NULL VARCHAR2(255)

Table 3.7: Table to keep project FEEDBACK details by Faculty

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 18


Project Approval System

CHAPTER IV
IMPLEMENTATION

MAIN FUNCTIONS WITH EXPLANATION

 REGISTRATION
Registration function will contain the registration form for the working of the
registration of a user as a student, Registration of the Faculty and HOD will be done by
the Administrator only. This will also check the various entries entered by the student at
the time of the registration that they are valid to their parameters or not.

 LOGIN
This function gives the facility to login for Admin, HOD, faculty and Students in their
respective profiles they can access their own data according to their accessibility and
permissions. Here, everyone gets their very own personalized Dashboard to control their
functionality easily. Students can control the filling of their data and faculty can view
that data of any student under them.The hod can approve the project of the student and
also give the feedback .

 UPLOAD
This function will allow the students to upload their data .This module also under take the
information about their project .

 UPDATE
This function will allow the students to update their data .This module also under
take the information about their project .

 REVIEW
This function will allow the faculty and the HOD to review projects of the various
students. The faculty a n d t h e H O D can also view the data and mark the
performance of the students. The faculty a n d t h e H O D can also check the various
entries entered by the student and validate it. The HOD can approve the project.

 DELETE
This function will allow the students to delete their data .

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING ; BERI ; BHOPAL 19


Project Approval System

 DOWNLOAD
This function will allow the Faculty and the HOD to download the data
which is submitted by the student.
 CHANGE PASSWORD
This function gives the facility to change password for Admin, HOD,
faculty and Students.
 FEEDBACK
This function will allow the faculty and the HOD to give feedback to the
various students.

CODING WITH EXPLANATION

 ADMIN SECTION

ADMIN LOGIN
 adminLogin.dao
package com.Dao;
import com.model.Admin;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class AdminDao extends GenericDao {

public AdminDao()

{
getConnection();
}
public boolean validateUser(Admin admin) {
String sql = "select * from Admin where USERNAME = ? and
PASSWORD = ?";
try {

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 20


Project Approval System

System.out.println(con);
PreparedStatement ps = con.prepareStatement(sql);
int parameterIndex = 0;
ps.setString(++parameterIndex, admin.getUsername());
ps.setString(++parameterIndex, admin.getPassword());
ResultSet rs = ps.executeQuery();
if (rs != null)
{
if (rs.next())
{ System.out.println("Admin featched");
return true;
}
}
} catch (SQLException e)
{}
return false;
}
}

HOD REGISTRTION

 HodRegistration.jsp
<%@page contentType="text/html" pageEncoding="UTF-
8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>Hod Registration Page</title>
<link href="HodRegistrationStyle.css" rel="stylesheet"
type="text/css"/>
</head>
<body>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 21


Project Approval System

<h4><a href="AdminHomePage.jsp" style="text-


decoration: none;color: red">Click Here</a> to Back</h4>

<form action="HodRegister" method="POST">


<div id="subhankar">
<p><u>HOD Registration Section</u></p>

<h3>HOD Name: <input id="trisha1" type="text"


placeholder="Enter Your Full Name" name="hname"
required="" /></h3>

<h3>User Name: <input id="trisha2" type="text"


placeholder="Enter Your Email Id" name="uname"
required="" /></h3>

<h3>Password: <input id="trisha3" type="password" placeholder="Enter


Your Password"

<h3>Mobile Number: <input id="trisha4"


type="number" placeholder="Enter Your Valid Mobile No"
name="mbno" required="" /></h3>

<h3>Department: <input id="trisha5" type="text"


placeholder="Enter Your Department" name="dpt"
required="" /></h3>
<h5 style="color:white"> <input id="trisha8"
type="checkbox" checked="checked" name="remember" />
Remember me<input id="trisha9" type="submit"
value="Register"/></h5>

</div>
</form>
</body>
</html>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING ; BERI ; BHOPAL 22


Project Approval System

 FACULTY AND HOD REGISTRATION

<%@page contentType="text/html" pageEncoding="UTF-


8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>Faculty Registration Page</title>
<link href="FacultyRegistrationStyle.css" rel="stylesheet"
type="text/css"/>

</head>
<body>
<h4><a href="AdminHomePage.jsp" style="text-decoration:
none;color: red">Click Here</a> to Back</h4>
<form action="FacultyRegister" method="POST">

<div id="subhankar">
<p><u>Faculty/HOD Registration Section</u></p>
<h3>Faculty Name: <input id="trisha1" type="text"
placeholder="Enter Teacher Name" name="fname"
required="" /></h3>
<h3>User Name: <input id="trisha2" type="text"
placeholder="Enter Your Email Id" name="uname"
required="" /></h3>
<h3>Password: <input id="trisha3"
type="password" placeholder="Enter Your Password"
name="pwd" required="" /></h3>
<h3>Mobile Number: <input id="trisha4"
type="number" placeholder="Enter Your Valid Mobile No"
name="mbno" required="" /></h3>
<h3>Department: <input id="trisha5" type="text"
placeholder="Enter Your Department" name="dpt"
required="" /></h3>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 23


Project Approval System

<h5 style="color:white"> <input id="trisha8"


type="checkbox" checked="checked" name="remember" />
Remember me<input id="trisha9" type="submit"
value="Register"/></h5>
</div>
</form>
</body>
</html>

 STUDENT REGISTRATION

studentRegistration.dao
package com.Dao;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.model.Student;

public class StudentDao extends GenericDao {

public StudentDao()
{
getConnection();
}
public String insertStudent(Student student)
{String sql = "insert into register(STUDENT_NAME,
USER_NAME, PASSWORD, MOBILE_NO, DEPARTMENT,
SEMESTER,YEAR) values(?, ?, ?, ?, ?, ?, ?)";
String result = "";
PreparedStatement ps = null;
try {
System.out.println(con);
ps = con.prepareStatement(sql);

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ;.BHOPAL 24


Project Approval System

int parameterIndex = 0;
ps.setString(++parameterIndex, student.getStudent_name());
ps.setString(++parameterIndex, student.getEmail());
ps.setString(++parameterIndex, student.getPassword());
ps.setLong(++parameterIndex, student.getMobile_no());
ps.setString(++parameterIndex, student.getDepartment());
ps.setInt(++parameterIndex, student.getSemester());
ps.setInt(++parameterIndex, student.getYear());

int i = ps.executeUpdate();
if (i != 0)
{
result = "Record has been inserted";
}
else
{
result = "Failed to insert the data";
}
} catch (SQLException e)
{
result = "Failed to insert due to error";
} finally
{
if (ps != null)
{
try
{
ps.close();
} catch (SQLException e)
{
e.printStackTrace();
}
}
}

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 25


Project Approval System

System.out.println(result);
System.out.println("
-");
return result;
}

public boolean validateUser(Student student) {


String sql = "select * from register where USER_NAME = ?
and PASSWORD = ?";
try {
System.out.println(con);
PreparedStatement ps = con.prepareStatement(sql);
int parameterIndex = 0;
ps.setString(++parameterIndex, student.getEmail());
ps.setString(++parameterIndex, student.getPassword());
ResultSet rs = ps.executeQuery();
if (rs != null) {
if (rs.next()) {
System.out.println("Student featched");
return true;
}
}
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}
}

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 26


Project Approval System

VIEW REGISTERED HOD

 registeredHODList,jsp
<%@page
import="org.o7planning.tutorial.jdbc.OracleConnUtils" %>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-
8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>View Hod List</title>
<link href="RegisteredHodList.css" rel="stylesheet"
type="text/css"/>
</head>
<body>
<br><br><br>
<center>
<%!
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
%>
<table border="2">
<header id="trisha1">Here The Registered Hod
List</header><br/>
<tr>
<th>Hod Name</th><th>User
Name</th><th>Password</th><th>Mobile
No</th><th>Department</th>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 27


Project Approval System

</tr>
<%
con = OracleConnUtils.getOracleConnection();
String sql = "select * from HOD";
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
%>
<tr>

<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getLong(4)%></td>
<td><%=rs.getString(5)%></td>

</tr>
<%
}
%>

</table><br>
<h4 style="color: red;"><a
href="AdminHomePage.jsp">Back to Previous
Page</a></h4>
<h5 style="color: green;"><a
href="AdminHomePage.jsp" >Back to Home Page</a></h5>
</center>
</body>
</html>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 28


Project Approval System

VEIW REGISTERED STUDENTS

 registeredStudentList.jsp
<%@page
import="org.o7planning.tutorial.jdbc.OracleConnUtils" %>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-
8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>View Page</title>
<link href="RegisteredStudentsList.css" rel="stylesheet"
type="text/css"/>
</head>
<body>
<br><br><br>
<center>
<%!
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
%>
<table border="2">
<header id="trisha1">Here The Registered Student
List</header><br/>
<tr>
<th>Student Name</th><th>User
Name</th><th>Mobile
No</th><th>Department</th><th>Semester</th><th>Year</
th>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 29


Project Approval System

</tr>
<%
con = OracleConnUtils.getOracleConnection();
String sql = "select * from register";
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
%>
<tr>
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getLong(4)%></td>
<td><%=rs.getString(5)%></td>
<td><%=rs.getInt(6)%></td>
<td><%=rs.getInt(7)%></td>

</tr>
<%
}
%>
</table><br>
<h4 style="color: red;"><a
href="AdminHomePage.jsp">Back to Previous
Page</a></h4>

<h5 style="color: green;"><a


href="AdminHomePage.jsp" >Back to Home Page</a></h5>

</center>
</body>
</html>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 30


Project Approval System

 HOD MODULE

HOD LOGIN
 HODLogin.jsp
<%@page contentType="text/html" pageEncoding="UTF-
8"%>
<html>
<head>
<title>Login Page</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width,
initial-scale=1.0">
<link href="hodLoginStyle.css" rel="stylesheet"
type="text/css"/>
</head>
<body>
<div class="login-wrap">
<div class="login-html">
<input id="tab-1" type="radio" name="tab"
class="sign-in" checked><label for="tab-1"
class="tab">HOD LOGIN</label>
<div class="login-form">
<div class="sign-in-htm">
<form action="HodLogin" method="post">
<div class="group">
<label for="uname" class="label">Username</label>
<input id="uname" type="text" class="input"
name="name" required>
</div>
<div class="group">
<label for="pass" class="label">Password</label>
<input id="pass" type="password" class="input"
name="pwd" required>
</div>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 31


Project Approval System

<div class="group">
</br> </br> </br> </br> <input type="submit"
class="button" value="Sign In">
</div>
</form>
<form method="post" action="index.jsp">
<div class="group">
<input type="submit" class="button"
value="BACK TO HOME PAGE">
</div>
</form>
</div>
</div>
</div>
</body>
</html>

VIEW PROJECT DETAILS

 downloadFiles,jsp
<%@page
import="org.o7planning.tutorial.jdbc.OracleConnUtils" %>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-
8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>Downloading Page</title>
<link href="fileDownloadStyle.css" rel="stylesheet"
type="text/css"/>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 32


Project Approval System

</head>
<body>
<br><br><br>
<center>
<%!
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
%>
<table border="2">
<header id="Trisha1"> VIEW PROJECT
DETAILS</header><br/>
<tr>
<th>ID</th><th>STUDENT NAME</th><th>File
Name</th><th>Description</th><th>Download</th><th>H
OD FEEDBACK</th><th>FACULTY FEEDBACK</th>
</tr>
<%
con = OracleConnUtils.getOracleConnection();
String sql = "select * from projects";
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
%>
<tr>
<td><%=rs.getInt(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(5)%></td>
<td><a
href="DownloadAttachmentServlet?id=<%=rs.getInt(1)%>">
Click Here To Download</a></td>
<td><a href="approvalProcess2.jsp">Add FEEDBACK
</a></td>
<td><a href="#">Add FEEDBACK </a></td>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 33


Project Approval System

</tr>
<%
}
%>

</table><br>
<h4 style="color: red; font-size: 20px;"><a
href="HOME.jsp">LOGOUT</a></h4>
<h5 style="color: green; font-size: 20px;"><a
href="HodLoginProcess2.jsp" >BACK</a></h5>
</center>
</body>
</html>
}
VIEW PPROJECT STATUS

 viewFiles,jsp
<%@page import="bean.Provider" %>
<%@page import="bean.ConnectionProvider" %>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-
8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<link href="viewFilesStyle2.css" rel="stylesheet"
type="text/css"/>
<title>View Page</title>

</head>
<body>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 34


Project Approval System

<br><br><br>
<link href="viewFilesStyle2.css" rel="stylesheet"
type="text/css"/>
<center>
<%!
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
%>
<table border="1" cellpadding="5%" width="50%">
<header id="NUM1" style="font-size: 30px">VIEW
PROJECT STATUS</header><br/>
<tr align="center">
<th>STUDENT NAME</th><th>PROJECT
TITLE</th><th>APPROVAL</th><th>HOD
FEEDBACK</th>
</tr>
<%
con = ConnectionProvider.getCon();
String sql = "select * from approval";
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
%>
<tr align="center">
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
</tr>
<%
}
%>
</table><br>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 35


Project Approval System

<h4 style="color: red; font-size: 20px;"><a


href="HOME.jsp">LOGOUT</a></h4>

<h5 style="color: green; font-size: 20px;"><a


href="HodLoginProcess2.jsp" >BACK</a></h5>
</center>
</body>
</html>
}

 FACULTY SECTION
FACULTY LOGIN
 facultyLogin.jsp

<%@page contentType="text/html" pageEncoding="UTF-


8"%>
<html>
<head>
<title>Login Page</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width,
initial-scale=1.0">
<link href="facultyLoginStyle.css" rel="stylesheet"
type="text/css"/>
</head>
<body>
<div class="login-wrap">
<div class="login-html">
<input id="tab-1" type="radio" name="tab" class="sign-
in" checked><label for="tab-1" class="tab">FACULTY
LOGIN</label>
<div class="login-form">
<div class="sign-in-htm">
<form method="post"
action="FacultyLogin">

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 36


Project Approval System

<div class="group">
<label for="uname" class="label">Username</label>
<input id="uname" type="text" class="input" name="uname"
required>
</div>
<div class="group">
<label for="pass" class="label">Password</label>
<input id="pass" type="password" class="input"
name="pass" required>
</div>
<div class="group">
</br> </br> </br> </br> <input type="submit"
class="button" value="Sign In">
</div>
</form>
<form method="post" action="index.jsp">
<div class="group">
<input type="submit" class="button" value="BACK
TO HOME PAGE">
</div>
</form>
</div>
</div>
</div>
</body>
</html>
%@page contentType="text/html" pageEncoding="UTF-
8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<link href="approvalProcess.css" rel="stylesheet">
<title>approval Page</title>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 37


Project Approval System

</head>
<body style="background:
url(https://www.drumangle.com/sandbox/wp/21813/wp-
content/uploads/2014/01/Login-Screen-Background-Wood-
5.jpg); background-size: cover;">
<p>FEEDBACK PROCESS</p>
<form action="index.jsp" method="post">
<div align="center">
<input id="tab1" type="submit" class="button"
value="LOGOUT"/>
</div>
</form>
<div class="box" align="center" style="margin-
top:15%; padding:5px; color:black; font-size: 20px" >
<div class="login-form">
<form align="center" method="post"
action="approvalProcessF2.jsp">
<div>
<br> <label for="studentname">STUDENT NAME</label>
<br> <input id="tanya1" type="text" name="studentname"
required />
</div>
<div>
<br> <label for="projecttitle">PROJECT TITLE</label>
<br> <input id="tanya2" type="text" name="projecttitle"
required />
</div>
<div>
<br> <label for="ffeedback"> FACULTY
FEEDBACK</label>
<br> <input id="tanya3" type="text" name="ffeedback"
size="50" required />
</div>
<div>
<br> <input id="tanya4" type="submit" class="button"
value="SUBMIT" />

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 38


Project Approval System

</div>
</form>
</div>
</div>
</body>
</html>

 STUDENT SECTION

STUDENT LOGIN
 studentLogin.dao
package com.Dao;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.model.Student;
public class StudentDao extends GenericDao {
public StudentDao() {
getConnection();
}
public String insertStudent(Student student) {
String sql = "insert into register(STUDENT_NAME,
USER_NAME, PASSWORD, MOBILE_NO,
DEPARTMENT, SEMESTER,YEAR) values(?, ?, ?, ?, ?, ?,
?)";
String result = "";
PreparedStatement ps = null;
try {
System.out.println(con);
ps = con.prepareStatement(sql);
int parameterIndex = 0;

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 39


Project Approval System

ps.setString(++parameterIndex, student.getStudent_name());
ps.setString(++parameterIndex, student.getEmail());
ps.setString(++parameterIndex, student.getPassword());
ps.setLong(++parameterIndex, student.getMobile_no());
ps.setString(++parameterIndex, student.getDepartment());
ps.setInt(++parameterIndex, student.getSemester());
ps.setInt(++parameterIndex, student.getYear());
int i = ps.executeUpdate();
if (i != 0)
{ result = "Record has been inserted";}
else
{result = "Failed to insert the data";}
}
catch (SQLException e)
{result = "Failed to insert due to error";}
finally
{if (ps != null) {
try
{ps.close();}
catch (SQLException e)
{ e.printStackTrace(); }
}
}
System.out.println(result);
System.out.println(" -------------------------");
return result;
}
public boolean validateUser(Student student) {
String sql = "select * from register where USER_NAME = ?
and PASSWORD = ?";
try {
System.out.println(con);
PreparedStatement ps = con.prepareStatement(sql);
int parameterIndex = 0;

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING; BERI ; BHOPAL 40


Project Approval System

ps.setString(++parameterIndex, student.getEmail());
ps.setString(++parameterIndex, student.getPassword());
ResultSet rs = ps.executeQuery();
if (rs != null) {
if (rs.next()) {
System.out.println("Student featched");
return true;
}
}
}
catch (SQLException e) {
e.printStackTrace();
}
return false;
}
}

PROJECT UPLOADING

 uploadToDB.jsp

<html>
<head>
<title>Upload files</title>
<link href="uploadToDBstyle.css" rel="stylesheet"
type="text/css"/>
</head>
<body>
<div style="padding:5px; color:red;font-style:italic;">
${errorMessage}
</div>
<h2>Project Files Uploading</h2>
<form method="post"
action="${pageContext.request.contextPath}/uploadToDB"

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 41


Project Approval System

enctype="multipart/form-data">
<p><u>Select File to Upload</u></p>
<h3>Student Name: <input id="trisha3" type="text"
placeholder="Enter Your Full Name" name="stuname"
required/></h3>
<h3>Select Your File <input id="trisha4" type="file"
name="file" required/></h3>
<b>Description:</b>
<br/>
<input id="trisha1" type="text" name="description" size="50"
required />
<br />
<h5><input id="trisha2" type="submit" value="Upload" />
<a href="StudentHomePage.html">Back to home
page?</a></h5>
</form>
</body>
</html>

VIEW UPLOADED FILES

 viewFiles.jsp
<%@page
import="org.o7planning.tutorial.jdbc.OracleConnUtils" %>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-
8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<link href="RegisteredStudentsList.css" rel="stylesheet"
type="text/css"/>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 42


Project Approval System

<title>View Page</title>
</head>
<body>
<br><br><br>
<center>
<%!
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
%>
<table border="2">
<header id="Trisha1">Your File is Uploaded
Here</header><br/>
<tr>
<th>ID</th><th>Student Name</th><th>File
Name</th><th>Description</th>
</tr>
<%
con = OracleConnUtils.getOracleConnection();
String sql = "select * from projects";
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
%>
<tr>
<td><%=rs.getInt(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(5)%></td>
</tr>
<%
}
%>
</table><br>

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING ; BERI ; BHOPAL 43


Project Approval System

<h4 style="color: red;"><a href="uploadToDB.jsp">Back to


file uploading page</a></h4>
<h5 style="color: green;"><a href="index.jsp" >Back to Home
Page</a></h5>
</center>
</body>
</html>
}

VIEW REPLY

 viewHodReplay.jsp

<%@page
import="org.o7planning.tutorial.jdbc.OracleConnUtils" %>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-
8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>View HOD Reply Page</title>
<link href="viewHodReplyStyle.css" rel="stylesheet"
type="text/css"/>
</head>
<body>
<br><br><br>
<center>
<%!
Connection con = null;
PreparedStatement ps = null;

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 44


Project Approval System

ResultSet rs = null;
%>
<table border="2">
<header style="font-weight: bolder">Your HOD is
Replied Here</header><br/>
<tr>
<th>Student Name</th><th>Project
Title</th><th>Approval</th><th>Description</th>
</tr>
<%
con = OracleConnUtils.getOracleConnection();
String sql = "select * from Approval";
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
%>
<tr>
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
</tr>
<%
}
%>
</table><br>
<h4 style="color: red;"><a
href="uploadToDB.jsp">Back to file uploading
page</a></h4>
<h5 style="color: green;"><a
href="StudentHomePage.html" >Back to Home
Page</a></h5>
</center>
</body>
</html> }

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 45


Project Approval System

CHAPTER V
RESULTS

FIGURE 5.1 Screenshot of Homepage

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 46


Project Approval System

Figure 5.2 Screenshot of Admin Dashboard

FIGURE 5.3 Screenshot of Registered HOD List

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 47


Project Approval System

FIGURE 5.4 Screenshot of Faculty Registration

FIGURE 5.5 Screenshot of Student Registration Page

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 48


Project Approval System

FIGURE 5.6 Screenshot of HOD Login Page

FIGURE 5.7 Screenshot of HOD Home Page

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 49


Project Approval System

FIGURE 5.8 Screenshot of HOD View Project Status

FIGURE 5.9 Screenshot of Faculty Login Page

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 50


Project Approval System

FIGURE 5.10 Screenshot of View Project Details Page

FIGURE 5.11 Screenshot of Faculty View Project Status

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 51


Project Approval System

FIGURE 5.12 Screenshot of Student Login Page

FIGURE 5.13 Screenshot of Feedback Page

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 52


Project Approval System

FIGURE 5.14 Screenshot of Project Uploading Page

FIGURE 5.15 Screenshot of Page Which Shows Uploaded Files

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 53


Project Approval System

FIGURE 5.16 Screenshot of Success Page

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 54


Project Approval System

CHAPTER VI
USER MANUAL

SOFTWARE REQUIREMENTS:

Operating windows
system
Code Editor VSCode,
NetBeans
Database Oracle
Language
Java(JSP)
Software
Web Server Apache Software Foundation

Web Browser Google Chrome

Table:6.1 -Software Requirements

HARDWARE REQUIREMENTS:

RAM 4 GB

Processor Intel i3
th
(6 gen)
Hard Disk
1TB

Table:6.2 – Hardware Requirements

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 55


Project Approval System

STEPS TO RUN THE PROJECT

Step 1:
Open the Netbeans IDE and open your project.
Step 2 :
Start the apache tomcat server.
Step 3:
Open the web browser in your system, here we hav used google chrome.
Step 4:
We can either run the project directly by clicking the run button or by right clicking and
using run file option.

Here we are writing the url address of the project in the web browser i.e
localhost:2000/projectapprovalsystem/
Step 5:
After the project has been executed successfully go to the appropriate section as per your
role.
Step 6:
If you are admin of the system go to the admin login page and enter the required
credentials .After logging in as the admin u can add student, faculty and student as well as
see the list of registered student, faculty and student.
Step 7:
If you are HOD then go to the HOD login page and enter the required credentials.After
logging in as HOD you get your required dashboard where you can view project details
and approve students project.
Step 8:

If you are faculty then go to the faculty login page and enter the required credentials.
After logging in as faculty you get your required dashboard where you can view project
details and give feedbackto the students project.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 56


Project Approval System

Step 9:

If you are student then go to the student login page and enter the required
credentials.
If you haven’t registered yourself before then register your self by going to the
registration page and filling the registration form.
After logging in as student you get your required dashboard where you can upload project
and its details .You can also see the status of your project.
Step 10:
After the required task is performed successfully close the application and stop the tomcat
server .

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 57


Project Approval System

CHAPTER VII
CONCLUSION & FUTURE SCOPE

This project will enhance the students and the Faculty to serve more quickly and
efficiently. This software is developed in order to computerize the activities which
take more time, if done manually. Project Approval System will enable the student
and faculty to do effortless project planning. And if we want information about
project of any student, we can access it quickly or update it if needed.
Digitalization of this system further helps the college management in time to come
rather than keeping records manually, reduces manpower and saves lot of time
and effort of management faculties.

CONCLUSION

Simplicity is never simple. As we have seen in this project, the process of creating
a user friendly and straightforward platform that facilitates the Project Approval
System is filled with complexity.

From understanding student requirements to system design and finally system


prototype and finalization, every step requires in-depth understanding and
commitment towards achieving the objectives of the project.

The Project Approval System is fully integrated to the system and used on real
time, the system prototype demonstrates easy navigation and data are stored in a
systematic way. Overall, efficiency has improved and work processes simplified.
Although all the objectives have been met, the system still has room for
improvement. The system is robust and flexible enough for future upgrade using
advanced technology and devices.

To sum up, developing a computer based project management system for any
college was a matter of essence. It will be the medium for the college
management for the proper management of the project monitoring in an organized
way. It is now essence for the organization to monitor the projects on the system,
without crawling any departments.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ; BHOPAL 58


Project Approval System

FUTURE WORK
The further enhancements which can be made in project approval could be done as
suggested below:

• We can plan mailing module which will allow the student to send email to HOD
with attachments. View/ send/reply email options will be provided. It can be done
in the form of the message center.

• Registration process can be refined by adding email alerts whenever HOD


approves registration.

• Alerts or notification module can be added separately which will show


notification icon and which when clicked will open the related info for which
notification was received.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING, BERI ;. BHOPAL 59


Project Approval System

CHAPTER VI
REFERENCES

https://final-sem-projects.blogspot.com/2014/03/college-project-approval-system-
java.html

https://www.w3schools.com/css/default.asp

https://www.oracle.com/in/database/technologies/112010-win64soft.html

https://projectsgeek.com/2017/03/student-project-allocation-project.html

https://www.w3schools.com/html/default.asp

https://www.projectsmart.co.uk/purpose-of-project-management-
and-setting- objectives.php

https://www.w3schools.com/bootstrap/bootstrap_ver.asp

https://www.upgrad.com/blog/java-project-ideas-topics-for-beginners/

https://www.tutorialspoint.com/html/index.htm

https://www.w3schools.com/css/css_intro.asp

https://www.javatpoint.com/url-rewriting-in-session-tracking

https://www.javatpoint.com/steps-to-connect-to-the-database-in-java

https://www.javatpoint.com/jsp-setProperty-and-jsp-getProperty-action-tag

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING ; BERI ; BHOPAL 60

You might also like