这个mysql连接字符串怎么写？

[chendd2001]

MySQL 3.23.49a-log running on localhost as d278@localhost，这是我在服务器上看到的提示。我得数据库是dbtest, 那么是否url这样写
jdbc:mysql://localhost/dbtest(好像说我无权访问数据源,当然我密码也对的)
还是
jdbc:mysql://d278@localhost/dbtest(从错误反映看好像错了找不到host)
就是d27278@localhost把我搞湖了

[snicker]

import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.DriverManager;

public class TestMysql {

public static void main(String[] args) {
Connection con= null;
Statement stmt = null;
ResultSet rs = null;
String url ="jdbc:mysql://localhost/query?useUnicode=true&characterEncoding=gb2312";
String user="";
String password="";
String queryString = "select code,name from cbm where code <='00000199'";
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con= DriverManager.getConnection(url,user,password);
stmt = con.createStatement();
rs = stmt.executeQuery(queryString);
while(rs.next()){
System.out.println("code:"+rs.getString("code")+" name:"+rs.getString("name"));
}
}catch(SQLException e){
System.out.println(" "+e);
}catch(Exception e){
System.out.println(" "+e);
}finally{
try{
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (con != null) con.close();
}catch(SQLException e){
System.out.println(" error in finally"+e);
}
}
}
}

[snicker]

把你的user,password 添上试试

[snicker]

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

后面的.newInstance()可以不要