Ruby on Rails 学习（五）

任务：对输入变量，做按行拆分，并精确匹配数据库中多个表数个字段的数据
1.取得输入变量
 batch_keyword = params[:batch_keyword]
2.判断字符串是否是空的
 if ( not params[:batch_keyword].nil? ) then
 end
3.按行拆分
  keywordArr = batch_keyword.split(/\n/)
4.构造匹配数据  
conditionsText = "tblx0.field0 IN ('0000000'"
for i in keywordArr do     
   tmpValue = "#{i}" 
   tmpValue = tmpValue.gsub(/\s+|\r|\n/,'')
   conditionsText = conditionsText + ",'"+tmpValue +"'"  
end   
conditionsText = conditionsText + ")";


5.完成代码 
 
    batch_keyword = params[:batch_keyword]
 
  
    if ( not batch_keyword.nil? ) then
keywordArr = batch_keyword.split(/\n/)
 
conditionsText0 = "tblx0.field0 IN ('0000000'"
conditionsText1 = "tblx1.field1  IN ('0000000'"
conditionsText2 = "tblx1.field2  IN ('0000000'"
conditionsText3 = "tblx1.field3  IN ('0000000'"
conditionsText4 = "tblx1.field4  IN ('0000000'"
for i in keywordArr do     
  tmpValue = "#{i}" 
  tmpValue = tmpValue.gsub(/\s+|\r|\n/,'')
  if ( not tmpValue.nil? ) then
conditionsText0 = conditionsText0 + ",'"+tmpValue +"'"  
conditionsText1 = conditionsText1 + ",'"+tmpValue +"'"  
conditionsText2 = conditionsText2 + ",'"+tmpValue +"'"  
conditionsText3 = conditionsText3 + ",'"+tmpValue +"'"  
conditionsText4 = conditionsText4 + ",'"+tmpValue +"'"  
  end   
end   
conditionsText0 = conditionsText0 + ")";
conditionsText1 = conditionsText1 + ")";
conditionsText2 = conditionsText2 + ")";
conditionsText3 = conditionsText3 + ")";
conditionsText4 = conditionsText4 + ")";



conditionsText = conditionsText0 + " or " + conditionsText1 + " or " + conditionsText2 + " or " + conditionsText3 + " or " + conditionsText4  
 
    end