Python-SQLite数据库连接Demo

#数据库连接
import sqlite3

#1、打开数据库
conn = sqlite3.connect("test_Raspberry.db")

#2、打开游标
c = conn.cursor()

#3、执行SQL语句
c.execute('drop table IF EXISTS user;')
c.execute('drop table IF EXISTS orderlist;')
c.execute('CREATE TABLE user ( _id integer PRIMARY KEY AUTOINCREMENT, user TEXT, pass text, age integer )')
c.execute('''CREATE TABLE orderlist (
	_id integer PRIMARY KEY AUTOINCREMENT,
	item_name text,
	item_price real,
	item_number integer,
	user_id integer,
FOREIGN KEY ( user_id ) REFERENCES user_tb ( _id ));''')

#4、关闭游标
c.close()
#5、关闭连接
conn.close()