1.使用mysql驱动连接数据库
require 'mysql'
mysql = Mysql.init()
mysql.connect('localhost', 'root', 'root')
mysql.select_db('test')
results = mysql.query("select * from test")
results.each do |row|
puts row[0]
end
mysql.close
2.DBI连接数据库
这种方式,刚开始遇到无法加载驱动的问题:
代码:
#require 'rubygems'
#gem 'mysql'
#gem 'dbi'
require 'dbi'
con = DBI.connect("dbi:Mysql:test")
result = con.execute("select count(id) from test")
puts result.fetch[0]
con.disconnect
错误:
in `load_driver': Could not load driver (no such file to load -- DBD/mysql/mysql) (DBI::InterfaceError)
或者
in `load_driver': Unable to load driver
前一种我用下面的方法解决的,代码:
require 'rubygems'
gem 'mysql'
gem 'dbi'
require 'dbi'
con = DBI.connect("dbi:Mysql:test")
result = con.execute("select count(id) from test")
puts result.fetch[0]
con.disconnect
后一种我手动重新安装了一次DBI,安装完后目录(D:\ruby\lib\ruby\site_ruby\1.8\DBD)下多了,mysql文件夹和Mysql.rb文件,mysql文件夹下有database.rb,driver.rb,statement.rb三个文件
同样用上面的代码连接数据库,问题解决
require 'mysql'
mysql = Mysql.init()
mysql.connect('localhost', 'root', 'root')
mysql.select_db('test')
results = mysql.query("select * from test")
results.each do |row|
puts row[0]
end
mysql.close
2.DBI连接数据库
这种方式,刚开始遇到无法加载驱动的问题:
代码:
#require 'rubygems'
#gem 'mysql'
#gem 'dbi'
require 'dbi'
con = DBI.connect("dbi:Mysql:test")
result = con.execute("select count(id) from test")
puts result.fetch[0]
con.disconnect
错误:
in `load_driver': Could not load driver (no such file to load -- DBD/mysql/mysql) (DBI::InterfaceError)
或者
in `load_driver': Unable to load driver
前一种我用下面的方法解决的,代码:
require 'rubygems'
gem 'mysql'
gem 'dbi'
require 'dbi'
con = DBI.connect("dbi:Mysql:test")
result = con.execute("select count(id) from test")
puts result.fetch[0]
con.disconnect
后一种我手动重新安装了一次DBI,安装完后目录(D:\ruby\lib\ruby\site_ruby\1.8\DBD)下多了,mysql文件夹和Mysql.rb文件,mysql文件夹下有database.rb,driver.rb,statement.rb三个文件
同样用上面的代码连接数据库,问题解决