python mysql executemany :key_python mysql executemany指定写入表

呼如林

楼主，刚敲了一下代码，executemany执行时最好对应个数。#!/usr/bin/envpython#--coding:utf-8--importloggingimportMySQLdbclass_MySQL(object):def__init__(self,host,port,user,passwd,db,charset='utf8'):self.conn=MySQLdb.connect(host=host,port=port,user=user,passwd=passwd,db=db,charset=charset)defget_cursor(self):returnself.conn.cursor()defquery(self,sql):cursor=self.get_cursor()try:cursor.execute(sql,None)result=cursor.fetchall()exceptException,e:logging.error("mysqlqueryerror:%s",e)returnNonefinally:cursor.close()returnresultdefexecute(self,sql,param=None):cursor=self.get_cursor()try:cursor.execute(sql,param)self.conn.commit()affected_row=cursor.rowcountexceptException,e:logging.error("mysqlexecuteerror:%s",e)return0finally:cursor.close()returnaffected_rowdefexecutemany(self,sql,params=None):cursor=self.get_cursor()try:cursor.executemany(sql,params)self.conn.commit()affected_rows=cursor.rowcountexceptException,e:logging.error("mysqlexecutemanyerror:%s",e)return0finally:cursor.close()returnaffected_rowsdefclose(self):try:self.conn.close()except:passdef__del__(self):self.close()host='localhost'port=3306user='root'passwd='123456'db='foo'mysql=_MySQL(host,port,user,passwd,db)defcreate_table():table="""CREATETABLEIFNOTEXISTS`watchdog`(`id`int(11)NOTNULLAUTO_INCREMENTPRIMARYKEY,`name`varchar(100),`price`int(11)NOTNULLDEFAULT0)ENGINE=InnoDBcharset=utf8;"""printmysql.execute(table)definsert_data():params=[('dog_%d'%i,i)foriinxrange(12)]sql="INSERTINTO`watchdog`(`name`,`price`)VALUES(%s,%s);"printmysql.executemany(sql,params)if__name__=='__main__':create_table()insert_data()