vote_sql.properties

来自「CMS4J 是 JAVA / JSP 版网站管理系统 （Content Man」· PROPERTIES 代码 · 共 35 行

##添加调查
add.vote=insert into vote (TITLE,SELECT1,ANSWER1,SELECT2,ANSWER2,\
		 SELECT3,ANSWER3,SELECT4,ANSWER4,SELECT5,ANSWER5,SELECT6,\
		 ANSWER6,SELECT7,ANSWER7,SELECT8,ANSWER8,VOTE_TIME,\
		 VOTE_TYPE,IS_SELECTED) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
##修改调查		 
modify.vote=update VOTE set TITLE=?,SELECT1=?,ANSWER1=?,SELECT2=?,ANSWER2=?,SELECT3=?,ANSWER3=?,\
		SELECT4=?,ANSWER4=?,SELECT5=?,ANSWER5=?,SELECT6=?,ANSWER6=?,\
		SELECT7=?,ANSWER7=?,SELECT8=?,ANSWER8=?,VOTE_TIME=?,VOTE_TYPE=?,IS_SELECTED=?\
		 where ID=?
##删除调查		 
del.vote=delete from vote where ID=?

##设置为最新调查
set.selected.vote=update VOTE set IS_SELECTED=1 where ID=?
		
##取得最新调查
get.selected.vote=select * from VOTE where IS_SELECTED=1

##删除最新调查
remove.selected.vote=update VOTE set IS_SELECTED=0 where ID=?

##通过ID取得调查
get.votevo.vote=select * from VOTE where ID=?



################################################
#voteTag中用到的sql语句                        #
#					       #
#################################################
get.vote.templet=\
	select t1.* FROM VOTE as t1 \
	where $WHERE order by $ORDER \
	limit $POSITION,$COUNTER