java网上图书商城(2)Category模块
本文实例为大家分享了java网上图书商城Category模块代码,供大家参考,具体内容如下
sql
CREATETABLE`t_category`( `cid`char(32)NOTNULL, `cname`varchar(50)DEFAULTNULL, `pid`char(32)DEFAULTNULL, `desc`varchar(100)DEFAULTNULL, `orderBy`int(11)NOTNULLAUTO_INCREMENT, PRIMARYKEY(`cid`), UNIQUEKEY`cname`(`cname`), KEY`FK_t_category_t_category`(`pid`), KEY`orderBy`(`orderBy`), CONSTRAINT`FK_t_category_t_category`FOREIGNKEY(`pid`)REFERENCES`t_category`(`cid`) )ENGINE=InnoDBAUTO_INCREMENT=48DEFAULTCHARSET=utf8;
Dao
publicList<Category>findAll()throwsSQLException{ /* *1.查询出所有一级分类 */ Stringsql="select*fromt_categorywherepidisnullorderbyorderBy"; List<Map<String,Object>>mapList=qr.query(sql,newMapListHandler()); List<Category>parents=toCategoryList(mapList); /* *2.循环遍历所有的一级分类,为每个一级分类加载它的二级分类 */ for(Categoryparent:parents){ //查询出当前父分类的所有子分类 List<Category>children=findByParent(parent.getCid()); //设置给父分类 parent.setChildren(children); } returnparents; }
left.jsp
Q6MenuBar组件显示手风琴式下拉菜单
<scriptlanguage="javascript"> $(function(){ .... <c:forEachitems="${parents}"var="parent"> <c:forEachitems="${parent.children}"var="child"> bar.add("${parent.cname}","${child.cname}","/goods/BookServlet?method=findByCategory&cid=${child.cid}","body"); </c:forEach> </c:forEach> }); </script>
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持毛票票。