清单2：创建一张表在 JRuby 内检索　

create table employees (id integer,
name varchar(50),
title varchar(100),
office varchar(20));
insert into employees values (1, 'Fred Smith', 'CEO', '1');
insert into employees values (2, 'John Doe', 'Vice President', '2 West');
insert into employees values (3, 'Jane Jones', 'CFO', '2 East');
insert into employees values (4, 'Sam Smiles', 'Intern', '99');
insert into employees values (5, 'Julie Morgan', 'Sales Associate', '5 West');
insert into employees values (6, 'Wilma Fonda', 'Executive Assistant', '23');
insert into employees values (7, 'Danielle Jamison', 'Director of Marketing', '3 East');
insert into employees values (8, 'Michele Cannon',
'Director of Customer Support', '5 East');
insert into employees values (9, 'Lance Hanniford', 'CIO', '3 West');
insert into employees values (10, 'Eliot Rinaggio', 'Sales Associate', '5 West');

　　连接至 Derby

　　由于已创建数据库并用一些数据对其进行了填充，下一个任务是使用 JRuby 连接至该数据库。为此，需要新建一个名为 derby.rb 的文件。在文本编辑器中打开此文件，并输入清单 3 中所示的代码行。