基本要求
(1)安装SQLite。
(2)安装python。
python操作SQLite数据库,并读出表中的数据
程序如下:
# -*- coding: UTF-8 -*-
import sqlite3
#打开数据库连接
conn = sqlite3.connect('test.db')
print("Opend database successfully")
##清除已存在的表 -students
conn.execute('''DROP TABLE students''');
conn.commit()
##创建一个表students
conn.execute('''CREATE TABLE students
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL);''')
print("Table created successfully");
conn.commit()
##插入数据
conn.execute("INSERT INTO sTudents(ID,NAME,AGE)\
VALUES(1,'Allen',25)");
conn.execute("INSERT INTO sTudents(ID,NAME,AGE)\
VALUES(2,'Maxsu',20)");
conn.execute("INSERT INTO sTudents(ID,NAME,AGE)\
VALUES(3,'Teddy',24)");
conn.commit()
print("Records Insert successfully");
print("-------------------");
##读取表students
cursor =conn.execute("SELECT * from students")
print ("ID NAME AGE")
for it in cursor:
for i in range(len(it)):
print it[i],
print ('\n')
conn.close()
结果如下: