Java DriverManagerDataSource.setUrl方法代码示例

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Bean
public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
	LocalContainerEntityManagerFactoryBean factory = new LocalContainerEntityManagerFactoryBean();

	JpaVendorAdapter jpaVendorAdapter = new HibernateJpaVendorAdapter();

	DriverManagerDataSource dataSource = new DriverManagerDataSource();
	dataSource.setUsername("root");
	dataSource.setPassword("");
	dataSource.setUrl("jdbc:mysql://localhost:3306/ensaiospring");
	dataSource.setDriverClassName("com.mysql.jdbc.Driver");

	Properties props = new Properties();
	props.setProperty("hibernate.dialect",
			"org.hibernate.dialect.MySQL5Dialect");
	props.setProperty("hibernate.show_sql", "true");
	props.setProperty("hibernate.hbm2ddl.auto", "update");

	factory.setJpaVendorAdapter(jpaVendorAdapter);
	factory.setDataSource(dataSource);
	factory.setJpaProperties(props);
	factory.setPackagesToScan("br.com.ciaware.springmvc.ensaio.models");

	return factory;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Bean
public DataSource mysqlDataSource() {

    DriverManagerDataSource dataSource = new DriverManagerDataSource();

    dataSource.setDriverClassName(MYSQL_DRIVER_CLASS_NAME);
    dataSource.setUrl(MYSQL_URL);
    dataSource.setUsername(MYSQL_USER_NAME);
    dataSource.setPassword(MYSQL_USER_PASSWORD);

    return dataSource;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Setup
public void setup() throws PropertyVetoException {
  dataSource = new DriverManagerDataSource();
  dataSource.setDriverClassName("com.mysql.jdbc.Driver");
  dataSource.setUrl(propertyOr("jdbcUrl", "jdbc:mysql://127.0.0.1:3306?useSSL=false"));
  dataSource.setUsername(propertyOr("username", "root"));
  dataSource.setPassword(propertyOr("password", "root"));

  JdbcTemplate delegate = new JdbcTemplate(dataSource);
  delegate.setDataSource(dataSource);

  proxy = new SenderProxy(new JdbcTemplateSender(delegate));
  proxy.onMessages(updated -> counter.addAndGet(updated.size()));

  reporter = reporter(proxy);
  batch = new BatchJdbcTemplate(delegate, reporter);
  batch.setDataSource(dataSource);

  unbatch = new JdbcTemplate(dataSource);
  unbatch.setDataSource(dataSource);
  unbatch.update(CREATE_DATABASE);
  unbatch.update(DROP_TABLE);
  unbatch.update(CREATE_TABLE);
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Bean
public DataSource configureDataSource() {
    log.info("*************** Env Variables configureDataSource *************** ");

    String driver = System.getenv(EnviromentVariables.DATASOURCE_DRIVER_CLASS.getCode());
    String url = System.getenv(EnviromentVariables.DATASOURCE_URL.getCode());
    String username = System.getenv(EnviromentVariables.DATASOURCE_USERNAME.getCode());
    String password = System.getenv(EnviromentVariables.DATASOURCE_PASSWORD.getCode());

    log.info("dataSource.driverClassName:    " + driver);
    log.info("dataSource.url:                " + url);
    log.info("dataSource.username:           " + username);
    log.info("dataSource.password:           ***");

    log.info("*************** END Env Variables configureDataSource *************** ");

    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(driver);
    dataSource.setUrl(url);
    dataSource.setUsername(username);
    dataSource.setPassword(password);

    return dataSource;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
/**
 * Creates the data source from the settings map
 *
 * @param settingsMap - the settingMap containing the db connection settings
 * @return the DataSource object
 */
public static DataSource getDataSource(HashMap settingsMap) {
    String driver;
    if ("MySQL".equals(settingsMap.get("datasource.ojb.platform"))) {
        driver = "com.mysql.jdbc.Driver";
    } else if ("Oracle9i".equals(settingsMap.get("datasource.ojb.platform"))) {
        driver = "oracle.jdbc.driver.OracleDriver";
    } else {
        driver = (String) settingsMap.get("datasource.driver.name");
    }

    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(driver);
    dataSource.setUrl((String) settingsMap.get("datasource.url"));
    dataSource.setUsername((String) settingsMap.get("datasource.username"));
    dataSource.setPassword((String) settingsMap.get("datasource.password"));
    return dataSource;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
/**
 * @return Access to relational database system for local deployments
 */
@Bean(name = "spring-demo-db")
public DataSource dataSource() {
    boolean isCloud = Arrays.asList(ctx.getEnvironment().getActiveProfiles()).contains("cloud");

    if (isCloud) {
        String msg = "DataSource bean has not been auto-reconfigured."
                + " Without, the application cannot exist in the Cloud.";
        logger.error(msg);
        throw new RuntimeException(msg);
    }

    logger.info("DataSource instance about to be created");
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName(env.getRequiredProperty("db.driver"));
    ds.setUrl(env.getRequiredProperty("db.url"));
    ds.setUsername(env.getRequiredProperty("db.username"));
    ds.setPassword(env.getRequiredProperty("db.password"));
    return ds;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Override
protected void setUp() throws Exception {
    super.setUp();

    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(DRIVER);
    dataSource.setUrl(URL);
    dataSource.setUsername(USERNAME);
    dataSource.setPassword(PASSWORD);

    jdbcTemplate = new JdbcTemplate(dataSource);
    createTestSchema();

    reader.setParameters(parameters);
    reader.validate(new ArrayList<String>());
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
/**
 * 获取新的数据源
 *
 * @return
 */
public static DataSource getNewDataSource() {
    if (newDataSource == null) synchronized (TaleUtils.class) {
        if (newDataSource == null) {
            Properties properties = TaleUtils.getPropFromFile("application-default.properties");
            if (properties.size() == 0) {
                return newDataSource;
            }
            DriverManagerDataSource managerDataSource = new DriverManagerDataSource();
            managerDataSource.setDriverClassName("com.mysql.jdbc.Driver");
            managerDataSource.setPassword(properties.getProperty("spring.datasource.password"));
            String str = "jdbc:mysql://" + properties.getProperty("spring.datasource.url") + "/" + properties.getProperty("spring.datasource.dbname") + "?useUnicode=true&characterEncoding=utf-8&useSSL=false";
            managerDataSource.setUrl(str);
            managerDataSource.setUsername(properties.getProperty("spring.datasource.username"));
            newDataSource = managerDataSource;
        }
    }
    return newDataSource;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Bean(name = "dataSource")
public DataSource getH2DataSource() 
{
	System.out.println("Starting of the method getH2DataSource");
	DriverManagerDataSource dataSource = new DriverManagerDataSource();
	dataSource.setDriverClassName("org.h2.Driver");
	dataSource.setUrl("jdbc:h2:tcp://localhost/~/bookmanagementsystem");
	dataSource.setUsername("sa");
	dataSource.setPassword("@aakash");
	System.out.println("Data Source Creation");
	return dataSource;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Bean
@Override
public DataSource selectAnyDataSource() {
    try {
        setProperties();
        defaultDataSource = new DriverManagerDataSource();
        defaultDataSource.setUrl(url);
        defaultDataSource.setUsername(username);
        defaultDataSource.setPassword(password);
        defaultDataSource.setDriverClassName(driver);
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    System.out.println("select any :: base-multitenant-select-any");
    return defaultDataSource;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Before
@Ignore
public void setUp() {
    try {
        //TODO: should be rewritten.

        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName(Config.DRIVERCLASSNAME);
        dataSource.setUrl(Config.URL);
        dataSource.setUsername(Config.USERNAME);
        dataSource.setPassword(Config.PASSWORD);
        jdbc = new JdbcUserRepository(new JdbcTemplate(dataSource));
            //TODO: run creating scripts.
        Assert.assertTrue(true);
    } catch (Throwable throwable) {
        Assert.fail(throwable.getMessage());
    }
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Before
@Ignore
public void setUp() {
    try {
        //TODO: should be rewritten.

        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName(Config.DRIVERCLASSNAME);
        dataSource.setUrl(Config.URL);
        dataSource.setUsername(Config.USERNAME);
        dataSource.setPassword(Config.PASSWORD);
        jdbc = new JdbcCommodityRepository(new JdbcTemplate(dataSource));
        //TODO: run creating scripts.
        Assert.assertTrue(true);
    } catch (Throwable throwable) {
        Assert.fail(throwable.getMessage());
    }
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Bean(name = "rootDataSource")
public DataSource rootDataSource() {
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(environment.getRequiredProperty("jdbc.driverClassName"));
    dataSource.setUrl(environment.getRequiredProperty("jdbc.root.url"));
    dataSource.setUsername(environment.getRequiredProperty("jdbc.root.username"));
    dataSource.setPassword(environment.getRequiredProperty("jdbc.root.password"));
    return dataSource;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
public List<Map> getSqlSearchResult(String db, String sql) {
	DataSourceManager dataSourceManager = (DataSourceManager) ObjectLocator
			.lookup("dataSourceManager", CmsPlugin.PLUGIN_ID);
	List<Map> rs = new ArrayList<Map>();
	if (dataSourceManager != null) {
		try {
			DataSourceModel dsm = dataSourceManager.getDataSourceByName(db);
			DriverManagerDataSource dmd = new DriverManagerDataSource();
			dmd.setDriverClassName(dsm.getDriverClassName());
			dmd.setUrl(dsm.getUrl());
			dmd.setUsername(dsm.getUserName());
			dmd.setPassword(dsm.getPassword());
			BaseDaoSupport baseDao = new BaseDaoSupport();
			// 动态设置数据源
			baseDao.setDataSource(dmd);
			baseDao.setUseDataSourceDialect(true);
			rs = baseDao.getDBMapObjectList(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	return rs;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
private static void setupDriverManagerDataSource() throws NamingException{
	SimpleNamingContextBuilder builder = SimpleNamingContextBuilder
			.emptyActivatedContextBuilder();
	DriverManagerDataSource dataSource = new DriverManagerDataSource();
	dataSource.setDriverClassName(System.getProperty("usciitg.db.driver"));
	dataSource.setUrl(System.getProperty("usciitg.db"));
	dataSource.setUsername(System.getProperty("usciitg.db.user"));
	dataSource.setPassword(System.getProperty("usciitg.db.password"));

	builder.bind(System.getProperty("usciitg.datasource"), dataSource);	
}