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