hsqldb

hsql是内置的数据库，java编写的吧，很小很灵活，简单的使用如下

java -classpath lib/hsqldb.jar org.hsqldb.Server

java -cp ../lib/hsqldb.jar org.hsqldb.util.DatabaseManager -url jdbc:hsqldb:hsql://localhost/mydb  

 

create table address(id int,FirstName varchar(10), LastName varchar(10), Street varchar(10), City varchar(10));

insert into address values(1,'yang','wenbo','qianjin','changchun');

insert into address values(2,'zhang','wenbo','qianjin','changchun');

insert into address values(3,'zhang','ji','qianjin','jilin');

select *from address