jdbc连接问题——com.alibaba.druid.pool.DruidDataSource error

在idea使用数据库连接池druid连接报错为com.alibaba.druid.pool.DruidDataSource error时候可能是mysql的jdbc jar包版本或者druid jar包版本问题造成

druid下载地址：https://repo1.maven.org/maven2/com/alibaba/druid/

mysql官网地址：MySQL :: Download Connector/J

下载最新版本导入lib中即可

druid jar下载及导入：

下载：如图

 

 导入：

复制到lib下

 加入到模块中：选中右键选中add....

 选中Model Library点击ok

 

附上druid相关内容：

druid

（数据库连接池实现技术，由阿里巴巴提供的）
    1. 使用步骤：
        (1).导入jar包 
        (2). 定义配置文件:是properties形式,可以叫任意名称，可以放在任意目录下
        (3). 加载配置文件。Properties
        (4). 获取数据库连接池对象：通过工厂来来获取  DruidDataSourceFactory
        (5). 获取连接：getConnection
          

             //加载配置文件
            Properties pro = new Properties();
            InputStream is = DruidDemo.class.getClassLoader().getResourceAsStream("druid.properties");
            pro.load(is);
            //获取连接池对象
            DataSource ds = DruidDataSourceFactory.createDataSource(pro);
            //获取连接
            Connection conn = ds.getConnection();

    2. 定义工具类
        (1). 定义一个类 JDBCUtils
        (2). 提供静态代码块加载配置文件，初始化连接池对象
        (3). 提供方法
             获取连接方法：通过数据库连接池获取连接
             释放资源
             获取连接池的方法

  
           public class JDBCUtils {

                //1.定义成员变量 DataSource
                private static DataSource ds ;
            
                static{
                    try {
                        //1.加载配置文件
                        Properties pro = new Properties();
                        pro.load(JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties"));
                        //2.获取DataSource
                        ds = DruidDataSourceFactory.createDataSource(pro);
                    } catch (IOException e) {
                        e.printStackTrace();
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }
            
                /**
                 * 获取连接
                 */
                public static Connection getConnection() throws SQLException {
                    return ds.getConnection();
                }
            
                /**
                 * 释放资源
                 */
                public static void close(Statement stmt,Connection conn){
                   /* if(stmt != null){
                        try {
                            stmt.close();
                        } catch (SQLException e) {
                            e.printStackTrace();
                        }
                    }
            
                    if(conn != null){
                        try {
                            conn.close();//归还连接
                        } catch (SQLException e) {
                            e.printStackTrace();
                        }
                    }*/
            
                   close(null,stmt,conn);
                }
            
            
                public static void close(ResultSet rs , Statement stmt, Connection conn){
            
            
                    if(rs != null){
                        try {
                            rs.close();
                        } catch (SQLException e) {
                            e.printStackTrace();
                        }
                    }
            
            
                    if(stmt != null){
                        try {
                            stmt.close();
                        } catch (SQLException e) {
                            e.printStackTrace();
                        }
                    }
            
                    if(conn != null){
                        try {
                            conn.close();//归还连接
                        } catch (SQLException e) {
                            e.printStackTrace();
                        }
                    }
                }
            
                /**
                 * 获取连接池方法
                 */
            
                public static DataSource getDataSource(){
                    return  ds;
                }
            
            }