HUMAN RESOURCE MANAGEMENT SYSTEM PROJECT REPORT | HUMAN RESOURCE MANAGEMENT SYSTEM

Project Overview

For an organization to run successfully and efficiently it's very important that it have efficient workers and to use it's resources very well specially Human resources. So one of the important goals of an organization is to recruit right people for the right job.

So there should be a proper recruiting process management system so that all the activities and selection procedure can be carried out effectively without losing its transparency. An on-line recruitment system will be of great help in carrying out recruitment operations and with this very objective in mind this On-Line Recruitment Process has been made. In this web base recruitment system we will manage all such activities (like creating vacancies, Short listing applicants, scheduling interviews, selecting final applicants also processing applicant’s detail and their status) that will save time, manpower and the biggest advantage of being it web based.

This web based system will provide better prospective for the enhancement of organization regarding to quality and transparency.

The HR center is a powerful application designed to allow companies to streamline their human resource tasks and manager their employees more efficiently

· Employee and Company Information

· Employee Time, Attendance, and Leave Request

· HR Documentation Management

The HR Center includes a comprehensive employee information database, work information, beneficiary information, and more for each employee. It comes standard with employee self-service access allowing employees to update their personal information, request time off or input their daily timesheet entries. It also has role –based access level control that is functionally based on whether a user is an employee, a manager, or an HR administrators.

Objectives:

This project is aimed at developing an on-line (web-based) and central Recruitment Process System for a company. Some features of this system will be creating vacancies, storing Applicants data, Interview process initiation, Scheduling Interviews, Storing Interview results for the applicant and finally Hiring of the applicant. Reports may be required to be generated for the use of HR department.

Thus summary of my project’s objective is as follows:-

· Provide better understanding between applicants and the organization.

· Provide an user friendly environment so that applicant’s can apply for job’s easily and company can run their recruitment process smoothly

· To maintain and store applicant details, vacancies details and employee’s details that will help in overall processing.

· It stores interviews results and provide the status of the applicant in the recruitment process.

· Provide scheduling information to the interviewers as well as to applicant.

The proposed system provides detail general information about the employee along with Educational, Certification, Skill and Project details. It enhances the HR Management in adding, viewing and updating employees’ details and generates various reports regarding employee’s skill and experience. Suggestions and Grievances posted by the employees are upheld for taking care of the necessary steps in forwarding company’s obligation.

Advantages of proposed system:

Ø Very fast and accurate.

Ø No need of any extra manual effort.

Ø No fever of data loss.

Ø Just need a little knowledge to operate the system.

Ø Doesn’t require any extra hardware device.

Ø At last very easy to find the employees.

Project Category:

This project is made On-Line (i.e. Web Based)

Tools/Platform Used:

Front End Java Server Pages

· User friendly

· GUI

· Separation of work (designing & coding)

· Written once run anywhere Middle-Tier

· Java Beans

Back End My Sql5.0

· Security

· Performance

· Scalability

· Reliability

· Support RDMS concepts

UML Model:

· CLASS DIAGRAM

· OBJECT DIAGRAM

SEQUENCE DIAGRAM

· COLLABORATION DIAGRAM

· STATE CHART DIAGRAM

· ACTIVITY DIAGRAM

· COMPONENT DIAGRAM

Data Flow Diagram:

Employee

Applicant

Context Level DFD for On-Line Recruitment Process

Oval: INTERVIEWER SECTION
(4.0)

Level 1 Dfd For On-Line Recruitment Process

Entity Relationship Diagram:

Modules and Their Description:

Login :

In this module employee’s user id and password is checked and only employees with valid user id and password will get entry into member’s zone. This is a security feature to avoid entry of unauthorized users.

Member’s Section:

Through this module entered employee can see and update their profile, can also change their password. Here two links are provided for HR employees and interviewers through this link both HR employee or interviewer can go to only their respective zones. No HR employee can go to interviewer and vice versa.

HR Department :

Through this module an employee can create vacancies, update vacancies details including status(open/closed/suspended), create applicants, edit applicant detail(status- hired, rejected etc.),shortlist applicants for interviews, schedule interviews and inform interviewers and finally on the basis of interview results inform the selected candidate. In short this module deals with the whole recruitment process.

Interviewer Section:

Through this module an interviewer can checks interview’s schedule and can edit or change schedules and inform HR department. Also sends interviews results to HR department for further processing.

Registration Process:

Through this module new applicants can registered themselves. After giving their professional details and resume applicant will get a user id and password. Then to get entry into recruitment section they need to provide this id and password and only applicants with valid id and password will get entry into recruitment zone. This is also a security feature to avoid entry of unauthorized user.

Recruitment Section:

Through this module entered applicant view various job openings, eligibility criteria for job, opening and closing date and can apply for one or more jobs. If already applied for jobs then applicant can view their status in the recruitment process also applicant can update their profile and resume(CV) and can also changed their password

Data Structures:

app_registration: This table maintains details of applicant

Field Name	Data Type
app_no(PRIMARY KEY)	VARCHAR(8)
lg_name	VARCHAR(15)
lg_pass	VARCHAR(10)
rem_ques	VARCHAR(60)
rem_ans	VARCHAR(25)
app_name	VARCHAR(40)
ps_city	VARCHAR(25)
email	VARCHAR(50)
alt_email	VARCHAR(50)
high_qual	VARCHAR(30)
qual_field	VARCHAR(30)
prev_exp	VARCHAR(50)
key_skill	VARCHAR(50)
currentdate	VARCHAR(20)

emp_detail: This table maintain details of employees

Field name	Data type
emp_no(PRIMARY KEY)	VARCHAR(8)
emplg_name	VARCHAR(15)
emp_pwd	VARCHAR(15)
emp_name	VARCHAR(50)
emp_ques	VARCHAR(60)
emp_ans	VARCHAR(25)
emp_sex	VARCHAR(6)
emp_desig	VARCHAR(30)
emp_special	VARCHAR(30)
emp_dept	VARCHAR(50)
emp_dob	VARCHAR(25)
emp_sal	VARCHAR(8)
emp_dojoin	VARCHAR(20)
emp_add	VARCHAR(300)
emp_phone	VARCHAR(25)
emp_email	VARCHAR(45)
emp_aemail	VARCHAR(45)

vacancy : This table maintain detail of jobs for which vacancies are open

Field Name	Data Type
vac_id (PRIMARY KEY)	VARCHAR(8)
create_date	VARCHAR(20)
owner	VARCHAR(50)
status	VARCHAR(50)
vac_title	VARCHAR(28)
vac_no	VARCHAR(10)
vac_dept	VARCHAR(30)
closing_date	VARCHAR(20)
vac_detail	VARCHAR(200)

user_jobdt : This table stores and maintain status of applicant for particular job selection process

Field Name	Data Type
app_no (FOREIGN KEY)	VARCHAR(8)
vac_id (FOREIGN KEY)	VARCHAR(8)
status	VARCHAR(20)

intereviewer This table stores interviewer and interviews details

Field Name	Data Type
emp_no(FOREIGN KEY)	VARCHAR(8)
vac_id (FOREIGN KEY)	VARCHAR(8)
emp_special	VARCHAR(30)
emp_dept	VARCHAR(50)
status	VARCHAR(10)
interview_date	VARCHAR(25)
email	VARCHAR(45)
set_time	VARCHAR(15)

hr_applicant: This table maintain the detail of applicants created by HR

Field Name	Data Type
app_no (FOREIGN KEY)	VARCHAR(8)
app_name	VARCHAR(20)
create_date	VARCHAR(20)
status	VARCHAR(20)

Process Logic:

Recruitment Section Process

Registration Process:

· In this process new applicants will be registered first and will be allotted user id and password.

· In future applicant will be given entry to Recruitment Section through this user id and password.

Recruitment Section process:

· In this zone applicant profiles are updated applicants can view job openings and can apply for one or more jobs or vacancies. They can also know their current status in the ongoing selection process.

Members Section Process

Login process:

· After entering valid user id and password employee will be given entry to member’s zone.

Members Section process:

· In this zone employee’s details can be viewed and their password and details are updated if required. From this zone only employee of HR department or interviewers can go to their respective sections other employees have no further participation.

Hr Department Process

Vacancy process:

· In this process, new vacancies are created and existing vacancies details (like their current status, closing date, eligibility requirement etc.) are updated if required.

Applicant process:

· In this process applicants detail is updated and new applicant can be created by employee.

Search process :

· In this process, details of particular vacancies or applicant are searched by employee.

Attaching process:

· In this process, applicants are attached to the vacancies means applicants are short listed for particular vacancy and they will be sent to Interviews simultaneously their status will be updated will show ‘In process’ status.

Scheduling process:

· In this process interview will be scheduled for the selected applicants and interviewers are informed about the schedules.

Applicant /Vacancy process:

· In this process, those candidates are listed which are finally selected for that particular job on the basis of interview result. Selected candidates are informed about their selection through emails also applicant can view their status which will be updated as ‘ Hired ‘ .

Interview Section Process:

· In this process, interviewer can view all interviews scheduled to be taken , change the Interview details – Date/Time and on the basis of interview for a particular job can select or reject the candidate, so on the basis of interview’s result interviewer update applicant status as Selected/Rejected.

Outputs Of The Project (Reports) :-

Following reports will be produced in this project :-

· Selected applicant’s list for interviews

· Interviews result report

· Hired applicants Report

Requirement Specification:

The system specification is the final work produced by the system and requirements engineer. It serves as the foundation for hardware engineering, software engineering, database engineering and human engineering.

Once requirements have been gathered explore each requirements in relationship to others, examine requirements for consistency, omissions and ambiguity.

After requirements analysis the requirements of On-Line Recruitment Process are as follows: -

Software requirements:

· Windows 98 / XP operating system

· MS-SQL server

· JSP & Java

· TOMCAT Server

Hardware requirements:

Pentium machine with 466 Mhz processor speed
256 MB RAM
10.2 GB Hard Disk

