Question

执行update操作时出错java.sql.SQLException: 无效的列索引

String sql = "update dwb_fr_frjbxx f SET f.tyxydm = ?, f.qyzch = ?, f.zzjgdm = ?, f.swdjh = ?, f.qymc = ?, f.frdb = ?, f.frzjlx = ?, f.frzjhm = ?, f.sssf = ？, f.sssj = ?, f.ssxq = ?, f.ssxzjd = ?, f.lrr = ?, f.ggsj = CURRENT_TIMESTAMP WHERE f.id = ? ";
Object[] param = new Object[]{
frinfo.getTyxydm(),frinfo.getQyzch(),frinfo.getZzjgdm(),frinfo.getSwdjh(),
frinfo.getQymc(),frinfo.getFrdb(),frinfo.getFrzjlx(),frinfo.getFrzjhm(),
frinfo.getSssf(),frinfo.getSssj(),frinfo.getSsxq(),frinfo.getSsxzjd(),
frinfo.getLrr(),frinfo.getId()
};
return jdbcTemplateOrcl.update(sql,param);

Answer 1

第二行f.sssf = ？你这个?号是中文的，请改成英文的?

追问

找了半小时都没发现哪的问题，笨死了。多谢高人指点！