(1)定义
<sql id="Base_Column_List">
patient_id, real_name, id_card, gender, getItemName('gender', gender) genderText, mobile_phone, phone, email, patient_card, province,
city, district, street, addr, nation, birthday, edu_degree, is_married, photo, relationship,
is_remove, create_date, update_date, customer_id, hospital_id, user_id
</sql>
(2)使用
<select id="queryByUserId" resultMap="BaseResultMap" parameterType="java.lang.String">
select
<include refid="Base_Column_List"/>
from patient
where user_id = #{user_id,jdbcType=VARCHAR}
</select>