Java BasicDataSource.setDriverClassName方法代码示例

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
/**
 * Get a new herd data source based on an in-memory HSQLDB database. This data source is used for loading the configuration table as an environment property
 * source as well as for the JPA entity manager. It will therefore create/re-create the configuration table which is required for the former. It also
 * inserts required values for both scenarios.
 *
 * @return the test herd data source.
 */
@Bean
public static DataSource herdDataSource()
{
    // Create and return a data source that can connect directly to a JDBC URL.
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName(org.h2.Driver.class.getName());
    basicDataSource.setUsername("");
    basicDataSource.setPassword("");
    basicDataSource.setUrl("jdbc:h2:mem:herdTestDb");

    // Create and populate the configuration table.
    // This is needed for all data source method calls since it is used to create the environment property source which happens before
    // JPA and other non-static beans are initialized.
    ResourceDatabasePopulator resourceDatabasePopulator = new ResourceDatabasePopulator();
    resourceDatabasePopulator.addScript(new ClassPathResource("createConfigurationTableAndData.sql"));
    DatabasePopulatorUtils.execute(resourceDatabasePopulator, basicDataSource); // This is what the DataSourceInitializer does.

    return basicDataSource;
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
private static BasicDataSource getBasicDataSource(DatasourceConfiguration configuration) {
    BasicDataSource dbcpDataSource = new BasicDataSource();
    dbcpDataSource.setDriverClassName(configuration.getDriverClassname());
    dbcpDataSource.setUrl(configuration.getUrl());
    dbcpDataSource.setUsername(configuration.getUser());
    dbcpDataSource.setPassword(configuration.getPassword());

    // Enable statement caching (Optional)
    dbcpDataSource.setPoolPreparedStatements(true);
    dbcpDataSource.setValidationQuery("Select 1 ");
    dbcpDataSource.setMaxOpenPreparedStatements(50);
    dbcpDataSource.setLifo(true);
    dbcpDataSource.setMaxTotal(10);
    dbcpDataSource.setInitialSize(2);
    return dbcpDataSource;
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
/**
 * Returns the singleton EntityManagerFactory instance for accessing the
 * default database.
 * 
 * @return the singleton EntityManagerFactory instance
 * @throws NamingException
 *             if a naming exception occurs during initialization
 * @throws SQLException
 *             if a database occurs during initialization
 * @throws IOException 
 */
public static synchronized EntityManagerFactory getEntityManagerFactory()
		throws NamingException, SQLException, IOException {
	if (entityManagerFactory == null) {
		InitialContext ctx = new InitialContext();
	    BasicDataSource ds = new BasicDataSource();
	    JsonNode credentials = readCredentialsFromEnvironment();
		ds.setDriverClassName(credentials.get("driver").asText());
	    ds.setUrl(credentials.get("url").asText());
	    ds.setUsername(credentials.get("user").asText());
	    ds.setPassword(credentials.get("password").asText());
		Map<String, Object> properties = new HashMap<String, Object>();
		properties.put(PersistenceUnitProperties.NON_JTA_DATASOURCE, ds);
		entityManagerFactory = Persistence.createEntityManagerFactory(
				PERSISTENCE_UNIT_NAME, properties);
	}
	return entityManagerFactory;
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
public DataSource invokeGetDataSource() {
	BasicDataSource bds = new BasicDataSource();
	bds.setDriverClassName("com.mysql.jdbc.Driver");
	bds.setUrl("jdbc:mysql://127.0.0.1:3306/inst02");
	bds.setUsername("root");
	bds.setPassword("123456");
	bds.setMaxTotal(50);
	bds.setInitialSize(20);
	bds.setMaxWaitMillis(60000);
	bds.setMinIdle(6);
	bds.setLogAbandoned(true);
	bds.setRemoveAbandonedOnBorrow(true);
	bds.setRemoveAbandonedOnMaintenance(true);
	bds.setRemoveAbandonedTimeout(1800);
	bds.setTestWhileIdle(true);
	bds.setTestOnBorrow(false);
	bds.setTestOnReturn(false);
	bds.setValidationQuery("select 'x' ");
	bds.setValidationQueryTimeout(1);
	bds.setTimeBetweenEvictionRunsMillis(30000);
	bds.setNumTestsPerEvictionRun(20);
	return bds;
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
/**
 * The main method.
 *
 * @param args the arguments
 */
public static void main(String[] args) {
		try {
			List<String> tableNames = Arrays.asList(args[0].split("[|]"));
			String targetFolder = args[1];
			String packageName = args[2];
	        String jdbcLogin = args[3];
	        String jdbcPassword = args[4];
	        String jdbcUrl = args[5];
	        String jdbcDriverClassName = args[6];
	        BasicDataSource ds = new BasicDataSource();
			ds.setDriverClassName(jdbcDriverClassName);
			ds.setUsername(jdbcLogin);
			ds.setPassword(jdbcPassword);
			ds.setUrl(jdbcUrl);
			ds.setDefaultAutoCommit(true);
			
			CreateBasicDaoVo generateVos = new CreateBasicDaoVo().setDs(ds).setTableNames(tableNames)
					.setPackageName(packageName).setTargetFolder(targetFolder).setJdbcDriverClassName(jdbcDriverClassName);
			generateVos.process();

		} catch (Exception e) {
			logger.error(e.getMessage(), e);
		}
	}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@SneakyThrows
private static CloseableDatasource dbcp(Config config) {
    int threads = config.getInt("threads");
    BasicDataSource dataSource = new BasicDataSource();

    dataSource.setDriverClassName(config.getString("driver"));
    dataSource.setUrl(config.getString("url"));

    dataSource.setUsername(config.getString("user"));
    dataSource.setPassword(config.getString("pwd"));

    dataSource.setInitialSize(threads);

    dataSource.setMinEvictableIdleTimeMillis(120 * 1000);//seconds

    DBCPCloseableDataSource ds = new DBCPCloseableDataSource(dataSource);
    return ds;
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
public DataSource createDataSource() {
    final String driverClass = (String) dbConfig.get("javax.persistence.jdbc.driver");
    final String connectionUrl = (String) dbConfig.get("javax.persistence.jdbc.url");
    final String username = (String) dbConfig.get("javax.persistence.jdbc.user");
    final String password = (String) dbConfig.get("javax.persistence.jdbc.password");

    final BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(driverClass);
    ds.setUsername(username);
    ds.setPassword(password);
    ds.setUrl(connectionUrl);
    ds.setMinIdle(1);
    ds.setMaxIdle(2);

    return ds;
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@BeforeClass
public static void setupDatabase() throws Exception {
  InputStream inputStream = MMXTopicTagsResourceTest.class.getResourceAsStream("/test.properties");

  Properties testProperties = new Properties();
  testProperties.load(inputStream);

  String host = testProperties.getProperty("db.host");
  String port = testProperties.getProperty("db.port");
  String user = testProperties.getProperty("db.user");
  String password = testProperties.getProperty("db.password");
  String driver = testProperties.getProperty("db.driver");
  String schema = testProperties.getProperty("db.schema");

  String url = "jdbc:mysql://" + host + ":" + port + "/" + schema;

  ds = new BasicDataSource();
  ds.setDriverClassName(driver);
  ds.setUsername(user);
  ds.setPassword(password);
  ds.setUrl(url);

}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@BeforeClass
public static void setupDatabase() throws Exception {
  InputStream inputStream = DeviceDAOImplTest.class.getResourceAsStream("/test.properties");

  Properties testProperties = new Properties();
  testProperties.load(inputStream);

  String host = testProperties.getProperty("db.host");
  String port = testProperties.getProperty("db.port");
  String user = testProperties.getProperty("db.user");
  String password = testProperties.getProperty("db.password");
  String driver = testProperties.getProperty("db.driver");
  String schema = testProperties.getProperty("db.schema");

  String url = "jdbc:mysql://" + host + ":" + port + "/" + schema;

  ds = new BasicDataSource();
  ds.setDriverClassName(driver);
  ds.setUsername(user);
  ds.setPassword(password);
  ds.setUrl(url);

  DBTestUtil.setBasicDataSource(ds);

  generateRandomUserData();
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@PostConstruct
/**
 * Creates security data-source to be used with the sample DB 
 */
public void init() {
       securityDataSource = new BasicDataSource();
       securityDataSource.setDriverClassName(com.mysql.jdbc.Driver.class.getName());
       securityDataSource.setUrl("jdbc:mysql://localhost:3306/java_one_2014");
       securityDataSource.setUsername("java_one");
       securityDataSource.setPassword("");
	securityDataSource.setInitialSize(5);
       securityDataSource.setMaxTotal(30);
       securityDataSource.setMaxIdle(15);
       securityDataSource.setMaxWaitMillis(3000);
       securityDataSource.setLogAbandoned(true);
       securityDataSource.setTestWhileIdle(true);
       securityDataSource.setTestOnBorrow(true);
       securityDataSource.setValidationQuery("select 1");
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@Override
public DataSource wrap(final ReportDataSource rptDs) {
    try {
        final BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName(rptDs.getDriverClass());
        dataSource.setUrl(rptDs.getJdbcUrl());
        dataSource.setUsername(rptDs.getUser());
        dataSource.setPassword(rptDs.getPassword());
        dataSource.setInitialSize(MapUtils.getInteger(rptDs.getOptions(), "initialSize", 3));
        dataSource.setMaxIdle(MapUtils.getInteger(rptDs.getOptions(), "maxIdle", 20));
        dataSource.setMinIdle(MapUtils.getInteger(rptDs.getOptions(), "minIdle", 1));
        dataSource.setLogAbandoned(MapUtils.getBoolean(rptDs.getOptions(), "logAbandoned", true));
        dataSource.setRemoveAbandonedTimeout(
            MapUtils.getInteger(rptDs.getOptions(), "removeAbandonedTimeout", 180));
        dataSource.setMaxWaitMillis(MapUtils.getInteger(rptDs.getOptions(), "maxWait", 1000));
        return dataSource;
    } catch (final Exception ex) {
        throw new RuntimeException("C3p0DataSourcePool Create Error", ex);
    }
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
private BasicDataSource getInitializedDataSource(MySQLConfig mySqlConfig) {

		BasicDataSource basicDataSource = new BasicDataSource();

		basicDataSource.setDriverClassName(mySqlConfig.getDriverClass());
		basicDataSource.setUrl(mySqlConfig.getUrl());
		basicDataSource.setUsername(mySqlConfig.getUsername());
		basicDataSource.setPassword(mySqlConfig.getPassword());
		
		basicDataSource.setRemoveAbandonedTimeout(mySqlConfig.getRemoveAbandonedTimeoutInSeconds());
		basicDataSource.setRemoveAbandonedOnBorrow(mySqlConfig.isAbleToRemoveAbandonedConnections());
		basicDataSource.setRemoveAbandonedOnMaintenance(mySqlConfig.isAbleToRemoveAbandonedConnections());

		// int maxValue = 100;
		// basicDataSource.setMaxIdle(maxValue);
		// basicDataSource.setMaxTotal(maxValue);

		return basicDataSource;
	}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
/**
 * TODO: write documentation
 * 
 * @throws ClassNotFoundException
 */
private void setupDataSource() throws ClassNotFoundException {

	// request classloader to load JDBC driver class
	Class.forName(jdbcDriverClassName);

	// prepare and configure data source
	dataSource = new BasicDataSource();
	dataSource.setDefaultAutoCommit(true);
	dataSource.setDriverClassName(jdbcDriverClassName);
	dataSource.setUsername(jdbcLogin);
	dataSource.setPassword(jdbcPass);
	dataSource.setUrl(jdbcUrl + jdbcSchema);
	dataSource.setValidationQuery("select 1");
	dataSource.setDefaultQueryTimeout(1000);
	dataSource.setMaxConnLifetimeMillis(100000);
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
public SQLDatabase(SQLDatabaseType jdbcInfo, String username, String password, String database, String host,
		int port, String key) {

	// TODO: check parameters

	this.jdbcInfo = jdbcInfo;
	this.username = username;
	this.password = password;
	this.host = host;
	this.port = port;
	this.database = database;
	this.key = key;

	BasicDataSource ds = new BasicDataSource();
	String urlPrefix = jdbcInfo.getJDBCurl(this.host, this.database, this.port) + "?autoReconnect=true";
	ds.setUrl(urlPrefix);
	ds.setUsername(username);
	ds.setPassword(password);
	ds.setDriverClassName(jdbcInfo.getDriverName());
	ds.setMinIdle(5);
	ds.setMaxIdle(10);
	ds.setMaxOpenPreparedStatements(100);

	dataSource = ds;
	setValidationQuery();
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
public static void initialize(String driverName, String driverUrl, String userName, String password) throws SQLException {
    dataSource = new BasicDataSource();
    dataSource.setDriverClassName(driverName);
    dataSource.setUsername(userName);
    dataSource.setPassword(password);
    dataSource.setUrl(driverUrl);

    dataSource.setDefaultReadOnly(false);
    dataSource.setDefaultAutoCommit(false);

    // enable detection and logging of connection leaks
    dataSource.setRemoveAbandonedOnBorrow(true);
    dataSource.setRemoveAbandonedOnMaintenance(true);
    dataSource.setRemoveAbandonedTimeout(3600); // 1 hour
    dataSource.setLogAbandoned(true);
    dataSource.setMaxWaitMillis(60000);
    dataSource.setMaxTotal(20);

    INITDATE = new Date();
}