dbeaver工具连接DB2数据库
drivername:com.ibm.db2.jcc.DB2Driver
#在dbeaver中对DB2数据库创建数据库(Schema):
#在dbeaver中对DB2数据库新增表
create table HMF.USERS(
id int NOT NULL primary key,
NAME VARCHAR(500),
EMAIL VARCHAR(500),
AGE VARCHAR(200),
SEX VARCHAR(200),
ID_CARD VARCHAR(500),
MOBILE_PHONE VARCHAR(500),
VISA_CARD VARCHAR(500),
OFFICER_CARD VARCHAR(500),
ADDRESS VARCHAR(500)
);
#在dbeaver中对DB2数据库表插入数据
INSERT INTO HMF.USERS VALUES ('1', '郑网', 'xingwei01@qq.com', '24', 'M', '460025198109201501', '18692031970', 'SYP618183451', '军字第00111209号', '北京市朝阳区立水桥南');
INSERT INTO HMF.USERS VALUES ('2', '小黑', 'xingwei02@qq.com', '24', 'M', '460025198109201502', '18692031971', 'SYP618183452', '军字第00111210号', '北京市朝阳区立水桥南');
INSERT INTO HMF.USERS VALUES ('3', '小白', 'xingwei03@qq.com', '24', 'M', '460025198109201503', '18692031972', 'SYP618183453', '军字第00111211号', '北京市朝阳区立水桥南');