ruby oracle数据,ruby连接Oracle

ruby的速度，ruby的灵巧，ruby的简洁，给许多开发人员一个惊喜，rails功不可没，但是ruby本身的优秀也是名不虚传。

别的不说了，以下是搜罗出来的ruby与数据库交互小样。格式与Java也差不多，SQL语句嘛，本身就是挺罗嗦的事。不知道ruby什么时候也能整个orm出来，呵呵。

#create

require 'dbi'

dbh = DBI.connect('DBI:OCI8:ORCL', 'hr', 'hr')

dbh.do("CREATE TABLE states (

id CHAR(2) PRIMARY KEY,

name VARCHAR2(15) NOT NULL,

capital VARCHAR2(25) NOT NULL)")

dbh.disconnect

#insert

require 'dbi'

dbh = DBI.connect('DBI:OCI8:ORCL', 'hr', 'hr')

sqlInsert = "INSERT INTO states (id, name, capital)

VALUES (?, ?, ?)"

dbh.do(sqlInsert, "AL", "Alabama", "Birmingham")

dbh.do(sqlInsert, "AZ", "Arizona", "Phoenix")

dbh.do(sqlInsert, "CO", "Colorado", "Denver")

dbh.do(sqlInsert, "FL", "Florida", "Tallahassee")

dbh.do(sqlInsert, "MA", "Maine", "Augusta")

dbh.do(sqlInsert, "PA", "Pennsylvania", "Philadelphia")

dbh.do(sqlInsert, "UT", "Utah", "Salt Lake City")

dbh.do(sqlInsert, "WA", "Washington", "Seattle")

dbh.do(sqlInsert, "WY", "Wyoming", "Cheyenne")

dbh.commit

dbh.disconnect[@more@]

#update

require 'dbi'

dbh = DBI.connect('DBI:OCI8:ORCL', 'hr', 'hr')

sqlCapitalsUpdate = "UPDATE states SET capital = ? WHERE id = ?"

dbh.do(sqlCapitalsUpdate, "Montgomery", "AL")

dbh.do(sqlCapitalsUpdate, "Harrisburg", "PA")

dbh.do(sqlCapitalsUpdate, "Olympia", "WA")

dbh.do("UPDATE states SET id = 'ME' WHERE name = 'Maine'")

dbh.commit

dbh.disconnect

#query

require 'dbi'

dbh = DBI.connect('DBI:OCI8:ORCL', 'hr', 'hr')

rs = dbh.prepare('SELECT * FROM states')

rs.execute

while rsRow = rs.fetch do

p rsRow

#Alternative output: puts rsRow

#Alternative output: pp rsRow

end

rs.finish

dbh.disconnect

#Ruby DBI 提供了更好的输出格式。清单 5 和 6 显示使用 DBI 分别以表格和 XML 格式输出相同的查询结果。清单 5 和 6 中的代码不仅显示了 DBI::Utils 输出格式功能的用法，还显示了与清单 4 略微不同的获取和操作结果集的方法。

#　　清单 5 queryStatesTableFormatter.rb

require 'dbi'

dbh = DBI.connect('DBI:OCI8:ORCL', 'hr', 'hr')

rs = dbh.execute('SELECT * FROM states')

rows = rs.fetch_all

column_names = rs.column_names

rs.finish

DBI::Utils::TableFormatter.ascii(column_names, rows)

dbh.disconnect

Listing 6: queryStatesTableXML.rb

require 'dbi'

dbh = DBI.connect('DBI:OCI8:ORCL', 'hr', 'hr')

rs = dbh.execute('SELECT * FROM states')

states_rows = rs.fetch_all

rs.finish

DBI::Utils::XMLFormatter.table(states_rows)

dbh.disconnect