c_customer_detail.jsp
上传用户:zghglow
上传日期:2022-08-09
资源大小:27227k
文件大小:4k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

JavaScript

  1. <%@ page contentType="text/html;charset=gb2312"%> 
  2. <%@include file="../include/checkadmin.jsp"%>
  3. <%@page import="java.sql.*"%>
  4. <%@include file="../include/db_conn.jsp"%>
  5. <%@include file="../include/const.jsp"%>
  6. <%@include file="../include/isNotInteger.jsp"%>
  7. <HTML>
  8. <HEAD>
  9. <TITLE>+ + 翔鹭石化 + +</TITLE>
  10. <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
  11. <link href="../style.css" rel="stylesheet" type="text/css">
  12. </HEAD>
  13. <BODY BGCOLOR=#CFE7F3 vlink="#666666" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 >
  14. <%!String c_KUNNR;%>
  15. <%!String c_NAME1;%>
  16. <%!String c_STREET;
  17.    String c_TELF1;
  18.    String c_KNAME1;
  19.    String c_STREET1;
  20.    String c_PSTLZ;
  21.    Date c_ERDAT;
  22.    Time c_ERZET;
  23. %>
  24. <%
  25.  String admin_username;
  26.  admin_username = (String)session.getAttribute("admin_username");
  27.  sql="SELECT KUNNR,NAME1,STREET,TELF1,KNAME1,STREET1,PSTLZ,ERDAT,ERZET FROM ZSD_KNA1 where KUNNR="+admin_username;
  28.  rs=smt.executeQuery(sql);
  29. while(rs.next()){
  30. c_KUNNR =rs.getString("KUNNR");
  31. c_NAME1      =rs.getString("NAME1");
  32. c_STREET =rs.getString("STREET");
  33. c_TELF1 = rs.getString("TELF1");
  34. c_KNAME1 = rs.getString("KNAME1");
  35. c_STREET1 = rs.getString("STREET1");
  36. c_PSTLZ = rs.getString("PSTLZ");
  37. c_ERDAT = rs.getDate("ERDAT");
  38. c_ERZET = rs.getTime("ERZET");
  39. }
  40. rs.close();
  41. rs.close();
  42. smt.close();
  43. conn.close();
  44. %>
  45. <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  46.         <tr> 
  47.           <img src="../images/in1p_CRM1.gif" width="778" height="90"></td>
  48.         </tr>
  49.   <tr> 
  50.     <td width="26" height="26"><img src="../images/indl1.gif" width="26" height="26"></td>
  51.     <td width="165" height="26"><img src="../images/in1t2.gif" width="165" height="26"></td>
  52.     <td height="26" align="right"><img src="../images/in1tblk.gif" width="585" height="26"></td>
  53.   </tr>
  54.  
  55. </table>
  56. <table width="778" height="300" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  57.   <tr> 
  58.     <td width="190" align="right" valign="top" bgcolor="f0f0f0">
  59. <!--子目录-->
  60. <%@include file="s2menu.jsp"%>
  61. <!--子目录-->
  62.  </td>
  63.     <td align="center" valign="top">
  64.         <table width="80%">
  65.   <tr>
  66.     <td >
  67.   <p align="center"><strong><font size="+2"><%=c_NAME1%></font></strong></p>
  68. </td>
  69.   </tr>
  70. </table>
  71.         <table width="80%">
  72.   <tr>
  73.     <td >
  74.   <p align="center"><strong><font size="3">基本信息</font></strong></p>
  75. </td>
  76.   </tr>
  77. </table>
  78.      <br>
  79.      <table width="85%" cellspacing="0" cellpadding="0">
  80.        <tr > 
  81.           <td><font color="#0033FF" size="+1"><strong>客户编号:</strong></font>
  82.  <font size="+1"><%=c_KUNNR%></font></td>
  83.        </tr>
  84.        <tr> 
  85.             <td><font color="#0033FF" size="+1"><strong>客户名称:</strong></font>
  86. <font size="+1"><%=c_NAME1%></font> </td>
  87.        </tr>
  88.        <tr> 
  89.          <td><font color="#0033FF" size="+1"><strong>客户地址:</strong></font>
  90. <font size="+1"><%=c_STREET%></font></td>
  91.         </tr>
  92.        <tr> 
  93.          <td><font color="#0033FF" size="+1"><strong>客户电话:</strong></font>
  94. <font size="+1"><%=c_TELF1%></font></td>
  95.         </tr>
  96.        <tr> 
  97.          <td><font color="#0033FF" size="+1"><strong>联 系 人:</strong></font>
  98. <font size="+1"><%=c_KNAME1%></font></td>
  99.         </tr>
  100.        <tr> 
  101.          <td><font color="#0033FF" size="+1"><strong>联系地址:</strong></font>
  102. <font size="+1"><%=c_STREET1%> </font></td>
  103.         </tr>
  104.        <tr> 
  105.          <td><font color="#0033FF" size="+1"><strong>邮政编码:</strong></font>
  106. <font size="+1"><%=c_PSTLZ%></font></td>
  107.         </tr>
  108.      </table>
  109.  <br><br><br>
  110.    <table width="85%" cellspacing="0" cellpadding="0">
  111.        <tr> 
  112.         <td><font color="#0033FF" size="+1"><strong>最后更新时间:</strong></font><font size="+1"><%=c_ERDAT%> <%=c_ERZET%></font></td>
  113.        </tr>    
  114.      </table>  
  115.  
  116.      </td>
  117.   </tr>
  118. </table>
  119. <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#999999">
  120.   <tr> 
  121.     <td><img src="../images/spacer.gif" width="1" height="1"></td>
  122.   </tr>
  123. </table>
  124. <%@include file="../include/bottom02.jsp"%>
  125. </BODY>
  126. </HTML>