RoR CRUD

来源：互联网发布：战龙三国旗进阶数据编辑：程序博客网时间：2024/06/07 03:25

查询

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

插入

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

0 0