OQLQuery
460461462463464465466467468469470
{ Transaction tx = odmg.newTransaction(); tx.begin(); // retrieve an Article OQLQuery query = odmg.newOQLQuery(); query.create("select anArticle from " + Article.class.getName() + " where articleId = $678"); query.bind(new Integer(30)); List results = (List) query.execute(); Article a = (Article) results.get(0);
8788899091929394959697
// 1. Get a list of some articles Transaction tx = odmg.newTransaction(); tx.begin(); OQLQuery query = odmg.newOQLQuery(); String oql = "select allPersons from " + org.apache.ojb.broker.Person.class.getName(); query.create(oql); ManageableCollection allPersons =
145146147148149150151152153154155
// 3. Get a list of some articles Transaction tx = odmg.newTransaction(); tx.begin(); OQLQuery query = odmg.newOQLQuery(); String sql = "select allPersons from " + org.apache.ojb.broker.Person.class.getName(); query.create(sql);
208209210211212213214215216217218
// 3. Get a list of some articles Transaction tx = odmg.newTransaction(); tx.begin(); EnhancedOQLQuery query = odmg.newOQLQuery(); String sql = "select somePersons from " + org.apache.ojb.broker.Person.class.getName(); query.create(sql, start, end);
266267268269270271272273274275276
342343344345346347348349350351352
{ tx.commit(); return; } EnhancedOQLQuery query = odmg.newOQLQuery(); String sql = "select somePersons from " + org.apache.ojb.broker.Person.class.getName(); query.create(sql, start, end); ManageableCollection somePersons =
390391392393394395396397398399400
int end = 5; Transaction tx = odmg.newTransaction(); try { tx.begin(); EnhancedOQLQuery query = odmg.newOQLQuery(); String sql = "select somePersons from " + org.apache.ojb.broker.Person.class.getName(); query.create(sql, start, end); query.execute();
424425426427428429430431432433434
int end = 10; try { Transaction tx = odmg.newTransaction(); tx.begin(); EnhancedOQLQuery query = odmg.newOQLQuery(); String sql = "select somePersons from " + org.apache.ojb.broker.Person.class.getName(); query.create(sql, start, end); query.execute();
321322323324325326327328329330331
db.open(TestHelper.DEF_JCD_ALIAS + "#" + TestHelper.DEF_USER + "#" + TestHelper.DEF_PASSWORD, Database.OPEN_READ_WRITE); tx = odmg.newTransaction(); tx.begin(); OQLQuery query = odmg.newOQLQuery(); query.create(queryStr); query.execute(); tx.commit(); db.close();
331332333334335336337338339340341
db = odmg.newDatabase(); db.open(TestHelper.DEF_JCD_ALIAS, Database.OPEN_READ_WRITE); tx = odmg.newTransaction(); tx.begin(); OQLQuery query2 = odmg.newOQLQuery(); query2.create(queryStr); query2.execute(); tx.commit(); db.close(); }