MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setUser("scott"); dataSource.setPassword("tiger"); dataSource.setServerName("myDBHost.example.org");
dataSource.setLoginTimeout(1); dataSource.setServerName(ip.getIp()); dataSource.setPort(ip.getPort());
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);
MysqlDataSource ds = new MysqlDataSource(); ds.setServerName("hostname"); ds.setUser("username"); 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);
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();
MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setUser(user); dataSource.setPassword(password); dataSource.setServerName(server); dataSource.setDatabaseName(database); Connection conn = dataSource.getConnection(); PreparedStatement stmt = conn.prepareStatement("INSERT INTO table (name, grade, age) VALUES (?, ?, ?)"); ...then while going throug the XML: stmt.setString(1, name); stmt.setString(2, grade); stmt.setString(3, age); stmt.execute(); ...at the end: stmt.close(); conn.commit(); conn.close()
private void setProperties(MysqlDataSource ds, Properties properties) throws SQLException { Properties props = (Properties) properties.clone(); String url = (String) props.remove(DataSourceFactory.JDBC_URL); if (url != null) { ds.setUrl(url); } String databaseName = (String) props.remove(DataSourceFactory.JDBC_DATABASE_NAME); if (databaseName == null && url == null) { throw new SQLException("missing required property " + DataSourceFactory.JDBC_DATABASE_NAME); } ds.setDatabaseName(databaseName); String password = (String) props.remove(DataSourceFactory.JDBC_PASSWORD); ds.setPassword(password); String portNumber = (String) props.remove(DataSourceFactory.JDBC_PORT_NUMBER); if (portNumber != null) { ds.setPortNumber(Integer.parseInt(portNumber)); } String serverName = (String) props.remove(DataSourceFactory.JDBC_SERVER_NAME); ds.setServerName(serverName); String user = (String) props.remove(DataSourceFactory.JDBC_USER); ds.setUser(user); if (!props.isEmpty()) { BeanConfig.configure(ds, props); } }
MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setDatabaseName("xyz"); dataSource.setUser("xyz"); dataSource.setPassword("xyz"); dataSource.setServerName("xyz.yourdomain.com");
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(); } } }
MysqlDataSource ds = new MysqlDataSource(); ds.setServerName(serverName); ds.setDatabaseName(mydatabase); ds.setUser(username); ds.setPassword(password); connection = ds.getConnection();
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();
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();
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); }
public class MySqlConnect { public static Connection connectToDB() { try { MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setServerName("localhost"); dataSource.setDatabaseName("auto_lube"); dataSource.setPortNumber(3306); dataSource.setUser("root"); dataSource.setPassword("mehar"); Connection conn = dataSource.getConnection(); JOptionPane.showMessageDialog(null, "Connection established"); // better log this message return conn; } catch (Exception e) { JOptionPane.showMessageDialog(null, e); // better log the exception return null; } } }
mysqlDS.setTrustCertificateKeyStorePassword("truststore-pw"); mysqlDS.setServerName("server"); mysqlDS.setPort(3306); mysqlDS.setDatabaseName("databasename");