public class GetTweets {
    public GetTweets(MysqlDB database) {
        this.database = database;
    }

    private final MysqlDB database;

    public static void main(String[] args) throws SQLException {
        Connection conn = DriverManager.getConnection(
            "jdbc:mysql://domU-12-31-38-00-8E-18.compute-1.internal/daphnie",
            "daph_admin",
            "gU3:35"
        );
        try {
            MysqlDB database = new MysqlDB(conn);
            GetTweets getTweets = new GetTweets(database);
            getTweets.run(args);
        } finally {
            conn.close();
        }
    }

    public void run() {
        ResultSet brands = database.getSearchNames();
        try {
            while(brands.next()) {
                String brand_name = brands.getString("name");
                System.out.println(brand_name);
            }
        } catch (SQLException e) {
            System.out.println("Query Error " + e);
        } finally {
            brands.close();
        }
    }
}

public class MysqlDB {
        public MysqlDB(Connection connection) {
            this.connection = connection;
        }

        public ResultSet getSearchNames() throws SQLException {
            // Not perfect: no finally block for stmt.
            Statement stmt = conn.createStatement();
            return stmt.executeQuery("SELECT name from brands");
        }

    }