import sys from com.ibm.as400.access import * from com.ziclix.python.sql import zxJDBC from com.ziclix.python.sql import PyConnection def JDBCSample(f): try: as400 = AS400() datasource = AS400JDBCDataSource(as400) connection = datasource.getConnection() con = PyConnection(connection) except zxJDBC.DatabaseError, e: print "¥Ç¡¼¥¿¥Ù¡¼¥¹¤ËÀܳ¤Ç¤¤Þ¤»¤ó¤Ç¤·¤¿" print "¸¶°ø¡§" + e[0] sys.exit(1) cur = con.cursor() sql =""" SELECT FILENAME,FILESIZE FROM PRIMULA.HOGE WHERE FILENAME = ? """ cur.execute(sql,(f,)) rset = cur.fetchall() if cur.rowcount > 0: print "%d¹Ô¤Î¥Ç¡¼¥¿¤¬ ¸«¤Ä¤«¤ê¤Þ¤·¤¿¡£" % cur.rowcount for e in rset: print "%s %s" % e print "ok." else: print "³ºÅö¥Ç¡¼¥¿¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£" print "sad." cur.close() con.close() if __name__ == '__main__': JDBCSample(sys.argv[1])
¤³¤Î¥Ú¡¼¥¸¤Ø¤Î¥³¥á¥ó¥È
3IsQRn I truly appreciate this article post.Much thanks again. Really Great.
tWB3GG Muchos Gracias for your article.Much thanks again. Keep writing.