我在JSP中要写入一个5000行的HTML代码到数据库.用Insert into要出错......请问有没有什么好的办法可以解决.......(希望能得到完整的代码.谢谢...)
另要打印"号怎么办?用out.println("""")会出错..

解决方案 »

  1.   

    1 你先给出代码
    2 out.println("\"");
      

  2.   

    另要打印"号怎么办?用out.println("""")会出错..
    str="";
    out.println(str);
      

  3.   

    <td colspan="2"><textarea name="Content" style="display:none"></textarea>
        <iframe ID="eWebEditor1" src="../webedit/index.htm" frameborder="0" scrolling="no" width="468" HEIGHT="350"></iframe>
    </td>这是HTML中的..
      int bigClassId=Integer.parseInt(request.getParameter("bigClassId")); //大类ID
      int smClassId=Integer.parseInt(request.getParameter("select")); //所选小类ID
      String title=request.getParameter("Title");
      String author=request.getParameter("Author");
      String source=request.getParameter("Original");
      String nowDateTime=java.text.DateFormat.getDateTimeInstance().format(new java.util.Date());
      try
      { 
       dataCon.query.addBatch("insert newsdata (Id,bigclassId,smclassId,title,author,source,content,readnumber,datetime) values("+thisId+","+bigClassId+","+smClassId+",'"+title+"','"+author+"','"+source+"','"+request.getParameter("Content")+"',0,'"+nowDateTime+"')");
      

  4.   

    我在JSP中要写入一个5000行的HTML代码到数据库.用Insert into要出错......请问有没有什么好的办法可以解决.......(希望能得到完整的代码.谢谢...)
    试试这种办法
    str="";
    str+="你的5000行代码";//这行可以写多次,直到你的html代码完为止
    insert into tablename(字段) values(str);
      

  5.   

    hawaii_wx(梦见夏威夷) 
    如果在要写入的字符前加入一个空的变量...是什么意思...我不懂咯...这样加入以后.那5000行要写入的代码也没什么变动呀.....起到什么转换作用吗?
      

  6.   

    5000行? 你的content字段多大,是不是超出了. 顺便把出错异常信息贴出来
      

  7.   

    数据库字段是够大的.我设了3G.org.apache.jasper.JasperException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Content")+"',0,
    '"+nowDateTime+"')");   dataCon.query.exec' at line 1
    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.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:595)
    root cause javax.servlet.ServletException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Content")+"',0,
    '"+nowDateTime+"')");   dataCon.query.exec' at line 1
    at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:536)
    at org.apache.jsp.AddNews_submit_jsp._jspService(AddNews_submit_jsp.java:107)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
    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.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:595)--------------------------------------------------------------------------------
    看起来很像是SQL语法错误.但我少插入一些数据就正常的..
      

  8.   

    要写入的代码如下:
    <%@ page contentType="text/html; charset=gb2312" %>
    <%request.setCharacterEncoding("GBK");%>
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <title>后台管理</title>
    <LINK
    href="css/css.css" type=text/css
    rel=STYLESHEET><LINK title=Planet
    href="css/planet.css" type=text/css
    rel=STYLESHEET>
    <style type="text/css">
    <!--
    .style3 {color: #FFFFFF}
    body {
    background-color: #2d345a;
    }
    -->
    </style></head>
    <jsp:useBean id="dataCon" scope="session" class="web.freewebBean" />
    <jsp:setProperty name="dataCon" property="*" />
    <body bgcolor="#ffffff">
    <%dataCon.query=dataCon.con.createStatement();
      int thisId=1; //记录有最大的ID为多少.然后再加1,为当前记录ID;
      dataCon.result=dataCon.query.executeQuery("select max(id)id from newsdata");
      while(dataCon.result.next())
          {thisId=dataCon.result.getInt("id");}
      thisId++;//在最大ID上加1,为当前记录ID;
      int bigClassId=Integer.parseInt(request.getParameter("bigClassId")); //大类ID
      int smClassId=Integer.parseInt(request.getParameter("select")); //所选小类ID
      String title=request.getParameter("Title");
      String author=request.getParameter("Author");
      String source=request.getParameter("Original");
      String nowDateTime=java.text.DateFormat.getDateTimeInstance().format(new java.util.Date());
    /*把当前时间转换为数字如:2005-08-19 01:00:11转换后为:20050819010011
      String tmp="";
      String nowDateTimeNumber="";
      for (int i=0;i<nowDateTime.length();i++)
      {
       tmp=nowDateTime.substring(i,i+1);
       if ((!(tmp.equals(":")))&&(!(tmp.equals("-")))&&(!(tmp.equals(" "))))
        {nowDateTimeNumber=nowDateTimeNumber+tmp;}
      }
    */
       dataCon.query.addBatch("insert newsdata (Id,bigclassId,smclassId,title,author,source,content,readnumber,datetime) values("+thisId+","+bigClassId+","+smClassId+",'"+title+"','"+author+"','"+source+"','"+request.getParameter("Content")+"',0,'"+nowDateTime+"')");
       dataCon.query.executeBatch();
     %>
    <script language=javascript>
     alert("添加信息成功!点击这里返回(可能需要刷新)")
     window.location="AddNews1.jsp"
    </script></body>
    </html>