在rails中执行sql语句

        sql = ActiveRecord::Base.connection()
        sql.insert "INSERT INTO #{UC_DBTABLEPRE}members SET username='#{@user.uname}', password='#{password}', email='#{@user.email}', regip='1.1.1.1', salt='#{salt}'"
        last_user_id = sql.select_value("SELECT uid FROM #{UC_DBTABLEPRE}members WHERE email='#{@user.email}'")
        unless last_user_id.nil?
          sql.insert "INSERT INTO #{UC_DBTABLEPRE}memberfields SET uid='#{last_user_id.to_s}', blacklist=' '"
        end

 其他的api还有：

    *  add_limit!
    * add_limit_offset!
    * add_lock!
    * begin_db_transaction
    * commit_db_transaction
    * default_sequence_name
    * delete
    * delete_sql
    * empty_insert_statement
    * execute
    * insert
    * insert_fixture
    * insert_sql
    * reset_sequence!
    * rollback_db_transaction
    * sanitize_limit
    * select
    * select_all
    * select_one
    * select_rows
    * select_value
    * select_values
    * transaction
    * update
    * update_sql

 

请查rails文档

评论

2 楼 FZtree 2014-10-09  

写controller 在action里面 @你要传递的变量

1 楼 lihaoyxj 2012-03-14  

你好，请问如何在rails中执行SQL语句的select的返回集后，怎么把结果集传给页面？有例子吗？