You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.
"""
代码功能：数据库链接与交互
"""
import pymysql
import hashlib
import Config as C
global conn
conn = None
# 01获取数据库连接
def conn_mysql ( ) :
conn = None
try :
conn = pymysql . connect ( host = C . DB_HOST , port = 3306 , user = C . DB_USER , password = C . DB_PASSWORD , db = C . DB_NAME ,
charset = ' utf8 ' )
except Exception as e :
print ( e )
return conn
# 02根据SQL语句操作数据库
def sql_execute ( sql ) :
global conn
if conn is None :
conn = conn_mysql ( )
cur = conn . cursor ( )
cur . execute ( sql )
result = cur . fetchall ( )
cur . close ( )
return result
# 03获取MD5加密结果
def md5 ( text ) :
text = bytes ( text , encoding = ' utf-8 ' )
return hashlib . md5 ( text ) . hexdigest ( )
if __name__ == " __main__ " :
str_md5 = md5 ( " 123456 " )
print ( ' MD5加密后为 ： ' + str_md5 )
