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 doDelete(OraConnection): myOraStatement = OraConnection.createStatement() for DEPTNO in (90, 91, 92, 93, 94, 95): mySQL = 'DELETE FROM EMP WHERE DEPTNO=' + str(DEPTNO) myOraResultSet = myOraStatement.execute(mySQL) mySQL = 'DELETE FROM DEPT WHERE DEPTNO=' + str(DEPTNO) myOraResultSet = myOraStatement.execute(mySQL) print DEPTNO myOraStatement.close() if __name__ == "__main__": myOraUID = 'Emprogria' myOraPWD = '470112' myOraSID = 'XE' myOraHost = 'localhost' myOraPort = '1521' myOraConnection = OraConnect(myOraUID, myOraPWD, myOraSID, myOraHost, myOraPort) doDelete(myOraConnection)

myOraConnection.close()