python串連資料庫

標籤：

# -*- coding: utf-8 -*-‘‘‘Created on 2015-03-19Mysql 資料庫連接類‘‘‘import MySQLdbclass DBOperate:    dbhandle = None    #建立和資料庫系統的串連    def connect(self):        self.dbhandle = MySQLdb.connect("localhost","username","password","dbname" )    #擷取操作遊標    def cursor(self):        try:            return self.dbhandle.cursor()        except (AttributeError, MySQLdb.OperationalError):            self.connect()            return self.dbhandle.cursor()    def commit(self):        return self.dbhandle.commit()    #關閉串連    def close(self):        return self.dbhandle.close()        #執行單行sql語句      def execute(self,sql):        conn = self.dbhandle.cursor()        conn.execute(sql)         #執行多條資料    def executemany(self,sql, tmp):        conn = self.dbhandle.cursor()        conn.executemany(sql, tmp)        #查詢某幾行sql    def querymany(self,sql,size):        conn = self.dbhandle.cursor()        conn.execute(sql)        rows = conn.fetchmany(size)        return rows        #查詢1行sql    def queryone(self,sql):        conn = self.dbhandle.cursor()        conn.execute(sql)        rows = conn.fetchone()        return rows            #查詢所有行sql    def queryall(self,sql):        conn = self.dbhandle.cursor()        conn.execute(sql)        rows = conn.fetchall()        return rows

 

python串連資料庫