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", password="123456", db="czth", charset='utf8')

config = {

'host': '134.175.103.124',

'port': 3306,

'user': 'wapn',

'password': '123456',

'db': 'czth',

'charset': 'utf8',

'cursorclass': pymysql.cursors.DictCursor

}

conn = pymysql.connect(**config)

cursor = conn.cursor()

sql = 'SELECT * FROM th_user_info'

count = cursor.execute(sql)

result = cursor.fetchall()

print('mysql查询:', result)

# 如果没有设置自动提交事务，则这里需要手动提交一次

conn.commit()

# 发生错误时回滚

conn.rollback()

# 关闭游标连接

cursor.close()

# 关闭数据库连接

conn.close()