python sqlite3简单操作

  • 2020 年 8 月 29 日
  • 笔记
python sqlite3简单操作(原创)
import sqlite3

class CsqliteTable:
def __init__(self):
pass

def linkSqlite3(self):
self.conn = sqlite3.connect('./data/xiaohai.db')
self.c = self.conn.cursor()
print("Opened database successfully")

def insertTable(self,sql):
self.c.execute(sql)
self.conn.commit()
print("insert success")

def selectValues(self):
self.conn = sqlite3.connect('./data/xiaohai.db')
self.c = self.conn.cursor()
self.cursor = self.c.execute("SELECT id from t_member;")
list1=[]
for row in self.cursor:
list1.append(row[0])
return list1

def updateTable(self):
self.conn = sqlite3.connect('./data/xiaohai.db')
self.c = self.conn.cursor()
self.cursor = self.c.execute("UPDATE t_member set name = '墨轩' where ID='1001';")
self.conn.commit()

def delValue(self):
self.conn = sqlite3.connect('test.db')
self.c = self.conn.cursor()
self.c.execute("DELETE from t_member where ID=2;")
self.conn.commit()
def closeTable(self):
print("close table")
self.conn.close()


if __name__=="__main__":
sqliteTable=CsqliteTable()
sqliteTable.linkSqlite3()
# sql="insert into t_member(id,name) values('3166102029','萧海')"
# sqliteTable.insertTable(sql)
# list1=sqliteTable.selectValues()
sqliteTable.updateTable()
sqliteTable.closeTable()