ibatis教学实例

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>