Java DB SQL

• 显示所有的用户表

select tablename from sys.systables where tabletype='T'

• 创建表

Create Table MAPS(

ID integer not null generated always as identity(startwith 1,increment by 1),

map_name varchar(40),

area_int int,

area decimal(8,4) not null,

picture blob(102400),

unique(map_id,map_name)

)

下面是一个从删除表,创建表,从文本文件导入数据,更新数据的例子.

 

drop table client;
CREATE TABLE client (
id integer not null generated always as identity(startwith 1,increment by 1),
barcode varchar(20) default NULL,
pinyin varchar(10) default NULL,
type varchar(50) default NULL,
name varchar(30) default NULL,
sex varchar(10) default NULL,
title varchar(200) default NULL,
department varchar(200) default NULL,
company varchar(255) default NULL,
industry varchar(50) default NULL,
address varchar(255) default NULL,
postcode varchar(8) default NULL,
areacode varchar(10) default NULL,
tel varchar(20) default NULL,
fax varchar(20) default NULL,
mobile varchar(15) default NULL,
email varchar(200) default NULL,
state smallint NOT NULL default 1,
regtime timestamp,
oldbarcode varchar(20) default NULL,
islogin smallint default 0
);
call SYSCS_UTIL.SYSCS_IMPORT_DATA(null,'CLIENT','BARCODE,PINYIN,TYPE,NAME,SEX,TITLE,
DEPARTMENT,COMPANY,INDUSTRY,ADDRESS,POSTCODE,AREACODE,TEL,
FAX,MOBILE,EMAIL',null,'c:/data.txt',null,null,'GBK',0);
update client set state=1,islogin=0,oldbarcode=barcode;