【python+mysql】pymysql第三方库用法示例

python操作数据库，代码示例

import pymysql

def runjblmysql(jblsql):
    #链接mysql服务器
    conn=pymysql.connect(host="127.0.0.1",
                         port=3306,
                         user="test",
                         password="test",
                         database="myStudyDemo1",
                         charset="utf8")
    cursor = conn.cursor(pymysql.cursors.DictCursor)
    #执行mysql脚本
    try:
        cursor.execute(jblsql)
        data=cursor.fetchall()
        conn.commit()
        return data
    except Exception as e:
        print(e)
    cursor.close()
    conn.close()

if __name__ == '__main__':
    jblsql="select * from `account`; "
    '''
    INSERT INTO `account` (`id`, `account`, `password`, `accounttype`, `comment`) VALUES (1, 'zhangsan', '123456', 1, '');
    '''
    result=runjblmysql(jblsql)
    print(result)