我不使用Maven，Spring或Hibernate，只是简单的Web Dynamic应用

Question

加载类com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver。

我正在更新MySQL Server和Workbench，现在我在工作区中的所有应用程序中都丢失了连接。

SQL Server是版本8.0.15。我在所有应用程序中都将其connector8.0.15.jar放置。

Answer 1

导入java.sql.connection;导入java.sql.drivermanager;

公共类DBConnectionManager {

public dbConnectionManager（）{}

private static Connection connection;
public static String driverClass = "com.mysql.jdbc.Driver";
public static String connURL = "jdbc:mysql://localhost:3306/mydb";
private static String user = "root";
private static String password = "root";

public static Connection getConnection() {
    try {
        if(connection == null) {
                Class.forName(driverClass);
            connection = DriverManager.getConnection(connURL, user, password);
        }
    } catch (Exception ex) {
        ex.printStackTrace();
        // TODO: handle exception
    }
    return connection;
} // this is my connectionManager class, i have connector8.0.15.jar

Answer 2

您的连接语句应该看起来像：

public static String connURL = "jdbc:mysql://127.0.0.1:3306/work?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn =(Connection)DriverManager.getConnection(connURL ,"root", "123");

Connurl背后的内容可能因地区而异。