python学习需要mysql_python学习之操作mysql

'''class ConnDB:

def __init__(self,host,user,passwd,db):

self.host=host

self.user=user

self.passwd=passwd

self.db=db

self.conn = None

self.cursor = None

def connect(self, cursor=pymysql.cursors.DictCursor):

self.conn = pymysql.connect(host=self.host,user=self.user,passwd=self.passwd,db=self.db)

self.cursor = self.conn.cursor(cursor=cursor)

return self.cursor

def close(self):

self.conn.commit()

self.cursor.close()

self.conn.close()

obj=ConnDB('x.x.x.x','root','xx','xx')

cursor=obj.connect()

cursor.execute("SELECT * FROM user_info WHERE username=%s",('root',))

row_1 = cursor.fetchone()

print(row_1)

cursor.close()'''

#定义数据库信息字典

my_dic ={"host": 'x.x.x.x,

"port": 3306,"user": 'root',"passwd": 'xxx',"db": 'xxx',"charset": 'utf8'}#以字典的方式传入数据库登录相关信息

classConnDB:def __init__(self,dic):

self.__conn_dict =dic

self.conn=None

self.cursor=Nonedef connect(self, cursor=pymysql.cursors.DictCursor):

self.conn= pymysql.connect(**self.__conn_dict)

self.cursor= self.conn.cursor(cursor=cursor)returnself.cursordefclose(self):

self.conn.commit()

self.cursor.close()

self.conn.close()

obj=ConnDB(my_dic)

cursor=obj.connect()

cursor.execute("SELECT * FROM user_info WHERE username=%s",('root',))

row_1=cursor.fetchone()print(row_1)

cursor.close()