亚洲中文字幕无码日韩精品,亚洲一区制服无码中字,亚洲精品第一国产综合精品99 ,一本大道中文日本香蕉

  python連接SQL server實現(xiàn)insert() 和讀取數(shù)據(jù)

發(fā)布日期：2022/9/2 6:42:33      瀏覽量：

首先需要安裝一個package：pymssql 

1、數(shù)據(jù)庫連接

import pymssql as py
import pandas as pd
# 連接數(shù)據(jù)庫，創(chuàng)建學生表，進行表查詢，表錄入
server = "DESKTOP-G8THN71"# 連接服務器地址
user = "sa"# 連接帳號
password = "1234"# 連接密碼
conn = py.connect(server, user, password, "student_message")  #獲取連接
cursor = conn.cursor() # 獲取光標

2、數(shù)據(jù)庫插入

def insert(Name, studentID, Sex):
    count_students = 0
    conn = py.connect(server, user, password, "student_message")  # 獲取連接
    cursor =conn.cursor()
    cursor.execute(’  select count(ID) from students’)
    for row in cursor:
        count_students = row[0]
        print(row[0])
    cursor.executemany(
        "INSERT INTO students VALUES (%d, %s, %d,%s)",
        [(count_students+1, Name, studentID, Sex)])
# 你必須調(diào)用 commit() 來保持你數(shù)據(jù)的提交如果你沒有將自動提交設置為true
    conn.commit()

3、通過某項信息，查詢返回信息

def readName(idnum):
    Name = -1
    conn = py.connect(server, user, password, "student_message")  # 獲取連接
    cursor =conn.cursor()
    cursor.execute(’  select Name from students where ID=’+str(idnum))
    for row in cursor:
        if row[0]!=[]:
            Name = row[0]
    conn.commit()
    return Name