python-mysqldemo

python连接MySQL数据库

'''
python连接mysqldemo

1.获取数据库
2.获取记录
3.增加记录
4.修改记录
5.删除记录
6............
'''

__author__ = 'xiaolong'
import pymysql

class MysqlDemo(object):
    # 设置数据库连接参数，默认编码类型为utf-8，参数为字符串
    def __init__(self,host,username,password,dbname):
        self.conn = pymysql.connect(host,username,password,dbname,charset='utf8')
        self.cursor = self.conn.cursor()

    # 更新数据
    def update(self,tablename,data,restrication_str):
        data_str = ''
        for item in data.items():
            data_str += '{}={},'.format(item[0],item[1])
        values = data_str[:-1]
        sql = 'update {} set {} where {}'.format(tablename,values,restrication_str)
        print(sql)
        try:
            self.cursor.execute(sql)
            self.conn.commit(<