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