* 1、下载安装cx_Oracle https://pypi.org/project/cx-Oracle/#files

* 2、下载instantclient，配置环境变量。 https://www.oracle.com/technetwork/cn/topics/winx64soft-101515-zhs.html

* 3、 把instantclient文件夹下所有的ddl文件复制到anaconda文件夹下。（复制oci，oraocci11，oraociei11的3个DLL粘贴到你的PY目录的Libs/site-packages文件夹下面）

* 4、编写测试代码

info = "username/password@ip:/SERVICE_NAME"

db = cx_Oracle.connect(info)

cursor = db.cursor()

# 执行数据库语句

res = cursor.execute("SELECT * FROM T_SH_JDCJBXX WHERE 1=1")

print(res.fetchone())

dsn = cx_Oracle.makedsn(db_host, db_port, db_name)

pool = PooledDB(cx_Oracle, mincached=20, blocking=True, user=db_user, password=db_pass, dsn=dsn)

conn = pool.connection()

with conn.cursor() as cursor:

sql = ""

res = cursor.execute(sql)

scan_result = res.fetchall()

conn.close()

sqlite数据库可以当做缓存来用，如果不想用redis的话，可以考虑用sqlite

import sqlite3

conn = sqlite3.connect('test.db')

cur = conn.cursor()

# 查看数据库中表是否存在

sql = "select * from sqlite_master where type = 'table' and name = 'user'"

cur.execute(sql)

values = cur.fetchall()

if values:

print(values)

else:

# 如果不存在，创建表

cur.execute('create table user (id varchar(20) primary key, name varchar(20))')

cur.execute('insert into user (id, name) values (\'1\', \'Michael\')')

cur.close()

conn.close()