Java BasicDataSource.setPassword方法代码示例

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包/类
/**
 * The following bean configures the database connection. The 'url' property value of "jdbc:derby:directory:jpaserver_derby_files;create=true" indicates that the server should save resources in a
 * directory called "jpaserver_derby_files".
 * 
 * A URL to a remote database could also be placed here, along with login credentials and other properties supported by BasicDataSource.
 */
@Bean(destroyMethod = "close")
public DataSource dataSource() {
	BasicDataSource retVal = new BasicDataSource();
	/*
	retVal.setDriver(new org.apache.derby.jdbc.EmbeddedDriver());
	retVal.setUrl("jdbc:derby:directory:target/jpaserver_derby_files;create=true");
	retVal.setUsername("");
	retVal.setPassword("");
	* */
	 
	
	try
	{
		retVal.setDriver(new com.mysql.jdbc.Driver());
	}
	catch (Exception exc)
	{
		exc.printStackTrace();
	}
	retVal.setUrl("jdbc:mysql://localhost:3306/dhis2_fhir");
	retVal.setUsername("root");
	retVal.setPassword("");
	return retVal;
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
/**
 * The following bean configures the database connection. The 'url' property value of "jdbc:derby:directory:jpaserver_derby_files;create=true" indicates that the server should save resources in a
 * directory called "jpaserver_derby_files".
 * 
 * A URL to a remote database could also be placed here, along with login credentials and other properties supported by BasicDataSource.
 */
@Bean(destroyMethod = "close")
public DataSource dataSource() {
	BasicDataSource retVal = new BasicDataSource();
	/*
	retVal.setDriver(new org.apache.derby.jdbc.EmbeddedDriver());
	retVal.setUrl("jdbc:derby:directory:target/jpaserver_derby_files;create=true");
	retVal.setUsername("");
	retVal.setPassword("");
	*/
	try
	{
		//retVal.setDriver(new com.mysql.jdbc.Driver());
		retVal.setDriver(new org.postgresql.Driver());
	}
	catch (Exception exc)
	{
		exc.printStackTrace();
	}
	//retVal.setUrl("jdbc:mysql://localhost:3306/dhis2_fhir");
	retVal.setUrl("jdbc:postgresql://localhost:5432/dhis2_fhir");
	retVal.setUsername("fhir");
	retVal.setPassword("xxxxxxx");
	
	return retVal;
}
 

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包/类
@Test
public void testOpenConnectionToH2DbHavingAllSupportedPersistenceProperties() throws ClassNotFoundException {
    // GIVEN
    final BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(H2_DRIVER_CLASS_PROP_VALUE);
    ds.setUsername(USERNAME_PROP_VALUE);
    ds.setPassword(PASSWORD_PROP_VALUE);
    ds.setUrl(H2_CONNECTION_URL_PROP_VALUE);

    // WHEN
    connection = DatabaseConnectionFactory.openConnection(ds);

    // THEN
    assertThat(connection, notNullValue());
    assertThat(connection, instanceOf(H2Connection.class));
}
 

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/inst01");
	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包/类
public static void setDataSourceFromPropertyFile() 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);
}
 

import org.apache.commons.dbcp2.BasicDataSource; //导入方法依赖的package包/类
@Bean
public BasicDataSource getDataSource() throws URISyntaxException {
	String url = System.getenv("DATABASE_URL");
	if (url == null) {
		url = "mysql://bugminer:[email protected]:3306/bugminer";
	}

	URI dbUri = new URI(url);
	String username = dbUri.getUserInfo().split(":")[0];
	String password = dbUri.getUserInfo().split(":")[1];
	String scheme = dbUri.getScheme();
	if (scheme.equals("postgres")) {
		scheme = "postgresql";
	}
	String dbUrl = "jdbc:" + scheme + "://" + dbUri.getHost() + ':' + dbUri.getPort() + dbUri.getPath();

	BasicDataSource basicDataSource = new BasicDataSource();
	basicDataSource.setUrl(dbUrl);
	basicDataSource.setUsername(username);
	basicDataSource.setPassword(password);

	return basicDataSource;
}
 

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

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

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");
}