Java BasicDataSource类代码示例

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
@Override
public DataSourceInfo getInfo(Object resource) throws Exception {
  DataSourceInfo dataSourceInfo = null;
  if (canMap(resource)) {
    BasicDataSource source = (BasicDataSource) resource;
    dataSourceInfo = new DataSourceInfo();
    dataSourceInfo.setBusyConnections(source.getNumActive());
    dataSourceInfo.setEstablishedConnections(source.getNumIdle() + source.getNumActive());
    dataSourceInfo.setMaxConnections(source.getMaxTotal());
    dataSourceInfo.setJdbcUrl(source.getUrl());
    dataSourceInfo.setUsername(source.getUsername());
    dataSourceInfo.setResettable(false);
    dataSourceInfo.setType("tomcat-dbcp2");
  }
  return dataSourceInfo;
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
private ConnectionDB ()
{
	pool = new BasicDataSource();
	pool.setDriverClassName("com.mysql.jdbc.Driver");
	pool.setUsername("root");
	pool.setPassword("1111");
	pool.setUrl("jdbc:mysql://localhost/videogameshop");
	pool.setInitialSize(40); 

}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
@Override
public LineaCompra findById(String id) {
	
	LineaCompra l = null;
	
	try
	{
		BasicDataSource basicDataSource = ConnectionDB.getInstancia().getPool();
		Connection conexion = basicDataSource.getConnection();
		
		
		String query = "select * from lineacompra where login = ?" ;
		
		PreparedStatement s = conexion.prepareStatement(query);
    
		s.setString(1,id);
    
		ResultSet rs = s.executeQuery ();
    
		if (rs.next())
		{
			l = new LineaCompra();
			l.setId(rs.getString(1));
			l.setIdcompra(rs.getString(2));
			l.setCantidad(rs.getInt(3));
			l.setSubtotal(rs.getFloat(4));

		}
        conexion.close();
		
	}catch (Exception ex)
	{
		System.out.println ("Error"+ex.getMessage());
	}


	return l;
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
@Override
public Usuario findById(String key) {
	Connection conexion = null;
	Usuario u = null;
	try
	{
		ConnectionDB pool = ConnectionDB.getInstancia();
		BasicDataSource datasource = pool.getPool();
		conexion = datasource.getConnection();
		
			
		String query = "select * from usuario where nick = ?" ;
		
		PreparedStatement s = conexion.prepareStatement(query);
    
		s.setString(1,key);
    
		ResultSet result = s.executeQuery ();
    
		if (result.next())
		{
			u = new Usuario();
			u.setId(result.getInt(1));
			u.setNombre(result.getString(2));
			u.setApellidos(result.getString(3));
			u.setDni(result.getString(4));
			u.setEmail(result.getString(5));
			u.setNick(result.getString(6));
			u.setPsswd(result.getString(7));
			u.setIsadmin(result.getBoolean(8));
		}
        conexion.close();
	}
	catch (Exception ex)
   	{
   		System.out.println ("Error"+ex.getMessage());
   	}

	return u;
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
/**
 * Tomcat 8 dbcp datasource accessor.
 *
 * @throws Exception the exception
 */
@Test
public void Tomcat8DbcpDatasourceAccessor() throws Exception {
  Tomcat8DbcpDatasourceAccessor accessor = new Tomcat8DbcpDatasourceAccessor();
  try (BasicDataSource source = new BasicDataSource()) {
    assertEquals("tomcat-dbcp2", accessor.getInfo(source).getType());
  }
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
/**
 * Tomcat 9 dbcp datasource accessor.
 *
 * @throws Exception the exception
 */
@Test
public void Tomcat9DbcpDatasourceAccessor() throws Exception {
  Tomcat9DbcpDatasourceAccessor accessor = new Tomcat9DbcpDatasourceAccessor();
  try (BasicDataSource source = new BasicDataSource()) {
    assertEquals("tomcat-dbcp2", accessor.getInfo(source).getType());
  }
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
/**
 * Tomcat 85 dbcp datasource accessor.
 *
 * @throws Exception the exception
 */
@Test
public void Tomcat85DbcpDatasourceAccessor() throws Exception {
  Tomcat85DbcpDatasourceAccessor accessor = new Tomcat85DbcpDatasourceAccessor();
  try (BasicDataSource source = new BasicDataSource()) {
    assertEquals("tomcat-dbcp2", accessor.getInfo(source).getType());
  }
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
/**
 * Create a new {@link DataSource} whose lifecycle is managed by baseline.
 *
 * @param environment {@code Environment} instance for this baseline service
 * @param database database configuration block for configuring the {@code DataSource}
 * @return valid, new {@code DataSource} instance
 */
public static ManagedDataSource newManagedDataSource(Environment environment, DatabaseConfiguration database) {
    BasicDataSource dataSource = (BasicDataSource) newDataSource(database);
    registerGauges(dataSource);

    ManagedDataSource managed = new ManagedDataSource(dataSource);
    environment.addManaged(managed);

    return managed;
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
/**
 * Create a new {@code DataSource}.
 * <br>
 * The lifecycle of the created instance is <strong>NOT</strong>
 * managed by baseline. To create a {@code DataSource} whose lifecycle
 * is managed, use {@link #newManagedDataSource(Environment, DatabaseConfiguration)}.
 *
 * @param database database configuration block for configuring the {@code DataSource}
 * @return valid, new {@code DataSource} instance
 */
public static DataSource newDataSource(DatabaseConfiguration database) {
    BasicDataSource dataSource = new BasicDataSource();

    // attempt to load the driver class
    dataSource.setDriverClassName(database.getDriverClass());

    // username and password
    // only sets them if the value is not null/empty
    if (!(database.getUsername() == null || database.getUsername().isEmpty())) {
        dataSource.setUsername(database.getUsername());
    }
    if (!(database.getPassword() == null || database.getPassword().isEmpty())) {
        dataSource.setPassword(database.getPassword());
    }

    // other properties
    dataSource.setUrl(database.getUrl());
    dataSource.setDefaultTransactionIsolation(database.getDefaultTransactionIsolation().getLevel());
    dataSource.setDefaultAutoCommit(database.isAutoCommit());
    dataSource.setTestOnBorrow(database.isCheckConnectionOnBorrow());
    dataSource.setTestOnReturn(database.isCheckConnectionOnReturn());
    dataSource.setMinIdle(database.getMinTotalConnections());
    dataSource.setMaxTotal(database.getMaxTotalConnections());
    dataSource.setMaxIdle(database.getMaxIdleConnections());
    dataSource.setMaxWaitMillis(database.getAcquireConnectionTimeout());
    dataSource.setDefaultQueryTimeout(database.getQueryTimeout() <= 0 ? null : database.getQueryTimeout());
    dataSource.setTestWhileIdle(database.isCheckConnectionWhenIdle());
    dataSource.setTimeBetweenEvictionRunsMillis(database.getIdleConnectionCheckInterval());
    dataSource.setMinEvictableIdleTimeMillis(database.getCloseIdleConnectionAfter());
    dataSource.setValidationQuery(database.getValidationQuery());
    dataSource.setValidationQueryTimeout((int) database.getValidationQueryTimeout());
    dataSource.setAccessToUnderlyingConnectionAllowed(false);
    dataSource.setDefaultAutoCommit(false);

    return dataSource;
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
public BasicDataSource getPool() {
	return pool;
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
public Producto findById(String id)
{
	Connection conexion = null;
	Producto p = null;
	try
	{
		ConnectionDB pool = ConnectionDB.getInstancia();
		BasicDataSource datasource = pool.getPool();
		conexion = datasource.getConnection();
		
			
		String query = "select * from producto where idProducto = ?" ;
		
		PreparedStatement s = conexion.prepareStatement(query);
    
		s.setString(1,id);
    
		ResultSet result = s.executeQuery ();
    
		if (result.next())
		{
			p = new Producto();
			p.setId_producto(result.getInt(1));
			p.setNombre(result.getString(2));
			p.setPlataforma(result.getString(3));
			p.setCategoria(result.getString(4));
			p.setStock(result.getInt(5));
			p.setPrecio(result.getFloat(6));
			p.setFecha(result.getString(7));
			p.setDescripcion(result.getString(8));
		}
        conexion.close();
		
	}
	
	
	catch (Exception ex)
	{
		System.out.println ("Error"+ex.getMessage());
	}


	return p;
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
@Override
public boolean canMap(Object resource) {
  return "org.apache.tomcat.dbcp.dbcp2.BasicDataSource".equals(resource.getClass().getName())
      && resource instanceof BasicDataSource;
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
private static void registerGauges(final BasicDataSource dataSource) {
    MetricRegistries.getRegistry().register(MetricRegistries.name("db", dataSource.getUrl(), "used"), (Gauge<Integer>) dataSource::getNumActive);
    MetricRegistries.getRegistry().register(MetricRegistries.name("db", dataSource.getUrl(), "idle"), (Gauge<Integer>) dataSource::getNumIdle);
}
 

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource; //导入依赖的package包/类
/**
 * Constructor.
 *
 * @param dataSource valid {@code DataSource} instance whose lifecycle should be managed by baseline
 */
@Inject
public ManagedDataSource(BasicDataSource dataSource) {
    this.dataSource = dataSource;
}