questionVersionDao.xml

最新推荐文章于 2023-09-16 07:30:00 发布

samwulei

最新推荐文章于 2023-09-16 07:30:00 发布

阅读量69

点赞数

分类专栏： Dao映射文件

本文链接：https://blog.csdn.net/samwulei/article/details/72354022

版权

Dao映射文件专栏收录该内容

6 篇文章 0 订阅

订阅专栏

<?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.casking.ccss.modules.qm.dao.QuestionVersionDao">

<sql id="questionVersionColumns">
C_Q_V_ID AS "id",
C_V_ID AS "vId",
C_Q_ID AS "qId",
C_Q_NAME AS "name",
C_Q_WEIGHT AS "weight",
C_Q_ORDER AS "order",
C_Q_REQUIRED AS "required",
C_Q_COUNT AS "count",
C_Q_PARENT_ORDER AS "parentOrder"
</sql>
<select id="findList" resultType="QuestionVersion">
SELECT
<include refid="questionVersionColumns"/>
FROM C_VERSIONS_WAREHOUSE A
WHERE 1 = 1
<if test="vId != null">
AND A.C_V_ID = #{vId}
</if>
</select>
<insert id="insertListByqId" parameterType="ArrayList" >
INSERT INTO C_VERSIONS_WAREHOUSE(
C_Q_V_ID,
C_V_ID,
C_Q_ID,
C_Q_NAME,
C_Q_WEIGHT,
C_Q_ORDER,
C_Q_REQUIRED,
C_Q_COUNT,
C_Q_PARENT_ORDER
)
<foreach collection="list" item="item" index="index" separator="union all">
select
sys_guid(),
#{item.vId},
#{item.qId},
#{item.name},
#{item.weight},
#{item.order},
#{item.required},
#{item.count},
#{item.parentOrder}
FROM dual
</foreach>
</insert>
<delete id="delete">
delete from C_QUESTION_DETAILS where C_Q_ID=#{qId}
</delete>

<delete id="updateOptionsByqId" parameterType="ArrayList">
<foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";">
UPDATE C_QUESTION_DETAILS
set C_Q_D_NAME=#{item.dName},C_Q_D_VALUE=#{item.dValue},C_Q_D_ORDER=#{item.order}
where
C_Q_D_ID= #{item.dId}
</foreach>
</delete>
</mapper>