Minor Project 1 - Report
Minor Project 1 - Report
Minor Project 1 - Report
Submitted To:
Submitted By:
Subhankar Samui(0129CS171018)
Prof.Monika Raghuwanshi.
(Assistant Professor, Computer Science Department)
CERTIFICATE
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
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.
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
VII
ABSTRACT
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 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 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
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.
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.
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.
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.
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:
CHAPTER V RESULTS:
Result shows all the different panel of the system. Here all the screenshots of the
system has been displayed with explanation.
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.
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 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:
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.
• Pipeline forecasting
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.
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
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 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.
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.
PROJECT MODULES
The Project Approval System has been modularized into following modules.
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.
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.
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.
REPORT MODULE:
UPLOAD MODULE :
DOWNLOAD MODULE:
Using this module the various usersof the system can download the project for
reviewing it.
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.
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.
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.
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.
SYSTEM TABLE
Admin Section
HOD Section
Faculty Section
Student Section
Project Section
DESCRIPTION NUMBER(255)
DESCRIPTION VARCHAR2(255)
CHAPTER IV
IMPLEMENTATION
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 .
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.
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 AdminDao()
{
getConnection();
}
public boolean validateUser(Admin admin) {
String sql = "select * from Admin where USERNAME = ? and
PASSWORD = ?";
try {
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>
</div>
</form>
</body>
</html>
</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>
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 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;
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;
}
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>
</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>
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>
</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>
</center>
</body>
</html>
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>
<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>
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"/>
</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>
</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>
<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>
FACULTY SECTION
FACULTY LOGIN
facultyLogin.jsp
<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>
</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" />
</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;
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;
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"
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>
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"/>
<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>
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;
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> }
CHAPTER V
RESULTS
CHAPTER VI
USER MANUAL
SOFTWARE REQUIREMENTS:
Operating windows
system
Code Editor VSCode,
NetBeans
Database Oracle
Language
Java(JSP)
Software
Web Server Apache Software Foundation
HARDWARE REQUIREMENTS:
RAM 4 GB
Processor Intel i3
th
(6 gen)
Hard Disk
1TB
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.
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 .
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.
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.
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.
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