@SuppressWarnings("unchecked")
public int CheckUserByName() {
// JOptionPane.showMessageDialog(null, _connPro.GetUserInfo().GetName());
IUserInfo u = this.FindByName(_connPro.GetUserInfo().GetName());
// JOptionPane.showMessageDialog(null, u.GetName());
int result = TypeOfErrorOnUser.WrongUserNameAndPass;
result = ((Comparable<IUserInfo>) u).compareTo(_connPro.GetUserInfo());
// JOptionPane.showMessageDialog(null, result);
return result;
}
@Override
public Connection GetSingleConnection(IConnectionProperty connPro) {
// TODO Auto-generated method stub
Connection conn = null;
_connectionProperty = connPro;
// JOptionPane.showMessageDialog(null, connPro.GetUserInfo().GetName());
try {
// conn = DriverManager.getConnection (
// "jdbc:postgresql://localhost/quan8", "postgres", "postgres");
conn =
DriverManager.getConnection(
connPro.GetUrl(), connPro.GetUserInfo().GetName(), connPro.GetUserInfo().GetPass());
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
@Override
public void setup(IConnectionProperty connPro) {
// TODO Auto-generated method stub
_connectionProperty = connPro;
System.out.println(_connectionProperty.GetUrl());
BoneCPConfig config = new BoneCPConfig();
System.out.println(_connectionProperty.GetUrl());
System.out.println(_connectionProperty.GetUserInfo().GetName());
System.out.println(_connectionProperty.GetUserInfo().GetPass());
config.setJdbcUrl(
_connectionProperty
.GetUrl()); // jdbc url specific to your database, eg jdbc:mysql://127.0.0.1/yourdb
config.setUsername(_connectionProperty.GetUserInfo().GetName());
config.setPassword(_connectionProperty.GetUserInfo().GetPass());
config.setMinConnectionsPerPartition(_minConn);
config.setMaxConnectionsPerPartition(_maxConn);
config.setPartitionCount(_partCount);
config.setDisableConnectionTracking(true);
if (doPreparedStatement) {
config.setStatementsCacheSize(10);
} else {
config.setStatementsCacheSize(0);
}
config.setReleaseHelperThreads(helper_threads);
config.setStatementReleaseHelperThreads(15);
config.setAcquireIncrement(5);
config.setPoolName("me");
config.setLazyInit(false);
try {
_boneCP = new BoneCP(config);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
@Override
public void Reset() {
// TODO Auto-generated method stub
if (_connectionProperty == null) {
System.out.print(String.format("khong reset duoc"));
return;
}
BoneCPConfig config = new BoneCPConfig();
config.setJdbcUrl(
_connectionProperty
.GetUrl()); // jdbc url specific to your database, eg jdbc:mysql://127.0.0.1/yourdb
config.setUsername(_connectionProperty.GetUserInfo().GetName());
config.setPassword(_connectionProperty.GetUserInfo().GetPass());
config.setMinConnectionsPerPartition(_minConn);
config.setMaxConnectionsPerPartition(_maxConn);
config.setPartitionCount(_partCount);
try {
_boneCP = new BoneCP(config);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* Khoi tao pool
*
* @author hdk
* @param connPro: connectionProperty
* @param minConn: minConnectionPerPartition:Default=5
* @param maxConn: maxConnectionPerPartition:Default=10
* @param partCount: PartitionCount:Default=1
*/
@Override
public void setup(IConnectionProperty connPro, int minConn, int maxConn, int partCount) {
// TODO Auto-generated method stub
_connectionProperty = connPro;
_minConn = minConn;
_maxConn = maxConn;
_partCount = partCount;
BoneCPConfig config = new BoneCPConfig();
config.setJdbcUrl(
_connectionProperty
.GetUrl()); // jdbc url specific to your database, eg jdbc:mysql://127.0.0.1/yourdb
config.setUsername(_connectionProperty.GetUserInfo().GetName());
config.setPassword(_connectionProperty.GetUserInfo().GetPass());
config.setMinConnectionsPerPartition(_minConn);
config.setMaxConnectionsPerPartition(_maxConn);
config.setPartitionCount(_partCount);
try {
_boneCP = new BoneCP(config);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
