<resultMap id="getallList" type="com.example.demo.pojo.node" autoMapping="true"> <result property="name" column="NameZh"></result> <result property="field" column="ResearchField"></result> </resultMap> <!--resultType="com.example.demo.pojo.node"--> <select id="findall" resultMap="getallList"> select s.NameZh ,s.ResearchField from researcher_basic_info_copy5 s <where> <if test="text != null"> and s.ResearchField like '%${text}%' </if> </where> </select>