使用 jython 操作 Oracle
安裝與設定：
- 下載 jython 後，修改 jython.bat 或 jython.sh：
- 指定 Oracle JDBC 程式庫 CLASSPATH：
- set CLASSPATH="C:\oraclexe\app\oracle\product\11.2.0\server\jdbc\lib\ojdbc6.jar"
- 指定 Oracle JDBC 程式庫 CLASSPATH：
- 執行：jython [查詢 新增 刪除]
- Oracle 資料庫安排：
- 建立一個用戶或是使用預設 HR 帳號。
- 執行 OraTable.sql 建立表格。
- 建立預儲程式。
查詢資料程式列表：
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 doQuery(OraConnection): myOraStatement = OraConnection.createStatement() myOraResultSet = myOraStatement.executeQuery("SELECT * FROM DEPT ORDER BY DEPTNO") while (myOraResultSet.next()): print myOraResultSet.getInt(1), '\t', \ myOraResultSet.getString(2).encode("iso-8859-8"), '\t', \ myOraResultSet.getString(3).encode("iso-8859-8") myOraStatement.close() def doQuery2(OraConnection): myOraStatement = OraConnection.createStatement() myOraResultSet = myOraStatement.executeQuery("SELECT * FROM EMP ORDER BY EMPNO") while (myOraResultSet.next()): print myOraResultSet.getInt(1), '\t', \ myOraResultSet.getString(2).encode("iso-8859-8"), '\t', \ myOraResultSet.getString(3).encode("iso-8859-8"), '\t', \ myOraResultSet.getInt(4), '\t', \ myOraResultSet.getDate(5), '\t', \ myOraResultSet.getFloat(6), '\t', \ myOraResultSet.getFloat(7), '\t', \ myOraResultSet.getInt(8) myOraStatement.close() if __name__ == "__main__": myOraUID = 'Emprogria' myOraPWD = '470112' myOraSID = 'XE' myOraHost = 'localhost' myOraPort = '1521' myOraConnection = OraConnect(myOraUID, myOraPWD, myOraSID, myOraHost, myOraPort) doQuery(myOraConnection) doQuery2(myOraConnection) myOraConnection.close()