一个项目：产品分类信息树状显示

产品分类信息树状形式显示

1.构建产品分类实体ProducType

package cn.tedu.ttms.product.entity;import java.io.Serializable;import java.util.Date;public class ProductType implements Serializable{    private static final long serialVersionUID = 1L;    private Integer id;    private String name;    /**排序号*/    private Integer sort;    /**分类的父类id*/    private Integer parentId;    private String note;    private Date createdTime;    private Date modifiedTime;    private String createdUser;    private String modifiedUser;    public Integer getId() {        return id;    }    public void setId(Integer id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public Integer getSort() {        return sort;    }    public void setSort(Integer sort) {        this.sort = sort;    }    public Integer getParentId() {        return parentId;    }    public void setParentId(Integer parentId) {        this.parentId = parentId;    }    public String getNote() {        return note;    }    public void setNote(String note) {        this.note = note;    }    public Date getCreatedTime() {        return createdTime;    }    public void setCreatedTime(Date createdTime) {        this.createdTime = createdTime;    }    public Date getModifiedTime() {        return modifiedTime;    }    public void setModifiedTime(Date modifiedTime) {        this.modifiedTime = modifiedTime;    }    public String getCreatedUser() {        return createdUser;    }    public void setCreatedUser(String createdUser) {        this.createdUser = createdUser;    }    public String getModifiedUser() {        return modifiedUser;    }    public void setModifiedUser(String modifiedUser) {        this.modifiedUser = modifiedUser;    }    @Override    public String toString() {        return "ProductType [id=" + id + ", name=" + name + ", sort=" + sort + ", parentId=" + parentId + ", note="                + note + ", createdTime=" + createdTime + ", modifiedTime=" + modifiedTime + ", createdUser="                + createdUser + ", modifiedUser=" + modifiedUser + "]";    }}

2.构建产品分类数据访问层对象ProductTypeDao

public interface ProductTypeDao {     List<Map<String,Object>>             findObjects();}<mapper namespace="cn.tedu.ttms.product.dao.ProductTypeDao">    <!-- 查询所有分类及这个分类的父类名称 -->    <select id="findObjects"            resultType="map">         <!-- 方案1 -->         select c.*,p.name parentName         from tms_classes c left join tms_classes p         on c.parentId=p.id         <!--  方案2         select c.*,         (select name parentName           from tms_classes p           where c.parentId=p.id)         from tms_classes c         -->    </select></mapper>

3.service实现类

@Servicepublic class ProductTypeServiceImpl implements ProductTypeService {    @Autowired    private ProductTypeDao productTypeDao;    @Override    public List<Map<String, Object>> findObjects() {        return productTypeDao.findObjects();    }}

4.构建产品分类控制层对象ProductController

@Controller@RequestMapping("/type/")public class ProductTypeController {     @Autowired     private ProductTypeService productTypeService;     @RequestMapping("listUI")     public String listUI(){         return "product/type_list";     }     @RequestMapping("doFindObjects")     @ResponseBody     public JsonResult doFindObjects(){         return new JsonResult(         productTypeService.findObjects());     }}

5.构建产品分类type_list.js的实现

$(function(){     $("#queryFormId")    .on("click",".btn-search",doQueryObjects);    doGetObjects();});function doQueryObjects(){    //1.初始化当前页码    $("#pageId").data("pageCurrent",1);    //2.执行查询操作    doGetObjects();}function doGetObjects(){    //初始化url    var url="team/doFindPageObjects.do?t="+Math.random();    //初始化参数对象    var params={name:$("#searchNameId").val()};//object     var pageCurrent=$("#pageId").data("pageCurrent");    if(!pageCurrent)pageCurrent=1;    //params.pageCurrent=pageCurrent;    params['pageCurrent']=pageCurrent;//{page-Current:1}    //发送异步启动获取分页数据    $.post(url,params,function(result){//JsonResult          if(result.state==1){            //1.tbodyId对应位置显示team信息              setTableBodyRows(result.data.list)            //2.设置分页信息              setPagination(result.data.pageObject);          }else{              alert(result.message);          }    });} function setTableBodyRows(list){    //1.获得tbodyId对应的对象     var tBody=$("#tbodyId");     tBody.empty();    //2.迭代list集合(多个team记录信息)     for(var i in list){        //2.1 创建 tr 对象         var tr=$("<tr></tr>");        tr.data("id",list[i].id);//可选(看业务)        //2.2 创建tds串        var tds="<td><input type='checkbox' name='checkdId' value='"+list[i].id+"'></td>"+        "<td>"+list[i].name+"</td>"+        "<td>"+list[i].projectName+"</td>"+        "<td>"+(list[i].valid?'启用':'禁用')+"</td>"+        "<td><input type='button' class='btn btn-default btn-update' value='修改'></td>";        //2.3将td追加到tr对象        tr.append(tds);        //2.4将tr追加到tBody中        tBody.append(tr);     } }