com.ailyr.tool.db.ds.pooled.PooledConnection Maven / Gradle / Ivy
package com.ailyr.tool.db.ds.pooled;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.ailyr.tool.db.DbUtil;
/**
* 池化
* @author Looly
*
*/
public class PooledConnection extends ConnectionWraper{
private PooledDataSource ds;
private boolean isClosed;
public PooledConnection(PooledDataSource ds) throws SQLException {
this.ds = ds;
DbConfig config = ds.getConfig();
this.raw = DriverManager.getConnection(config.getUrl(), config.getUser(), config.getPass());
}
public PooledConnection(PooledDataSource ds, Connection conn) {
this.ds = ds;
this.raw = conn;
}
/**
* 重写关闭连接，实际操作是归还到连接池中
*/
@Override
public void close() throws SQLException {
this.ds.free(this);
this.isClosed = true;
}
/**
* 连接是否关闭，关闭条件：
* 1、被归还到池中
* 2、实际连接已关闭
*/
@Override
public boolean isClosed() throws SQLException {
return isClosed || raw.isClosed();
}
/**
* 打开连接
* @return this
*/
protected PooledConnection open() {
this.isClosed = false;
return this;
}
/**
* 释放连接
* @return this
*/
protected PooledConnection release() {
DbUtil.close(this.raw);
return this;
}
}