MyBatis 提示：A query was run and no Result Maps were found for the Mapped Statement

谁借莪１个温暖的怀抱￠ 2023-10-18 18:37 13阅读 0赞

错误\*Mapper.xml文件：

<select id="select" parameterType="map">
      	 select sid, name_, `type_`, `length`, decimal_, required, primary_, default_value, 
        	comment_, create_dt, create_by, update_dt, update_by, bus_table_id, version, `state`, 
        	delete_flag, code_, desc_
        	from ucas_bus_column
        	where 1 = 1
        	<if test="busTableId != null and busTableId !=''">
        		and bus_table_id = #{busTableId,jdbcType=VARCHAR}
        	</if>
        	<if test="notBusTableId != null and notBusTableId !=''">
        		and <![CDATA[ bus_table_id <> #{notBusTableId,jdbcType=VARCHAR} ]]>
        	</if>
      </select>

错误原因：缺少配置resultMap 标签

正确\*Mapper.xml 文件:

<select id="select" parameterType="map" resultMap="BaseResultMap">
      	 select sid, name_, `type_`, `length`, decimal_, required, primary_, default_value, 
        	comment_, create_dt, create_by, update_dt, update_by, bus_table_id, version, `state`, 
        	delete_flag, code_, desc_
        	from ucas_bus_column
        	where 1 = 1
        	<if test="busTableId != null and busTableId !=''">
        		and bus_table_id = #{busTableId,jdbcType=VARCHAR}
        	</if>
        	<if test="notBusTableId != null and notBusTableId !=''">
        		and <![CDATA[ bus_table_id <> #{notBusTableId,jdbcType=VARCHAR} ]]>
        	</if>
      </select>