public void delete(String employeeId)
  {
   
   try
   {
    String querystring="DELETE FROM EMPLOYEE WHERE EMPID=?";
    con=getConnection();
    ptmt=con.prepareStatement(querystring);
    ptmt.setString(1, employeeId);
    ptmt.executeUpdate();
    
   }
   catch(SQLException e)
   {
    e.printStackTrace();
   }
   finally
   {
    try
    {
    if(rs!=null)
        rs.close();
    if(ptmt!=null)
       ptmt.close();
    if(con!=null)
       con.close();
    }
    catch(SQLException e)
    {
     e.printStackTrace();
    }
    catch(Exception e)
    {
     e.printStackTrace();
    }
    
   }
   
  }