今后有用吧

<!-- 车辆颜色管理 -->
<select id="selectVehicleColor" resultClass="HashMap" resultSetType="SCROLL_INSENSITIVE">
        select top <![CDATA[ $pageSize$  ]]>
v.ID as ID, v.RegistrationNo as RegistrationNo,c.Name as Name from
MSC_VehicleColor as c ,MSC_Vehicle as v
where v.id not in (select top
(($currentPage$-1) * $pageSize$) id from
MSC_VehicleColor order by id DESC)
and
v.VehicleColorID=c.id and c.Name like '%$name$%'
order by ID DESC
    </select>
<select id="selectVehicleColorcount" resultClass="java.lang.Long"
resultSetType="SCROLL_INSENSITIVE">
SELECT COUNT(*)
FROM MSC_VehicleColor as c ,MSC_Vehicle as v
where   v.VehicleColorID=c.id
   AND      c.Name like '%$name$%'
   </select>