require 'mysql'
class QueryUtil
def find_user_info usernames
@db = Mysql.real_connect("localhost","root","123456","test",3306);
sql = "select * from user_info where "
usernames.each do |user|
sql << "username = '"
sql << user
sql << "' or "
end
puts sql
result = @db.query(sql);
result.each_hash do |row|
#处理从数据库读出来的数据
end
#后面应将读到的数据组装成对象返回,这里略去
ensure
@db.close
end
end
qUtil = QueryUtil.new qUtil.find_user_info ["Tom", "Jim", "Anna"]
require 'mysql'
class QueryUtil
def find_user_info usernames
@db = Mysql.real_connect("localhost","root","123456","test",3306);
sql = "select * from user_info where "
usernames.each do |user|
sql << "username = '"
sql << user
sql << "' or "
end
sql = sql[0 .. -" or ".length]
puts sql
result = @db.query(sql);
result.each_hash do |row|
#处理从数据库读出来的数据
end
#后面应将读到的数据组装成对象返回,这里略去
ensure
@db.close
end
end
select * from user_info where username = 'Tom' or username = 'Jim' or username = 'Anna'
require 'mysql'
class QueryUtil
def find_user_info(usernames, strategy)
@db = Mysql.real_connect("localhost","root","123456","test",3306);
sql = "select * from user_info where "
if strategy == 1
usernames.each do |user|
sql << "username = '"
sql << user
sql << "' or "
end
sql = sql[0 .. -" or ".length]
elsif strategy == 2
need_or = false
usernames.each do |user|
sql << " or " if need_or
sql << "username = '"
sql << user
sql << "'"
need_or = true
end
end
puts sql
result = @db.query(sql);
result.each_hash do |row|
#处理从数据库读出来的数据
end
#后面应将读到的数据组装成对象返回,这里略去
ensure
@db.close
end
end
qUtil = QueryUtil.new qUtil.find_user_info(["Tom", "Jim", "Anna"], 2)
class Strategy
def get_sql usernames
raise "You should override this method in subclass."
end
end
class Strategy1
def get_sql usernames
sql = "select * from user_info where "
usernames.each do |user|
sql << "username = '"
sql << user
sql << "' or "
end
sql = sql[0 .. -" or ".length]
end
end
class Strategy2
def get_sql usernames
sql = "select * from user_info where "
need_or = false
usernames.each do |user|
sql << " or " if need_or
sql << "username = '"
sql << user
sql << "'"
need_or = true
end
end
end
require 'mysql'
class QueryUtil
def find_user_info(usernames, strategy)
@db = Mysql.real_connect("localhost","root","123456","test",3306);
sql = strategy.get_sql(usernames)
puts sql
result = @db.query(sql);
result.each_hash do |row|
#处理从数据库读出来的数据
end
#后面应将读到的数据组装成对象返回,这里略去
ensure
@db.close
end
end
qUtil = QueryUtil.new qUtil.find_user_info(["Tom", "Jim", "Anna"], Strategy1.new) qUtil.find_user_info(["Jac", "Joe", "Rose"], Strategy2.new)
select * from user_info where username = 'Tom' or username = 'Jim' or username = 'Anna' select * from user_info where username = 'Jac' or username = 'Joe' or username = 'Rose'
# -*- encoding: utf-8 -*-
#现金收费抽象类
class CashSuper
def accept_cash(money)
end
end
#正常收费子类
class CashNormal < CashSuper
def accept_cash(money)
money
end
end
#打折收费子类
class CashRebate < CashSuper
attr_accessor :mony_rebate
def initialize(mony_rebate)
@mony_rebate = mony_rebate
end
def accept_cash(money)
money * mony_rebate
end
end
#返利收费子类
class CashReturn < CashSuper
attr_accessor :mony_condition, :mony_return
def initialize(mony_condition, mony_return)
@mony_condition = mony_condition
@mony_return = mony_return
end
def accept_cash(money)
if money > mony_condition
money - (money/mony_condition) * mony_return
end
end
end
#现金收费工厂类
class CashFactory
def self.create_cash_accept(type)
case type
when '正常收费'
CashNormal.new()
when '打8折'
CashRebate.new(0.8)
when '满三百减100'
CashReturn.new(300,100)
end
end
end
cash0 = CashFactory.create_cash_accept('正常收费')
p cash0.accept_cash(700)
cash1 = CashFactory.create_cash_accept('打8折')
p cash1.accept_cash(700)
cash2 = CashFactory.create_cash_accept('满三百减100')
p cash2.accept_cash(700)
class CashContext
attr_accessor :cs
def initialize(c_super)
@cs = c_super
end
def result(money)
cs.accept_cash(money)
end
end
type = '打8折'
cs=case type
when '正常收费'
CashContext.new(CashNormal.new())
when '打8折'
CashContext.new(CashRebate.new(0.8))
when '满三百减100'
CashContext.new(CashReturn.new(300,100))
end
p cs.result(700)
class CashContext
attr_accessor :cs
def initialize(type)
case type
when '正常收费'
@cs = CashNormal.new()
when '打8折'
@cs = CashRebate.new(0.8)
when '满三百减100'
@cs = CashReturn.new(300,100)
end
end
def result(money)
cs.accept_cash(money)
end
end
cs=CashContext.new('打8折')
p cs.result(700)
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有