mapper.xml里面的if问题

[qq_31098647]

<!-- 主键查询 -->
<select id="selectByPrimaryKey" resultClass="userInfo" parameterClass="userInfo">
SELECT
<include refid="userInfo_Column_List"/>
FROM user_info
WHERE login_name = #login_name#
<if test=' isAreaVersion== "1" '>
<isNotEmpty prepend="and" property="outhosid"> <!-- 登录时的医院ID -->
hosid=#outhosid#
</isNotEmpty>
</if>


错误信息：
The content of element type "select" must match "(include|dynamic|iterate|isParameterPresent|
isNotParameterPresent|isEmpty|isNotEmpty|isNotNull|isNull|isNotEqual|isEqual|isGreaterThan|
isGreaterEqual|isLessThan|isLessEqual|isPropertyAvailable|isNotPropertyAvailable)".

[zhangpf的代码人生]

你的select并没有if这个标签，注意一下mybatis或者ibatis的版本

[木子0204]

<select id="selectByParams" resultMap="BaseResultMap"> select <include refid="Base_Column_List" /> from t_active_flow <include refid="Example_Where_Clause" /> </select> 里面是这样的 ，你的if应该放到 Example_Where_Clause条件里面吧 <sql id="Example_Where_Clause"> <if test=' isAreaVersion== "1" '> <isNotEmpty prepend="and" property="outhosid"> <!-- 登录时的医院ID --> hosid=#outhosid# </isNotEmpty> </if> </sql> 类似这样的