<select id="ibatorgenerated_selectByPrimaryKey" resultMap="ibatorgenerated_BaseResultMap"
  parameterClass="java.util.Map">
  select ROWNUM,t.* from (select
  m.procuct_name,m.cost_price,i.img_path,s.product_sku_id,s.product_id
  from
  kmproduct.product_sku s,
  kmproduct.productmain m,
  kmproduct.product_image i,
  bnes_browsing_his b
  where b.content_code=s.product_sku_code
  and s.product_sku_id=i.sku_id
  and i.product_id=m.product_id
  <dynamic prepend="AND">
              <![CDATA[
                  b.login_id = #loginId:NUMBER#
    ]]>
  </dynamic>
  )t
  <dynamic prepend="WHERE">
                <![CDATA[
                 ROWNUM <#rowNum:NUMBER#
    ]]>
   )t
  </dynamic>

 </select>

大神求指点啊  老是报错命令为正确结束  map参数是有值得我测试过