SQLite操作[python]

import sqlite3
#创建表
#1、创建或者连接一个数据库DB
connection = sqlite3.connect('coachdata.sqlite')
#2、获取数据库的游标（类似指针）
cursor = connection.cursor()
#3、执行数据库命令execute，命令有create、select、insert、delete、update
cursor.execute(""" CREATE TABLE athletes (
                                        id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL,
                                        name TEXT NOT NULL,
                                        dob DATE NOT NULL)""")

cursor.execute("""CREATE TABLE timing_data (
                                            athlete_id INTEGER NOT NULL,
                                            value TEXT NOT NULL,
                                            FOREIGN KEY (athlete_id) REFERENCES athletes)""")
#4、执行数据库操作
connection.commit()
#5、关闭数据库连接
connection.close()

###################
connection = sqlite3.connect('coachdata.sqlite')
cursor = connection.cursor()
id = '1'
cursor.execute("SELECT name,dob from athletes WHERE id=? ", (id))
# cursor返回的是一个list
print cursor.fetchall()
connection.commit()

 

转载于:https://my.oschina.net/continuous/blog/818297