Job portal in java code, Assignments of Java Programming

Online job portal website is for job seekers and employers.

Typology: Assignments

2020/2021

Uploaded on 01/06/2021

unknown user
unknown user 🇮🇳

1 document

1 / 40

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
ONLINE JOB PORTAL
INTRODUCTION
Architecturally, JSP may be viewed as a high-level abstraction of Java servlets. JSP
pages are loaded in the server and are operated from a structured special installed Java
server packet called a Java EE Web Application, often packaged as a .war or .ear file
archive.
JSP allows Java code and certain pre-defined actions to be interleaved with static web
markup content, with the resulting page being compiled and executed on the server to
deliver an HTML or XML document. The compiled pages and any dependent Java
libraries use Java bytecode rather than a native software format, and must therefore be
executed within a Java virtual machine (JVM) that integrates with the host operating
system to provide an abstract platform-neutral environment.
JSP syntax is a fluid mix of two basic content forms: scriptlet elements and markup.
Markup is typically standard HTML or XML, while scriptlet elements are delimited
blocks of Java code which may be intermixed with the markup. When the page is
requested the Java code is executed and its output is added, in situ, with the
surrounding markup to create the final page. JSP pages must be compiled to Java
bytecode classes before they can be executed, but such compilation is needed only
when a change to the source JSP file has occurred.
Java code is not required to be complete (self contained) within its scriptlet element
block, but can straddle markup content providing the page as a whole is syntactically
correct (for example, any Java if/for/while blocks opened in one scriptlet element
must be correctly closed in a later element for the page to successfully compile). This
system of split inline coding sections is called step over scripting because it can wrap
around the static markup by stepping over it. Markup which falls inside a split block
of code is subject to that code, so markup inside an if block will only appear in the
output when the if condition evaluates to true; likewise markup inside a loop construct
may appear multiple times in the output depending upon how many times the loop
body runs.
The JSP syntax adds additional XML-like tags, called JSP actions, to invoke built-in
functionality. Additionally, the technology allows for the creation of JSP tag libraries
that act as extensions to the standard HTML or XML tags. JVM operated tag libraries
provide a platform independent way of extending the capabilities of a web server.
Note that not all commercial Java servers are Java EE specification compliant.
MySQL is a relational database management system (RDBMS)[2] that runs as a server
providing multi-user access to a number of databases. The SQL phrase stands for
Structured Query Language.
The software components used in our project are as under:
1. Eclipse
2. MySQL database
37
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28

Partial preview of the text

Download Job portal in java code and more Assignments Java Programming in PDF only on Docsity!

INTRODUCTION

Architecturally, JSP may be viewed as a high-level abstraction of Java servlets. JSP

pages are loaded in the server and are operated from a structured special installed Java

server packet called a Java EE Web Application, often packaged as a .war or .ear file

archive.

JSP allows Java code and certain pre-defined actions to be interleaved with static web

markup content, with the resulting page being compiled and executed on the server to

deliver an HTML or XML document. The compiled pages and any dependent Java

libraries use Java bytecode rather than a native software format, and must therefore be

executed within a Java virtual machine (JVM) that integrates with the host operating

system to provide an abstract platform-neutral environment.

JSP syntax is a fluid mix of two basic content forms: scriptlet elements and markup.

Markup is typically standard HTML or XML, while scriptlet elements are delimited

blocks of Java code which may be intermixed with the markup. When the page is

requested the Java code is executed and its output is added, in situ, with the

surrounding markup to create the final page. JSP pages must be compiled to Java

bytecode classes before they can be executed, but such compilation is needed only

when a change to the source JSP file has occurred.

Java code is not required to be complete (self contained) within its scriptlet element

block, but can straddle markup content providing the page as a whole is syntactically

correct (for example, any Java if/for/while blocks opened in one scriptlet element

must be correctly closed in a later element for the page to successfully compile). This

system of split inline coding sections is called step over scripting because it can wrap

around the static markup by stepping over it. Markup which falls inside a split block

of code is subject to that code, so markup inside an if block will only appear in the

output when the if condition evaluates to true; likewise markup inside a loop construct

may appear multiple times in the output depending upon how many times the loop

body runs.

The JSP syntax adds additional XML-like tags, called JSP actions, to invoke built-in

functionality. Additionally, the technology allows for the creation of JSP tag libraries

