19 layui 的条件查询以及传递参数

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <title>layui</title>
  <meta name="renderer" content="webkit">
  <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <link rel="stylesheet" href="//res.layui.com/layui/dist/css/layui.css"  media="all">
  <!-- 注意：如果你直接复制所有代码到本地，上述css路径需要改成你本地的 -->
</head>
<body> 
 
<div class="demoTable">
  搜索ID：
  <div class="layui-inline">
    <input class="layui-input" name="id" id="demoReload" autocomplete="off">
  </div>
  <button class="layui-btn" data-type="reload">搜索</button>
</div>
 
<table class="layui-hide" id="LAY_table_user" lay-filter="user"></table> 
               
          
<script src="//res.layui.com/layui/dist/layui.js" charset="utf-8"></script>
<!-- 注意：如果你直接复制所有代码到本地，上述js路径需要改成你本地的 -->
<script>
layui.use('table', function(){
  var table = layui.table;
  
  //方法级渲染
  table.render({
    elem: '#LAY_table_user'
    ,url: '/demo/table/user/'
    ,cols: [[
      {checkbox: true, fixed: true}
      ,{field:'id', title: 'ID', width:80, sort: true, fixed: true}
      ,{field:'username', title: '用户名', width:80}
      ,{field:'sex', title: '性别', width:80, sort: true}
      ,{field:'city', title: '城市', width:80}
      ,{field:'sign', title: '签名'}
      ,{field:'experience', title: '积分', sort: true, width:80}
      ,{field:'score', title: '评分', sort: true, width:80}
      ,{field:'classify', title: '职业', width:80}
      ,{field:'wealth', title: '财富', sort: true, width:135}
    ]]
    ,id: 'testReload'
    ,page: true
    ,height: 315
  });
  
  var $ = layui.$, active = {
    reload: function(){
      var demoReload = $('#demoReload');
      
      //执行重载
      table.reload('testReload', {
        page: {
          curr: 1 //重新从第 1 页开始
        }
   , method: 'POST'
        ,where: {
          key: {
            id: demoReload.val()
          }
        }
      });
    }
  };
  
  $('.demoTable .layui-btn').on('click', function(){
    var type = $(this).data('type');
    active[type] ? active[type].call(this) : '';
  });
});
</script>

</body>
</html>

后台接受参数：


@RequestMapping("/api")
@RestController
public class BackstageBankController {
    @RequestMapping("/companyinit")
    public Map<String, Object> CompanyInit(@RequestParam Map<String, Object> params){
        return  params;
    }

}

service

 public ResponseModel<ResponseCode,Object> CompanyInit(Map<String, Object> params) {
        ResponseModel<ResponseCode,Object> responseModel=new ResponseModel<>();
 try{
            PageHelper.startPage(1,5); //一行代码实现分页
            //创建条件查询对象
            Example example =new Example(BackstageBankEntity.class);
            Example.Criteria criteria =example.createCriteria();

  if(params.get("condition").equals("3")){//3,为公司名称，2为 账号
                criteria.orLike("realname","%"+params.get("CorporateName")+"%");
            }else if(params.get("condition").equals("2")){
               criteria.orLike("username","%"+params.get("CorporateName")+"%");
            }
            example.setOrderByClause("id desc");
            List<BackstageBankEntity>  list =backstageBankMapper.selectByExample(example);
   for (BackstageBankEntity backstageBankEntity:list)
                backstageBankEntity.setBankpassword(null);//设置name为空（当不需要再前台出现的数据都可以这样设置）
            PageInfo<BackstageBankEntity> pojoPageInfo =new PageInfo<>(list); //装填数据
          responseModel.setData(list)
                         .setCount(pojoPageInfo.getPageNum())      //装填的数据是关键不然出不来数据（返回的code为0，data为数据性质）
                      .setCode(ResponseCode.SUCCESS.getCode());
  }catch (Exception e){
            e.getStackTrace();
            responseModel.setException(e)
            .setCode(-1);
        }
         return  responseModel;
    }
}

19 layui 的条件查询以及传递参数

推荐阅读更多精彩内容