python sql 操作

from werkzeug.security import generate_password_hash

pwd=generate_password_hash(“123456”)

print(str(pwd))

import sqlite3,datetime
conn = sqlite3.connect(database=r’E:\pp\students.sqlite3’)
cursor = conn.cursor()
kk = datetime.datetime.now()

#sql1 = “INSERT INTO admin(id, name, pwd, is_super,role_id,addtime) VALUES(1, ‘admin’, ‘pbkdf2:sha256:260000$xiY52DJ3ZZ7hipyD$23b1f1afd5c22bfaafc141a376891821c9cdfad493b34153bb609bf4a11d134d’, 0,0,‘2023-06-20 22:37:12.785588’)”
sql1 = “INSERT INTO role(id, name, auths, addtime) VALUES(0, ‘admin’,0, ‘2023-06-20 22:37:12.785588’)”

cursor.execute(sql1)

2.关闭数据库连接

conn.commit() # 更新数据库
cursor.close() # 关闭cursor对象
conn.close() # 关闭数据库连接