| | |
| | | </insert> |
| | | |
| | | <insert id="inserts"> |
| | | insert into lf.sys_args |
| | | (name,cvalue,dvalue,descr,create_user,create_time) |
| | | values |
| | | <foreach collection="list" item="item" index="index" separator=","> |
| | | (#{item.name},#{item.cvalue},#{item.dvalue},#{item.descr},#{item.createUser},now()) |
| | | </foreach> |
| | | insert into lf.sys_args |
| | | (name,cvalue,dvalue,descr,create_user,create_time) |
| | | values |
| | | <foreach collection="list" item="item" index="index" separator=","> |
| | | (#{item.name},#{item.cvalue},#{item.dvalue},#{item.descr},#{item.createUser},now()) |
| | | </foreach> |
| | | </insert> |
| | | |
| | | <delete id="delete"> |
| | |
| | | |
| | | <update id="update"> |
| | | update lf.sys_args |
| | | set name=#{name},cvalue=#{cvalue},dvalue=#{dvalue},descr=#{descr},create_user=#{createUser},create_time=now() |
| | | set name=#{name},cvalue=#{cvalue},dvalue=#{dvalue},descr=#{descr},update_user=#{updateUser},update_time=now() |
| | | where id=#{id} |
| | | </update> |
| | | |
| | |
| | | <foreach collection="list" item="item" index="index" separator=";"> |
| | | update lf.sys_args |
| | | <set> |
| | | name=#{item.name},cvalue=#{item.cvalue},dvalue=#{item.dvalue},descr=#{item.descr},create_user=#{item.createUser},create_time=now() |
| | | name=#{item.name},cvalue=#{item.cvalue},dvalue=#{item.dvalue},descr=#{item.descr},update_user=#{item.updateUser},update_time=now() |
| | | </set> |
| | | where id = #{item.id} |
| | | </foreach> |