批量添加、修改、查询相关Java代码

批量添加

void insertRiderCompute(@Param("riderMoneyReportPos") List<RiderMoneyReportPo> riderMoneyReportPos);

<insert id="insertRiderCompute">
INSERT INTO tb_rider_money_report
(rider_money,rider_user_id,status,create_time,zhi_fu_bao,zhi_fu_bao_name,type)
VALUES
<foreach collection="riderMoneyReportPos" item="item" index="index" separator=",">
(
#{item.riderMoney},
#{item.riderUserId},
#{item.status},
#{item.createTime},
#{item.zhiFuBao},
#{item.zhiFuBaoName},
#{item.type}
)
</foreach>
</insert>

批量查询

List<TbOrderVo> selectByTime(@Param("startTime") String startTime, @Param("endTime") String endTime,
@Param("shopId") Long shopId, @Param("type") String type,
@Param("schoolShops") List<String> schoolShops);

select tr.shops_money as shopsMoney,tr.shops_id,tr.status,tr.create_time,tr.update_time,tr.type,gs.shop_name,gs.phone,
tr.sum_platform_money as sumPlatformMoney,tr.sum_rider_money as sumRiderMoney,tr.deduction_earning as deductionEarning,tr.sum_order_money as sumOrderMoney
from tb_shop_money_report tr
left join goods_shop gs on tr.shops_id=gs.shop_id
where 1=1
<if test="schoolShops!=null and schoolShops.size()>0">
AND tr.shops_id in
<foreach collection="schoolShops" item="item" open="(" close=")" separator=",">
#{item}
</foreach>
</if>
<if test="schoolShops.size()==0">
AND tr.shops_id in ('')
</if>

批量修改

Integer importInfo(@Param("students")List<Student> students,@Param("classroom")String classroom);

<update id="importInfo">
        update tab_student set
        <foreach collection="students" item="student" open="classroom= case id" close="end">
            when #{student.id} then #{student.classroom}
        </foreach>
        where id in
        <foreach collection="students" item="student" open="(" close=")" separator=",">
            #{student.id}
        </foreach>
    </update>