druid连接池

druid数据库连接池

1. 配置duiid.properties
   前面的名字必须符合druid命名规则

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/rent
username=root
password=123

2. 工具类

package utils;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import com.mchange.v2.c3p0.ComboPooledDataSource;

import javax.sql.DataSource;
import java.beans.PropertyVetoException;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.lang.reflect.Field;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

public class DruidUtils {

    private  static DataSource dataSource;


    static {
       Properties properties = new Properties();
        try {
            properties.load(new FileInputStream(new File("C:\\Users\\bears\\IdeaProjects\\20210926Spring\\src\\properties\\druid.properties")));
            dataSource = DruidDataSourceFactory.createDataSource(properties);


        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    /*
    * 获取连接
    */
    public  static Connection getConnection() throws SQLException, PropertyVetoException {
        return dataSource.getConnection();
    }
    }

3. test测试

  package test;

import utils.DruidUtils;

import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.SQLException;

public class DruidTest {
    public static void main(String[] args) throws PropertyVetoException, SQLException {
        Connection connection = DruidUtils.getConnection();
        System.out.println(connection);
    }
}