Advertisement

Python simple MySQL tool class, a PooledDB case study.

阅读量:

Python 3.7环境配置

第三方库安装流程

执行以下命令以完成相关库的安装:
pip install pymysql
pip install DBUtils

功能实现:建立mysql连接池,实现增删查改

复制代码
 import pymysql

    
 import time
    
 from DBUtils.PooledDB import PooledDB
    
  
    
  
    
 class MysqldbHelper(object):  # 继承object类所有方法
    
     def __init__(self, config):
    
     self.host = config['host']
    
     self.username = config['user']
    
     self.password = config['passwd']
    
     self.db = config['db']
    
     self.port = config['port']
    
     while True:
    
         try:
    
             self.pool = PooledDB(pymysql, 5, 

全部评论 (0)

还没有任何评论哟~