代码片段lll

//首页显示自己的数据
public Page<SysUserRoleVO> getUserRole(UserRoleQueryDTO userRoleQueryDTO) {
        UserInfo user = LocalProvider.getUser();
        Long companyId = Long.parseLong(user.getCompanyId());
        Integer companyType = user.getCompanyType();
        Long userId = Long.parseLong(user.getUserId());
        long num0 = userRoleQueryDTO.getCurrent(), num = num0;
        long size0 = userRoleQueryDTO.getSize(), size = size0;
        long total = 0;
        int flag = 0;
        if (num == 1 && size > 1) {
            flag = 1;
            size--;
        }
        if (num > 1 && size == 1) {
            flag = 2;
            num--;
        }
        if (num > 1 && size > 1) {
            flag = 3;
            num = (num - 1) * size;
            size = 1;
        }
        Page<SysUserRoleVO> page = new Page<>(num, size);
        SysUserRoleVO sysUserRoleVo = sysUserRoleMapper.selectMyRole(userId, companyType, companyId, userRoleQueryDTO);
        if (sysUserRoleVo == null) {
            page = new Page<>(num0, size0);
            return sysUserRoleMapper.selectUserRole(page, companyType, userRoleQueryDTO, companyId, userId);
        }
        Page<SysUserRoleVO> sysUserRoleVoList = sysUserRoleMapper.selectUserRole(page, companyType, userRoleQueryDTO, companyId, userId);
        List<SysUserRoleVO> list = new ArrayList<>();

        total++;
        sysUserRoleVo.setIsOperation((short) 0);
        if (flag == 0 || flag == 1) {
            list.add(sysUserRoleVo);
        }

        if (flag != 0 && flag != 3) {
            if (sysUserRoleVoList.getTotal() > 0) {
                list.addAll(sysUserRoleVoList.getRecords());
            }
            if (flag == 1) {
                sysUserRoleVoList.setSize(++size);
            }
            if (flag == 2) {
                sysUserRoleVoList.setCurrent(++num);
            }
        }
        if (flag == 3) {
            if (sysUserRoleVoList.getRecords().size() > 0) {
                list.addAll(sysUserRoleVoList.getRecords());
            }
            page = new Page<>(num0, size0);
            sysUserRoleVoList = sysUserRoleMapper.selectUserRole(page, companyType, userRoleQueryDTO, companyId, userId);
            if (sysUserRoleVoList.getRecords().size() > 0) {
                List<SysUserRoleVO> records = sysUserRoleVoList.getRecords();
                if (records.size() == size0) {
                    records.remove(sysUserRoleVoList.getRecords().size() - 1);
                }
                list.addAll(sysUserRoleVoList.getRecords());
            }
            sysUserRoleVoList.setSize(size0);
            sysUserRoleVoList.setCurrent(num0);
        }
        total += sysUserRoleVoList.getTotal();
        sysUserRoleVoList.setTotal(total);
        sysUserRoleVoList.setRecords(list);
        return sysUserRoleVoList;
    }

//mybatis xml
<where>
    <choose>
        <when test="param.companyType == 0">
            <if test="param.name != null and param.name.trim() != ''">
                and supplier_name like CONCAT('%',#{param.name},'%')
            </if>
        </when>
        <otherwise>
            and supplier_name = #{param.name}
        </otherwise>
    </choose>
    and is_delete = 1
</where>

<if test="ew.registerTime != null and ew.name.size > 0">
    AND o.register_time &gt;=  DATE_FORMAT(#{ew.registerTime},'%Y-%m-%d 00:00:00')
    AND o.register_time &lt;=  DATE_FORMAT(#{ew.registerTime},'%Y-%m-%d 23:59:59')
</if>

s.work_email IN
<foreach collection="workEmail" item="item" index="index" open="(" close=")" separator=",">
    #{item}
</foreach>

not exists ( select 1 from finance_order_apply as apply where apply.finance_order_undo_id = un.id and apply.is_delete = 1 )

'已办' AS `status`

<insert id="saveOrUpdate">
        <selectKey keyProperty="count" resultType="int" order="BEFORE">
            select count(*) from tms_bank_user_bank where user_id = #{data.userId} and bank_id = #{data.bankId}
        </selectKey>
        <if test="count > 0">
            update tms_bank_user_bank
            set is_delete = 0 , update_by = #{data.updateBy} , update_time = #{data.updateTime}
            where user_id = #{data.userId} and bank_id = #{data.bankId}
        </if>
        <if test="count==0">
            insert into tms_bank_user_bank(user_id , bank_id ,create_by , update_by ,create_time , update_time )
            values(#{data.userId},#{data.bankId},#{data.createBy},#{data.updateBy}, #{data.createTime},
            #{data.updateTime})
        </if>
</insert>

CASE WHEN b.acc_type = 'basic' THEN '基本户' ELSE '一般户' END )

<select id="insertOrUpdate">
        insert into tms_bank_refund(
        business_id,
        refund_time,...
        )
        values
        (
        #{tmsBankRefund.businessId},
        #{tmsBankRefund.refundTime},...
        )
        on duplicate key update
        business_id=#{tmsBankRefund.businessId},
        refund_time=#{tmsBankRefund.refundTime},...
</select>

//属性注入
a.b.c=d1,d2

@Value("#{'${a.b.c}'.split(',')}")
private List<String> roleCodes;

@Value("#{T(ChaincodeID).newBuilder().setName('${CHAINCODE_NAME}')}")
private ChaincodeID chainCodeId;