mysql返回自动生成序号
<select id="getPageData" parameterType="java.util.Map" resultMap="BaseResultMap2">
SELECT
@rownum :=@rownum + 1 AS ID,
SUB1.*
FROM
(
select
<include refid="Base_Column_List2"/>
FROM
qzq_ljqlx t1
LEFT OUTER JOIN
s_user t2
ON
t1.create_uid = t2.user_id AND
t2.del_flag = 0
WHERE
t1.del_flag = 0
AND
(t1.ljqlx_name LIKE '%${ljqlxName}%' OR t1.`LJQLX_CONTENT` LIKE '%${ljqlxContent}%')
limit #{beginIndex},#{pageSize}
) SUB1,
(SELECT @rownum := 0) r
</select>