欢迎来到Doc100.Net免费学习资源知识分享平台!
您的位置:首页 > 程序异常 >

j2ee揭示ora-00933: sql 命令未正确结束 请大家都来看看代码很简单.

更新时间: 2014-01-05 02:14:58 责任编辑: Author_N1

 

J2EE提示ORA-00933: SQL 命令未正确结束 请大家都来看看代码很简单...
                        
ConnUtil connUtil = new ConnUtil();
Connection conn= connUtil.getConnection();
PreparedStatement state=conn.prepareStatement("UPDATE STUDENTS SET name=?,username=?,password=? WHERE studentnumber=?;" );
state.setString(1, stuupdata.name);
state.setString(2, stuupdata.username);
state.setString(3, stuupdata.password);
state.setInt(4, stuupdata.studentnumber);
state.executeUpdate();


老是提示ORA-00933: SQL 命令未正确结束    stuupdata是个参数类,里面参数肯定没问题,求大神指导!!!
ORA-00933: SQL 命令未正确结束

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3897)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)
at cn.com.njust.web.admin.StuUpdata.updata(StuUpdata.java:55)
at org.apache.jsp.jsp.stuupdatasuccess_jsp._jspService(stuupdatasuccess_jsp.java:87)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
上一篇:上一篇
下一篇:下一篇

 

随机推荐程序问答结果

 

 

如对文章有任何疑问请提交到问题反馈,或者您对内容不满意,请您反馈给我们DOC100.NET论坛发贴求解。
DOC100.NET资源网,机器学习分类整理更新日期::2014-01-05 02:14:58
如需转载,请注明文章出处和来源网址:http://www.doc100.net/bugs/t/7544/
本文WWW.DOC100.NET DOC100.NET版权所有。