python-访问sqlite数据库

最新推荐文章于 2022-01-27 15:22:18 发布

原创最新推荐文章于 2022-01-27 15:22:18 发布 · 263 阅读

0 ·

CC 4.0 BY-SA版权

python 专栏收录该内容

199 篇文章

订阅专栏

import sqlite3

conn = sqlite3.connect('mrsoft.db')
cursor = conn.cursor()
cursor.execute('create table user(id int(10) primary key,name varchar(2))')
cursor.close()
conn.close()

************************************************

import sqlite3

conn = sqlite3.connect('mrsoft.db')
cursor = conn.cursor()
sql = 'insert into user(id,name) values(?,?)'
# cursor.execute(sql,(2,"xiaoming"))
data=[(3,"andy"),(4,"tom"),(5,"jordon")]
cursor.executemany(sql,data)
cursor.close()
conn.commit()
conn.close()

***************************************************
import sqlite3

conn = sqlite3.connect('mrsoft.db')
cursor = conn.cursor()
sql = 'select * from user'
cursor.execute(sql)
# result = cursor.fetchone()
# print(result)
# result = cursor.fetchone()
# print(result)

# result =cursor.fetchmany(3)

result = cursor.fetchall()
print(result)
cursor.close()
# conn.commit()
conn.close()

**********************************************************

import sqlite3

conn = sqlite3.connect('mrsoft.db')
cursor = conn.cursor()
sql = 'update user set name=? where id=?'
cursor.execute(sql,("mr",1))
cursor.execute("select * from user")
result = cursor.fetchall()
print(result)
cursor.close()
conn.commit()
conn.close()

******************************************************************

import sqlite3

conn = sqlite3.connect('mrsoft.db')
cursor = conn.cursor()
sql = 'delete from user where id=?'
cursor.execute(sql,(1,))

cursor.execute("select * from user")
result = cursor.fetchall()
print(result)
cursor.close()
conn.commit()
conn.close()