python学习：多种方式显示Firebird数据库表中数据

一、最简单直接的方式显示表中的数据，当然显示结果不直观。

# -*- coding: utf-8 -*-
"""
Created on Tue Jul 10 22:06:43 2018
@author: User
"""
import fdb

con = fdb.connect(host='127.0.0.1',database='D:/0tixiao/A1.FDB', user='sysdba', password='masterkey',charset='UTF8')

cur = con.cursor()

sql_select = 'select * from T1 order by year_released'

#显示全部内容
cur.execute(sql_select)
print(cur.fetchall())

cur.close()
con.close()

显示结果：

[('Lisp', 1958), ('c', 1972), ('Python', 1991), ('Dylan', 1995)]

二、每次显示一行数据：

# -*- coding: utf-8 -*-
"""
Created on Tue Jul 10 22:06:43 2018
@author: User
"""
import fdb

con = fdb.connect(host='127.0.0.1',database='D:/0tixiao/A1.FDB', user='sysdba', password='masterkey',charset='UTF8')

cur = con.cursor()

sql_select = 'select * from T1 order by year_released'

#每次显示一行数据，第1种方式
cur.execute(sql_select)
for (NAME, YEAR_RELEASED) in cur:
    print('1:%s was available since %s' % (NAME, YEAR_RELEASED))

#每次显示一行数据，第2种方式 
cur.execute(sql_select)
for row in cur:
    print('2:%s was available since %s' % (row[0], row[1]))
 
#每次显示一行数据，第3种方式
cur.execute(sql_select)
for row in cur.itermap():
    print('3:%(name)s was available since %(YEAR_RELEASED)d' % row) 

cur.close()
con.close()

显示结果：

1:Lisp was available since 1958
1:c was available since 1972
1:Python was available since 1991
1:Dylan was available since 1995
2:Lisp was available since 1958
2:c was available since 1972
2:Python was available since 1991
2:Dylan was available since 1995
3:Lisp was available since 1958
3:c was available since 1972
3:Python was available since 1991
3:Dylan was available since 1995