MCPcopy Create free account
hub / github.com/diyhi/bbs / UserRepositoryImpl

Class UserRepositoryImpl

src/main/java/cms/repository/user/impl/UserRepositoryImpl.java:51–2095  ·  view source on GitHub ↗

用户管理接口实现类 @Repository 将加有Repository注解的使用JPA或者Hibernate原生API的方法所抛出的异常转化为Spring的DataAccessException中的异常 UncategorizedDataAccessException为MYSQL唯一索引重复异常

Source from the content-addressed store, hash-verified

49 * UncategorizedDataAccessException为MYSQL唯一索引重复异常
50 */
51@Repository
52@Transactional
53public 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();

Callers

nothing calls this directly

Calls

no outgoing calls

Tested by

no test coverage detected

Used in the wild real call sites across dependent graphs

searching dependent graphs…