1 package org.contineo.documan.dao; 2 3 import java.util.Collection ; 4 5 import org.apache.log4j.Level; 6 import org.apache.log4j.Logger; 7 import org.apache.ojb.broker.PBKey; 8 import org.apache.ojb.broker.PersistenceBroker; 9 import org.apache.ojb.broker.PersistenceBrokerFactory; 10 import org.apache.ojb.broker.query.Criteria; 11 import org.apache.ojb.broker.query.QueryByCriteria; 12 import org.contineo.core.LoggingManager; 13 import org.contineo.documan.Keywords; 14 15 19 public class KeywordDAO { 20 21 private PersistenceBroker broker = null; 22 private PBKey pbkey; 23 private Logger logger; 24 25 28 public KeywordDAO() { 29 logger = LoggingManager.getLogger(this.getClass()); 30 pbkey = new PBKey("contineo"); 31 } 32 33 37 public Collection findByDocId(int docid) { 38 Collection coll = null; 39 try { 40 broker = PersistenceBrokerFactory.createPersistenceBroker(pbkey); 41 Criteria crit = new Criteria(); 42 crit.addEqualTo("co_docid", new Integer (docid)); 43 QueryByCriteria query = new QueryByCriteria(org.contineo.documan.Keywords.class, crit); 44 query.addOrderBy("co_docid",true); 45 coll = broker.getCollectionByQuery(query); 46 } catch (Exception e) { 47 if (logger.isEnabledFor(Level.ERROR)) 48 logger.error(e.getMessage()); 49 } finally { 50 if (broker != null) broker.close(); 51 } 52 return coll; 53 } 54 55 59 public Collection <Keywords> findByFirstLetter(String letter, String username) { 60 Collection <Keywords> coll = null; 61 try { 62 broker = PersistenceBrokerFactory.createPersistenceBroker(pbkey); 63 DocumentDAO docDao = new DocumentDAO(); 64 Collection precoll = docDao.findByUserName(username); 65 if (precoll == null || precoll.size() == 0) 66 return null; 67 Criteria crit = new Criteria(); 68 crit.addIn("co_docid", precoll); 69 crit.addLike("co_keyword", letter + "%"); 70 QueryByCriteria query = new QueryByCriteria(org.contineo.documan.Keywords.class, crit); 71 query.addOrderBy("co_keyword", true); 72 coll = broker.getCollectionByQuery(query); 73 } catch (Exception e) { 74 if (logger.isEnabledFor(Level.ERROR)) 75 logger.error(e.getMessage()); 76 } finally { 77 if (broker != null) broker.close(); 78 } 79 return coll; 80 } 81 } 82
| Popular Tags
|