python连接oracle指南

背景

经常需要连接数据库，统计数据并导出成excel

安装

在pypi上找到合适的module包，windows 64位,python3.7.6版本，需下载cx_Oracle-7.3.0-cp37-cp37m-win_amd64.whl，执行’pip install cx_Oracle-7.3.0-cp37-cp37m-win_amd64.whl’ 安装module

脚本

import cx_Oracle


def connectOracle():
	db_ip = '192.168.0.110'
	service_name = 'newmbdb'
	user_name = 'query'
	password = 'query'
	conn=cx_Oracle.connect(user_name+"/"+password+"@//"+db_ip+":1521/"+service_name)
	return conn

def query_max_period(conn):
	max_period = '20200110'
	db_cursor = conn.cursor()
	sql_cmd = 'SELECT max(statistics_period) FROM log_statistics'
	db_cursor.execute(sql_cmd)
	result = db_cursor.fetchone()
	if result:
		if result[0] >= 0:
			max_period = result[0]
    db_cursor.close()
	print("max_period :" + str(max_period))
	return max_period


if __name__ == "__main__":
	conn = connectOracle()
	max_period = query_max_period(conn)
	conn.close()