DataSourceDemo数据库连接池

package Day30DBUtils;

import org.apache.commons.dbcp.BasicDataSource;

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

/**
 * @Author quzheng
 * @Date 2019/10/4 22:51
 * @Version 1.0
 */
public class DataSourceDemo {
    public static void main(String[] args) throws SQLException {
        //创建DataSource接口的实现类对象
        BasicDataSource dataSource = new BasicDataSource();

        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://192.168.8.14:3306/day22_JDBC");
        dataSource.setUsername("root");
        dataSource.setPassword("123456");

        try{
            //调用对象方法 getConnection获取数据库的连接
            Connection con = dataSource.getConnection();
            System.out.println(con);
        }catch (SQLException ex){
            ex.printStackTrace();
            throw new RuntimeException("数据库连接失败");
        }



    }
}