本文整理汇总了Java中com.mysql.cj.jdbc.MysqlDataSource类的典型用法代码示例。如果您正苦于以下问题:Java MysqlDataSource类的具体用法?Java MysqlDataSource怎么用?Java MysqlDataSource使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
MysqlDataSource类属于com.mysql.cj.jdbc包,在下文中一共展示了MysqlDataSource类的8个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的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");
}
开发者ID:Mantaro,项目名称:MantaroRPG,代码行数:9,代码来源:SQLDatabase.java
示例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);
}
开发者ID:orekyuu,项目名称:Moco,代码行数:17,代码来源:Sample.java
示例3: initDataSource
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);
}
开发者ID:RWTH-i5-IDSG,项目名称:steve-plugsurfing,代码行数:26,代码来源:BeanConfiguration.java
示例4: 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);
}
开发者ID:WalshyDev,项目名称:JBA,代码行数:20,代码来源:JBA.java
示例5: 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;
}
开发者ID:hekate-io,项目名称:hekate,代码行数:31,代码来源:JdbcSeedNodeProviderTest.java
示例6: 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());
}
开发者ID:orekyuu,项目名称:Moco,代码行数:9,代码来源:QueryTestBase.java
示例7: 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;
}
开发者ID:ICIJ,项目名称:extract,代码行数:12,代码来源:DataSourceFactory.java
示例8: setDataSource
import com.mysql.cj.jdbc.MysqlDataSource; //导入依赖的package包/类
protected static void setDataSource(MysqlDataSource source){
dataSource = source;
}
开发者ID:WalshyDev,项目名称:JBA,代码行数:4,代码来源:SQLController.java
注:本文中的com.mysql.cj.jdbc.MysqlDataSource类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论