本文基於 **Eclipse 3.2.2 / Ruby 1.8.6 / RDT 0.8** 時代環境 (約 2007 年)。現代 Ruby 開發請使用:
Dynamic Languages Toolkit (DLTK) Ruby 插件。以下內容僅供歷史參考、舊專案維護或教學研究之用。





path=C:\eclipse\language


tar -xzf dbi-0.1.1.tar.gz
cd dbi-0.1.1
ruby setup.rb
tar -xzf ruby-oci8-1.0.0-rc1.tar.gz
cd ruby-oci8-1.0.0-rc1
ruby setup.rb
# 以及執行編譯好的二進位
ruby ruby-oci8-1.0.0-rc1-mswin32.rb


require 'dbi'
dbh = DBI.connect('DBI:OCI8:HOST', 'USERNAME', 'PASSWORD')
puts "Connected to Oracle!"
dbh.disconnect
require 'dbi'
dbh = DBI.connect('DBI:OCI8:HOST', 'USERNAME', 'PASSWORD')
dbh.do(<<-SQL)
CREATE TABLE states (
id CHAR(2) PRIMARY KEY,
name VARCHAR2(15) NOT NULL,
capital VARCHAR2(25) NOT NULL
)
SQL
dbh.disconnect
require 'dbi'
dbh = DBI.connect('DBI:OCI8:HOST', 'USERNAME', 'PASSWORD')
sql = "INSERT INTO states (id, name, capital) VALUES (?, ?, ?)"
dbh.do(sql, 'AL', 'Alabama', 'Birmingham')
dbh.do(sql, 'AZ', 'Arizona', 'Phoenix')
dbh.commit
dbh.disconnect
require 'dbi'
dbh = DBI.connect('DBI:OCI8:HOST', 'USERNAME', 'PASSWORD')
sql = "UPDATE states SET capital = ? WHERE id = ?"
dbh.do(sql, 'Montgomery', 'AL')
dbh.do(sql, 'Harrisburg', 'PA')
dbh.commit
dbh.disconnect
require 'dbi'
dbh = DBI.connect('DBI:OCI8:HOST', 'USERNAME', 'PASSWORD')
sth = dbh.prepare('SELECT * FROM states')
sth.execute
while row = sth.fetch do
p row # 輸出陣列 [id, name, capital]
# row[0] = id, row[1] = name, row[2] = capital
end
sth.finish
dbh.disconnect

| 舊技術棧 | 現代替代方案 |
|---|---|
| Ruby 1.8.6 | Ruby 3.2+ (YJIT、效能大幅提升) |
| RDT (Eclipse 插件) | VS Code + Ruby LSP / RubyMine |
| DBI + OCI8 | ruby-oci8 (仍維護) + sequel / activerecord ORM |
| Watir 1.4 | Watir 7+ (Selenium WebDriver 封裝)、Capybara |
| 手動環境變數 | rbenv / rvm / asdf 版本管理器 + Bundler 依賴管理 |