expand.jsp

此程序为纯jsp实现通讯录功能

<%@ page contentType="text/html;charset=GBK" language="java" %>
<%@ page  import="java.sql.*,java.util.*,java.io.*,javax.xml.transform.*,org.dom4j.*,org.dom4j.io.*,javax.xml.transform.stream.StreamSource" %>
<%@ include file="conn.jsp"%>
<%@ include file="sso.jsp"%>
<%
		String departid=(String)request.getParameter("depart_id");
		if(departid==null)
			departid="";
		String unitid=(String)request.getParameter("unit_id");
		if(unitid==null)
			unitid="";
		String expand =(String)request.getParameter("expand");
		if(expand==null)
			expand="false";



		Document document = DocumentHelper.createDocument();
		document  =  document.addProcessingInstruction("xml-stylesheet","type=\"text/xsl\"");   
		document.setXMLEncoding("GBK");
		Element root = document.addElement("root");              //填充部门
		String unitSql = "select t.org_id,t.org_name from txl_org t where t.org_level = '2'";
		ResultSet rs = null;
		rs = st.executeQuery(unitSql);
		int p=0;    //计算在哪一页显示
		int r=0;    //计数变量
		int s=0;    //计数变量
		while(rs.next()){
			Element element = root.addElement("unit");
			String unit = rs.getString("org_name");
			String unit_id = rs.getString("org_id");
			element.addAttribute("name", unit);	
			element.addAttribute("unit_id", unit_id);
			if(!unitid.equals("")  && expand.equals("true") && unitid.equals(unit_id))	{
				p=p+r;
				element.addAttribute("expand", "false");
			}		
			else if (!unitid.equals("")  && expand.equals("false") && unitid.equals(unit_id)){
				p=p+r;
				element.addAttribute("expand", "true");
			}	
			else
				element.addAttribute("expand", "false");
			r++;
		}
		

		for(int i=0;i<15;i++){ //空白填充
			Element element = root.addElement("unit");
			element.addAttribute("name", "");
			element.addAttribute("unit_id", "");
		}

	if(expand.equals("false") ||(!unitid.equals("")  && expand.equals("true") && !departid.equals(""))){ //填充判断

		List list = null;                //填充处室
		list = document.selectNodes("//unit");

			for(int i=0;i<list.size();i++){
			Element node = (Element) list.get(i);
			String unit_id = node.attributeValue("unit_id");
			
			String departSql =  "select * from txl_org t where t.org_level = '3' and t.upper_org_id = '" + unit_id +"'";
			//ResultSet 
				rs = st.executeQuery(departSql);
		while(rs.next()){
				Element element = node.addElement("depart");
				String depart = rs.getString("org_name");
				String depart_id = rs.getString("org_id");
				element.addAttribute("name",depart );
				element.addAttribute("depart_id",depart_id);
				element.addAttribute("parent", element.getParent().attributeValue("unit_id"));
					if(!unitid.equals("")  && expand.equals("true") && departid.equals(depart_id)){
						element.addAttribute("expand", "false");
						p=p+s;
					}	
					
					else if (!unitid.equals("")  && expand.equals("false") && departid.equals(depart_id)){
						element.addAttribute("expand", "true");
						p=p+s;
					}
						
					else
						element.addAttribute("expand", "false");
					s++;
				
				}
			
		}
		if(expand.equals("false")){ //填充判断

		list = document.selectNodes("//unit/depart");    //填充人员
		for(int i=0;i<list.size();i++){
			Element node = (Element) list.get(i);
			String depart_id = node.attributeValue("depart_id");
			String unit_id = node.getParent().attributeValue("unit_id");
			//System.out.println(unit);
			
			String departSql =  "select * from txl_view t where t.unit_ID='"+unit_id+"' and t.depart_id= '"+depart_id+"'";
			//System.out.println(departSql);
				rs = st.executeQuery(departSql);
			while(rs.next()){
				Element element = node.addElement("person");
				element.addAttribute("id", rs.getString("ID"));	
				element.addAttribute("unit_id", rs.getString("unit_id"));	
				element.addAttribute("depart_id", rs.getString("depart_id"));	
				element.addAttribute("name", rs.getString("NAME"));	
				element.addAttribute("code", rs.getString("CODE"));	
				element.addAttribute("company", rs.getString("COMPANY_NAME"));
				element.addAttribute("unit", rs.getString("UNIT_NAME"));	
				element.addAttribute("depart", rs.getString("DEPART_NAME"));	
				element.addAttribute("post", rs.getString("POST"));
				element.addAttribute("roomid", rs.getString("ROOMID"));	
				element.addAttribute("phone", rs.getString("PHONE"));
				element.addAttribute("extension", rs.getString("EXTENSION"));
				element.addAttribute("mobile", rs.getString("MOBILE"));
				element.addAttribute("email", rs.getString("EMAIL"));
				element.addAttribute("fax", rs.getString("FAX"));
				element.addAttribute("zip", rs.getString("ZIP"));
				element.addAttribute("address", rs.getString("ADDRESS"));
				element.addAttribute("remark", rs.getString("REMARK"));
				element.addAttribute("tdno", rs.getString("TDNO"));
				//element.addAttribute("parent", element.getParent().attributeValue("name"));
					}
				}
			}

		

	}

