擅长:python、mysql、java
<p>无论使用什么库来执行SQL语句,都应该有一种方法来区分空结果集和一个或多行的结果集。检查<a href="http://code.google.com/p/pyodbc/wiki/GettingStarted" rel="nofollow">tutorial for pyodbc</a>。这样的方法会起作用:</p>
<pre><code>SQL.execute("SELECT CodePro FROM Table WHERE CodeID = ?", x)
row = SQL.fetchone()
if row: # check if there was at least one row returned
CodePro = row[0]
</code></pre>