OJB中的多条件查询

1. /*
2.  *  (non-doc)
3.  * @see org.pie.vls.Application.VLSBase#init()
4.  */
5. public void init() {
6.     try {
7.         broker = PersistenceBrokerFactory.defaultPersistenceBroker();
8.         broker.clearCache();
10.         //general criteria, with all the query condition
11.         Criteria crit = new Criteria();
12.         Criteria crit1 = null;
13.         List criteriaList = new Vector();
14.         //if the reservation id is not 0
15.         if (resvID > 0) {
16.             crit.addNotEqualTo("resvID", new Integer(this.resvID));
17.         }
19.         Iterator iter = this.reservationTimeslotList.iterator();
20.         while (iter.hasNext()) {
21.             //logger.debug ("TIMESLOT -----");
22.             ReservationTimeslot reservationTimeslot = (ReservationTimeslot) iter.next();
23.             /**
24.              * set the query condition list
25.              * start and end
26.              */
27.             startTimeUTC = reservationTimeslot.getStartDateTimeUTC();
28.             endTimeUTC = reservationTimeslot.getEndDateTimeUTC();
29.             if (this.selectType == Constants.BETWEEN_RESERVATIONS) {
30.                 crit1 = new Criteria();
31.                 //logger.debug ("BETWEEN " + startTimeUTC + " " + endTimeUTC);
32.                 crit1.addBetween("start", startTimeUTC, endTimeUTC);
33.                 Criteria critMore1 = new Criteria();
34.                 critMore1.addBetween("end", startTimeUTC, endTimeUTC);
35.                 Criteria critMore2 = new Criteria();
36.                 critMore2.addLessOrEqualThan("start", startTimeUTC);
37.                 critMore2.addGreaterOrEqualThan("end", endTimeUTC);
38.                 crit1.addOrCriteria(critMore1);
39.                 crit1.addOrCriteria(critMore2);
40.                 }
42.             criteriaList.add(crit1.copy(true, true, true));
43.         }
45.         if (criteriaList.size() > 0) {
46.             crit1 = new Criteria();
47.             for (int i = 0; i < criteriaList.size(); i++) {
48.                 crit1.addOrCriteria((Criteria) criteriaList.get(i));
49.             }
50.             crit.addAndCriteria(crit1);
51.         }
52.         logger.debug(crit);
53.         QueryByCriteria tquery = QueryFactory.newQuery(Timeslot.class, crit);
54.         this.timeslots = broker.getCollectionByQuery(tquery);
55.         broker.clearCache();
56.         broker.close();
57.     } catch (Throwable t) {
58.         logger.error(t.getMessage(), t);
59.     }
60. }

--------------------next---------------------