python连接几种数据库方法

1、连接oracle数据库：

#encoding:utf-8
from sqlalchemy.ext.sqlsoup import SqlSoup
from sqlalchemy import create_engine
"""连接数据库"""
db_data = create_engine('oracle://username:[e-mail]:1521/logpub',pool_recycle=60)
db = SqlSoup(db_data)

"""查询数据"""
sql = "select t.user_name,t.channel_name,t.channel_id,t.local_path from PUB_URL t where t.content_date = to_date('2015-02-26','yyyy-mm-dd') and t.local_path like '%%/data/Data%%'"
channels_massage = db.connection().execute(sql).fetchall()
db.session.close()

2、连接mysql数据库：

import MySQLdb

conn_athena = MySQLdb.connect(host="192.168.xx.xx",user='xxx',passwd='xxxx',db='xxx')
cursor_athena = conn_athena.cursor()
sql = "update hadoop_jobs t set t.status = 0"
cursor_athena.execute(sql)
cursor_athena.commit()
cursor_athena.close()
conn_athena.close()

3、连接redis数据库：

import redis

r = redis.Redis(host=ip, port=port, password=pwd, db=db)
keys = r.keys()
print keys

仅用于个人总结，仅供参考！