Mybatis注解开发 @Select @Insert @Update @Delete

最新推荐文章于 2025-06-24 10:26:02 发布

原创

最新推荐文章于 2025-06-24 10:26:02 发布 · 2.4k 阅读

7 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #mybatis #数据库 #oracle

Mybatis注解开发 @Select @Insert @Update @Delete

@Select用法

如果未使用mybatis的动态标签，则不需要加<script></script>标签
注意若数据库为在oracle，使用容易造成字段类型不匹配的问题

@Mapper
public interface RtcCheckParamBussDao {
    @Select(value = "<script>"+
            "select count(*) from r_verify_parm where code_type = 'TLT' " +
                    "<if test = 'branchCode != \"ALL\"' > and branch = #{branchCode,jdbcType=VARCHAR} </if>" +
                    "<if test = 'subBranchCode != \"ALL\"' > and sub_branch = #{subBranchCode,jdbcType=VARCHAR}</if>" +
                    "<if test = 'userId != null and userId != \"\"' > and verify_code = #{userId,jdbcType=VARCHAR} </if>"
    +"</script>")
    int checkUserBranch(@Param(value = "branchCode" ) String branchCode, @Param(value = "subBranchCode" )String subBranchCode,@Param(value = "userId" ) S