数据增删改查
import sqlite3
from db import get_db_conn,close_db_conn
db_file='score.db'
def inset_score_data():
conn = sqlite3.connect(db_file)
cur=conn.cursor()
sql='insert into score(stu_name,math_score,chinese_score)' 'values=(?,?,?)'
data=('赵五',90,94)
cur.execute(sql,data)
conn.commit()
cur.close()
conn.close()
inset_score_data()
def delete_score_data():
conn = sqlite3.connect(db_file)
cur=conn.cursor()
sql='delete from score where id=?'
id=(3,)
cur.execute(sql,id)
conn.commit()
cur.close()
conn.close()
delete_score_data()
def update_score_data():
conn=sqlite3.connect(db_file)
cur=conn.cursor()
sql='update score set math_score=?,' 'chinese_score=? where id=2'
data=(99,99,)
cur.execute(sql,data)
conn.commit()
cur.close()
conn.close()
update_score_data()
def select_score_all():
conn=sqlite3.connect(db_file)
cur=conn.cursor()
sql='select * from score'
cur.execute(sql)
print(cur.fetchall())
cur.close()
conn.close()
select_score_all()
def insert_mult_data():
conn=sqlite3.connect(db_file)
cur=conn.cursor()
sql='insert into score(stu_name,math_score,chinese_score)' 'values(?,?,?)'
cur.executemany(sql,score_list)
conn.commit()
cur.close()
conn.close()
return cur.rowcount
print(insert_mult_data())
def get_data():
conn=get_db_conn(db_file)
cur=conn.cursor()
sql='select *from score'
cur.execute(sql)
print(cur.fetchall())
close_db_conn(cur,conn)
get_data()
import sqlite3
from sqlite3 import Error
def get_db_conn(db_file):
conn=None
try:
conn=sqlite3.connect(db_file)
except Error as e:
print(e)
if conn is not None:
return conn
def close_db_conn(cur,conn):
if cur is not None:
cur.close()
if conn is not None:
conn.close()