Skip to main content

pyodbc

基础使用​

import pyodbc

serverName = "192.168.100.29"
userName = "sa"
passWord = "sql2008"
port = "1433"

main_db = pyodbc.connect(
    "DRIVER={ODBC Driver 17 for SQL Server};"
    + f"SERVER={serverName};DATABASE=MAIN_DB_1;UID={userName};PWD={passWord}"
)

# 从数据库获取加密数据
def test(npc_id: int):

    sql = "SELECT Gold,Pro01,ItemId01 FROM dbo.NpcDropItemParams WHERE NpcId={};"

    rows = main_db.execute(sql.format(npc_id))

    data = rows.fetchall()

    return data


data = test(4247)