// 聲明為一個 Spring Boot 控制器
@RestController
public class DatabaseController {

    // POST請求映射到/test-database-connection路徑
    @PostMapping("/test-database-connection")
    public String testDatabaseConnection(@RequestBody DatabaseConfig config) {
        try {
            // 創(chuàng)建數(shù)據(jù)源
            DataSource dataSource = createDataSource(config);
            // 使用JdbcTemplate執(zhí)行SQL語句
            JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
            jdbcTemplate.execute("SELECT 1");
            // 如果連接成功，返回"ok"
            return "ok";
        } catch (Exception e) {
            // 如果發(fā)生異常，打印異常信息并返回"error"
            e.printStackTrace();
            return "error";
        }
    }

    // 創(chuàng)建數(shù)據(jù)源
    private DataSource createDataSource(DatabaseConfig config) {
        // 使用DriverManagerDataSource創(chuàng)建數(shù)據(jù)源
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        // 設置數(shù)據(jù)源的驅動類名、URL、用戶名和密碼
        dataSource.setDriverClassName(config.getDriverClassName());
        dataSource.setUrl(config.getUrl());
        dataSource.setUsername(config.getUsername());
        dataSource.setPassword(config.getPassword());
        return dataSource;
    }
}

package com.example.test111;

public class DatabaseConfig {
    private String driverClassName;
    private String url;
    private String username;
    private String password;

    // 構造函數(shù)、getter和setter方法

    public DatabaseConfig() {
    }

    public DatabaseConfig(String driverClassName, String url, String username, String password) {
        this.driverClassName = driverClassName;
        this.url = url;
        this.username = username;
        this.password = password;
    }

    public String getDriverClassName() {
        return driverClassName;
    }

    public void setDriverClassName(String driverClassName) {
        this.driverClassName = driverClassName;
    }

    public String getUrl() {
        return url;
    }

    public void setUrl(String url) {
        this.url = url;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

mysql -u root -p

use mysql;

update user set host = '%' where user = 'root';

flush privileges; 

select host,user from user;