sql语句
<select id="selectBymh" resultType="house" parameterType="house"> select * from t_house <where> <if test="houseNum!=null and houseNum!=''"> and houseNum like concat(concat('%',#{houseNum},'%')) </if> <if test="houseName!=null and houseName!=''"> and houseName like concat(concat('%',#{houseName},'%')) </if> </where> order by houseNum asc </select>