代码如下:importjava.util.*;importjava.io.*;importjava.sql.*;publicclassTest{Connectioncon;publicConnectiongetConnection(){try{Class.forName("com.mysql.jdbc.Driver");}cat...
代码如下:
import java.util.*;
import java.io.*;
import java.sql.*;
public class Test {
Connection con;
public Connection getConnection() {
try {
Class.forName("com.mysql.jdbc.Driver");
}
catch (ClassNotFoundException e) {
System.out.println("加载数据库驱动程序失败!");
e.printStackTrace();
}
try {
con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/myagenda","user","123456");
}
catch(SQLException e) {
System.out.println("获取数据库连接失败!");
e.printStackTrace();
}
return con;
}
public static void main(String[] args) {
Test t=new Test();
t.getConnection();
}
}
系统报错:
获取数据库连接失败!
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
...
at myjava/com.test.Test.getConnection(Test.java:17)
我分析有几种可能:
1.数据库地址:但无论是放在C:\,D:\,project主目录, project src目录,都不行;
2.文件名:原名是myagenda.db,但无论加不加扩展名,都报错;
3.文件格式:文件是用SQLite创建的,不知道是否与MYSQL不兼容;
4.用户名和密码,数据库本身无密码,用户名我试了user, root,密码试了123456, password, windows用户密码,都不行。
请高手给一个肯定成功的例子,比如范例数据库,存放地址,密码和口令,以帮助理解,谢谢。
展开