Java MysqlDataSource.setUrl方法代码示例

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
/**
 * Tests fix for BUG#16791 - NullPointerException in MysqlDataSourceFactory
 * due to Reference containing RefAddrs with null content.
 * 
 * @throws Exception
 *             if the test fails
 */
public void testBug16791() throws Exception {
    MysqlDataSource myDs = new MysqlDataSource();
    myDs.setUrl(dbUrl);
    Reference asRef = myDs.getReference();
    System.out.println(asRef);

    removeFromRef(asRef, "port");
    removeFromRef(asRef, NonRegisteringDriver.USER_PROPERTY_KEY);
    removeFromRef(asRef, NonRegisteringDriver.PASSWORD_PROPERTY_KEY);
    removeFromRef(asRef, "serverName");
    removeFromRef(asRef, "databaseName");

    //MysqlDataSource newDs = (MysqlDataSource)
    new MysqlDataSourceFactory().getObjectInstance(asRef, null, null, null);
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
@BeforeClass
public static void beforeClass() throws Exception{
    initializeTestEnv();
    
    final int sleepCount = 30;
    
    LOGGER.debug("sleep " + sleepCount + "sec for generating enough test data");
    for(int i=1; i<=sleepCount; i++){
        LOGGER.debug(i + "/" + sleepCount);
        Thread.sleep(1000);
    }
    
    // create dataSource
    dataSource = new MysqlDataSource();
    dataSource.setUrl(DB_URL);
    dataSource.setUser(DB_USER);
    dataSource.setPassword(DB_PW);
    
    
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
public static Connection getConnection() {
    if(url==null||user==null||password==null){
        initData();
    }
    try {
        if (conn == null || conn.isClosed()) {
            MysqlDataSource ds_mysql = new MysqlDataSource();
            ds_mysql.setUrl(url);// 设置连接字符串
            conn = ds_mysql.getConnection(user, password);
            return conn;
        }
    } catch (SQLException e) {
        System.out.println("连接JDBC出错!");
        e.printStackTrace();
        return null;
    }
    return conn;
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
/**
 * Tests fix for BUG#16791 - NullPointerException in MysqlDataSourceFactory
 * due to Reference containing RefAddrs with null content.
 * 
 * @throws Exception if the test fails
 */
public void testBug16791() throws Exception {
	MysqlDataSource myDs = new MysqlDataSource();
	myDs.setUrl(dbUrl);
	Reference asRef = myDs.getReference();
	System.out.println(asRef);
	
	removeFromRef(asRef, "port");
	removeFromRef(asRef, NonRegisteringDriver.USER_PROPERTY_KEY);
	removeFromRef(asRef, NonRegisteringDriver.PASSWORD_PROPERTY_KEY);
	removeFromRef(asRef, "serverName");
	removeFromRef(asRef, "databaseName");
	
	//MysqlDataSource newDs = (MysqlDataSource)
	new MysqlDataSourceFactory().getObjectInstance(asRef, null, null, null);
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
@Before
public void setUpService() {
    MockitoAnnotations.initMocks(this);
    CaArrayUsernameHolder.setUser(STANDARD_USER);
    final ProjectManagementServiceBean pmsBean = new ProjectManagementServiceBean();

    pmsBean.setProjectDao(this.daoFactoryStub.getProjectDao());
    pmsBean.setFileDao(fileDao);
    pmsBean.setSampleDao(this.daoFactoryStub.getSampleDao());
    pmsBean.setSearchDao(this.daoFactoryStub.getSearchDao());
    pmsBean.setVocabularyDao(this.daoFactoryStub.getVocabularyDao());

    locatorStub = ServiceLocatorStub.registerEmptyLocator();
    locatorStub.addLookup(FileAccessService.JNDI_NAME, this.fileAccessServiceStub);
    locatorStub.addLookup(GenericDataService.JNDI_NAME, this.genericDataService);
    final MysqlDataSource ds = new MysqlDataSource();
    final Configuration config = hibernateHelper.getConfiguration();
    ds.setUrl(config.getProperty("hibernate.connection.url"));
    ds.setUser(config.getProperty("hibernate.connection.username"));
    ds.setPassword(config.getProperty("hibernate.connection.password"));
    locatorStub.addLookup("java:jdbc/CaArrayDataSource", ds);
    this.projectManagementService = pmsBean;
    locatorStub.addLookup(ProjectManagementService.JNDI_NAME, this.projectManagementService);
    hibernateHelper.setFiltersEnabled(false);
    this.transaction = hibernateHelper.beginTransaction();
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
private PermissionsManagementService createPermissionsManagementService(GenericDataService genericDataServiceStub) {
    final CaArrayDaoFactory daoFactory = CaArrayDaoFactory.INSTANCE;
    final PermissionsManagementServiceBean bean = new PermissionsManagementServiceBean();
    bean.setHibernateHelper(this.hibernateHelper);
    bean.setCollaboratorGroupDao(daoFactory.getCollaboratorGroupDao());
    bean.setSearchDao(daoFactory.getSearchDao());

    final ServiceLocatorStub locatorStub = ServiceLocatorStub.registerEmptyLocator();
    locatorStub.addLookup(GenericDataService.JNDI_NAME, genericDataServiceStub);
    final MysqlDataSource ds = new MysqlDataSource();
    final Configuration config = this.hibernateHelper.getConfiguration();
    ds.setUrl(config.getProperty("hibernate.connection.url"));
    ds.setUser(config.getProperty("hibernate.connection.username"));
    ds.setPassword(config.getProperty("hibernate.connection.password"));
    locatorStub.addLookup("java:jdbc/CaArrayDataSource", ds);
    bean.setGenericDataService(genericDataServiceStub);

    return bean;
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
public void testBug42267() throws Exception {
    MysqlDataSource ds = new MysqlDataSource();
    ds.setUrl(dbUrl);
    Connection c = ds.getConnection();
    String query = "select 1,2,345";
    PreparedStatement ps = c.prepareStatement(query);
    String psString = ps.toString();
    assertTrue("String representation of wrapped ps should contain query string", psString.endsWith(": " + query));
    ps.close();
    ps.toString();
    c.close();
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
/**
 * Tests fix for Bug#72632 - NullPointerException for invalid JDBC URL.
 */
public void testBug72632() throws Exception {
    final MysqlDataSource dataSource = new MysqlDataSource();
    dataSource.setUrl("bad-connection-string");
    assertThrows(SQLException.class, "Failed to get a connection using the URL 'bad-connection-string'.", new Callable<Void>() {
        public Void call() throws Exception {
            dataSource.getConnection();
            return null;
        }
    });
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
public static void main(String[] args) {

		// Define connection to the server
		MysqlDataSource dataSource = new MysqlDataSource(); // If you are not using MySQL, use different DataSource
		dataSource.setUrl("jdbc:mysql://relational.fit.cvut.cz"); // Public read-only database for testing
		dataSource.setUser("guest");
		dataSource.setPassword("relational");

		// Which database to analyse
		String databaseName = "mutagenesis"; // Another database to try: financial
		String schemaName = ""; // Always empty for MySQL databases

		// Connect to the database
		try (Connection connection = dataSource.getConnection()){

			// Estimate the PK and FK
			List<Table> tables = Schema.getPrimaryKeys(connection, databaseName, schemaName);
			tables = Optimization.optimize(tables);
			List<Relationship> relationships = Schema.getRelationships(connection, databaseName, schemaName, tables, false);
			OptimizationRelationship.optimize(relationships, tables);
			List<CompoundRelationship> compoundRelationships = CompoundRelationship.buildFrom(relationships);

			// Print the estimated PK and FK with the defined quote characters
			System.out.println("Estimated primary keys follow: ");
			System.out.println(SQL.getPkQuery(tables, '`', '`'));
			System.out.println("Estimated foreign key constraints follow: ");
			System.out.println(SQL.getFkQuery(compoundRelationships, '`', '`'));
		} catch (SQLException | InterruptedException e) {
			e.printStackTrace();
		}
	}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
private void run() throws IOException, SQLException {
    MysqlDataSource dataSource = new MysqlDataSource();
    dataSource.setUrl("jdbc:mysql://" + host + ":" + port + "/" + database);
    dataSource.setUser(username);
    dataSource.setPassword(password);

    try (FileInputStream inputStream = new FileInputStream(file)) {
        ScriptRunner runner = new ScriptRunner(dataSource.getConnection());
        runner.setAutoCommit(true);
        runner.setStopOnError(true);
        runner.runScript(new InputStreamReader(inputStream));
        runner.closeConnection();
    }
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
public static Connection getConnection(String url, String username, String password) throws SQLException{
    MysqlDataSource ds = new MysqlDataSource();
    ds.setUrl(url);
    ds.setUser(username);
    ds.setPassword(password);
    return ds.getConnection();
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
/**
 * When the application is run in Tomcat this method MUST NOT be used, because then the data source is
 * automatically retrieved from the context. If we run the applications as stand alone, then we have to
 * initialize the data source ourselves. In the latter case this method should be used.
 * @param jdbcURL the database url
 * @param dbLoginName the login for the database
 * @param dbUserPassword the pasword for the database
 * @param db the database XCURE_CHAT_DB or XCURE_HOSTIP_DB
 * @throws Exception if the database is not recognized.
 */
public static void initializeDataSource( final String jdbcURL, final String dbLoginName,
										 final String dbUserPassword, final byte db ) throws Exception {
	MysqlDataSource dataSource = new MysqlDataSource();
	dataSource.setUrl ( jdbcURL );
	dataSource.setUser( dbLoginName );
	dataSource.setPassword( dbUserPassword );
	switch( db ) {
		case XCURE_CHAT_DB: xcureChatDataSource = dataSource; break;
		case XCURE_HOSTIP_DB: xcureHostipDataSource = dataSource; break;
		default:
			throw new Exception("Unknown DB = " + db + " should be either XCURE_CHAT_DB("+XCURE_CHAT_DB+") or XCURE_HOSTIP_DB("+XCURE_HOSTIP_DB+")");
	}
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
public void testBug42267() throws Exception {
	MysqlDataSource ds = new MysqlDataSource();
	ds.setUrl(dbUrl);
	Connection conn = ds.getConnection();
	String query = "select 1,2,345";
	PreparedStatement ps = conn.prepareStatement(query);
	String psString = ps.toString();
	assertTrue("String representation of wrapped ps should contain query string", psString.endsWith(": " + query));
	ps.close();
	ps.toString();
	conn.close();
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
private static DataSource getAdhocDataSource() {
    MysqlDataSource ds = new MysqlDataSource();
    Configuration config = hibernateHelper.getConfiguration();
    ds.setUrl(config.getProperty(Environment.URL));
    ds.setUser(config.getProperty(Environment.USER));
    ds.setPassword(config.getProperty(Environment.PASS));
    return ds;
}
 

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //导入方法依赖的package包/类
private ProjectManagementService createProjectManagementService(final FileAccessServiceStub fileAccessServiceStub) {
    final CaArrayDaoFactory daoFactory = CaArrayDaoFactory.INSTANCE;

    final GenericDataServiceBean genericDataServiceBean = new GenericDataServiceBean();
    genericDataServiceBean.setProjectDao(daoFactory.getProjectDao());
    genericDataServiceBean.setSearchDao(daoFactory.getSearchDao());
    this.genericDataService = genericDataServiceBean;

    final ProjectManagementServiceBean bean = new ProjectManagementServiceBean();
    bean.setProjectDao(daoFactory.getProjectDao());
    bean.setFileDao(daoFactory.getFileDao());
    bean.setSampleDao(daoFactory.getSampleDao());
    bean.setSearchDao(daoFactory.getSearchDao());
    bean.setVocabularyDao(daoFactory.getVocabularyDao());

    final ServiceLocatorStub locatorStub = ServiceLocatorStub.registerEmptyLocator();
    locatorStub.addLookup(FileAccessService.JNDI_NAME, fileAccessServiceStub);
    locatorStub.addLookup(GenericDataService.JNDI_NAME, this.genericDataService);
    final MysqlDataSource ds = new MysqlDataSource();
    final Configuration config = this.hibernateHelper.getConfiguration();
    ds.setUrl(config.getProperty("hibernate.connection.url"));
    ds.setUser(config.getProperty("hibernate.connection.username"));
    ds.setPassword(config.getProperty("hibernate.connection.password"));
    locatorStub.addLookup("java:jdbc/CaArrayDataSource", ds);

    return bean;
}