我有一张有顺序的简易桌. 当我在INSERTINT.SET方法中使用Sequence.nextval()时,一切正常. 当我在intertInto.Values方法中使用equence.nextval()时,只使用Sequence,再次指定end就可以了. 当我在INSERTINT.VALUES方法中使用Sequence.nextval()时,如果使用的不是Sequence,则会出现错误.
这样就可以了
int w = dslContext
.insertInto(APPOINTMENTTYPE)
.set(APPOINTMENTTYPE.MC, 501559436L)
.set(APPOINTMENTTYPE.ID, HIBERNATE_SEQUENCE.nextval())
.set(APPOINTMENTTYPE.NAME, "test name")
.set(APPOINTMENTTYPE.DESCRIPTION, "test description")
.set(APPOINTMENTTYPE.BLUE, 255)
.set(APPOINTMENTTYPE.GREEN, 255)
.set(APPOINTMENTTYPE.RED, 255)
.set(APPOINTMENTTYPE.REMINDERINTERVAL, 1)
.execute();
这也可以.
int x = dslContext.insertInto(APPOINTMENTTYPE,
APPOINTMENTTYPE.ID).values(APPOINTMENTTYPE_SEQ.nextval()).execute();
这会产生错误Cannot resolve method 'values(Field<Long>, int)'
int y = dslContext.insertInto(APPOINTMENTTYPE, APPOINTMENTTYPE.ID, APPOINTMENTTYPE.BLUE).values(APPOINTMENTTYPE_SEQ.nextval(), 255).execute();