初用 hsqldb

初用
hsqldb

今天初了下 hsqldb

下载 hsqldb
http://sourceforge.net/project/showfiles.php?group_id=23316

下载
hsqldb_1_8_0_7.zip

解压到 D:/hsqldb

在 D:/hsqldb 目录下创建 runxdb.bat
文件如下:

cd data
java -cp
../lib/hsqldb.jar org.hsqldb.Server -database.0 xdb
-dbname.0 xdb

然后双击 runxdb.bat 启动
hsqldb Server

到目录 demo 下运行 runManagerSwing.bat 来创建表
type : HSQL
Database Engine Server
url : jdbc:hsqldb:hsql://localhost/xdb
user :
SA

建表:

CREATE MEMORY
TABLE
TEXT(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START
WITH
1) NOT NULL PRIMARY KEY,NAME VARCHAR);

添加数据:

INSERT INTO TEXT VALUES(1,'chenlb')
INSERT INTO TEXT VALUES(2,'Tenny')

Java 文件

package hsqldb;

import java.sql.Connection;
import
java.sql.DriverManager;
import
java.sql.ResultSet;
import
java.sql.SQLException;
import
java.sql.Statement;

/**
*
*
@author chenlb 2007-4-28
*
*/
public
class HsqldbFirstSimple
{

    /**
      * @param args
     */
    public
static void
main(String[] args) {
        // TODO
Auto-generated method stub

        try
{
             Class.forName("org.hsqldb.jdbcDriver" );

} catch (Exception e) {

System.out.println("ERROR: failed
to load HSQLDB JDBC driver.");

e.printStackTrace();
            return;
         }

        try
{
             Connection c =
DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/xdb", "sa", "");
             Statement stmt = c.createStatement();
             ResultSet rs = stmt.executeQuery("select * from
text");
            while(rs.next()) {

System.out.println(rs.getString(1)+"\t"+rs.getString(2));
             }
         } catch (SQLException e) {
            // TODO Auto-generated catch block
             e.printStackTrace();
         }

}

}

chenlb.blogjava.net