Python 操作DB数据库

#!/usr/bin/env python# coding=utf-8import ibm_db# 执行DB2 SQL语句try:conn = ibm_db.connect("DATABASE=testdb;HOSTNAME=10.20.10.9;PORT=50000;PROTOCOL=TCPIP;UID=db2inst1;PWD=123456;", "", "")#...

Chao Hsin-fang

920人浏览 · 2019-09-20 17:44:33

Chao Hsin-fang · 2019-09-20 17:44:33 发布

#!/usr/bin/env python
# coding=utf-8
import ibm_db
# 执行DB2 SQL语句
try:
    conn = ibm_db.connect("DATABASE=testdb;HOSTNAME=10.20.10.9;PORT=50000;PROTOCOL=TCPIP;UID=db2inst1;PWD=123456;", "", "")
    # db2_sql = "SELECT * FROM youtable;"
    # stmt = ibm_db.exec_immediate(conn, db2_sql)
    # print "Number of affected rows: ", ibm_db.num_rows(stmt)
    # ibm_db.close(conn)
    sql = "SELECT * FROM YOUTABLE"
    stmt = ibm_db.exec_immediate(conn, sql)
    dictionary = ibm_db.fetch_both(stmt)
    while dictionary is not False:
        print "The ID is : ", dictionary["ID"]
        print "The USERNAME is : ", dictionary["USERNAME"]
        dictionary = ibm_db.fetch_both(stmt)
except Exception as e:
    print("connect failed%s" % str(e))