错误信息:org.apache.jasper.compiler.ParseException: /article/postsave.jsp(1,17) Attribute value should be quoted上面提示你在第一行第17个字段错误。Attribute 的值需要先加载才可以用,可能你的conn.jsp里面用到了getAttribute(),但在先前你没有给他赋值
调试欢乐多
<%@ include file=conn.jsp%>
<%@ import="java.util.*"%>
<html>
<body>
<%
int hits=0;
String classStr="";
String articleNameStr="";
String authorStr="";
String fromUrlStr="";
String contentStr="";
String tempStr=""; tempStr=request.getParameter("postClass");
if(tempStr!=null && !tempSTR.equals(""))
classStr=tempStr;
else
classStr=null;
tempStr=request.getParameter("postArticleName");
if(tempStr!=null && !tempStr.equals(""))
articleNameStr=tempStr;
else
articleNameStr=null;
tempStr=request.getParameter("postAuthor");
if(tempStr!=null && !tempStr.equals("")&&tempStr.length()<400&&tempStr.length()>4000)
authorStr=tempStr;
else
authorStr=null;
tempStr=request.getParameter("postContent");
if(tempStr!=null && !tempStr.equals(""))
contentStr=tempStr;
else
contentStr=null;
fromUrlStr=request.getParameter("postFromUrl");
Data addTime=new Date();
String sql="insert into Article values('','articleNameStr','classStr','authorStr','contentStr','fromUrlStr',date_format(addTime,'%y-%m-%d') as addtime,hits)";
if(classStr!=null&&articleNameStr!=null&&authorStr!=null&&contentStr!=null)
stmt.executeUpdate(sql);
else
out.println("请您仔细检查你应该填写的项目!");
%>
<%stmt.close();
conn.close();
%>
</body>
</html>
还是不行<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file=conn.jsp%>
<%@ import="java.util.*"%>
<html>
<body>
<%
int hits=0;
String classStr="";
String articleNameStr="";
String authorStr="";
String fromUrlStr="";
String contentStr="";
String tempStr=""; tempStr=request.getParameter("postClass");
if(tempStr!=null && !tempSTR.equals(""))
classStr=tempStr;
else
classStr=null;
tempStr=request.getParameter("postArticleName");
if(tempStr!=null && !tempStr.equals(""))
articleNameStr=tempStr;
else
articleNameStr=null;
tempStr=request.getParameter("postAuthor");
if(tempStr!=null && !tempStr.equals("")&&tempStr.length()<400&&tempStr.length()>4000)
authorStr=tempStr;
else
authorStr=null;
tempStr=request.getParameter("postContent");
if(tempStr!=null && !tempStr.equals(""))
contentStr=tempStr;
else
contentStr=null;
fromUrlStr=request.getParameter("postFromUrl");
java.sql.Date addTime = new java.sql.Date( (new Date()).getTime() );
String sql="insert into Article values('','articleNameStr','classStr','authorStr','contentStr','fromUrlStr','addTime',hits)";
if(classStr!=null&&articleNameStr!=null&&authorStr!=null&&contentStr!=null)
stmt.executeUpdate(sql);
else
out.println("请您仔细检查你应该填写的项目!");
%>
<%stmt.close();
conn.close();
sql.close();
%>
</body>
</html>//conn.jsp
<%@ page import="java.sql.*"%>
<%
String dburl = "jdbc:mysql://localhost:3306/bookdata";
Connection conn = null;
Statement stmt = null;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
conn = DriverManager.getConnection(dburl, "book", "book");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
%>
String sql="insert into Article values('','"+articleNameStr+"','"+classStr+"','"+authorStr+"','"+contentStr+"','"+fromUrlStr+"',"+date_format(addTime,'%y-%m-%d')+" as addtime,hits)";
exception stack trace贴出来
String sql="insert into Article values('','articleNameStr','classStr','authorStr','contentStr','fromUrlStr','addTime',"+hits+")";hits左右两边改过了,仔细看一下
我这是取post.jsp表单里面的数据,然后写入数据库
谢谢你先
org.apache.jasper.compiler.ParseException: /article/postsave.jsp(1,17) Attribute value should be quoted
at org.apache.jasper.compiler.JspReader.parseToken(JspReader.java:522)
at org.apache.jasper.compiler.JspReader.parseAttributeValue(JspReader.java:568)
at org.apache.jasper.compiler.JspReader.parseTagAttributes(JspReader.java:681)
at org.apache.jasper.compiler.Parser$Directive.accept(Parser.java:224)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1145)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1103)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1099)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:213)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:210)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:552)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:177)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:189)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
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:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:479)
改成
<%@ include file="conn.jsp"%>
D:\server\Tomcat\work\localhost\web\article\postsave$jsp.java:111: Ambiguous class: java.sql.Date and java.util.Date
java.sql.Date addTime = new java.sql.Date( (new Date()).getTime() );
^
1 error
java.sql.Date addTime = new java.sql.Date();
java.sql.Date addTime = new java.sql.Date();
^
1 error
java.sql.Date addTime = new java.sql.Date( (new java.uitl.Date()).getTime() );
但是怎么会这样:不管post.jsp提供的什么总是输出:请您仔细检查你应该填写的项目! 也就是说:if(classStr!=null&&articleNameStr!=null&&authorStr!=null&&contentStr!=null)
这一句的判断总是通不过
但是怎么会这样:不管post.jsp提供的什么总是输出:请您仔细检查你应该填写的项目! 也就是说:if(classStr!=null&&articleNameStr!=null&&authorStr!=null&&contentStr!=null)
这一句的判断总是通不过