MyBatis Cause: java.sql.SQLException: Operand should contain 1 column(s) 异常处理

最新推荐文章于 2024-02-08 22:06:45 发布

FserSuN

最新推荐文章于 2024-02-08 22:06:45 发布

阅读量2.1w

点赞数 10

分类专栏： MyBatis 文章标签： mybatis 异常 select

本文链接：https://blog.csdn.net/Revivedsun/article/details/66478386

版权

MyBatis 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

用mybatis foreach出现异常Operand should contain 1 column(s)

    <select id="selectByCreditIdList" resultMap="BaseResultMap">
        SELECT * FROM table
        WHERE id IN (
                    <foreach collection="creditIdList" item="cid" index="index" open="(" close=")" separator=",">
                        #{cid}
                    </foreach>
                    )
    </select>

暴出的异常如下。

Error querying database.  Cause: java.sql.SQLException: Operand should contain 1 column(s)
### The error may exist in com/fengdai/finance/dao/CreditBillCycleDao.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT * FROM credit_bill_cycle   WHERE   (         id IN (       (         ?       ,        ?       )     )   )
### Cause: java.sql.SQLException: Operand should contain 1 column(s)

发现生成IN 后跟随的列表是一个( ? , ? ) ，因此产生Operand should contain 1 column(s)异常。删除MyBatis sql映射文件中的外围括号，问题解决。

(  <-删除
                    <foreach collection="creditIdList" item="cid" index="index" open="(" close=")" separator=",">
                        #{cid}
                    </foreach>
) <- 删除