tree.properties

学生选课系统 赶快来下载啊啊好东西 呵呵啊啊 啊啊啊啊啊

# ForumTree#
forum_allTreeSql = SELECT * FROM EF_FORUMS WHERE forum_parent=-1
forum_currentSql = SELECT * FROM EF_FORUMS WHERE forum_id=?
forum_childSql = SELECT * FROM EF_FORUMS WHERE forum_root=? AND forum_parent=?  ORDER BY forum_showorder DESC
forum_updateLRSql = UPDATE EF_FORUMS SET forum_left=?,forum_right=? WHERE forum_id=?
forum_updateInsertRight = UPDATE EF_FORUMS SET forum_right=forum_right+2 WHERE forum_right>=? AND forum_root=?
forum_updateInsertLeft = 	UPDATE EF_FORUMS SET forum_left=forum_left+2 WHERE forum_left>? AND forum_root=?
forum_deleteLRSql = DELETE FROM EF_FORUMS WHERE (forum_left between ? AND ?) AND forum_root=?
forum_updateDeleteRight = UPDATE EF_FORUMS SET forum_right=forum_right-? WHERE forum_right>? AND forum_root=?
forum_updateDeleteLeft = UPDATE EF_FORUMS SET forum_left=forum_left-? WHERE forum_left>? AND forum_root=?

# PostTree#
post_allTreeSql = SELECT * FROM EF_POSTS WHERE post_parent=-1
post_currentSql = SELECT * FROM EF_POSTS WHERE post_id=?
post_childSql = SELECT * FROM EF_POSTS WHERE  topic_id=? AND post_parent=? ORDER BY post_floor
post_updateLRSql = UPDATE EF_POSTS SET post_left=?,post_right=? WHERE post_id=?
post_updateInsertRight = UPDATE EF_POSTS SET post_right=post_right+2 WHERE post_right>=? AND topic_id=?
post_updateInsertLeft = 	UPDATE EF_POSTS SET post_left=post_left+2 WHERE post_left>? AND topic_id=?
post_deleteLRSql = DELETE FROM EF_POSTS WHERE (post_left between ? AND ?) AND topic_id=?
post_updateDeleteRight = UPDATE EF_POSTS SET post_right=post_right-? WHERE post_right>? AND topic_id=?
post_updateDeleteLeft = UPDATE EF_POSTS SET post_left=post_left-? WHERE post_left>? AND topic_id=?