1、DERBY_HOME
D:\db-derby-10.10.2.0-bin
2、path和CLASS_PATH都添加如下:
;%DERBY_HOME%\bin;%DERBY_HOME%\lib\derbyrun.jar;
3、cmd输入sysinfo,看是否配置成功。
cmd输入ii,测试如下语句:
connect ‘jdbc:derby:dedb;user=root;password=root;create=true’; //连接数据库 账号密码为root/root
create table t_user(uuid varchar(32), name varchar(10), age int, address varchar(40)); //创建一个表
insert into t_user values(‘B82A6C5244244B9BB226EF31D5CBE508’, ‘Miachel’, 20, ‘street 1’); //插入几行数据
insert into t_user values(‘B82A6C5244244B9BB226EF31D5CBE509’, ‘Andrew’, 35, ‘street 1’);
insert into t_user values(‘B82A6C5244244B9BB226EF31D5CBE510’, ‘Orson’, 47, ‘street 1’);
insert into t_user values(‘B82A6C5244244B9BB226EF31D5CBE511’, ‘Rambo’, 19, ‘street 1’);
select * from t_user;