Question

用PrepareStatement对象在sql语句 的insert中怎样实现id的自增长，我的代码如下可是有错误 请指教 谢谢

create or replace trigger S_INTERVIEW_ID
before insert on INTERVIEW_INFO
referencing old as old new as new for each row
begin
new.INTERVIEW_ID=S_INTERVIEW_ID.nextval;
end;

sql
.append("insert into INTERVIEW_INFO ( INTERVIEW_ID,INTERVIEWEE_NAME, INTERVIEWEE_SEX,");
sql
.append("INTERVIEWEE_POSITION,GRADUATION_DATE, EDU_BACKGROUND, FOREIGN_LANG, FOREIGN_MEMO,");
sql
.append(" BUSTRIP_FLAG, BUSTRIP_TIME,DEPT_DEVELOP, OUTSOURCING_FLAG, LEAVE_REASON, BIRTH_YEAR, ");
sql
.append("NATIVE_PLACE, BGFRIEND_FLAG,BGFRIEND_PLACE, DESAIRED_SALARY, BEFORE_SALARY, WORK_TIME, ");
sql.append("COMPACT_STATUS, TECHNICAL_REVIEW,OVERALL_MERIT, FINAL_RESULT, JAPAN_LEVEL)");
sql.append("values (S_INTERVIEW_ID.Nextval,？,？, ？, ？, ？, ？, ？, ？, ？, ？, ？, ？, ？,");
sql.append("？, ？, ？, ？, ？, ？, ？, ？, ？, ？, ？)");

提示错误为“java.sql.SQLException: 无效的列索引”

Answer 1

建表时就要把表中的ID字段建为自增数列,例如:
id int identity not null
这样在插入时就会自动增长,但插入语句不应包括该字段,只插入后面的内容就可以了
例如:该表有三个字段id,name,age,其中id为自增字段
insert t_1 name,age values("张三",12)
insert t_1 name,age values("李四",20)
结果为
1 张三 12
2 李四 20
希望对你有帮助