我正在尝试通过我的应用程序将数据插入到Google Cloud mysql数据库中,该应用程序是通过eclipse.Here在java上构建的,代码如下:
package com.example.dao;
import java.sql.Connection;
import java.sql.DriverManager;
public class dao {
private static Connection con;
public static Connection getcon(){
try{
String instanceConnectionName = "edu-vitae1";
String databaseName = "eduvitae";
String username = "root";
String password = "edu";
String jdbcUrl = String.format(
"jdbc:mysql://google/eduvitae?cloudSqlInstance=edu-vitae1&socketFactory=com.google.cloud.sql.mysql.SocketFactory&user=root&password=root&useSSL=false",
databaseName,
instanceConnectionName);
Connection con = DriverManager.getConnection(jdbcUrl, username, password);
Class.forName("com.mysql.jdbc.GoogleDriver");
//con=DriverManager.getConnection("jdbc:google:mysql://edu-vitae1>/edu-vitae?user=root&password=root");
}
catch (Exception e) {
System.out.println(e);
}
return con;
}
}
在部署项目之后,我得到了这个错误:
找不到适用于jdbc:mysql://google/eduvitae?cloudSqlInstance=edu-vitae1&socketFactory=com.google.cloud.sql.mysql.SocketFactory&user=root&password=root&useSSL=false的
java.sql.SQLException驱动程序
有人能帮我解决这个问题吗?提前感谢你
发布于 2018-07-31 07:53:52
3天后,我在我的code.Notice中发现了一个愚蠢的错误,在我的代码中,我首先建立了连接,然后使用Class.forName (“com.mysql.jdbc.GoogleDriver”)加载了驱动程序;这是incorrect.You应该首先使用Class.forName加载驱动程序,然后使用DriverManager.getConnection.Please建立连接。不要犯我在这个愚蠢的错误上浪费了3天的愚蠢的错误。我将下面的正确代码张贴出来供你参考:
package com.example.dao;
import java.sql.Connection;
import java.sql.DriverManager;
public class dao {
private static Connection con;
public static Connection getcon(){
try{
String instanceConnectionName = "edu-vitae1";
String databaseName = "eduvitae";
String username = "root";
String password = "root";
Class.forName("com.mysql.jdbc.Driver");
String jdbcUrl = String.format(
"jdbc:mysql://google/eduvitae?cloudSqlInstance=edu-vitae1&socketFactory=com.google.cloud.sql.mysql.SocketFactory&user=root&password=root&useSSL=false",
databaseName,
instanceConnectionName);
Connection con = DriverManager.getConnection(jdbcUrl, username, password);
//con=DriverManager.getConnection("jdbc:mysql://35.200.134.221/edu","root","root");
}
catch (Exception e) {
System.out.println(e);
}
return con;
}
}
https://stackoverflow.com/questions/51581316
复制相似问题