from dbapi import *

serverURL = "derbyserver:localhost"
#serverURL = "derbyserver:10.1.1.123"
dbname = "casino"
username = "admin"
password = "solar"
tbl = "reservation"

with connect(serverURL, dbname, username, password) as con:
    cursor = con.cursor()
    sql = "SELECT * FROM " + tbl
    cursor.execute(sql)   
    result = cursor.fetchall() # list of tuples
    for record in result:
        print("seatNb:", record[0], " booked:", record[1]," cust:", record[2])