Python操作SQLite的简单例子

import sqlite3

class SqliteProvider(object):
    def __init__(self, filename):
        super(SqliteService, self).__init__()
        self.conn = sqlite3.connect(filename)

    def __del__( self ):
        if self.conn:
            self.conn.commit()
            self.conn.close()

    def exec_cmd(self, sql):
        cur = self.conn.cursor()
        cur.execute(sql)
        self.conn.commit()
        result = cur.fetchone()

        return result

    def get(self, sql):
        cur = self.conn.cursor()
        cur.execute(sql)
        self.conn.commit()
        result = cur.fetchall()

        return result
		
if __name__ == '__main__'
    db = SqliteProvider('demo.db')
	print db.exec_cmd('SELECT COUNT(*) FORM sqlite_master;')