that act as extensions to the standard HTML or XML tags. JVM operated tag libraries

provide a platform independent way of extending the capabilities of a web server.

Note that not all commercial Java servers are Java EE specification compliant.

MySQL is a relational database management system (RDBMS)[2]^ that runs as a server

providing multi-user access to a number of databases. The SQL phrase stands for

Structured Query Language.

The software components used in our project are as under:

1. Eclipse

2. MySQL database

OVERVIEW

The importace of placement system is increasing day by day. Thousands of applicants are

depending placement cell. But the applicants are facing so many problems. This project is an

attempt to minimize the problems of an applicant to find a correct job. If we can make it an

online computerized and a mobile alert process it will be so fast and convenient for the

applicants.Far from upsetting matters, however, new technologies have predominantly made

life better and considerably easier for most 0people, and so it must be concluded that they

should be welcomed.

Software does not require a dedicated computer and can be run on almost any PC running

Windows OS The package includes the MOB JOBS software and a normal cell phone and

data cable. It uses a normal SIM card from a GSM operator with a local mobile number. In

functionality it is similar to the four digit short codes but unlike short codes that is billed

according to the agreement between the content provider and the service provider and can

only be reached 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.

EXISTING SYSTEM

The existing system is a manual system of limitations like accuracy, expense, low

speed and efficiency and unformatted outputs. In the existing system, all data

processing is done manually. All the files and record books are replaced by the

software system. When there are a lot of issues such as retrieval and storage of the

information and keeping track of them becomes a tedious task. By implementing a

computerized system, the limitation in the present system will be reduced. Manpower

can be reduced to a great extent and efficiency and accuracy can be increased to

manifold. More over consumption of time can be reduced to far greater extend by the

implementation of the proposed system.

PROPOSED SYSTEM

In the proposed system we propose to computerize the above-mentioned activities. In the

existing system, all data processing is done manually. When there are a lot of issues such as

retrieval and storage of the information and keeping track of them becomes a tedious task.

By implementing a computerized system, the limitation in the present system will be

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.

SYSTEM SPECIFICATION

HARDWARE REQUIREMENTS Minimum Requirements Processors : Intel Pentium Pro or Processor running at 133 MHz Hard Disk : 1.2 GB Hard Disk RAM : Client Level – Minimum 128MB Recommended Requirements for peek performance Processors : Intel Pentium III running at 450 MHz RAM : Client Level – Minimum 512MB Display Type: SVGA Color Monitor Keyboard : Enhanced 104 Standard Mouse : PS/2 2 Button SOFTWARE REQUIREMENTS

Operating System : WINDOWS 2000/2003/

XP/WINDOWS 7/WINDOWS VISTA

TOOLS USED: Front end: ECLIPSE Back end: MYSQL ,TOMCAT SERVER

TABLE STRUCTURES

The structure of all tables included in the project is as under:-

1.INTERVIEW

| Field | Type | Null | Key | Default | Extra |

| can_uname | varchar(50) | YES | MUL | NULL | |

| com_name | varchar(50) | YES | MUL | NULL | |

| iv_date | date | YES | | NULL | |

| iv_time | varchar(20) | YES | | NULL | |

| iv_place | varchar(50) | YES | | NULL | |

2.EMPLOYER

| Field | Type | Null | Key | Default | Extra |

| emp_name | varchar(50) | NO | PRI | | |

| emp_pass | varchar(50) | YES | | NULL | |

| emp_web | varchar(50) | YES | | NULL | |

3.APPLICANT

| Field | Type | Null | Key | Default | Extra |

| fname | varchar(50) | NO | | NULL | |

| lname | varchar(50) | NO | | NULL | |

| gender | varchar(10) | NO | | NULL | |

| username | varchar(50) | NO | PRI | NULL | |

| password | varchar(50) | NO | | NULL | |

| email | varchar(50) | NO | | NULL | |

4.JOB

mysql> desc job;

| Field | Type | Null | Key | Default | Extra |

| c_name | varchar(50) | NO | PRI | | |

| c_web | varchar(50) | YES | | NULL | |

| vacancy | int(50) | YES | | NULL | |

| salary | int(50) | YES | | NULL | |

| job_desc | varchar(50) | YES | | NULL | |

| location | varchar(50) | YES | | NULL | |

