sqlite3简单操作

创建表importsqlite3# 连接文件数据库（不存在则自动创建）conn=sqlite3.connect("my_database.db")cursor=conn.cursor()# 创建表cursor.execute(""" create table if not exists users ( id integer primary key autoincrement, username text not null, age integer ) """)# 插入数据cursor.execute("insert into users(username, age) values("bob", 25)")conn.commit()# 查询数据cursor.execute("select * from users")print(cursor.fetchall())# 输出: [(1, 'bob', 25)]conn.close()-----------------------------------------------------------------------------------删除表中数据importsqlite3 DB_FILE="C:/inoutsave.db"# 连接到SQLite数据库conn=sqlite3.connect(DB_FILE)try:# 创建一个游标对象cursor=conn.cursor()# 执行DELETE语句清除表数据cursor.execute("DELETE FROM io_record")# 提交事务conn.commit()exceptsqlite3.Errorase:print(f"An error occurred:{e}")# 如果发生错误，则回滚事务conn.rollback()finally:# 关闭数据库连接conn.close()