hi all,
i have a jsp page with an update bean.
when i tried to use statement.executeUpdate(), it just hung
there.......no response no nothing at all.......can someone tell me
what's wrong with my code? below is my code.
thanks in advance.
ced
--------------------------------------------------------------------------------------------------
my jsp,
<jsp:useBean id="beanConnect" class="jsp.DbBean" scope="application"/>
<%
if (request.getParameter("jsp_insert") != null) {
String sNo = request.getParameter("txtStaffNo");
String sName = request.getParameter("txtName");
String sDept = request.getParameter("txtSection");
String UpdateString = "insert into t_staff (staff_no, staff_name,
dept) values ('" + sNo + "','" + sName + "','" + sDept + "')";
beanConnect.connect();
beanConnect.execUpdate(UpdateString);
}
%>
in my bean,
package jsp;
import java.sql.*;
import java.io.*;
public class DbBean {
public boolean connect{
//connection properties..............................
}
public void execUpdate (String queryString) throws SQLException
{
Statement updStmt = dbCon.createStatement ();
updStmt.executeUpdate(queryString);
}
} //end of the Dbbean
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
