注册 登录
编程论坛 → J2EE论坛

[求助] jsp + mysql 的问题

aneylinwuhui 发布于 2007-06-07 11:01， 1559 次点击

我的原码是:

<%@ 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


都做了好几天了 还没有弄好 希望有能者能救救我

在线等 谢谢了!

13 回复
#2
黄袖标2007-06-07 11:06
connection ?


conn ??
#3
aneylinwuhui2007-06-07 11:15
能不能在说的清楚一点啊!我是刚学的

应该怎么改才好啊!
#4
黄袖标2007-06-07 11:17

把你的conn都改成connection

我上边说的还不清楚...

[此贴子已经被作者于2007-6-7 11:18:04编辑过]
#5
farain2007-06-07 11:17
你没给数据库连接做异常处理,这样没法正常通过编译.
#6
aneylinwuhui2007-06-07 11:18
谢谢了!我在去试试!
#7
aneylinwuhui2007-06-07 11:45
如何给我的数据库连接做异常处理

能不能给个例子 给我看看啊!
真是不好意思啊!我是刚学的!

先感谢了!
#8
支离破碎2007-06-07 11:53
用try..catch来处理异常。
#9
可可℃乐2007-06-07 13:17
变量没有定义。检查程序中的变量是否声明或者调用错了..
#10
guoxhvip2007-06-09 00:11

LZ好象用的是纯java驱动方式连接数据库 可能很多 比如SQLSERVERSP4补丁，如果你是用JBuilder写要添加驱动，就算你捕获了异常一样会把异常错误给你打印出来
#11
寂寞天涯人2007-06-09 14:30

Connection connection=DriverManager.getConnection(url);


Statement Statement=conn.createStatement();
conn.close();

上面用connection
下面却用conn肯定错了啊
Statement Statement=connection.createStatement();
connection.close();
#12
ming2062007-06-09 16:05

try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection(url);

catch(ClassNotFoundException ce){
out.print("异常：驱动连接错误");
}
//
try{
Statement st=conn.createStatement();
st.executeUpdate("INSERT into wode(numble,name,xing)values('numble','name')");
out.println("记录插入完毕!");
}
catch((SQLException sqle){
out.print("异常："+sqle);
}
finally{
try{
if(st!=null) st.close();
if(conn!=null) conn.close();
}catch(Exception e){
out.print("异常："+e);
}
}
#13
sailyyang2007-06-12 16:44

你的 jsp文件编译错误。


Statement.executeUpdate(\"INSERT into wode(numble,name,xing)\" + \"values(\'numble\',\'name\')\");


out.println(\"记录插入完毕!\");
Statement.close();
conn.close();

你不觉得你的 "\"有点特别吗 。。都注释掉 代码了。。jsp没有 > 包括。。当然编译错误
#14
无缘今生2007-08-05 14:03
只一个“\”应该不是注释吧？
1
©2025, BC-CN.NET
电脑版