【MyBatis】There is no Getter for prpperty named "XXX"

最新推荐文章于 2023-05-16 10:03:43 发布

转载最新推荐文章于 2023-05-16 10:03:43 发布 · 328 阅读

文章标签：

#mybatis

『问题记录』专栏收录该内容

22 篇文章

订阅专栏

博客主要讲述了MyBatis出现异常的情况，具体为if test判空时，报There is no getter for property named 'companyId' in 'class java.lang.Long'错误。同时给出了两种解决方案，一是修改mapper接口，二是修改mapper文件。

转自：https://blog.youkuaiyun.com/u011662320/article/details/80612425

mybatis异常:

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'companyId' in 'class java.lang.Long'

mapper接口:

 List<BranchInfo> findListStatus1(Long companyId );

mybatis的mapper文件:


    <select id="findListStatus1"  parameterType="java.lang.Long" resultType="com.xm.admin.dao.model.BranchInfo">
        SELECT * FROM branch_info
        WHERE status = 1
        <if test="companyId != null">
            and company_id = #{companyId,jdbcType=BIGINT}
        </if>
    </select>

报错是mybatis中if test的判空时报错了。

解决方案1:

mapper接口改为：

 List<BranchInfo> findListStatus1(@Param(value="companyId")Long companyId );

引入的jar包：

import org.apache.ibatis.annotations.Param;

解决方案二:

修改mapper文件:


    <select id="findListStatus1"  parameterType="java.lang.Long" resultType="com.xm.admin.dao.model.BranchInfo">
        SELECT * FROM branch_info
        WHERE status = 1
        <if test="_parameter != null">
            and company_id = #{companyId,jdbcType=BIGINT}
        </if>
    </select>