展开全部
根据32313133353236313431303231363533e59b9ee7ad9431333365646332你的需求,我贴出在普通Java 项目中,很单纯的使用 C3P0 连接池的方式。不使用 Spring , 不使用 Tomcat JNDI 数据源。就是很普通的Java项目使用它的方式:package com.malhui.zhidao.example;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class DBPool {
private static DBPool instance;
private ComboPooledDataSource dataSource;
static{
instance = new DBPool();
}
private DBPool() {
try {
dataSource = new ComboPooledDataSource();
Properties prop = new Properties();
InputStream in = DBPool.class.getClassLoader().getResourceAsStream("db.properties");
prop.load(in);
dataSource.setDriverClass(prop.getProperty("driverClass"));
dataSource.setJdbcUrl(prop.getProperty("url"));
dataSource.setUser(prop.getProperty("username"));
dataSource.setPassword(prop.getProperty("password"));
} catch (Exception e) {
e.printStackTrace();
}
}
public static DBPool getInstance(){
return instance;
}
public Connection getConnection() throws SQLException {
return dataSource.getConnection();
}
public static void main(String[] args) throws SQLException {
// 1.获取JDBC 数据库连接
Connection conn = DBPool.getInstance().getConnection();
// 2.使用 conn 连接操作数据库 做你所想
}
}
代码都是本人手工敲出来的,希望对你有帮助。满意希望采纳喔 !