擅长:python、mysql、java
<p>将连接和游标用作<a href="http://initd.org/psycopg/docs/usage.html#with-statement" rel="nofollow noreferrer">context managers</a>(with语句)可能最简单:</p>
<p>从文件中:</p>
<pre><code>with psycopg2.connect(your_stuff_in_here) as conn:
with conn.cursor() as curs
curs.execute('SELECT * FROM test')
</code></pre>
<p>这将在出现任何错误后自动清除。如果需要对错误进行更细粒度的控制,可以使用try/catch/finally。在</p>