📄 clientinfo.jsp
字号:
<%--
模块名称：客户管理
模块功能：客户介绍
版 本：V1.0
著 作 人：蔡静
著作日期：2001-10-08
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：
= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
String customer_id = request.getParameter("customer_id");
String link_man, customer_name, enter_date, telephone, mobile_telephone;
String fax, email, customer_type, lawyer_id, address, customer_introduce;
String sql = "select link_man, customer_name, enter_date, telephone,";
sql = sql + "mobile_telephone, fax, email, customer_type, lawyer_id, address,";
sql = sql + "customer_introduce from t_customer where customer_id='";
sql = sql + customer_id + "'";
ResultSet rs = db.executeQuery(sql);
if (rs.next()) {
link_man = rs.getString("link_man");
customer_name = rs.getString("customer_name");
enter_date = rs.getString("enter_date");
telephone = rs.getString("telephone");
mobile_telephone = rs.getString("mobile_telephone");
fax = rs.getString("fax");
email = rs.getString("email");
customer_type = rs.getString("customer_type");
lawyer_id = rs.getString("lawyer_id");
address = rs.getString("address");
customer_introduce = rs.getString("customer_introduce");
%>
<html>
<head>
<title>顾问单位介绍</title>
<%@ include file="../inc/config.jsp" %>
</head>
<body class="page">
<!--显示工具条-->
<table width="98%" align="center" cellspacing="1">
<tr>
<td width="90%"><a href="Client.jsp"><img src="../images/all.gif" height="22" border="0" width="88"></a>
<a href="ClientAdd.jsp"><img src="../images/add.gif" alt="增加内容" width="79" height="22" border="0" ></a>
<img src="../images/delete.gif" alt="删除选中的内容" style="cursor:hand" width="79" height="22">
<a href="ClientSearch.jsp"><img src="../images/query.gif" alt="查询内容" width="79" height="22" border="0"></a></td>
<td width="10%" align="right"><img src="../images/back.gif" width="50" height="22" onClick="window.history.back()" style="cursor:hand"></td>
</tr>
</table>
<table width="98%" background="../images/line.gif" border="0" cellspacing="0" cellpadding="0" height="12" align="center">
<tr>
<td> </td>
</tr>
</table>
<!--显示工具条结束-->
<table width="98%" align="center" border="0" cellspacing="1" cellpadding="0" class="table_bg">
<tr>
<td height="24" width="19%" align="right" class="title_bg"> 客户编号：</td>
<td height="24" width="32%" class="tr_bg1"><%=customer_id%></td>
<td height="24" width="17%" align="right" class="title_bg"> 联系人：</td>
<td height="24" width="32%" class="tr_bg1">
<%
if (link_man != null)
out.print(link_man);
%>
</td>
</tr>
<tr>
<td align="right" height="28" width="19%" class="title_bg"> 客户名称：</td>
<td height="28" width="32%" class="tr_bg1">
<%
if (customer_name != null)
out.print(customer_name);
%>
</td>
<td align="right" height="28" width="17%" class="title_bg">登记时间： </td>
<td height=28 width=32% class="tr_bg1">
<%
if (enter_date != null)
out.print(enter_date.substring(0,10));
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 电话：</td>
<td height=28 width=32% class="tr_bg1">
<%
if (telephone != null)
out.print(telephone);
%>
</td>
<td align="right" height="28" width="17%" class="title_bg"> 手机：</td>
<td height=28 width=32% class="tr_bg1">
<%
if (mobile_telephone != null)
out.print(mobile_telephone);
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 传真：</td>
<td height=28 width=32% class="tr_bg1">
<%
if (fax != null)
out.print(fax);
%>
</td>
<td align=right height=28 width=17% class="title_bg"> E-mail：</td>
<td height=28 width=32% class="tr_bg1" >
<%
if (email != null)
out.print("<a href=\"mailto:mszhang@xoceco.com.cn\">"+email+"</a>");
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 客户类型：</td>
<td height=28 width=32% class="tr_bg1">
<%
if (customer_type != null) {
if (customer_type.equals("zf"))
out.print("政府");
if (customer_type.equals("gq"))
out.print("国企");
if (customer_type.equals("sz"))
out.print("三资");
if (customer_type.equals("my"))
out.print("民营");
if (customer_type.equals("gr"))
out.print("个人");
if (customer_type.equals("qt"))
out.print("其他");
}
%>
</td>
<td align=right height=28 width=17% class="title_bg"> 承办律师：</td>
<td height=28 width=32% class="tr_bg1" >
<%
if ((lawyer_id != null) && (!lawyer_id.equals(""))) {
String sql1 = "select employee_name from t_employee where";
sql1 = sql1 + " employee_id = '" + lawyer_id + "'";
ResultSet rs1 = db.executeQuery(sql1);
if (rs1.next())
out.print(rs1.getString("employee_name"));
}
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg">地址：</td>
<td height=28 class="tr_bg1" colspan="3">
<%
if (address != null)
out.print(address);
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg">客户简介：</td>
<td colspan=4 height=28 class="tr_bg1">
<%
if (customer_introduce != null)
out.print(customer_introduce);
%>
</td>
</tr>
</table>
<br>
</body>
</html>
<%}%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -