Create

connect 'jdbc:derby://localhost:1527/city_aaa;create=true';
drop table cities;
create table cities (id varchar(10), name varchar(20), population int, date_mod date);
commit;
quit;


Insert

connect 'jdbc:derby://localhost:1527/city_aaa';

insert into cities (id,name,population,date_mod) values
 ('t3551','山口',41856,'2001-7-2');
insert into cities (id,name,population,date_mod) values
 ('t3552','下関',37239,CAST ('2001-3-4' as date));
insert into cities (id,name,population,date_mod) values
 ('t3553','萩',26547,'2001-3-6');
insert into cities (id,name,population,date_mod) values
 ('t3554','徳山',51238,CAST ('2001-1-21' as date));
insert into cities (id,name,population,date_mod) values
 ('t3555','岩国',72634,CAST ('2001-4-11' as date));
insert into cities (id,name,population,date_mod) values
 ('t3556','光',57863,CAST ('2001-3-17' as date));
insert into cities (id,name,population,date_mod) values
 ('t3557','宇部',42951,CAST ('2001-5-12' as date));
insert into cities (id,name,population,date_mod) values
 ('t3558','長門',32784,CAST ('2001-7-28' as date));
insert into cities (id,name,population,date_mod) values
 ('t3559','防府',61952,CAST ('2001-2-14' as date));
commit;
quit;

Read

connect 'jdbc:derby://localhost:1527/city_aaa';
select id,name,population,date_mod from cities;
quit;