如何使用python将以下信息入库

Python015

如何使用python将以下信息入库,第1张

如何用python实现 注意：密码中会出现双引号、单引号和逗号

Python code

#!/usr/bin/env python sfile = ( '{ "_id" : ObjectId( "4ad9469045343000008" ), "passwd" : "passwd1", "mail" : "", "id" : "", "src" : "weibo" }', '{ "_id" : ObjectId( "4ad9469045343000009" ), "passwd" : "passwd2", "mail" : "", "id" : "", "src" : "weibo" }', ) import re pat = re.compile('{ "_id" : ObjectId\( (.*) \), "passwd" : (.*), "mail" : (.*), "id" : (.*), "src" : (.*) }')for line in sfile: rs = pat

python 数据库第三方库 都有批量插入数据的方法 例如oracle

        for val in jsonVal:

            #print val["serverid"]

            #print val["server_name"]

            param.append((val["serverid"], "san_s" + val["serverid"], val["server_name"]))

            # cursor.execute('insert into game_server_name(server_id, server_name, chinese_name) values(:server_id, :2, :3)',(val["serverid"], "san_s" + val["serverid"], val["server_name"]))

            # cursor.execute("insert into game_server_name(server_id, server_name, chinese_name) values('a','b','c')")

        print param

        print len(param)

        cursor.prepare('insert into game_server_name(server_id, server_name, chinese_name) values(:1, :2, :3)') # 一次插入全部数据

        cursor.executemany(None, param)

就是准备好插入语句 和要插入的数据数组 然后执行 cursor.executemany(None, param)

MYSQL 数据库 也是一样的道理