List of usage examples for org.hibernate.criterion Restrictions le
public static SimpleExpression le(String propertyName, Object value)
From source file:forms.frmEstate.java
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed Criteria criteria = db.getCriteria(Apartmentsandoffices.class); //ehir//w w w.ja v a 2 s . c om if (jComboBox1.getSelectedIndex() > 0) { criteria.add(Restrictions.eq("address", jComboBox1.getSelectedIndex())); } //fiyat if (jTextField1.getText().length() > 0 && jTextField2.getText().length() > 0) { criteria.add(Restrictions.between("price", Integer.valueOf(jTextField1.getText()), Integer.valueOf(jTextField2.getText()))); } else if (jTextField1.getText().length() > 0) { criteria.add(Restrictions.ge("price", Integer.valueOf(jTextField1.getText()))); } else if (jTextField2.getText().length() > 0) { criteria.add(Restrictions.le("price", Integer.valueOf(jTextField2.getText()))); } //oda says if (jComboBox2.getSelectedIndex() > 0) { criteria.add(Restrictions.eq("roomcount", jComboBox2.getSelectedIndex())); } //bina ya if (jComboBox3.getSelectedIndex() > 0) { criteria.add(Restrictions.eq("buildingage", jComboBox3.getSelectedIndex())); } //m2 if (jTextField3.getText().length() > 0 && jTextField9.getText().length() > 0) { criteria.add(Restrictions.between("m2", Integer.valueOf(jTextField3.getText()), Integer.valueOf(jTextField9.getText()))); } else if (jTextField3.getText().length() > 0) { criteria.add(Restrictions.ge("m2", Integer.valueOf(jTextField3.getText()))); } else if (jTextField9.getText().length() > 0) { criteria.add(Restrictions.le("m2", Integer.valueOf(jTextField9.getText()))); } //stma if (jComboBox4.getSelectedIndex() > 0) { criteria.add(Restrictions.eq("heating", jComboBox4.getSelectedIndex())); } //kat if (jComboBox5.getSelectedIndex() > 0) { criteria.add(Restrictions.eq("floor", jComboBox5.getSelectedIndex())); } //toplam kat if (jComboBox6.getSelectedIndex() > 0) { criteria.add(Restrictions.eq("totalfloor", jComboBox6.getSelectedIndex())); } //banyo says if (jTextField4.getText().length() > 0) { criteria.add(Restrictions.eq("bathroomcount", Integer.valueOf(jTextField4.getText()))); } //eyalm if (!jCheckBox1.isSelected() && !jCheckBox2.isSelected()) { //criteria.add(Restrictions.eq("furniture", null)); } else if (jCheckBox1.isSelected()) criteria.add(Restrictions.eq("furniture", true)); else criteria.add(Restrictions.eq("furniture", false)); //emlak tipi if (jComboBox8.getSelectedIndex() > 0) { criteria.add(Restrictions.eq("type", jComboBox8.getSelectedIndex())); } //emlak durumu if (jComboBox7.getSelectedIndex() > 0) { criteria.add(Restrictions.eq("state", jComboBox7.getSelectedIndex())); } apartment.getApartmentAds(criteria.list(), jTable2); }
From source file:forms.frmEstate.java
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed Criteria criteria = db.getCriteria(Lands.class); if (jComboBox9.getSelectedIndex() > 0) criteria.add(Restrictions.eq("address", jComboBox9.getSelectedIndex())); if (jComboBox25.getSelectedIndex() > 0) criteria.add(Restrictions.eq("state", jComboBox25.getSelectedIndex())); if (jComboBox26.getSelectedIndex() > 0) criteria.add(Restrictions.eq("reconstruction", jComboBox26.getSelectedIndex())); if (jComboBox27.getSelectedIndex() > 0) criteria.add(Restrictions.eq("deedstate", jComboBox27.getSelectedIndex())); if (jComboBox28.getSelectedIndex() > 0) criteria.add(Restrictions.eq("clearance", jComboBox28.getSelectedIndex())); if (jComboBox29.getSelectedIndex() > 0) criteria.add(Restrictions.eq("kaks", jComboBox29.getSelectedIndex())); //fiyat/*from w ww.ja v a 2s. co m*/ if (jTextField5.getText().length() > 0 && jTextField6.getText().length() > 0) { criteria.add(Restrictions.between("price", Integer.valueOf(jTextField5.getText()), Integer.valueOf(jTextField6.getText()))); } else if (jTextField5.getText().length() > 0) { criteria.add(Restrictions.ge("price", Integer.valueOf(jTextField5.getText()))); } else if (jTextField6.getText().length() > 0) { criteria.add(Restrictions.le("price", Integer.valueOf(jTextField6.getText()))); } //m2 if (jTextField13.getText().length() > 0 && jTextField14.getText().length() > 0) { criteria.add(Restrictions.between("m2", Integer.valueOf(jTextField13.getText()), Integer.valueOf(jTextField14.getText()))); } else if (jTextField13.getText().length() > 0) { criteria.add(Restrictions.ge("m2", Integer.valueOf(jTextField13.getText()))); } else if (jTextField14.getText().length() > 0) { criteria.add(Restrictions.le("m2", Integer.valueOf(jTextField14.getText()))); } land.getLandAds(criteria.list(), jTable3); }
From source file:fr.gael.dhus.olingo.v1.SQLVisitor.java
License:Open Source License
private Criterion internalCriterionComparative(BinaryOperator operator, String property, Object value) { Criterion criterion;/*from w ww . j av a2s . co m*/ switch (operator) { case EQ: { criterion = Restrictions.eq(property, value); break; } case NE: { criterion = Restrictions.ne(property, value); break; } case GT: { criterion = Restrictions.gt(property, value); break; } case GE: { criterion = Restrictions.ge(property, value); break; } case LT: { criterion = Restrictions.lt(property, value); break; } case LE: { criterion = Restrictions.le(property, value); break; } default: throw new UnsupportedOperationException("Unsupported operation: " + operator.toUriLiteral()); } return criterion; }
From source file:fr.utbm.repository.CourseSessionDao.java
/** * Filtre sur title, date et loc /*from w w w . ja va 2 s. co m*/ * @param date * @param loc * @param title * @return */ public List<Course_Session> getCourseSessionsFilter(Date date, Integer loc, String title) { System.out.println(date + " " + loc + " " + title); session = HibernateUtil.getSessionFactory().openSession(); List<Course_Session> courseSessions = null; try { session.beginTransaction(); Criteria criteria = session.createCriteria(Course_Session.class, "cs"); criteria.createCriteria("courseCode", "c") .add(Restrictions.like("c.title", title, MatchMode.ANYWHERE).ignoreCase()); if (date != null) { criteria.add(Restrictions.le("cs.startDate", date)); criteria.add(Restrictions.ge("cs.endDate", date)); } if (loc != null) { criteria.createAlias("locationId", "l"); criteria.add(Restrictions.eq("l.id", loc)); } courseSessions = criteria.list(); session.getTransaction().commit(); } catch (HibernateException he) { he.printStackTrace(); if (session.getTransaction() != null) { try { session.getTransaction().rollback(); } catch (HibernateException he2) { he2.printStackTrace(); } } } finally { if (session != null) { try { session.close(); } catch (HibernateException he2) { he2.printStackTrace(); } } } for (Course_Session c : courseSessions) { System.out.println(c.getCourseCode()); } return courseSessions; }
From source file:fsl.ta.toms.roms.dao.impl.ReportDAOImpl.java
@Override public VehicleSeizedReportBO vehicleSeizedReport(VehicleSeizedReportCriteriaBO reportCriteria, String userName, String userRegion, ReportDisplayInformationDAOImpl reportDisplayInformation) { List<VehicleSeizedReportBO> vehicleSeizedReportBOList = new ArrayList<VehicleSeizedReportBO>(); Criteria criteria = this.hibernateTemplate.getSessionFactory().getCurrentSession() .createCriteria(WarningNoticeDO.class, "wn"); /* Add Aliases */ criteria.createAlias("roadOperation", "ro", Criteria.LEFT_JOIN); criteria.createAlias("taStaff", "tas", Criteria.LEFT_JOIN); criteria.createAlias("tas.person", "taPerson", Criteria.LEFT_JOIN); criteria.createAlias("offender", "of", Criteria.LEFT_JOIN); criteria.createAlias("pound", "p", Criteria.LEFT_JOIN); criteria.createAlias("wreckingCompany", "wc", Criteria.LEFT_JOIN); criteria.createAlias("wn.roadCheckOffenceOutcome.roadCheckOffence.offence", "ofn", Criteria.LEFT_JOIN); criteria.createAlias("wn.roadCheckOffenceOutcome.roadCheckOffence.roadCheck.compliance.vehicle", "v", Criteria.LEFT_JOIN);/*from ww w . jav a 2 s .c om*/ criteria.createAlias("wn.roadCheckOffenceOutcome.roadCheckOffence.roadCheck.compliance.compliancyArtery", "art", Criteria.LEFT_JOIN); /* Add Filters */ /* * This is assuming that start date and end date are mandatory search * fields and will not be NULL */ // criteria.add(Restrictions.between("seizureDtime",reportCriteria.getOffenceStartDate() // ,reportCriteria.getOffenceEndDate() )); Date reportStartDate = DateUtils.searchDateFormater(reportCriteria.getOffenceStartDate(), DateUtils.SEARCHDATETYPE.START); Date reportEndDate = DateUtils.searchDateFormater(reportCriteria.getOffenceEndDate(), DateUtils.SEARCHDATETYPE.END); criteria.add(Restrictions.ge("seizureDtime", reportStartDate)); criteria.add(Restrictions.le("seizureDtime", reportEndDate)); if (reportCriteria.getTAOfficeRegion() != null && !reportCriteria.getTAOfficeRegion().isEmpty()) criteria.add(Restrictions.eq("ro.officeLocCode", reportCriteria.getTAOfficeRegion().trim())); if (reportCriteria.getTAStaffId() != null && !reportCriteria.getTAStaffId().isEmpty()) criteria.add(Restrictions.eq("tas.staffId", reportCriteria.getTAStaffId().trim())); if (reportCriteria.getOffenderId() != null && reportCriteria.getOffenderId() > 0) criteria.add(Restrictions.eq("of.personId", reportCriteria.getOffenderId())); if (StringUtil.isSet(reportCriteria.getOffenderFirstName())) { criteria.add(Restrictions .like("of.firstName", reportCriteria.getOffenderFirstName().trim(), MatchMode.ANYWHERE) .ignoreCase()); } if (StringUtil.isSet(reportCriteria.getOffenderLastName())) { criteria.add(Restrictions .like("of.lastName", reportCriteria.getOffenderLastName().trim(), MatchMode.ANYWHERE) .ignoreCase()); } if (StringUtil.isSet(reportCriteria.getOffenderTRN())) { criteria.add(Restrictions.eq("of.trnNbr", reportCriteria.getOffenderTRN().trim())); } if (reportCriteria.getPoundId() != null && reportCriteria.getPoundId() > 0) criteria.add(Restrictions.eq("p.poundId", reportCriteria.getPoundId())); if (reportCriteria.getWreckingCompanyId() != null && reportCriteria.getWreckingCompanyId() > 0) criteria.add(Restrictions.eq("wc.wreckingCompanyId", reportCriteria.getWreckingCompanyId())); if (reportCriteria.getRoadOperationId() != null && reportCriteria.getRoadOperationId() > 0) criteria.add(Restrictions.eq("ro.roadOperationId", reportCriteria.getRoadOperationId())); if (StringUtil.isSet(reportCriteria.getRoadOperationName())) criteria.add(Restrictions .like("ro.operationName", reportCriteria.getRoadOperationName().trim(), MatchMode.ANYWHERE) .ignoreCase()); if (StringUtil.isSet(reportCriteria.getTAStaffTRN())) { criteria.add(Restrictions.eq("taPerson.trnNbr", reportCriteria.getTAStaffTRN().trim())); } criteria.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP); List warningNotices = criteria.list(); Iterator iterator = warningNotices.iterator(); /* Get report criteria names and descriptions */ reportCriteria .setTAOfficeDescription(this.getTAOfficeRegionDescription(reportCriteria.getTAOfficeRegion())); if (StringUtil.isSet(reportCriteria.getTAStaffId())) reportCriteria.setTAStaffName(this.getTAStaffName(reportCriteria.getTAStaffId())); else if (StringUtil.isSet(reportCriteria.getTAStaffTRN())) reportCriteria.setTAStaffName(this.getPersonName(reportCriteria.getTAStaffTRN())); if (reportCriteria.getOffenderId() != null && reportCriteria.getOffenderId() > 0) reportCriteria.setOffenderName(this.getPersonName(reportCriteria.getOffenderId())); else if (StringUtil.isSet(reportCriteria.getOffenderTRN())) reportCriteria.setOffenderName(this.getPersonName(reportCriteria.getOffenderTRN())); reportCriteria.setPoundName(this.getPoundName(reportCriteria.getPoundId())); reportCriteria.setWreckingCompanyName(this.getWreckingCompanyName(reportCriteria.getWreckingCompanyId())); /* * reportCriteria.setRoadOperationDesc(this.getRoadOperationName( * reportCriteria.getRoadOperationId())); */ /* __________________________________________ */ String stringStartDate = ""; String stringEndDate = ""; try { stringStartDate = DateUtils.getFormattedUtilDate(reportCriteria.getOffenceStartDate()); stringEndDate = DateUtils.getFormattedUtilDate(reportCriteria.getOffenceEndDate()); } catch (Exception exe) { } List<VehicleSeizedReportResultsBO> results = new ArrayList<VehicleSeizedReportResultsBO>(); while (iterator.hasNext()) { Map map = (Map) iterator.next(); WarningNoticeDO warningNotice = (WarningNoticeDO) map.get("wn"); RoadOperationDO roadOperation = (RoadOperationDO) map.get("ro"); TAStaffDO taStaff = (TAStaffDO) map.get("tas"); PersonDO offender = (PersonDO) map.get("of"); PoundDO pound = (PoundDO) map.get("p"); WreckingCompanyDO wreckingCompany = (WreckingCompanyDO) map.get("wc"); OffenceDO offence = (OffenceDO) map.get("ofn"); VehicleDO vehicle = (VehicleDO) map.get("v"); ArteryDO artery = (ArteryDO) map.get("art"); /* Get List of Witnesses */ Criteria criteriaWitness = this.hibernateTemplate.getSessionFactory().getCurrentSession() .createCriteria(WitnessWarningNoticeDO.class, "wwn"); criteriaWitness.add( Restrictions.eq("wwn.pk.warningNotice.warningNoticeId", warningNotice.getWarningNoticeId())); List<String> witnessNames = new ArrayList<String>(); for (WitnessWarningNoticeDO wwnDO : (List<WitnessWarningNoticeDO>) criteriaWitness.list()) { witnessNames.add(NameUtil.getName(wwnDO.getPk().getWitness().getFirstName(), wwnDO.getPk().getWitness().getLastName())); // witnessNames.add(wwnDO.getPk().getWitness()) } /* _______________________________________ */ VehicleSeizedReportResultsBO result = new VehicleSeizedReportResultsBO( NameUtil.getName(offender.getFirstName(), offender.getLastName()), offence.getDescription(), offence.getShortDescription(), NameUtil.getName(taStaff.getPerson().getFirstName(), taStaff.getPerson().getLastName()), pound.getPoundName(), wreckingCompany.getCompanyName(), (StringUtil.isSet(vehicle.getModel()) ? vehicle.getModel().trim() : "") + "; " + (StringUtil.isSet(vehicle.getMakeDescription()) ? vehicle.getMakeDescription().trim() : "") + "; Plate #: " + (StringUtil.isSet(vehicle.getPlateRegNo()) ? vehicle.getPlateRegNo().trim() : ""), artery.getShortDescription(), roadOperation.getOfficeLocCode(), roadOperation.getOperationName(), witnessNames, warningNotice.getSeizureDtime(), this.getTAOfficeRegionDescription(roadOperation.getOfficeLocCode())); results.add(result); } return new VehicleSeizedReportBO(userName, userRegion, reportDisplayInformation.applicationName, /* * The name of the * application from bean * config */ reportDisplayInformation.vehicleSeizedReportTitle + stringStartDate + " TO " + stringEndDate, /* * The name * of the * report is * from * wired * bean */ reportStartDate, reportEndDate, reportCriteria.getSearchCriteriaString(), results, this.getTAOfficeRegionDescription(userRegion)); }
From source file:gDao.util.Finder.java
License:Apache License
/** * According to column, fetch the results equal or lower than the value *///from w w w.ja v a 2 s . c o m public void addFilterLessThanOrEqual(String column, Object value) { controlRelationAndAddToList(criterionList, Restrictions.le(trimColumn(column), value), column); }
From source file:gov.nih.nci.cabio.annotations.ArrayAnnotationServiceImpl.java
License:BSD License
public Collection<SNP> getSnpsNearGene(String symbol, Long kbUpstream, Long kbDownstream, String assembly) throws ApplicationException { List params = new ArrayList(); params.add(assembly);//from w w w. ja va 2s .c om params.add(symbol); params.add(symbol); params.add(taxon); Collection<GenePhysicalLocation> result = appService.query(new HQLCriteria(GET_SNPS_NEAR_GENE_HQL, QueryUtils.createCountQuery(GET_SNPS_NEAR_GENE_HQL), params)); if (result == null || result.isEmpty()) throw new ApplicationException("No genes found for symbol " + symbol); Collection<GenomeRange> rawRanges = new TreeSet<GenomeRange>(); Long upPad = kbUpstream * 1000; Long downPad = kbDownstream * 1000; Long chromosomeId = null; // construct all padded ranges for (GenePhysicalLocation pl : result) { if (chromosomeId == null) chromosomeId = pl.getChromosome().getId(); rawRanges.add(new GenomeRange(pl.getChromosomalStartPosition() - upPad, pl.getChromosomalEndPosition() + downPad)); } // combine overlapping ranges Collection<GenomeRange> ranges = new ArrayList<GenomeRange>(); GenomeRange last = null; for (GenomeRange gr : rawRanges) { if ((last == null) || (last.getEnd() < gr.getStart() - 1)) { ranges.add(gr); last = gr; } else if (gr.getEnd() > last.getEnd()) { last.setEnd(gr.getEnd()); } } // query for SNPs on the given assembly in the combined ranges DetachedCriteria dc = DetachedCriteria.forClass(SNP.class).createCriteria("physicalLocationCollection") .add(Restrictions.eq("assembly", assembly)); Disjunction or = Restrictions.disjunction(); for (GenomeRange gr : ranges) { or.add(Restrictions.and(Restrictions.ge("chromosomalStartPosition", gr.getStart()), Restrictions.le("chromosomalEndPosition", gr.getEnd()))); } dc.add(or).addOrder(Order.asc("chromosomalStartPosition")) .add(Restrictions.sqlRestriction("{alias}.chromosome_id = ?", chromosomeId, Hibernate.LONG)); List<SNP> results = appService.query(dc); return results; }
From source file:gov.nih.nci.caintegrator.data.CaIntegrator2DaoImpl.java
License:BSD License
/** * {@inheritDoc}// ww w . j a v a2 s . co m */ @Override @SuppressWarnings(UNCHECKED) // Hibernate operations are untyped public List<Gene> findGenesByLocation(String chromosome, Integer startPosition, Integer endPosition, GenomeBuildVersionEnum genomeBuildVersion) { String locStartPosition = "location.startPosition"; String locEndPosition = "location.endPosition"; Criteria geneLocationCriteria = getCurrentSession().createCriteria(GeneChromosomalLocation.class); // (gene.startPos <= startPosition && gene.endPos >= startPosition) // || (gene.startPos >= lowerInput && gene.startPos <= higherInput) Junction overallOrStatement = Restrictions.disjunction(); overallOrStatement.add(Restrictions.conjunction().add(Restrictions.le(locStartPosition, startPosition)) .add(Restrictions.ge(locEndPosition, startPosition))); overallOrStatement.add(Restrictions.conjunction().add(Restrictions.ge(locStartPosition, startPosition)) .add(Restrictions.le(locStartPosition, endPosition))); geneLocationCriteria.add(overallOrStatement); geneLocationCriteria.add(getChromosomeRestriction(chromosome)); geneLocationCriteria.createCriteria("geneLocationConfiguration") .add(Restrictions.eq("genomeBuildVersion", genomeBuildVersion)); geneLocationCriteria.setProjection(Projections.property("geneSymbol")); List<String> geneSymbols = geneLocationCriteria.list(); return geneSymbols.isEmpty() ? new ArrayList<Gene>() : getCurrentSession().createCriteria(Gene.class) .setProjection(Projections.distinct(Projections.property(SYMBOL_ATTRIBUTE))) .add(Restrictions.in(SYMBOL_ATTRIBUTE, geneSymbols)).addOrder(Order.asc(SYMBOL_ATTRIBUTE)) .list(); }
From source file:gov.nih.nci.caintegrator.data.CopyNumberAlterationCriterionConverter.java
License:BSD License
private void addSegmentValueCriterion(Criteria segmentDataCrit) { // First case, if both are null. if (copyNumberCriterion.getUpperLimit() == null && copyNumberCriterion.getLowerLimit() == null) { return;/*from w ww . ja v a 2 s .c om*/ } SimpleExpression upperLimitExpression = Restrictions.le("segmentValue", copyNumberCriterion.getUpperLimit()); SimpleExpression lowerLimitExpression = Restrictions.ge("segmentValue", copyNumberCriterion.getLowerLimit()); // Second case, upper limit is higher than lower limit, value is in between the two if (copyNumberCriterion.isInsideBoundaryType()) { segmentDataCrit.add(Restrictions.conjunction().add(upperLimitExpression).add(lowerLimitExpression)); return; } // Third case, lower limit is higher than upper limit, value is outside of the limits if (copyNumberCriterion.isOutsideBoundaryType()) { segmentDataCrit.add(Restrictions.disjunction().add(upperLimitExpression).add(lowerLimitExpression)); return; } // Fourth case, upper limit has a value, lower limit is null. if (copyNumberCriterion.getUpperLimit() != null) { segmentDataCrit.add(upperLimitExpression); return; } // Fifth case, lower limit has a value, upper limit is null. if (copyNumberCriterion.getLowerLimit() != null) { segmentDataCrit.add(lowerLimitExpression); } }
From source file:gov.nih.nci.caintegrator.data.CopyNumberAlterationCriterionConverter.java
License:BSD License
private SimpleExpression segmentEndLessThanHigh(Integer chromosomeCoordinateHigh) { return Restrictions.le(LOCATION_END_ATTRIBUTE, chromosomeCoordinateHigh); }