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
+ "%'");
}
public static ResultSet findByUrl(Database db, String url) throws Exception {
return db.query("select tmsp, url, body from page where url = '" + url + "'");
}
// finders
public static ResultSet findAll(Database db) throws Exception {
return db.query("select tmsp, url, body from page");
}