JSP报错,知道错的地方,却不知道为什么那个地方会出错,有出错信息
cds1 2006-04-19 02:29:44 jsp原码如下:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.lang.Math.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:useBean id="newsconn" scope="page" class="news.newsconn"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style1 {font-size: x-large}
.style2 {font-size: large}
-->
</style>
</head>
<body>
<%
ResultSet rs=newsconn.executeQuery("select max(id) as maxid from news");
rs.next();
String max_id=rs.getString("maxid")+1;
rs.close();
String title=request.getParameter("tf1");
String author=request.getParameter("tf2");
String content=request.getParameter("ta");
/*String sql="insert into news values('"+max_id+"',";
sql+="'"request.getParameter("tf1")+"','"+request.getParameter("tf2")+"',";
sql+="date(),'"+request.getParameter("ta")+"')";*/
String sql="insert into news values('"+max_id+"',";
sql+="'"title+"','"+author+"',";
sql+="date(),'"+content+"')";
newsconn.executeQuery(sql);
out.println("<hr>");
out.println("<h2>添加新闻成功!</h2>");
out.println("<hr>");
%>
<p class="style1">请输入要添加新闻的详细信息!
</p>
<hr>
<form name="form1" method="post" action="newsadd.jsp">
<p align="center">标 题:
<input name="tf1" type="text" size="90">
</p>
<p align="center"> 内 容:
<textarea name="ta" cols="80" rows="15"></textarea>
</p>
<!--<p align="center">关键字:
<input name="tf2" type="text" size="25">-->
<p align="center">
作者:
<input name="tf2" type="text" size="25">
</p>
<p align="center">
<input type="submit" name="submit" value="确定">
<input type="reset" name="reset" value="清除">
</p>
</form>
<p align="center"><a href="newsedit.jsp">编辑新闻</a> <a href="default.jsp">查看新闻</a></p>
</body>
</html>
在浏览器中执行后的错误如下:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 40 in the jsp file: /news/newsadd.jsp
Generated servlet error:
Syntax error on token "title", delete this token
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 40 in the jsp file: /news/newsadd.jsp
Generated servlet error:
Syntax error on token "title", delete this token
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:409)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:297)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:276)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:264)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:563)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:303)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.15 logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.5.15
看了很久,真的看不出title错在哪里,麻烦高手指点迷津
另外,想问下要把当前系统时间写进数据库要用什么函数