Ibats分页.docVIP

SqlMap.xml中 ?xml version=1.0 encoding=UTF-8 ? !DOCTYPE sqlMap PUBLIC -////DTD SQL Map 2.0//EN /dtd/sql-map-2.dtd sqlMap namespace=view_teacher resultMap id=abatorgenerated_ViewTeacherResult class=edu.xw.ji.models.ViewTeacher !-- WARNING - This element is automatically generated by Abator for iBATIS, do not modify. This element was generated on Tue Dec 02 09:11:14 CST 2008. -- result column=teacher_id property=teacherId jdbcType=CHAR / result column=sex_type_name property=sexTypeName jdbcType=VARCHAR / result column=name property=name jdbcType=VARCHAR / /resultMap sql id=abatorgenerated_Example_Where_Clause !-- WARNING - This element is automatically generated by Abator for iBATIS, do not modify. This element was generated on Tue Dec 02 09:11:14 CST 2008. -- iterate property=oredCriteria conjunction=or prepend=where removeFirstPrepend=iterate isEqual property=oredCriteria[].valid compareValue=true ( iterate prepend=and property=oredCriteria[].criteriaWithoutValue conjunction=and $oredCriteria[].criteriaWithoutValue[]$ /iterate iterate prepend=and property=oredCriteria[].criteriaWithSingleValue conjunction=and $oredCriteria[].criteriaWithSingleValue[].condition$ #oredCriteria[].criteriaWithSingleValue[].value# /iterate iterate prepend=and property=oredCriteria[].criteriaWithListValue conjunction=and $oredCriteria[].criteriaWithListValue[].condition$ iterate property=oredCriteria[].criteriaWithListValue[].values open=( close=) conjunction=, #oredCriteria[].criteriaWithListValue[].values[]# /iterate /iterate iterate prepend=and property=oredCriteria[].criteriaWithBetweenValue conjunction=and $oredCriteria[].criteriaWithBetweenValue[].condition$ #oredCriteria[].criteriaWithBetweenValue[].values[0]# and #oredCriteria[].criteriaWithBetweenValue[].values[1]