import pymysql
class mysql_conn(object):
def __init__(self):
self.db = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, database='py10')
self.cursor = self.db.cursor()
def execute_modify_mysql(self,sql):
self.cursor.execute(sql)
self.db.commit()
def __del__(self):
self.cursor.close()
self.db.close()
if __name__ == '__main__':
sql = 'insert into xueqiu_test values(4)'
mc = mysql_conn()
mc.execute_modify_mysql(sql)
sql = 'insert into xueqiu_test values(5)'
mc.execute_modify_mysql(sql)
sql = 'insert into xueqiu_test values(6)'
mc.execute_modify_mysql(sql)
sql = 'insert into xueqiu_test values(7)'
mc.execute_modify_mysql(sql)