国产成人精品久久免费动漫-国产成人精品天堂-国产成人精品区在线观看-国产成人精品日本-a级毛片无码免费真人-a级毛片毛片免费观看久潮喷

您的位置:首頁(yè)技術(shù)文章
文章詳情頁(yè)

Python 操作 PostgreSQL 數(shù)據(jù)庫(kù)示例【連接、增刪改查等】

瀏覽:103日期:2022-07-29 13:36:37

本文實(shí)例講述了Python 操作 PostgreSQL 數(shù)據(jù)庫(kù)。分享給大家供大家參考,具體如下:

我使用的是 Python 3.7.0

PostgreSQL可以使用psycopg2模塊與Python集成。

sycopg2是用于Python編程語(yǔ)言的PostgreSQL數(shù)據(jù)庫(kù)適配器。

psycopg2是非常小,快速,穩(wěn)定的。 您不需要單獨(dú)安裝此模塊,因?yàn)槟J(rèn)情況下它會(huì)隨著Python 2.5.x版本一起發(fā)布。

pip3 install python-psycopg2pip3 install psycopg2-binary

連接到數(shù)據(jù)庫(kù)

以下Python代碼顯示了如何連接到現(xiàn)有的數(shù)據(jù)庫(kù)。 如果數(shù)據(jù)庫(kù)不存在,那么它將自動(dòng)創(chuàng)建,最后將返回一個(gè)數(shù)據(jù)庫(kù)對(duì)象。

#!/usr/bin/pythonimport psycopg2conn = psycopg2.connect(database='testdb', user='postgres', password='pass123', host='127.0.0.1', port='5432')print('Opened database successfully')

在這里指定使用testdb作為數(shù)據(jù)庫(kù)名稱,如果數(shù)據(jù)庫(kù)已成功打開(kāi)連接,則會(huì)提供以下消息:

Open database successfully

創(chuàng)建表

以下Python程序?qū)⒂糜谠谙惹皠?chuàng)建的數(shù)據(jù)庫(kù)(testdb)中創(chuàng)建一個(gè)表:

#!/usr/bin/pythonimport psycopg2conn = psycopg2.connect(database='testdb', user='postgres', password='pass123', host='127.0.0.1', port='5432')print('Opened database successfully')cur = conn.cursor()cur.execute(’’’CREATE TABLE COMPANY (ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50), SALARY REAL);’’’)print 'Table created successfully'conn.commit()conn.close()

當(dāng)執(zhí)行上述程序時(shí),它將在數(shù)據(jù)庫(kù)testdb中創(chuàng)建COMPANY表,并顯示以下消息:

Opened database successfullyTable created successfully

插入操作

以下Python程序顯示了如何在上述示例中創(chuàng)建的COMPANY表中創(chuàng)建記錄:

#!/usr/bin/pythonimport psycopg2conn = psycopg2.connect(database='testdb', user='postgres', password='pass123', host='127.0.0.1', port='5432')print('Opened database successfully')cur = conn.cursor()cur.execute('INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, ’Paul’, 32, ’California’, 20000.00 )');cur.execute('INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (2, ’Allen’, 25, ’Texas’, 15000.00 )');cur.execute('INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (3, ’Teddy’, 23, ’Norway’, 20000.00 )');cur.execute('INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (4, ’Mark’, 25, ’Rich-Mond ’, 65000.00 )');conn.commit()print('Records created successfully');conn.close()

當(dāng)執(zhí)行上述程序時(shí),它將在COMPANY表中創(chuàng)建/插入給定的記錄,并顯示以下兩行:

Opened database successfullyRecords created successfully

SELECT操作

以下 Python 程序顯示了如何從上述示例中創(chuàng)建的 COMPANY 表中獲取和顯示記錄:

#!/usr/bin/pythonimport psycopg2conn = psycopg2.connect(database='testdb', user='postgres', password='pass123', host='127.0.0.1', port='5432')print('Opened database successfully')cur = conn.cursor()cur.execute('SELECT id, name, address, salary from COMPANY')rows = cur.fetchall()for row in rows: print('ID = ', row[0]) print('NAME = ', row[1]) print('ADDRESS = ', row[2]) print('SALARY = ', row[3], 'n')print('Operation done successfully');conn.close()

執(zhí)行上述程序時(shí),會(huì)產(chǎn)生以下結(jié)果:

Opened database successfullyID = 1NAME = PaulADDRESS = CaliforniaSALARY = 20000.0

ID = 2NAME = AllenADDRESS = TexasSALARY = 15000.0

ID = 3NAME = TeddyADDRESS = NorwaySALARY = 20000.0

ID = 4NAME = MarkADDRESS = Rich-MondSALARY = 65000.0

Operation done successfully

更新操作

