oracle: python test_python_cx_Oracle.py
renxp renxp 172.17.18.164:1521/orcl
#!/usr/bin/python
# Copyright Platform Computing Inc., an IBM company, 2012
import sys
import string
import os
import time
import cx_Oracle as oraledb
# -----------------------------------------
# utility functions
# -----------------------------------------
class ISFDB:
"""
A class for handling the ISF database connection.
"""
def __init__(self, user=None, passwd=None, url=None):
"""
Init
"""
self.dbuser = user
self.dbpasswd = passwd
self.dburl = url
self.__dbconn = None
if self.dbuser:
return
def connect(self, exit=True):
""" Connect to ISF database
"""
try:
self.__dbconn = oraledb.connect(self.dbuser, self.dbpasswd, self.dburl)
except Exception, e:
print "Failed to connect to ISF database %s" %self.dburl
print e
if exit:
sys.exit(1)
else:
return None
else:
#no exception occurred - obtain cursor
return self.__dbconn
def isconnected(self):
if self.__dbconn == None:
return False
else:
return True
def disconnect(self):
"""
Disconnect from the database
"""
if not self.isconnected():
return
self.__dbconn.close()
self.__dbconn = None
def checkConnection():
isf_dbuser = sys.argv[1]
isf_dbpasswd = sys.argv[2]
isf_dburl = sys.argv[3]
# Connect to the database
database = ISFDB(isf_dbuser, isf_dbpasswd, isf_dburl)
database.connect()
database.disconnect()
return
if __name__ == "__main__":
checkConnection()
sys.exit(0)
MySQL:python
test_python_MySQL.py 172.17.27.242 3306 root
111111 test
#!/usr/bin/python
# Copyright Platform Computing Inc., an IBM company, 2012
import sys
import string
import os
import time
import MySQLdb as mysqldb
# -----------------------------------------
# utility functions
# -----------------------------------------
class ISFDB:
"""
A class for handling the ISF database connection.
"""
def __init__(self, host=None,port=None,user=None, passwd=None, dbname=None):
"""
Init
"""
self.dbhost = host
self.dbport = port
self.dbuser = user
self.dbpasswd = passwd
self.dbname = dbname
self.__dbconn = None
if self.dbuser:
return
def connect(self, exit=True):
""" Connect to ISF database
"""
try:
self.__dbconn = mysqldb.connect(host='%s' %self.dbhost, port=string.atoi(self.dbport),user='%s' %self.dbuser,\
passwd='%s' %self.dbpasswd, db='%s' %self.dbname)
except Exception, e:
print "Failed to connect to ISF database %s" %self.dbhost
print e
if exit:
sys.exit(1)
else:
return None
else:
#no exception occurred - obtain cursor
return self.__dbconn
def isconnected(self):
if self.__dbconn == None:
return False
else:
return True
def disconnect(self):
"""
Disconnect from the database
"""
if not self.isconnected():
return
self.__dbconn.close()
self.__dbconn = None
def checkConnection():
isf_dbhost = sys.argv[1]
isf_dbport = sys.argv[2]
isf_dbuser = sys.argv[3]
isf_dbpasswd = sys.argv[4]
isf_dbname = sys.argv[5]
# Connect to the database
database = ISFDB(isf_dbhost, isf_dbport, isf_dbuser,isf_dbpasswd,isf_dbname)
database.connect()
database.disconnect()
return
if __name__ == "__main__":
checkConnection()
sys.exit(0)
分享到:
相关推荐
本文实例讲述了Python操作Oracle数据库的简单方法和封装类。分享给大家供大家参考,具体如下: 最近工作有接触到Oracle,发现很多地方用Python脚本去做的话,应该会方便很多,所以就想先学习下Python操作Oracle的...
python-oracledb的源码和使用示例代码, python-oracledb 1.0,适用于Python versions 3.6 through 3.10. Oracle Database; This directory contains samples for python-oracledb. 1. The schemas and SQL ...
Python实现两个Oracle数据库同步工作
python 实现Oracle /Mysql ETl 导入greenplum 数据库。
python2.7连接oracle的代码,已经完成好编写的工具类,可以直接拿来使用
数据库 Mysql转oracle sql脚本转oracle脚本
python 操作数据库 mysql oracle cx_oracle to_sql 操作数据库 读取 插入 更新
学生信息管理系统(python+GUI+mysql).zip,学生信息管理系统(python+GUI+mysql).zip,学生信息管理系统(python+GUI+mysql).zip 学生信息管理系统(python+GUI+mysql).zip,学生信息管理系统(python+GUI+mysql).zip,...
这是python操作oracle需要安装的一个插件,执行rpm -ivh cx_Oracle-5.2.1-11g-py26-1.x86_64.rpm进行安装
python+django+mysql电影推荐系统源码,毕业设计 python+django+mysql电影推荐系统源码,毕业设计 python+django+mysql电影推荐系统源码,毕业设计 python+django+mysql电影推荐系统源码,毕业设计 python+...
摘 要: 讲解了应用 Python 如何访问 MySQL 数据库。首先介绍了 Python、MySQL,然后讲解 MySQL 数据库访问模块,并通过一个实例来说明应用该模块来访问 MySQL 数据库,最后总结了用 Python 访问 MySQL 数据库的优点
python 连接oracle 实现数据查询,解决中文显示乱码问题
Python连接Oracle数据库,最常用的就是cx_Oracle包了,这是一篇cx_Oracle工具的官方文档,里面详细介绍了cx_Oracle的特点安装配置等,有需要的同学可以下载来看
最近用到Python操作数据库,MySql的操作封装类,简单写了一个Mysql封装操作类,分享一下,需要安装pymsql,安装方法:https://blog.csdn.net/sinat_28984567/article/details/105316092
python beautifulsoup Oracle MySQL
通过python脚本连接mysql数据库, 并执行mysql数据库语句,工具类。
python Oracle操作类,操作Oracle数据必备,很简单的!
python 操作oracle 安装oracle依赖。Oracle客户端安装的炕,文档有下载地址版本是 11_2 不过高版本意思都一样
使用Python连接和操作MySQL数据库工具包-PyMySQL (1)安装Python (2)安装MySQL (3)安装PyMySQL (4)创建连接 (5)Python代码操作数据库 1. 引入模块MySQLdb:import MySQLdb 2. 连接到数据库和建立游标:...