?

这里不是耶路撒冷  所以失忆

{ "msg": "\r\n### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near \")\"\n 位置:233\r\n### The error may exist in file [D:\\lz_framework\\lz-ehs-admin\\ruoyi-ehs\\target\\classes\\mapper\\business\\PCerDataMapper.xml]\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: insert into ehsdata.p_cer_data (site,cer_one,cer_two,cer_type,cer_name,end_time,status,create_time) values ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ) , ( ?, ?, ?, ?, ?, ?, ?, ?, )\r\n### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near \")\"\n 位置:233\n; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near \")\"\n 位置:233", "code": 500 }
08-03
这个错误信息: ``` org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" ``` 表明你在执行 SQL 插入语句时,SQL 语法中存在错误,**括号 `)` 附近有语法错误**。 --- ### ❗问题定位: 从你提供的 SQL 片段来看: ```sql insert into ehsdata.p_cer_data (site,cer_one,cer_two,cer_type,cer_name,end_time,status,create_time) values (?, ?, ?, ?, ?, ?, ?, ?, ), -- 注意这里最后多了一个逗号 ... ``` 你插入语句中每个 `values` 后面的括号中都多了一个 **多余的逗号 `,`**,例如: ```sql (?, ?, ?, ?, ?, ?, ?, ?, ), -- 多余的逗号导致 PostgreSQL 报错 ``` PostgreSQL 无法识别这个语法,因此报错: > `syntax error at or near ")"` --- ### ✅ 解决方案: #### 修改 SQL,删除每个 `values` 中多余的逗号: **错误写法:** ```sql values (?, ?, ?, ?, ?, ?, ?, ?, ), -- 错误:多了一个逗号 ``` **正确写法:** ```sql values (?, ?, ?, ?, ?, ?, ?, ?), -- 正确:没有多余的逗号 ``` 确保每个 `values` 子句中的占位符数量与列数量一致,并且**不要在最后加逗号**。 --- ### ✅ 完整修正示例(批量插入): ```sql insert into ehsdata.p_cer_data (site, cer_one, cer_two, cer_type, cer_name, end_time, status, create_time) values (?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?) -- 根据实际插入条数继续添加 ; ``` --- ### 🔍 附加建议: 1. **SQL 格式化**: - 使用 SQL 格式化工具或 IDE 插件检查语法。 2. **MyBatis 动态 SQL 批量插入**: 如果你是通过 Java 代码动态生成多条插入语句,建议使用 MyBatis 的 `<foreach>` 实现批量插入,例如: ```xml <insert id="batchInsert"> INSERT INTO ehsdata.p_cer_data (site, cer_one, cer_two, cer_type, cer_name, end_time, status, create_time) VALUES <foreach collection="list" item="item" separator=","> (#{item.site}, #{item.cerOne}, #{item.cerTwo}, #{item.cerType}, #{item.cerName}, #{item.endTime}, #{item.status}, #{item.createTime}) </foreach> </insert> ``` 这样可以避免手动拼接 SQL 出现语法错误。 --- ### ✅ 总结: - 报错原因:SQL 插入语句中每个 `values` 子句最后多了一个逗号。 - 解决方法:删除每个 `values (?, ?, ...),` 中最后的多余逗号。 - 建议:使用 MyBatis 的 `<foreach>` 实现安全的批量插入。 ---
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值