求指教 这个方法是错在哪里？

Question

public static boolean InsertAuditEvent(HttpServletRequest request){
boolean b = false;
String checkout_style_id = StringUtil.getRequestString(request, "way");    
String bank_name = StringUtil.getRequestString(request, "bankname");                    
String account = StringUtil.getRequestString(request, "banknumber");                        
String account_uesrname = StringUtil.getRequestString(request, "holder");      
//String developer_id = StringUtil.getRequestString(request, "developer_id");       
String developer_type = StringUtil.getRequestString(request, "usertype");        
String APPLY_PRICE = StringUtil.getRequestString(request, "withdraw");              
        String sql="Insert into withdraw (checkout_style_id, bank_name, account,account_name,syadate,developer_type,apply_price,draw_type) values ("+checkout_style_id+", "+bank_name+","+account+","+account_name+","+developer_id+","+syadate+","+developer_type+","+apply_price+","+draw_type+")  ";
b= DataBaseOperator.insertOrUpdateData(sql);
        return b;
   }
报错内容为：String sql="Insert into withdraw (checkout_style_id, bank_name, account,account_name,syadate,developer_type,apply_price,draw_type) values ("+checkout_style_id+", "+bank_name+","+account+","+account_name+","+developer_id+","+syadate+","+developer_type+","+apply_price+","+draw_type+")  ";

Answer 1

2012-5-23 11:21:25 org.apache.catalina.loader.WebappClassLoader loadClass
信息: Illegal access: this web application instance has been stopped already.  Could not load javax.servlet.jsp.SkipPageException.  The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1587)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1546)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63)
at org.apache.jsp.finace.carry_005fapplication_005fdo_jsp._jspService(carry_005fapplication_005fdo_jsp.java:77)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

Answer 2

String sql="Insert into withdraw (checkout_style_id, bank_name, account,account_name,syadate,developer_type,apply_price,draw_type) values ('"+checkout_style_id+"', '"+bank_name+","+account+"','"+account_name+"','"+developer_id+"','"+syadate+"','"+developer_type+"','"+apply_price+"','"+draw_type+"')  ";

Answer 3

String sql="Insert into withdraw (checkout_style_id, bank_name, account,account_name,syadate,developer_type,apply_price,draw_type) values ('"+checkout_style_id+"', '"+bank_name+"',"+account+",'"+account_name+"',"+developer_id+",'"+syadate+"','"+developer_type+"','"+apply_price+"','"+draw_type+"') ";

Answer 4

问题解决，谢谢大家帮忙，因为oracle没有自增长，只能写了个函数，结贴。

Answer 5

insert into withdraw(checkout_style_id, bank_name) values(1,'name');
肯定是少了单引号；
数据库建的表中，若某个字段是字符（串）类型的，insert的时候要价单引号；当在应用程序中拼接插入字符串时，注意字段是字符类型的双引号中还要再加单引号哦～
如：
String sql="insert into withdraw(checkout_style_id,bank_name) values("+checkout_style_id+",'"+bank_name+"')";
也就是：
String sql="insert into withdraw(checkout_style_id,bank_name) values(1,'xiaoming')"