(记录)异步并发,多线程处理表的统计

结果集对象

package com.huike.report.domain.vo;

import lombok.Data;

/**
 * 首页基本数据VO对象
 */
@Data
public class IndexBaseInfoVO {
    private Integer cluesNum=0;  //线索数目
    private Integer businessNum=0;  //商机数目
    private Integer contractNum=0;  //合同数目
    private Double salesAmount=0.0;  //销售金额
}

 安全工具类(获得登录用户信息)

package com.huike.common.utils;

import org.springframework.security.core.Authentication;
import org.springframework.security.core.context.SecurityContextHolder;
import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
import com.huike.common.constant.HttpStatus;
import com.huike.common.core.domain.model.LoginUser;
import com.huike.common.exception.CustomException;

/**
 * 安全服务工具类
 * 
 * 
 */
public class SecurityUtils
{
    /**
     * 获取用户账户
     **/
    public static String getUsername()
    {
        try
        {
            return getLoginUser().getUsername();
        }
        catch (Exception e)
        {
            throw new CustomException("获取用户账户异常", HttpStatus.UNAUTHORIZED);
        }
    }

    public static Long getUserId()
    {
        try
        {
            return getLoginUser().getUser().getUserId();
        }
        catch (Exception e)
        {
            throw new CustomException("获取用户账户异常", HttpStatus.UNAUTHORIZED);
        }
    }

    public static Long getDeptId()
    {
        try
        {
            return getLoginUser().getUser().getDeptId();
        }
        catch (Exception e)
        {
            throw new CustomException("获取用户账户异常", HttpStatus.UNAUTHORIZED);
        }
    }

    /**
     * 获取用户
     **/
    public static LoginUser getLoginUser()
    {
        try
        {
            return (LoginUser) getAuthentication().getPrincipal();
        }
        catch (Exception e)
        {
            throw new CustomException("获取用户信息异常", HttpStatus.UNAUTHORIZED);
        }
    }

    /**
     * 获取Authentication
     */
    public static Authentication getAuthentication()
    {
        return SecurityContextHolder.getContext().getAuthentication();
    }

    /**
     * 生成BCryptPasswordEncoder密码
     *
     * @param password 密码
     * @return 加密字符串
     */
    public static String encryptPassword(String password)
    {
        BCryptPasswordEncoder passwordEncoder = new BCryptPasswordEncoder();
        return passwordEncoder.encode(password);
    }

    /**
     * 判断密码是否相同
     *
     * @param rawPassword 真实密码
     * @param encodedPassword 加密后字符
     * @return 结果
     */
    public static boolean matchesPassword(String rawPassword, String encodedPassword)
    {
        BCryptPasswordEncoder passwordEncoder = new BCryptPasswordEncoder();
        return passwordEncoder.matches(rawPassword, encodedPassword);
    }

    /**
     * 是否为管理员
     * 
     * @param userId 用户ID
     * @return 结果
     */
    public static boolean isAdmin(Long userId)
    {
        return userId != null && 1L == userId;
    }

    public static Long getAdmin()
    {
        return 1L;
    }
}

 引入一个utils

异步并发,多线程处理表的统计

 /**
     * 获取首页基本数据
     * 异步的并发,多线程处理表的统计
     * @param beginCreateTime
     * @param endCreateTime
     * @return
     */
    @Override
    public IndexBaseInfoVO getBaseInfo(String beginCreateTime, String endCreateTime) {
        //1）构建一个空的结果集对象
        IndexBaseInfoVO result = new IndexBaseInfoVO();
        //封装结果集属性
        // 2.1 由于查询需要用到用户名 调用工具类获取用户名
        String username = SecurityUtils.getUsername();
        try {

            CompletableFuture<Integer> cluesNum=CompletableFuture.supplyAsync(()->{
                //查询第一个属性 线索数量
                return reportMpper.getCluesNum(beginCreateTime, endCreateTime, username);
            });
            CompletableFuture<Integer> businessNum=CompletableFuture.supplyAsync(()->{
                //查询第一个属性 商机数量
                return reportMpper.getBusinessNum(beginCreateTime, endCreateTime, username);
            });
            CompletableFuture<Integer> contractNum=CompletableFuture.supplyAsync(()->{
                //查询第一个属性 合同数量
                return reportMpper.getContractNum(beginCreateTime, endCreateTime, username);
            });
            CompletableFuture<Double> salesAmount=CompletableFuture.supplyAsync(()->{
                //查询第一个属性,销售金额
                return reportMpper.getSalesAmount(beginCreateTime, endCreateTime, username);
            });
            //join 等待所有线程全部执行完
            CompletableFuture
                    .allOf(cluesNum,businessNum,contractNum,salesAmount)
                    .join();
            //封装结果集对象
            result.setCluesNum(cluesNum.get());
            result.setBusinessNum(businessNum.get());
            result.setContractNum(contractNum.get());
            result.setSalesAmount(salesAmount.get());
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
        //4 返回结果集对象
        return result;
    }