python-mysql数据库操作

1. 首先要安装MySQLdb依赖库
2. 示范mysql数据库的 增、删、改、查操作
import MySQLdb

class MySQLHelper():

     def __init__(self):
         self.conn = MySQLdb.connect(host="localhost",port=3306,user="cb",passwd="XXXXXX",db="wuyn",charset="utf8")
         #port 可以不写，默认3306
         self.cursor = self.conn.cursor()
        
     # select 操作
     def select_data(self,sql): 
         n = self.cursor.execute(sql)
         print n
         #成功时候返回n=1        
         print "Id\tName\tAge"  
         for rows in self.cursor.fetchall():     
             print "%s\t%s\t%s"%(rows[0],rows[1],rows[2])
   
     # insert 操作
     def insert_data(self, sql, param):
         n  = self.cursor.execute(sql, param)
         print n
   
     # update 操作
     def update_data(self, sql, param):
         n= self.cursor.execute(sql, param)
         print n

     # delete 操作
     def delete_data(self, sql, param):
         n = self.cursor.execute(sql, param)
         print n

     def __del__(self):
         print 'disconnect from mysqldb!'

mysqlhelper = MySQLHelper()
mysqlhelper.get_data('select * from user_t')

sql = "insert into user_t (id, name, age) values (%s, %s, %s)"
param = (100,"wuyn",24)
mysqlhelper.insert_data(sql,param)

sql = "update user_t set name=%s where id = %d"
param = ("wuyn",3)
mysqlhelper.update_data(sql, param)

sql  = "delete from user_t where id = %d"
param = ( 3 )
mysqlhelper.delete_data(sql, param)

mysqlhelper.insert_data(sql,p
----------------------------------------------------------------------------------------------------------------------