Titan Tang's Blog

Titan Tang's Blog

在ubuntu 7.10上安装ruby Dbi

参考了http://myjavaworld.wordpress.com/2008/01/14/installing-mysql-server-and-lib-mysql-for-ruby-on-ubuntu-710/ 步骤如下

sudo apt-get install mysql-server libmysqlclient15-dev mysql-client

sudo apt-get install mysql-query-browser(可选)

sudo apt-get install libdbd-mysql-ruby libdbd-mysql-ruby1.8

sudo gem install mysql

测试代码: 代码来自于:http://www.kitebird.com/articles/ruby-dbi.html (上面那篇文章的安装dbi的方法貌似不适用与ubuntu)

#!/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

Comments