sql.properties

CMS4J 是 JAVA / JSP 版网站管理系统 （Content Manage System For Java）的简称

#########################################################
# 统计管理
#########################################################

# 保存当前站点访问量
save.site_counter = \
	insert into STAT_SITE_COUNTER \
	(STAT_COUNT,STAT_TYPE,STAT_YEAR,STAT_MONTH,\
	STAT_DAY,STAT_HOUR,STAT_MINUTE,SAVE_DATE) \
	values (?,?,?,?,?,?,?,?)

# 取得自开始日期以来网站的访问量
get.site_counter = \
	select sum(STAT_COUNT) as SUM_STAT \
	from STAT_SITE_COUNTER \
	where SAVE_DATE >= '@DATE' \
	and STAT_TYPE = ?

# 取得月网站访问量
get.site_counter_month = \
	select sum(STAT_COUNT) as SUM_STAT \
	from STAT_SITE_COUNTER \
	where STAT_YEAR = ? and STAT_MONTH = ? \
	and STAT_TYPE = ?

# 取得日网站访问量
get.site_counter_day = \
	select sum(STAT_COUNT) as SUM_STAT \
	from STAT_SITE_COUNTER \
	where STAT_YEAR = ? and STAT_MONTH = ? \
	and STAT_DAY = ? and STAT_TYPE = ?