QueryDEPT+EMP.py

程式列表：

from oracle.jdbc.driver import OracleDriver from java.sql import DriverManager from OraLib import * from OraCommon import * class Query: myOraConnection = None myOraCommon = None def __init__(self, OraConnection): self.myOraConnection = OraConnection self.myOraCommon = OraCommon(OraConnection) def doQuery(self): self.myOraCommon.doQueryDEPT() self.myOraCommon.doQueryEMP() if __name__ == "__main__": myOraUID = 'Emprogria' myOraPWD = '470112' myOraSID = 'XE' myOraHost = 'localhost' myOraPort = '1521' myOraLib = OraLib() myOraConnection = myOraLib.OraConnect(myOraUID, myOraPWD, myOraSID, myOraHost, myOraPort) myQuery = Query(myOraConnection) myQuery.doQuery() myOraConnection.close()