Question

java连接mysql，连接不上

代码如下
public class ku {

public static void main(String[] args){

String driver = "com.mysql.jdbc.Driver";

String url = "jdbc:mysql://127.0.0.1:3306/hit";

String user = "root";

String password = "root";

try {

Class.forName(driver);

Connection conn = DriverManager.getConnection(url, user, password);

if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");

Statement statement = conn.createStatement();

conn.close();

} catch(ClassNotFoundException e) {

System.out.println("Sorry,can`t find the Driver!");
e.printStackTrace();

} catch(SQLException e) {

e.printStackTrace();

} catch(Exception e) {

e.printStackTrace();

}
}
}

结果如图

求原因

Answer 1

需要添加driver的包到java运行环境

Usage: java [-options] class [args...]
(to execute a class)
or java [-options] -jar jarfile [args...]
(to execute a jar file)

where options include:
-d32 use a 32-bit data model if available

-d64 use a 64-bit data model if available
-server to select the "server" VM
The default VM is server.

-cp <class search path of directories and zip/jar files>

追问

我解决了，是JDK的版本太高了，1.8的不支持jdbc了，不过还是谢啦

Answer 2

不是告诉你了么，没有驱动撒，把驱动JAR导入就好了

追问

导入了之后还是这样

追答

与MYSQL版本不一致

分大小写的检查是不是写错了