如何使用ruby编程连接和访问mysqldb

#!/usr/bin/ruby -w
require "rubygems"
require "mysql"
begin
     # connect to the MySQL server
     dbh = DBI.connect("DBI:Mysql:TESTDB:localhost", 
                        "nyros", "root")
     # 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

I want to connect and access MySQL database through ruby programming. But i am getting this error when executing the ruby code in my terminal.

我想通过ruby编程连接和访问MySQL数据库。但是我在终端中执行ruby代码时遇到此错误。

Error:

/.rvm/rubies/ruby-1.9.3 p547/lib/ruby/site_ruby/1.9.1/rubygems/core_ext/kernel_require.rb:55:in 'require': cannot load such file -- mysql (LoadError)
from /home/nyros/.rvm/rubies/ruby-1.9.3-p547/lib/ruby/site_ruby/1.9.1/rubygems/core_ext/kernel_require.rb:55:in 'require'
from task.rb:3:in '<main>'

1 个解决方案

#1

I suggest using mysql2. It is a mysql library for Ruby.

我建议使用mysql2。它是Ruby的mysql库。

For example:

require 'mysql2'

client = Mysql2::Client.new(:host => HOST, :username => USERNAME, :database => DATABASE)
client.query("select * from tabel_name;")

If you don't want to use mysql2, you also can refer to this link.

如果您不想使用mysql2,您也可以参考此链接。

1 个解决方案

#1

更多相关文章

随机推荐