java調用腳本語言筆記（jython,jruby,groovy）

有兩種方法

1.java se 6以後實作了jsr 223規範

用

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 OracleDriver
from java.sql import DriverManager

username = '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 zxJDBC

url = '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:

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

 通路資料庫

require 'java'

module JavaLang
  include_package "java.lang"
end

module JavaSql
  include_package 'java.sql'
end

begin
 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:

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

 使用GroovyShell:

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

 通路資料庫

import groovy.sql.Sql

def 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運作時處理的内容)