Thursday, March 3, 2011

Servlets- Inserting a Employee Details by using the PreparedStatement()


/*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

No comments:

Post a Comment