我的原码是:
<%@ page contentType="text/html; charset=Shift_JIS" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>
<%
//驱动程序名
String driverName="com.mysql.jdbc.Driver";
//数据库用户名
String userName="root";
//密码
String userPasswd="wuhui";
//数据库名
String dbName="hokenn";
//表名
String tableName="wode";
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection=DriverManager.getConnection(url);
Statement Statement=conn.createStatement();
Statement.executeUpdate(\"INSERT into wode(numble,name,xing)\" + \"values(\'numble\',\'name\')\");
out.println(\"记录插入完毕!\");
Statement.close();
conn.close();
%>
可是运行就出现以下错误:
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: 9 in the jsp file: /t.jsp
Generated servlet error:
conn cannot be resolved
An error occurred at line: 9 in the jsp file: /t.jsp
Generated servlet error:
statement cannot be resolved
An error occurred at line: 9 in the jsp file: /t.jsp
Generated servlet error:
Stmt cannot be resolved
An error occurred at line: 9 in the jsp file: /t.jsp
Generated servlet error:
conn cannot be resolved
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
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: 9 in the jsp file: /t.jsp
Generated servlet error:
conn cannot be resolved
An error occurred at line: 9 in the jsp file: /t.jsp
Generated servlet error:
statement cannot be resolved
An error occurred at line: 9 in the jsp file: /t.jsp
Generated servlet error:
Stmt cannot be resolved
An error occurred at line: 9 in the jsp file: /t.jsp
Generated servlet error:
conn cannot be resolved
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:414)
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:305)
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.20 logs.
Apache Tomcat/5.5.20
都做了好几天了 还没有弄好 希望有能者能救救我
在线等 谢谢了!
----------------解决方案--------------------------------------------------------
connection ?
conn ??
----------------解决方案--------------------------------------------------------
能不能在说的清楚一点啊!我是刚学的
应该怎么改才好啊!
----------------解决方案--------------------------------------------------------
把你的conn都改成connection
我上边说的还不清楚...[此贴子已经被作者于2007-6-7 11:18:04编辑过]
----------------解决方案--------------------------------------------------------
你没给数据库连接做异常处理,这样没法正常通过编译.
----------------解决方案--------------------------------------------------------
谢谢了!我在去试试!
----------------解决方案--------------------------------------------------------
如何给我的数据库连接做异常处理
能不能给个例子 给我看看啊!
真是不好意思啊!我是刚学的!
先感谢了!
----------------解决方案--------------------------------------------------------
用try..catch来处理异常。
----------------解决方案--------------------------------------------------------
变量没有定义。检查程序中的变量是否声明或者调用错了..
----------------解决方案--------------------------------------------------------
LZ好象用的是纯java驱动方式连接数据库 可能很多 比如SQLSERVERSP4补丁，如果你是用JBuilder写要添加驱动，就算你捕获了异常一样会把异常错误给你打印出来
----------------解决方案--------------------------------------------------------