This Employee Management System Final year JSP project useful for all employees in any organization, colleges, industries, shopping malls. Where employee can apply leaves, can chat with other employees, send mails and messages, providing library services. We have designed this JSP coding project foe our college where college staff can interact with others and using all felicities with the help of this web application. This can work in local are network and over the internet. if any staff member not able to go to college  then they can apply leave online using internet. teachers can apply books for enhancing their subject knowledge before going to teach students. Admin has all rights to approve or reject all staff requests.

Also See:

Employee Management System Project

Find the below added Java Server pages JSP scripting code for EMS Project:

[cc lang=”asp”] String email =request.getParameter(“add”);
int st=0;
String eid=” “,email1=” “;

try

{
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

Connection cn1 = DriverManager.getConnection(“jdbc:odbc:Intranet”,””,””);

PreparedStatement ps12=cn1.prepareStatement(“select Empid,Email from Employee where Username=?”);
ps12.setString(1,userdet.getUser());

ResultSet rs=ps12.executeQuery();

if(rs.next())
{
eid=rs.getString(1);
email1 =rs.getString(2);

}
PreparedStatement ps=cn1.prepareStatement(“select Email from AddressBook where Empid=?”);
ps.setString(1,eid);
ResultSet rs1 =ps.executeQuery();
while(rs1.next())
{
if(rs1.getString(1)==email)
st=1;
}

}catch(Exception e){%><%}
if(email==email1)
{
st=1;
}
if(st==0)
{
try{
Connection con=DriverManager.getConnection(“jdbc:odbc:Intranet”,””,””);
PreparedStatement psx1=con.prepareStatement(“insert into AddressBook(Empid,Email) values(?,?)”);
psx1.setString(1,eid);
psx1.setString(2,email);
psx1.executeUpdate();
}catch(Exception e){}
[/cc]

Admin Employee modify JSP Code:

[cc lang=”asp”]try
{
String ss = request.getParameter(“s1”);
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
Connection cn = DriverManager.getConnection(“jdbc:odbc:Intranet”,””,””);
PreparedStatement ps=cn.prepareStatement(“select Address,Phone,Email,Department,Designation,Salary from Employee where Empid=?”);
ps.setString(1,ss);
ResultSet rs= ps.executeQuery();
if(rs.next())
{
addr=rs.getString(1);
phno=Integer.parseInt(rs.getString(2));
email=rs.getString(3);
dept=rs.getString(4);
desig=rs.getString(5);
sal=rs.getString(6);
}[/cc]

Download Employee Management System JSP & HTML Project.

Useful Links:

Staff Management System Project