问题描述
Stringsql="insertintoteacherinfo(score)values('"+average+"')wheregonghao="+request.getParameter("go")+"";sqlRst=sqlStmt.executeQuery(sql);go是上页传来的参数··这句老是提示有语法错误大家看下谢谢了在线急等
解决方案
解决方案二：
rootcausejavax.servlet.ServletException:[Microsoft][SQLServer2000DriverforJDBC][SQLServer]在关键字'where'附近有语法错误。org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)org.apache.jsp.pingfen._1_jsp._jspService(_1_jsp.java:111)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)javax.servlet.http.HttpServlet.service(HttpServlet.java:729)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)javax.servlet.http.HttpServlet.service(HttpServlet.java:729)rootcausejava.sql.SQLException:[Microsoft][SQLServer2000DriverforJDBC][SQLServer]在关键字'where'附近有语法错误。com.microsoft.jdbc.base.BaseExceptions.createException(UnknownSource)com.microsoft.jdbc.base.BaseExceptions.getException(UnknownSource)com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(UnknownSource)com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(UnknownSource)com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(UnknownSource)com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(UnknownSource)com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(UnknownSource)com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(UnknownSource)com.microsoft.jdbc.base.BaseStatement.postImplExecute(UnknownSource)com.microsoft.jdbc.base.BaseStatement.commonExecute(UnknownSource)com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(UnknownSource)com.microsoft.jdbc.base.BaseStatement.executeQuery(UnknownSource)org.apache.jsp.pingfen._1_jsp._jspService(_1_jsp.java:99)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)javax.servlet.http.HttpServlet.service(HttpServlet.java:729)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
解决方案三：
你把sql语句在后台打印一下，应该很容易看出来了
解决方案四：
我落伍了，insert还能和where一起用？？感觉是你想更改，用update吧貌似
解决方案五：
回帖是一种美德！每天回帖即可获得10分可用分！
解决方案六：
回帖是一种美德！每天回帖即可获得10分可用分！