Ruby環境搭建
1、上傳ruby原始碼包，原始碼下載地址
http://www.ruby-lang.org/en/downloads/
2、配置并編譯源代碼
./configure
Make
Make install
3、安裝openssl,由于默認gem源不可用。重新配置https的gem源需要首先安裝openssl。
yum install openssl
yum install libssl-dev
進入 ruby原始碼目錄/ext/openssl
運行：
ruby extconfig.rb
make
make install
4、安裝gzib,
cd rubyum install libssl-devel
yum install libssl-devel
進入 ruby原始碼目錄/ext/zlib
make
make install裝目錄/ext/zlib
5、gem配置
gem sources --remove https://rubygems.org/
gem sources --add https://gems.ruby-china.org/ --remove https://rubygems.org/
gem sources -l
*** CURRENT SOURCES ***
https://gems.ruby-china.org
6、安裝unixodbc和unixodbc-devel
7、安裝 dbd-odbc
gem install dbd-odbc
8、安裝 dbi
gem install dbi
9、安裝 ruby-odbc
gem install ruby-odbc
10、配置8todbc
11、測驗代碼
#!/usr/bin/ruby -w
require “dbd/ODBC”
begin
# 連接到 MySQL 服務器
dbh = DBI.connect(“DBI:ODBC:gbase8t”,
“informix”, “informix”)
dbh.do(“DROP TABLE IF EXISTS EMPLOYEE”)
dbh.do(“CREATE TABLE EMPLOYEE (
FIRST_NAME CHAR(20) NOT NULL,
LAST_NAME CHAR(20),
AGE INT,
SEX CHAR(1),
INCOME INT )” )
puts “Table created”
dbh.do( “INSERT INTO EMPLOYEE(FIRST_NAME,
LAST_NAME,
AGE,
SEX,
INCOME)
VALUES (‘Mac’, ‘Mohan’, 20, ‘M’, 2000)” )
puts “Record has been created”
dbh.commit
sth = dbh.prepare(“SELECT * FROM EMPLOYEE”)
sth.execute()
sth.fetch do |row|
printf “First Name: %s, Last Name : %s\n”, row[0], row[1]
printf “Age: %d, Sex : %s\n”, row[2], row[3]
printf “Salary :%d \n\n”, row[4]
end
sth.finish
rescue DBI::DatabaseError => e
puts “An error occurred”
puts “Error code: #{e.err}”
puts “Error message: #{e.errstr}”
dbh.rollback
ensure
# 斷開與服務器的連接
dbh.disconnect if dbh
end
12、執行代碼
Ruby test.rb
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/250919.html
標籤：其他數據庫