list.jsp

这是一个用jsp+Oracle开发的联系人客户关系管理系统！

<%
/**********************************************************
Copyright (C),2003-10-15, Beijing  USTB.
All rights reserved.
Filename: 
Author: 
Version 1.0
Date:2003-10-15
Description:
Other:
Variable List:

Function List:

History:
***********************************************************/
%>
<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,com.util.DealString"%>
<%
	//登录超时
	if((String)session.getAttribute("zgbh")==null)
	{
		response.sendRedirect("../session.htm");
	}
%>
<jsp:useBean id="myBean" scope="page" class="com.bean.RelationBean"/>
<%
	DealString ds = new DealString();
	//取得菜单类别
	String strType = ds.toString((String)request.getParameter("txt_type"));

	//编号
	String strID = ds.toString((String)request.getParameter("txt_id"));

	//字典名称
	String strDict = ds.toString((String)request.getParameter("txt_dict"));

	//增删改类型
	String strEdit = ds.toString((String)request.getParameter("txt_edit"));

	//权限控制
	String uid = (String)session.getAttribute("zgbh");
%>

<br>
<div align=center>
<font color="#0000CC" size=3><b>客户关系列表<b></font>
</div>
<br>
<TABLE cellSpacing=1 cellPadding=5 width="95%" align=center bgColor=#999999  style="word-break:break-all;">

  <TR bgColor=#999999 height=20>
    <TD >
      <CENTER><B><font color="#ffffff">联系人姓名</font></B></CENTER></TD>
    <TD >
      <CENTER><B><font color="#ffffff">客户名称</font></B></CENTER></TD>
    
      <td><CENTER><B><font color="#ffffff">操作</font></B></CENTER></TD>

	  
	  </TR>

  <TR bgColor=#ffffff>
    <TD colSpan=3 height=15 align=right>
	<FONT color="#FF6600">
	<A onclick="add('');" style="cursor:hand;"></A>
	</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD></TR>


  <%
  
 	String bgcolor="";
	Vector vect = (Vector)myBean.getData();
	int t = 0;
	for(int i=0;i<vect.size();i++)
	{
		if ((t%2)==0) { 
			bgcolor="#CCCCCC";
		}else {
			bgcolor="#ffffff";
		}
		t++;
		Hashtable hash = (Hashtable)vect.get(i);	
		String strID1 = (String)hash.get("PERSONID");
		String strName = (String)hash.get("PERSONNAME");
		String cust = (String)hash.get("CUSTNAME");
		while(i<vect.size()-1)//还有下一条记录
		{
			Hashtable hash1 = (Hashtable)vect.get(i+1);
			String temp = (String)hash1.get("PERSONID");
			if(temp.trim().equals(strID1.trim()))
			{
				cust += "<br>"+(String)hash1.get("CUSTNAME");
				i++;
			}
			else break;
		}
  %>

  <TR bgColor="<%=bgcolor%>">
    <TD align=center width="30%"><%=strName%></TD>
	<TD><%=cust%></TD>
	<TD align=center width=110>
	<FONT color="#0000CC">
		<A onclick="edit('<%=strID1%>','<%=strName%>');" style="cursor:hand;">修改</A>
	</FONT></TD>

  </TR>
<%
	}
%>
</TABLE>
  <script>
	function edit(id,name)
	{
		document.all.txt_type.value = "1";
		document.all.txt_id.value = id;
		document.all.txt_edit.value = "1";
		document.all.txt_dict.value = name;
		document.all.form1.action = "index.jsp";
		document.all.form1.submit();
	}
</script>
<%
	myBean.closeConn();
%>