搜鞥都哦 发表于 2017-4-30 15:21:57

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
页: [1]
查看完整版本: python MySQLdb示例代码