如:
CREATE SEQUENCE note_sequ ;
CREATE TABLE note
(
id int not null primary key , -- sequence
title varchar(20) not null ,
name varchar(20) not null ,
content varchar(50) not null
) ;
String sql = "INSERT INTO note VALUES(note_sequ.nextVal,?,?,?)" ;
CREATE SEQUENCE note_sequ ;
CREATE TABLE note
(
id int not null primary key , -- sequence
title varchar(20) not null ,
name varchar(20) not null ,
content varchar(50) not null
) ;
String sql = "INSERT INTO note VALUES(note_sequ.nextVal,?,?,?)" ;
(
id int(5) primary key auto_increment,
title varchar(20),
author varchar(20),
content varchar(50)
};