本文整理汇总了Java中com.mysql.cj.jdbc.MysqlDataSource.setURL方法的典型用法代码示例。如果您正苦于以下问题:Java MysqlDataSource.setURL方法的具体用法?Java MysqlDataSource.setURL怎么用?Java MysqlDataSource.setURL使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类com.mysql.cj.jdbc.MysqlDataSource
的用法示例。
在下文中一共展示了MysqlDataSource.setURL方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: SQLDatabase
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");
}
示例2: main
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);
}
示例3: setupMySQL
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);
}
示例4: getDataSources
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;
}
示例5: init
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());
}
示例6: createSingle
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;
}