jython 新增 Oracle 資料

新增資料程式列表：

from oracle.jdbc.driver import OracleDriver from java.sql import DriverManager def OraConnect(OraUID, OraPWD, OraSID, OraHost, OraPort): myOraDriver = OracleDriver() DriverManager.registerDriver(myOraDriver) myOraConnectionURL = "jdbc:oracle:thin:@%s:%s:%s" % (OraHost, OraPort, OraSID) myOraConnection = DriverManager.getConnection(myOraConnectionURL, OraUID, OraPWD) return myOraConnection def doUpdate(OraConnection): myOraStatement = OraConnection.createStatement() for DEPTNO in (90, 91, 92, 93, 94, 95): mySQL = "INSERT INTO DEPT (DEPTNO, DNAME, LOC) VALUES(" + str(DEPTNO) + ", TO_CHAR(LOCALTIMESTAMP, 'MMDDHHMISS'), TO_CHAR(LOCALTIMESTAMP, 'MMDDHHMISS'))" try: myOraResultSet = myOraStatement.execute(mySQL) print mySQL except: pass myOraStatement.close() if __name__ == "__main__": myOraUID = 'Emprogria' myOraPWD = '470112' myOraSID = 'XE' myOraHost = 'localhost' myOraPort = '1521' myOraConnection = OraConnect(myOraUID, myOraPWD, myOraSID, myOraHost, myOraPort) doUpdate(myOraConnection)

myOraConnection.close()