Spring Boot MyBatis-Plus setSql() 方法用法

自定义 SQL 片段

setSql(String setSql, Object... params)

boolean success = pointsService.lambdaUpdate()
        .eq(Points::getUserId, uid)
        .setSql("balance = balance - {0}", points)
        .setSql("expiring = expiring - {0}", points)
        .update(new Points());

setSql(boolean condition, String setSql, Object... params)

boolean condition = mpUser.getTotalSignDate() == null;

boolean success = mpUserService.lambdaUpdate()
        .eq(MpUser::getId, userId)
        .set(MpUser::getLastSignDate, date)
        .setSql(condition, "total_sign_date = 1")
        .setSql(!condition, "total_sign_date = total_sign_date + 1")
        .update(new MpUser());

与 apply() 方法区别

setSql仅用于update语句。

apply可用于select、update、delete、where等多个语句。