mysql 图片存储到数据库中 python

#!/usr/bin/python  
#coding=utf-8  
import MySQLdb   
class BlobDataTestor:  
    def __init__ (self):
        try:
            self.conn = MySQLdb.connect(host='localhost',user='root',passwd='110',db='test')
        except:
           pass  
  
    def __del__ (self):  
        try:  
            self.conn.close()  
        except :  
            pass   
  
    def closedb(self):  
        self.conn.close()  
  
    def setup(self):  
        cursor = self.conn.cursor()  
        cursor.execute( """ 
            CREATE TABLE IF NOT EXISTS `Dem_Picture` ( 
            `ID` int(11) NOT NULL auto_increment, 
            `PicData` mediumblob, 
            PRIMARY KEY (`ID`) 
            ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; 
            """)  

    def teardown(self):  
        cursor = self.conn.cursor()  
        try:  
            cursor.execute( "Drop Table Dem_Picture" )  
        except:  
            pass   
        # self.conn.commit()   
  
    def testRWBlobData(self):   
    # 读取源图片数据                 
        f = open( "/home/hduser/桌面/imagine/rotate.jpeg" , "rb" )  
        b = f.read()  
        f.close()  
  
    # 将图片数据写入表   
        cursor = self.conn.cursor()  
        cursor.execute( "INSERT INTO Dem_Picture (PicData) VALUES (%s)" , (MySQLdb.Binary(b)))  
    # self.conn.commit()   
    # 读取表内图片数据，并写入硬盘文件   
        cursor.execute( "SELECT PicData FROM Dem_Picture ORDER BY ID DESC limit 1" )  
        d = cursor.fetchone()[0]  
        cursor.close()  

        f = open( "/home/hduser/桌面/imagine/hehe.jpeg" , "wb" )  
        f.write(d)  
        f.close()  

if __name__ == "__main__":  
    test = BlobDataTestor()  
    try:  
        test.setup()  
        test.testRWBlobData()  
        test.teardown()  
    finally:  
        test.closedb()