python db2数据库操作_python操作DB2数据库

#!/usr/bin/env python

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

import ibm_db

try:

conn = ibm_db.connect("DATABASE=service;HOSTNAME=8.8.8.8;PORT=50000;PROTOCOL=TCPIP;\

UID=myname;PWD=mypassw", "", "")

except:

print("connect failed,%s" % ibm_db.conn_errormsg())

else:

sql = "SELECT * FROM tableName "

try:

stmt = ibm_db.exec_immediate(conn, sql)

dictionary = ibm_db.fetch_both(stmt)

while dictionary!=False:

for i in range(0, 15):

if i in (10, 12):

print(dictionary.get(i).strftime('%Y-%m-%d %H:%M:%S')),

else:

print(dictionary.get(i)),

print("\n")

dictionary = ibm_db.fetch_both(stmt)

except:

print("stmt failed,%s" % ibm_db.stmt_errormsg())

finally:

if ibm_db.active(conn):

ibm_db.close(conn)

print("database close success!")