mysql> SELECT artist,song,book_title,page_num FROM content WHERE artist LIKE "%b
lue oyster cult%";
+------------------+-----------------------+------------------------------------
+----------+
| artist           | song                  | book_title
| page_num |
+------------------+-----------------------+------------------------------------
+----------+
| Blue Oyster Cult | Don t Fear the Reaper | Guitar Tab White Pages Vol 1
|      210 |
| Blue Oyster Cult | Godzilla              | Guitar Tab White Pages Vol 1
|      271 |
| Blue Oyster cult | Burning for you       | Guitar Tab White Pages Vol 3
|      193 |
| Blue Oyster Cult | Burning for You       | The Greatest Rock Guitar Fake Book
|       48 |
| Blue Oyster Cult | Dont Fear the Reaper  | The Greatest Rock Guitar Fake Book
|       97 |
+------------------+-----------------------+------------------------------------
+----------+
5 rows in set (0.02 sec)
 
mysql>

@Action
    public Task search() {
       return new SearchTask(getApplication());
    }
 
    private class SearchTask extends Task {
        private String searchQuery;
        private List searchList;
 
 
        SearchTask(org.jdesktop.application.Application app) {
            super(app);
 
        searchList = org.jdesktop.observablecollections.ObservableCollections.observableList(query.getResultList());
 
        }
        //public <PropertyType> get<PropertyName>();
 
 
        @Override protected Void doInBackground() {
            try {
                setProgress(0, 0, 4);
                setMessage("Rolling back the current changes...");
                setProgress(1, 0, 4);
                entityManager.getTransaction().rollback();
                Thread.sleep(1000L); // remove for real app
                setProgress(2, 0, 4);
 
                setMessage("Starting a new transaction...");
                entityManager.getTransaction().begin();
                Thread.sleep(500L); // remove for real app
                setProgress(3, 0, 4);
 
                setMessage("Fetching new data...");
                java.util.Collection data = query.getResultList();
                Thread.sleep(1300L); // remove for real app
                setProgress(4, 0, 4);
 
                Thread.sleep(150L); // remove for real app
                searchList.clear();
                searchList.addAll(data);
            } catch(InterruptedException ignore) { }
            return null;
        }

Connection con = DriverManager.getConnection(url, "Fernanda", "J8");
 
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                     ResultSet.CONCUR_READ_ONLY);
ResultSet srs = stmt.executeQuery("SELECT COF_NAME, PRICE FROM COFFEES");
 
WHILE(rst.next())
 
ResultSet srs = stmt.executeQuery("select COF_Name from COFFEES " +
"where price = 7.99");
srs.next();

entityManager = javax.persistence.Persistence.createEntityManagerFactory("splashbookdbPU").createEntityManager();
        org.jdesktop.application.ResourceMap resourceMap = org.jdesktop.application.Application.getInstance(splashapp.SplashApp.class).getContext().getResourceMap(SplashView.class);
        query = entityManager.createQuery(resourceMap.getString("query.query")); // NOI18N
        list = org.jdesktop.observablecollections.ObservableCollections.observableList(query.getResultList());