<sql id="test1">
    id,name_a as name1,name_b AS name2,cid
    </sql>

    <select id="no1" resultType="com.zb.entity.No1">
       select <include refid="test1"></include> from no1;
    </select>

 <resultMap id="test1" type="com.zb.entity.No1">
        <result column="name_a" property="name1"></result>
        <result column="name_b" property="name2"></result>
    </resultMap>

    <select id="no1" resultMap="test1">
       select * from no1;
    </select>