急!!!jsp联接mysql数据还是出问题各位来帮帮忙,要不我要被炒了!救救我!!!!!
jsp代码:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/exc?user=root&useUnicode=true&characterEncoding=gb2312";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from datum";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
%>
第一个字段内容为:<font color=blue>
<%=rs.getString("id")%></font>
第二个字段内容为:<font color=blue>
<%=rs.getString("name")%></font>
第三个字段内容为:<font color=blue>
<%=rs.getString("age")%></font><br>
<%
}
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
jdk安装目录:d:\java\j2sdk1.4.2
tomcat5.0安装目录:d:\tomcat 5.0
环境变量(系统变量)配置如下:
CLASSPATH :
.;d:\java\j2sdk1.4.2.\lib\tools.jar;d:\java\j2sdk1.4.2.lid\dt.jar;d:\java\j2sdk1.4.2.\bin;d:\Tomcat 5.0\lib;d:\Tomcat 5.0\common\lib\mm.mysql-2.0.14-bin.jar;
JAVA_HOME :
d:\java\j2sdk1.4.2;
path :
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;D:\Program Files\Symantec\pcAnywhere\;"C:\Program Files\Common Files\!Sunv\TransEngine";d:\java\j2sdk1.4.2\bin;
Tomcat_home :
d:\Tomcat 5.0;
tomact5.0 server已经启用。
mysql4.1.7 winmysqladmin.exe 也已经启用,可能看到exc 数据库的表datum 的字段。
将以上的jsp代码放入以下目录:
d:\Tomcat 5.0\webapps\ROOT
文件名为:TestMysql.jsp
在IE中输入:http://localhost:8080/TestMysql.jsp
IE中的错误为:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description
The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException)
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.TestMysql_jsp._jspService(TestMysql_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause
java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException)
org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
org.gjt.mm.mysql.Driver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:193)
org.apache.jsp.TestMysql_jsp._jspService(TestMysql_jsp.java:45)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.0.16
请大家一定要救救我:
e-mail:chensjmail@163.com
一定有回报!!!!!!!!!!!!!!!!!!!!!