sqlserver的不同版本有不同的分页语句,在这里只是我使用的版本。
mapper.xml文件下分页语句如下:
<select id="findInfoByPage" resultType="com.lyjg.lyjgsc.entity.Info">
SELECT
TOP 15
s.[作业单号] jobOrder,
s.[图号] figureNumber,
s.[计划单号] projectNumber,
s.[零件名称] nameOfParts,
s.[材料] material,
s.[完工工序] wggx,
s.[完工日期] sjdate,
s.[生产数量] num,
s.[生产状态] productionState,
s.zydtime zddate,
s.[预计完工日期] yjdate,
s.[客户] client
FROM
scjdgzb s WHERE 1=1 AND s.ID NOT IN
(SELECT TOP ${page} ID FROM scjdgzb c WHERE 1=1
<if test="productionState != null and productionState != ''" >
AND c.[生产状态] = #{productionState}
</if>
<if test="nameOfParts != null and nameOfParts != ''" >
AND c.[零件名称] LIKE '%'+#{nameOfParts}+'%'
</if>
<if test="jobOrder != null and jobOrder != ''" >
AND c.[作业单号] LIKE &