Sqlite:
使用Python的sqlite3：
需要注意下commit方式与qt稍有不同
importsqlite3classDBManager():def__init__(self):
self.db= sqlite3.connect("core.db")
self.query=self.db.cursor()
...
self._initTable()
...## Create table["webpower"] if not existsdef_initTable(self):
self.query.execute("create table if not exists webpower (id integerPRimary key,name TEXT,state integer)")
self.db.commit()
...
使用QtSql:
1fromPyQt4.QtSqlimportQSqlQuery,QSqlDatabase23classDBManager():4def__init__(self):5self.db = QSqlDatabase.addDatabase("QSQLITE")#select database type6self.db.setDatabaseName("core.db")#set database name7self.db.open()#connect to or create database8self.query = QSqlQuery()#sql handler9...1011...
MySQL:
fromPyQt4.QtSqlimportQSqlQuery,QSqlDatabaseclassDBManager():def__init__(self):
self.db= QSqlDatabase.addDatabase("QMYSQL")#select database typeself.db.setHostName("localhost")#set addressself.db.setUserName("root");#set user nameself.db.setPassWord("root");#set user pwdself._trytoConnect()#check connectionself.query =QSqlQuery()## create databaseself.query.exec_("CREATE DATABASE test1")## Choose databaseself.db.setDatabaseName("test1")
self._trytoConnect()#also can be :self.query.exec_("USE test1")## Connect and check connection statedef_trytoConnect(self):if(self.db.open()):print"Success"else:print"Failed to connect to mysql"...
常用SQL：
--create tablecreatetableifnotexiststest2 (idintegerprimarykey,timereal,powersreal);--clear tabledeletefromtest2;--insertinsertintot1values(1,0.1,0.2);--selectselect*fromtest1--delete tabledroptabletest4