用户管理接口实现类 @Repository 将加有Repository注解的使用JPA或者Hibernate原生API的方法所抛出的异常转化为Spring的DataAccessException中的异常 UncategorizedDataAccessException为MYSQL唯一索引重复异常
| 49 | * UncategorizedDataAccessException为MYSQL唯一索引重复异常 |
| 50 | */ |
| 51 | @Repository |
| 52 | @Transactional |
| 53 | public class UserRepositoryImpl extends DaoSupport<User> implements UserRepository { |
| 54 | private static final Logger logger = LogManager.getLogger(UserRepositoryImpl.class); |
| 55 | |
| 56 | @Resource PointLogConfig pointLogConfig; |
| 57 | @Resource UserGradeRepository userGradeRepository; |
| 58 | |
| 59 | |
| 60 | @Resource UserLoginLogConfig userLoginLogConfig; |
| 61 | |
| 62 | @Resource PrivateMessageRepository privateMessageRepository; |
| 63 | @Resource SystemNotifyRepository systemNotifyRepository; |
| 64 | @Resource RemindRepository remindRepository; |
| 65 | @Resource FavoriteRepository favoriteRepository; |
| 66 | @Resource UserDynamicConfig userDynamicConfig; |
| 67 | |
| 68 | @Resource LikeRepository likeRepository; |
| 69 | @Resource FollowRepository followRepository; |
| 70 | @Resource UserRoleRepository userRoleRepository; |
| 71 | @Resource PaymentRepository paymentRepository; |
| 72 | @Lazy |
| 73 | @Resource QuestionRepository questionRepository; |
| 74 | @Lazy |
| 75 | @Resource AnswerRepository answerRepository; |
| 76 | @Lazy |
| 77 | @Resource RedEnvelopeRepository redEnvelopeRepository; |
| 78 | @Resource MembershipCardGiftTaskRepository membershipCardGiftTaskRepository; |
| 79 | |
| 80 | |
| 81 | /** |
| 82 | * 根据条件分页查询用户信息 |
| 83 | * @param jpql SQL |
| 84 | * @param params 参数值 |
| 85 | * @param firstIndex 开始索引 |
| 86 | * @param maxResult 需要获取的记录数 |
| 87 | * @return 返回值只包含id、userName、point、deposit、registrationDate 等字段值 |
| 88 | */ |
| 89 | @Transactional(readOnly=true,propagation=Propagation.NOT_SUPPORTED) |
| 90 | public List<User> findUserInfoByConditionPage(String jpql,List<Object> params,int firstIndex, int maxResult){ |
| 91 | |
| 92 | List<User> userList = new ArrayList<User>(); |
| 93 | |
| 94 | int placeholder = 1;//占位符参数 |
| 95 | Query query = em.createQuery("select o.id, o.userName, o.point, o.deposit, o.registrationDate from User o"+(jpql == null || "".equals(jpql.trim())? "" : " where "+jpql)); |
| 96 | if(params != null && params.size() >0){ |
| 97 | for(Object obj : params){ |
| 98 | query.setParameter(placeholder,obj); |
| 99 | placeholder++; |
| 100 | } |
| 101 | } |
| 102 | //索引开始,即从哪条记录开始 |
| 103 | query.setFirstResult(firstIndex); |
| 104 | //获取多少条数据 |
| 105 | query.setMaxResults(maxResult); |
| 106 | |
| 107 | |
| 108 | List<Object[]> objectList = query.getResultList(); |
nothing calls this directly
no outgoing calls
no test coverage detected
searching dependent graphs…