本文整理了Java中com.mysql.jdbc.jdbc2.optional.MysqlDataSource.<init>()
方法的一些代码示例,展示了MysqlDataSource.<init>()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。MysqlDataSource.<init>()
方法的具体详情如下:
包路径:com.mysql.jdbc.jdbc2.optional.MysqlDataSource
类名称:MysqlDataSource
方法名:<init>
暂无
代码示例来源:origin: prestodb/presto
@Inject
public MysqlDaoProvider(DbResourceGroupConfig config)
{
requireNonNull(config, "DbResourceGroupConfig is null");
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setURL(requireNonNull(config.getConfigDbUrl(), "resource-groups.config-db-url is null"));
this.dao = Jdbi.create(dataSource)
.installPlugin(new SqlObjectPlugin())
.onDemand(ResourceGroupsDao.class);
}
代码示例来源:origin: stackoverflow.com
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setUser("scott");
dataSource.setPassword("tiger");
dataSource.setServerName("myDBHost.example.org");
代码示例来源:origin: alibaba/nacos
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setConnectTimeout(CONNECT_TIMEOUT_MS);
dataSource.setSocketTimeout(CONNECT_TIMEOUT_MS);
代码示例来源:origin: killbill/killbill
private DataSource getRawMysqlDataSource(final String dbName, final String user, final String pwd) {
final com.mysql.jdbc.jdbc2.optional.MysqlDataSource rawSource = new com.mysql.jdbc.jdbc2.optional.MysqlDataSource();
rawSource.setDatabaseName(dbName);
rawSource.setUser(user);
rawSource.setPassword(pwd);
rawSource.setPort(3306);
rawSource.setURL("jdbc:mysql://localhost:3306/killbill?createDatabaseIfNotExist=true&allowMultiQueries=true");
return rawSource;
}
代码示例来源:origin: stackoverflow.com
public static void main(String[] args) throws Exception {
MysqlDataSource db = new MysqlDataSource();
db.setDatabaseName("test");
Connection conn = db.getConnection("test", "test");
ResultSet res = conn.prepareStatement("SELECT * FROM thing").executeQuery();
res.next();
System.out.println("Get a int as a string: " + res.getString("a_int"));
}
代码示例来源:origin: com.carrotsearch/junit-benchmarks
@Override
protected Connection createConnection() throws SQLException
{
final MysqlDataSource ds = new MysqlDataSource();
ds.setURL(dbUrl);
Connection results = ds.getConnection();
results.setAutoCommit(false);
return results;
}
代码示例来源:origin: stackoverflow.com
MysqlDataSource ds = new MysqlDataSource();
ds.setServerName("host");
ds.setUser("user");
ds.setPassword("password");
JdbcTemplate jdbcTemplate = new JdbcTemplate(ds);
BufferedReader in = new BufferedReader(new FileReader("script.sql"));
LineNumberReader fileReader = new LineNumberReader(in);
String query = JdbcTestUtils.readScript(fileReader);
代码示例来源:origin: org.scijava/junit-benchmarks
@Override
protected Connection createConnection() throws SQLException
{
final MysqlDataSource ds = new MysqlDataSource();
ds.setURL(dbUrl);
Connection results = ds.getConnection();
results.setAutoCommit(false);
return results;
}
代码示例来源:origin: stackoverflow.com
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setUser("scott");
dataSource.setPassword("tiger");
dataSource.setServerName("myDatabaseHost.example.org");
and then obtain connections from it, same as above:
Connection conn = dataSource.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT ID FROM USERS");
...
rs.close();
stmt.close();
conn.close();
代码示例来源:origin: io.prestosql/presto-resource-group-managers
@Inject
public MysqlDaoProvider(DbResourceGroupConfig config)
{
requireNonNull(config, "DbResourceGroupConfig is null");
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setURL(requireNonNull(config.getConfigDbUrl(), "resource-groups.config-db-url is null"));
this.dao = Jdbi.create(dataSource)
.installPlugin(new SqlObjectPlugin())
.onDemand(ResourceGroupsDao.class);
}
代码示例来源:origin: com.facebook.presto/presto-resource-group-managers
@Inject
public MysqlDaoProvider(DbResourceGroupConfig config)
{
requireNonNull(config, "DbResourceGroupConfig is null");
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setURL(requireNonNull(config.getConfigDbUrl(), "resource-groups.config-db-url is null"));
this.dao = Jdbi.create(dataSource)
.installPlugin(new SqlObjectPlugin())
.onDemand(ResourceGroupsDao.class);
}
代码示例来源:origin: prestosql/presto
@Inject
public MysqlDaoProvider(DbResourceGroupConfig config)
{
requireNonNull(config, "DbResourceGroupConfig is null");
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setURL(requireNonNull(config.getConfigDbUrl(), "resource-groups.config-db-url is null"));
this.dao = Jdbi.create(dataSource)
.installPlugin(new SqlObjectPlugin())
.onDemand(ResourceGroupsDao.class);
}
代码示例来源:origin: stackoverflow.com
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setDatabaseName("xyz");
dataSource.setUser("xyz");
dataSource.setPassword("xyz");
dataSource.setServerName("xyz.yourdomain.com");
代码示例来源:origin: com.ning.billing/killbill-osgi-bundles-analytics
@Override
public void initialize() throws IOException {
dataSource = new MysqlDataSource();
dataSource.setDatabaseName(databaseName);
dataSource.setUser(username);
dataSource.setPassword(password);
dataSource.setPort(port);
// See http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
dataSource.setURL(jdbcConnectionString);
}
代码示例来源:origin: stackoverflow.com
MysqlDataSource ds = new MysqlDataSource();
ds.setServerName(serverName);
ds.setDatabaseName(mydatabase);
ds.setUser(username);
ds.setPassword(password);
connection = ds.getConnection();
代码示例来源:origin: com.ning.billing.commons/killbill-embeddeddb
@Override
public void initialize() throws IOException {
dataSource = new MysqlDataSource();
dataSource.setDatabaseName(databaseName);
dataSource.setUser(username);
dataSource.setPassword(password);
dataSource.setPort(port);
// See http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
dataSource.setURL(jdbcConnectionString);
}
代码示例来源:origin: stackoverflow.com
MysqlDataSource ds = new MysqlDataSource();
ds.setDatabaseName("DATABASE");
ds.setUser("USERNAME");
ds.setPassword("USER PASSWORD");
ds.setServerName("localhost");
ds.setPort(3306);
connection = ds.getConnection();
代码示例来源:origin: stackoverflow.com
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setServerName("localhost");
dataSource.setDatabaseName("inventry");
dataSource.setPortNumber(3306);
dataSource.setUser("root");
dataSource.setPassword(""); // blank password is a terrible idea
Connection connection = dataSource.getConnection();
代码示例来源:origin: games647/LagMonitor
public Storage(Logger logger, String host, int port, String database, boolean usessl, String user, String pass, String prefix) {
this.logger = logger;
this.prefix = prefix;
this.dataSource = new MysqlDataSource();
this.dataSource.setUser(user);
this.dataSource.setPassword(pass);
this.dataSource.setServerName(host);
this.dataSource.setPort(port);
this.dataSource.setDatabaseName(database);
this.dataSource.setUseSSL(usessl);
}
代码示例来源:origin: org.kill-bill.billing/killbill-util
private DataSource getRawMysqlDataSource(final String dbName, final String user, final String pwd) {
final com.mysql.jdbc.jdbc2.optional.MysqlDataSource rawSource = new com.mysql.jdbc.jdbc2.optional.MysqlDataSource();
rawSource.setDatabaseName(dbName);
rawSource.setUser(user);
rawSource.setPassword(pwd);
rawSource.setPort(3306);
rawSource.setURL("jdbc:mysql://localhost:3306/killbill?createDatabaseIfNotExist=true&allowMultiQueries=true");
return rawSource;
}
内容来源于网络,如有侵权,请联系作者删除!