jaydebeapi_hsqldb_jdbc_connection_query_and_fetch.py

1import jaydebeapi
2
3# Connect to 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 a query
13curs.execute('create table CUSTOMER (ID INTEGER, NAME VARCHAR(255))')
14curs.execute("insert into CUSTOMER values (1, 'John')")
15curs.execute("select * from CUSTOMER")
16
17# Fetch and print results
18results = curs.fetchall()
19print(results)
20
21# Clean up
22curs.close()
23conn.close()