Java Database.query Examples

Example #1

File: Page.java Project: mateusbpontes/scc263

 public static ResultSet findByQuery(Database db, String query) throws Exception {
   return db.query(
       "select tmsp, url, body from page where url like '%"
           + query
           + "%' or body like '%"
           + query
           + "%'");
 }

Example #2

File: Page.java Project: mateusbpontes/scc263

 public static ResultSet findByUrl(Database db, String url) throws Exception {
   return db.query("select tmsp, url, body from page where url = '" + url + "'");
 }

Example #3

File: Page.java Project: mateusbpontes/scc263

 // finders
 public static ResultSet findAll(Database db) throws Exception {
   return db.query("select tmsp, url, body from page");
 }