jaydebeapi_hsqldb_jdbc_connection_query_and_fetch.py

1import jaydebeapi
2
3# Connect to the database using the JDBC driver
4conn = jaydebeapi.connect("org.hsqldb.jdbcDriver",
5                          "jdbc:hsqldb:mem:.",
6                          ["SA", ""],
7                          "/path/to/hsqldb.jar")
8
9# Create a cursor object
10curs = conn.cursor()
11
12# Execute SQL commands
13curs.execute('create table CUSTOMER (ID INTEGER, NAME VARCHAR(255))')
14curs.execute("insert into CUSTOMER values (1, 'John')")
15
16# Execute a query and fetch results
17curs.execute("select * from CUSTOMER")
18print(curs.fetchall())
19
20# Clean up
21curs.close()
22conn.close()