通过jsp向数据库中添加数据的问题

Question

试过好多次了，可总是不执行prepStmt = con.prepareStatement(insertStatment);所以也不能往后执行

Answer 1

我把全部代码都贴上吧，实在很疑惑：（帮忙看一下程序有问题吗？谢谢！
try {
// Get Parameter Value
String MemberNo = request.getParameter("number");
String Firstname = request.getParameter("firstname");
String Lastname = request.getParameter("lastname");
String Sex = request.getParameter("sex");
String Address = request.getParameter("address");
String Call = request.getParameter("call");

AccountBean account = new AccountBean();
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());        try {
con = DriverManager.getConnection("jdbc:odbc:AccountDB");  } catch (SQLException e) {
throw new Throwable("DB Connection failed: " + e.getMessage());
 } try {
String insertStatement = "insert into customerdetail( number,firstname,lastname,sex,address,call) values('"+MemberNo+"','"+Firstname+"','"+Lastname+"','"+Sex+"','"+Address+"','"+Call+"')";
prepStmt = con.prepareStatement(insertStatement);
int X = prepStmt.executeUpdate();prepStmt.close();
rs.close();
con.close();
} catch (Exception e) {
throw new Throwable("DB failure: " + e.getMessage());
}request.getSession().setAttribute(ACCOUNT_BEAN, account);
RequestDispatcher dispatcher = getServletContext().getRequestDispatcher(RESULT_JSP5);
dispatcher.forward(request, response);

} catch(Throwable theException) {
System.out.println(theException.getMessage());

 try {
if (!con.isClosed()) {
   prepStmt.close();
   rs.close();
  con.close();
}
  request.getSession().setAttribute(ERROR_MESG, theException.getMessage());
RequestDispatcher dispatcher = getServletContext().getRequestDispatche(ERROR_JSP);
  dispatcher.forward(request, response);
}catch(Exception e){
throw new ServletException(e.getMessage());
}
}