<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.miaxis.newgzpt.mapper.GzptVideoVipMapper">


    <insert id="saveGzptVideoVip" parameterType="com.miaxis.newgzpt.domain.GzptVideoVip">
        insert into GZPT_VIDEO_VIP VALUES (seq_gzpt_video_vip.nextval,
                                                 #{userId},
                                                 #{userName,jdbcType=VARCHAR},
                                                 #{subject2,jdbcType=DATE},
                                                 #{subject3,jdbcType=DATE})
    </insert>

    <update id="updateGzptVideoVipByUserId" parameterType="com.miaxis.newgzpt.domain.GzptVideoVip">
        update GZPT_VIDEO_VIP
        set SUBJECT2 = #{subject2,jdbcType=DATE}, SUBJECT3 = #{subject3,jdbcType=DATE}
        where user_id = #{userId}
    </update>


    <select id="getGzptVideoVipByUserId" resultType="com.miaxis.newgzpt.domain.GzptVideoVip" parameterType="com.miaxis.newgzpt.dto.GzptVideoVipDTO">
        select * from GZPT_VIDEO_VIP
        <where>
            and user_id = #{userId}
        </where>
    </select>





</mapper>
