python3.4用函数操作mysql5.7数据库
本文实例为大家分享了python3.4函数操作mysql数据库的具体代码，供大家参考，具体内容如下
#!/usr/bin/envpython
#-*-coding:utf-8-*-
#__author__="blzhu"
"""
pythonstudy
Date：2017
"""
#-*-coding:utf-8-*-
__author__='djstava@gmail.com'
importlogging
importpymysql
classMySQLCommand(object):
def__init__(self,host,port,user,passwd,db,table,charset):
self.host=host
self.port=port
self.user=user
self.password=passwd
self.db=db
self.table=table
self.charset=charset
defconnectMysql(self):
try:
self.conn=pymysql.connect(host=self.host,port=self.port,user=self.user,passwd=self.password,
db=self.db,charset=self.charset)
self.cursor=self.conn.cursor()
print('connect'+self.table+'correctly!')
except:
print('connectmysqlerror.')
defqueryMysql(self):
sql="SELECT*FROM"+self.table
try:
print("queryMysql:")
self.cursor.execute(sql)
#row=self.cursor.fetchone()
fordinself.cursor:
print(str(d[0]),str(d[1]),str(d[2]))
#print(row)
except:
print(sql+'executefailed.')
definsertMysql(self,id,name,sex):
sql="INSERTINTO"+self.table+"VALUES("+id+","+"'"+name+"',"+"'"+sex+"')"
try:
print("insertMysql:")
self.cursor.execute(sql)
print(sql)
except:
print("insertfailed.")
defupdateMysqlSN(self,name,sex):
sql="UPDATE"+self.table+"SETsex='"+sex+"'"+"WHEREname='"+name+"'"
print("updatesn:"+sql)
try:
self.cursor.execute(sql)
self.conn.commit()
except:
self.conn.rollback()
defdeleteMysql(self,id):#删除
sql="DELETEFROM%sWHEREid='%s'"%(self.table,id)
#"deletefromstudentwherezid='%s'"%(id)
try:
self.cursor.execute(sql)
print(sql)
self.conn.commit()
print("deletethe"+id+"throwsuccessfully!")
except:
print("deletefailed!")
self.conn.rollback()
defcloseMysql(self):
self.conn.commit()#不执行此句，所作的操作不会写入到数据库中
self.cursor.close()
self.conn.close()
if__name__=='__main__':
zblmysql=MySQLCommand(host='localhost',user='root',passwd='root',db='zbltest1',port=3306,table='student2',
charset='utf8')
zblmysql.connectMysql()
zblmysql.queryMysql()
zblmysql.insertMysql('5','zbl5','man')
zblmysql.queryMysql()
zblmysql.deleteMysql(id=2)
zblmysql.queryMysql()
zblmysql.updateMysqlSN(name='zbl5',sex='woman')
zblmysql.queryMysql()
zblmysql.closeMysql()
参考：python3操作mysql数据库的方法
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持毛票票。