python操作SQLite数据库，并读出表中的数据

基本要求

（1）安装SQLite。
（2）安装python。

程序如下：

# -*- 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()
--------------------- 
作者：张海玲 
来源：CSDN 
原文：https://blog.csdn.net/weixin_42014622/article/details/81750063 
版权声明：本文为博主原创文章，转载请附上博文链接！