java网上图书商城（2）Category模块

本文实例为大家分享了java网上图书商城category模块代码，供大家参考，具体内容如下

sql

create table `t_category` (
 `cid` char(32) not null,
 `cname` varchar(50) default null,
 `pid` char(32) default null,
 `desc` varchar(100) default null,
 `orderby` int(11) not null auto_increment,
 primary key (`cid`),
 unique key `cname` (`cname`),
 key `fk_t_category_t_category` (`pid`),
 key `orderby` (`orderby`),
 constraint `fk_t_category_t_category` foreign key (`pid`) references `t_category` (`cid`)
) engine=innodb auto_increment=48 default charset=utf8;　

dao

public list<category> findall() throws sqlexception {
 /*
  * 1. 查询出所有一级分类
  */
 string sql = "select * from t_category where pid is null order by orderby";
 list<map<string,object>> maplist = qr.query(sql, new maplisthandler());
  
 list<category> parents = tocategorylist(maplist);
  
 /*
  * 2. 循环遍历所有的一级分类，为每个一级分类加载它的二级分类
  */
 for(category parent : parents) {
  // 查询出当前父分类的所有子分类
  list<category> children = findbyparent(parent.getcid());
  // 设置给父分类
  parent.setchildren(children);
 }
 return parents;
}

left.jsp

q6menubar组件显示手风琴式下拉菜单

<script language="javascript">
$(function() {
....
<c:foreach items="${parents}" var="parent">
 <c:foreach items="${parent.children}" var="child">
 bar.add("${parent.cname}", "${child.cname}", "/goods/bookservlet?method=findbycategory&cid=${child.cid}", "body");
 </c:foreach>
</c:foreach>
 
});
</script>

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。