英雄云在关联查询调取到怎么将采集的数据上传云端可以保存到表单中吗？选择数据调取呢？

来源：蜘蛛抓取(WebSpider) 时间：2023-12-18 06:01 标签： 怎么将采集的数据上传云端
最近项目中有一个需求分页查询数据，并在各页勾选相应的checkbox框进行保存。项目采用的是layui+mybatis+mysql+springboot实现。实现思路:定义一个存储用户ID的数组，监听表单checkbox将选中的角色ID放入数组和取消的角色ID删除。页面初始化时通过layui的parseData将选中的角色ID放入用户ID数组中。jsp页面<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %>
Controller @ResponseBody @RequestMapping(value = "/getOperativeRoleMapList") public void getOperativeRoleMapList(HttpServletRequest request, HttpServletResponse response, PageParam pageParam) throws Exception { Page pager = new Page(); pager.setPage(pageParam.getPage()); pager.setRecPerPage(pageParam.getLimit()); PageData> pd = new PageData>(); PageInfo> pageInfo = permissionService.getOperativeRoleMapPageInfo(request, pageParam); List> list = pageInfo.getList(); //获取用户ID,通过用户ID查询角色ID,如果查询出的角色信息包含通过用户ID查询出的角色设置LAY_CHECKED为true String userId = request.getParameter("userId"); if(StringUtils.isNotBlank(userId)){ List roleIdList = permissionService.getOperativeRoleIdsByUserId(Long.parseLong(userId)); if(CollectionUtils.isNotEmpty(roleIdList)){ for (Map map : list) { Long roleId = MapUtils.getLong(map,"ROLEID"); map.put("roleId",roleId); map.put("roleName",MapUtils.getString(map,"ROLENAME")); map.put("description",MapUtils.getString(map,"DESCRIBTION")); map.put("LAY_CHECKED",roleIdList.contains(roleId)?true:false); //map.put("status",roleIdList.contains(roleId)?true:false); System.out.println(map); } } } if(list!= null && list.size()>0){ pd.setCount((int) pageInfo.getTotal()); pd.setData(list); }else{ pd.setCount(0); pd.setData(new ArrayList>()); } String json = JsonUtil.toJson(pd); response.setContentType("text/html;charset=utf-8"); PrintWriter out; try { out = response.getWriter(); out.print(json); out.flush(); out.close(); } catch (IOException e) { e.printStackTrace(); } } Servicepackage com.tele.health.operation.api.service; import com.github.pagehelper.PageInfo; import com.tele.health.operation.api.bo.PageParam; import javax.servlet.http.HttpServletRequest; import java.util.List; import java.util.Map; /** * ClassName:PermissionService * Package：com.tele.health.operation.api.service * Description: * * @Date:2020-03-04 9:43 * @Author:liyutao */ public interface PermissionService { PageInfo> getOperativeRoleMapPageInfo(HttpServletRequest request, PageParam pageParam); } ServiceImplpackage com.tele.health.operation.api.service.impl; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import com.tele.health.operation.api.bo.PageParam; import com.tele.health.operation.api.domain.OperativeUserRole; import com.tele.health.operation.api.mapper.OperativeRoleMapper; import com.tele.health.operation.api.mapper.OperativeUserMapper; import com.tele.health.operation.api.util.StringUtil; import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Propagation; import org.springframework.transaction.annotation.Transactional; import javax.servlet.http.HttpServletRequest; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; /** * ClassName:PermissionServiceImpl * Package：com.tele.health.operation.api.service.impl * Description: * @Date:2020-03-04 9:43 * @Author:liyutao */ @Service public class PermissionServiceImpl implements PermissionService { @Autowired private OperativeUserMapper operativeUserMapper; @Autowired private OperativeRoleMapper operativeRoleMapper; @Override public List getOperativeRoleIdsByUserId(long userId) { return operativeUserMapper.getRoleIdsByUserId(userId); } @Override public PageInfo> getOperativeRoleMapPageInfo(HttpServletRequest request, PageParam pageParam) { PageHelper.startPage(pageParam.getPage(), pageParam.getLimit()); Map params = new HashMap<>(); List> operativeRoleMapList = operativeRoleMapper.getOperativeRoleMapByParams(params); PageInfo> objectPageInfo = new PageInfo<>(operativeRoleMapList); return objectPageInfo; } } Mapper.xml

我要回帖

更多关于 怎么将采集的数据上传云端 的文章

 

随机推荐