articlespecial_sql.properties

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

# 插入新专题
add.special = insert into ARTICLE_SPECIAL \
			(SPECIAL_ID,NAME,STATE,REMARK,ADD_DATE,ORDER_NUM) \
			values (?,?,?,?,?,?)


# 修改专题
modify.special = update ARTICLE_SPECIAL set \
			NAME = ? , REMARK = ? \
			where  SPECIAL_ID  = ?

# 修改专题状态
modify.special.state = update ARTICLE_SPECIAL set \
			STATE = ? \
			where SPECIAL_ID  = ?


# 检测专题ID是否已经存在
has.special.id = select COUNT(*) AS COUNT from ARTICLE_SPECIAL \
			where SPECIAL_ID = ?

# 取得一个专题
get.special = select * from ARTICLE_SPECIAL \
			where SPECIAL_ID = ?

# 取得最大的ORDER_NUM
get.max.special.ordernum = select * from ARTICLE_SPECIAL \
				order by ORDER_NUM desc LIMIT 0,1

# 删除一个专题：删除专题表中的条目
del.special = delete from ARTICLE_SPECIAL \
				where SPECIAL_ID = ?

# 清空一个专题：将原隶属于本专题的文章移出
remove.special.article = update ARTICLE set \
				SPECIAL_ID = "1" \
				where SPECIAL_ID = ?

# 专题排序：取得上一专题的排序编号
# 之所以还要加上ORDER_NUM > 1，是因为“无”专题不参加排序
get_prev_special_order = select * from ARTICLE_SPECIAL \
			where ORDER_NUM < ? and ORDER_NUM > 1 \
			order by ORDER_NUM desc LIMIT 0,1

# 专题排序：取得下一专题的排序编号
get_next_special_order = select * from ARTICLE_SPECIAL \
			where ORDER_NUM > ? \
			order by ORDER_NUM LIMIT 0,1

# 专题排序：保存
set_special_order = update ARTICLE_SPECIAL set ORDER_NUM = ? \
			where SPECIAL_ID = ?

#取得专题总数
get.special.count = select count(*) as count FROM ARTICLE_SPECIAL \
			where STATE = 1 and SPECIAL_ID <> 1


#################################################################
#   Special标签中用到的SQL
#################################################################
	
# 根据不同的条件，取得不同专题的模板
get.article.special.templet = \
	select t1.* FROM ARTICLE_SPECIAL as t1 \
	where $WHERE and SPECIAL_ID <> "1" order by $ORDER \
	limit $POSITION,$COUNTER