当前位置: 代码迷 >> 综合 >> Cause: java.sql.SQLException: Column count doesn‘t match value count at row 1
  详细解决方案

Cause: java.sql.SQLException: Column count doesn‘t match value count at row 1

热度:64   发布时间:2024-02-22 05:54:02.0
Cause: java.sql.SQLException: Column count doesn't match value count at row 1

mapper.xml中的sql语句中需要插入n个属性值,实际上只插入了小于n个

改为

    <insert id="insert" parameterType="com.example.demo.entity.OriPic">insert into ori_pic (pic_id,  vi_fi_id,pic_path,descri,`name`,typeId)values (#{picId,jdbcType=VARCHAR}, #{viFiId,jdbcType=VARCHAR}, #{picPath,jdbcType=VARCHAR},#{descri,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, #{typeId,jdbcType=INTEGER})</insert>

去除多余属性值