下面列出了org.hibernate.criterion.Restrictions#eq ( ) 实例代码,或者点击链接到github查看源代码,也可以在右侧发表评论。
@Override
public boolean deleteTaskAnswer(Long documentID) {
try {
Criterion criterion = Restrictions.eq("id.documentId", documentID);
List<TaskAnswer> answers = getAllByCriteria(criterion);
if(answers != null) {
// delete task
for (TaskAnswer taskAnswer : answers) {
delete(taskAnswer);
}
}
return true;
} catch (Exception e) {
logger.error("Error in deleting taskAnswer give documentID : " + documentID);
return false;
}
}
@Override
public List<Question> findStatsColVarQus(SurveyDirectory survey) {
Criterion criterion1=Restrictions.eq("belongId", survey.getId());
Criterion criterion2=Restrictions.eq("tag", 2);
// Criterion criterion31=Restrictions.ne("quType", QuType.FILLBLANK);
// Criterion criterion32=Restrictions.ne("quType", QuType.MULTIFILLBLANK);
// Criterion criterion33=Restrictions.ne("quType", QuType.ANSWER);
//
//// Criterion criterion3=Restrictions.or(criterion31, criterion32);
// //where s=2 and (fds !=1 or fds!=2 )
// return questionDao.find(criterion1,criterion2,criterion31,criterion32,criterion33);
Criterion criterion31=Restrictions.ne("quType", QuType.FILLBLANK);
Criterion criterion32=Restrictions.ne("quType", QuType.MULTIFILLBLANK);
Criterion criterion33=Restrictions.ne("quType", QuType.ANSWER);
Criterion criterion34=Restrictions.ne("quType", QuType.CHENCHECKBOX);
Criterion criterion35=Restrictions.ne("quType", QuType.CHENFBK);
Criterion criterion36=Restrictions.ne("quType", QuType.CHENRADIO);
Criterion criterion37=Restrictions.ne("quType", QuType.ENUMQU);
Criterion criterion38=Restrictions.ne("quType", QuType.ORDERQU);
Criterion criterion39=Restrictions.ne("quType", QuType.SCORE);
return questionDao.find(criterion1,criterion2,criterion31,criterion32,criterion33,criterion34,criterion35,criterion36,criterion37,criterion38,criterion39);
}
@Sessional
@Override
public SshKey findByDigest(String digest) {
SimpleExpression eq = Restrictions.eq("digest", digest);
EntityCriteria<SshKey> entityCriteria = EntityCriteria.of(SshKey.class).add(eq);
entityCriteria.setCacheable(true);
return find(entityCriteria);
}
@SuppressWarnings("unchecked")
public static List<BasicRule> getAllOtherPublishedBasicRules(String userID) {
Session session = getSessionFactory().getCurrentSession();
session.beginTransaction();
Criteria crit = session.createCriteria(BasicRule.class);
Criterion isOwner = Restrictions.not(Restrictions.eq(OWNER_ID, valueOf(userID)));
SimpleExpression isPublished = Restrictions.eq(PUBLISHED, true);
List<BasicRule> rules = crit.add(Restrictions.and(isOwner, isPublished)).list();
session.getTransaction().commit();
return rules;
}
/** {@inheritDoc} */
@Override
public Object visit(PropertyIsEqualTo filter, Object userData) {
String propertyName = getPropertyName(filter.getExpression1());
String finalName = parsePropertyName(propertyName, userData);
Object value = castLiteral(getLiteralValue(filter.getExpression2()), propertyName);
return Restrictions.eq(finalName, value);
}
public int getOrderById(String quId){
Criterion criterion=Restrictions.eq("quId", quId);
QuOrderby quOrderby=quOrderbyDao.findFirst("orderById", false, criterion);
if(quOrderby!=null){
return quOrderby.getOrderById();
}
return 0;
}
/**
* 取一份卷子回答的数据
*/
public Page<SurveyAnswer> answerPage(Page<SurveyAnswer> page,String surveyId){
Criterion cri1=Restrictions.eq("surveyId", surveyId);
Criterion cri2=Restrictions.lt("handleState", 2);
page.setOrderBy("endAnDate");
page.setOrderDir("desc");
page=findPage(page, cri1, cri2);
return page;
}
@Override
public List<SurveyAnswer> answersByIp(String surveyId, String ip) {
Criterion criterionSurveyId = Restrictions.eq("surveyId", surveyId);
Criterion criterionIp = Restrictions.eq("ipAddr", ip);
List<SurveyAnswer> answers = surveyAnswerDao.find(criterionSurveyId,
criterionIp);
return answers;
}
private SurveyDetail findUn(String dirId){
Criterion criterion=Restrictions.eq("dirId", dirId);
List<SurveyDetail> details=surveyDetailDao.find(criterion);
if(details!=null && details.size()>0){
return details.get(0);
}
return null;
}
@Override
public List<AnOrder> findAnswer(String belongAnswerId, String quId) {//belongAnswerId quId
Criterion criterion1=Restrictions.eq("belongAnswerId", belongAnswerId);
Criterion criterion2=Restrictions.eq("quId", quId);
return anOrderDao.find(criterion1,criterion2);
}
public static Criterion ofTargetProject(Project target) {
return Restrictions.eq("targetProject", target);
}
public static Criterion ofSubmitter(User submitter) {
return Restrictions.eq("submitter", submitter);
}
public AnYesno findAnswer(String belongAnswerId,String quId){
//belongAnswerId quId
Criterion criterion1=Restrictions.eq("belongAnswerId", belongAnswerId);
Criterion criterion2=Restrictions.eq("quId", quId);
return anYesnoDao.findUnique(criterion1,criterion2);
}
@Override
public List<AnChenCheckbox> findAnswer(String belongAnswerId, String quId) {//belongAnswerId quId
Criterion criterion1=Restrictions.eq("belongAnswerId", belongAnswerId);
Criterion criterion2=Restrictions.eq("quId", quId);
return anChenCheckboxDao.find(criterion1,criterion2);
}
@Override
public List<QuestionLogic> findByCkQuId(String ckQuId) {
Criterion cri1=Restrictions.eq("ckQuId", ckQuId);
Criterion cri2=Restrictions.eq("visibility", 1);
return questionLogicDao.find(cri1,cri2);
}
private RdrSet loadSet(String column, String value) {
Criterion criterion = Restrictions.eq(column, value);
List list = Persister.getInstance().getByCriteria(RdrSet.class, criterion);
return ! (list == null || list.isEmpty()) ? (RdrSet) list.get(0) : null;
}
public List<AnDFillblank> findAnswer(String belongAnswerId,String quId){
//belongAnswerId quId
Criterion criterion1=Restrictions.eq("belongAnswerId", belongAnswerId);
Criterion criterion2=Restrictions.eq("quId", quId);
return anDFillblankDao.find(criterion1,criterion2);
}
@Override
public List<TaskQueue> findLatestTaskQueue(Long clientAppID) {
Criterion criterion = Restrictions.eq("clientAppID",clientAppID);
return getMaxOrderByCriteria(criterion, "updated");
}
@Override
public User findByCode(String code) {
Criterion criterion=Restrictions.eq("findPwdCode", code);
return userDao.findFirst(criterion);
}
/**
* 按属性条件参数创建Criterion,辅助函数.
*
* @param propertyName
* String
* @param propertyValue
* Object
* @param matchType
* MatchType
* @return Criterion
*/
public static Criterion buildCriterion(String propertyName,
Object propertyValue, MatchType matchType) {
Assert.hasText(propertyName, "propertyName不能为空");
Criterion criterion = null;
// 根据MatchType构造criterion
switch (matchType) {
case EQ:
criterion = Restrictions.eq(propertyName, propertyValue);
break;
case NOT:
criterion = Restrictions.ne(propertyName, propertyValue);
break;
case LIKE:
criterion = Restrictions.like(propertyName, (String) propertyValue,
MatchMode.ANYWHERE);
break;
case LE:
criterion = Restrictions.le(propertyName, propertyValue);
break;
case LT:
criterion = Restrictions.lt(propertyName, propertyValue);
break;
case GE:
criterion = Restrictions.ge(propertyName, propertyValue);
break;
case GT:
criterion = Restrictions.gt(propertyName, propertyValue);
break;
case IN:
criterion = Restrictions.in(propertyName,
(Collection) propertyValue);
break;
case INL:
criterion = Restrictions.isNull(propertyName);
break;
case NNL:
criterion = Restrictions.isNotNull(propertyName);
break;
default:
criterion = Restrictions.eq(propertyName, propertyValue);
break;
}
return criterion;
}