擅长:python、mysql、java
<p>改为使用绑定变量。下面是在Python中使用DBs的规范:<a href="http://www.python.org/dev/peps/pep-0249/" rel="nofollow noreferrer">PEP 249: Python Database API Specification v2.0</a>。</p>
<p>更新:根据<code>pymssql</code>的文档,您需要如下内容:</p>
<pre><code>sql = """
INSERT INTO [SCHOOLINFO]
VALUES(
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %d, %s, %s, %d
)"""
cur.execute(sql, self.accountNo, self.altName, self.address1, self.address2, self.city, self.state, self.zipCode, self.phone1, self.phone2, self.fax, self.contactName, self.contactEmail, self.prize_id, self.shipping, self.chairTempPass, self.studentCount)
</code></pre>