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.PersonBean"/>
<%
	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="#000000">标志编号</font></B></CENTER></TD>
    <TD >
      <CENTER><B><font color="#000000">姓名</font></B></CENTER></TD>
    <TD>
      <CENTER><B><font color="#000000">固定电话号码</font></B></CENTER></TD>
    <TD>
      <CENTER><B><font color="#000000">手机号码</font></B></CENTER></TD>
    <TD>
      <CENTER><B><font color="#000000">小灵通号码</font></B></CENTER></TD>
	<TD>
      <CENTER><B><font color="#000000">电子邮件</font></B></CENTER></TD>
    
      <td><CENTER><B><font color="#000000">操作</font></B></CENTER></TD>

	  
	  </TR>

  <TR bgColor=#ffffff>
    <TD colSpan=7 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();
	for(int i=0;i<vect.size();i++)
	{
		if ((i%2)==0) { 
			bgcolor="#CCCCCC";
		}else {
			bgcolor="#ffffff";
		}
		Hashtable hash = (Hashtable)vect.get(i);	
		String strID1 = (String)hash.get("PERSONID");
  %>

  <TR bgColor="<%=bgcolor%>">
    <TD align=center width=60><%=strID1%></TD>
    <TD align=center width=60><%=hash.get("PERSONNAME")%></TD>
    <TD align=center width=80><%=hash.get("TELENO")%></TD>
    <TD align=center width=80><%=hash.get("MOBILENO")%></TD>
    <TD align=center width=80><%=hash.get("PASNO")%></TD>
	<TD ><%=hash.get("EMAILADDRESS")%></TD>
	<TD align=center width=80>
	<FONT color="#0000CC">
		<A onclick="edit('<%=strID1%>');" style="cursor:hand;">修改</A>&nbsp;|
		<A onclick="del('<%=strID1%>');" style="cursor:hand;">删除</A>
	</FONT></TD>

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

	function edit(id)
	{
		document.all.txt_type.value = "1";
		document.all.txt_id.value = id;
		document.all.txt_edit.value = "4";
		document.all.form1.action = "index.jsp";
		document.all.form1.submit();
	}

	function del(id)
	{
		if(!confirm("是否真的要删除？"))
		{
		}
		else
		{
			document.all.txt_type.value = "1";
			document.all.txt_id.value = id;
			document.all.txt_edit.value = "5";
			document.all.form1.action = "../PersonServlet";
			document.all.form1.submit();
		}
	}
</script>
<%
	myBean.closeConn();
%>