但是在我这样使用的时候,在oracle中编译出错:
String sqlStr = "insert into student (id,name) vaules(?,?)";
try{
Connection conn = new OracleDriver().getdefaultConnection();
PreparedStatement st = conn.preparedStatement(sql);
st.setInt(1,STU_SEQUENCE.NEXTVAL);
st.setString(2,p_name);//p_name为外部传入
st.close();
conn.close();
}
catch(SQLException e)
{
}
String sqlStr = "insert into student (id,name) vaules(?,?)";
try{
Connection conn = new OracleDriver().getdefaultConnection();
PreparedStatement st = conn.preparedStatement(sql);
st.setInt(1,STU_SEQUENCE.NEXTVAL);
st.setString(2,p_name);//p_name为外部传入
st.close();
conn.close();
}
catch(SQLException e)
{
}
before insert on STUDENT
for each row
begin
select STU_SEQUENCE.NEXTVAL into :new.ID from dual;
end;
/
INSERT INTO STUDENT (NAME) VALUES (P_NAME)
因为java不能识别STU_SEQUENCE.NEXTVAL