巴巴运动网学习笔记(21-25)
1.实现最基本的分页数据的的查找功能(claaType,bengin,max),并单元测试
View Code
1 public <T> ScrollResult<T> getScrollResult(Class<T> classType,int begin, int max) {
2 return getScrollResult(classType, begin, max,null);
3 }
2.为分页数据的查找增加排序功能(claaType,bengin,max,map),并单元测试
View Code
1 public <T> ScrollResult<T> getScrollResult(Class<T> classType,int begin, int max,LinkedHashMap<String, String> orderHashMap) {
2 return getScrollResult(classType, begin, max, orderHashMap,null,null);
3 }
3.为分页数据的查找增加过滤功能(claaType,bengin,max,map,filterString,params),并单元测试
View Code
1 public <T> ScrollResult<T> getScrollResult(Class<T> classType,int begin, int max,LinkedHashMap<String, String> orderHashMap,String filterString,Object[] params) {
2 ScrollResult<T> scrollResult = new ScrollResult<T>();
3 String entityName = getEntiyName(classType);
4 String orderString = getOrderString(orderHashMap);
5 Query query = entityManager.createQuery("select p from "+entityName+" p "+(filterString==null?"":"where "+filterString+" ")+orderString);
6 for(int i=0;params!=null&&filterString!=null&&!filterString.equals("")&&i<params.length;i++){
7 query.setParameter(i+1, params[i]);
8 }
9 if(begin!=-1&&max!=-1){
10 query.setFirstResult(begin).setMaxResults(max);
11 }
12 scrollResult.setResultList(query.getResultList());
13 query = entityManager.createQuery("select count(p) from "+entityName+" p "+(filterString==null?"":"where "+filterString));
14 for(int i=0;params!=null&&filterString!=null&&!filterString.equals("")&&i<params.length;i++){
15 query.setParameter(i+1, params[i]);
16 }
17 scrollResult.setCount((Long)query.getSingleResult());
18 return scrollResult;
19 }
4.实现spring+jpa+struts1的集成,并单元测试
