MyBatis动态传入表名查询数据

@RequestMapping("/searchSjgl.htm")
    @ResponseBody
    public List<IdSjgl> searchSjgl(HttpServletRequest request)throws UnsupportedEncodingException{
        List<IdSjgl> list=sjglService.findAllSjgl();//查询所有数据
        String stdate=request.getParameter("stdate").trim();//获取前端传来的ID值
        for(IdSjgl sjgl:list){
            Map<String,String> map1 = new HashMap<String,String>();
            map1.put("tableName", sjgl.getSjkb());
//          List<IdId_> shList=sjglService.findSjTest(map1,map2);
            List<IdId_> shList=sjglService.findSj(map1);
            //List<IdId_> shList=sjglService.findSj(sjgl.getSjkb());
            if(shList.size()==0||shList.equals(null)){
                sjgl.setSfwk("无数据");
                sjgl.setSfsh("未审核");
                sjglService.update(sjgl);
//              for(IdId_ id:shList){
//                  if(id.getSh()==0){
//                  }
//              }
            }else{
                for(IdId_ id:shList){
                    if(id.getStdate().equals(stdate)){
                        sjgl.setSfwk("有数据");
                        if(id.getSh()==1){
                            sjgl.setSfsh("已审核");
                        }
                    }else{
                        sjgl.setSfwk("无数据");
                        sjgl.setSfsh("未审核");           
                    }
                    sjglService.update(sjgl);
                }
            }  
        }
        return sjglService.findAllSjgl();
    }
     
     
<select id="findSj" resultMap="Idresult" statementType="STATEMENT" >
        select sh,stdate from ${tableName}
</select>

转载于:https://my.oschina.net/CarrieLiu/blog/1554502