Online Job Portal
Online Job Portal
Online Job Portal
BY
ANSHU RANI
ANSHULI SHANDILYA
Submitted to
DR. NEENA GUPTA
(Assistant Professor)
1
CERTIFICATE
This is to certify that this project entitled “ONLINE JOB PORTAL” submitted in
the partial fulfillment, for the award of degree of Master Of Computer Application
of Gurukul Kangri Vishwavidyalaya, Dehradun by ANSHU RANI and
ANSHULI SHANDILYA was carried out by them under my supervision. The
matter embodied in this project work has not been submitted earlier for award of
any degree or diploma in any university/institutions to the best of our knowledge
and belief.
We wish all the best in their future carrier.
2
DECLARATION
We hereby declare that this submission is own work and that, to the best of
knowledge and belief, it contains no material previously published or written by
another person nor material which to a substantial extent has been accepted for the
award of any degree of the university or other institute of higher learning except
where due acknowledgement has been made in the text.
Date
ANSHU RANI
ANSHULI SHANDILYA
( MCA 5th Sem)
3
ACKNOWLEDGEMENT
Date:
4
ABSTRACT
Online Job Portal is to develop a system using which job applicants and recruiters
can communicate with each other. The purpose is to enable applicants to search for
jobs in a convenient manner and to enable employers to find suitable candidates.
Easy Job Portal is a job portal where Job Seeker can post their resumes, mange
profile, and search for a job and apply for a job. Employer posts their requirement,
searching for the candidates and matches the requirement .Easy Job is a job portal
like Monster.com, naukri.com where Job Seeker can post their resumes, mange
profile, and search for a job and apply for a job. Employer posts their requirement,
searching for the candidates and matches the requirement. Job Recruiters match
job seeker profile to employer requirement and send message to the job seekers.
System has powerful keyword based search facilities to search for specific
requirement. Easy Job Portal support multi user environment and can support very
large database, can store resume; It has facility to send system generated email to
candidates whenever new job posted which match the profile of the candidate.
Modules:
Design for the technology and engineering professionals, enabling them to perform
highly targeted job searches based on specific criteria, including location, type of
employment, skill set and keyword. This career site will also allow the job seekers
to post resume.
5
Search Job – Search the posted jobs based on specific criteria such as location, type
of employment, and skill set.
Statistic – Statistics for the jobseeker (in order to see how many times his profile
has been viewed).
Employer Module:-
Design system for the employers to post job requirements and allow searching
candidates from the resume database that matches the skill.
Statistic – Statistics for the employer (employer can see how many times his post
has been viewed, as well as more detailed report including the date, ip, username
of the user viewed the post)
6
Recruiter Module:-
Design resume database that allow recruiters to quickly and efficiently find
candidates with specialized skill sets that match desired criteria.
Match Requirement – View all the job seekers who match specific job
requirements.
Send Resume – Send the eligible candidates list to the employer.
Change Password – Change his/her password.
� Authenticate the user ID and Password of the job seeker, employer, and
recruiter.
MODULE DESCRIPTION-:
1). Applicant registration
7
3). Job search
5). Message
1) Applicant registration:
The applicant can register into the site by providing his details and he can set
his username and password for logging in later.
2) Company registration:
The authority of the company can register into the site by providing its
details and they can set its username and password for logging in. They can also
specify their requirements for each vacancy.
3) Job search:
Applicants can search for the job vacancies in the fields of their choice and
apply as interested.
4) Vacancy registration:
Authority of the company can provide all the necessary information
about the vacancies in each post along with eligibility criteria.
5) Message:
Software selects the apt ones from the registered applicants for each post
and informs them by a mobile alert. The message includes interview details.
Job Search using keywords, Specialization and location in the home page
Job Mail alert to the Job Seekers.
8
Hot Jobs in home page
9
Table of Contents
1 Introduction .............................................................................................. 11
2 System Specification .................................................................................. 13
2.1 Software Requirements Specifications ............................................ 13
2.2 Hardware Requirements Specifications .......................................... 13
3 Problem Definition ................................................................................... 14
3.1Existing system .................................................................................. 14
3.2Proposed system ................................................................................. 14
4 Data flow diagram .................................................................................... 18
5 E-R diagram .............................................................................................. 16
6 Source code................................................................................................ 21
7 Screenshots ................................................................................................ 84
8 Testing ....................................................................................................... 90
9 Conclusion ............................................................................................... 91
10 Reference ................................................................................................... 92
10
1.INTRODUCTION
11
from certain networks a long code (Local GSM number) can be accessed from
almost anywhere in the world for the price of an Normal SMS depending on
location and tariff of the Local GSM operator. Receiving the response is an
incoming SMS and is free.
12
2.SYSTEM SPECIFICATION
13
3.Problem Definition
3.1 Existing System:-
The present system requires applicants to search through print and visual media for
job opportunities. Applicants need to apply for jobs using conventional methods
and appear for interview on a specified date at a specified location. Employers
need to advertise the vacancies and sort all applicant details, conduct selection
procedures and complete the formalities. This approach is tedious and requires
much effort and resources.
Modules:
Design for the technology and engineering professionals, enabling them to perform
highly targeted job searches based on specific criteria, including location, type of
employment, skill set and keyword. This career site will also allow the job seekers
to post resume.
Employer Module:-
Design system for the employers to post job requirements and allow searching
candidates from the resume database that matches the skill.
Recruiter Module:-
14
Design resume database that allow recruiters to quickly and efficiently find
candidates with specialized skill sets that match desired criteria.
15
4.DATA FLOW DIAGRAM
16
Figure 3:DFD level 2
17
5.E-R DIAGRAM
18
TABLE STRUCTURES
1 .APPLIED TABLE
2.COMPANY DETAILS
19
3.STUDENTS DETAILS
4.VACANCY
20
6.SOURCE CODE
1.AppliedVacancy.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Applied Vacancy</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
<body>
<%
int sid=0;
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
String sname=session.getAttribute("logstudent").toString();
String getid="Select * From Student_Detail where name='"+sname+"'";
ResultSet rs=st.executeQuery(getid);
if(rs.next())
{
sid=rs.getInt("sid");
}
%>
<div class="container-fluid">
<%-- Main Header --%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<img src="images/1.jpg" height=450px width=100% class="img img-rounded">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%-- Menu part--%>
21
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<h3 style="color:#269abc;">Welcome To The Campus
<a href="index.jsp">Home Page</a>
<%
if(session.getAttribute("logstudent")!=null)
{
%>
<a href="StudentDashboard.jsp">Student </a>
<%
}
else
{
%>
<a href="StudentLogin.jsp">Student </a>
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
22
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<div class="row">
<div class="col-md-2">
<center><h2 style="color:#269abc"><b>Dashboard</b></h2>
<table class="table">
<tr>
<td><b><a href="ViewVacancy.jsp">View Vacancy</a></b></td>
</tr>
<tr>
<td><b><a href="AppliedVacancy.jsp">View Applied Vacancy</a></b></td>
</tr>
<tr>
<td><b><a href="StudentDetail.jsp">Student Detail</a></b></td>
</tr>
<tr>
<td><b><a href="logout.jsp">Logout</a></b></td>
</tr>
</table>
</center>
</div>
<div class="col-md-10">
<center><h1 style="color:#269abc"><b>You Applied For</b></h1></center><br>
<table class="table">
<tr>
<th>Company Name</th>
<th>Job Profile</th>
<th>Salary</th>
<th>Eligibility Criteria</th>
<th>Bond</th>
<th>Email Id</th>
<th>Contact No</th>
<th>Delete</th>
</tr>
<%
String sql="Select * From Applied,Vacancy,Company_Detail where Applied.sid='"+sid+"' AND
Vacancy.cid=Applied.cid AND Applied.cid=Company_detail.cid;";
23
rs=st.executeQuery(sql);
while(rs.next())
{
%>
<tr>
<td><%=rs.getString("Name")%></td>
<td><%=rs.getString("Job_Profile")%></td>
<td><%=rs.getString("Salary")%></td>
<td><%=rs.getString("Criteria")%></td>
<td><%=rs.getString("Bond")%></td>
<td><%=rs.getString("Email_Id")%></td>
<td><%=rs.getString("Contact_No")%></td>
<td><a href="DeleteApplied.jsp?cid=<%=rs.getInt("cid")%>">Delete</a></td>
</tr>
<%
}
%>
</table>
</div>
</div>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
<%
}
catch(Exception e)
{
24
%>
<%=e%>
<%
}
%>
</body>
</html>
</script><br><br><span style="padding-left:0px"><img src="1.gif" width="100" height="100" align = left span style="padding-
left:30px">
<br>
<table>
<tr>
<td>
<font color="blue" face="impact" size="2"> <a href="" name="linkSomepage" onclick="return
linksomepage_onclick()">Advertising/PR</a><br>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage" onclick="return
linksomepage_onclick()">Arts/Entertainment/<br>Publishing</a><br>
<tr>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">College</a><br>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">Education/Training</a><br>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">Engineering/Architecture</a><br>
<tr>
<td>
<font color="blue" face="impact" size="2"> <a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">Entrepreneurial/Start-up</a><br>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">Entry Level</a><br>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">Government</a><br>
<tr>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">Health Care</a><br>
25
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">Hospitality/Travel</a><br>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">Human Resources</a><br>
<tr>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">Insurance</a><br>
<td>
<font color="blue" face="impact" size="2"> <a href="" name="linkSomepage" onclick="return
linksomepage_onclick()">Internet/New Media</a><br>
<tr>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">Legal</a><br>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage"
onclick="return linksomepage_onclick()">Manufacturing/Operations</a><br>
<td>
<tr>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage" onclick="return
linksomepage_onclick()">Marketing</a><br>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage" onclick="return
linksomepage_onclick()">Pharmaceutical/Biotech</a><br>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage" onclick="return
linksomepage_onclick()">Real Estate/Construction/<br>Facilities</a><br>
<tr>
<td><font color="blue" face="impact" size="2"><a href="" name="linkSomepage" onclick="return
linksomepage_onclick()">Retail</a><br>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage" onclick="return
linksomepage_onclick()">Sales</a><br>
<td>
<font color="blue" face="impact" size="2"><a href="" name="linkSomepage" onclick="return
linksomepage_onclick()">Tech Contract</a><br>
26
<tr>
<td><font color="blue" face="impact" size="2"><a href="" name="linkSomepage" onclick="return
linksomepage_onclick()">Technology</a><br>
2.Apply.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Redirect</title>
</head>
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
int sid=0;
int cid=Integer.parseInt(request.getParameter("cid").toString());
String sname=session.getAttribute("logstudent").toString();
String getstid="Select * From Student_Detail where name='"+sname+"';";
ResultSet rs=st.executeQuery(getstid);
if(rs.next())
{
sid=rs.getInt("Sid");
}
String checkalready="Select * From Applied where cid="+cid+" And Sid="+sid+";";
27
rs=st.executeQuery(checkalready);
if(rs.next())
{
%>
<h1>You already applied for this Job.</h1>
<%
}
else
{
String sql="Insert into applied values("+cid+","+sid+");";
int x=st.executeUpdate(sql);
if(x>0)
{
response.sendRedirect("AppliedVacancy.jsp");
}
else{
%>
<h2>Error to connect database.</h2>
<%
}
}
}
catch(Exception e)
{}
%>
</body>
</html>
3.CompanyDashboard.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Company Login</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
<body>
<div class="container-fluid">
28
<%-- Main Header --%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<img src="images/1.jpg" height=450px width=100% class="img img-rounded">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%-- Menu part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<h3 style="color:#269abc;">Welcome To The Campus
<a href="index.jsp">Home Page</a>
<%
if(session.getAttribute("logstudent")!=null)
{
%>
<a href="StudentDashboard.jsp">Student </a>
<%
}
else
{
%>
<a href="StudentLogin.jsp">Student </a>
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
29
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h1 style="color:#269abc"><b>Company Dashboard</b></h1></center><br><br><br>
<table class="table">
<tr>
<td><h3><a href="ViewStudent.jsp"><input type="button" value="View Student Detail" class="btn btn-
success" style="height:150px; width:100%; font-size:20px;"></a></h3></td>
<td><h3><a href="postvacancy.jsp"><input type="button" value="Post New Vacancy" class="btn btn-
warning" style="height:150px; width:100%; font-size:20px;"></a></h3></td>
<td><h3><a href="CompanyDetail.jsp"><input type="button" value="View Company Detail" class="btn
btn-danger" style="height:150px; width:100%; font-size:20px;"></a></h3></td>
<td><h3><a href="logout.jsp"><input type="button" value="Log Out" class="btn btn-primary"
style="height:150px; width:100%; font-size:20px;"></a></h3></td>
</tr>
</table>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
30
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
</body>
</html>
4.CompanyDetails.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Company Detail</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
<body>
<%
String name=null;
int id=0;
if(session.getAttribute("loguser")!=null)
{
name=session.getAttribute("loguser").toString();
}
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
String sql="Select * From Company_Detail where name='"+name+"';";
31
ResultSet rs=st.executeQuery(sql);
%>
<div class="container-fluid">
32
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<div class="row">
<div class="col-md-2">
<center><h2 style="color:#269abc"><b>Dashboard</b></h2>
<table class="table">
<tr>
<td><b><a href="ViewStudent.jsp">View Student Detail</a></b></td>
</tr>
<tr>
<td><b><a href="postvacancy.jsp">Post Vacancy</a></b></td>
</tr>
<tr>
<td><b><a href="CompanyDetail.jsp">Company Detail</a></b></td>
33
</tr>
<tr>
<td><b><a href="logout.jsp">Logout</a></b></td>
</tr>
</table>
</center>
</div>
<div class="col-md-10">
<center><h1 style="color:#269abc"><b>Company Detail</b></h1></center><br>
<form method="post">
<%
if(rs.next())
{
%>
<table class="table">
<tr>
<td><b>Company Id:</b></td>
<td><input type="text" name="cid" value="<%=rs.getInt("cid")%>" disabled></td>
</tr>
<tr>
<td><b>Company Name:</b></td>
<td><input type="text" value="<%=rs.getString("name")%>" name="compnmae" disabled></td>
</tr>
<tr>
<td><b>Established Date:</b></td>
<td><input type="text" value="<%=rs.getString("Established_date")%>" name="edate"></td>
</tr>
<tr>
<td><b>Email Id:</b></td>
<td><input type="text" value="<%=rs.getString("email_id")%>" name="email"></td>
</tr>
<tr>
<td><b>Contact No:</b></td>
<td><input type="text" value="<%=rs.getString("Contact_No")%>" name="contno"></td>
</tr>
<tr>
<td><b>HR Name:</b></td>
<td><input type="text" value="<%=rs.getString("HR_Name")%>" name="hrname"></td>
</tr>
<tr>
34
<td><b>Password:</b></td>
<td><input type="text" value="<%=rs.getString("Password")%>" name="password"></td>
</tr>
<tr>
<td colspan="2"><center><input type="submit" value="Update" name="submit" class="btn btn-
primary">
</tr>
</table>
<%
id=rs.getInt("cid");
}
if(request.getParameter("submit")!=null)
{
String edate=request.getParameter("edate");
String eid=request.getParameter("email");
String cno=request.getParameter("contno");
String hrname=request.getParameter("hrname");
String pass=request.getParameter("password");
String upsql="Update company_detail Set Established_date='"+edate+"',Email_Id='"+eid+"',"
+ "contact_no='"+cno+"',hr_name='"+hrname+"',password='"+pass+"' where cid="+id+";";
int x=st.executeUpdate(upsql);
if(x==1)
{
response.sendRedirect("CompanyDetail.jsp");
%>
<h2>Update Successfully..</h2>
<%
}
else
{
%>
<h2>Unable to update Record..</h2>
<%
}
}
%>
</form>
</div>
</div>
</div>
35
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
<%
}
catch(Exception e)
{
%>
<%=e%>
<%
}
%>
</body>
</html>
5.CompanyLogin.jsp
<%@page import="java.sql.*"%>
<%@page import="java.sql.DriverManager"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Company Login</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
36
<script src="css/jquery.js"></script>
</head>
<body>
<%
String name=null;
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
%>
<div class="container-fluid">
37
else
{
%>
<a href="StudentLogin.jsp">Student </a>
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="color:#269abc"><b>Company Login Form</b></h3>
<form method="post">
<table class="table table-striped table-bordered">
<tr>
38
<td><b>Enter Company Name:</b></td>
<td><input type="text" name="compname" required></td>
</tr>
<tr>
<td><b>Enter Password:</b></td>
<td><input type="password" name="password" required></td>
</tr>
<tr>
<td colspan="2"><center><input type="submit" name="submit" value="Log in" class="btn btn-
primary">
<a href="CompanyRegistration.jsp"> <input type="button" value="Register" class="btn btn-
primary"></a>
</center></td>
</tr>
</table>
</form>
<%
if(request.getParameter("submit")!=null)
{
String cname=request.getParameter("compname");
String pass=request.getParameter("password");
String sql="Select * From company_detail where Email_Id='"+cname+"' AND Password='"+pass+"';";
ResultSet rs=st.executeQuery(sql);
int x=0;
while(rs.next())
{
x++;
name=rs.getString("Name");
}
if(x>0)
{
session.setAttribute("loguser",name);
response.sendRedirect("CompanyDashboard.jsp");
}
else
{
%>
<center><h2>Invalid User Name or Password</h2></center>
<%
39
}
%>
<%
}
%>
</center>
</div>
<div class="col-md-1"></div>
</div>0
</div>
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
<%
}
catch(Exception e)
{
%>
<%=e%>
<%
}
%>
</body>
</html>
6.CompanyRegistration.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
40
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Company Registration</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
<body>
<%
int id=0;
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
String getid="Select * From Company_Detail;";
ResultSet rs=st.executeQuery(getid);
while(rs.next())
{
id=rs.getInt("cid");
}
id++;
%>
<div class="container-fluid">
41
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<h3 style="color:#269abc;">Welcome To The Campus
<a href="index.jsp">Home Page</a>
<%
if(session.getAttribute("logstudent")!=null)
{
%>
<a href="StudentDashboard.jsp">Student </a>
<%
}
else
{
%>
<a href="StudentLogin.jsp">Student </a>
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
42
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="color:#269abc"><b>Company Registration Form</b></h3>
<form method="post">
<table class="table table-striped table-bordered">
<tr>
<td><b>Your Id:</b></td>
<td><input type="text" name="id" value="<%=id%>" disabled></td>
</tr>
<tr>
<td><b>Enter Company Name:</b></td>
<td><input type="text" name="compname" required></td>
</tr>
<tr>
<td><b>Enter Established Date:</b></td>
<td><input type="text" name="edate" required></td>
</tr>
<tr>
<td><b>Enter Email Id:</b></td>
<td><input type="text" name="emailid" required></td>
</tr>
<tr>
<td><b>Enter Contact No:</b></td>
<td><input type="text" name="contno" required></td>
</tr>
<tr>
<td><b>Enter HR Name:</b></td>
<td><input type="text" name="hrname" required></td>
</tr>
<tr>
<td><b>Enter Password:</b></td>
<td><input type="password" name="password" required></td>
</tr>
<tr>
43
<td colspan="2"><center><input type="submit" name="submit" value="Register" class="btn btn-
primary">
<a href="CompanyLogin.jsp"><input type="button" value="Login" class="btn btn-primary"></a>
</center></td>
</tr>
</table>
<%
if(request.getParameter("submit")!=null)
{
String cname=request.getParameter("compname");
String edate=request.getParameter("edate");
String eid=request.getParameter("emailid");
String cno=request.getParameter("contno");
String hrname=request.getParameter("hrname");
String pass=request.getParameter("password");
String instqu="Insert into
Company_Detail(name,established_date,email_id,contact_no,hr_name,password) values('"+cname+"',"
+ "'"+edate+"','"+eid+"','"+cno+"','"+hrname+"','"+pass+"');";
int x=st.executeUpdate(instqu);
if(x==1)
{
%>
<h2>Insert Record Successfully...</h2>
<%
response.sendRedirect("CompanyLogin.jsp");
}
else
{
%>
<h2>Unable to insert record</h2>
<%
}
}
%>
</form>
</center>
</div>
<div class="col-md-1"></div>
</div>
</div>
44
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
<%
}
catch(Exception e)
{
%>
<%=e%>
<%
}
%>
</body>
</html>
7.DeleteApplied.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Redirect</title>
</head>
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
45
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
int sid=0;
int cid=Integer.parseInt(request.getParameter("cid").toString());
String sname=session.getAttribute("logstudent").toString();
String getstid="Select * From Student_Detail where name='"+sname+"';";
ResultSet rs=st.executeQuery(getstid);
if(rs.next())
{
sid=rs.getInt("Sid");
}
String sql="Delete From Applied where sid="+sid+" And cid="+cid+";";
int x=st.executeUpdate(sql);
if(x>0)
{
response.sendRedirect("AppliedVacancy.jsp");
}
else{
%>
<h2>Error to connect database.</h2>
<%
}
}
catch(Exception e)
{}
%>
</body>
</html>
8.Index.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Home Page</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
46
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
String sql="Select Name,job_profile,salary,criteria,bond,Vacancy.email_id,Vacancy.contact_no From
Vacancy,Company_detail where Company_Detail.cid=Vacancy.cid;";
ResultSet rs=st.executeQuery(sql);
%>
<div class="container-fluid">
47
else
{
%>
<a href="StudentLogin.jsp">Student </a>
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<div class="row">
<div class="col-md-2">
<table class="table-border">
<tr>
48
<td><h4 style="color:#269abc; "><b>Update Status</b></h4></td>
</tr>
<tr>
<td><marquee direction="up" scrollamount="3"> New Job update Soon<br>
New Job update Soon<br>
New Job update Soon<br>
New Job update Soon<br>
New Job update Soon<br>
New Job update Soon<br>
New Job update Soon<br>
New Job update Soon<br>
New Job update Soon<br>
New Job update Soon<br>
New Job update Soon<br>
</marquee></td>
</tr>
</table>
</div>
<div class="col-md-10">
<center><h2 style="color:#269abc; width:50%;">Welcome To The Campus <br><hr
style="background:#269abc; height:2px;"> Get Your Dream Job Today. </h2></center>
<%
while(rs.next())
{
%>
<table class="table">
<tr>
<td><h4><b>Company Name: </b><%=rs.getString("Name")%><br><br>
<b>Job Profile: </b><%=rs.getString("Job_Profile")%><br><br>
<b>Salary: Rs</b><%=rs.getString("Salary")%><br><br>
<b>Eligibility Criteria: </b><%=rs.getString("Criteria")%><br><br>
<b>Bond: </b><%=rs.getString("bond")%><br><br>
<b>Email Id: </b><%=rs.getString("Email_Id")%><br><br>
<b>Contact No: </b><%=rs.getString("Contact_No")%></h4>
</td>
</tr>
<%
}
%>
49
</table>
</div>
</div>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
<%
}
catch(Exception e)
{
%>
<%=e%>
<%
}
%>
</body>
</html>
9.logout.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
50
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Logout</title>
</head>
<body>
<%
session.removeAttribute("loguser");
session.removeAttribute("logstudent");
response.sendRedirect("index.jsp");
%>
</body>
</html>
10.PostVacancy.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Post Vacancy</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
%>
<div class="container-fluid">
51
<div class="col-md-1"></div>
</div>
</div>
</div>
52
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<div class="row">
<div class="col-md-2">
<center><h2 style="color:#269abc"><b>Dashboard</b></h2>
<table class="table">
<tr>
<td><b><a href="ViewStudent.jsp">View Student Detail</a></b></td>
</tr>
<tr>
<td><b><a href="postvacancy.jsp">Post Vacancy</a></b></td>
</tr>
<tr>
<td><b><a href="CompanyDetail.jsp">Company Detail</a></b></td>
</tr>
<tr>
<td><b><a href="logout.jsp">Logout</a></b></td>
</tr>
</table>
</center>
</div>
<div class="col-md-10">
<center><h1 style="color:#269abc"><b>Post Vacancy</b></h1></center><br>
<form method="post">
<table class="table">
<tr>
53
<td><b>Enter Company Id:</b></td>
<td><input type="text" name="cid" required></td>
</tr>
<tr>
<td><b>Enter Job Profile:</b></td>
<td><input type="text" name="jp" required></td>
</tr>
<tr>
<td><b>Enter Salary:</b></td>
<td><input type="text" name="sal" required></td>
</tr>
<tr>
<td><b>Enter Eligibility Criteria:</b></td>
<td><textarea rows="4" cols="22" name="ec"></textarea></td>
</tr>
<tr>
<td><b>Enter Bond:</td>
<td><textarea rows="4" cols="22" name="bond"></textarea></td>
</tr>
<tr>
<td><b>Enter Email Id:</b></td>
<td><input type="text" name="email" required></td>
</tr>
<tr>
<td><b>Enter Contact No:</b></td>
<td><input type="text" name="contno" required></td>
</tr>
<tr>
<td colspan="2"><center><input type="submit" value="Post" name="submit" class="btn btn-
primary"> <input type="reset" value="Reset" name="submit" class="btn btn-primary"></center></td>
</tr>
</table>
<%
if(request.getParameter("submit")!=null)
{
String cid=request.getParameter("cid");
String jp=request.getParameter("jp");
String sal=request.getParameter("sal");
String ec=request.getParameter("ec");
String bond=request.getParameter("bond");
54
String eid=request.getParameter("email");
String cno=request.getParameter("contno");
String insrt="Insert into vacancy
values("+cid+",'"+jp+"','"+sal+"','"+ec+"','"+bond+"','"+eid+"','"+cno+"');";
int x=st.executeUpdate(insrt);
if(x==1)
{
%>
<h2>Vacancy is Post</h2>
<%
}
else
{
%>
<h2>Unable to connect Database..</h2>
<%
}
}
%>
</form>
</div>
</div>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
55
</div>
<%
}
catch(Exception e)
{
%>
<%=e%>
<%
}
%>
</body>
</html>
11.Registration.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Registration</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
<body>
<div class="container-fluid">
56
<%-- Menu part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<h3 style="color:#269abc;">Welcome To The Campus
<a href="index.jsp">Home Page</a>
<%
if(session.getAttribute("logstudent")!=null)
{
%>
<a href="StudentDashboard.jsp">Student </a>
<%
}
else
{
%>
<a href="StudentLogin.jsp">Student </a>
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
57
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h1 style="color:#269abc"><b>Registration</b></h1><br><br><br>
<a href="StudentRegistration.jsp"><input type="button" value="Student Registration" class="btn btn-
primary"></a>
<a href="CompanyRegistration.jsp"><input type="button" value="Company Registration" class="btn btn-
primary"></a><br><br><br>
</center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
</body>
</html>
12.StudentDashboard.jsp
58
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Student Dashboard</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
<body>
<div class="container-fluid">
<%-- Main Header --%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<img src="images/1.jpg" height=450px width=100% class="img img-rounded">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
59
{
%>
<a href="StudentLogin.jsp">Student </a>
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h1 style="color:#269abc"><b>Student Dashboard</b></h1></center><br><br><br>
<table class="table">
<tr>
<td><h3><a href="ViewVacancy.jsp"><input type="button" value="View Vacancy" class="btn btn-
success" style="height:150px; width:100%; font-size:20px;"></a></h3></td>
60
<td><h3><a href="AppliedVacancy.jsp"><input type="button" value="View Applied Vacancy"
class="btn btn-warning" style="height:150px; width:100%; font-size:20px;"></a></h3></td>
<td><h3><a href="StudentDetail.jsp"><input type="button" value="Studnet Detail" class="btn btn-
danger" style="height:150px; width:100%; font-size:20px;"></a></h3></td>
<td><h3><a href="logout.jsp"><input type="button" value="Log Out" class="btn btn-primary"
style="height:150px; width:100%; font-size:20px;"></a></h3></td>
</tr>
</table>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
</body>
</html>
13.StudentDetails.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Student Detail</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
61
</head>
<body>
<%
String name=null;
int id=0;
if(session.getAttribute("logstudent")!=null)
{
name=session.getAttribute("logstudent").toString();
}
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
String sql="Select * From Student_detail where name='"+name+"';";
ResultSet rs=st.executeQuery(sql);
%>
<div class="container-fluid">
62
if(session.getAttribute("logstudent")!=null)
{
%>
<a href="StudentDashboard.jsp">Student </a>
<%
}
else
{
%>
<a href="StudentLogin.jsp">Student </a>
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
63
<div class="col-md-1"></div>
<div class="col-md-10">
<div class="row">
<div class="col-md-2">
<center><h2 style="color:#269abc"><b>Dashboard</b></h2>
<table class="table">
<tr>
<td><b><a href="ViewVacancy.jsp">View Vacancy</a></b></td>
</tr>
<tr>
<td><b><a href="StudentDetail.jsp">Student Detail</a></b></td>
</tr>
<tr>
<td><b><a href="logout.jsp">Logout</a></b></td>
</tr>
</table>
</center>
</div>
<div class="col-md-10">
<center><h1 style="color:#269abc"><b>Student Detail</b></h1></center><br>
<form method="post">
<%
if(rs.next())
{
%>
<table class="table">
<tr>
<td><b>Student Id:</b></td>
<td><input type="text" name="sid" value="<%=rs.getInt("sid")%>" disabled></td>
</tr>
<tr>
<td><b>Student Name:</b></td>
<td><input type="text" value="<%=rs.getString("Name")%>" name="stunmae" disabled></td>
</tr>
<tr>
<td><b>Course:</b></td>
<td><input type="text" value="<%=rs.getString("Course")%>" name="course"></td>
</tr>
<tr>
<td><b>Collage Name:</b></td>
64
<td><input type="text" value="<%=rs.getString("Collage")%>" name="collname"></td>
</tr>
<tr>
<td><b>Age:</b></td>
<td><input type="text" value="<%=rs.getString("Age")%>" name="age"></td>
</tr>
<tr>
<td><b>Gender:</b></td>
<td><input type="text" value="<%=rs.getString("Gender")%>" name="gender"></td>
</tr>
<tr>
<td><b>Email Id:</b></td>
<td><input type="text" value="<%=rs.getString("Email_Id")%>" name="email"></td>
</tr>
<tr>
<td><b>Contact No:</b></td>
<td><input type="text" value="<%=rs.getString("Contact_No")%>" name="contno"></td>
</tr>
<tr>
<td><b>10<sup>th</sup> %:</b></td>
<td><input type="text" value="<%=rs.getString("10th_per")%>" name="ten"></td>
</tr>
<tr>
<td><b>12<sup>th</sup>%:</b></td>
<td><input type="text" value="<%=rs.getString("12th_per")%>" name="twel"></td>
</tr>
<tr>
<td><b>Collage %:</b></td>
<td><input type="text" value="<%=rs.getString("collage_per")%>" name="collper"></td>
</tr>
<tr>
<td><b>Password:</b></td>
<td><input type="text" value="<%=rs.getString("password")%>" name="password"></td>
</tr>
<tr>
<td colspan="2"><center><input type="submit" value="Update" name="submit" class="btn btn-
primary">
</tr>
</table>
<%
65
id=rs.getInt("sid");
}
if(request.getParameter("submit")!=null)
{
String clname=request.getParameter("collname");
String course=request.getParameter("course");
String age=request.getParameter("age");
String gender=request.getParameter("gender");
String eid=request.getParameter("email");
String cno=request.getParameter("contno");
String ten=request.getParameter("ten");
String twel=request.getParameter("twel");
String clper=request.getParameter("collper");
String pass=request.getParameter("password");
String upsql="Update Student_detail Set
course='"+course+"',collage='"+clname+"',age="+age+",gender='"+gender+"',email_id='"+eid+"',"
+
"contact_No='"+cno+"',10th_Per='"+ten+"',12th_per='"+twel+"',collage_Per='"+clper+"',password='"+pass+"';";
int x=st.executeUpdate(upsql);
if(x==1)
{
response.sendRedirect("StudentDetail.jsp");
%>
<center><h2>Update Successfully..</h2></center>
<%
}
else
{
%>
<center><h2>Unable to update Record..</h2></center>
<%
}
}
%>
</form>
</div>
</div>
</div>
<div class="col-md-1"></div>
</div>
66
</div>
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
<%
}
catch(Exception e)
{
%>
<%=e%>
<%
}
%>
</body>
</html>
14.StudentLogin.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Student Login</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
<body>
67
<%
String name=null;
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
%>
<div class="container-fluid">
68
<a href="StudentLogin.jsp">Student </a>
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="color:#269abc"><b>Student Login Form</b></h3>
<form method="post">
<table class="table table-striped table-bordered">
<tr>
<td><b>Enter Email Id:</b></td>
<td><input type="text" name="eid" required></td>
</tr>
69
<tr>
<td><b>Enter Password:</b></td>
<td><input type="password" name="password" required></td>
</tr>
<tr>
<td colspan="2"><center><input type="submit" name="submit" value="Log in" class="btn btn-
primary">
<a href="StudentRegistration.jsp"> <input type="button" value="Register" class="btn btn-
primary"></a>
</center></td>
</tr>
</table>
<%
if(request.getParameter("submit")!=null)
{
String eid=request.getParameter("eid");
String pass=request.getParameter("password");
String sql="Select * From Student_detail where Email_Id='"+eid+"' AND Password='"+pass+"';";
ResultSet rs=st.executeQuery(sql);
if(rs.next())
{
name=rs.getString("Name");
session.setAttribute("logstudent",name);
response.sendRedirect("StudentDashboard.jsp");
}
else{
%>
<h2>Error Your Email Id And Password is incorrect.</h2>
<%
}
}
%>
</form>
</center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
70
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
<%
}
catch(Exception e)
{
%>
<%=e%>
<%
}
%>
</body>
</html>
15.StudentRegistration.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Student Registration</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
<body>
<%
int id=0;
try{
71
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
String getid="Select * From Student_Detail;";
ResultSet rs=st.executeQuery(getid);
while(rs.next())
{
id=rs.getInt("sid");
}
id++;
%>
<div class="container-fluid">
72
}
else
{
%>
<a href="StudentLogin.jsp">Student </a>
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="color:#269abc"><b>Student Registration Form</b></h3>
<form method="Post">
<table class="table table-striped table-bordered">
73
<tr>
<td><b>Your Id:</b></td>
<td><input type="text" name="id" value="<%=id%>" disabled></td>
</tr>
<tr>
<td><b>Enter Your Full Name:</b></td>
<td><input type="text" name="sname" required></td>
</tr>
<tr>
<td><b>Enter Your Course Name:</b></td>
<td><input type="text" name="course" required></td>
</tr>
<tr>
<td><b>Enter Your Collage Name:</b></td>
<td><input type="text" name="collname" required></td>
</tr>
<tr>
<td><b>Enter Your Age:</b></td>
<td><input type="text" name="age" required></td>
</tr>
<tr>
<td><b>Enter Your Gender:</b></td>
<td><input type="text" name="gender" required></td>
</tr>
<tr>
<td><b>Enter Your Email Id:</b></td>
<td><input type="text" name="email" required></td>
</tr>
<tr>
<td><b>Enter Your Contact No:</b></td>
<td><input type="text" name="contno" required></td>
</tr>
<tr>
<td><b>Enter Your 10<sup>th</sup>%:</b></td>
<td><input type="text" name="ten" required></td>
</tr>
<tr>
<td><b>Enter Your 12 <sup>th</sup> %:</b></td>
<td><input type="text" name="twel" required></td>
</tr>
74
<tr>
<td><b>Enter Your Collage %:</b></td>
<td><input type="text" name="collper" required></td>
</tr>
<tr>
<td><b>Enter Your Password:</b></td>
<td><input type="text" name="password" required></td>
</tr>
<tr>
<td colspan="2"><center><input type="submit" name="submit" value="Register" class="btn btn-
primary">
<a href="StudentLogin.jsp"><input type="button" value="Login" class="btn btn-primary"></a>
</center></td>
</tr>
</table>
<%
if(request.getParameter("submit")!=null)
{
String sname=request.getParameter("sname");
String clname=request.getParameter("collname");
String course=request.getParameter("course");
String age=request.getParameter("age");
String gender=request.getParameter("gender");
String eid=request.getParameter("email");
String cno=request.getParameter("contno");
String ten=request.getParameter("ten");
String twel=request.getParameter("twel");
String clper=request.getParameter("collper");
String pass=request.getParameter("password");
String instqu="Insert into
Student_Detail(name,course,collage,age,gender,email_id,contact_no,10th_per,12th_per,collage_per,password)
values('"+sname+"',"
+
"'"+course+"','"+clname+"',"+age+",'"+gender+"','"+eid+"','"+cno+"','"+ten+"','"+twel+"','"+clper+"','"+pass+"');";
int x=st.executeUpdate(instqu);
if(x==1)
{
%>
<h2>Insert Record Successfully...</h2>
<%
response.sendRedirect("StudentLogin.jsp");
75
}
else
{
%>
<h2>Unable to insert record</h2>
<%
}
}
%>
</form>
</center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
<%
}
catch(Exception e)
{
%>
<%=e%>
<%
}
%>
</body>
76
</html>
16.Viewstudent.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>View Student Detail</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
%>
<div class="container-fluid">
77
<div class="col-md-10">
<h3 style="color:#269abc;">Welcome To The Campus
<a href="index.jsp">Home Page</a>
<%
if(session.getAttribute("logstudent")!=null)
{
%>
<a href="StudentDashboard.jsp">Student </a>
<%
}
else
{
%>
<a href="StudentLogin.jsp">Student </a>
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
78
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<div class="row">
<div class="col-md-2">
<center><h2 style="color:#269abc"><b>Dashboard</b></h2>
<table class="table">
<tr>
<td><b><a href="ViewStudent.jsp">View Student Detail</a></b></td>
</tr>
<tr>
<td><b><a href="postvacancy.jsp">Post Vacancy</a></b></td>
</tr>
<tr>
<td><b><a href="CompanyDetial.jsp">Company Detail</a></b></td>
</tr>
<tr>
<td><b><a href="logout.jsp">Logout</a></b></td>
</tr>
</table>
</center>
</div>
<div class="col-md-10">
<center><h1 style="color:#269abc"><b>Student Detail</b></h1></center><br>
<form method="post">
<table class="table">
<tr>
<td colspan="10"><center><b>Search By Category:</b> <input type="text"
name="cat"> <input type="submit" value="Search" name="submit" class="btn btn-primary"></center></td>
</tr>
<%
String sql="Select * From student_detail;";
if(request.getParameter("submit")!=null)
{
String cat=request.getParameter("cat");
sql="Select * From Student_detail where Course='"+cat+"';";
}
79
ResultSet rs=st.executeQuery(sql);
%>
<tr>
<th>Name</th>
<th>Course</th>
<th>Collage Name</th>
<th>Age</th>
<th>Gender</th>
<th>Email Id</th>
<th>Contact No</th>
<th>10<sup>th</sup> %</th>
<th>12<sup>th</sup> %</th>
<th>Graduation %</th>
</tr>
<%
while(rs.next())
{
%>
<tr>
<td><%=rs.getString("Name")%></td>
<td><%=rs.getString("Course")%></td>
<td><%=rs.getString("Collage")%></td>
<td><%=rs.getString("Age")%></td>
<td><%=rs.getString("Gender")%></td>
<td><%=rs.getString("Email_Id")%></td>
<td><%=rs.getString("Contact_No")%></td>
<td><%=rs.getString("10th_Per")%></td>
<td><%=rs.getString("12th_Per")%></td>
<td><%=rs.getString("Collage_Per")%></td>
</tr>
<%
}
%>
</table>
</form>
</div>
</div>
</div>
<div class="col-md-1"></div>
</div>
80
</div>
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
<%
}
catch(Exception e)
{
%>
<%=e%>
<%
}
%>
</body>
</html>
17.ViewVacancy.jsp
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>View Vacancy</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="css/jquery.js"></script>
</head>
<body>
81
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/onlinerecuritment","root","");
Statement st=conn.createStatement();
%>
<div class="container-fluid">
82
<%
}
%>
<%
if(session.getAttribute("loguser")!=null)
{
%>
<a href="CompanyDashboard.jsp">Company </a>
<%
}
else
{
%>
<a href="CompanyLogin.jsp">Company </a>
<%
}
%>
<a href="Registration.jsp">New Registration</a>
</h3>
<hr style="background:#269abc; height:2px;">
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Data Part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<div class="row">
<div class="col-md-2">
<center><h2 style="color:#269abc"><b>Dashboard</b></h2>
<table class="table">
<tr>
<td><b><a href="ViewVacancy.jsp">View Vacancy</a></b></td>
</tr>
<tr>
83
<td><b><a href="AppliedVacancy.jsp">View Applied Vacancy</a></b></td>
</tr>
<tr>
<td><b><a href="StudentDetail.jsp">Student Detail</a></b></td>
</tr>
<tr>
<td><b><a href="logout.jsp">Logout</a></b></td>
</tr>
</table>
</center>
</div>
<div class="col-md-10">
<center><h1 style="color:#269abc"><b>Vacancy</b></h1></center><br>
<table class="table">
<tr>
<th>Company Name</th>
<th>Job Profile</th>
<th>Salary</th>
<th>Eligibility Criteria</th>
<th>Bond</th>
<th>Email Id</th>
<th>Contact No</th>
<th>Apply</th>
</tr>
<%
String sql="Select
Vacancy.cid,Company_Detail.Name,job_Profile,Salary,Criteria,bond,Vacancy.Email_Id,Vacancy.Contact_No From
Vacancy,company_Detail where "
+ "company_detail.cid=vacancy.cid;";
ResultSet rs=st.executeQuery(sql);
while(rs.next())
{
int cid=rs.getInt("cid");
%>
<tr>
<td><%=rs.getString("Name")%></td>
<td><%=rs.getString("Job_Profile")%></td>
<td><%=rs.getString("Salary")%></td>
<td><%=rs.getString("Criteria")%></td>
<td><%=rs.getString("Bond")%></td>
84
<td><%=rs.getString("Email_Id")%></td>
<td><%=rs.getString("Contact_No")%></td>
<td><a href="apply.jsp?cid=<%=cid%>">Apply</a></td>
</tr>
<%
}
%>
</table>
</div>
</div>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
<%--Footer part--%>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-1"></div>
<div class="col-md-10">
<center><h3 style="background:lightblue;">@All Right Reserved...</h3></center>
</div>
<div class="col-md-1"></div>
</div>
</div>
</div>
</div>
<%
}
catch(Exception e)
{
%>
<%=e%>
<%
}
%>
</body>
</html>
85
86
7.SCREENSHOT
1.Home Page
2.Registration Page
87
3.Student Login Form
88
5. View vacancy
89
8.TESTING
The task of System Testing is done with many different straights. This System is
tested by following steps:
Unit Testing-
The unit test focuses on the internal processing Logic and data Structure with in
the boundaries of a component. In this testing each and every program is tested
individually using Record that program produced satisfactory output and validation
also.
Validation Testing-
Validation Testing provides final assurance that software meets all function
behavioral and performance requirements. Validation Testing is indicates
validation in System.
System Testing-
System Testing verifies that all elements mash properly and that over all system
function performance is achieved. System Testing indicates the fetch of errors in
the software Developed. To test computer software it is actually series different
test whose purpose is to full exercise the computer base system.
90
9.CONCLUSION
The Online job portal System is developed using java and sql fully meets the
objectives of the system for which it has been developed. The system is operated at
a high level of efficiency and all the job seekers and user associated with the
system understands its advantage. The system solves the problem. It was intended
to solve as requirement specification.
There have been numerous cases of computer glitches, errors in Content,
and security lapses reported in online job searching .So in the near future the so –
called software could be made more secure and reliable. While electronic glitches
are rare, they have been known to occur, for instance when computer crashes
voided the efforts of thousands of student. There are also cases in which the
correction software has corrupted database. So the software can be programmed
well so as to avoid corrupted information.
Online Job Portal is to develop a system using which job applicants and
recruiters can communicate with each other. The purpose is to enable applicants to
search for jobs in a convenient manner and to enable employers to find suitable
candidates.
Easy Job Portal is a job portal where Job Seeker can post their resumes, mange
profile, and search for a job and apply for a job. Employer posts their requirement,
searching for the candidates and matches the requirement .Easy Job is a job portal
like Monster.com, naukri.com where Job Seeker can post their resumes, mange
profile, and search for a job and apply for a job. Employer posts their requirement,
searching for the candidates and matches the requirement. Job Recruiters match
job seeker profile to employer requirement and send message to the job seekers.
91
10.Reference
1. http://www.roseindia.com
2. http://java.sun.com/products/jsp
3. Professional JSP, Wrox publications.
4. Matthew siple (1998) “The Complete guide to Java Database Programming” Tata McGraw-
Hill Publishing Company Limited(124-135).
5. Herbert schildt (2001) “The complete Java Reference” Tata McGraw-Hill publishing
Company Limited(907-915).
6. Gnu.inflibnet.ac.in>jspui
92