擅长:python、mysql、java
<p>我的IP已添加,防火墙设置正确。我之所以知道这一点,是因为我获取了enterNewHardware函数代码并将其放入自己的py文件中,从数据变量中删除了textbox变量,只添加了文字字符串。它工作并输入数据。在我的文本框变量和数据库之间。它不喜欢什么东西。我还创建了一个名为“HardwareTree”的新硬件表,只是为了测试,所以在这里重命名了它</p>
<pre><code>import pyodbc
azureServer = "pythonserver5874.database.windows.net"
azureDB = "inventoryDatabase"
userName = "na"
password = "na"
driver = "{ODBC Driver 17 for SQL Server}"
connectionString = f"DRIVER={driver};SERVER={azureServer};PORT=1433;DATABASE=
{azureDB};UID={userName};PWD={password}"
conn = pyodbc.connect(connectionString)
cursor = conn.cursor()
sql_statement = '''INSERT INTO inventoryDatabase.dbo.HardwareThree (serialNumber,
modelName, userName, machineActive)
VALUES (?, ?, ?, ?)'''
data = ('Test', 'Test', 'Test', 'Test')
cursor.execute(sql_statement, data)
conn.commit()
cursor.commit()
conn.close()
</code></pre>
<p><a href="https://i.stack.imgur.com/nCozq.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nCozq.jpg" alt="enter image description here"/></a></p>