p=p/20; //计算显示在哪页
//	System.out.println(p);
TransformerFactory factory = TransformerFactory.newInstance();
Transformer transformer = factory.newTransformer(new StreamSource(new File("address.xsl")));
DocumentSource source = new DocumentSource(document);
DocumentResult result = new DocumentResult();
transformer.transform(source, result);
Document transformedDoc = result.getDocument();
//out.println(document.asXML());
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
<LINK href="style.css" type="text/css" rel="stylesheet">
<script defer="defer" language="javascript" type="text/javascript">
<!--
        var _offset = 0;
		var page = 0;
        function _$id(_obj) {
				
                return document.getElementById(_obj);
        }
        function _$Pages(_i) {
                _$id("Content").scrollTop = (_$id("Content").clientHeight*_i);
				page = _i;
			//	alert(page);
        }
		function pgup(){		//上翻页
				if(!page==0){
					page--;
				}
				
				_$id("Content").scrollTop = (_$id("Content").clientHeight*page);
	
		}
		function pgdn(){		//下翻页
				_offset = _$id("Content").clientHeight;
				//alert(1==Math.floor(_$id("Content").scrollHeight/_offset));
				if(!(page==Math.floor(_$id("Content").scrollHeight/_offset)-1)){
					page++;
				}				
				_$id("Content").scrollTop = (_$id("Content").clientHeight*page);
				//alert(page);

		}
        function _$InitPages() {
               /* var _s='';
                _offset = _$id("Content").clientHeight;
                var _top = _$id("Content").scrollTop;
                for (var i=0;i<(_$id("Content").scrollHeight/_offset);i++) {
                        _s+=('<a href="javascript:void(0);" onclick="javascript:_$Pages('+i+');" onfocus="this.blur()" title="Page&nbsp;'+(i+1)+'">'+(i+1)+'</a>&nbsp;&nbsp;&nbsp;&nbsp;');
                }
                _$id("Pages").innerHTML=_s;*/
				_$Pages(<%=p%>); //定位页数
				
        }

//--> 
</script>
 </HEAD>
 <BODY onload="_$InitPages();">
 <!--BODY-->
 <form action="search.jsp" method="post">
<table border="0" width = "100%">
            <tr bgcolor = "#ffe3bb">
                <td style="height=20;BORDER-bottom:#FF9900 1px solid" colspan="9">
                    <font id="User">集团公司人员通讯录</font>
                </td>
           </tr>
          <tr>
               <td style="height=20;BORDER-bottom:#FF9900 1px solid" colspan="9">
               <table>
                  <tr>
                    <td align="center">