mysql访问oracle数据_python访问Oracle及Mysql数据库

# !/usr/local/python

# -*- coding: utf-8 -*-

import cx_Oracle

import pymysql

# --------oracle链接数据库----------------------------

student1 = {'id': 1011,

'name': 7,

'age': 18}

conn = cx_Oracle.connect('czth_sales/123456@127.0.0.1:1521/ORCL')

sql1 = 'select * from student where id=%s' % (student1['id'])

cur = conn.cursor()

cur.execute(sql1)

result = cur.fetchall()

print('oracle查询：', result)

sql = 'insert into student values(%s,%s,%s)' % (student1['id'], student1['name'], student1['age'])

cur.execute(sql)

conn.commit()

# --------mysql链接数据库----------------------------

# conn = pymysql.connect(host ="134.175.103.124",port =3306,user= "wapn", p