mysql problem!

asked 2006-03-26 09:16:51 +0800

admin
18691 ● 1 ● 10 ● 130

Orignial message at:
https://sourceforge.net/forum/message.php?msg_id=3651203

By: nobody

I have include the mysql-connector-java-3.1.12-bin.jar
I wrote the code in the <zscript></zscript> String sDBDriver="org.gjt.mm.mysql.Driver";
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.out.println("Jdbc_conn():"+e.getMessage());
}

Connection
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","1234
5");
Statement stmt = conn.createStatement();
ResultSet res = stmt.executeQuery("select * from foo");

while (res.next())
{
String name = res.getString("name");
System.out.println(name);
}
res.close();

conn.close();

but, when i run it, I got the error:
java.sql.SQLException:No suitable driver[SQL:0,08001]

why? is the driver which i download from apache.com is not suitable for ZK?