数据库连接池-Druid的使用
package druid;/*
*druid 数据连接池
- */
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.io.FileInputStream;
import java.io.FileReader;
import java.sql.Connection;
import java.util.Properties;public class DruidDemo {
public static void main(String[] args) throws Exception {
//1. 导入 jar 包</span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">2.定义配置文件 </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">3.加载配置文件</span> Properties prop = <span style="color: rgba(0, 0, 255, 1)">new</span><span style="color: rgba(0, 0, 0, 1)"> Properties(); </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">获取数据库的位置信息,加载数据库</span> prop.load(<span style="color: rgba(0, 0, 255, 1)">new</span> FileInputStream("F:\\Develop\\code\\Demo2\\src\\druid.txt"<span style="color: rgba(0, 0, 0, 1)">)); </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">4.获取连接池对象</span> DataSource dataSource =<span style="color: rgba(0, 0, 0, 1)"> DruidDataSourceFactory.createDataSource(prop); </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">5.获取数据库连接Connection</span> Connection connection =<span style="color: rgba(0, 0, 0, 1)"> dataSource.getConnection(); System.out.println(connection); }
}