BBS电子论坛Java版项目工程源码

drop table treenode; //NODEID 为id //NODEPARENT 为父节点id,如没有则为null //NODECELL 为节点所在层,根节点为1层 //NODETITLE 为节点显示标题 //NODETEXT 为节点链接 create table treenode(NODEID int(4) auto_increment, NODEPARENT int(4) default 0, NODECELL int(2), NODETITLE varchar(50) not null, NODETEXT varchar(50), primary key (NODEID)); insert into treenode(NODECELL,NODETITLE) values(1,"tool"); insert into treenode(NODEPARENT,NODECELL,NODETITLE,NODETEXT) values(1,2,"knife","test1.jsp"); insert into treenode(NODEPARENT,NODECELL,NODETITLE,NODETEXT) values(1,2,"snip","test2.jsp"); insert into treenode(NODEPARENT,NODECELL,NODETITLE,NODETEXT) values(1,2,"cup","test2.jsp"); insert into treenode(NODEPARENT,NODECELL,NODETITLE,NODETEXT) values(4,3,"watercup","test2.jsp"); insert into treenode(NODEPARENT,NODECELL,NODETITLE,NODETEXT) values(4,3,"teacup","test1.jsp"); insert into treenode(NODECELL,NODETITLE) values(1,"drink"); insert into treenode(NODEPARENT,NODECELL,NODETITLE,NODETEXT) values(7,2,"tea","test1.jsp"); insert into treenode(NODEPARENT,NODECELL,NODETITLE,NODETEXT) values(7,2,"coffee","test1.jsp"); INSERT INTO treenode( NODECELL,NODETITLE,NODETEXT) values ( 1,'文章类别1','pub.do?dispatch=addContentType0'); insert into treenode(NODEPARENT,NODECELL,NODETITLE,NODETEXT) values(7,2,"文","test1.jsp"); create trigger treenode_bef_insupdate before update on treenode for each row begin set @old = OLD.nodeenabled; set @new = NEW.nodeenabled; set old = '2'; end; // CREATE TRIGGER t21_au BEFORE UPDATE ON treenode FOR EACH ROW BEGIN SET @old = OLD.nodeenabled; SET @new = NEW.nodeenabled; END;// CREATE TRIGGER t1 AFTER INSERT ON data FOR EACH ROW UPDATE chars SET count = count + CHAR_LENGTH(NEW.name); create trigger delforums after delete on treenode for each row begin delete from treenode end CREATE TRIGGER t1 AFTER INSERT ON treenode FOR EACH ROW insert into userlog(name) values('ff') delimiter | create trigger tff after insrt on treenode for each row begin insert into userlog(name) values('ff'); end; | drop trigger treenode_bef_ins; delimiter | create trigger treenode_bef_ins before update on treenode for each row begin set NEW.nodeenabled = '2' ; end; | delimiter ;