以下 Python 代碼顯示了如何使用UPDATE語(yǔ)句來(lái)更新任何記錄,然后從COMPANY表中獲取并顯示更新的記錄:

#!/usr/bin/pythonimport psycopg2conn = psycopg2.connect(database='testdb', user='postgres', password='pass123', host='127.0.0.1', port='5432')print('Opened database successfully')cur = conn.cursor()cur.execute('UPDATE COMPANY set SALARY = 25000.00 where ID=1')conn.commitprint('Total number of rows updated :', cur.rowcount)cur.execute('SELECT id, name, address, salary from COMPANY')rows = cur.fetchall()for row in rows: print('ID = ', row[0]) print('NAME = ', row[1]) print('ADDRESS = ', row[2]) print('SALARY = ', row[3], 'n')print('Operation done successfully');conn.close()

Python

執(zhí)行上述程序時(shí),會(huì)產(chǎn)生以下結(jié)果:

Opened database successfullyTotal number of rows updated : 1ID = 1NAME = PaulADDRESS = CaliforniaSALARY = 25000.0

ID = 2NAME = AllenADDRESS = TexasSALARY = 15000.0

ID = 3NAME = TeddyADDRESS = NorwaySALARY = 20000.0

ID = 4NAME = MarkADDRESS = Rich-MondSALARY = 65000.0

Operation done successfully

刪除操作

以下 Python 代碼顯示了如何使用 DELETE 語(yǔ)句來(lái)刪除記錄,然后從 COMPANY 表中獲取并顯示剩余的記錄:

#!/usr/bin/pythonimport psycopg2conn = psycopg2.connect(database='testdb', user='postgres', password='pass123', host='127.0.0.1', port='5432')print('Opened database successfully')cur = conn.cursor()cur.execute('DELETE from COMPANY where ID=2;')conn.commitprint('Total number of rows deleted :', cur.rowcount)cur.execute('SELECT id, name, address, salary from COMPANY')rows = cur.fetchall()for row in rows: print('ID = ', row[0]) print('NAME = ', row[1]) print('ADDRESS = ', row[2]) print('SALARY = ', row[3], 'n')print('Operation done successfully');conn.close()

執(zhí)行上述程序時(shí),會(huì)產(chǎn)生以下結(jié)果:

Opened database successfullyTotal number of rows deleted : 1ID = 1NAME = PaulADDRESS = CaliforniaSALARY = 20000.0

ID = 3NAME = TeddyADDRESS = NorwaySALARY = 20000.0

ID = 4NAME = MarkADDRESS = Rich-MondSALARY = 65000.0

Operation done successfully

更多關(guān)于Python相關(guān)內(nèi)容感興趣的讀者可查看本站專題:《Python常見(jiàn)數(shù)據(jù)庫(kù)操作技巧匯總》、《Python數(shù)學(xué)運(yùn)算技巧總結(jié)》、《Python數(shù)據(jù)結(jié)構(gòu)與算法教程》、《Python函數(shù)使用技巧總結(jié)》、《Python字符串操作技巧匯總》、《Python入門與進(jìn)階經(jīng)典教程》及《Python文件與目錄操作技巧匯總》

希望本文所述對(duì)大家Python程序設(shè)計(jì)有所幫助。

標(biāo)簽: Python 編程
相關(guān)文章:
主站蜘蛛池模板: 欧美成人高清在线视频大全 | 欧美成人日韩 | 日本久久久久久 | 精品国产免费观看久久久 | 国产成人综合日韩精品无 | 午夜国产理论 | 久久精品.com| 高清在线一区二区三区亚洲综合 | 国产亚洲欧美日韩在线观看一区二区 | 性欧美视频a毛片在线播放 性欧美一级 | 色精品一区二区三区 | 免费国产高清精品一区在线 | 一级一片免费视频播放 | 大陆老头xxxxxhd | 99在线精品视频在线观看 | 在线视频久久 | 久久久久久免费视频 | 国内欧美一区二区三区 | 国产欧美精品综合一区 | 久久www免费人成_看片高清 | 国产精品爱久久久久久久9999 | 日韩三级在线免费观看 | 香蕉福利久久福利久久香蕉 | 在线观看免费精品国产 | 国产三级久久久精品三级 | 毛片基地免费视频a | 久久精品综合免费观看 | 成人久久 | 亚洲精品成人av在线 | 国产成人综合视频 | 国产精品无码久久av | 国产在线极品 | 怡红院宜春院 | 亚洲欧美自拍偷拍 | 在线不卡一区二区 | 97视频免费播放观看在线视频 | 男女上下爽无遮挡午夜免费视频 | 免费一级视频在线播放 | 久久久久久久久久久福利观看 | 亚洲系列在线 | 国产菲菲视频在线观看 |