announce_sql.properties

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

#########################################################
# 通知通告
#########################################################

# 添加通知通告
add.announce = \
	insert into ANNOUNCE \
	(IS_SELECTED,TITLE,CONTENT,AUTHOR, \
	ADD_DATE,CLASS_ID,BEGIN_DATE,END_DATE,ANNOUNCE_TYPE) values \
	(?,?,?,?,?,?,?,?,?)

# 修改通知通告
modify.announce = \
	update ANNOUNCE set \
	TITLE=?,CONTENT=?, \
	AUTHOR=?,CLASS_ID=?,BEGIN_DATE=?,END_DATE=?,ANNOUNCE_TYPE = ? \
	where ID = ?

# 删除通知通告
del.announce = \
	delete from ANNOUNCE where ID = ?

# 删除某一分类下的所有通知通告
del.type.announce = \
	delete from ANNOUNCE where CLASS_ID = ?

# 设置通知通告状态
set.announce.state = \
	update ANNOUNCE set \
	IS_SELECTED=? \
	where ID = ?


#########################################################
# 通知通告分类
#########################################################

# 添加通知通告分类
add.announce_class = \
	insert into ANNOUNCE_CLASS \
	(NAME,abc,REMARK,ADD_AUTHOR,ADD_DATE) \
	values (?,?,?,?,?)

# 修改通知通告分类
modify.announce_class = \
	update ANNOUNCE_CLASS set \
	NAME=?,REMARK=? \
	where ID = ?

# 删除通知通告分类
del.announce_class = \
	delete from ANNOUNCE_CLASS where ID = ?



#################################################################
#   announce标签中用到的SQL
#################################################################

# 得到通知通告列表模板
get.announce.templet = \
	select * from ANNOUNCE \
	where $WHERE order by $ORDER \
	limit $POSITION,$COUNTER


#################################################################
#   announce_class标签中用到的SQL
#################################################################

# 得到通知通告列表模板
get.announce_class.templet = \
	select * from ANNOUNCE_CLASS where $WHERE order by $ORDER