首页 > 数据库技术 > 详细

Spring操作更新数据库字段

时间:2021-07-29 16:01:51      阅读:12      评论:0      收藏:0      [点我收藏+]

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

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!