mybatis的sql标签

1. 静态

<sql id="factoryColumns">factory_index,factory_id,system_name,model_num,model_id</sql>

<select id="listAllInfoByFactoryId" resultMap="factoryResultMap" parameterType="Integer">        select <include refid="factoryColumns"/> from tb2_factory where factory_id = #{factoryId}    </select>

1. 动态

<sql id="userColumns"> ${alias}.id,${alias}.password </sql> 

<select id="findUserById" parameterType="String" resultType="User">  select <include refid="userColumns"><property name="alias" value="u"/></include> from sysuser u where id=#{id}  </select>