Mybits---在xml中的sql

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 参数是操作表的实体类