SHibernate+Javascript实现无限级树形菜单.doc

Struts1.2+Hibernate3.0+JavaScript+JSTL1.1 实现无限级树形菜单一、说明：1、开发环境：Eclipse3.2.1+MyEclipse5.1+Tomcat5.5+Microsoft SQL Server 20002、主要实现技术：Struts1.2+Hibernate3.0+JavaScript+JSTL1.1+自定义标签3、页面的树形菜单的节点用 JavaScript进行控制4、数据库中的商品类别表productCategory包含一个引用自身主键的外键，从而形成自身一对多关系5、自定义标签实现类Recursion中主要用了递归实现节点的展开二、完成后运行效果如下图：三、具体实现步骤：1、新建一个Web Project工程(随便加载JSTL1.1的支持)，创建如下图所示的结构目录；2、创建数据库数据库中就只有两张表，其中商品类别商品为一对多关系，商品类别自身形成一对多关系(引用主键：类别编号做外键：父类编号)，下面是由PowerDesigner 12 画的概念图生成的数据库脚本tree.sql如下：/*=*/* DBMS name: Microsoft SQL Server 2000 */* Created on: 2007-07-14 09:10:40 */*=*/*=*/* Table: product */*=*/create database treegouse treegocreate table product ( productId int identity not null, CategoryId int not null, productName varchar(100) not null, productPrice money not null, constraint PK_PRODUCT primary key nonclustered (productId)go/*=*/* Index: ProductCategoryToProduct_FK */*=*/create index ProductCategoryToProduct_FK on product (CategoryId ASC)go/*=*/* Table: productCategory */*=*/create table productCategory ( CategoryId int identity not null, ParentCategoryId int null, CategoryName varchar(50) not null, constraint PK_PRODUCTCATEGORY primary key nonclustered (CategoryId)go/*=*/* Index: 商品类别拥有商品类别_FK */*=*/create index 商品类别拥有商品类别_FK on productCategory (ParentCategoryId ASC)goalter table product add constraint FK_PRODUCT_PRODUCTCA_PRODUCTC foreign key (CategoryId) references productCategory (CategoryId)goalter table productCategory add constraint FK_PRODUCTC_商品类别拥有商品类_PRODUCTC foreign key (ParentCategoryId) references productCategory (CategoryId)用查询分析器运行上述脚本，在数据库中建表product结构如下图：表productCategory结构如下图：3、数据库建好后，通过MyEclipse加载Struts 1.2、Hibernate 3.0的支持4、切换到MyEclipse Database 视图，通过Hibernate Reverse Engineering生成两张表的Pojo类和*.hbm.xml映射文件5、对自动生成的Pojo类和*.hbm.xml映射文件进行适当的修改,修改后的文件如下：1)Product.javapackage com.lideedu.yame.tree.pojos;public class Product implements java.io.Serializable private Integer productId; private ProductCategory productCategory; private String productName; private Double productPrice; public Product() public Integer getProductId() return ductId; public void setProductId(Integer productId) ductId = productId; public ProductCategory getProductCategory() return ductCategory; public void setProductCategory(ProductCategory productCategory) ductCategory = productCategory; public String getProductName() return ductName; public void setProductName(String productName) ductName = productName; public Double getProductPrice() return ductPrice; public void setProductPrice(Double productPrice) ductPrice = productPrice; 2)Product.hbm.xml 3)ProductCategory.javapackage com.lideedu.yame.tree.pojos;import java.util.HashSet;import java.util.Set;SuppressWarnings(serial)public class ProductCategory implements java.io.Serializable private Integer categoryId;private String categoryName;private ProductCategory parentCategory;private Set subCategories = new HashSet(0);private Set products = new HashSet(0);public Set getProducts() return products;public void setProducts(Set products) ducts = products;public ProductCategory() public Integer getCategoryId() return this.categoryId;public void setCategoryId(Integer categoryId) this.categoryId = categoryId;public String getCategoryName() return this.categoryName;public void setCategoryName(String categoryName) this.categoryName = categoryName;public ProductCategory getParentCategory() return parentCategory;public void setParentCategory(ProductCategory parentCategory) this.parentCategory = parentCategory;public Set getSubCategories() return subCategories;public void setSubCategories(Set subCategories) this.subCategories = subCategories;4)ProductCategory.hbm.xml 6、编写DAO1) ProductDAOpackage com.lideedu.yame.tree.dao;import java.util.List;import org.hibernate.Session;import org.hibernate.Transaction;import com.lideedu.yame.tree.db.HibernateSessionFactory;import com.lideedu.yame.tree.pojos.Product;public class ProductDAO private Session session= null;private Transaction tx = null;public void save(Product product)try session = HibernateSessionFactory.getSession();tx = session.beginTransaction();session.save(product);mit(); catch (Exception e) e.printStackTrace();if(tx != null)tx.rollback();finallyHibernateSessionFactory.closeSession();tx = null;public List queryAll()List list = null;try session = HibernateSessionFactory.getSession();list = session.createQuery(from Product p left join fetch ductCategory).list(); catch (Exception e) e.printStackTrace();finallyHibernateSessionFactory.closeSession();return list;public List queryByProductId(int productId)List list = null;try session = HibernateSessionFactory.getSession();list = session.createQuery(from Product p left join fetch ductCategory where ductId=+productId).list(); catch (Exception e) e.printStackTrace();finallyHibernateSessionFactory.closeSession();return list;public List queryByCategoryId(int categoryId)List list = null;try session = HibernateSessionFactory.getSession();list = session.createQuery(from Product p left join fetch ductCategory where ductCategory.categoryId=+categoryId).list(); catch (Exception e) e.printStackTrace();finallyHibernateSessionFactory.closeSession();return list;2) ProductCategoryDAOpackage com.lideedu.yame.tree.dao;import java.util.List;import org.hibernate.Session;import org.hibernate.Transaction;import com.lideedu.yame.tree.db.HibernateSessionFactory;import com.lideedu.yame.tree.pojos.ProductCategory;public class ProductCategoryDAO private Session session= null;private Transaction tx = null;public void save(ProductCategory pc)try session = HibernateSessionFactory.getSession();tx = session.beginTransaction();session.save(pc);mit(); catch (Exception e) e.printStackTrace();if(tx != null)tx.rollback();finallyHibernateSessionFactory.closeSession();tx = null;public List queryAll()List list = null;try session = HibernateSessionFactory.getSession();list = session.createQuery(from ProductCategory p left join fetch p.parentCategory).list(); catch (Exception e) e.printStackTrace();finallyHibernateSessionFactory.closeSession();return list;7、编写Struts 控制类1)ListCategoryAction.java 这个类的作用是从数据库中查出根类，存放到List中，然后把List保存到request范围，在前台通过自定义标签取出后，在自定义标签的实现类RecursionTag中通过递归做成一棵目录树，在页面显示出来，页面的节点的展开和折叠是通过JavaScript控制的。package com.lideedu.yame.tree.struts.action;import java.util.ArrayList;import java.util.Iterator;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;import org.apache.struts.action.ActionForm;import org.apache.struts.action.ActionForward;import org.apache.struts.action.ActionMapping;import com.lideedu.yame.tree.dao.ProductCategoryDAO;import com.lideedu.yame.tree.pojos.ProductCategory;public class ListCategoryAction extends Action SuppressWarnings(unchecked)public ActionForward execute(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response) ProductCategoryDAO pcDAO = new ProductCategoryDAO();List list = new ArrayList();Iterator it = pcDAO.queryAll().iterator();for (Iterator iter = it; iter.hasNext();) ProductCategory element = (ProductCategory) iter.next();if(element.getParentCategory() = null)list.add(element);request.setAttribute(all, list);return mapping.findForward(list);2)QueryProductAction.java 此类用于显示具体商品的名称时调用，当页面目录树展开到没有子类的节点时，就调用此类从数据库中查询出该类别下所有商品的信息package com.lideedu.yame.tree.struts.action;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;import org.apache.struts.action.ActionForm;import org.apache.struts.action.ActionForward;import org.apache.struts.action.ActionMapping;import com.lideedu.yame.tree.dao.ProductDAO;public class QueryProductAction extends Action private ProductDAO productDAO = new ProductDAO();public ActionForward execute(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response) int productId = new Integer(request.getParameter(productId);List list = productDAO.queryByProductId(productId);request.setAttribute(products, list);return mapping.findForward(listProducts);8、Struts配置文件struts-config.xml 9、几个JSP页面文件1) main.jsp 此页面非常简单，只是提供个调用ListCategoryAction的入口 Main !- 显示所有商品类别目录 2) ListProducts.jsp此页用来显示某个具体商品的详细信息 My JSP ListProducts.jsp starting page !- 商品详细信息 商品所属类别：$ductCategory.categoryName 商品编号：$ductId 商品名称：$ductName 价格：$ductPrice元 * 3) ListCategory.jsp *核心页面显示商品类别目录树和具体商品信息，无限级树型菜单所有商品没有任何商品!initiate();您的浏览器不支持此功能，请您使用最新的版本。 function iframeResize()var dyniframe = null;var indexwin = null;if (document.getElementById)dyniframe = document.getElementById(mainFrame);indexwin = window;if (dyniframe)if (dyniframe.contentDocument)dyniframe.height = dyniframe.contentDocument.body.scrollHeight + 10;else if (dyniframe.document & dyniframe.document.body.scrollHeight) iframeheight= mainFrame.document.body.scrollHeight + 10;dyniframe.height = iframeheight;10、用到的JavaScript脚本和样式表（控制树节点的关键）1) myjs.js2) mycss.css上述两个文件和用到的图片都打包在上传的文件中，因为这两个文件是网上搜来的，有兴趣的自己去研究！11、自定义标签的编写1） 创建标签处理类（Tag Handler ClassRecursionTag.java）package com.lideedu.yame.utils;import java.io.IOException;import java.util.Iterator;imp