Java MysqlDataSource类代码示例

import com.mysql.cj.jdbc.MysqlDataSource; //导入依赖的package包/类
public SQLDatabase() {
	dataSource = new MysqlDataSource();
	dataSource.setDatabaseName("mantarologs");
	dataSource.setUser("root");
	dataSource.setPassword(MantaroData.config().get().getSqlPassword());
	dataSource.setServerName("localhost");
	dataSource.setURL(dataSource.getURL() + "?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&autoReconnect=true&useSSL=false");
}
 

import com.mysql.cj.jdbc.MysqlDataSource; //导入依赖的package包/类
public static void main(String[] args) throws SQLException {
    MysqlDataSource mysqlDataSource = new MysqlDataSource();
    mysqlDataSource.setPassword("moco");
    mysqlDataSource.setUser("moco");
    mysqlDataSource.setURL("jdbc:mysql://localhost:3306/moco");
    Database.initialize(new MocoConfig.Builder(DataSourceSelector.single(mysqlDataSource), DatabaseType.MYSQL).build());

    List<User> result = Users.select()
            .where(
                    Users.ID_CO.in(1, 2),
                    Users.NAME_CO.in("orekyuu", "jails")
            ).result();
    User user = result.get(1);
    System.out.println(user.owner.get().get().name);
    System.out.println(user.owner.get().get().name);
}
 

import com.mysql.cj.jdbc.MysqlDataSource; //导入依赖的package包/类
/**
 * https://github.com/brettwooldridge/HikariCP/wiki/MySQL-Configuration
 */
private void initDataSource() {
    MysqlDataSource ds = new MysqlDataSource();

    // set standard params
    ds.setServerName(CONFIG.getDb().getIp());
    ds.setPort(CONFIG.getDb().getPort());
    ds.setDatabaseName(CONFIG.getDb().getSchema());
    ds.setUser(CONFIG.getDb().getUserName());
    ds.setPassword(CONFIG.getDb().getPassword());

    // set non-standard params
    ds.getModifiableProperty(PropertyDefinitions.PNAME_cachePrepStmts).setValue(true);
    ds.getModifiableProperty(PropertyDefinitions.PNAME_prepStmtCacheSize).setValue(250);
    ds.getModifiableProperty(PropertyDefinitions.PNAME_prepStmtCacheSqlLimit).setValue(2048);
    ds.getModifiableProperty(PropertyDefinitions.PNAME_characterEncoding).setValue("utf8");
    ds.getModifiableProperty(PropertyDefinitions.PNAME_serverTimezone).setValue("UTC");

    HikariConfig hc = new HikariConfig();
    hc.setDataSource(ds);

    dataSource = new HikariDataSource(hc);
}
 

import com.mysql.cj.jdbc.MysqlDataSource; //导入依赖的package包/类
/**
 * Set's up a MySQL dataSource so that you can run {@link SQLController#runSqlTask(SQLTask)}
 * @param user MySQL User
 * @param password MySQL user password
 * @param serverName Server name
 * @param dbName Database name
 */
public void setupMySQL(String user, String password, String serverName, String dbName){
    MysqlDataSource dataSource = new MysqlDataSource();
    dataSource.setUser(user);
    dataSource.setPassword(password);
    dataSource.setDatabaseName(dbName);
    dataSource.setServerName(serverName);
    dataSource.setPort(3306);
    dataSource.setPortNumber(3306);
    dataSource.setURL(dataSource.getURL() + "?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&autoReconnect=true&useSSL=false");
    dataSource.setUrl(dataSource.getUrl() + "?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&autoReconnect=true&useSSL=false");
    SQLController.setDataSource(dataSource);
}
 

import com.mysql.cj.jdbc.MysqlDataSource; //导入依赖的package包/类
@Parameters(name = "{index}:{0}")
public static Collection<DataSource> getDataSources() {
    List<DataSource> dataSources = new ArrayList<>();

    dataSources.add(newH2DataSource());

    // MySQL
    if (HekateTestProps.is("MYSQL_ENABLED")) {
        MysqlDataSource mysql = new MysqlDataSource();

        mysql.setURL(HekateTestProps.get("MYSQL_URL"));
        mysql.setUser(HekateTestProps.get("MYSQL_USER"));
        mysql.setPassword(HekateTestProps.get("MYSQL_PASSWORD"));

        dataSources.add(mysql);
    }

    // PostgreSQL
    if (HekateTestProps.is("POSTGRES_ENABLED")) {
        PGSimpleDataSource postgres = new PGSimpleDataSource();

        postgres.setUrl(HekateTestProps.get("POSTGRES_URL"));
        postgres.setUser(HekateTestProps.get("POSTGRES_USER"));
        postgres.setPassword(HekateTestProps.get("POSTGRES_PASSWORD"));

        dataSources.add(postgres);
    }

    return dataSources;
}
 

import com.mysql.cj.jdbc.MysqlDataSource; //导入依赖的package包/类
@BeforeAll
public static void init() {
    MysqlDataSource mysqlDataSource = new MysqlDataSource();
    mysqlDataSource.setPassword("moco");
    mysqlDataSource.setUser("moco");
    mysqlDataSource.setURL("jdbc:mysql://localhost:3306/moco");
    Database.initialize(new MocoConfig.Builder(DataSourceSelector.single(mysqlDataSource), DatabaseType.MYSQL).build());
}
 

import com.mysql.cj.jdbc.MysqlDataSource; //导入依赖的package包/类
private DataSource createSingle()  {
	final MysqlDataSource dataSource = new MysqlDataSource();

	dataSource.setURL(createURL());
	dataSource.setUser(null == user ? "extract" : user);
	dataSource.setPassword(password);

	dataSource.initializeProperties(createProperties());

	return dataSource;
}
 

import com.mysql.cj.jdbc.MysqlDataSource; //导入依赖的package包/类
protected static void setDataSource(MysqlDataSource source){
    dataSource = source;
}