dataSource.setPort(ip.getPort());
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; }
import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; public class SignalDB { private static MysqlDataSource ds = null; public static MysqlDataSource getDataSource(String db_name) { if (ds == null) { // db variables set here getDataSource(db_url, db_user, db_password, db_port); } ds.setDatabaseName(db_name); return ds; } private static void getDataSource(String db_url, String db_user, String db_password, int db_port) { try { ds = new MysqlDataSource(); ds.setServerName(db_url); ds.setUser(db_user); ds.setPassword(db_password); ds.setPort(db_port); } catch (Exception e) { System.out.println("MysqlDataSource err: " + e.getMessage()); e.printStackTrace(); } } }
@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); }
@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); }
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); }
MysqlDataSource ds = new MysqlDataSource(); ds.setDatabaseName("DATABASE"); ds.setUser("USERNAME"); ds.setPassword("USER PASSWORD"); ds.setServerName("localhost"); ds.setPort(3306); connection = ds.getConnection();
MysqlDataSource ds = new MysqlDataSource(); ds.setServerName("localhost"); ds.setPort("3306"); ds.setDatabaseName("testdb"); ds.setUser("root"); ds.setPassword(""); Connection connection = ds.getConnection();
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; }
mysqlDS.setPort(3306); mysqlDS.setDatabaseName("databasename");