Derby数据库应用相关文档:
http://apps.hi.baidu.com/share/detail/6550525
http://hi.baidu.com/commath/blog/item/2dc5b1f8f473b0d4b58f3166.html
之前在mysql中编辑,现在要移植到derby中,有些数据类型不兼容:
时间数据类型:
mysql版本:
create table JYS
(
ID int not null,
qsrq datetime,
zzrq datetime,
primary key (ID)
);
derby版本:
create table JYS
(
ID int not null,
qsrq TIMESTAMP,
zzrq TIMESTAMP,
primary key (ID)
);
datetime ----------> TIMESTAMP
自增主键:
mysql版本:
create table DW
(
id int not null auto_increment,
mc varchar(50),
primary key (id)
);
derby版本:
create table DW
(
id int generated by default as identity,
mc varchar(50),
primary key (id)
);
bool类型:
mysql版本:
create table YSPF
(
ID int not null,
tgsj bool,
primary key (ID)
);
derby版本:
create table YSPF
(
ID int not null,
tgsj varchar(1),
primary key (ID)
);
bool -------------------------> varchar(1)