1 package org.hibernate.criterion; 3 4 13 public class Subqueries { 14 15 public static Criterion exists(DetachedCriteria dc) { 16 return new ExistsSubqueryExpression("exists", dc); 17 } 18 19 public static Criterion notExists(DetachedCriteria dc) { 20 return new ExistsSubqueryExpression("notExists", dc); 21 } 22 23 public static Criterion propertyEqAll(String propertyName, DetachedCriteria dc) { 24 return new PropertySubqueryExpression(propertyName, "=", "all", dc); 25 } 26 27 public static Criterion propertyIn(String propertyName, DetachedCriteria dc) { 28 return new PropertySubqueryExpression(propertyName, "in", null, dc); 29 } 30 31 public static Criterion propertyNotIn(String propertyName, DetachedCriteria dc) { 32 return new PropertySubqueryExpression(propertyName, "not in", null, dc); 33 } 34 35 public static Criterion propertyEq(String propertyName, DetachedCriteria dc) { 36 return new PropertySubqueryExpression(propertyName, "=", null, dc); 37 } 38 39 public static Criterion propertyNe(String propertyName, DetachedCriteria dc) { 40 return new PropertySubqueryExpression(propertyName, "<>", null, dc); 41 } 42 43 public static Criterion propertyGt(String propertyName, DetachedCriteria dc) { 44 return new PropertySubqueryExpression(propertyName, ">", null, dc); 45 } 46 47 public static Criterion propertyLt(String propertyName, DetachedCriteria dc) { 48 return new PropertySubqueryExpression(propertyName, "<", null, dc); 49 } 50 51 public static Criterion propertyGe(String propertyName, DetachedCriteria dc) { 52 return new PropertySubqueryExpression(propertyName, ">=", null, dc); 53 } 54 55 public static Criterion propertyLe(String propertyName, DetachedCriteria dc) { 56 return new PropertySubqueryExpression(propertyName, "<=", null, dc); 57 } 58 59 public static Criterion propertyGtAll(String propertyName, DetachedCriteria dc) { 60 return new PropertySubqueryExpression(propertyName, ">", "all", dc); 61 } 62 63 public static Criterion propertyLtAll(String propertyName, DetachedCriteria dc) { 64 return new PropertySubqueryExpression(propertyName, "<", "all", dc); 65 } 66 67 public static Criterion propertyGeAll(String propertyName, DetachedCriteria dc) { 68 return new PropertySubqueryExpression(propertyName, ">=", "all", dc); 69 } 70 71 public static Criterion propertyLeAll(String propertyName, DetachedCriteria dc) { 72 return new PropertySubqueryExpression(propertyName, "<=", "all", dc); 73 } 74 75 public static Criterion propertyGtSome(String propertyName, DetachedCriteria dc) { 76 return new PropertySubqueryExpression(propertyName, ">", "some", dc); 77 } 78 79 public static Criterion propertyLtSome(String propertyName, DetachedCriteria dc) { 80 return new PropertySubqueryExpression(propertyName, "<", "some", dc); 81 } 82 83 public static Criterion propertyGeSome(String propertyName, DetachedCriteria dc) { 84 return new PropertySubqueryExpression(propertyName, ">=", "some", dc); 85 } 86 87 public static Criterion propertyLeSome(String propertyName, DetachedCriteria dc) { 88 return new PropertySubqueryExpression(propertyName, "<=", "some", dc); 89 } 90 91 public static Criterion eqAll(String value, DetachedCriteria dc) { 92 return new SimpleSubqueryExpression(value, "=", "all", dc); 93 } 94 95 public static Criterion in(String value, DetachedCriteria dc) { 96 return new SimpleSubqueryExpression(value, "in", null, dc); 97 } 98 99 public static Criterion notIn(String value, DetachedCriteria dc) { 100 return new SimpleSubqueryExpression(value, "not in", null, dc); 101 } 102 103 public static Criterion eq(String value, DetachedCriteria dc) { 104 return new SimpleSubqueryExpression(value, "=", null, dc); 105 } 106 107 public static Criterion gt(String value, DetachedCriteria dc) { 108 return new SimpleSubqueryExpression(value, ">", null, dc); 109 } 110 111 public static Criterion lt(String value, DetachedCriteria dc) { 112 return new SimpleSubqueryExpression(value, "<", null, dc); 113 } 114 115 public static Criterion ge(String value, DetachedCriteria dc) { 116 return new SimpleSubqueryExpression(value, ">=", null, dc); 117 } 118 119 public static Criterion le(String value, DetachedCriteria dc) { 120 return new SimpleSubqueryExpression(value, "<=", null, dc); 121 } 122 123 public static Criterion ne(String value, DetachedCriteria dc) { 124 return new SimpleSubqueryExpression(value, "<>", null, dc); 125 } 126 127 public static Criterion gtAll(String value, DetachedCriteria dc) { 128 return new SimpleSubqueryExpression(value, ">", "all", dc); 129 } 130 131 public static Criterion ltAll(String value, DetachedCriteria dc) { 132 return new SimpleSubqueryExpression(value, "<", "all", dc); 133 } 134 135 public static Criterion geAll(String value, DetachedCriteria dc) { 136 return new SimpleSubqueryExpression(value, ">=", "all", dc); 137 } 138 139 public static Criterion leAll(String value, DetachedCriteria dc) { 140 return new SimpleSubqueryExpression(value, "<=", "all", dc); 141 } 142 143 public static Criterion gtSome(String value, DetachedCriteria dc) { 144 return new SimpleSubqueryExpression(value, ">", "some", dc); 145 } 146 147 public static Criterion ltSome(String value, DetachedCriteria dc) { 148 return new SimpleSubqueryExpression(value, "<", "some", dc); 149 } 150 151 public static Criterion geSome(String value, DetachedCriteria dc) { 152 return new SimpleSubqueryExpression(value, ">=", "some", dc); 153 } 154 155 public static Criterion leSome(String value, DetachedCriteria dc) { 156 return new SimpleSubqueryExpression(value, "<=", "some", dc); 157 } 158 159 160 } 161 | Popular Tags |