Go4Expert - jsp to Delete data from database wont work

Hello can im new to Jsp and trying to delete data in a database using JSP. everything works fine except the data dose not delete :nonod: I have posted the code below if any 1 can help me. Thanks

HTML Code:

<html>

<head>

<title>Delete Question

</title>

</head>



<body>

<%



int nID1;

 if (request.getParameter("nID") == null) {



} else {

 String sQuestID = request.getParameter("nID"); 





 nID1 =  Integer.parseInt(sQuestID);





%>

<!-- the % tag below is what is called a scriptlet tag - allows java to be embedded in the jsp -->

<%@ page import="java.sql.*" %>

<%@ page import="java.util.*" %>



<%





// creates and initialises the JDBC-ODBC bridge driver

        // NB this driver is designated as "experimental" and not recommended for commercial use!

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();



        // note that we give the name of the local directory here! --> "nas1/" segment below

        // will need changing if this page is moved!

        String sHere = getServletContext().getRealPath("/au003022/jsp/bare2/JSP-FAQ-assignment.accdb");



        // builds the connection string - makes it easier to print it for checking purposes

        String sConn = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + sHere + ";";



// makes the connection with the database

        Connection cnJDBC = DriverManager.getConnection(sConn);



        // gets ready to send a SQL command down our connection

        Statement stJDBC = cnJDBC.createStatement();





        // Allows us to check our SQL statement and see that it is well formed

        String sSQL = "Delete FROM tblFAQ WHERE ID='" + nID1 + "';";        

        //out.print("Debug:<br />" + sSQL + "<hr />");



//ResultSet rs = stJDBC.executeUpdate(sSQL);



}



//response.sendRedirect("logmain.jsp");









%>

</table>



</body>

</html>