Total query data:
<select id= "SelectCount"resulttype= "Java.lang.Integer"> <!--WARNING-@mbggenerated This element was automatically generated by MyBatis Generator, DoNot modify. -select COUNT (id) from Tb_user<where > <ifTest= "Username! = NULL" >and username like'%${username,jdbctype=varchar}% ' </if> <ifTest= "Start_time! = null" >and Addtime>= #{start_time,jdbctype=TIMESTAMP}</if> <ifTest= "End_time! = null" >and Addtime<= #{end_time,jdbctype=TIMESTAMP}</if> </where> </select>
Paging query:<select id= "Getuserforpage"resultmap= "Baseresultmap"> <!--WARNING-@mbggenerated This element was automatically generated by MyBatis Generator, DoNot modify. -Select<include refid= "Base_column_list"/>From Tb_user<where > <ifTest= "Username! = NULL" >and username like'%${username,jdbctype=varchar}% ' </if> <ifTest= "Start_time! = null" >and Addtime>= #{start_time,jdbctype=TIMESTAMP}</if> <ifTest= "End_time! = null" >and Addtime<= #{end_time,jdbctype=TIMESTAMP}</if> </where>Limit #{index},#{num}</select>
MyBatis SQL Paging processing and querying total data volume