@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(); } }