| sel_post | varchar(50) | YES | | NULL | |

| iv_date | date | YES | | NULL | |

Advertising/PR

Arts/Entertainment/ Publishing

College

Education/Training

Engineering/Architecture

Entrepreneurial/Start-up

Entry Level

Government

Health Care

Hospitality/Travel

Human Resources

Insurance

Internet/New Media

Legal

Manufacturing/Operations

Marketing

Pharmaceutical/Biotech

Real Estate/Construction/Facilities

Retail

Sales

Tech Contract

Technology Telecommunications

Temp Jobs

GETJOBS.COM is a registered organization

PAGE: login_a.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>

Insert title here

//int flag=2; //String k1=request.getParameter("username"); String k2=request.getParameter("passwd"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection c=DriverManager.getConnection("jdbc:odbc:abc","root","root"); Statement s =c.createStatement(); String sql = "select * from applicant where username='"+k1+"'";// and password='"+k2+"'"; ResultSet rs=s.executeQuery(sql); rs.next(); String pass=rs.getString(5); if (k2.equals(pass)) { %>

<%} else { %> <%} } catch (Exception e) { %> <%} } %>

PAGE: app_home.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import = "java.sql.*"%>

CANDIDATE HOME PAGE WELCOME <%=session.getAttribute("t1") %> APPLICANT HOME PAGE

Search Jobs

Location:

Skills:

Functional Area:

<% } else { %> <% } out.println("success"); } catch (Exception e ){out.println(e); } } %>

PAGE: interview.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>

Insert title here

<% try { String c1=(String)session.getAttribute("t1"); String b1=(String)session.getAttribute("a1"); String b2=(String)session.getAttribute("a2"); String b3=(String)session.getAttribute("a3"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection c=DriverManager.getConnection("jdbc:odbc:abc","root","root"); Statement s =c.createStatement(); String sql ="select * from job where location='"+b1+"' and job_desc='"+b2+"' and sel_post='"+b3+"'"; ResultSet rs=s.executeQuery(sql);

rs.next(); %>

Username:<%=session.getAttribute("t1") %> Company:<%out.println(rs.getString(1)); %> Vacancies:< %out.println(rs.getString(3));%> Salary: < %out.println(rs.getString(4));%> Job Post: < %out.println(rs.getString(7));%> Location: < %out.println(rs.getString(6));%> Interview date: < %out.println(rs.getString(8));%> Interview Time: < %out.println(rs.getString(9));%> Interview Place: < %out.println(rs.getString(10));%>

<% Statement m =c.createStatement(); String sq1 ="select * from interview where can_uname='"+c1+"' and com_name='"+rs.getString(1)+"'"; ResultSet rs1=m.executeQuery(sq1); boolean a=rs1.next(); if (a== false ) { out.println("success1"); out.println(rs.getString(8)); out.println(rs.getString(9)); out.println(rs.getString(10)); Statement p =c.createStatement(); String sq ="insert into interview values('"+c1+"','"+rs.getString(1)+"','"+rs.getString(8)+"','"+rs.getString(9)+"','"+rs.getString(10)+"')"; p.execute(sq); out.println("success"); } else if (a== true ) { %> <% } String m1=request.getParameter("rs.getString(1)"); session.setAttribute("v1",m1); out.println("success"); } catch (Exception e ){out.println(e); }

PAGE: job_select.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%>

SELECT JOB

<% try { String b1=(String)session.getAttribute("a1"); String b2=(String)session.getAttribute("a2"); String b3=(String)session.getAttribute("a3"); //out.println(b1); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection c=DriverManager.getConnection("jdbc:odbc:abc","root","root"); Statement s =c.createStatement(); String sql ="select * from job where location='"+b1+"' and job_desc='"+b2+"' and sel_post='"+b3+"'"; ResultSet rs=s.executeQuery(sql); rs.next(); %>

Company:< %out.println(rs.getString(1));%>

Vacancies:< %out.println(rs.getString(3));%>

Salary: < %out.println(rs.getString(4));%> Job Post: < %out.println(rs.getString(7));%> Location: < %out.println(rs.getString(6));%>

<% } catch (Exception e ){out.println(e); }

PAGE: 1.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import = "java.sql.*"%>

Candidate Information Page :

APPLICANT LOGIN PAGE

  • Required fields

Login Information

  • Email address: