自己公司 ibatis配置文件 中 增删改查的写法

???
自己公司 ibatis配置文件 中 增删改查的写法
?????

??? <!-- 查询的写法?? -->
??? <select id="getCoursePassWordSure" parameterparameterparameterproperty="userID"> userID </isNotNull>
??????????? <isNotNull prepend="," property="majorID"> majorID </isNotNull>
??????????? <isNotNull prepend="," property="listID"> listID </isNotNull>
??????? </dynamic>
??????? )
??????? VALUES (
??????? <dynamic prepend="">
??????????? <isNotNull prepend="" property="userID"> #userID# </isNotNull>
??????????? <isNotNull prepend="," property="majorID"> #majorID# </isNotNull>
??????????? <isNotNull prepend="," property="listID"> #listID# </isNotNull>
??????? </dynamic>
??????? )
???? </insert>

?

??? <!--? 在jsp 中 的方式删除 -->
??? <delete id="removeFaqSubscribe" parameterparameterproperty="userID"> userID=#userID# </isNotNull>
??????????? <isNotNull prepend="AND" property="majorID"> majorID=#majorID# </isNotNull>
??????? </dynamic>
??? </delete>