【Spring】配置druid连接池并初始化JdbcTemplate

迈不过友情╰ 2021-09-21 02:48 581阅读 0赞

### 文章目录 ###

*   *  导入库和依赖
     *  配置druid.properties配置文件
     *  写一个JDBCUtil工具类
     *  使用

--------------------

## 导入库和依赖 ##

![在这里插入图片描述][20200209170010955.png]

## 配置druid.properties配置文件 ##

此处使用的是mysql-connector-java-8连接器, 因此驱动器路径(driverClassName)与5的不同

driverClassName=com.mysql.cj.jdbc.Driver
    url=jdbc:mysql://localhost:3306/score_management_db?characterEncoding=UTF-8&serverTimezone=UTC
    username=root
    password=123123
    # 初始化连接数量
    initialSize=5
    # 最大连接数
    maxActive=10
    # 最大等待时间
    maxWait=3000
    
    timeBetweenEvictionRunsMillis=60000
    minEvictableIdleTimeMillis=300000
    validationQuery=SELECT 1
    testWhileIdle=true
    testOnBorrow=false
    testOnReturn=false
    poolPreparedStatements=true
    maxPoolPreparedStatementPerConnectionSize=200

## 写一个JDBCUtil工具类 ##

import com.alibaba.druid.pool.DruidDataSourceFactory;
    import java.io.InputStream;
    import java.sql.Connection;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    import java.util.Properties;
    import javax.sql.DataSource;
    
    public class JDBCUtil { 
        private static DataSource ds;
        
        static { 
            Properties prop = new Properties();
            InputStream is = Main.class.getClassLoader().getResourceAsStream("druid.properties");
    
            try { 
                prop.load(is);
                ds = DruidDataSourceFactory.createDataSource(prop);
            } catch (Exception var3) { 
                var3.printStackTrace();
            }
        }
    
        public JDBCUtil() { 
        }
    
        public static Connection getConnection() throws SQLException { 
            return ds.getConnection();
        }
    
        public static void close(Statement stat, Connection conn) { 
            close((ResultSet)null, stat, conn);
        }
    
        public static DataSource getDataSource() { 
            return ds;
        }
    
        public static void close(ResultSet rs, Statement stat, Connection conn) { 
            if (rs != null) { 
                try { 
                    rs.close();
                } catch (SQLException var6) { 
                    var6.printStackTrace();
                }
            }
    
            if (stat != null) { 
                try { 
                    stat.close();
                } catch (SQLException var5) { 
                    var5.printStackTrace();
                }
            }
    
            if (conn != null) { 
                try { 
                    conn.close();
                } catch (SQLException var4) { 
                    var4.printStackTrace();
                }
            }
    
        }
    }

## 使用 ##

JdbcTemplate template = new JdbcTemplate(JDBCUtil.getDataSource());

Q&A 请指正!

[20200209170010955.png]: /images/20210920/d88ea19570fc4630a0046a690ba8ecf0.png