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() # 关闭数据库连接