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]