python 连接 oracle及mysql

python 连接oracle

# coding:utf-8 

from sqlalchemy import create_engine 
import os 

os.environ['NLS_LANG']= '.AL32UTF8' 
#数据库连接 
db = create_engine('oracle://username:password@ip_address:port/databasename') 
conn = db.raw_connection() 
cursor = conn.cursor() 

sql = """ sql 语句 """ 

result = cursor.execute(sql) 
conn.commit() 
cursor.close() 

python 连接mysql

# code=utf-8

import pymysql
mydb = pymysql.connect(host="localhost",    
                       user='root',
                       password='password',
                       db="import_data",
                      )
cursor = mydb.cursor()    
sql = "select * from bianjing"    
cursor.execute(sql)    
datas = cursor.fetchall()    
for data in datas:
    print(data)