下面是程序
<%@ page contentType="text/html; charset=gbk" %>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<html>
<head>
<title>
插入数据
</title>
</head>
<body>
<%
String declareid=request.getParameter("declareid");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:zk"); //建立数据库连接
String str="UPDATE declare
set check='yes'
where declareid='"+declareid+"'";
Statement smt=con.createStatement();
smt.executeUpdate(str);
smt.close();
con.close();
out.print("设备申报已经成功审批");
%>
</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: 11 in the jsp file: /device/zk/check.jsp
Generated servlet error:
G:\Tomcat 5.0\work\Catalina\localhost\newapp\org\apache\jsp\device\zk\check_jsp.java:58: unclosed string literal
String str="UPDATE declare
^
An error occurred at line: 11 in the jsp file: /device/zk/check.jsp
Generated servlet error:
G:\Tomcat 5.0\work\Catalina\localhost\newapp\org\apache\jsp\device\zk\check_jsp.java:59: unclosed character literal
set check='yes'
^
An error occurred at line: 11 in the jsp file: /device/zk/check.jsp
Generated servlet error:
G:\Tomcat 5.0\work\Catalina\localhost\newapp\org\apache\jsp\device\zk\check_jsp.java:59: illegal line end in character literal
set check='yes'
^
An error occurred at line: 11 in the jsp file: /device/zk/check.jsp
Generated servlet error:
G:\Tomcat 5.0\work\Catalina\localhost\newapp\org\apache\jsp\device\zk\check_jsp.java:60: unclosed character literal
where declareid='"+declareid+"'";
^
4 errors
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.0.28
[返回] 中文XML论坛 - 专业的XML技术讨论区 →
计算机技术与应用 → 『 Java/Eclipse 』 → JSP高手进 请问这个程序的UPDATE语句 怎么报错
(订阅本版)
2006/5/17 9:13:00
新浪微博
JSP高手进 请问这个程序的UPDATE语句 怎么报错
