//在mapper里直接写也可以,是另一种写法,实现都一样的 //@Update("UPDATE comment SET like_count = like_count + 1 WHERE id = #{id} AND status = 0") intincreaseLikeCount(@Param("id") Long id);
}
生成 CommentMapper.xml
1 2 3 4 5 6 7 8 9 10 11
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mappernamespace="com.mengze.mapper.CommentMapper"> <updateid="increaseLikeCount"> UPDATE comment SET like_count = like_count + 1 WHERE id = #{id} AND status = 0 </update>