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数据库的方法
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持毛票票。