一周都没搞定jsp连接MySQL的大问题!

[weixin_38049770]

Resin3.0.19

代码是:

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>
<%
  String driverName="com.mysql.jdbc.Driver";
  String userName="root";
  String userPasswd="root123";
  String dbName="bbs";
  String tableName="";
  String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
  Class.forName("com.mysql.jdbc.Driver".newInstance();
  Connection connection=DriverManager.getConnection(url);
  Statement statement = connection.createStatement();
  String sql="SELECT * FROM "+tableName;
  ResultSet rs = statement.executeQuery(sql);
   ResultSetMetaData rmeta = rs.getMetaData();
   int numColumns=rmeta.getColumnCount();
out.print("id"
out.print("|"
out.print("num"
out.print("<br>"
while(rs.next()) {
out.print(rs.getString(1)+" "
out.print("|"
out.print(rs.getString(2));
out.print("<br>"
}
out.print("<br>"
out.print("..........."



提示:
500 Servlet Exception
com.mysql.jdbc.CommunicationsException: Communications link failure due
to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.SocketException: Permission denied

STACKTRACE:

java.net.SocketException: java.net.SocketException: Permission denied
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:193)
        at _jsp._test_0mysql__jsp._jspService(_test_0mysql__jsp.java:39)
        at com.caucho.jsp.JavaPage.service(JavaPage.java:60)
        at com.caucho.jsp.Page.pageservice(Page.java:570)
        at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:175)
        at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:17
        at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
        at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:419)
        at com.caucho.server.port.TcpConnection.run(TcpConnection.java:389)
        at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:507)
        at com.caucho.util.ThreadPool.run(ThreadPool.java:433)
        at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2707)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:193)
        at _jsp._test_0mysql__jsp._jspService(test_mysql.jsp:13)
        at com.caucho.jsp.JavaPage.service(JavaPage.java:60)
        at com.caucho.jsp.Page.pageservice(Page.java:570)
        at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:175)
        at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:17
        at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
        at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:419)
        at com.caucho.server.port.TcpConnection.run(TcpConnection.java:389)
        at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:507)
        at com.caucho.util.ThreadPool.run(ThreadPool.java:433)
        at java.lang.Thread.run(Thread.java:595)


--------------------------------------------------------------------------------
Resin-3.0.19 (built Mon, 15 May 2006 04:50:47 PDT)


换个N个驱动也不行!
现在用!mysql-connector-java-3.1.12-bin