树拼接--【DRP】

	/**
	 * 子叶节点前面加入一个-号，非叶子节点前面加入一个+号
	 * @param conn
	 * @param id
	 * @param level
	 * @throws SQLException
	 */
	private void readClientTree(Connection conn,int id,int level)throws SQLException{
		String sql="select * from t_client where pid=?";
		PreparedStatement pstmt=null;
		ResultSet rs=null;
		
		try {
			pstmt=conn.prepareStatement(sql);
			pstmt.setInt(1, id);
			rs =pstmt.executeQuery();
						
			while (rs.next()) {
				sbTreeHTML.append("<div>");//div开始
				sbTreeHTML.append("
");
				for(int i=0;i<level;i++){
					sbTreeHTML.append("<img src="../images/white.gif">");
					sbTreeHTML.append("
");
				}
				
			/*	sbTreeHTML.append(rs.getString("name"))
				.append("<br> 
");*/
				//如果遍历的节点是叶子节点，+名字+回车，如果不是遍历的叶子节点，-名字回车	
				//if("N".equals(rs.getString("is_leaf"))){
				if(Constants.NO.equals(rs.getString("is_leaf"))){
					sbTreeHTML.append("<img alt="展开" style="cursor:hand;" onClick="display('"+ rs.getInt("id") + "');" id="img" +rs.getInt("id")+"" src="../images/plus.gif">");
					sbTreeHTML.append("
");
					sbTreeHTML.append("<img id="im"+ rs.getInt("id") +"" src="../images/closedfold.gif">");
					sbTreeHTML.append("
");
					sbTreeHTML.append("<a href="client_node_crud.jsp" target="clientDispAreaFrame">"+rs.getString("name")+"</a>");
					sbTreeHTML.append("
");
					sbTreeHTML.append("<div style="display:none;" id="div" + rs.getInt("id")+"">");
					sbTreeHTML.append("
");
					readClientTree(conn, rs.getInt("id"), level+1);					
					sbTreeHTML.append("</div>");
					sbTreeHTML.append("
");
				}else{
					sbTreeHTML.append("<img src="../images/minus.gif">");
					sbTreeHTML.append("
");
					sbTreeHTML.append("<img src="../images/openfold.gif">");
					sbTreeHTML.append("
");
					
					if(Constants.YES.equals(rs.getString("is_client"))){
						sbTreeHTML.append("<a href="client_crud.html" target="clientDispAreaFrame">" +rs.getString("name") + "</a>");
					}else{
						sbTreeHTML.append("<a href="client_node_crud.jsp" target="clientDispAreaFrame">"+rs.getString("name")+"</a>");
					}
					sbTreeHTML.append("
");
				}
				sbTreeHTML.append("</div>");//div结束
				sbTreeHTML.append("
");
			}
		}finally {
			DbUtil.close(rs);
			DbUtil.close(pstmt);
		}
	}

静态类：

/**
 * 
 */
package com.bjpowernode.drp.util;


/**
 * @ClassName:Constants
 * @Description:系统公用常量
 * @author wm
 * @date 2016年1月1日下午4:14:41
 */
public class Constants {

		public static final String NO="N";
		public static final String YES="Y";
			
		
}

jsp页面：

<%@ page language="java" contentType="text/html; charset=GB18030"
    pageEncoding="GB18030"%>
 <%@page import="com.bjpowernode.drp.basedata.manager.*" %>
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
		<link rel="stylesheet" href="../style/drp.css">
		<style type="text/css">
<!--
a:link {
	text-decoration: none;
	color: #000000;
	font-size: 9pt;
	font-family: 宋体;
}
a:visited {
	text-decoration: none;
	color: #000000;
	font-size: 9pt;
	font-family: 宋体;
	
}
a:hover {
	text-decoration: none;
	color: #000000;
	font-size: 9pt;
	font-family: 宋体;

}
a:active {
	text-decoration: none;
	color: #000000;
	font-size: 9pt;
	font-family: 宋体;
}
-->
</style>

<script language="JavaScript">
<!--
function display(id) {
	 eval("var div=div"+id);
	 eval("var img=img"+id);
	 eval("var im=im"+id);
	 div.style.display=div.style.display=="block"?"none":"block";
	 img.src=div.style.display=="block"?"../images/minus.gif":"../images/plus.gif";
	 im.src=div.style.display=="block"?"../images/openfold.gif":"../images/closedfold.gif";
	 img.alt=div.style.display=="block"?"关闭":"展开";
}
//-->
</script>
	</head>
	<body class="body1">
		<table>
			<tr>
				<td valign="top" nowrap="nowrap">
					<%=ClientManager.getInstance().ClientManager() %>
				</td>
			</tr>
		</table>
	</body>
</html>

<%= %>获取页面上变量的值

调用的类：

/**
 * 
 */
package com.bjpowernode.drp.basedata.manager;

import com.bjpowernode.drp.basedata.domain.Client;


/**
 * @ClassName:ClientManager
 * @Description:采用单例实现
 * @author wm
 * @date 
 */
public class ClientManager {
	
	 //静态类
	 private static ClientManager instance=new ClientManager();
	 //私有构造函数
	 private ClientManager(){
		 
	 }
	 //静态方法
	 public  static ClientManager getInstance() {
		 return instance;		
	}
	/**
	 * 
	 */
	@SuppressWarnings(value = "all")
	public String ClientManager() {
		return new ClientTreeReader().getClientTreeHTMLString();
	}
	/**
	 * 根据id查询分销商和区域
	 * @param id
	 * @return 如果存在返回client对象，否则返回null
	 */
	public Client findClientOrRegionById(int id){
		return null;
	}
	
	

}

页面树结构，虽然不能支持增删改的同步，但是能实现不同的节点不一样的显示。img1 im1 div1 ，如果是父节点，显示+号，名字，回车；如果不是遍历的叶子节点，-号，名字，回车。