简单的用法 # -*- coding: utf-8 -*- from sqlalchemy import create_engine, MetaData engine = create_engine('sqlite:///test.sqlite') metadata = MetaData(bind=engine, reflect=True) conn = engine.connect() # 创建表 conn.execute('CREATE TABLE IF NOT EXISTS user(name VARCHAR, password VARCHAR)') # 创建数据 conn.execute('INSERT INTO user(name, password) VALUES(?, ?)', (('tom', '123'), ('john', '321'))) # 查询 for row in conn.execute('SELECT * FROM user'): print row.name, row['name'], row[0] 更简单的用法 # -*- coding: utf-8 -*- from sqlalchemy import create_engine, MetaData engine = create_engine('sqlite:///test.sqlite') # metadata = MetaData(bind=engine, reflect=True) # 创建表 engine.execute('CREATE TABLE IF NOT EXISTS user(name VARCHAR, password VARCHAR)') # 创建数据 engine.execute('INSERT INTO user(name, password) VALUES(?, ?)', [('tom', '123'), ('john', '321')]) # 查询 for row in engine.execute('SELECT * FROM user'): print row.name, row['name'], row[0]