Python中操作数据库，将操作封装成类

import pymysql

class  connectSql():

def__init__(self,host=’localhost’,port=3306,db=’mydb’,harset=’utf8’,user=’root’,password=””):

self.host=host

self.port=port

self.db=db

self.charset=charset

self.user=user

self.password=password

  def sqlConnect(self)

self.connect=pymysql.Connect(host=self.host,port=self.port,db=self.db,charset=self.charset,user=self.user,password=self.password,db=self.db)

self.cursor=self.connect.cursor()

  def sqlClose(self)

  self.connect.close()

self.cursor.close()

 

 

 

 

 def add(self,a,b,c):

self.sqlConnect()

sql=”语句1”

self.cursor.execute(sql)

self.connect.commit()

sql_obj=connectSql()

sql_obj.add(“1”,”2”,”3”)