Question

怎么把ruby中的变量写到数据库里

简单说是insert into info_part(number) values ('data[0]') 存到数据库里number字段下得值是data[0]而不是data[0]变量对应的值 请问怎么修改 原语句如下
dbh.query("insert into info_part(id,number,regi_time,regi_place,part_time,part_place,become_time,become_place)
# values(NULL,'20095575','data[0][1]','data[0][3]','data[1][1]','data[1][3]','data[2][1]','data[2][3]')")

Answer 1

values中不能加引号吧。不然肯定把你的引号内的当作内容存进去。

追问

不加引号会报错 PHP里是不加引号 所以我试过

追答

# assume "objects" table has the following schema:
# create table objects (
# name varchar2(20),
# thing object
# )

db.type_translation = true
db.translator.add_translator( "object" ) do |type, value|
db.decode( value )
end

h = { :one=>:two, "three"=>"four", 5=>6 }
dump = db.encode( h )

db.execute( "insert into objects values ( ?, ? )", "bob", dump )

obj = db.get_first_value( "select thing from objects where name='bob'" )
p obj == h

Answer 2

data 是什么??
Array??
Array of Array??

追问

明显数组么

Answer 3

执行SQL语句
require "dbi"
dbh = DBI.connect("DBI:ODBC:#{db_name}",@user,@password)
sth = dbh.execute(%%1)

追问

我是 require "mysql"的 就算是用这个DBI 我也想知道我的错在哪

追答

你多加了一个#

参考资料： http://keyknight.blog.163.com/blog/static/3663784020077983725887/