address.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="config.jsp"%>
<%
		String chushi=(String)request.getParameter("chushi");
		if(chushi==null)
			chushi="";
		String bumen=(String)request.getParameter("bumen");
		if(bumen==null)
			bumen="";
		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 bumenmingcheng from unit";
		ResultSet rs = null;
		rs = st.executeQuery(unitSql);
		int p=0;   //计算在哪一页显示
		int t=0;
		while(rs.next()){
			Element element = root.addElement("unit");
			String unit = rs.getString("bumenmingcheng");
			element.addAttribute("name", unit);	
			if(!bumen.equals("")  && expand.equals("true") && bumen.equals(unit))	{
				p=t;
				element.addAttribute("expand", "false");
			}		
			else if (!bumen.equals("")  && expand.equals("false") && bumen.equals(unit)){
				p=t;
				element.addAttribute("expand", "true");
			}	
			else
				element.addAttribute("expand", "false");
			t++;
		}
		p=p/20;
		if(expand.equals("false") ||(!bumen.equals("")  && expand.equals("true") && !chushi.equals(""))){ //填充判断

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

		for(int i=0;i<list.size();i++){
			Element node = (Element) list.get(i);
			String unit = node.attributeValue("name");
			if(unit.equals(bumen)){
			String departSql =  "select depart from depart where unit = '"+unit+"'";
			//ResultSet 
				rs = st.executeQuery(departSql);
			while(rs.next()){
				Element element = node.addElement("depart");
				String depart = rs.getString("depart");
				element.addAttribute("name",depart );	
				element.addAttribute("parent", element.getParent().attributeValue("name"));
					if(!bumen.equals("")  && expand.equals("true") && chushi.equals(depart))	
						element.addAttribute("expand", "false");
					else if (!bumen.equals("")  && expand.equals("false") && chushi.equals(depart))
						element.addAttribute("expand", "true");
					else
						element.addAttribute("expand", "false");
			
				}
			}
		}
		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 = node.attributeValue("name");
			String unit = node.getParent().attributeValue("name");
			//System.out.println(unit);
			if(depart.equals(chushi)){
			String departSql =  "select * from address where unit = '"+unit+"' and depart = '"+depart+"'";
				rs = st.executeQuery(departSql);
			while(rs.next()){
				Element element = node.addElement("person");
				element.addAttribute("name", rs.getString("NAME"));	
				element.addAttribute("code", rs.getString("CODE"));	
				element.addAttribute("company", rs.getString("COMPANY"));
				element.addAttribute("unit", rs.getString("UNIT"));	
				element.addAttribute("depart", rs.getString("DEPART"));	
				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"));
					}
				}
			}

		}

	}

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>

<style type="text/css">


#Content {
        width: 425px;
        height: 360px;
        margin: 10px 10px 0px 10px;
        _margin: 10px 5px 0px 5px; /* CSS Hack For IE6 */
        overflow: hidden;
        text-align: left;
}
#Pages {
        width: 445px;
        height: 20px;
        margin: 0px;
        text-align: right;
}
</style>

<script defer="defer" language="javascript" type="text/javascript">
<!--
        var _offset = 0;
        function _$id(_obj) {
				
                return document.getElementById(_obj);
        }
        function _$Pages(_i) {
                _$id("Content").scrollTop = (_$id("Content").clientHeight*_i);
        }
        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%>);

alert("<%=p%>");
//--> 
</script>
 </HEAD>
 <BODY onload="_$InitPages();">
<div id="Content">
<%
out.println(transformedDoc.asXML());
%>
</div>
<div id="Pages"></div>
</BODY>
</HTML>


<%
rs.close();
st.close();
con.close();
%>