Java DriverManagerDataSource.setUsername方法代码示例

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包/类
/**
 * Creates and returns a new data source from the given connection information. Creates a new {@link DriverManagerDataSource}.
 *
 * @param jdbcConnection the JDBC connection
 * @param variables the optional map of key-value for expression evaluation
 *
 * @return a new {@link DataSource}
 */
private DataSource createDataSource(JdbcConnection jdbcConnection, Map<String, Object> variables)
{
    String url = evaluate(jdbcConnection.getUrl(), variables, "jdbc connection url");
    String username = evaluate(jdbcConnection.getUsername(), variables, "jdbc connection username");
    String password = evaluate(jdbcConnection.getPassword(), variables, "jdbc connection password");

    validateUrl(url);

    DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource();
    driverManagerDataSource.setUrl(url);
    driverManagerDataSource.setUsername(username);
    driverManagerDataSource.setPassword(password);
    driverManagerDataSource.setDriverClassName(getDriverClassName(jdbcConnection.getDatabaseType()));
    return driverManagerDataSource;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Bean(name = "dataSource")
public DataSource dataSource() {
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName(driverClassName);
    ds.setUrl(databaseUrl);

    Properties p = new Properties();
    Map<String, String> datasourceProperties = mapPropertyNames("datasource", hibernateConfiguration());
    p.putAll(datasourceProperties);
    ds.setConnectionProperties(p);
    if (!StringUtils.isEmpty(username)) {
        ds.setUsername(username);
    }
    if (!StringUtils.isEmpty(password)) {
        ds.setPassword(password);
    }
    return ds;
}
 

import org.springframework.jdbc.datasource.DriverManagerDataSource; //导入方法依赖的package包/类
@Before
public void setup() {
	DriverManagerDataSource dataSource = new DriverManagerDataSource();
	dataSource.setDriverClassName(DATASOURCE_DRIVER_CLASS_NAME);
	dataSource.setUrl(DATASOURCE_URL);
	dataSource.setUsername(DATASOURCE_USER_NAME);
	dataSource.setPassword(DATASOURCE_USER_PASSWORD);
	this.dataSource = dataSource;
	try {
		this.server = Server.createTcpServer("-tcp", "-tcpAllowOthers", "-tcpPort", String.valueOf(randomPort))
				.start();
	}
	catch (SQLException e) {
		throw new IllegalStateException(e);
	}
}
 

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包/类
@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);	
}