Python爬取政府采购网数据到oracle

运行环境：

python3.7

实现过程：

1、导入模块 

# -*- coding: utf-8 -*-
# 配置chromedriver，参考：https://www.cnblogs.com/heguihui/p/10535526.html
import time
# import pymysql
# import xlrd
# import xlutils.copy
from selenium import webdriver
from selenium.webdriver.chrome.options import Options
from multiprocessing.dummy import Pool as ThreadPool
from selenium.common.exceptions import NoSuchElementException
import cx_Oracle

2、连接oracle数据库

# 连接oracle数据库
def connectDB():
    host = "localhost"
    port = "1521"
    sid = "orcl"
    dsn = cx_Oracle.makedsn(host, port, sid)
    # 此处添加charset='utf8'是为了在数据库中显示中文，此编码必须与数据库的编码一致
    db = cx_Oracle.connect("js", "1", dsn)
    return db
    cursorDB = db.cursor(