def getMaleNumFromDataBase():
conditionList = ["sex"]
conditionValList = ["male"]
operatorList = ["="]
sqlEnd = SQLServerEnd(USER_BASIC_TABLE_NAME)
maleNum = sqlEnd.selectCount(conditionList, conditionValList, operatorList)
return maleNum
def getOnlineNum():
sql = SQLServerEnd(LOGIN_TABLE_NAME)
conditionList = ['status']
conditionValList = ['1']
operatorList = ['=']
num = sql.selectCount(conditionList,conditionValList,operatorList)
return num
def getAgeCountFromDataBase(begin, end):
endYear = getYearsAgoDate(begin)
beginYear = getYearsAgoDate(end)
conditionList = ["birthday", "birthday"]
conditionValList = [beginYear, endYear]
operatorList = [">=", "<="]
sqlEnd = SQLServerEnd(USER_BASIC_TABLE_NAME)
count = sqlEnd.selectCount(conditionList, conditionValList, operatorList)
return count
