1. About java利用jdbc直接连接数据库,经常取得连接,用完释放,很浪费系统资源2. Code Java代码package com.cdv.mam.db;import java.sql.Connection;import java.sql ...
1. About
java利用jdbc直接连接数据库,经常取得连接,用完释放,很浪费系统资源
2. Code
Java代码
package com.cdv.mam.db;import java.sql.Connection;import java.sql.DatabaseMetaData;import java.sql.SQLException;import java.util.Properties;import javax.sql.DataSource;import org.apache.commons.dbcp.BasicDataSourceFactory;import org.apache.commons.logging.Log;import org.apache.commons.logging.LogFactory;//import org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory;/** * tomcat数据库连接池管理类<br> * 使用为tomcat部署环境<br> * 需要在类路径下准备数据库连接配置文件dbcp.properties * */public class DBManager { private static final Log log = LogFactory.getLog(DBManager.class); private static final String configFile = "dbcp.properties"; private static DataSource dataSource; static { Properties dbProperties = new Properties(); try { dbProperties.load(DBManager.class.getClassLoader() .getResourceAsStream(configFile)); dataSource = BasicDataSourceFactory.createDataSource(dbProperties); Connection conn = getConn(); DatabaseMetaData mdm = conn.getMetaData(); log.info("Connected to " + mdm.getDatabaseProductName() + " " + mdm.getDatabaseProductVersion()); if (conn != null) { conn.close(); } } catch (Exception e) { log.error("初始化连接池失败:" + e); } } private DBManager() { } /** * 获取链接,用完后记得关闭 * * @see {@link DBManager#closeConn(Connection)} * @return */ public static final Connection getConn() { Connection conn = null; try { conn = dataSource.getConnection(); } catch (SQLException e) { log.error("获取数据库连接失败:" + e); } return conn; } /** * 关闭连接 * * @param conn * 需要关闭的连接 */ public static void closeConn(Connection conn) { try { if (conn != null && !conn.isClosed()) { conn.setAutoCommit(true); conn.close(); } } catch (SQLException e) { log.error("关闭数据库连接失败:" + e); } }}
海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理:https://www.xlkjsw.com
原标题:java 数据库连接池
关键词:JAVA
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。