源代码
<select id="getPurMaterialMaxAreanum" parameterType="java.lang.Integer" resultType="java.lang.Integer">
SELECTmax(areanum)
FROM
pur_material
WHERE
needs=0
<if test="areaid != null" >
AND areaid = #{areaid,jdbcType=INTEGER}
</if>
</select>
现代码
<select id="getPurMaterialMaxAreanum" parameterType="java.lang.Integer" resultType="java.lang.Integer">
SELECTmax(areanum)
FROM
pur_material
WHERE
needs=0
<if test="_parameter != null" >
AND areaid = #{_parameter}
</if>
</select>