Security Mechanism:

In the software security there are two levels of security. The 1^st level of security, which is provided by the FRONT END and 2^nd level of security provided by the database which is being used.

Front End Security:-

This security level is developed or designed by the s/w developer or designer. S/he provides her/his s/w the security for the system, by considering many factors regarding to the particular s/w.

In this software following are used to provide security.

Login Checking:

There are two login’s are provided in this software one for employees and one for applicants. In order to avail the services of software employees have to provide a valid id and password and only after entering correct id and password employee will get entry otherwise they will be blocked from accessing any services of this site. Similarly a login check is provided for user applying for job. In order to enter recruitment zone user have to enter id and password which they got after registration , in this way security have been provided for both employee section and applicant section. There is also provision to change the password in case password is known by other.

Back End Security:-

In this particular software our back end used is SQL server 2000. So all the inbuilt security aspects provided by the SQL server 2000 database is used as it is. It will provide the strong feature of security so that it will be difficult to change, modify any personal or university data. Information is vital to success, but when damaged or in the wrong hands, it can threaten success. SQL server 2000 provides extensive security features to safe guard your information from both unauthorized viewing and intentional or inadvertent damage. This security is provided by granting or revoking privileges on a person- by- person and privilege-by-privilege basis. There are six ways by which security regarding to the database can be provided. They are as follows-

(1) CREATE USER

(2) DELETE USER

(3) MODIFY USER

(4) GRANT PERMISSION TO USER

(5) COMMIT

(6) ROLLBACK

Future Scope of this Project:

In future this project can be treated as product according to specification and needs of any organization. Since recruitment plays key role in any organization; thus, success over a long period of time and reliance of organization over recruitment is going to be one of the most considered topic for any organization.

Therefore On-Line Recruiting Process will be of great help in carrying out recruitment process smoothly and effectively. At present days every organization is using web technology for their proper functioning, so this web based project is all in all important from market aspects.

Furthermore if this project will be uploaded, it can be used as recruitment site and any organization can register their self on the site to carry out their recruitment process making this site as central recruitment system.

Conclusion:

As evidence of the success of this mission, there are millions of items listed each day in thousands of different categories. There are items for almost any interest that one could imagine, from sheet music to automobiles to hand tools to real estate. And the variety doesn’t stop there. Need a computer? One may find it listed in the proper category, in any configuration from very old and obsolete to the latest greatest machine available. What about antiques? One can find an antique quilt that is up for highest bid, or maybe an old violin, whose beautiful tones have enchanted many though its years. Tickets. Maybe a ticket to the next concert of ones favorite artist or play production. One can even find that special bottle of wine, some aged, exotic cheese, and the perfect ‘mood’ music for that special occasion.

In this instance it may be true that on eBay, they have something for everybody, whatever their tastes may be.

Bibliography:

Ø Analysis and Design of Information System By- V. Rajaraman.

Ø Analysis and Design of Information System By- James A Senn.

Ø Structure Analysis and System Specification By- Tom De Marco.

Ø The Practical Guide to Structure Design By- Page Jone Meilir.

Ø Managing the Structure Technique By- Edward Yourdon.

Ø System Analysis, Designing and Development By- Perry Edwards.

1. INTRODUCTION

1.1 HUMAN RESOURCE MANAGEMENT SYSTEM

This web based system will provide better prospective for the enhancement of organization regarding to quality and transparency.

Objectives:

Thus summary of my project’s objective is as follows:-

· Provide better understanding between applicants and the organization.

· Provide an user friendly environment so that applicant’s can apply for job’s easily and company can run their recruitment process smoothly

· To maintain and store applicant details, vacancies details and employee’s details that will help in overall processing.

· It stores interviews results and provide the status of the applicant in the recruitment process.

· Provide scheduling information to the interviewers as well as to applicant.

Advantages of proposed system:

Ø Very fast and accurate.

Ø No need of any extra manual effort.

Ø No fever of data loss.

Ø Just need a little knowledge to operate the system.

Ø Doesn’t require any extra hardware device.

Ø At last very easy to find the employees.

1.2 PURPOSE OF THE STUDY:

The HR center is a powerful application designed to allow companies to streamline their human resource tasks and manager their employees more efficiently

Employee and Company Information

Employee Time, Attendence, and Leave Request

HR Documentation Management (i.e. insurance forms, W-2’s etc.)

2. OBJECTIVE OF THE STUDY:

Thus summary of my project’s objective is as follows:-

· Provide better understanding between applicants and the organization and

· Provide an user friendly environment so that applicant’s can apply for job’s easily and company can run their recruitment process smoothly

· To maintain and store applicant details, vacancies details and employee’s details that will help in overall processing.

· It stores interviews results and provide the status of the applicant in the recruitment process.

· Provide scheduling information to the interviewers as well as to applicant.

SCOPE OF THE STUDY:

Allow a for the creation of an application specification to the human resource that maintain the intranet automation of the HR software i.e., which contains the data related to the employee.

PROJECT OVERVIEW AND LIMITTIONS:

This project can be used to identify a employee in the organization. The project maintains the details of the entire employee. Each employee is given with different employee Id.

In this I can use the vb.net language. Back end is ms-access. Duration of this project is 3 months .i was discussed the total modules of HR department. Limits are there. In this project I was taken only HR department from organization.

3.SYSTEM ANALYSIS:-

3.1 EXISTING SYSTEM

The HR Administration falls short of controlling the employee’s activities in analyzing his/her strengths and weakness. The decision for appraisal of assigning next project to the employee or to train him/her to enhance the skills – where lies with proper projection. He is not provided with the detailed project information done or to be assigned based on Application / Verticals.

DRAWBACKS IN EXISTING SYSTEM:

Ø Need of extra manual effort.

Ø It used to take much time to find any employee

Ø Not very much accurate.

Ø Danger of losing the files in some cases.

3.2 PROPOSED SYSTEM

Decision in assigning proper skillful hands for the project is an important issue in HR Module. The HR Administrator should report with the personal holding the necessary skills required for the project assignment. The decision in making analysis about the employee’s skills is a prime important before booting in. The proposed system of HR Module is the right software to be incorporated into the Automation of HR Software for helping the organization needs with respect to skilful Human Resource.

3.2.1 ADVANTAGES OF PROPOSED SYSTEM:

Ø Very fast and accurate.

Ø No need of any extra manual effort.

Ø No fever of data loss.

Ø Just need a little knowledge to operate the system.

Ø Doesn’t require any extra hardware device.

Ø At last very easy to find the employees.

3.3 FEASIBILITY STUDY

Once the problem is clearly understood, the next step is to conduct feasibility study, which is high-level capsule version of the entered systems and design process. The objective is to determine whether or not the proposed system is feasible. The three tests of feasibility have been carried out.

Ø Technical Feasibility

Ø Economical Feasibility

Ø Operational Feasibility

TECHNICAL FEASIBILITY

In Technical Feasibility study, one has to test Whether the proposed system can be developed using existing technology or not. It is planned to implement the proposed system using java technology. It is evident that the necessary hardware and software are available for development and implementation of the proposed system. Hence, the solution is technically feasible.

ECONOMICAL FEASIBILITY

As part of this, the costs and benefits associated With the proposed system compared and the project is economically feasible only if tangible or intangible benefits outweigh costs. The system development costs will be significant. So the proposed system is economically feasible.

OPERATION FEASIBILITY

It is a standard that ensures interoperability

Without stifling competition and innovation among users, to the benefit of the public both in terms of cost and service quality. The proposed system is acceptable to users. So the proposed system is operationally feasible.

4. SYSTEM REQUIREMENTS

4.1 Software Specification

· Windows 98 / XP operating system

· MS-SQL server

· JSP & Java

· TOMCAT Server

4.2 Hardware Specification:

Pentium machine with 466 Mhz processor speed
256 MB RAM
10.2 GB Hard Disk

5. Software requirement Specification(SRS)

1) Introduction:

1.1. Purpose:

The purpose of this document is to present a detailed description of the Online HRM Solution. It will explain the purpose and features of the system, the interfaces of the system, what the system will do, the constraints under which it must operate and how the system will react to external stimuliate.

1.2. Scope:

1.3. Definitions and Abbreviations:

Following are the definitions for the jargoned words.

Term	Definition
My Sql	Structure query language for the database purposes. Used to define procedures to store and retrieve data.
User	A lay person who needs the system to do his task efficiently and effectively. An account holder or a bank’s website visitor.
Database	Collection of all the information monitored by this system.
Jsp	JSP java server page, A server side scripting language, is used to connect the html with the MY SQL databases.
Administrator	A person that will be responsible for the addition and deletion of the staff members from the general database of the system..
Software Requirements Specification	A document that completely describes all of the functions of a proposed system and the constraints under which it must operate. For example, this document.

2) General Descriptions:

2.1. Product Perspective:

Following is the context or origin of online banking system. Comparison b/w the Tradition system and the new system can also be cleared through the system models.

2.2. Functionalities:

This software will have following functionalities

Login :

Member’s Section:

HR Department :

Interviewer Section:

Through this module an interviewer can checks interview’s schedule and can edit or change schedules and inform HR department. Also sends interviews results to HR department for further processing.

Registration Process:

Recruitment Section:

2.3 Generals Constraints:

Some general constraints should be defined which will have a great part in the overall succession of the online banking project.

a) Hardware Requirements:

As this system is an online Web-based application so a client server will be the most suitable Organizational style for this system. Computer systems will be needed by each of the actor as well as that user must be connected to the internet.

So, concisely following hardware will be needed.

1) Computer systems

2) Internet availability

b) Safety and Security:

This Project must be safe and secure because customers will directly contact their account through he internet. Software will have to identify the valid customer according to his/her bank details and password. So it is a difficult task to prevent the system by major disasters by preventing the unauthorized access to the system.

2.4 Assumptions and Dependencies:

Following are the assumptions and dependencies which are related to this online banking project.

