<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>