在python中保存数据

# 写入数据到文本文件
with open('data.txt', 'w') as file:
    file.write('Hello, World!')

# 从文本文件读取数据
with open('data.txt', 'r') as file:
    data = file.read()

print(data)  # 输出：Hello, World!

import csv

# 写入数据到CSV文件
data = [['Name', 'Age'], ['John', 25], ['Jane', 30]]
with open('data.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerows(data)

# 从CSV文件读取数据
with open('data.csv', 'r') as file:
    reader = csv.reader(file)
    data = list(reader)

print(data)  # 输出：[['Name', 'Age'], ['John', '25'], ['Jane', '30']]

import sqlite3

# 连接到SQLite数据库
conn = sqlite3.connect('data.db')

# 创建表
conn.execute('''CREATE TABLE IF NOT EXISTS users
                 (id INTEGER PRIMARY KEY AUTOINCREMENT,
                 name TEXT NOT NULL,
                 age INTEGER NOT NULL)''')

# 插入数据
conn.execute("INSERT INTO users (name, age) VALUES ('John', 25)")
conn.execute("INSERT INTO users (name, age) VALUES ('Jane', 30)")
conn.commit()

# 查询数据
cursor = conn.execute("SELECT id, name, age FROM users")
data = cursor.fetchall()

print(data)  # 输出：[(1, 'John', 25), (2, 'Jane', 30)]

# 关闭数据库连接
conn.close()