Java tutorial
/* * Copyright (c) 2011 Brown Bag Consulting. * This file is part of the ExpressUI project. * Author: Juan Osuna * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License Version 3 * as published by the Free Software Foundation with the addition of the * following permission added to Section 15 as permitted in Section 7(a): * FOR ANY PART OF THE COVERED WORK IN WHICH THE COPYRIGHT IS OWNED BY * Brown Bag Consulting, Brown Bag Consulting DISCLAIMS THE WARRANTY OF * NON INFRINGEMENT OF THIRD PARTY RIGHTS. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. * * The interactive user interfaces in modified source and object code versions * of this program must display Appropriate Legal Notices, as required under * Section 5 of the GNU Affero General Public License. * * You can be released from the requirements of the license by purchasing * a commercial license. Buying such a license is mandatory as soon as you * develop commercial activities involving the ExpressUI software without * disclosing the source code of your own applications. These activities * include: offering paid services to customers as an ASP, providing * services from a web application, shipping ExpressUI with a closed * source product. * * For more information, please contact Brown Bag Consulting at this * address: juan@brownbagconsulting.com. */ package com.expressui.sample.view.user; import com.expressui.core.dao.StructuredEntityQuery; import com.expressui.sample.dao.UserDao; import com.expressui.sample.entity.security.Role; import com.expressui.sample.entity.security.User; import org.springframework.context.annotation.Scope; import org.springframework.stereotype.Component; import javax.annotation.Resource; import javax.persistence.TypedQuery; import javax.persistence.criteria.*; import java.util.ArrayList; import java.util.List; @Component @Scope("prototype") @SuppressWarnings({ "rawtypes" }) public class UserQuery extends StructuredEntityQuery<User> { @Resource private UserDao userDao; private String loginName; private Role doesNotBelongToRole; public String getLoginName() { return loginName; } public void setLoginName(String loginName) { this.loginName = loginName; } public Role getDoesNotBelongToRole() { return doesNotBelongToRole; } public void setDoesNotBelongToRole(Role doesNotBelongToRole) { this.doesNotBelongToRole = doesNotBelongToRole; } @Override public List<User> execute() { return userDao.execute(this); } @Override public List<Predicate> buildCriteria(CriteriaBuilder builder, Root<User> rootEntity) { List<Predicate> criteria = new ArrayList<Predicate>(); if (!isEmpty(loginName)) { ParameterExpression<String> p = builder.parameter(String.class, "loginName"); criteria.add(builder.like(builder.upper(rootEntity.<String>get("loginName")), p)); } if (!isEmpty(doesNotBelongToRole)) { ParameterExpression<Role> p = builder.parameter(Role.class, "doesNotBelongToRole"); Join join = rootEntity.join("userRoles", JoinType.LEFT); criteria.add(builder.or(builder.notEqual(join.get("role"), p), builder.isNull(join.get("role")))); } return criteria; } @Override public void setParameters(TypedQuery typedQuery) { if (!isEmpty(loginName)) { typedQuery.setParameter("loginName", "%" + loginName.toUpperCase() + "%"); } if (!isEmpty(doesNotBelongToRole)) { typedQuery.setParameter("doesNotBelongToRole", doesNotBelongToRole); } } @Override public void clear() { Role doesNotBelongToRole = this.doesNotBelongToRole; super.clear(); this.doesNotBelongToRole = doesNotBelongToRole; } @Override public String toString() { return "UserQuery{" + "loginName='" + loginName + '\'' + '}'; } }