-
python3连接MySQL数据库
- import pymysql
-
- class MYSQL:
-
- def __init__(self,host,user,pwd,dbname):
- self.host = host
- self.user = user
- self.pwd = pwd
- self.dbname = dbname
-
-
-
- def getCursor(self):
-
-
- self.db = pymysql.connect(self.host,self.user,self.pwd,self.dbname)
-
-
- cur = self.db.cursor()
-
-
- return cur
-
-
- def queryOperation(self,sql):
-
-
- cur = self.getCursor()
-
-
- cur.execute(sql)
-
-
- row = cur.rowcount
-
-
-
-
- dataList = cur.fetchall()
-
-
- cur.close()
-
-
- self.db.close()
-
-
- return dataList,row
-
-
- def deleteOperation(self,sql):
-
-
- cur = self.getCursor()
- try:
-
- cur.execute(sql)
-
-
- self.db.commit()
-
- except Exception as e:
- print(e)
-
-
- self.db.rollback()
-
-
- cur.close()
-
-
- self.db.close()
-
-
- def updateOperation(self,sql):
- cur = self.getCursor()
- try:
- cur.execute(sql)
- self.db.commit()
- except Exception as e:
- print(e)
- self.db.rollback()
-
- cur.close()
- self.db.close()
-
-
- def insertOperation(self,sql):
-
- cur = self.getCursor()
- try:
- cur.execute(sql)
- self.db.commit()
- except Exception as e:
- print(e)
- self.db.rollback()
-
- cur.close()
- self.db.close()
-
相关阅读:
Android配置----adb工具的使用
Android配置----小米手机通过wifi连接ADB调试Android应用
Java语法基础(二)----运算符
Java语法基础(一)----关键字、标识符、常量、变量
Java学习----Java概述
nginx配置upstream实现负载均衡
docker挂载本地目录和数据卷容器
sublime text 3 配置优化
sql update set使用case when语句
mysql表复制create table like和create table as比较
-
原文地址:https://www.cnblogs.com/meng-wei-zhi/p/8214745.html
Copyright © 2020-2023
润新知