1) This project is a stand-alone project so it will not affect the system where it will be embedded.

2) This project is a web-based project while the staff was addict of using traditional methods of data storage and retrieval so they will be trained a bit to jump to it.

3) This system will not depend on any other module. It will be a web-based so every one will independently contact it.

4) It is will not affect the environment at all.

3) Specific Requirements:

How the online HRM Solution will interact with the environment, what will be the functional and non-functional requirement. These all the steps should be defined here for providing a powerful base to the design phase.

The design of the project will completely depend on the functional and non-functional requirements. So these should be defined clearly and accurately for the effectiveness.

3.1 Functional Requirements:

Following are the services which this system will provide. These are the facilities and functions required by the customer.

a) Login

b) Member’s Section

c) HR Department

d) Interviewer Section

e) Registration Process

f) Recruitment Section

3.1.3) Process Specification:

All the process are described as below.

Recruitment Section Process

Registration Process:

· In this process new applicants will be registered first and will be allotted user id and password.

· In future applicant will be given entry to Recruitment Section through this user id and password.

Recruitment Section process:

Members Section Process

Login process:

· After entering valid user id and password employee will be given entry to member’s zone.

Members Section process:

Hr Department Process

Vacancy process:

· In this process, new vacancies are created and existing vacancies details (like their current status, closing date, eligibility requirement etc.) are updated if required.

Applicant process:

· In this process applicants detail is updated and new applicant can be created by employee.

Search process :

· In this process, details of particular vacancies or applicant are searched by employee.

Attaching process:

Scheduling process:

· In this process interview will be scheduled for the selected applicants and interviewers are informed about the schedules.

Applicant /Vacancy process:

Interview Section Process:

Outputs Of The Project (Reports) :-

Following reports will be produced in this project :-

· Selected applicant’s list for interviews

· Interviews result report

· Hired applicants Report

3.3) Non-Functional Requirements:

Those requirements which are not the functionalities of a system but are the characteristics of a system are called the non-functionalities. Every software system has some non-functionalities. Just fulfilling the requirements of the user is not a good task, keeping the system accurate, easy to maintain, reliable and secure is also a basic part of software engineering. Online Banking System must have the following non-functional requirements so that I could be said as a complete system.

1) Performance constraints:

This system must be fit according to the performance wise. It should use less memory and will be easily accessible by the user. Memory management should be done wisely so that none of the memory part goes wasted.

2) Hardware limitations:

It should be designed in such a way that cheap hardware must be installed to access and use it effectively. It should be platform independent. There should be no hardware limitations. In should be designed to work with the low specification hardware so that it could easily work with the high specification hardware.

3) Maintainable:

Each of the modules should be designed in such a way that a new module can easily be integrated with it.

6. SOFTWARE ENGINEERING PARADIGM:

Software Engineering is an engineering approach according to which techniques and knowledge are systematically organized before they are applied to the development of software. We will define Software to not only include software programs but also to the associated documentation required to develop, operate and maintain the programs. By defining Software in a broader sense, we wish to emphasize the necessity of considering the generation of timely documentation as an integral part of the software development process. We can combine this with definition of engineering to produce the following definition.

The practical application of scientific knowledge in the design and construction of computer programs and the associated documentation required to develop, operate and maintain them.

To solve actual problems in an industry setting a software engineer or team of engineers must incorporate a development strategy that encompasses the process, methods and tools.

Like any other product,a software product completes a cycle from its inception to obsolescence/replacement/wearing out. The process of software development not only needs writing the program and maintain it, but also a detail study of the system to identify current requirements related to the software development as well as to anticipate the future requirements. It also needs to meet the objective of low cost, and good quality along with minimum development time.

To manage the project objective it is important that product development phase should be divided into phase so that projects progress and change in requirement can be controlled along with the quality of the product. Following are the general phases in the life cycle of a software product.

· Requirement analysis and specification for clear understanding of the problem.

· Software design for planning the solution of the problem

· Coding(implementation)for writing program as per the suggested solution.

· Testing for verifying and validation the objective of the product.

· Operation and maintenance for use and to ensure its availability to users.

A process model for software engineering is chosen based on the nature of the project and application, the methods and tools to be used, and the controls and deliverables that are required.

Among the various available Software Process Models (Waterfall model, Spiral model, Prototyping model, Fourth Generation Techniques etc) the best suited for this project is the Water Fall Model.

Water Fall Model Techniques

The life-cycle paradigm demands a systematic, sequential approach to software development that begins at the system level and progresses through analysis, design, coding, testing and maintenance. The life-cycle paradigm encompasses the following activities:

System Engineering and Analysis

Establishing requirements for all system elements and then allocating some subset of these requirements to software

Software Requirement Analysis

To understand the nature of the program to be built, the software engineer (analyst) must understand the information domain for the software, as well as the required function, performance, and interfacing. Requirements for both the system and the software are documented and reviewed with the customer.

The water fall model has some disadvantages, like

1. It works only for systems designed to automate an existing manual system. For absolutely new system determining the requirement is difficult as the user himself does not know them in advance what is being built or finalized at each stage

2. Freezing the requirements means freezing the hardware. A large project might take few years to complete, by the time the product is available the hardware become obsolete.

3. It assumes that requirements are frozen before the rest of the development can proceed. In some situation it might be desirable to develop a part of the system completely, and later enhance the system in phases. This is often done for the software products that are developed not necessarily for a client, but for general marketing in which case the requirements are likely to be determined largely by developer themselves.

7 SYSTEM DESGIN

7.1 Detail Design

7.1.1UML DIAGRAMS

UNIFIED MODELING LANGUAGE

UML is the international standard notation for object-oriented analysis and design. The Object Management Group defines it. The heart of object-oriented problem solving is the construction of a model. The model abstracts the essential details of the underlying problem from its usually complicated real world. Several modeling tools are wrapped under the heading of the UML™, which stands for Unified Modeling Language™.

AN OVERVIEW OF UML:

The UML is a language for

Visualizing
Specifying
Constructing
Documenting

These are the artifacts of a software-intensive system. The three major elements of UML are

The UML’s basic building blocks
The rules that dictate how those building blocks may be put together.
Some common mechanisms that apply throughout the UML.

BASIC BUILDING BLOCKS OF THE UML:

The vocabulary of UML encompasses three kinds of building blocks:

Ø Things

Ø Relationships

Ø Diagrams

Things are the abstractions that are first-class citizens in a model.

Relationships tie these things together.

Diagrams group the interesting collection of things.

THINGS IN THE UML:

They are the abstractions that are first-class citizens in a model. There are four kinds of things in the UML

Structural things
Behavioral things.
Grouping things.
Annotational things.

These things are the basic object oriented building blocks of the UML. They are used to write well-formed models.

STRUCTURAL THINGS:

Structural things are the nouns of the UML models. These are mostly static parts of the model, representing elements that are either conceptual or physical. In all, there are seven kinds of Structural things.

CLASS:

A class is a description of a set of objects that share the same attributes, operations, relationships, and semantics. A class implements one or more interfaces. Graphically a class is rendered as a rectangle, usually including its name, attributes and operations, as shown below.

INTERFACE:

An interface is a collection of operations that specify a service of a class or component. An interface describes the externally visible behavior of that element.

Graphically the interface is rendered as a circle together with its name.

COLLABORATION:

Collaboration defines an interaction and is a society of roles and other elements that work together to provide some cooperative behavior that’s bigger than the sum of all the elements. Graphically, collaboration is rendered as an ellipse with dashed lines, usually including only its name as shown below.

Chain

USE CASE:

Use case is a description of a set of sequence of actions that a system performs that yields an observable result of value to a particular thing in a model. Graphically, Use Case is rendered as an ellipse with dashed lines, usually including only its name as shown below.

ACTIVE CLASS:

An active class is a class whose objects own one or more processes or threads and therefore can initiate control activity. Graphically, an active class is rendered just like a class, but with heavy lines usually including its name, attributes and operations as shown below.

COMPONENT:

Component is a physical and replaceable part of a system that conforms to and provides the realization of a set of interfaces. Graphically, a component is rendered as a rectangle with tabs, usually including only its name, as shown below.

NODE:

A Node is a physical element that exists at run time and represents a computational resource, generally having at least some memory and often, processing capability. Graphically, a node is rendered as a cube, usually including only its name, as shown below.

BEHAVIORAL THINGS:

Behavioural Things are the dynamic parts of UML models. These are the verbs of a model, representing behaviour over time and space.

INTERACTION:

An interaction is a behavior that comprises a set of messages exchanged among a set of objects within a particular context to accomplish a specific purpose. Graphically, a message is rendered as a direct line, almost always including the name if its operation, as shown below.

Display

STATE MACHINE:

A state machine is a behavior that specifies the sequence of states an object are an interaction goes through during its lifetime on response to events, together with its responses to those events. Graphically, a state is rendered as a rounded rectangle usually including its name and its sub-states, if any, as shown below.

GROUPING THINGS:

Grouping things are the organizational parts of the UML models. These are the boxes into which a model can be decomposed.

PACKAGE:

A package is a general-purpose mechanism for organizing elements into groups.

ANNOTATIONAL THINGS:

Annotational things are the explanatory parts of the UML models.

Note:

A note is simply a symbol for rendering constraints and comments attached to an element or a collection of elements.

Graphically a note is rendered as a rectangle with dog-eared corner together, with a textual or graphical comment, as shown below.

RELATIONSHIPS IN THE UML:

There are four kinds of relationships in the UML:

Dependency
Association
Generalization
Realization

1.DEPENDENCY:

This is relationship between two classes whenever one class is completely dependent on the other class. Graphically the dashed line represents it with arrow pointing to the class that it is being depended on.

2. ASSOCIATION: It is a relationship between instances of the two classes. There is an association between two classes if an instance of one class must know about the other in order to perform its work. In a diagram, an association is a link connecting two classes. Graphically it is represented by line as shown.

