bug记录 mybaitis

bug记录：

java.sql.SQLException: sql injection violation, syntax error: syntax error, expect EQ, actual IDENTIFIER pos 258, line 8, column 15, token IDENTIFIER id : update rsv_production_data_copy1
set qdaily = ?,
well_num = ?,
daily_gas_production = ?,
oil_pressure = ?,
well_head_temperature = ?,
daily_water_production = ?,
where
id = ?
; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, expect EQ, actual IDENTIFIER pos 258, line 8, column 15, token IDENTIFIER id : update rsv_production_data_copy1
set qdaily = ?,
well_num = ?,
daily_gas_production = ?,
oil_pressure = ?,
well_head_temperature = ?,
daily_water_production = ?,
where
id = ?; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, expect EQ, actual IDENTIFIER pos 258, line 8, column 15, token IDENTIFIER id : update rsv_production_data_copy1
set qdaily = ?,
well_num = ?,
daily_gas_production = ?,
oil_pressure = ?,
well_head_temperature = ?,
daily_water_production = ?,
where
id = ?

解决办法： 更新语句得最后一个字段不小心加上逗号了，去掉这个逗号即可。犯了个低级得错误，罪不可赦