Python的内置库—SQLite3

为什么80%的码农都做不了架构师？>>>

Python内置库SQLite3， Python使用SQLite不需要安装，直接使用

SQLite：轻量级，可嵌入，不能承受高并发访问，适合桌面，移动应用。

# SQLite数据库
import sqlite3

# 增 insert
conn = sqlite3.connect('test.db')
cursor = conn.cursor()
cursor.execute('create table user(id varchar(20) primary key, name varchar(20), age varchar(20))' )
cursor.execute('insert into user (id, name, age) values (\'2\', \'Jack\', \'18\')')
print(cursor.rowcount)
cursor.close()
conn.commit()
conn.close()

# 查  select...
conn = sqlite3.connect('test.db')
cursor = conn.cursor()
cursor.execute('select * from user where id=?', ('1', ))
cursor.execute('select * from user')
values = cursor.fetchall()
print(values)
cursor.close()
conn.commit()
conn.close()

# 改  update
conn = sqlite3.connect('test.db')
cursor = conn.cursor()
cursor.execute('update user set age=? where id=?', ('19', '1'))
cursor.execute('select * from user')
values = cursor.fetchall()
print(values)
cursor.close()
conn.commit()
conn.close()


# 删  delete
conn = sqlite3.connect('test.db')
cursor = conn.cursor()
cursor.execute('delete from user where id=?', ('2',))
cursor.execute('select * from user')
values = cursor.fetchall()
print(values)
cursor.close()
conn.commit()
conn.close()

转载于:https://my.oschina.net/xxWang/blog/756334