python MySQLdb示例代码

搜鞥都哦

　　# -*- coding: utf-8 -*-
　　import MySQLdb
　　
#DB parameter
strHost = 'localhost'
strDB = 'web_study_db'
strUser = 'root'
strPasswd = '1234'
　　#connect to DB
def getConnect(host=strHost, db=strDB, user=strUser, passwd=strPasswd, charset="utf8"):
return MySQLdb.connect(host=strHost, db=strDB, user=strUser, passwd=strPasswd, charset="utf8")
　　def initClientEncode(conn):
curs = conn.cursor()
curs.execute("SET NAMES utf8")
conn.commit()
return curs
　　def insertBookDetail(bookDetail):
conn = getConnect()
curs = initClientEncode(conn)
sqlStr = '''insert into t_book_details (name,isbn,publisher,author) values (%s,%s,%s,%s)'''
　　#生成sql语句
　　#这里的bookDetail.name等字段，都已经转化为Utf-8编码
param = (bookDetail.name,bookDetail.isbn,bookDetail.publisher,bookDetail.author)
ret = curs.execute(sqlStr, param)
conn.commit()
#取自增的当前Id
curs.execute("SELECT LAST_INSERT_ID()")
row = curs.fetchone()
　　
curs.close()
conn.close()
return row[0]