/*Before Executing dis program you should create Employee Table in the database And "emp.html" with eno,ename,salary field......*/
package com.edu.servlets;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class EmployeeServlet extends HttpServlet{
Connection con;
PreparedStatement ps;
public void init(ServletConfig config) throws ServletException{
String driver=config.getInitParameter("driver");
String cs=config.getInitParameter("url");
String usr=config.getInitParameter("user");
String pwd=config.getInitParameter("pwd");
try
{
Class.forName(driver);
con=DriverManager.getConnection(cs,usr,pwd);
ps=con.prepareStatement("Insert into employee values(?,?,?)");
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
}//init()
public void destroy(){
try
{
if(ps!=null)
ps.close();
if(con!=null)
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
String a=request.getParameter("empno");
String name=request.getParameter("name");
String c=request.getParameter("salary");
int eno=Integer.parseInt(a);
float salary=Float.parseFloat(c);
try{
ps.setInt(1,eno);
ps.setString(2,name);
ps.setFloat(3,salary);
ps.executeUpdate();
}catch(SQLException e)
{
e.printStackTrace();
}
response.sendRedirect("emp.html");
}//doPost()
}//EmployyeeServlet class