JavaWeb开发过程中异常记录

一、SQL异常

1、java.sql.SQLException: Wrong number of parameters: expected 9, was given 11 Query:

insert into tb_stu_travel(username,startDate,endDate,province,city,area,goVehicle,goNumber,backVehicle,backNumber,content) values(?,?,?,?,?,?,?,?,?)

Parameters: [2007013628, Thu May 05 00:00:00 CST 2022, Sat May 07 00:00:00 CST 2022, 云南, 红河哈尼族彝族自治州, 金平苗族瑶族傣族自治县, 飞机, CA1234, 高铁, G5678, 旅游]

SQL语句,插入字段数9,提供参数11个。

 

posted @ 2022-05-15 19:33  熊猫Panda先生  阅读(191)  评论(0编辑  收藏  举报