eclipse mysql数据库

来源:百度知道 编辑:UC知道 时间:2024/05/23 11:38:20
源程序如下:

public class Database {
public static void main(String[] arg)
{
String url="jdbc:mysql://localhost/mysqldb?user=root,password=123456";

String driver="com.mysql.jdbc.Driver";
String sql="select * from vertex";
Connection conn=null;

try{

Class.forName(driver);
conn=DriverManager.getConnection(url);
}catch(Exception e){
e.printStackTrace();

try{
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
System.out.print("ID");
System.out.print(rs.getInt("id"));
System.out.print("PX:");
System.out.print(rs.getInt("px"));

}
rs.close();
stmt.close();
conn.close();

}
catch(Exception ex){
ex.printStackTrace();
}
}
}
}

问题如下:

url试试改成:
jdbc:mysql://localhost:3306/mysqldb?user=root&password=123456
你端口号没写...
如果还是有问题,就把user和password去掉
改为
Class.forName(url,"root","123456") ;