Ruby/DBI數(shù)據(jù)庫(kù)訪問(wèn)接口

Ruby/DBI 是一個(gè)跟 Perl/DBI 類似的統(tǒng)一數(shù)據(jù)庫(kù)訪問(wèn)接口，支持各種流行的數(shù)據(jù)庫(kù)。

下面是一段使用了 Ruby/DBI 的代碼：

#!/usr/bin/ruby -w
   # simple.rb - simple MySQL script using Ruby DBI module

   require "dbi"

   begin
     # connect to the MySQL server
     dbh = DBI.connect("DBI:Mysql:test:localhost", "testuser", "testpass")
     # get server version string and display it
     row = dbh.select_one("SELECT VERSION()")
     puts "Server version: " + row[0]
   rescue DBI::DatabaseError => e
     puts "An error occurred"
     puts "Error code: #{e.err}"
     puts "Error message: #{e.errstr}"
   ensure
     # disconnect from server
     dbh.disconnect if dbh
   end