1.下载2.2版本后解压缩到指定目录
2.打开bin目录,点击runServer.bat,然后最小化窗口,注意不要关闭
3.点击runManagerSwing.bat,Type选择HSQL Database Engine Server 点击Ok按钮
4.此时已进入默认数据库,在根目录中进入data文件夹,此文件夹里保存有数据库信息
创建表customer:
create table customer(id integer not null primary key,firstname varchar(50),lastname varchar(50))
添加数据:insert into customer values(1,'lin','fenliang')
查询:select * from customer
创建数据库(命名为test):data文件夹下:java -cp ../lib/hsqldb.jar org.hsqldb.Server -database.0 test -dbname.0.test
此后就可以用JDBC连接此数据库啦,注意记得导包哦
另一种方式:
新建server.properties,内容为:
server.port=9001
server.dbname.0=test
server.database.0=file:test
server.silent=true
将此文件及bin目录下的runServer.bat拷贝到data目录下,运行runServer.bat。数据库名为test的数据库已建好了。
连接测试代码:HSQLConn.java
package org.com.spring.guide.dbutil;
import java.sql.Connection;
import java.sql.DriverManager;
public class HSQLConn {
static String USERNAME = "sa";
static String PASSWORD = "";
static String DRIVERNAME = "org.hsqldb.jdbcDriver";
static String URL = "jdbc:hsqldb:hsql://localhost/test";
public static Connection Conn() {
Connection connection = null;
try {
Class.forName(DRIVERNAME);
connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
connection.setAutoCommit(false);
if (!connection.isClosed()) {
System.out.println("Connect DataBase Successfully!");
}
} catch (Exception e) {
System.out.println("ERROR: failed to load HSQLDB JDBC driver.");
e.printStackTrace();
}
return connection;
}
public static void main(String[] args) {
// TODO Auto-generated method stub
Conn();
}
}