mybatis @Update注解 用if实现条件判断更新

在更新时先判断传入的参数是否为null或空串以实现条件更新

 @Update({
            "<script> ",
            "update tb_user_info set ",
            "<if test = "uprofession != null"> ",
            "uprofession=#{uprofession}, ",
            "</if> ",
            "<if test = "umajor != null"> ",
            "umajor=#{umajor}, ",
            "</if> ",
            "<if test = "directionOfStudy != null"> ",
            "directionOfStudy=#{directionOfStudy}, ",
            "</if> ",
            "update_time=CURRENT_TIMESTAMP ",
            "WHERE user_id=#{user_id}",
            "</script>"
            })
    void updateUserInfo(
                        @Param("user_id") int user_id,
                        @Param("uprofession") String uprofession,
                        @Param("umajor") String umajor,
                        @Param("directionOfStudy") String directionOfStudy
                        );

版权声明:本文为m0_67402914原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。