Untitled
unknown
python
2 years ago
824 B
7
Indexable
def display_loans():
mycursor.execute("SELECT * FROM Loan")
rows = mycursor.fetchall()
if not rows:
print("No loan records found.")
else:
print("Loan Details:")
for row in rows:
if len(row) >= 9:
print("Account Number:", row[0])
print("Loan Amount:", row[1])
print("Profit Rate:", row[2])
print("Time Period (Months):", row[3])
print("Loan Type:", row[4])
print("Customer Salary:", row[5])
print("Final Amount:", row[6])
print("Total Profit:", row[7])
print("Last Payment Date:", row[8])
print("\n")
else:
print("Incomplete data in row:", row)
display_loans()Editor is loading...
Leave a Comment