向前一篇文章中创建的T1表中插入数据。
# -*- coding: utf-8 -*-
"""
Created on Tue Jul 10 22:06:43 2018
使用 executemany 方法,插入值保存在 list 中
@author: User
"""
import fdb
con = fdb.connect(host='127.0.0.1',database='D:/0tixiao/A1.FDB', user='sysdba', password='masterkey',charset='UTF8')
sql_insert = 'insert into T1(NAME,YEAR_RELEASED) values(?, ?)'
param = [
("c", 1972),
("Python", 1991),
('Lisp', 1958),
('Dylan', 1995),
]
cur = con.cursor()
try:
cur.executemany(sql_insert, param)
con.commit()
except Exception as e:
print("执行“执行Firebird: %s 时出错:%s" % (sql_insert, e))
con.rollback()
finally:
cur.close()
con.close()
运行完成后,查看表中数据情况: