用python管理MySQL数据库 v2.0

# v2.0 重写了insert方法
from pymysql import *

class DatabaseManagementSystem(object):
    """MySQL数据库管理系统"""

    def __init__(self,data_name):
        # 创建与数据库的连接
        self.conn = connect(host='localhost',port=3306,
                       database=data_name,user='root',password='',
                       charset='utf8')
        # 获得游标对象
        self.csl = self.conn.cursor()

    def insert(self,table_name,colum_name,values):
        # 插入数据
        self.csl.execute('insert into {0} values{1};'.format(table_name,values))
        print(self.csl)

    def update_colum(self,table_name,new_name,old_name):
        # 修改一个列数据
        self.csl.execute('update {0} set name="{1}" where name="{2}";'
                          .format(table_name,new_name,old_name))
        print(self.csl)

    def delete(self,table_name,equation):
        # 删除一行数据
        self.csl.execute('delete from {0} where {1};'.format(table_name,equation))
        print(self.csl)

    def show_all(self,colums,table_name):
        self.csl.execute('select {0} from {1};'.format(colums,table_name))
        for temp in self.csl.fetchall():
            print(temp)

    def commit(self):
        # 提交命令
        self.conn.commit()
        print(self.csl)

    def __del__(self):
        # 关闭游标和连接
        self.csl.close()
        self.conn.close()