jsp with database oracle

hai i am doing one program in jsp i want to check the jsp life cycle methods so wrote one program, in which i write jspInit() method and jspDestroy() methods. but i am getting error i crate a table with the name employee i am sending sample code to u. plz help me to fix this problem

<%@ page import ="java.sql.*" %> <%@ page import ="java.util.*" %> <%! Connection con; PreparedStatement ps; public void jspInit() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:online","system","manager"); ps=con.prepareStatement("insert into employees values(?,?,?)"); } catch(Exception e) { e.printStackTrace();

}

} public void jspDestroy() { try { ps.close(); con.close(); } catch(Exception e) { e.printStackTrace(); } } %> <%

int eno = Integer.parseInt(request.getParameter("t1")); String name=request.getParameter("t2"); float sal = Float.parseFloat(request.getParameter("t3")); ps.setInt(1,eno); ps.setString(2,name); ps.setFloat(3,sal); ps.executeUpdate(); %> <%@ include file ="emp.html" %>