<select id="selectByCondition" parameterType="java.util.HashMap" resultMap="BaseResultMap">

    select

    <include refid="Base_Column_List" />

    from sys_user

    where 1=1

    <if test="_parameter.containsKey('sysUserName')">

      and sys_user_name=#{sysUserName}

    </if>

    <if test="_parameter.containsKey('cBeginTime')">

      <![CDATA[

        and create_time >= #{cBeginTime}

      ]]>

    </if>

    <if test="_parameter.containsKey('cEndTime')">

      <![CDATA[

        and create_time < #{cEndTime}

      ]]>

    </if>

    <if test="_parameter.containsKey('uEndTime')">

      <![CDATA[

        and update_time < #{uEndTime}

      ]]>

    </if>

  </select>