import cx_Oracle as cx
'''
windows下使用需要cx_Oracle 安装`Instant Client`
下载 Instant Client官网地址:
http://www.oracle.com/technetwork/topics/winx64soft-089540.html
'''
import pymysql
def connect_oracle():
ip = 'xxx.xxx.xxx.xxx'
port = xxxx
db = 'xxxx'
username = '****'
pwd = '***'
dsn = cx.makedsn(ip, port, db)
con = cx.connect(username, pwd, dsn) # 连接数据库
cursor = con,cursor() # 创建游标
'''
通过游标,可以执行SQL语句,实现与数据库的交互,但是游标使用完之后需要关闭
查询所有表名
select table_name from all_tables
'''
cursor.execute(""select *****)
# data = cursor.fetchall() # 获取一条数据
data = cursor.fetchall() # 获取所有数据
print(data)
cursor.close()
con.close()
def connect_mysql():
ip = 'xxx.xxx.xxx.xxx'
port = xxxx
db = 'xxxx'
username = '****'
pwd = '***'
con = pymysql.connect(host=ip, port=port, user=username, password=pwd, database=db) # 连接数据库
cursor = con,cursor() # 创建游标
sql_str = '''
insert ******
'''#最好使用三引号,以防万一----如果此处使用单引号或者双引号,同时sql语句中如果也存在单引号或者双引号,可能就会报错。
cursor.execute(sql_str)
con.commit()
cursor.close()
con.close()
if __name__ == '__main__':
connect_oracle()
# connect_mysql()
python连接Oracle、Mysql数据库
于 2020-09-12 14:52:42 首次发布