您好, 欢迎来到 !    登录 | 注册 | | 设为首页 | 收藏本站

Spring操作更新数据库字段

bubuko 2022/1/25 18:59:09 java 字数 3264 阅读 755 来源 http://www.bubuko.com/infolist-5-1.html

ActivityInfoServiceImpl.java @Service("IActivityInfoService") @Slf4j public class ActivityInfoServiceImpl extends ServiceImpl<ActivityInfoMapper, Acti ...

ActivityInfoServiceImpl.java

@Service("IActivityInfoService")
@Slf4j
public class ActivityInfoServiceImpl extends ServiceImpl<ActivityInfoMapper, ActivityInfo> implements IActivityInfoService {
    @Autowired
    private IActivityReadService activityReadService;
    @Autowired(required = false)
    private ActivityReadMapper activityReadMapper;

    private void addActivityReadRecord(String uid, ActivityInfo info, String shareCode) {
       activityReadService.getOne(Wrappers.<ActivityRead>lambdaQuery()
            .eq(ActivityRead::getActivityUid, activityUid)
            .eq(ActivityRead::getCustomerUid, useUid),false);    
            
            if(ObjectUtil.isNotNull(activityRead))
            activityReadMapper.increaseReadTime(uid , info.getUid());
    }
}

 

 

ActivityReadMapper.xml

<mapper namespace="com.xypopo.market.mapper.ActivityReadMapper">
    <update id="increaseReadTime">
        update activity_read set read_times = read_times + 1 where customer_uid = #{customerUid} and activity_uid = #{activityUid}
    </update>
</mapper>

 

 

ActivityReadMapper.java
public interface ActivityReadMapper extends BaseMapper<ActivityRead> {
    boolean increaseReadTime(@Param("customerUid") String customerUid, @Param("activityUid") String activityUid);
}

 

 

此处是SpringBoot和mybatis-plus实现了此处一个接口的业务逻辑,把用户报名人数用数据库方式加一,而不使用get和set去存取实现

 

Spring操作更新数据库字段

原文:https://www.cnblogs.com/coder-Fish/p/15074467.html


如果您也喜欢它,动动您的小指点个赞吧

除非注明,文章均由 laddyq.com 整理发布,欢迎转载。

转载请注明:
链接:http://laddyq.com
来源:laddyq.com
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。


联系我
置顶