0) MM_editAction += "?" + request.getQueryString();
if (request.getParameter("MM_delete") != null &&
request.getParameter("MM_recordId") != null) {
String MM_tableName = "@@table@@";
String MM_tableCol = "@@col@@";
String MM_recordId = "@@colQuote@@" + request.getParameter("MM_recordId") + "@@colQuote@@";
String MM_redirectPage = "@@url@@";
// create the delete sql statement
String MM_deleteStr = "delete from " + MM_tableName + " where " + MM_tableCol + " = " + MM_recordId;
// finish the sql and execute it
Driver MM_driver = (Driver)Class.forName("@@driver@@").newInstance();
Connection MM_connection = DriverManager.getConnection("@@conn@@", "@@username@@", "@@password@@");
PreparedStatement MM_deleteStatement = MM_connection.prepareStatement(MM_deleteStr);
MM_deleteStatement.setQueryTimeout(0);
MM_deleteStatement.executeUpdate();
MM_connection.close();
// redirect with URL parameters
if (MM_redirectPage.length() == 0) MM_redirectPage = request.getRequestURI();
if (MM_redirectPage.indexOf('?') == -1 && request.getQueryString() != null)
MM_redirectPage += "?" + request.getQueryString();
response.sendRedirect(response.encodeRedirectURL(MM_redirectPage));
}
%>
]]>