SQL语法错误：PnMapperRuKu.xml文件中insert语句的逗号问题怎么解决？

sqlexception：语法错误

错误原因：

代码块中出现的类似“name后的 ,”实际应为“name后应缺失 ,”。

具体问题：

零一万物开放平台

零一万物大模型开放平台

下载

pnmapperruku.xml文件中的insertpnassertrukudetails方法中，insert语句中storageroom列后跟着一个多余的逗号。

正确语句：

zuojiankuohaophpcninsert id="insertPnAssertRukuDetails" parameterType="com.ruoyi.system.domain.PnModelInOutInventory"youjiankuohaophpcn
        insert into pnAssertRukuDetails (
     zuojiankuohaophpcnif test="parentPnAssertRukuId != null and parentPnAssertRukuId != '' "youjiankuohaophpcnparent_pnAssertRuku_id,zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="materialInformation != null and materialInformation != '' "youjiankuohaophpcnmaterialInformation,zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="numbersRuKu != null and numbersRuKu != '' "youjiankuohaophpcnnumbersRuKu,zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="qualified != null and qualified != '' "youjiankuohaophpcnqualified,zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="unit != null and unit != '' "youjiankuohaophpcnunit,zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="storageRoom != null and storageRoom != ''"youjiankuohaophpcnstorageRoomzuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="sn != null and sn != ''"youjiankuohaophpcnsn,zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="remark != null and remark != ''"youjiankuohaophpcnremark,zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="batchNumber != null and batchNumber != ''"youjiankuohaophpcnbatchNumber,zuojiankuohaophpcn/ifyoujiankuohaophpcn
    )values(
     zuojiankuohaophpcnif test="parentPnAssertRukuId != null and parentPnAssertRukuId != '' "youjiankuohaophpcn#{parentPnAssertRukuId},zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="materialInformation != null and materialInformation != '' "youjiankuohaophpcn#{materialInformation},zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="numbersRuKu != null and numbersRuKu != '' "youjiankuohaophpcn#{numbersRuKu},zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="qualified != null and qualified != '' "youjiankuohaophpcn#{qualified},zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="unit != null and unit != '' "youjiankuohaophpcn#{unit},zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="storageRoom != null and storageRoom != ''"youjiankuohaophpcn#{storageRoom},zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="sn != null and sn != ''"youjiankuohaophpcn#{sn},zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="remark != null and remark != ''"youjiankuohaophpcn#{remark},zuojiankuohaophpcn/ifyoujiankuohaophpcn
     zuojiankuohaophpcnif test="batchNumber != null and batchNumber != ''"youjiankuohaophpcn#{batchNumber},zuojiankuohaophpcn/ifyoujiankuohaophpcn
    )
zuojiankuohaophpcn/insertyoujiankuohaophpcn