本文实例讲述了python实现mysql的单引号字符串过滤方法。分享给大家供大家参考,具体如下:
最主要用这个函数,可以处理MySQLdb.escape_string(content).
class Guide: def __init__(self): self.time_zone = 7*3600 #设置时区 self.now_time = int(time.time()) + self.time_zone #取得当前时间 #本地 self.gamedb_model = mysql_conn.MySQLHelper(config.game_db[\'host\'], config.game_db[\'user\'], config.game_db[\'password\'], config.game_db[\'db_name\'], config.game_db[\'port\']) #远程 self.remote_model = mysql_conn.MySQLHelper(config.remote_db[\'host\'], config.remote_db[\'user\'], config.remote_db[\'password\'], config.remote_db[\'db_name\'], config.remote_db[\'port\']) #game center self.commdb_model = mysql_conn.MySQLHelper(config.comm_db[\'host\'], config.comm_db[\'user\'], config.comm_db[\'password\'], config.comm_db[\'db_name\'], config.comm_db[\'port\']) def index(self): #拿到第二天未登陆的用户 for line in open(\"2014.3.20_global_ips.txt\"): list = line.split(\'||\') l = len(list) if l == 3: info = \'\' else: info = MySQLdb.escape_string(list[3]) self.commdb_model.insert(\'ip_area\',{\'start_ip\':list[0],\'end_ip\':list[1],\'area\':list[2],\'info\':info}) if __name__ ==\"__main__\": keep = Guide() keep.index()
希望本文所述对大家python程序设计有所帮助。