java呼叫指令碼語言筆記（jython,jruby,groovy）

 有兩種方法
1.java se 6以後實現了jsr 223規範
java代碼：

ScriptEngineManager factory = new ScriptEngineManager();ScriptEngineManager scriptEngine = factory.getEngineByName("javascript");//或者"js"scriptEngine.eval(code);//執行一段指令碼，code是js代碼

 很方便呼叫指令碼

2.可以使用指令碼語方本身提供的與java的整合手段

jython整合
使用jsr223:
前提下載jython的包，已實現jsr223
(建議在官網上下載，在安裝目錄下有jython.jar，http://repo2.maven.org/maven2/org/python/jython/2.5.0/ 這裡也有，但是這個包裡沒有jsr223的實現，看包下存不存在org.python.jsr223)

ScriptEngineManager factory = new ScriptEngineManager();ScriptEngineManager scriptEngine = factory.getEngineByName("python");//或者"jython"scriptEngine.eval(code);

使用PythonInterpreter，可以調用exec(String code)方法:

PythonInterpreter interpreter = new PythonInterpreter();interpreter.exec(code);

訪問資料庫
使用jdbc:

from oracle.jdbc.driver import OracleDriverfrom java.sql import DriverManagerusername = 'hr'password = '123456'url = 'jdbc:oracle:thin:@localhost:1521:XE'driver = OracleDriver()DriverManager.registerDriver(driver)conn = DriverManager.getConnection(url, username, password)stmt = conn.createStatement()sql = "select salary from EMPLOYEES t where t.salary<2300"rs = stmt.executeQuery(sql)while (rs.next()): print rs.getInt('salary')rs.close()stmt.close()

 結果:
2200
2100
2200

使用zxJDBC :

from com.ziclix.python.sql import zxJDBCurl = 'jdbc:oracle:thin:@localhost:1521:XE'username = 'hr'password = '123456'driverName = 'oracle.jdbc.driver.OracleDriver'mysqlConn = zxJDBC.connect(url,username, password,driverName)cursor = mysqlConn.cursor()     cursor.execute("select last_name from EMPLOYEES t where t.salary<2300");#print cursor.fetchone()list = cursor.fetchall()for record in list:    print "name:"+record[0]#print cursor.description[0]#print cursor.description[1]

 結果:
name:麥克
name:Olson
name:Philtanker

從資料庫中查出的中文內容正常的。
而在代碼裡面的中文全部是亂碼或拋異常，未解決。

與jruby整合
使用jsr223:Java代碼

ScriptEngineManager factory = new ScriptEngineManager();ScriptEngineManager scriptEngine = factory.getEngineByName("jruby");//或者"ruby"scriptEngine.eval(code);

 訪問資料庫

Ruby代碼

require 'java'module JavaLang  include_package "java.lang"endmodule JavaSql  include_package 'java.sql'endbegin username = 'hr' password = '123456' url = 'jdbc:oracle:thin:@localhost:1521:XE' driverName = 'oracle.jdbc.driver.OracleDriver' JavaLang::Class.forName(driverName).newInstance conn = JavaSql::DriverManager.getConnection(url, username, password) stmt = conn.createStatement sql = "select last_name from EMPLOYEES t where t.salary<2300" rs = stmt.executeQuery(sql) while (rs.next) do  puts "名字:"+rs.getString("last_name") end rs.close stmt.close conn.close()rescue JavaLang::ClassNotFoundException puts "ClassNotFoundException"rescue JavaSql::SQLException puts "SQLException"end

 

 結果:
名字:楹﹀厠
名字:Olson
名字:Philtanker

 

從資料庫中查出的中文內容為亂碼的。
而在代碼裡面的中文正常。

 

與groovy整合
使用jsr223:

Java代碼

ScriptEngineManager factory = new ScriptEngineManager();ScriptEngineManager scriptEngine = factory.getEngineByName("groovy");//或者"Groovy"scriptEngine.eval(code);

 使用GroovyShell:

Java代碼

GroovyShell shell = new GroovyShell();Script script = shell.parse(code);Object result = script.run();

訪問資料庫

Groovy代碼

 

import groovy.sql.Sqldef username = 'hr'def password = '123456'def url = 'jdbc:oracle:thin:@localhost:1521:XE'def driverName = 'oracle.jdbc.driver.OracleDriver'def sql = Sql.newInstance(url, username, password, driverName)sql.eachRow("select last_name from EMPLOYEES t where t.salary<2300") { println "名字：${it.last_name}"}

結果:
名字：麥克
名字：Olson
名字：Philtanker

 

在使用groovy過程中碰到了一個異常
Exception in thread "main" java.lang.VerifyError: (class: groovy/runtime/metaclass/java/util/ArrayListMetaClass, method: super$2$invokeMethod signature: (Ljava/lang/Class;Ljava/lang/Object;Ljava/lang/String;[Ljava/lang/Object;ZZ)Ljava/lang/Object;) Illegal use of nonvirtual function call
這個異常解決花了很長時間
是因為在原來項目中存在json-lib-2.1.jar(有可能名稱為json-lib-2.1-jdk15.jar)，這個包是用來處理json的，與groovy1.7.5存在衝突,更新為json-lib-2.3.jar即可
(json-lib裡有一些groovy運行時處理的內容)

 

轉自：http://yinxvxv.iteye.com/blog/811328  上面還有包 很不錯