多条件分页查询

下面展示一些 内联代码片。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.cjc.dao.StudentMapper">
<resultMap type="com.cjc.model.Students" id="stuMapper">
	<id property="stu_id" column="stu_id" />
	<result property="stu_name" column="stu_name" />
	<result property="sex" column="sex" />
	<result property="mtel" column="mtel" />
	<result property="qq" column="qq" />
	<result property="address" column="address" />
	<result property="birthday" column="birthday" />
	<result property="stu_status" column="stu_status" />
	<result property="class_id" column="class_id" />
	<result property="class_name" column="class_name" />
	<association property="clazz" javaType="com.cjc.model.Clazz">
		<id property="class_id" column="class_id" />
		<result property="classname" column="classname" />
	</association>
</resultMap>
<sql id="sql">
<where>
	<if test="stu_name!=null and stu_name!=''">
	and s.stu_name like "%"#{stu_name}"%"
	</if>
	<if test="sex!=null and sex!=''">
	and s.sex = #{sex} 
	</if>
	<if test="class_id!=null and class_id!=''">
	and s.class_id=#{class_id}
	
	</if>
</where>
</sql>
	<select id="fandAll" parameterType="com.cjc.dto.Dto" resultMap="stuMapper">
	select * from students s left join clazz c on s.class_id=c.class_id 
<include refid="sql"></include>
		limit #{page},#{limit}
	
	</select>
	<select id="count" resultType="Integer" parameterType="com.cjc.dto.Dto">
	select count(*) from students s left join clazz c on s.class_id=c.class_id 

<include refid="sql"></include>
	</select>
	<insert id="inser">
	insert into students (stu_name,class_id,sex,qq,mtel,birthday)
	VALUES(#{stu_name},#{class_id},#{sex},#{qq},#{mtel},#{birthday});
	</insert>
</mapper>