python mysql数据库操作封装_Python操作mysql数据库（封装基本的增删改查）

gistfile1.txt

1、安装MySQL-python-1.2.3.win-amd64-py2.7.exe，这是操作mysql数据库的python库，有32位和64位之分，看自机器下载

2、64位机器安装MySQL-python-1.2.3.win-amd64-py2.7.exe出现 which was not found the regidtry，请点这里

3、引入mysql库：

import MySQLdb

# -*- coding: cp936 -*-

import MySQLdb

class MysqldbHelper:

#获取数据库连接

def getCon(self):

try:

conn=MySQLdb.connect(host='localhost',user='mjy',passwd='123',db='python',port=3306,charset='utf8')

return conn

except MySQLdb.Error,e:

print "Mysqldb Error:%s" % e

#查询方法，使用con.cursor(MySQLdb.cursors.DictCursor),返回结果为字典

def select(self,sql):

try:

con=self.getCon()

print con

cur=con.cursor(MySQLdb.cursors.DictCursor)

count=cur.execute(sql)

fc=cur.fetchall()

return fc

except MySQLdb.Error,e:

print "Mysqldb Error:%s" % e

finally:

cur.close()

con.close()

#带参数的更新方法,eg:sql='insert into pythontest values(%s,%s,%s,now()',params=(6,'C#','good book')

def updateByParam(self,sql,params):

try:

con=self.getCon()

cur=con.cursor()

count=cur.execute(sql,params)

con.commit()

return count

except MySQLdb.Error,e:

con.rollback()

print "Mysqldb Error:%s" % e

finally:

cur.close()

con.close()

#不带参数的更新方法

def update(self,sql):

try:

con=self.getCon()

cur=con.cursor()

count=cur.execute(sql)

con.commit()

return count

except MySQLdb.Error,e:

con.rollback()

print "Mysqldb Error:%s" % e

finally:

cur.close()

con.close()

if __name__ == "__main__":

db=MysqldbHelper()

def get():

sql="select * from pythontest"

fc=db.select(sql)

for row in fc:

print row["ptime"]

def ins():

sql="insert into pythontest values(5,'数据结构','this is a big book',now())"

count=db.update(sql)

print count

def insparam():

sql="insert into pythontest values(%s,%s,%s,now())"

params=(6,'C#','good book')

count=db.updateByParam(sql,params)

print count

def delop():

sql="delete from pythontest where pid=4"

count=db.update(sql)

print "the："+str(count)

def change():

sql="update pythontest set pcontent='c# is a good book' where pid=6"

count=db.update(sql)

print count

#get()

#ins()

#insparam()

#delop()

#change()