Python3 连接mysql

最新推荐文章于 2022-07-08 10:05:52 发布

Talent_C_

最新推荐文章于 2022-07-08 10:05:52 发布

阅读量156

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/Talent_C_/article/details/83182928

版权

python 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

本文介绍了如何在Python3环境中使用PyCharm设置项目解释器并安装pymysql库，以便连接到MySQL数据库。通过一个简单的查询information_schema数据库的例子进行演示。

摘要由CSDN通过智能技术生成

在python3.x中连接mysql数据库要先安装一下pymysql：

在pycharm中 File->Settings->Project->Project Interpreter

简单测试了一下查询mysql自带的 information_schema数据库

# !/usr/bin/python3
# -*- coding:utf-8 -*-
# @author:TalentC
# @Time:2018/10/19

import pymysql.cursors

class mysql(object):
    def __init__(self,dbinfo):
        try:
            # connect to database
            self.connect = pymysql.Connect(
                host=dbinfo['host'],
                port=dbinfo['port'],
                user=dbinfo['user'],
                passwd=dbinfo['passwd'],
                db=dbinfo['db'],
                charset=dbinfo['charset']
            )
            self.cursor = self.connect.cursor()
        except Exception as e:
            print(e)

    def __del__(self):
        self.cursor.close()
        self.connect.close()

    def select(self,sql):
        self.cursor.execute(sql)
        return self.cursor.fetchall()

    def insert(self,sql):
        try:
            self.cursor.execute(sql)
            self.connect.commit()
            return self.cursor.rowcount
        except Exception as e:
            return e

    def update(self,sql):
        try:
            self.cursor(sql)
            self.connect.commit()
            return self.cursor.rowcount
        except Exception as e:
            return e

    def delete(self,sql):
        try:
            self.cursor(sql)
            self.connect.commit()
            return self.cursor.rowcount
        except Exception as e:
            return e

    def rollback(self):
        self.connect.rollback()


if __name__ == '__main__':
    dbinfo = {'host': '192.168.28.212',
              'port': 3306,
              'user': 'root',
              'passwd': 'fa',
              'db': 'information_schema',
              'charset': 'utf8'
              }

    db = mysql(dbinfo)
    sql = 'select * from CHARACTER_SETS'
    res = db.select(sql)
    for row in res:
        print(row)

输出结果：