模糊查询出list

<resultMap id="shipList" type="com.sinochem.yunlian.yunliantraffic.domain.Ship">
  <id column="id" property="id" />
  <result column="ship_name" property="shipName" />
  <result column="create_time_zt" property="createTimeZt" />
  <result column="update_time_zt" property="updateTimeZt" />
  <result column="ship_type" property="shipType" />
  <result column="call_sign" property="callSign" />
  <result column="ship_length" property="shipLength" />
  <result column="ship_width" property="shipWidth" />
  <result column="draught" property="draught" />
  <result column="mmsi" property="mmsi" />
  <result column="update_time" property="updateTime" />
</resultMap>


<select id="getShipByTerm" resultMap="shipList">
  select
  *
  from ship
  where ship_name or mmsi like concat('%',#{term},'%')
</select>