关于mysql驱动问题

macromediahk 2005-06-23 10:06:57

报错如下：

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)

======================================================
在此之前，我已经把mysql的密码清除了，并且在classpath 和tomcat的common\lib 里都添置了最新的JDBC驱动mysql-connector-java-3.1.5-gamma.zip。但是还是错误。不知道为什么，希望大家能帮忙看下~

======================================================
代码如下

<%@ page contentType="text/html" language="java" import="java.sql.*"%>
<html>
<body>
从mysql读出的数据内容<br>
<table border="1">
<tr><td>flexname</td><td>flextime</td><td>flexfuture</td></tr>
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/flex","root","");
Statement stm=con.createStatement();
ResultSet rst=stm.executeQuery("select * from myflex;");
while(rst.next()){
out.print("<tr><td>"+rst.getString(1)+"</td><td>"+rst.getInt(2)+"</td><td>"+rst.getString(3)+"</td></tr>");
}
%>
</table>
</body>
</html>

...全文