Java 仓储模式
使用的Spring boot +Jpa
项目层级：
common里包含了model，以及一些viewModel等等
下面就是设计的仓储模式
先看下SysUser:
@MappedSuperclass public class SuperBaseModel { //基本属性 }
@MappedSuperclass public class BaseModel extends SuperBaseModel { //枚举值：https://blog.csdn.net/hanjun0612/article/details/72845960 private Integer isValid =EnumList.ValidEnum.Valid.getEnumItem().getItemKey(); @Column(name="IsValid") public Integer getIsValid() { return isValid; } public void setIsValid(Integer isValid) { this.isValid = isValid; } }
@Entity @Table(name = "sys_user", catalog = "kps_business") @DynamicUpdate public class SysUser extends BaseModel implements java.io.Serializable { //get set }
枚举值，请查看 https://blog.csdn.net/hanjun0612/article/details/72845960
一，dao创建MyJpa
@NoRepositoryBean public interface MyJpaRepository<T,ID extends Serializable> extends JpaRepository <T,ID>,JpaSpecificationExecutor<T>{ }
接着创建一个 SysUserDao，里面额外创建了3个方法。
@Repository public interface SysUserDao extends MyJpaRepository<SysUser, String>{ public SysUser getByAccount(String account); public SysUser getByAccountAndPlatformUUID(String account,String platformUUID); public SysUser getByUserUUId(String userUUId); }
这里MyJpaRepository<SysUser,String>
首先传入的是对象SysUser,其次传入了一个String 的UUID
如果你是Integer，那你自行修改就可以了。
二，service
先创建BaseSuperService
public interface BaseSuperService<T extends SuperBaseModel,ID extends Serializable> extends MyJpaRepository<T, ID> { /** * 分页查询 */ PageResult<T> pagedList(T entity,Integer currentPage,Integer pageSize,Order...orders); PageResult<T> pagedList(T entity,Integer currentPage,Order...orders); }
接着创建BaseService
public interface BaseService<T extends BaseModel,ID extends Serializable> extends BaseSuperService<T, ID> { /** * 分页查询(有效的记录) */ PageResult<T> pagedListForVaild(T entity,Integer currentPage,Integer pageSize,Order...orders) throws Exception; PageResult<T> pagedListForVaild(T entity,Integer currentPage,Order...orders) throws Exception; }
这里，你可以只创建一个BaseService。我是由于后期有两个领域模型
第一个领域模型，只需要BaseSuperService的pagedList方法
第二个领域模型，需要BaseSuperService的pagedList方法，以及BaseService的PagedListForVaild方法
因此才创建了两个层级。
最后创建UserService
public interface SysUserService extends BaseService<SysUser,String>{ public SysUser getByAccountAndPlatformUUID(String account,String platformUUID); public SysUser getByAccount(String account); public SysUser getByUserUUId(String userUUID); }
三，创建Impl
首先创建BaseSuperServiceImpl
@SuppressWarnings({"unchecked", "rawtypes"})
public class BaseSuperServiceImpl< K extends MyJpaRepository<T,ID>, T extends SuperBaseModel,ID extends Serializable> implements BaseSuperService<T,ID> {
protected Class<T> clazz;
protected String keyName; //主键属性名
protected Method getMethod; //得到主键对应的get方法
protected String sortName="createTime"; //默认字段排序 由于个别表key为UUID，不能按key排序
@Value("${isDebug}")
protected boolean isDebug;
@Autowired
protected K dao;
@Autowired
protected StringRedisTemplate redisTemplate;
@PersistenceContext
protected EntityManager em;// 类似hibernate session
public BaseSuperServiceImpl() {
ParameterizedType type = (ParameterizedType) getClass().getGenericSuperclass();
clazz = (Class<T>) type.getActualTypeArguments()[1];
getMethod = HibernateUtil.getKeyMethod(clazz);
String idname =getMethod.getName().substring(3);
idname = idname.substring(0, 1).toLowerCase() + idname.substring(1);
keyName = idname; //得到主键id名
}
@Override
public List<T> findAll() {
return dao.findAll();
}
@Override
public List<T> findAll(Sort sort) {
return dao.findAll(sort);
}
@Override
public Page<T> findAll(Pageable pageable) {
return dao.findAll(pageable);
}
@Override
public List<T> findAll(Iterable<ID> integers) {
return dao.findAll(integers);
}
@Override
public long count() {
return dao.count();
}
@Override
public void delete(ID id) {
dao.delete(id);
}
@Override
public void delete(T entity) {
dao.delete(entity);
}
@Override
public void delete(Iterable<? extends T> entities) {
dao.delete(entities);
}
@Override
public void deleteAll() {
dao.deleteAll();
}
@Override
public <S extends T> S save(S entity) {
try {
SysUser curUser = WebUtil.getCurrentUser(isDebug);
ID id = (ID) getMethod.invoke(entity);
//如果新增，reateTime，createUserUUID没给值，统一赋值
if(id==null){
if(entity.getCreateTime()==null) entity.setCreateTime(DateUtil.getCurDate());
if(entity.getCreateUserUUID()==null) entity.setCreateUserUUID(curUser.getUserUUId());
}
return dao.save(entity);
} catch (Exception e) {
LogerHelper.error(e);
}
return null;
}
@Override
public <S extends T> List<S> save(Iterable<S> entities) {
return dao.save(entities);
}
@Override
public T findOne(ID id) {
return dao.findOne(id);
}
@Override
public boolean exists(ID id) {
return dao.exists(id);
}
@Override
public void flush() {
dao.flush();
}
@Override
public <S extends T> S saveAndFlush(S entity) {
return dao.saveAndFlush(entity);
}
@Override
public void deleteInBatch(Iterable<T> entities) {
dao.deleteInBatch(entities);
}
@Override
public void deleteAllInBatch() {
dao.deleteAllInBatch();
}
@Override
public T getOne(ID id) {
return dao.getOne(id);
}
@Override
public <S extends T> S findOne(Example<S> example) {
return dao.findOne(example);
}
@Override
public <S extends T> List<S> findAll(Example<S> example) {
return dao.findAll(example);
}
@Override
public <S extends T> List<S> findAll(Example<S> example, Sort sort) {
return dao.findAll(example,sort);
}
@Override
public <S extends T> Page<S> findAll(Example<S> example, Pageable pageable) {
return dao.findAll(example, pageable);
}
@Override
public <S extends T> long count(Example<S> example) {
return dao.count(example);
}
@Override
public <S extends T> boolean exists(Example<S> example) {
return dao.exists(example);
}
@Override
public PageResult<T> pagedList(T entity, Integer currentPage, Integer pageSize, Order... orders) {
Sort s = null;
if (orders != null && orders.length > 0) {
s = new Sort(orders);
} else {
s = new Sort(new Order(Direction.DESC, sortName));
}
PageRequest pr = new PageRequest(currentPage - 1, pageSize, s);
Page<T> p = this.findAll(pr);
Integer fromItem = PageUtil.getOffset(currentPage, pageSize);
return new PageResult<T>(currentPage, pageSize, p.getContent(), (int)p.getTotalElements(), p.getTotalPages(), fromItem, p.getContent().size());
}
@Override
public PageResult<T> pagedList(T entity, Integer currentPage, Order... orders) {
return this.pagedList(entity, currentPage,PageUtil.PAGE_SIZE,orders);
}
protected List<Map> exectSqlMap(Query query) {
query.unwrap(SQLQuery.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
return query.getResultList();
}
protected Map exectSqlMap2(Query query) {
List<Map> list = exectSqlMap(query);
return ListUtil.notEmpty(list)?list.get(0):null;
}
protected PageResult<T> gerPageResult(Integer currentPage, Integer pageSize,
Specification<T> sf,Order... orders) {
//构建分页信息
Sort s = null;
if (orders != null && orders.length > 0) {
s = new Sort(orders);
} else {
s = new Sort(new Order(Direction.DESC, sortName));
}
PageRequest pr = new PageRequest(currentPage - 1, pageSize, s);
Page<T> p = sf==null?this.findAll(pr):this.findAll(sf,pr);
Integer fromItem = PageUtil.getOffset(currentPage, pageSize);
return new PageResult<T>(currentPage, pageSize, p.getContent(), (int)p.getTotalElements(), p.getTotalPages(), fromItem, p.getContent().size());
}
@Override
public T findOne(Specification<T> spec) {
return dao.findOne(spec);
}
@Override
public List<T> findAll(Specification<T> spec) {
return dao.findAll(spec);
}
@Override
public Page<T> findAll(Specification<T> spec, Pageable pageable) {
return dao.findAll(spec, pageable);
}
@Override
public List<T> findAll(Specification<T> spec, Sort sort) {
return dao.findAll(spec, sort);
}
@Override
public long count(Specification<T> spec) {
return dao.count(spec);
}
}
基本上，重写了所有的方法。
然后创建：BaseServiceImpl
public class BaseServiceImpl<K extends MyJpaRepository<T,ID>,T extends BaseModel,ID extends Serializable> extends BaseSuperServiceImpl<K,T,ID> implements BaseService<T,ID> { @Override public PageResult<T> pagedListForVaild(T entity, Integer currentPage, Integer pageSize, Order... orders) throws Exception { Sort s = null; if (orders != null && orders.length > 0) { s = new Sort(orders); } else { s = new Sort(new Order(Direction.DESC, sortName)); } PageRequest pr = new PageRequest(currentPage - 1, pageSize, s); T model = clazz.newInstance(); model.setIsValid(EnumList.ValidEnum.Valid.getEnumItem().getItemKey()); Example<T> example = Example.of(model); Page<T> p = dao.findAll(example, pr); Integer fromItem = PageUtil.getOffset(currentPage, pageSize); return new PageResult<T>(currentPage, pageSize, p.getContent(), (int)p.getTotalElements(), p.getTotalPages(), fromItem, p.getContent().size()); } @Override public <S extends T> S save(S entity) { //如果isValid没给值，统一赋值 if(entity.getIsValid()==null) entity.setIsValid(EnumList.ValidEnum.Valid.getEnumItem().getItemKey()); return super.save(entity); } @Override public PageResult<T> pagedListForVaild(T entity, Integer currentPage, Order... orders) throws Exception { return this.pagedListForVaild(entity, currentPage,PageUtil.PAGE_SIZE,orders); } }
最后创建UserServiceImpl
@Service("userService")
public class SysUserServiceImpl extends BaseServiceImpl<SysUserDao,SysUser,String> implements SysUserService {
public SysUser getByUserUUId(String userUUId){
return dao.getByUserUUId(userUUId);
}
@Override
public SysUser getByAccountAndPlatformUUID(String account,String platformUUID) {
return dao.getByAccountAndPlatformUUID(account,platformUUID);
}
@Override
public SysUser getByAccount(String account) {
return dao.getByAccount(account);
}
@Override
public PageResult<SysUser> pagedList(SysUser entity, Integer currentPage, Integer pageSize, Order... orders) {
if(entity==null){
return super.pagedList(entity, currentPage, pageSize, orders);
}
//构建查询条件
Specification<SysUser> sf = new Specification<SysUser>(){
@Override
public Predicate toPredicate(Root<SysUser> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
String name = entity.getUserNameCn();
Integer isValid = entity.getIsValid();
List<Predicate> list = new ArrayList<Predicate>();
if (StringUtils.isNotBlank(name)) {
name = name.toLowerCase();
Predicate p1 = cb.like(cb.lower(root.get("userNameCn")), "%" + name + "%");
Predicate p2 = cb.like(cb.lower(root.get("userNameEn")), "%" + name + "%");
Predicate p3 = cb.like(cb.lower(root.get("account")), "%" + name+ "%");
list.add(cb.or(p1,p2,p3));
}
if(isValid!=null){
list.add(cb.equal(root.get("isValid"),isValid));
}
Predicate[] p = new Predicate[list.size()];
return cb.and(list.toArray(p));
}
};
return super.gerPageResult(currentPage, pageSize,sf,orders);
}
}
这里，我额外演示一下重写了PagedList方法。
四，测试调用
@RunWith(value=SpringRunner.class) @SpringBootTest(classes={WebAPISYSApp.class}) public class SysUserTest{ @Autowired private SysUserService userService; @Test public void findUser(){ SysUser user = userService.findOne("0c867aca-d1eb-11e8-9aa5-0022198292f8"); logger.info(user.getAccount()); } }
