ruby 操作Mysql数据库

在工作中要反复的进行数据库操作，所以写了下面一个脚本，代码贴下防备忘：
class DealMySQL
   
    def initialize(localhost=nil,username=nil,password=nil,database=nil)
        require "mysql"
        @localhost = localhost
        @username = username
        @password = password
        @database = database
        @dbc = Mysql.real_connect("#{@localhost}","#{@username}","#{@password}","#{@database}",3306)
    end

    def deal_some_record(sql=nil)
        @dbc.query(sql)
    end
   
    def finalize()
        @dbc.close
    end
end