oracle数据库案例
1,插入
<insert id="doinsert" parameterType="com.jyzph.recruit.entity.JobfairFavorite">
insert into tbl_jobfair_favorite(f_id,job_fair_id,user_code)values((select get_uuid from dual),#{job_fair_id},#{userCode})
</insert>
ps:insert执行成功后返回int,
parameterType 参数是操作表的实体类
2,删除
<delete id="doDelete" parameterType="com.jyzph.recruit.entity.JobfairFavorite">
delete from tbl_jobfair_favorite where job_fair_id = #{job_fair_id} and user_code = #{userCode}
</delete>
ps:update执行成功后返回int,
parameterType 参数是操作表的实体类