pymysql------escape_string
(pymysql 1.0 版本以上的 导入要使用以下方法)
from pymysql.converters import escape_string
escape_string 方法直接将字符串中的特殊字符,进行转译功能,使用极其方便
案例
conn = pymysql.connect(host='localhost', user='root', password='123456', port=3306,db='test') #连接数据库
cur = conn.cursor()
Str1=”hcsi /’ncjdn \’dscjnc”
Str2=”hcsi /’ncjdn \’ds\\\///cjnc”
src = pymysql.escape_string(Str1)
tgt = pymysql.escape_string(Str2)
insert_sql = f" insert into {tablename} (src_text,tgt_text) values ({src},{tgt}); "
try:
cur.execute(insert_sql)
conn.commit()
conn.close()
print('ok............................')
except Exception as e:
print(e, "insert--------------")
conn.rollback()
conn.close()
return 'erro............'