Go4Expert

Go4Expert (http://www.go4expert.com/)
-   JSP (http://www.go4expert.com/forums/jsp/)
-   -   jsp to Delete data from database wont work (http://www.go4expert.com/forums/jsp-delete-data-database-wont-t24198/)

Dave1816 17Dec2010 12:47

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>



All times are GMT +5.5. The time now is 10:39.