jfinal框架中jQuery从后台获取数据，并在页面滚动显示

最新推荐文章于 2022-01-17 15:23:38 发布

iamlzjoco

最新推荐文章于 2022-01-17 15:23:38 发布

阅读量400

点赞数 1

文章标签： jfinal 给ul标签绑定数据滚动显示数据

本文链接：https://blog.csdn.net/iamlzyoco/article/details/93976199

版权

1.dao层：

public List<ZkltSjjl> getCoverageRate(){
       String sql = "select c.name,trunc((c.num / b.total)*100,2) amount from (select b.name, a.jfdd,count(1) num from zklt_sjjl a\n" +
               "left join zklt_area b on b.id = a.jfdd where a.jflx = '1' group by b.name,a.jfdd)c,\n" +
               "(select count(1) total from zklt_base_book)b order by amount desc";
       return ZkltSjjl.dao.find(sql);
   }

2.controller层：

public void getCoverageRate() {
       List<ZkltSjjl> coverageRate = ZkltSjjl.dao.getCoverageRate();
       renderJson(coverageRate);
   }

3.HTML层：

<!DOCTYPE html>
<html lang="en">
<head>
   <meta charset="UTF-8">
   <title>滚动</title>
   <script src="http://libs.baidu.com/jquery/1.11.1/jquery.min.js"></script>
   <style>
       *{padding: 0;margin: 0;}
       body{margin: 10px;}
       ul{list-style-type: none;}
       ul li{height: 10px; line-height: 10px;}
   </style>
</head>
<script type="text/javascript">

$(document).ready(function(){
   $.ajax({
       type:"get",
       url:ctx + "/admin/zklt/payInfo/getCoverageRate",
       dataType:"json",
       success:function(data){
           //console.log(data.length)
           var coverageList = "";
            $.each(data,function(i,item){   //遍历ul中的li
                  if(null == item.name){
   coverageList += "<li>其他:"+item.amount+"%"+"</li><br>";
               }else{
                   coverageList += "<li>"+item.name+":"+item.amount+"%"+"</li><br>";
               }
             });
            $('#rateList').html(coverageList);

       },
       error:function(){
           alert("error");
       }
   })
});

</script>
<body>
   <ul id="rateList">
   </ul>
   <script>
   setInterval(function(){
       $('ul').children().first().clone(true).appendTo('ul');
       $('ul>:first').remove();
   },1000);
   </script>
</body>
</html>

iamlzjoco

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
jfinal框架中jQuery从后台获取数据，并在页面滚动显示

1.dao层：public List<ZkltSjjl> getCoverageRate(){ String sql = "select c.name,trunc((c.num / b.total)*100,2) amount from (select b.name, a.jfdd,count(1) num from zklt_sjjl a\n" + ...
复制链接

扫一扫