3. GENERALIZATION:

An inheritance is a link indicating one class is a super class of the other. A generalization has a triangle pointing to the super class. Graphically it is represented by line with a triangle at end as shown.

4. REALIZATION:

DIAGRAMS IN UML:

Diagrams play a very important role in the UML. There are nine kind of modeling diagrams as follows:

· Use Case Diagram

· Class Diagram

· Object Diagram

· Sequence Diagram

· Collaboration Diagram

· State Chart Diagram

· Activity Diagram

· Component Diagram

· Deployment Diagram

CLASS DIAGRAM:

Class diagrams are the most common diagrams found in modeling object-oriented systems. A class diagram shows a set of classes, interfaces, and collaborations and their relationships. Graphically, a class diagram is a collection of vertices and arcs.

Contents:

Class Diagrams commonly contain the following things:

Classes

Interfaces

Collaborations

Dependency, generalization and association relationships

USE CASES DIAGRAM:

Use Case diagrams are one of the five diagrams in the UML for modeling the dynamic aspects of systems(activity diagrams, sequence diagrams, state chart diagrams and collaboration diagrams are the four other kinds of diagrams in the UML for modeling the dynamic aspects of systems). Use Case diagrams are central to modeling the behavior of the system, a sub-system, or a class. Each one shows a set of use cases and actors and relationships.

COMMON PROPERTIES:

A Use Case diagram is just a special kind of diagram and shares the same common properties, as do all other diagrams- a name and graphical contents that are a projection into the model. What distinguishes a use case diagram from all other kinds of diagrams is its particular content.

Contents

Use Case diagrams commonly contain:

Use Cases

Actors

Dependency, generalization, and association relationships

Like all other diagrams, use case diagrams may contain notes and constraints. Use Case diagrams may also contain packages, which are used to group elements of your model into larger chunks. Occasionally, you will want to place instances of use cases in your diagrams, as well, especially when you want to visualize a specific executing system.

INTERACTION DIAGRAMS

An Interaction diagram shows an interaction, consisting of a set of objects and their relationships, including the messages that may be dispatched among them. Interaction diagrams are used for modeling the dynamic aspects of the system.

A sequence diagram is an interaction diagram that emphasizes the time ordering of the messages. Graphically, a sequence diagram is a table that shows objects arranged along the X-axis and messages, ordered in increasing time, along the Y-axis and messages, ordered in increasing time, along the Y-axis.

Contents

Interaction diagrams commonly contain:

Objects

Links

Messages

Like all other diagrams, interaction diagrams may contain notes and constraints.

SEQUENCE DIAGRAMS:

Typically you place the object that initiates the interaction at the left, and increasingly more sub-routine objects to the right. Next, you place the messages that these objects send and receive along the Y-axis , in order of increasing time from top to the bottom. This gives the reader a clear visual cue to the flow of control over time.

Sequence diagrams have two interesting features:

There is the object lifeline. An object lifeline is the vertical dashed line that represents the existence of an object over a period of time. Most objects that appear in the interaction diagrams will be in existence for the duration of the interaction, so these objects are all aligned at the top of the diagram, with their lifelines drawn from the top of the diagram to the bottom.

There is a focus of the control. The focus of control is tall, thin rectangle that shows the period of time during which an object is performing an action, either directly or through the subordinate procedure. The top of the rectangle is aligns with the action; the bottom is aligned with its completion.

Contents

Sequence diagrams commonly contains

Objects

Object Life Line

Focus of Control

ACTIVITY DIAGRAM

An Activity Diagram is essentially a flow chart showing flow of control from activity to activity. They are used to model the dynamic aspects of as system. They can also be used to model the flow of an object as it moves from state to state at different points in the flow of control.

An activity is an ongoing non-atomic execution with in a

State machine. Activities ultimately result in some action, which is made up of executable atomic computations that result in a change of state of distinguishes a use case diagram from all other kinds of diagrams is its particular content.

Contents

Activity diagrams commonly contain:

Fork

Start & End Symbol

STATE CHART DIAGRAMS

A state chart diagram shows a state machine. State chart diagrams are used to model the dynamic aspects of the system. For the most part this involves modeling the behavior of the reactive objects. A reactive object is one whose behavior is best characterized by its response to events dispatched from outside its context. A reactive object has a clear lifeline whose current behavior is affected by its past.

A state chart diagram show a state machine emphasizing the flow of control from state to state. A state machine is a behavior that specifies the sequence of states an object goes through during its lifetime in response to events together with its

Response to those events. A state is a condition in the life of the object during which it satisfies some conditions, performs some activity or wait for some events. An event is a specification of a significant occurrence that has a location in time and space.

Graphically a state chart diagram is a collection of vertices and arcs.

Contents:

State chart diagram commonly contain:

Simple states and Composite states.

Transitions, including events and actions.

CLASS DIAGRAM

OBJECT DIAGRAM

SEQUENCE DIAGRAM

COLLABORATION DIAGRAM

STATE CHART DIAGRAM

ACTIVITY DIAGRAM

COMPONENT DIAGRAM

CLASS DIAGRAM

7.2 DATA BASE DESIGN

7.2.1 DATA FLOW DIAGRAMS

DATA FLOW DIAGRAMS:

A graphical tool used to describe and analyze the moment of data through a system manual or automated including the process, stores of data, and delays in the system. Data Flow Diagrams are the central tool and the basis from which other components are developed. The transformation of data from input to output, through processes, may be described logically and independently of the physical components associated with the system. The DFD is also know as a data flow graph or a bubble chart.

Employee

Applicant

Context Level DFD for On-Line Recruitment Process

Oval: INTERVIEWER SECTION
(4.0)

LEVEL 1 DFD FOR ON-LINE RECRUITMENT PROCESS

7.2.2 ER Diagram

7.2.3DATABASE TABLES

app_registration: This table maintains details of applicant

Field Name	Data Type
app_no(PRIMARY KEY)	VARCHAR(8)
lg_name	VARCHAR(15)
lg_pass	VARCHAR(10)
rem_ques	VARCHAR(60)
rem_ans	VARCHAR(25)
app_name	VARCHAR(40)
ps_city	VARCHAR(25)
email	VARCHAR(50)
alt_email	VARCHAR(50)
high_qual	VARCHAR(30)
qual_field	VARCHAR(30)
prev_exp	VARCHAR(50)
key_skill	VARCHAR(50)
currentdate	VARCHAR(20)

emp_detail: This table maintain details of employees

Field name	Data type
emp_no(PRIMARY KEY)	VARCHAR(8)
emplg_name	VARCHAR(15)
emp_pwd	VARCHAR(15)
emp_name	VARCHAR(50)
emp_ques	VARCHAR(60)
emp_ans	VARCHAR(25)
emp_sex	VARCHAR(6)
emp_desig	VARCHAR(30)
emp_special	VARCHAR(30)
emp_dept	VARCHAR(50)
emp_dob	VARCHAR(25)
emp_sal	VARCHAR(8)
emp_dojoin	VARCHAR(20)
emp_add	VARCHAR(300)
emp_phone	VARCHAR(25)
emp_email	VARCHAR(45)
emp_aemail	VARCHAR(45)

vacancy : This table maintain detail of jobs for which vacancies are open

Field Name	Data Type
vac_id (PRIMARY KEY)	VARCHAR(8)
create_date	VARCHAR(20)
owner	VARCHAR(50)
status	VARCHAR(50)
vac_title	VARCHAR(28)
vac_no	VARCHAR(10)
vac_dept	VARCHAR(30)
closing_date	VARCHAR(20)
vac_detail	VARCHAR(200)

user_jobdt : This table stores and maintain status of applicant for particular job selection process

Field Name	Data Type
app_no (FOREIGN KEY)	VARCHAR(8)
vac_id (FOREIGN KEY)	VARCHAR(8)
status	VARCHAR(20)

intereviewer This table stores interviewer and interviews details

Field Name	Data Type
emp_no(FOREIGN KEY)	VARCHAR(8)
vac_id (FOREIGN KEY)	VARCHAR(8)
emp_special	VARCHAR(30)
emp_dept	VARCHAR(50)
status	VARCHAR(10)
interview_date	VARCHAR(25)
email	VARCHAR(45)
set_time	VARCHAR(15)

hr_applicant: This table maintain the detail of applicants created by HR

Field Name	Data Type
app_no (FOREIGN KEY)	VARCHAR(8)
app_name	VARCHAR(20)
create_date	VARCHAR(20)
status	VARCHAR(20)

7.2.4 Screen Design Login.jsp

8. Coding

Login.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

function validate()

{

if(document.form1.txtuid.value == "")

{

alert("Plz Enter User Id !!!!!!!!!!!!");

return;

}

if(document.form1.txtuname.value == "")

{

alert("Plz Enter User Name !!!!!!!!!!!!");

return;

}

if(document.form1.txtpassword.value == "")

{

alert("Plz Enter Password !!!!!!!!!!!!");

return;

}

document.form1.action="select_login.jsp";

document.form1.submit();

}

</script>

<tr>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td><div align="right">Password</div></td>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

</th>

</tr>

<tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Select_Login.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

try

