# coding=utf-8   ''''' Created on 2015-01-14  @author: '''import json;import urllib2import sysimport cx_Oracleimport exceptions# page=urllib2.urlopen("http://").read()  # jsonVal = json.loads(page)   def read_json_file(file_name):    file_object = open(file_name)    db = cx_Oracle.connect('用户名', '密码', 'ip:1521/oracle的serve_name')    cursor = db.cursor()    '''    rows = cursor.execute('select * from table')    for sz in rows:        print sz    '''    try:        all_the_text = file_object.read()        jsonVal = json.loads(all_the_text)        param = []        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)        db.commit()    except Exception, err:        print err    finally:        cursor.close()                db.close()        file_object.close()def main():    read_json_file('E:/android.json')    read_json_file('E:/apple.json')if __name__ == '__main__':    main()

 

当只有一次参数的时候，也要把它写成元组的形式，比如 Cursor.execute(‘select name from user where id=:1’,(login_Id,)) 千万要注意，login_id后面还带有一个逗号