第11章使用Python操作數(shù)據(jù)庫(kù)

1、Python操作數(shù)據(jù)庫(kù)數(shù)據(jù)庫(kù)編程接口連接對(duì)象參數(shù)參數(shù)說(shuō)明說(shuō)明dsn數(shù)據(jù)源名稱(chēng)，給出該參數(shù)表示數(shù)據(jù)庫(kù)依賴user用戶名password用戶密碼host主機(jī)名database數(shù)據(jù)庫(kù)名稱(chēng)conn = pymysql.connect(host=localhost, user=user, password=passwd, db=test, charset=utf8, cursorclass=pymysql.cursors.DictCursor)Connection對(duì)象方法名方法名說(shuō)明說(shuō)明cursor()獲取游標(biāo)對(duì)象，操作數(shù)據(jù)庫(kù)，如執(zhí)行DML操作，調(diào)用存儲(chǔ)過(guò)程等commit()提交事務(wù)rollback()

2、回滾事務(wù)close()關(guān)閉數(shù)據(jù)庫(kù)連接Connection對(duì)象方法游標(biāo)對(duì)象Cursor對(duì)象方法名方法名說(shuō)明說(shuō)明callproc(procname, parameters)調(diào)用存儲(chǔ)過(guò)程，需要數(shù)據(jù)庫(kù)支持close()關(guān)閉當(dāng)前游標(biāo)execute(operation, parameters)執(zhí)行數(shù)據(jù)庫(kù)操作，SQL語(yǔ)句或者數(shù)據(jù)庫(kù)命令executemany(operation, seq_of_params)用于批量操作，如批量更新fetchone()獲取查詢結(jié)果集中的下一條記錄fetchmany(size)獲取指定數(shù)量的記錄fetchall()獲取結(jié)構(gòu)集的所有記錄nextset()跳至下一個(gè)可用的結(jié)果集co

3、nn = pymysql.connect(host=localhost, user=user, password=passwd, db=test, charset=utf8, cursorclass=pymysql.cursors.DictCursor)Connection對(duì)象cur = conn.cursor()cur.excute(“insert into users(id,name) values(1,mr)”)cur.close()mit()conn.close()Cursor對(duì)象使用SQLite創(chuàng)建數(shù)據(jù)庫(kù)文件實(shí)現(xiàn)步驟導(dǎo)入sqlite3模塊創(chuàng)建Connection連接對(duì)象創(chuàng)建Cursor游標(biāo)對(duì)象執(zhí)行SQL語(yǔ)句關(guān)閉游標(biāo)關(guān)閉連接create table user( id int(10) primary key ,name varchar(20) )操作SQLite數(shù)據(jù)操作SQLite數(shù)據(jù)新增修改刪除查詢操作SQLite步驟導(dǎo)入sqlite3模塊創(chuàng)建Connection連接對(duì)象創(chuàng)建Cursor游標(biāo)對(duì)象執(zhí)行SQL語(yǔ)句關(guān)閉游標(biāo)關(guān)閉連接SQL語(yǔ)句ufetchone()：獲取查詢結(jié)果集中的下一條記錄。ufetchmany(size)：獲取指定數(shù)量的記錄