RoR CRUD

查询

  def find_test
    s_name=request.GET["name"]
    str= "select * from students where name="+%("#{s_name}")
    student=Student.find_by_sql(str)
    render :text => student[0] == nil ?"empty":student[0].attributes

  end

模糊查询

User.where("user_email like '%yong%'")

User Load (0.5ms)  SELECT `users`.* FROM `users` WHERE (user_email like '%yong%')

插入

  def add_test
    s_name=request.GET["name"]
    s_age=request.GET["age"]
    s_sex=request.GET["sex"]
    student=Student.create(:name=>s_name,:age=>s_age,:sex=>s_sex)
    str= "select * from students where name="+%("#{student.name}")
    s_student=Student.find_by_sql(str)
    render :text => s_student[0] == nil ?"empty":s_student[0].attributes
  end

更新

  def update_test
    s_name=request.GET["name"]
    s_new_name=request.GET["new_name"]
    str= "select * from students where name="+%("#{s_name}")
    student=Student.find_by_sql(str)
    
    s_ids=[]
    s_id_conditions=[]
    for s in student
      s_ids+=[s.id]
      s_id_conditions+=[:name=>s_new_name]
    end


    Student.update(s_ids,s_id_conditions)
    s_student=Student.find_by_sql(str)
    render :text => s_student[0] == nil ?"empty":s_student[0].attributes
  end

删除

  def delete_test
    s_name=request.GET["name"]
    str= "select * from students where name="+%("#{s_name}")
    student=Student.find_by_sql(str)
    s_ids=[]
    for s in student
      s_ids+=[s.id]
    end
    Student.delete(s_ids)
    s_student=Student.find_by_sql(str)
    render :text => s_student[0] == nil ?"empty":s_student[0].attributes
  end