1、MyBatis参数传递 - 需要传递多个参数时，可以用map结构进行传递 - service调用：
Map<String, Object> conditons = new HashMap<String, Object>(); conditons.put("resId", liveId.toString()); conditons.put("resType",10); - mapper定义： deleteByResourceAndType(Map<String, Object> conditions); - xml： <delete id="deleteByResourceAndType"> DELETE FROM PEIXUN_SPEAKER_RELATED <where> RES_ID=#{resId} AND RES_TYPE=#{resType} </where> </delete>2、MyBatis的XML配置文件相关
xml配置文件中的继承extends参数 继承resultMap：添加参数： <resultMap type="CoursePO" id="courseWithRelationLive" extends="courseResult"> <result property="liveId" column="liveId" /> <result property="liveName" column="liveName" /> </resultMap>继承resultMap：添加select，以list形式添加：
<resultMap type="CoursePO" id="courseWithElements" extends="courseResult"> <collection property="elementList" column="ID" javaType="ArrayList" ofType="ElementPO" select="getElementsByCourseId" /> </resultMap> <select id="getElementsByCourseId" parameterType="long" resultMap="elementwithOrderMap"> SELECT CE.COURSE_ID, CE.ELEMENT_ORDER , E.ID, E.TYPE, E.NAME, E.DESCRIPTION, E.CREATOR_ID, E.CREATOR_NAME, E.COVER_PATH, E.ATTACH_PATH, E.CREATE_TIME, E.UPDATE_TIME, E.TRANS_STATUS, E.VOICE_PATH, E.KEY_WORDS from PEIXUN_COURSE_ELEMENT CE INNER JOIN PEIXUN_ELEMENT E on CE.ElEMENT_ID=E.ID where CE.COURSE_ID=#{id} order by CE.ELEMENT_ORDER ASC </select>