sqlexception:语法错误
错误原因:
代码块中出现的类似“name后的 ,”实际应为“name后应缺失 ,”。
具体问题:
pnmapperruku.xml文件中的insertpnassertrukudetails方法中,insert语句中storageroom列后跟着一个多余的逗号。
正确语句:
<insert id="insertPnAssertRukuDetails" parameterType="com.ruoyi.system.domain.PnModelInOutInventory"> insert into pnAssertRukuDetails ( <if test="parentPnAssertRukuId != null and parentPnAssertRukuId != '' ">parent_pnAssertRuku_id,</if> <if test="materialInformation != null and materialInformation != '' ">materialInformation,</if> <if test="numbersRuKu != null and numbersRuKu != '' ">numbersRuKu,</if> <if test="qualified != null and qualified != '' ">qualified,</if> <if test="unit != null and unit != '' ">unit,</if> <if test="storageRoom != null and storageRoom != ''">storageRoom</if> <if test="sn != null and sn != ''">sn,</if> <if test="remark != null and remark != ''">remark,</if> <if test="batchNumber != null and batchNumber != ''">batchNumber,</if> )values( <if test="parentPnAssertRukuId != null and parentPnAssertRukuId != '' ">#{parentPnAssertRukuId},</if> <if test="materialInformation != null and materialInformation != '' ">#{materialInformation},</if> <if test="numbersRuKu != null and numbersRuKu != '' ">#{numbersRuKu},</if> <if test="qualified != null and qualified != '' ">#{qualified},</if> <if test="unit != null and unit != '' ">#{unit},</if> <if test="storageRoom != null and storageRoom != ''">#{storageRoom},</if> <if test="sn != null and sn != ''">#{sn},</if> <if test="remark != null and remark != ''">#{remark},</if> <if test="batchNumber != null and batchNumber != ''">#{batchNumber},</if> ) </insert>