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+") ";
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+") ";
解决方案 »
- log4j 无法输出日志问题,请大家帮忙。。。
- 如何从JAVA里传数组到ORACLE存储过程?
- 学习Hibernate中遇到的一堆问题,我实在无力解决!
- eclipse出现问题了,请高手相救,谢谢
- struts 动态form如何处理?急!!!
- 建立两个表关联后,部署出错,提示not allowed to have key-fields.这样的错误是怎么回事呢?在线!
- 在servlet里大量使用静态方法会不会有并发访问的问题
- 谁帮我看看这代码哪里的问题?谢谢大哥大姐了。
- j2ee中session Bean中如何连接两种以上的数据库,比如oracle,sqlserver...此问题困扰了我一个星期也没有解决!!!!!
- ActiveMQ实现监听多个队列消费
- jxl操作excel的一些问题
- ClientAbortException: java.net.SocketException: Connection reset
信息: 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)
肯定是少了单引号;
数据库建的表中,若某个字段是字符(串)类型的,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')"