ibatis select in property with array

    <select id="getQuestionsByIds" resultMap="get-questions-inids">
        select q.que_id,
       q.lib_id,
       q.que_code,
       q.type_code,
       q.base_code,
       q.diff_code,
       q.knowledge_id,
       q.ability_code,
       q.create_user,
       q.create_time,
       q.is_big_text,
       q.secret,
       q.parent_id,
       q.que_version,
       q.casual,
       q.choise,
       q.answer,
       q.clob_casual,
       q.clob_choise,
       q.clob_answer,
       q.score,
       q.answer_time,
       q.source_code,
       q.source_code sourceName,
       q.use_count,
       q.is_approved,
       q.is_avail,
       q.start_time,
       q.end_time,
       q.byinfor,
       q.update_time,
       q.update_user,
       ql.lib_name lib_name,
       qt.type_name type_name,
       pack_exam.get_qk_name(q.que_id) qk_name,
       qd.diff_name diff_name,
       qa.ability_name ability_name,
       cb.name exam_wh_id_str
  from questions q left join question_library ql on ql.lib_id = q.lib_id left join question_type qt on qt.type_code = q.type_code left join question_difficulty qd
  on qd.diff_code = q.diff_code left join question_ability qa on qa.ability_code = q.ability_code left join course_bank cb on cb.id = q.exam_wh_id
 where que_id in
    
<iterate conjunction="," open="(" close=")">
    #[]#
    </iterate>

    </select>
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值