jsp连mysql问题！！！！！！！！！

[hx054321]

小弟第一次用jsp连接mysql数据库，都连了快一个礼拜了还是连不上啊，上死火了。请大哥哥或大姐姐们给个指点好吗。
我很笨的，希望能从头教起。 拜托了，如果连上了请吃糖葫芦！！！！！

[zjntche_cn]

JSP文件内容如下：

<%@ page contentType="text/html; charset=gb2312" %>

<%@ page language="java" %>

<%@ page import="java.sql.*" %>

<%
Connection cConnection;
Statement sStatement;
ResultSet rQueryResult;
ResultSetMetaData rResultSetMetaData;
String sSQL = "select user, password from user";
int iColumnCount;

cConnection = null;
sStatement = null;
rQueryResult = null;

try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
cConnection = DriverManager.getConnection("jdbc:mysql://localhost/mysql?username=root&password=null&useUnicode=true&characterEncoding=gb2312");

try {
sStatement = cConnection.createStatement();

try {
rQueryResult = sStatement.executeQuery(sSQL);

try {
rResultSetMetaData = rQueryResult.getMetaData();
try {
iColumnCount = rResultSetMetaData.getColumnCount();

out.print("<table border=1 bordercolor=black align='center' width='500'>");
out.print("<tr>");
out.print("<td>" + "user" + "</td>");
out.print("<td>" + "password" + "</td>");
out.print("</tr>");
while(rQueryResult.next()) {
out.print("<tr>");
out.print("<td>" + rQueryResult.getString(1) + "</td>");
out.print("<td>" + rQueryResult.getString(2) + "</td>");
out.print("</tr>");
}
out.print("</table>");
out.print("<br>");
out.print("数据库操作成功，恭喜你");
} catch (SQLException e) {
System.err.println("rResultSetMetaData.getColumnCount():" + e.getMessage());
}
} catch (SQLException e) {
System.err.println("rQueryResult.getMetaData():" + e.getMessage());
}
} catch (SQLException e) {
System.err.println("sStatement.executeQuery(sSQL):" + e.getMessage());
} finally {
try {
if (rQueryResult != null)
rQueryResult.close();
} catch (SQLException e) {
e.printStackTrace();
}
rQueryResult = null;
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (sStatement != null)
sStatement.close();
} catch(SQLException e) {
e.printStackTrace();
}
sStatement = null;
}
} catch(SQLException e) {
e.printStackTrace();
} finally {
try {
if (cConnection != null)
cConnection.close();
} catch(SQLException e) {
e.printStackTrace();
}
cConnection = null;
}
%>

[terry3411]

如果你的密码为空（即没有密码），试一下把：
cConnection = DriverManager.getConnection("jdbc:mysql://localhost/mysql?username=root&password=null&useUnicode=true&characterEncoding=gb2312");
改成：
cConnection = DriverManager.getConnection("jdbc:mysql://localhost/mysql?username=root&useUnicode=true&characterEncoding=gb2312");

即把“&password=null”这选项去掉

[lxfa]

你用的MySQL驱动是多少版本的?
你的MySQL的版本是多少呀?