Python - 连接数据库

最新推荐文章于 2022-09-29 16:41:20 发布

weixin_39729846

最新推荐文章于 2022-09-29 16:41:20 发布

阅读量228

点赞数 1

分类专栏： Python

本文链接：https://blog.csdn.net/weixin_39729846/article/details/83029201

版权

Python 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

配置文件：showjoy.conf

[mysql]
#开发环境
product_conn_str=192.168.0.223:3306:product
sc_conn_str=192.168.0.223:3306:sc
trade_conn_str=192.168.0.151:3306:trade
user_conn_str=192.168.0.151:3306:user
#shop_conn_str=192.168.0.151:3306:shop
act_conn_str=192.168.0.151:3306:act
shop_conn_str=192.168.0.223:3306:shop
db_user=qingzhi
db_password=qingzhi@0326

代码：

import sys
reload(sys)
sys.setdefaultencoding("utf-8")
import MySQLdb as mdb
import ConfigParser
import re
import xlwt

class tools_module(object):

    """
      读取配置文件,以conf结尾
    """
    @staticmethod
    def read_configuration_file():
        cp = ConfigParser.SafeConfigParser()
        cp.read('showjoy.conf')
        return  cp


    """
      获取jdbc链接
    """
    @staticmethod
    def get_db_conn(conn_str):
        cp = tools_module.read_configuration_file();
        conn_str = cp.get('mysql',conn_str)
        db_user = cp.get('mysql','db_user')
        db_password = cp.get('mysql','db_password')
        tmp_str = re.split(' +', conn_str)[0]
        tmp_arr = re.split(':', tmp_str)
        db_host = tmp_arr[0]
        db_port = int(tmp_arr[1])
        db_name = tmp_arr[2]
        conn = mdb.connect(host=db_host, user=db_user, passwd=db_password, db=db_name,charset='utf8')
        return conn


if __name__ == '__main__':
    tools_module.func()

    sql_str = '''
             SELECT sca.id, sca.shop_id, sca.month, sca.allowance, sca.status, sca.commission_id
             from shop.shop_conscientious_allowance sca
             where sca.is_delete = 0
             and sca.shop_id = 20115
             and sca.month = 201807
           '''
    #sql_str = sql_str.replace('${shopId}', '4459')
    #sql_str = sql_str.replace('${month}', '201808')

    conn = tools_module.get_db_conn('shop_conn_str')

    cursor = conn.cursor()
    cursor.execute(sql_str)
    result = cursor.fetchall()
    print(result)