使用S2SH整合EXT.doc

使用S2SH整合EXT的步骤如下： 1)：创建表exttree,表结构如下： drop table if exists exttree; CREATE TABLE exttree( id bigint(11) auto_increment primary key, parentId bigint(11) NOT NULL, title varchar(255) default NULL, number bigint(11) default NULL, leaf int(4) default NULL, url varchar(255) default NULL ); insert into `exttree` values(null,-1,Root,0,0,null); insert into `exttree` values(null,1,音乐,0,0,null); insert into `exttree` values(null,2,轻金属,1,1,null); insert into `exttree` values(null,2,重金属,2,1,null); insert into `exttree` values(null,2,RB,3,1,null); insert into `exttree` values(null,1,体育,0,0,null); insert into `exttree` values(null,6,篮球,1,1,null); insert into `exttree` values(null,6,足球,2,1,null); insert into `exttree` values(null,6,体操,3,1,null); insert into `exttree` values(null,1,美食,0,0,null); insert into `exttree` values(null,10,中国菜,0,0,null); insert into `exttree` values(null,11,青椒找肉,0,1,null); insert into `exttree` values(null,10,日本菜,0,0,null); insert into `exttree` values(null,13,河夫烤鱼,0,1,null); insert into `exttree` values(null,10,法国菜,0,0,null); insert into `exttree` values(null,15,爆炒蜗牛,0,1,null); PS：NUMBER为节点之间的排序，ParentID和leaf为父节点和子节点的代码。 2）后台数据处理接口： package?com.exttree.dao;import?java.util.List;import?com.exttree.pojo.Exttree;/**?*//**?*?Ext访问数据库接口封装?*??*?@author?BruceLeey?*??*/public?interface?IExtTreeDemo?{????/**?*//**?????*?根据ID查找对象?????*??????*?@param?id?????*?@return?????*?@throws?Exception?????*/????public?Exttree?findById(Long?id)?throws?Exception;????/**?*//**?????*?根据父节点查询所有子节点列表?????*??????*?@param?parentId?????*?@return?????*?@throws?Exception?????*/????public?ListExttree?findChildById(Long?parentId)?throws?Exception;????/**?*//**?????*?保存节点?????*??????*?@param?node?????*?@throws?Exception?????*/????public?void?save(Exttree?node)?throws?Exception;????/**?*//**?????*?根据ID删除子节点?????*??????*?@param?node?????*?@throws?Exception?????*/????public?void?removeChildById(Exttree?node)?throws?Exception;????/