mybatis分页XML代码集成sqlserver

 XML：

   <sql id="Base_Column_List">
        id, deviceid, ipAddress, cph, deCph, ownerName, type, ownNo, contact1,
        contact2,
        alarmLinkTel, linkTel2, TaxiNo, yyZh, zyZh, districtCode, frameNo,
        engineNo, vehicleType,
        brand, color, purchaseDate, purchaseSum, seller, enrolDate, logOut,
        logOutCause,
        logOutDate, yhRzMm, byZd, insertTime, drvId, iAccStatues, iDBType,
        webPass, productCode,
        installPerson, installAddress, recordPerson, businessPerson, marks,
        setMarks, serverEndTime,
        serverMoney, contact3, contactPhone3, baseInfoMark, centerNumber,
        huiYuan, csBrand,
        customNo, delFlag, state, createTime, updateTime, repairTime,
        insuranceTime, certificateTime,
        gasCylinder1#, gasCylinder2#, gasCylinder3#, gasCylinder4#,
        overSpeedValue
    </sql> 

<sql id="Example_Where_Clause">
        <where>
            <foreach collection="oredCriteria" item="criteria" separator="or">
                <if test="criteria.valid">
                    <trim prefix="(" suffix=")" prefixOverrides="and">
                        <foreach collection="criteria.criteria"
                                 item="criterion">
                            <choose>
                                <when test="criterion.noValue">
                                    and ${criterion.condition}
                                </when>
                                <when test="criterion.singleValue">
                                    and ${criterion.condition}
                                    #{criterion.value}
                                </when>
                                <when test="criterion.betweenValue">
                                    and ${criterion.condition}
                                    #{criterion.value} and
                                    #{criterion.secondValue}
                                </when>
                                <when test="criterion.listValue">
                                    and ${criterion.condition}
                                    <foreach collection="criterion.value"
                                             item="listItem" open="(" close=")"
                                             separator=",">
                                        #{listItem}
                                    </foreach>
                                </when>
                            </choose>
                        </foreach>
                    </trim>
                </if>
            </foreach>
        </where>
    </sql>

 <select id="selectVehiclePageByExample" resultMap="BaseResultMap"
            parameterType="com.tc.lvmsm.vo.vm.VehicleExample">
        SELECT
        <include refid="Base_Column_List"/>
        FROM
        (SELECT ROW_NUMBER() OVER(ORDER BY ID DESC) AS rowid,
        <include refid="Base_Column_List"/>
        FROM C_VM_Vehicle
        <if test="_parameter != null">
            <include refid="Update_By_Example_Where_Clause"/>
        </if>
        )t
        WHERE
        t.rowid > ${startPos}
        AND
        t.rowid &lt; = (${pageSize} + (${startPos} ))

        <if test="orderByClause != null and  orderByClause !=''">
            order by ${orderByClause}
        </if>

    </select>