天天看点

内嵌的Jetty启动后访问503

<!--author:wlj -->
  <!--date:2016-05-19 -->
  <!--desc:查询用户(商家,普通用户)信息列表,根据账号,昵称模糊查询 -->
  <select id="listUserPage" resultType="Dto" parameterType="Dto">
    SELECT
    <include refid="cn.usmaker.common.dao.mapper.Shop_userMapper.column2" />,
    (select nickname_ from shop_user as p_user where p_user.id_ = shop_user.fk_introducer_id_) as
    introducer_name_
    from shop_user
      <where>
      <if test="hotkey !=null and hotkey !=''">
        and
        ( shop_user.account_ like '%${hotkey}%'
        or
          shop_user.nickname_ like '%${hotkey}%'
        )
      </if>
      <if test="true">
        and
          shop_user.type_=#{type_}<!--用户类型:1:普通用户;2:商家用户 -->
      </if>
    </where>