旅游管理系统：产品分类信息树状显示

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

##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实现类

@Service
public 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);
	 }
 }