| | |
| | | update_time, |
| | | isupload, |
| | | upload_time |
| | | from svy_lib_ScriptOption |
| | | from svy_lib_scriptoption |
| | | </sql> |
| | | |
| | | <select id="selectSvyLibScriptOptionList" parameterType="com.smartor.domain.SvyLibScriptOption" |
| | |
| | | |
| | | <insert id="insertSvyLibScriptOption" parameterType="com.smartor.domain.SvyLibScriptOption" useGeneratedKeys="true" |
| | | keyProperty="id"> |
| | | insert into svy_lib_ScriptOption |
| | | insert into svy_lib_scriptoption |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="topicid != null">topicid,</if> |
| | | <if test="svyid != null">svyid,</if> |
| | |
| | | </insert> |
| | | |
| | | <update id="updateSvyLibScriptOption" parameterType="com.smartor.domain.SvyLibScriptOption"> |
| | | update svy_lib_ScriptOption |
| | | update svy_lib_scriptoption |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="topicid != null">topicid = #{topicid},</if> |
| | | <if test="svyid != null">svyid = #{svyid},</if> |
| | |
| | | </update> |
| | | |
| | | <update id="deleteSvyLibScriptOptionByOptionid" parameterType="Long"> |
| | | update svy_lib_ScriptOption |
| | | update svy_lib_scriptoption |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | del_flag = 1 |
| | | </trim> |
| | |
| | | </update> |
| | | |
| | | <delete id="deleteSvyLibScriptOptionByOptionids" parameterType="String"> |
| | | delete from svy_lib_ScriptOption where id in |
| | | delete from svy_lib_scriptoption where id in |
| | | <foreach item="id" collection="array" open="(" separator="," close=")"> |
| | | #{id} |
| | | </foreach> |