jsp 运行的出错

说明insert已经执行了，但后面代码有错误阿！
具体看错误提示！

解决方案 »

  1.   

    应该是sql语句后的页面出错
    在页面里放几个System.out.println，然后去控制台看看执行到什么地方出的错
      

  2.   

    代码如下:
    <%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.sql.*"%><html><body><%
       String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
       String sConnStr="jdbc:odbc:vote";
       Connection conn=null;
       ResultSet rs=null;
       Statement stm=null;   String content;
       
       content=request.getParameter("content");
      
       String sql="insert into test (content) values('"+content+"')";  
    try
    {
    Class.forName(sDBDriver);
    conn=DriverManager.getConnection(sConnStr,"sa","samf");
    stm=conn.createStatement();
    rs=stm.executeQuery(sql);
    }
    catch(Exception ex)
    {

    out.println(ex.getMessage());
    }

    rs.close();
    stm.close();
    conn.close();
    out.print("successful!");
    %></body></html>
      

  3.   

    你的错误信息是什么？？？还有，你的rs=stm.executeQuery(sql);
    这一句要修改为：rs=stm.executeUpdate(sql);
      

  4.   

    insert语句属于update使用stm.executeUpdate(sql)；它的返回值不能付给结果集类型的rs.
      

  5.   

    to:dooluby(抗日统一联盟：蓝色) 
    这是改为update后的错误:org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: -1 in the jsp file: nullGenerated servlet error:
        [javac] Since fork is true, ignoring compiler setting.
        [javac] Compiling 1 source file
        [javac] Since fork is true, ignoring compiler setting.
        [javac] C:\Tomcat 4.1\work\Standalone\localhost\myweb\sqlinsert_jsp.java:86: incompatible types
        [javac] found   : int
        [javac] required: java.sql.ResultSet
        [javac]  rs=stm.executeUpdate(sql);
        [javac]                                     ^
        [javac] 1 error
      

  6.   

    这是原来的错误信息:
    description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
    at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
    at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
    at java.lang.Thread.run(Thread.java:536)
      

  7.   

    将你的rs=stm.executeQuery(sql);
    修改为：stm.executeUpdate(sql);