jaydebeapi_hsqldb_jdbc_connection_query_and_fetch.py

1import jaydebeapi
2
3# Replace these variables with your actual database and driver details
4driver_class = "org.hsqldb.jdbcDriver"
5connection_url = "jdbc:hsqldb:mem:mymemdb"
6driver_jar = "/path/to/hsqldb.jar"
7credentials = ["SA", ""]
8
9# Establishing the connection
10conn = jaydebeapi.connect(
11    driver_class,
12    connection_url,
13    credentials,
14    driver_jar,
15)
16
17# Creating a cursor and executing a query
18curs = conn.cursor()
19curs.execute('create table customer (id integer, name varchar(20))')
20curs.execute("insert into customer values (1, 'John')")
21curs.execute("select * from customer")
22
23# Fetching the result
24print(curs.fetchall())
25
26# Closing the connection
27curs.close()
28conn.close()