【完结】Python基础知识学习 Day14

一、零碎知识点

1、SQLite

SELECT * FROM Linkman

INSERT INTO Linkman (Name,Mobile,BirthDate,IsValid) VALUES ('Tom','18866669999','1990-09-01',1);
INSERT INTO Linkman (Name,Mobile,BirthDate,IsValid) VALUES ('Jarry','18866669999','1990-09-01',1);
INSERT INTO Linkman (Name,Mobile,BirthDate,IsValid) VALUES ('Mike','18866669999','1990-09-01',1);
INSERT INTO Linkman (Name,Mobile,BirthDate,IsValid) VALUES ('Peter','18866669999','1990-09-01',0;
INSERT INTO Linkman (Name,Mobile,BirthDate,IsValid) VALUES ('Marry','18866669999','1990-09-01',1);

UPDATE Linkman SET BirthDate = '1998-12-21' WHERE rowid = 1

DELETE FROM Linkman WHERE OID = 5

2、用Python操作SQLite

import sqlite3

conn = sqlite3.connect('addressbook.db')
c = conn.cursor()

s1 = 'INSERT INTO Linkman (Name,Mobile,BirthDate,IsValid) VALUES ('Tom','18866669999','1990-09-01',1)'
s2 = 'UPDATE Linkman SET BirthDate = '1998-12-21' WHERE rowid = 1'
s3 = 'DELETE FROM Linkman WHERE OID = 5'

c.execute(s1)
c.execute(s2)
c.execute(s3)

conn.commit()
conn.close()

实际应用时可定义不同的函数来进行操作

二、Xmind