dataSource.setPort(ip.getPort()); connection = dataSource.getConnection(); CONNECTION_POOL.put(key, connection);
import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; //... MysqlDataSource mysql = (MysqlDataSource) context.lookup("jdbc/MySQLDataSource"); mysql.setRewriteBatchedStatements(true); Connection conn = mysql.getConnection();
public void saveTps(float tps) { try (Connection con = dataSource.getConnection(); PreparedStatement stmt = con.prepareStatement("INSERT INTO " + prefix + TPS_TABLE + " (tps) VALUES (?)")) { stmt.setFloat(1, tps); stmt.execute(); } catch (SQLException sqlEx) { logger.log(Level.SEVERE, "Error saving tps to database", sqlEx); logger.log(Level.SEVERE, "Using this data {0}", new Object[]{tps}); } } }
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")); }
@Override protected Connection createConnection() throws SQLException { final MysqlDataSource ds = new MysqlDataSource(); ds.setURL(dbUrl); Connection results = ds.getConnection(); results.setAutoCommit(false); return results; }
@Override protected Connection createConnection() throws SQLException { final MysqlDataSource ds = new MysqlDataSource(); ds.setURL(dbUrl); Connection results = ds.getConnection(); results.setAutoCommit(false); return results; }
public void savePlayers(Collection<PlayerData> playerData) { if (playerData.isEmpty()) { return; } try (Connection con = dataSource.getConnection(); PreparedStatement stmt = con.prepareStatement("INSERT INTO " + prefix + PLAYERS_TABLE + " (world_id, uuid, name, ping) " + "VALUES (?, ?, ?, ?)")) { for (PlayerData data : playerData) { stmt.setInt(1, data.getWorldId()); stmt.setString(2, data.getUuid().toString()); stmt.setString(3, data.getPlayerName()); stmt.setInt(4, data.getPing()); stmt.addBatch(); } stmt.executeBatch(); } catch (SQLException sqlEx) { logger.log(Level.SEVERE, "Error saving player data to database", sqlEx); logger.log(Level.SEVERE, "Using this data {0}", playerData); } }
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()
protected void connect() { try { MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setURL(url); dataSource.setPassword(password); dataSource.setUser(userName); connection = dataSource.getConnection(); connection.setAutoCommit(true); closed = false; totalConnectionOpen++; } catch (SQLException sqlException) { this.closed = true; connection = null; handle("Unable to connect", sqlException); } }
protected void connect() { try { MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setURL(url); dataSource.setPassword(password); dataSource.setUser(userName); connection = dataSource.getConnection(); connection.setAutoCommit(true); closed = false; totalConnectionOpen++; } catch (SQLException sqlException) { this.closed = true; connection = null; handle("Unable to connect", sqlException); } }
protected void connect() { try { MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setURL(url); dataSource.setPassword(password); dataSource.setUser(userName); connection = dataSource.getConnection(); connection.setAutoCommit(true); closed = false; totalConnectionOpen++; } catch (SQLException sqlException) { this.closed = true; connection = null; handle("Unable to connect", sqlException); } }
/** * Connects to the DB and tracks if successful so upstream stuff can try to reconnect. */ protected void connect() { try { MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setURL(url); dataSource.setPassword(password); dataSource.setUser(userName); connection = dataSource.getConnection(); connection.setAutoCommit(true); closed = false; totalConnectionOpen++; } catch (SQLException sqlException) { this.closed = true; connection = null; handle("Unable to connect", sqlException); } }
/** * Connects to the DB and tracks if successful so upstream stuff can try to reconnect. */ protected void connect() { try { MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setURL(url); dataSource.setPassword(password); dataSource.setUser(userName); connection = dataSource.getConnection(); connection.setAutoCommit(true); closed = false; totalConnectionOpen++; } catch (SQLException sqlException) { this.closed = true; connection = null; handle("Unable to connect", sqlException); } }
/** * Connects to the DB and tracks if successful so upstream stuff can try to reconnect. */ protected void connect() { try { MysqlDataSource dataSource = new MysqlDataSource(); dataSource.setURL(url); dataSource.setPassword(password); dataSource.setUser(userName); connection = dataSource.getConnection(); connection.setAutoCommit(true); closed = false; totalConnectionOpen++; } catch (SQLException sqlException) { this.closed = true; connection = null; handle("Unable to connect", sqlException); } }
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 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();
MysqlDataSource ds = new MysqlDataSource(); ds.setServerName("localhost"); ds.setPort("3306"); ds.setDatabaseName("testdb"); ds.setUser("root"); ds.setPassword(""); Connection connection = ds.getConnection();
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; } } }