hsqldb简单使用

最新推荐文章于 2024-11-23 17:57:08 发布

原创最新推荐文章于 2024-11-23 17:57:08 发布 · 1.1k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#hsqldb #sql #url #数据库 #database #include

笔记专栏收录该内容

4 篇文章

订阅专栏

本来想测个东西，发现数据库是在服务器上，本机又没有装任何数据库，所以拿个hsqldb来用用。
将hsqldb.jar拷贝到lib目录下，db文件夹中新建文件server.bat,内容如下：

java -cp ../lib/hsqldb.jar org.hsqldb.Server -database.0 db/users -dbname.0 users

users 为数据库的名字。
其余的就是建一些sql文件了，比如create_accounts.sql

CREATE TABLE accounts(

id INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1) PRIMARY KEY,

userName varchar(16),

password varchar(16),

lastIP varchar(19),

lastSignInDateTime datetime,

rightClass INTEGER

);

CREATE INDEX accounts_id ON accounts(id);

CREATE INDEX accounts_userName ON accounts(userName);

accounts_data.sql

INSERT INTO accounts (username, password, lastIP,lastSignInDateTime,rightClass)
values('test1', 'test1','211.68.40.62',now(),1);
INSERT INTO accounts (username, password, lastIP,lastSignInDateTime,rightClass)
values('test2', 'test2','211.68.40.63',now(),2);

使用ant
新建文件build.properties：
db.driver=org.hsqldb.jdbcDriver
db.url=jdbc:hsqldb:hsql://localhost/users
db.user=sa
db.pw=
新建文件build.xml

<?xml version="1.0"?>
<project name="UserManager" basedir=".">
    <property file="build.properties" />
    <property name="src.dir" value="src" />
    <property name="lib.dir" value="lib" />
    <path id="master-classpath">
    <fileset dir="${lib.dir}">
    <include name="*.jar"/>
    </fileset>
    </path>

    <target name="createTables">
        <echo message="CREATE TABLES USING: ${db.driver} ${db.url}" />
        <sql driver="${db.driver}" url="${db.url}" userid="${db.user}" password="${db.pw}" onerror="continue" src="db/create_accounts.sql">
            <classpath refid="master-classpath" />
        </sql>
    </target>
    <target name="dropTables">
        <echo message="DROP TABLES USING: ${db.driver} ${db.url}" />
        <sql driver="${db.driver}" url="${db.url}" userid="${db.user}" password="${db.pw}" onerror="continue">
            <classpath refid="master-classpath" />
            DROP TABLE accounts;
        </sql>
    </target>
    <target name="loadData">
        <echo message="LOAD DATA USING: ${db.driver} ${db.url}" />
        <sql driver="${db.driver}" url="${db.url}" userid="${db.user}" password="${db.pw}" onerror="continue" src="db/accounts_data.sql">
            <classpath refid="master-classpath" />
        </sql>
    </target>
    <target name="printData">
        <echo message="PRINT DATA USING: ${db.driver} ${db.url}" />
        <sql driver="${db.driver}" url="${db.url}" userid="${db.user}" password="${db.pw}" onerror="continue" print="true">
            <classpath refid="master-classpath" />
            SELECT * FROM accounts;
        </sql>
    </target>
    <target name="clearData">
        <echo message="CLEAR DATA USING: ${db.driver} ${db.url}" />
        <sql driver="${db.driver}" url="${db.url}" userid="${db.user}" password="${db.pw}" onerror="continue">
            <classpath refid="master-classpath" />
            DELETE FROM accounts;
        </sql>
    </target>
    <target name="shutdownDb">
        <echo message="SHUT DOWN DATABASE USING: ${db.driver} ${db.url}" />
        <sql driver="${db.driver}" url="${db.url}" userid="${db.user}" password="${db.pw}" onerror="continue">
            <classpath refid="master-classpath" />
            SHUTDOWN;
        </sql>
    </target>
</project>