Python與數(shù)據(jù)庫交互：入門指南

更新時間：2023年11月08日 08:26:17 作者：半夏微光zhang

這篇文章主要介紹了Python與數(shù)據(jù)庫交互：入門指南的相關(guān)資料,需要的朋友可以參考下

"""測試連接數(shù)據(jù)庫"""

1.第一步導(dǎo)包

from pymysql import Connection

2.獲取連接對象

connection = Connection( host="localhost", #主機(jī)名(IP) port=3306, #端口號 user="root", #用戶名 password="123456", #密碼 autocommit=True #(自動確認(rèn)，用于增刪改) )

3.獲取游標(biāo)

cursor = connection.cursor()

4.使用數(shù)據(jù)庫

connection.select_db("test")

5.執(zhí)行sql語句

cursor.execute("select *from user")

6.獲取數(shù)據(jù)(數(shù)據(jù)為元組類型)

fetchall = cursor.fetchall()

7.循環(huán)遍歷數(shù)據(jù)

for e in fetchall: print(e)

8.關(guān)閉對象

connection.close()

以下是一個使用Python連接數(shù)據(jù)庫的示例代碼：

import mysql.connector

# 連接數(shù)據(jù)庫
def connect_to_database():
    try:
        conn = mysql.connector.connect(
            host="your_host",
            user="your_user",
            password="your_password",
            database="your_database"
        )
        print("成功連接到數(shù)據(jù)庫")
        return conn
    except mysql.connector.Error as err:
        print("數(shù)據(jù)庫連接失?。?, err)

# 查詢數(shù)據(jù)
def query_data(conn, query):
    try:
        cursor = conn.cursor()
        cursor.execute(query)
        results = cursor.fetchall()
        for row in results:
            print(row)
    except mysql.connector.Error as err:
        print("查詢數(shù)據(jù)失敗：", err)

# 插入數(shù)據(jù)
def insert_data(conn, query, values):
    try:
        cursor = conn.cursor()
        cursor.execute(query, values)
        conn.commit()
        print("數(shù)據(jù)插入成功")
    except mysql.connector.Error as err:
        print("插入數(shù)據(jù)失?。?, err)

# 更新數(shù)據(jù)
def update_data(conn, query):
    try:
        cursor = conn.cursor()
        cursor.execute(query)
        conn.commit()
        print("數(shù)據(jù)更新成功")
    except mysql.connector.Error as err:
        print("更新數(shù)據(jù)失?。?, err)

# 刪除數(shù)據(jù)
def delete_data(conn, query):
    try:
        cursor = conn.cursor()
        cursor.execute(query)
        conn.commit()
        print("數(shù)據(jù)刪除成功")
    except mysql.connector.Error as err:
        print("刪除數(shù)據(jù)失?。?, err)

# 關(guān)閉數(shù)據(jù)庫連接
def close_connection(conn):
    conn.close()
    print("數(shù)據(jù)庫連接已關(guān)閉")

# 測試連接和查詢
conn = connect_to_database()
query = "SELECT * FROM your_table"
query_data(conn, query)
close_connection(conn)

到此這篇關(guān)于Python與數(shù)據(jù)庫交互：入門指南的文章就介紹到這了,更多相關(guān)Python連接數(shù)據(jù)庫內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: