<sql id="commonSql">
select * from <!--多条sql语句都有的部分-->
</sql>
<select id="selectFoodByFoodName" resultType="map">
<include refid="commonSql"></include> foods where foodname like '%${a}%'
</select>
select * from <!--多条sql语句都有的部分-->
</sql>
<select id="selectFoodByFoodName" resultType="map">
<include refid="commonSql"></include> foods where foodname like '%${a}%'
</select>