知识点

 1     /**
 2      * 获取特卫服务类型（所有）
 3      * @param request
 4      * @param response
 5      * @param time_stamp
 6      * @param sig
 7      * @param callback
 8      */
 9     @RequestMapping("/queryAllTType")
10     public void queryAllTType(HttpServletRequest request,HttpServletResponse response,
11             @RequestParam("time_stamp") String time_stamp,@RequestParam("sig") String sig,@RequestParam("callback") String callback){
12         String localhost = FileUtil.getLocalhost();
13         Map<String,Object> map=new HashMap<String,Object>();
14         map=ParameterValidation.validateParameter(time_stamp, sig, "queryAllTType");
15         if(map.get("code")==null){
16             List<SgTaskType> list=sgTaskTypeServiceImpl.findAllType();
17             List<SgTaskType> lastlist = new ArrayList<SgTaskType>();
18              if(list!=null&&list.size()>0){
19                     for(SgTaskType pic : list){
20                          pic.setPicture(localhost+request.getContextPath()+"/pc/sg/findSgTaskTypeCoverImg?id="+pic.getId()+".png");
21                          lastlist.add(pic);
22                     }
23                 }
24             map.put("data", list);
25             map.put("code", 200);
26         }
27         returnEntityToJson(response, callback, map);
28     }
29 
30 /**
31      * 获取特卫任务图片
32      * @param request
33      * @param response
34      * @param id
35      */
36     @RequestMapping("/findSgTaskTypeCoverImg")
37     public void findSgTaskTypeCoverImg(HttpServletRequest request,HttpServletResponse response,@RequestParam("id") String id){
38         Map<String,Object> map = new HashMap<String,Object>();
39         if(id==null||"".equals(id)){    
40             map.put("code", 201);//id号为空
41             map.put("data", null);
42             returnEntityToJson(response,map);
43             return;
44         }
45         String attr[] = id.split(".png");
46         SgTaskType Ttype = sgTaskTypeServiceImpl.findEntityById(attr[0]);
47         if(Ttype!=null){
48             String imgpath = Ttype.getPicture();
49             if(imgpath!=null&&!"".equals(imgpath)){
50                 byte[] s = FileUtil.loadFile(imgpath);
51                 if(s!=null&&s.length>0){
52                     response.reset();
53                     try {
54                         response.getOutputStream().write(s);
55                     } catch (IOException e) {
56                         // TODO Auto-generated catch block
57                         e.printStackTrace();
58                     }
59                 }else{
60                     byte[] s1 = FileUtil.loadFile(FileUtil.getPro("/filePath.properties","defaultCover"));
61                     if(s1!=null&&s1.length>0){
62                         response.reset();
63                         try {
64                             response.getOutputStream().write(s1);
65                         } catch (IOException e) {
66                             // TODO Auto-generated catch block
67                             e.printStackTrace();
68                         }
69                     }
70                 }
71             }
72         }
73     }

1 public List<SgTaskType> findAllType(){
2         
3         return sgTaskTypeDao.findALLType();
4         
5     }

@Query("select t from SgTaskType t where 1=1")
    List<SgTaskType> findALLType();
//通过id查
    @Query("from SgTaskType t where t.id=:id")
    List<SgTaskType> findAllTaskTypeById(@Param("id") String id);
    

 1     /**
 2      * 获取特卫服务的类型（贴身保镖，逛街拎包，接送孩子等）----分页
 3      * @param request
 4      * @param response
 5      * @param time_stamp
 6      * @param sig
 7      */
 8     @RequestMapping("/queryALLSgTaskType")
 9     public void queryALLSgTaskType(HttpServletRequest request,HttpServletResponse response,
10             @RequestParam("time_stamp") String time_stamp,@RequestParam("sig") String sig,@RequestParam("callback") String callback,
11             @RequestParam("page") int page,@RequestParam("rows") int rows){
12         String localhost = FileUtil.getLocalhost();
13         Map<String,Object> map=new HashMap<String,Object>();
14         map=ParameterValidation.validateParameter(time_stamp, sig, "queryALLSgTaskType");
15         if(map.get("code")==null){
16             List<SgTaskType> list=sgTaskTypeServiceImpl.findSgTaskTypeForPage((page-1)*rows, rows);
17             List<SgTaskType> lastlist = new ArrayList<SgTaskType>();
18              if(list!=null&&list.size()>0){
19                     for(SgTaskType pic : list){
20                          pic.setPicture(localhost+request.getContextPath()+"/pc/sg/findSgTaskTypeCoverImg?id="+pic.getId()+".png");
21                          lastlist.add(pic);
22                     }
23                 }
24             map.put("data", list);
25             map.put("code",200);
26         }
27         returnEntityToJson(response, callback, map);
28     }
29     /**
30      * 获取特卫任务图片
31      * @param request
32      * @param response
33      * @param id
34      */
35     @RequestMapping("/findSgTaskTypeCoverImg")
36     public void findSgTaskTypeCoverImg(HttpServletRequest request,HttpServletResponse response,@RequestParam("id") String id){
37         Map<String,Object> map = new HashMap<String,Object>();
38         if(id==null||"".equals(id)){    
39             map.put("code", 201);//id号为空
40             map.put("data", null);
41             returnEntityToJson(response,map);
42             return;
43         }
44         String attr[] = id.split(".png");
45         SgTaskType Ttype = sgTaskTypeServiceImpl.findEntityById(attr[0]);
46         if(Ttype!=null){
47             String imgpath = Ttype.getPicture();
48             if(imgpath!=null&&!"".equals(imgpath)){
49                 byte[] s = FileUtil.loadFile(imgpath);
50                 if(s!=null&&s.length>0){
51                     response.reset();
52                     try {
53                         response.getOutputStream().write(s);
54                     } catch (IOException e) {
55                         // TODO Auto-generated catch block
56                         e.printStackTrace();
57                     }
58                 }else{
59                     byte[] s1 = FileUtil.loadFile(FileUtil.getPro("/filePath.properties","defaultCover"));
60                     if(s1!=null&&s1.length>0){
61                         response.reset();
62                         try {
63                             response.getOutputStream().write(s1);
64                         } catch (IOException e) {
65                             // TODO Auto-generated catch block
66                             e.printStackTrace();
67                         }
68                     }
69                 }
70             }
71         }
72     }

 1 /**
 2      * pc查询任务类型（分页）
 3      * @param page
 4      * @param rows
 5      * @return
 6      */
 7     public List<SgTaskType> findSgTaskTypeForPage(int page,int rows){
 8         return spTaskTypeDaoImpl.findTaskTypeForPage(page, rows);
 9     }
10     

@Component
public class SgTaskTypeDaoImpl {

    @PersistenceContext
    EntityManager entityManager;
    
    public List<SgTaskType> findTaskTypeForPage(int page,int rows){
        
        String sql="select * from t_sgtasktype";
        List<SgTaskType> sg=new ArrayList<SgTaskType>();
        sg=entityManager.createNativeQuery(sql,SgTaskType.class).setFirstResult(page).setMaxResults(rows).getResultList();
        if(!sg.isEmpty()){
            return sg;
        }else{
            return null;
        }
        
    }
}