对数据源进行操作

方法一：getDruidDataSourceeList：获取数据源

方法二：getLocalDataSource：获取本地数据源

方法三：getTestConectById：判断连接数据源是否成功

1.Util层

package com.sjzl.util;

import com.alibaba.druid.pool.DruidDataSource;
import com.sjzl.entity.DataSourceManage;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * @Description:
 * @Author: ss
 * @Date: 2023/3/13 14:18
 */

public class ConnectDataUtil {


    /**
     * @Description:获取数据源
     * @Author: ss
     * @Date: 2023/3/13 14:38
     * @param dataSourceManage:
     * @return: com.alibaba.druid.pool.DruidDataSource
     **/
    public DruidDataSource getDruidDataSourceeList(DataSourceManage dataSourceManage) {
        // 创建 DruidDataSource 实例
        DruidDataSource dataSource = new DruidDataSource();

        try{
            // 配置数据库连接参数
            //数据库连接url
            String url = "";
            //数据库驱动
            String driver = "";

            switch (dataSourceManage.getDatabaseTypeName()){
                case "MariaDB":
                    url = "jdbc:mariadb://"+dataSourceManage.getHostAddress()+":"+dataSourceManage.getPortNumber()+"/"+dataSourceManage.getDatabaseName();
                    driver = "org.mariadb.jdbc.Driver";
                    break;
                case "Oracle":
                    url = "jdbc:oracle:thin:@"+dataSourceManage.getHostAddress()+":"+dataSourceManage.getPortNumber()+":"+dataSourceManage.getDatabaseName();
                    driver = "oracle.jdbc.driver.OracleDriver";
                    break;
                case "MySql":
                    url = "jdbc:mysql://"+dataSourceManage.getHostAddress()+":"+dataSourceManage.getPortNumber()+"/"+dataSourceManage.getDatabaseName();
                    driver = "com.mysql.cj.jdbc.Driver";