如何使用JRuby和JDBC连接到Oracle

require 'java'
require 'jdbc/ojdbc6.jar'

# 设置数据库连接信息
driver = 'oracle.jdbc.driver.OracleDriver'
url = 'jdbc:oracle:thin:@localhost:1521:orcl'
username = 'your_username'
password = 'your_password'

# 加载驱动程序并建立连接
java.lang.Class.forName(driver)
conn = java.sql.DriverManager.getConnection(url, username, password)

# 创建一个Statement对象
stmt = conn.createStatement()

# 执行查询并显示结果
rs = stmt.executeQuery('SELECT * FROM your_table')
while rs.next()
  puts rs.getString(1)
end

# 关闭连接
rs.close()
stmt.close()
conn.close()

jruby your_script.rb