jaydebeapi_hsqldb_jdbc_connection_and_sql_query.py

1import jaydebeapi
2
3conn = jaydebeapi.connect("org.hsqldb.jdbcDriver",
4                          "jdbc:hsqldb:mem:.",
5                          ["SA", ""],
6                          "/path/to/hsqldb.jar",)
7
8curs = conn.cursor()
9curs.execute('create table CUSTOMER (ID INTEGER, NAME VARCHAR(255))')
10curs.execute("insert into CUSTOMER values (1, 'John')")
11curs.execute("select * from CUSTOMER")
12print(curs.fetchall())
13
14curs.close()
15conn.close()