擅长:python、mysql、java
<p>我认为在插入之后需要提交(模式更改,如新表应该自动提交)。我建议将完整路径添加到数据库中,以确保下次访问的位置相同。</p>
<p>下面是代码的扩展:</p>
<pre><code>import sqlite3
def create():
try:
c.execute("""CREATE TABLE mytable
(start, end, score)""")
except:
pass
def insert():
c.execute("""INSERT INTO mytable (start, end, score)
values(1, 99, 123)""")
def select(verbose=True):
sql = "SELECT * FROM mytable"
recs = c.execute(sql)
if verbose:
for row in recs:
print row
db_path = r'C:\Users\Prosserc\Documents\Geocoding\test.db'
conn = sqlite3.connect(db_path)
c = conn.cursor()
create()
insert()
conn.commit() #commit needed
select()
c.close()
</code></pre>
<p>输出:</p>
<pre><code>(1, 99, 123)
</code></pre>
<p>关闭程序后,如果我登录到SQLite数据库,数据仍然存在。</p>