python 数据库类

#!/usr/bin/python
#coding:gbk
#file_name:music_db
#音乐数据库连接类

from MySQLdb import *

class music_db:
     def __init__(self):
         self.conn = connect(host="127.0.0.1",user="",passwd="",db="")#链接对象
         self.cursor = cursors.DictCursor(self.conn)#指针对象
     def __del__(self):
         self.cursor.close()
         self.conn.close()

     
     def query(self,sql,lastid=None):         
         n = self.cursor.execute(sql) #影响的行数
         if lastid:
            return self.cursor.lastrowid#返回最后插入id    
         else:
            return n

     def fetchone(self,sql):#查询一条
         n = self.query(sql)
         return self.cursor.fetchone()

     def fetchall(self,sql):#查询多条
         n = self.query(sql)
         return self.cursor.fetchall()