jdbc 数据库BasicDataSourceFactory

最新推荐文章于 2024-02-27 21:38:49 发布

原创最新推荐文章于 2024-02-27 21:38:49 发布 · 4k 阅读

2 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

17 篇文章

订阅专栏

本文介绍了一个使用Apache Commons DBCP2实现的数据库连接池工厂类。通过加载配置文件初始化连接池，并演示了如何利用该连接池获取连接、执行SQL查询及处理结果集的基本过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com.www.dbcpFactory;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

import javax.sql.DataSource;

import org.apache.commons.dbcp2.BasicDataSourceFactory;

public class DbcpFactory {

public static Connection conn;

public static void init() throws Exception, IOException{
Properties pps = new Properties();

pps.load(new FileReader("dbcp.properties"));

BasicDataSourceFactory factory = new BasicDataSourceFactory();

DataSource Source = factory.createDataSource(pps);

conn = Source.getConnection();

}

public static void main(String[] args) {

Connection con = conn;

try {
PreparedStatement ps =con.prepareStatement("select * from huhu");

ResultSet rs = ps.executeQuery();

List li = new ArrayList();
while(rs.next()){
String ss = rs.getString("Sname");
int s2 = rs.getInt("Sage");

String result = ss +s2;
li.add(result);
System.out.println();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

}

dbcp.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql:localhost:3306/mytest
user=root
password=root123