ibatis教学实例
xml的配置:
<mapper namespace="com.dao.StudyDao" >
<resultMap />
</resultMap>
<sql >
and course_name like CONCAT('%',#{results.courseName},'%')
</if>
</if>
</trim>
</sql>
<sql >
course_name ,createtime,level,id
</sql>
<select />
order by id desc
</select>
<select />
</select>
<select />
from s_course a
where id = #{sId,jdbcType=INTEGER}
</select>
<delete >
createtime = #{createTime,jdbcType=DATE},
</if>
</set>
where id = #{sId,jdbcType=INTEGER}
</update>
</mapper>