{

int uid=Integer.parseInt(request.getParameter("txtuid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="select * from login_hrm where User_Id=? and User_Name=? and Password=?";

PreparedStatement ps=con.prepareStatement(query);

String User_Name=request.getParameter("txtuname");

String Password=request.getParameter("txtpassword");

ps.setInt(1,uid);

ps.setString(2,User_Name);

ps.setString(3,Password);

ResultSet rs =ps.executeQuery();

if(rs.next())

{

out.println("Sucessfully login");

session.setAttribute("user",User_Name);

response.sendRedirect("index.jsp");

}

else

{

out.println("<h1>Invalid User Name and Password </h1>");

}

catch(Exception e)

{

out.println(e.getMessage());

}

<a href="login.jsp"><strong>Login again!!!!!</strong></a>

</body>

</html>

Employee_Profile.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style3 {

font-size: 12px;

color: #330000;

}

.style4 {

color: #000066;

font-weight: bold;

}

-->

</style>

</head>

<body>

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="select MAX(Employee_Id) from emp_hrm";

PreparedStatement ps=con.prepareStatement(query);

ResultSet rs=ps.executeQuery();

int r=0;

if(rs.next())

{

r=rs.getInt(1);

}

r=r+1;

String code="EMP"+r;

<tr>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<td><div align="center" class="style4">Enter Profile Detail for New Employee </div></td>

</tr>

</table>

<tr>

<td width="89">Employee Id </td>

</div></td>

</tr>

<tr>

<td>First Name </td>

<td>Middle Name </td>

</tr>

<tr>

<td>Designation</td>

</tr>

<tr>

<option>Development</option>

<option>Testing</option>

<option>Hadware</option>

<option>Networking</option>

<option>Front office</option>

</select>

</td>

</tr>

<tr>

</tr>

<tr>

<td>Address1</td>

</tr>

<tr>

<td>Address2</td>

</tr>

<tr>

<option>Lucknow</option>

<option>Gorakhpur</option>

</select></td>

</tr>

<tr>

<td>State</td>

<td>Nationality</td>

</tr>

<tr>

</tr>

</table>

</form>

</div></th>

</tr>

<tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Insert_emp.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

try

{

int eid=Integer.parseInt(request.getParameter("txtid"));

int oid=Integer.parseInt(request.getParameter("txtorgid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="insert into emp_hrm values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

PreparedStatement ps=con.prepareStatement(query);

String First_Name=request.getParameter("txtfname");

String Middle_Name=request.getParameter("txtmname");

String Last_Name=request.getParameter("txtlname");

String Designation=request.getParameter("txtdesignation");

String Dept=request.getParameter("cmbdept");

String DOB=request.getParameter("txtdob");

String Join_Date=request.getParameter("txtdate");

String Address1=request.getParameter("cmdaddress1");

String Address2=request.getParameter("cmdaddress2");

String City=request.getParameter("cmbcity");

String State=request.getParameter("txtstate");

String Nationality=request.getParameter("txtnationality");

ps.setInt(1,eid);

ps.setString(2,First_Name);

ps.setString(3,Middle_Name);

ps.setString(4,Last_Name);

ps.setInt(5,oid);

ps.setString(6,Designation);

ps.setString(7,Dept);

ps.setString(8,DOB);

ps.setString(9,Join_Date);

ps.setString(10,Address1);

ps.setString(11,Address2);

ps.setString(12,City);

ps.setString(13,State);

ps.setString(14,Nationality);

int r=ps.executeUpdate();

if(r>0)

{

out.println("Record Inserted");

}

else

{

out.println("Record Not Inserted");

}

catch(Exception e)

{

out.println(e.getMessage());

}

</body>

</html>

Get_Employee.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td width="51%">Enter Employee ID </td>

</tr><td>

</tr>

</table>

</form>

</div></th>

</tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Edit_Employee.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style3 {

font-size: 12px;

color: #330000;

}

.style4 {

color: #000066;

font-weight: bold;

}

-->

</style>

</head>

<body>

int emp_id=Integer.parseInt(request.getParameter("txtid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="select * from emp_hrm where employee_id=?";

PreparedStatement ps=con.prepareStatement(query);

ps.setInt(1,emp_id);

ResultSet rs=ps.executeQuery();

<tr>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

if(rs.next())

{

<td><div align="center" class="style4"> Profile Detail of Employee /Update </div></td>

</tr>

</table>

<tr>

<td width="89">Employee Id </td>

int id=rs.getInt(1);

</tr>

<tr>

<td>First Name </td>

<td>Middle Name </td>

</tr>

<tr>

<td>Designation</td>

</tr>

<tr>

<option>Accounts</option>

<option>Development</option>

<option>Testing</option>

</select><%=rs.getString(7) %></td>

</tr>

<tr>

<td><p>(yyyy-mm-dd)

</td>

</tr>

<tr>

<td>Address1</td>

</td>

</tr>

<tr>

<td>Address2</td>

</tr>

<tr>

<option>Lucknow</option>

<option>Gorakhpur</option>

</select><%=rs.getString(12) %></td>

</tr>

<tr>

<td>State</td>

<option>Delhi</option>

</select><%=rs.getString(13) %></td>

<td>Nationality</td>

</tr>

<tr>

</tr>

</table>

}

else

{

out.println("<h1>Plz Enter Correct Employee Id </h1>");

}

</form>

</div></th>

</tr>

<tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Update_Employee.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<p>

try

{

int eid=Integer.parseInt(request.getParameter("txtid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="update emp_hrm set Dept=?, address1=?, address2=?,city=?, state=? where employee_id=?";

PreparedStatement ps=con.prepareStatement(query);

String Dept=request.getParameter("cmbdept");

String Address1=request.getParameter("cmdaddress1");

String Address2=request.getParameter("cmdaddress2");

String City=request.getParameter("cmbcity");

String State=request.getParameter("cmbstate");

ps.setString(1,Dept);

ps.setString(2,Address1);

ps.setString(3,Address2);

ps.setString(4,City);

ps.setString(5,State);

ps.setInt(6,eid);

int r=ps.executeUpdate();

if(r>0)

{

out.println("<b><font color=blue size="+24+"+> Employee Detail has been Updated!!!!!</font><b>");

}

else

{

out.println("<h1> Employee Detail has not been Updated!!!!!1</h1>");

}

catch(Exception e)

{

out.println(e.getMessage());

}

</p>

</body>

</html>

User_Registration.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query1="select MAX(User_Id) from user_profile";

PreparedStatement ps1=con.prepareStatement(query1);

ResultSet rs=ps1.executeQuery();

int r=0;

if(rs.next())

{

r=rs.getInt(1);

}

r=r+1;

String code="UID"+r;

<tr>

<%=code %> <input name="txtid" type="hidden" id="txtid"value="<%=r %>" />

</div></th>

</tr>

<tr>

</tr>

<tr>

<td>Password</td>

</tr>

<tr>

<td>Address</td>

</tr>

<tr>

<td>Email</td>

</tr>

<tr>

</tr>

</table>

</form>

</body>

</html>

Insert_User.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<p>

try

{

int uid=Integer.parseInt(request.getParameter("txtid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query1="insert into user_profile values(?,?,?,?,?)";

PreparedStatement ps1=con.prepareStatement(query1);

String User_Name=request.getParameter("txtname");

String Password=request.getParameter("txtpassword");

String Address=request.getParameter("cmdaddress");

String Email=request.getParameter("txtemail");

ps1.setInt(1,uid);

ps1.setString(2,User_Name);

ps1.setString(3,Password);

ps1.setString(4,Address);

ps1.setString(5,Email);

int r1=ps1.executeUpdate();

String query2="insert into login_hrm values(?,?,?)";

PreparedStatement ps2=con.prepareStatement(query2);

ps2.setInt(1,uid);

ps2.setString(2,User_Name);

ps2.setString(3,Password);

int r2=ps2.executeUpdate();

if(r2>0)

{

out.println("<h1>User Sucessfully Register !!!!!! </h1>");

}

else

{

out.println("Not Login");

}

</p>

<p><a href="login.jsp"><strong>Go to Login </strong></a></p>

<p>

}

catch(Exception e)

{

out.println(e.getMessage());

}

</p>

</body>

</html>

Registration.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="select MAX(Applicant_Id) from app_reg";

PreparedStatement ps=con.prepareStatement(query);

ResultSet rs= ps.executeQuery();

int r=0;

if(rs.next())

{

r=rs.getInt(1);

}

r=r+1;

String code="APP"+r;

<tr>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td colspan="6" bgcolor="#00CCFF"><div align="center">Contact Information </div></td>

</tr>

<tr>

<td>Applicant id </td>

</tr>

<tr>

</tr>

<tr>

<td>Address1</td>

</tr>

<tr>

<td>Address2</td>

</tr>

<tr>

<td>Current Location </td>

<td>Email</td>

</tr>

<tr>

<td>Phone</td>

<td>Mobile</td>

</tr>

<tr>

<td colspan="6" bgcolor="#00CCFF"><div align="center">Personal Information </div></td>

</tr>

<tr>

<td>Gender</td>

Male

Female</td><td> </td>

</tr>

<tr>

<td colspan="6" bgcolor="#00CCFF"><div align="center">Professionals & Educational Details </div></td>

</tr>

<tr>

</tr>

<tr>

<td>Skills</td>

</tr>

<tr>

<td>Industry</td>

</tr>

<tr>

<td>Category</td>

</tr>

<tr>

<td>Roles</td>

</tr>

<tr>

<td height="36">Current Employer </td>

<td>Current Salary </td>

</tr>

<tr>

<td>Highest degree </td>

<td>Second Highest degree </td>

</tr>

<tr>

<td colspan="6" bgcolor="#00CCFF"><div align="center">Domain Knowledge </div></td>

</tr>

<tr>

<td>Domain</td>

</tr>

<tr>

</tr>

</table>

</form>

</div></th>

</tr>

<tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Insert_Reg.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

try

{

int a=Integer.parseInt(request.getParameter("txtid"));

int cs=Integer.parseInt(request.getParameter("txtsalary"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="insert into app_reg values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

PreparedStatement ps=con.prepareStatement(query);

String Name=request.getParameter("txtname");

String Address1=request.getParameter("cmdaddress1");

String Address2=request.getParameter("cmdaddress2");

String Current_Location=request.getParameter("txtlocation");

String Phone=request.getParameter("txtphone");

String Email=request.getParameter("txtemail");

String Mobile=request.getParameter("txtmobile");

String DOB=request.getParameter("txtdob");

String Gender=request.getParameter("gender");

String Work_Exp=request.getParameter("txtwork");

String Skills=request.getParameter("txtskills");

String Industry=request.getParameter("txtindustry");

String Category=request.getParameter("txtcategory");

String Current_Employer=request.getParameter("txtcurrent");

String Roles=request.getParameter("txtroles");

String Highest_Degree=request.getParameter("txtdegree");

String Second_Highest_Degree=request.getParameter("txtsecond");

String Domain=request.getParameter("txtdomain");

ps.setInt(1,a);

ps.setString(2,Name);

ps.setString(3,Address1);

ps.setString(4,Address2);

ps.setString(5,Current_Location);

ps.setString(6,Phone);

ps.setString(7,Email);

ps.setString(8,Mobile);

ps.setString(9,DOB);

ps.setString(10,Gender);

ps.setString(11,Work_Exp);

ps.setString(12,Skills);

ps.setString(13,Industry);

ps.setString(14,Category);

ps.setString(15,Current_Employer);

ps.setString(16,Roles);

ps.setInt(17,cs);

ps.setString(18,Highest_Degree);

ps.setString(19,Second_Highest_Degree);

ps.setString(20,Domain);

ps.setString(21,"False");

int r=ps.executeUpdate();

if(r>0)

{

alert("Apllicant Register..............");

</script>

}

else

{

out.println("Record Not Inserted");

}

catch(Exception e)

{

String m=e.getMessage();

</script>

}

</body>

</html>

Get_Applicant.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td width="51%">Enter Applicant ID </td>

</tr><td>

</tr>

</table>

</form>

</div></th>

</tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Edit_Applicant.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

int id=Integer.parseInt(request.getParameter("txtid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="select * from app_reg where Applicant_id=?";

PreparedStatement ps=con.prepareStatement(query);

ps.setInt(1,id);

ResultSet rs= ps.executeQuery();

<tr>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

if(rs.next())

{

int r=rs.getInt(1);

<tr>

<td colspan="6" bgcolor="#00CCFF"><div align="center">Contact Information </div></td>

</tr>

<tr>

<td>Applicant id </td>

int r1=rs.getInt(1);

</tr>

<tr>

</tr>

<tr>

<td>Address1</td>

</tr>

<tr>

<td>Address2</td>

</tr>

<tr>

<td>Current Location </td>

<td>Email</td>

</tr>

<tr>

<td>Phone</td>

<td>Mobile</td>

</tr>

<tr>

<td colspan="6" bgcolor="#00CCFF"><div align="center">Personal Information </div></td>

</tr>

<tr>

<td>Gender</td>

</tr>

<tr>

<td colspan="6" bgcolor="#00CCFF"><div align="center">Professionals & Educational Details </div></td>

</tr>

<tr>

</tr>

<tr>

<td>Skills</td>

</tr>

<tr>

<td>Industry</td>

</tr>

<tr>

<td>Category</td>

</tr>

<tr>

<td>Roles</td>

</tr>

<tr>

<td height="36">Current Employer </td>

<td>Current Salary </td>

</tr>

<tr>

<td>Highest degree </td>

<td>Second Highest degree </td>

</tr>

<tr>

<td colspan="6" bgcolor="#00CCFF"><div align="center">Domain Knowledge </div></td>

</tr>

<tr>

<td>Domain</td>

</tr>

<tr>

</tr>

</table>

}

</form>

</div></th>

</tr>

<tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Update_Applicant.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

try

{

int id=Integer.parseInt(request.getParameter("txtid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="update app_reg set Address1=?,Address2=?,Current_Location=?,phone=?,Email=?,Mobile=? where Applicant_id=?";

PreparedStatement ps=con.prepareStatement(query);

String Address1=request.getParameter("cmdaddress1");

String Address2=request.getParameter("cmdaddress2");

String Current_Location=request.getParameter("txtlocation");

String Phone=request.getParameter("txtphone");

String Email=request.getParameter("txtemail");

String Mobile=request.getParameter("txtmobile");

ps.setInt(7,id);

ps.setString(1,Address1);

ps.setString(2,Address2);

ps.setString(3,Current_Location);

ps.setString(4,Phone);

ps.setString(5,Email);

ps.setString(6,Mobile);

int r=ps.executeUpdate();

if(r>0)

{

out.println("<h1> Employee Detail has been Updated!!!!!1</h1>");

}

else

{

out.println("<h1> Employee Detail has not been Updated!!!!!1</h1>");

}

catch(Exception e)

{

out.println(e.getMessage());

}

</body>

</html>

Time_Management.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {color: #330000}

.style3 {

color: #990000;

font-weight: bold;

}

-->

</style>

</head>

<body>

<tr>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<td><div align="center" class="style1">Daily Attendance Summary </div></td>

</tr>

<tr>

<td><span class="style3">Applicant does not exist!!! </span></td>

</tr>

<tr>

<td>Employee Id </td>

<td bgcolor="#00CCFF">EmployeeName</td>

<td>Remark</td>

</tr>

</table></td>

</tr>

</table>

</form>

</div></th>

</tr>

<tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Attendance.jsp

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

<%@ page import ="java.util.*" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

String user=(String)session.getAttribute("user");

//out.println("ghtyunbnbvnvbnbvnbvnbvnbvnvnbvnbvnvnvn"+user);

if(user!=null)

{

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<th width="750" valign="top" scope="row"><div align="left"><%

java.util.Date dt= new java.util.Date();

<tr>

<td>Employee Id </td>

<strong>Today is:-</strong> <%=dt.toString() %></td>

</tr>

<tr>

Out</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form></div></th>

</tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

}

else

{

out.println("Invalid user!!!!!!!! Access Not alllow..............");

<a href="login.jsp" class="style1">Go to Login</a>

}

</body>

</html>

Insert_Attendance.jsp

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

<%@ page import ="java.util.*" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

try

{

java.util.Date dt= new java.util.Date();

int eid=Integer.parseInt(request.getParameter("txtid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query=null;

PreparedStatement ps=null;

String check=request.getParameter("radio");

if(check.equals("in"))

{

query="insert into attendance_hrm values(?,?,?)";

ps=con.prepareStatement(query);

ps.setInt(1,eid);

ps.setString(2,dt.toString());

ps.setString(3,null);

}

else

{

query="update attendance_hrm set outtime=? where Employee_Id=?";

ps=con.prepareStatement(query);

ps.setString(1,dt.toString());

ps.setInt(2,eid);

}

int r=ps.executeUpdate();

if(r>0)

{

out.println("Attendance Record..............");

}

else

{

out.println("Attendance not Record..............");

}

catch(Exception e)

{

out.println(e.getMessage());

}

</body>

</html>

Attendance_Report.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

String user=(String)session.getAttribute("user");

//out.println("ghtyunbnbvnvbnbvnbvnbvnbvnvnbvnbvnvnvn"+user);

if(user!=null)

{

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td colspan="2"><div align="center"><strong>Attendance Report </strong></div></td>

</tr>

<tr>

<td>Employee Id </td>

</tr>

<tr>

</tr>

</table>

</form>

</div></th>

</tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

}

else

{

out.println("Invalid user!!!!!!!! Access Not alllow..............");

<a href="login.jsp" class="style1">Go to Login</a>

}

</body>

</html>

Attendance_Detail.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

Try

{

int eid=Integer.parseInt(request.getParameter("txtid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query=null;

PreparedStatement ps=null;

query="select * from attendance_hrm where Employee_id=?";

ps=con.prepareStatement(query);

ps.setInt(1,eid);

ResultSet rs=ps.executeQuery();

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</div></th>

<tr>

<td width="225"><div align="center">Intime</div></td>

<td width="234"><div align="center">Outtime</div></td>

</tr>

while(rs.next())

{

<tr>

</tr>

}

</table>

</th>

</tr>

<%@include file="../footer.jsp"%>

</div></th></tr>

</table>

}

catch(Exception e)

{

out.println(e.getMessage());

}

</body></html>

Leave_Application.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style4 {color: #000000; font-weight: bold; }

-->

</style>

</head>

<body>

<tr>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<td colspan="4"><div align="center" class="style4">Leave Application </div></td>

</tr>

<tr>

<td>Request Id </td>

</tr>

<tr>

<td>Employee Id </td>

</tr>

<tr>

<td>Designation</td>

<td>Department</td>

</tr>

<td colspan="4"><div align="center" class="style4">Leave Detail </div></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>Reason for leave(100 letters only) </td>

</tr>

<tr>

<td>Type of Leave Applied for </td>

<option>Medical</option>

<option>Persional</option>

</select></td>

</tr>

<tr>

<td colspan="4" bgcolor="#00CCFF"><div align="center" class="style4">Major Activity To Be Handled during TheLeave Applied </div></td>

</tr>

<tr>

<td>Activity Details </td>

<td>No. ofthe Person Responsible </td>

<td>Details</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td colspan="4" bgcolor="#00CCFF"><div align="center" class="style4">Contact Details of theapplicant during the leave period </div></td>

</tr>

<tr>

<td>Address</td>

</tr>

<tr>

</tr>

</table>

</form>

</div></th>

</tr>

<tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Insert_Leave.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

try

{

int rid=Integer.parseInt(request.getParameter("txtrid"));

int eid=Integer.parseInt(request.getParameter("txteid"));

int pr1=Integer.parseInt(request.getParameter("txtperson1"));

int pr2=Integer.parseInt(request.getParameter("txtperson2"));

int pr3=Integer.parseInt(request.getParameter("txtperson3"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="insert into leave_hrm values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

PreparedStatement ps=con.prepareStatement(query);

String Designation=request.getParameter("txtdesignation");

String Date=request.getParameter("txtdate");

String Name=request.getParameter("txtdate");

String Department=request.getParameter("txtdepartment");

String From=request.getParameter("txtfrom");

String To=request.getParameter("txtto");

String Days=request.getParameter("txtdays");

String Reason_for_Leave=request.getParameter("cmdreason");

String Type_of_Leave_Applied_for=request.getParameter("cmbtype");

String Activity_Details1=request.getParameter("txtactivity1");

String Activity_Details2=request.getParameter("txtactivity2");

String Activity_Details3=request.getParameter("txtactivity3");

String Details1=request.getParameter("txtdetails1");

String Details2=request.getParameter("txtdetails2");

String Details3=request.getParameter("txtdetails3");

String Address=request.getParameter("cmdaddress");

ps.setInt(1,rid);

ps.setInt(2,eid);

ps.setString(3,Designation);

ps.setString(4,Date);

ps.setString(5,Name);

ps.setString(6,Department);

ps.setString(7,From);

ps.setString(8,To);

ps.setString(9,Days);

ps.setString(10,Reason_for_Leave);

ps.setString(11,Type_of_Leave_Applied_for);

ps.setString(12,Activity_Details1);

ps.setString(13,Activity_Details2);

ps.setString(14,Activity_Details3);

ps.setInt(15,pr1);

ps.setInt(16,pr2);

ps.setInt(17,pr3);

ps.setString(18,Details1);

ps.setString(19,Details2);

ps.setString(20,Details3);

ps.setString(21,Address);

int r=ps.executeUpdate();

if(r>0)

{

out.println("Record Inserted");

}

else

{

out.println("Record Not Inserted");

}

catch(Exception e)

{

out.println(e.getMessage());

}

</body>

</html>

Leave_Apply.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

String user=(String)session.getAttribute("user");

//out.println("ghtyunbnbvnvbnbvnbvnbvnbvnvnbvnbvnvnvn"+user);

if(user!=null)

{

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td>Request Id </td>

</tr>

<tr>

<td>Employee Id </td>

</tr>

<tr>

</tr>

<tr>

<td>Leave From </td>

</tr>

<tr>

<td>Leave To </td>

</tr>

<tr>

<td>Total Days </td>

</tr>

<tr>

</tr>

</table>

</form>

</div></th>

</tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

}

else

{

out.println("Invalid user!!!!!!!! Access Not alllow..............");

<a href="login.jsp" class="style1">Go to Login</a>

}

</body>

</html>

Update_Leave.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

try

{

int rid=Integer.parseInt(request.getParameter("txtrid"));

int id=Integer.parseInt(request.getParameter("txtid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="update leave_hrm set Employee_Id=?,Name=?,from=?,To=?,days=? where Request_Id=?";

PreparedStatement ps=con.prepareStatement(query);

String Name=request.getParameter("txtname");

String From=request.getParameter("txtfrom");

String To=request.getParameter("txtto");

String days=request.getParameter("txtday");

ps.setInt(6,rid);

ps.setInt(1,id);

ps.setString(2, Name);

ps.setString(3, From);

ps.setString(4, To);

ps.setString(5,days);

int r=ps.executeUpdate();

if(r>0)

{

out.println("Leave Approved");

}

else

{

out.println("Leave not Approved");

}

catch(Exception e)

{

out.println(e.getMessage());

}

</body>

</html>

Written_Round.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<tr>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td colspan="2" bgcolor="#00CCFF"><div align="center">Enter Employee Id & First Name </div></td>

</tr>

<tr>

<td>Employee Id </td>

</tr>

<tr>

<td>First Name </td>

</tr>

<tr>

</tr>

</table>

</form>

</div></th>

</tr>

<tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Test_Reg.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

try

{

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query="select * from app_reg where status=?";

String query1="insert into test_result_hrm values(?,?,?,?)";

String query2="insert into technical_result_hrm values(?,?,?,?)";

String query3="insert into hr_test_hrm values(?,?,?,?)";

PreparedStatement ps=con.prepareStatement(query);

PreparedStatement ps1=con.prepareStatement(query1);

PreparedStatement ps2=con.prepareStatement(query2);

PreparedStatement ps3=con.prepareStatement(query3);

ps.setString(1,"false");

ResultSet rs =ps.executeQuery();

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td>Applicant Id </td>

<td>Apply for Test </td>

</tr>

int i=0;

while(rs.next())

{

int id=rs.getInt(1);

ps1.setInt(1,id);

ps1.setString(2,"null");

ps1.setString(3,"null");

ps1.setString(4,"null");

ps2.setInt(1,id);

ps2.setString(2,"null");

ps2.setString(3,"null");

ps2.setString(4,"null");

ps3.setInt(1,id);

ps3.setString(2,"null");

ps3.setString(3,"null");

ps3.setString(4,"null");

int r1=ps1.executeUpdate();

int r2=ps2.executeUpdate();

int r3=ps3.executeUpdate();

i++;

<tr>

<td>Allow for Test</td>

</tr>

}

</table>

</form>

</div></th>

</tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

<a href="login.jsp" class="style1">Go to Login</a>

}

catch(Exception e)

{

out.println(e.getMessage());

}

</body>

</html>

Written.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td>Applicant Id </td>

</tr>

<tr>

<option>Written</option>

</select>

</td>

</tr>

<tr>

</tr>

<tr>

<td>Marks</td>

</tr>

<tr>

</tr>

</table>

</form>

</div></th>

</tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Update_Written.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td>Applicant Id </td>

</tr>

<tr>

<option>Written</option>

</select>

</td>

</tr>

<tr>

</tr>

<tr>

<td>Marks</td>

</tr>

<tr>

</tr>

</table>

</form>

</div></th>

</tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Technical_Round.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<tr>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%> </th>

<tr>

<td colspan="2" bgcolor="#00CCFF"><div align="center">Enter Employee Id & First Name </div></td>

</tr>

<tr>

<td>Employee Id </td>

</tr>

<tr>

<td>First Name </td>

</tr>

<tr>

</tr>

</table>

</form>

</div> </th>

</tr>

<tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Technical.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

String user=(String)session.getAttribute("user");

//out.println("ghtyunbnbvnvbnbvnbvnbvnbvnvnbvnbvnvnvn"+user);

if(user!=null)

{

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td>Applicant Id </td>

</tr>

<tr>

<option>Technical</option>

</select>

</td>

</tr>

<tr>

</tr>

<tr>

<td>Marks</td>

</tr>

<tr>

</tr>

</table>

</form></div></th>

</tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

}

else

{

out.println("Invalid user!!!!!!!! Access Not alllow..............");

<a href="login.jsp" class="style1">Go to Login</a>

}

</body>

</html>

Update_Technical.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

try

{

int id=Integer.parseInt(request.getParameter("txtid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query=" update technical_result_hrm set Test_Type=?,Test_Date=?,Marks=? where Applicant_Id=?";

PreparedStatement ps=con.prepareStatement(query);

String Test_Type=request.getParameter("cmbtype");

String Test_Date=request.getParameter("txtdate");

String Marks=request.getParameter("txtmark");

ps.setInt(4,id);

ps.setString(1,Test_Type);

ps.setString(2,Test_Date);

ps.setString(3,Marks);

int r=ps.executeUpdate();

if(r>0)

{

out.println("Result updated");

}

else

{

out.println("Result not updated");

}

catch(Exception e)

{

out.println(e.getMessage());

}

</body>

</html>

HR_Round.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<tr>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td colspan="2" bgcolor="#00CCFF"><div align="center">Enter Employee Id & First Name </div></td>

</tr>

<tr>

<td>Employee Id </td>

</tr>

<tr>

<td>First Name </td>

</tr>

<tr>

</tr>

</table>

</form>

</div></th>

</tr>

<tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

HR_Test.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

String user=(String)session.getAttribute("user");

//out.println("ghtyunbnbvnvbnbvnbvnbvnbvnvnbvnbvnvnvn"+user);

if(user!=null)

{

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

<tr>

<td>Applicant Id </td>

</tr>

<tr>

</select>

</td>

</tr>

<tr>

</tr>

<tr>

<td>Marks</td>

</tr>

<tr>

</tr>

</table>

</form>

</div></div></th>

</tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

}

else

{

out.println("Invalid user!!!!!!!! Access Not alllow..............");

<a href="login.jsp" class="style1">Go to Login</a>

}

</body>

</html>

Update_Hr.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

try

{

int id=Integer.parseInt(request.getParameter("txtid"));

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hrm","root","root");

String query=" update technical_result_hrm set Test_Type=?,Test_Date=?,Marks=? where Applicant_Id=?";

PreparedStatement ps=con.prepareStatement(query);

String Test_Type=request.getParameter("cmbtype");

String Test_Date=request.getParameter("txtdate");

String Marks=request.getParameter("txtmark");

ps.setInt(4,id);

ps.setString(1,Test_Type);

ps.setString(2,Test_Date);

ps.setString(3,Marks);

int r=ps.executeUpdate();

if(r>0)

{

out.println("Result updated");

}

else

{

out.println("Result not updated");

}

catch(Exception e)

{

out.println(e.getMessage());

}

</body>

</html>

Change_Pass.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

function validate()

{

if(document.form1.txtid.value == "")

{

alert("Plz Enter User Id !!!!!!!!!!!!");

return;

}

if(document.form1.txtuname.value == "")

{

alert("Plz Enter User Name !!!!!!!!!!!!");

return;

}

if(document.form1.txtpassword.value == "")

{

alert("Plz Enter Password !!!!!!!!!!!!");

return;

}

document.form1.action="update_pass.jsp";

document.form1.submit();

}

</script>

<tr>

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td><div align="right">Password</div></td>

</tr>

<tr>

<td><div align="right">New Password</div></td>

</tr>

<tr>

</tr>

</table>

</form>

</th>

</tr>

<tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

</body>

</html>

Menu.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style4 {color: #993300}

.style5 {font-size: 14px}

-->

</style>

</head>

<body>

<tr>

</a>

</ul></th>

</tr>

<span class="style4"><a href="employee_profile.jsp">Employee Profile</br>

</a></span>

<li class="style5"><a href="employee_profile.jsp">Create Profile</a></li>

<li class="style5"><a href="get_employee.jsp">Edit Profile </a></li>

</ul></th>

</tr>

<span class="style4">Recruitment Registration </span><br/>

<li class="style5"><a href="registration.jsp">New Applicant</a> </li>

<li class="style5"><a href="get_applicant.jsp">Update Applicant</a></li>

<br />

<span class="style4"><a href="written_round.jsp">Wrriten Round </a></span>

<li class="style5"><a href="/mca1/written.jsp">Update Result</a></li>

<br>

<span class="style4"><a href="technical_round.jsp">Technical Round</br>

</a></span>

<li class="style5"><a href="allow_tech.jsp">Shortlist for Tech. Round</a></li>

<li class="style5"><a href="/mca1/technical.jsp">Update Result</a></li>

<br>

<span class="style4"><strong><a href="hr_round.jsp">HR Round</br>

</a></strong></span>

<li class="style5"><a href="allow_hr.jsp">Shortlist for HR Round</a></li>

<li class="style5">Update Result</li>

<li class="style5">Shortlist for selection</li>

<li class="style5"><a href="allowed.jsp">Selected Candidate</a></li>

</ul></th>

</tr>

<span class="style4"><a href="time_management.jsp">Time Management</br>

</a></span>

<li class="style5"><a href="attendance.jsp">Enter/Update Attendance</a></li>

<li class="style5"><a href="attendance_report.jsp">Attendance summary </a></li>

</ul></th>

</tr>

<span class="style4"><a href="leave_application.jsp">Leave Management</br>

</a></span>

<li class="style5"><a href="leave_application.jsp">Leave Apply</a></li>

<li class="style5"><a href="leave_apply.jsp">Leave approve/Update Result</a></li>

<li class="style5">Approved Request </li>

</ul> </th>

</tr>

<li class="style4"><a href="payroll.jsp">Payroll</a></li>

<li>Employee Agreement</li>

<li>Calc/Get Employee salary </li>

</ul></th>

</tr>

<li class="style4"><a href="chang_pass.jsp">Change Password </a></li>

</ul></th>

</tr>

<li class="style4">About Us </li>

</ul></th>

</tr>

</table>

</body>

</html>

Index.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

font-size: 18px;

font-weight: bold;

}

-->

</style>

</head>

<body>

String user=(String)session.getAttribute("user");

//out.println("ghtyunbnbvnvbnbvnbvnbvnbvnvnbvnbvnvnvn"+user);

if(user!=null)

{

<%@include file="../header.jsp"%>

</div></th>

</tr>

<tr>

<%@include file="../menu.jsp"%>

</th>

</tr>

<%@include file="../footer.jsp"%>

</div></th>

</tr>

</table>

}

else

{

out.println("Invalid user!!!!!!!! Access Not alllow..............");

<a href="login.jsp" class="style1">Go to Login</a>

}

</body>

</html>

Header.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style2 {

color: #993300;

font-size: 36px;

font-weight: bold;

}

-->

</style>

</head>

<body>

<tr>

</tr>

</table>

</body>

</html>

Design.jsp

<tr>

<td>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table></td>

<td>

<h1 align="left"><font color="#0000CC">Welcome</font></h1>

<td>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table></td>

</tr>

<tr >

<td>

</tr>

</table>

<tr>

<td><div align="center"><font color="#990000" size="5" face="Courier New, Courier, monospace"><marquee direction="left"behaviour="scroll"><strong><font size="6">Human Resource Management System</font></strong> </marquee>

</font></div></td>

</tr>

</table>

<p>

</table>

</p>

</blockquote>

Footer.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {color: #990000}

-->

</style>

</head>

<body>

<tr>

<th height="25" bgcolor="#3399FF" scope="row"><div align="center"><span class="style1">(c)copyright By HRMS Solution </span></div></th>

</tr>

</table>

</body>

</html>

Logout.jsp

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

<!--

.style1 {

color: #993300;

font-weight: bold;

}

.style2 {font-size: 24px}

-->

</style>

</head>

<body>

<p>

session.invalidate();

</p>

<p align="center" class="style2"> <span class="style1">you are sucessfully Log Out.....</span>...</p>

<p align="center" class="style1">Thanks for using HRM Solution..... </p>

<p align="center"><a href="login.jsp">Login again... </a></p>

</body>

</html>

9. Code Efficiency

CODE EFFICIENCY:-

Code of the software is said to be efficient, if the complexity of all types is minimum. In the code of the developed software, I have tried to minimize the space and time complexity, so the code is efficient.

The complexities can be minimized in three ranges. They are called as organized simplicity, disorganized complexity and organized complexity.

Organized simplicity is represented by systems that are adequate models of some real world phenomena and yet consist of a very small number of variables, which depend on each other in highly deterministic fashion.

Disorganized complexity possesses characteristics that are represented by the system, with every large number of variables and high degrees of randomness.

Organized complexity is methodologically undeveloped in the sense that neither analytical nor statistical methods are adequate for dealing with systems that fit into it.

Computational complexity

Computational complexity is a characterization of time and space requirements for solving a problem by a particular algorithm. Either of these requirements is usually expressed in terms of a single that represent the size of the problem. Although computational complexity has been predominantly studied in terms of the time it takes to perform a computation, the amount of computer memory is required frequently just as important. This requirement is usually called the space requirement. It is expressed in the terms of a space complexity function, analogous to the time complexity function.

10. Validation checks

Validation refers to a set of activities that ensure that software that has been built is traceable to customer requirements. Validation can be defined in many ways, but a simple definition is that validation succeeds when software functions in a manner that can be reasonably expected by the customer. Validation checks specify the limit of the software up to which software is valid also validation checks controls the security of the software. In this application I have used ASP.Net validation controls and java script both , the controls are:

Regular Expression Validator
Required Field Validator
Common Regular Expression validator
Custom validation
Compare validator
Range valiadtor

11. TESTING PHASE

The testing phase involves the testing of the developed system using various kinds of data. An elaborated testing of data is prepared and a system is tested using the test data. While testing, errors are noted and corrections remade, the corrections are also noted for future use.

SYSTEM TESTING

Testing is a set of activities that can be planned in advance and conducted systematically. The proposed system is tested in parallel with the software that consists of its own phases of analysis, implementation, testing and maintenance. Following are the tests conducted on the system.

UNIT TESTING

During the implementation of the system each module of the system was tested separately to uncover errors with in its boundaries. User interface was used as a guide in the process.

MODULE TESTING

A module is composed of various programs related to that module. Module testing is done to check the module functionality and interaction between units within a module.

It checks the functionality of each program with relation to other programs within the same module. It then tests the overall functionality of each module.

INTEGRATION TESTING

Integration testing is a systematic technique for constructing the program structure while conducting tests to uncover errors associated with interfacing. The objective is to take unit-tested module and build a program structure that has been dictated by design.

ACCEPTANCE TESTING

The software has been tested with the realistic data given by the client and produced fruitful results. The client satisfying all the requirements specified by them has also developed the software within the time limitation specified. A demonstration has been given to the client and the end-user giving all the operational features.

12. IMPLEMENTATION PHASE

The implementation is the final and important phase. It involves User training, system testing and successful running of the developed system. The users test the developed system when changes are made according to the needs. The testing phase involves the testing of the developed system using various kinds of data. An elaborate testing of data is prepared and system is tested using the tests data.

Implementation is the stage where theoretical design turned into a working system. Implementation is planed carefully to propose system to avoid unanticipated problems. Many preparations involved before and during the implementation of proposed system. The system needed to be plugged in to the organization’s network then it could be accessed from anywhere, after a user logins into the portal. The tasks that had to be done to implement the system were to create the database tables in the organization database domain. Then the administrator was granted his role so that the system could be accessed.

The next phase in the implementation was to educate the system. A demonstration of all the functions that can be carried out by the system was given to examination department person, who will make extensive use of the system.

13. SECURITY MECHANISM:

In the software security there are two levels of security. The 1^st level of security, which is provided by the FRONT END and 2^nd level of security provided by the database which is being used.

FRONT END SECURITY:-

This security level is developed or designed by the s/w developer or designer. S/he provides her/his s/w the security for the system, by considering many factors regarding to the particular s/w.

In this software following are used to provide security.

LOGIN CHECKING:

BACK END SECURITY:-

(7) CREATE USER

(8) DELETE USER

(9) MODIFY USER

(10) GRANT PERMISSION TO USER

(11)COMMIT

(12)ROLLBACK

14. CONCLUSION

In this instance it may be true that on eBay, they have something for everybody, whatever their tastes may be.

15.FUTURE SCOPE OF THIS PROJECT :-

In future this project can be treated as product according to specification and needs of any organisation.

Since recruitment plays key role in any organization; thus, success over a long period of time and reliance of organization over recruitment is going to be one of the most considered topic for any organization.

Therefore On-Line Recruiting Process will be of great help in carrying out recruitment process smoothly and effectively.

At present days every organization is using web technology for their proper functioning, so this web based project is all in all important from market aspects.

FREE DOWNLOAD BCA MCA MANAGEMENT SYSTEM PROJECT SYNOPSIS REPORT WITH SOURCE CODE (ASP.NET PHP JAVA)

FREE DOWNLOAD IGNOU BCA MCA PROJECT, SYNOPSIS AND FINAL REPORT WITH SOURCE CODE

Friday, May 15, 2020

Human Resource Management System

HUMAN RESOURCE MANAGEMENT SYSTEM PROJECT REPORT | HUMAN RESOURCE MANAGEMENT SYSTEM

Project Overview

3.2 PROPOSED SYSTEM

1) Introduction:

1.1. Purpose:

UNIFIED MODELING LANGUAGE

BASIC BUILDING BLOCKS OF THE UML:

CLASS DIAGRAM:

USE CASES DIAGRAM:

INTERACTION DIAGRAMS

ACTIVITY DIAGRAM

STATE CHART DIAGRAMS

7.2.1 DATA FLOW DIAGRAMS

7.2.2 ER Diagram

7.2.3DATABASE TABLES

Computational complexity

No comments:

Post a Comment

SQL Server Unique Constraint