jython

sample25 jython hsqldb スタンドアローンモード

import java
from java.sql import *
from java.io  import *

java.lang.Class.forName("org.hsqldb.jdbcDriver")
con = DriverManager.getConnection("jdbc:hsqldb:file:/c:/hsqldb/data/mydb", "sa", "")

print "Connected."

stmt = con.createStatement()
rset = stmt.executeQuery("create table books(book_title varchar primary key,author varchar)")
sql= "insert into books (book_title, author) values('甲賀忍法帖','山田風太郎')"
rset = stmt.executeQuery(sql);
rset = stmt.executeQuery("select book_title, author from books")
while rset.next():
    book_title = rset.getString(1)
    author = rset.getString(2)
    print "[" + book_title +":"+ author + "]"

rset = stmt.executeQuery("shutdown");

print "ok."
rset.close()
stmt.close()
con.close()

con = DriverManager.getConnection("jdbc:hsqldb:file:/c:/hsqldb/data/mydb", "sa", "")

で、hsqldbをスタンドアローンモードで使います。hsqldbのサーバを起動する必要がありません。

rset = stmt.executeQuery("shutdown");

で、最後にshutdownが必要です。