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

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

开发平台:

JavaScript

  1. <%@ page contentType="text/html;charset=gb2312"%> 
  2. <%@page import="java.sql.*"%>
  3. <%@include file="../include/checkadmin.jsp"%>
  4. <%@include file="../include/db_conn.jsp"%>
  5. <%@include file="../include/css.jsp"%>
  6. <%@include file="../include/const.jsp"%>
  7. <%!String c_id;%>
  8. <%!String c_KUNNR;%>
  9. <%!String c_NAME1;%>
  10. <%!String c_STREET;
  11.    String c_TELF1;
  12.    String c_KNAME1;
  13.    String c_STREET1;
  14.    String c_PSTLZ;
  15.    Date c_ERDAT;
  16.    Time c_ERZET;
  17. %>
  18. <%!Date news_date;%>
  19. <%
  20. int intReviewNum; //评论记录总数
  21. c_id=request.getParameter("c_id");
  22. if(c_id==null){
  23. //
  24. }
  25. sql="SELECT KUNNR,NAME1,STREET,TELF1,KNAME1,STREET1,PSTLZ,ERDAT,ERZET FROM ZSD_KNA1 where c_id="+c_id;
  26. rs=smt.executeQuery(sql);
  27. while(rs.next()){
  28. c_KUNNR =rs.getString("KUNNR");
  29. c_NAME1      =rs.getString("NAME1");
  30. c_STREET =rs.getString("STREET");
  31. c_TELF1 = rs.getString("TELF1");
  32. c_KNAME1 = rs.getString("KNAME1");
  33. c_STREET1 = rs.getString("STREET1");
  34. c_PSTLZ = rs.getString("PSTLZ");
  35. c_ERDAT = rs.getDate("ERDAT");
  36. c_ERZET = rs.getTime("ERZET");
  37. }
  38. rs.close();
  39. //更新阅读次数
  40. // smt.executeUpdate("update tbl_news_content set news_hits=news_hits+1 where news_id="+news_id);
  41. //取得评论数目
  42. //sql="SELECT review_id  FROM tbl_news_review where news_id="+news_id;
  43. //rs=smt.executeQuery(sql);
  44. //rs.last();
  45. //intReviewNum=rs.getRow();
  46. //关闭数据库连接对象
  47. rs.close();
  48. smt.close();
  49. conn.close();
  50. %>
  51. <HTML>
  52. <HEAD>
  53. <TITLE>+ + 翔鹭石化 + +</TITLE>
  54. <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
  55. <link href="../style.css" rel="stylesheet" type="text/css">
  56. </HEAD>
  57. <BODY BGCOLOR=#CFE7F3 vlink="#666666" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 >
  58. <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  59.        <tr> 
  60.           <img src="../images/in1p_CRM1.gif" width="778" height="90"></td>
  61.         </tr>
  62. </table>
  63. <table width="778" height="300" align="center" cellpadding="0" cellspacing="0" bgcolor="f0f0f0">
  64.   <tr>
  65.      <td height="20"></td>
  66.   </tr>
  67.   <tr>
  68.     <td width="10%"></td>
  69. <td width="100" ></td>
  70.      <td>
  71.      <table width="100%" height="1%">
  72.        <tr > 
  73.           <td><font color="#0033FF" size="+1">客户编号:</font>
  74.  <font size="+1"><%=c_KUNNR%></font></td>
  75.        </tr>
  76.        <tr> 
  77.             <td><font color="#0033FF" size="+1">客户名称:</font>
  78. <font size="+1"><%=c_NAME1%></font> </td>
  79.        </tr>
  80.        <tr> 
  81.          <td><font color="#0033FF" size="+1">客户地址:</font>
  82. <font size="+1"><%=c_STREET%></font></td>
  83.         </tr>
  84.        <tr> 
  85.          <td><font color="#0033FF" size="+1">客户电话:</font>
  86. <font size="+1"><%=c_TELF1%></font></td>
  87.         </tr>
  88.        <tr> 
  89.          <td><font color="#0033FF" size="+1">联 系 人:</font>
  90. <font size="+1"><%=c_KNAME1%></font></td>
  91.         </tr>
  92.        <tr> 
  93.          <td><font color="#0033FF" size="+1">联系地址:</font>
  94. <font size="+1"><%=c_STREET1%> </font></td>
  95.         </tr>
  96.        <tr> 
  97.          <td><font color="#0033FF" size="+1">邮政编码:</font>
  98. <font size="+1"><%=c_PSTLZ%></font></td>
  99.         </tr>
  100.        <tr> 
  101.         <td><font color="#ff0000" size="+1">数据更新时间:<%=c_ERDAT%> <%=c_ERZET%></font></td>
  102.        </tr>
  103.       </table>
  104.     </td>
  105.    </tr>
  106.  </table>
  107. <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#999999">
  108.   <tr> 
  109.     <td><img src="../images/spacer.gif" width="1" height="1"></td>
  110.   </tr>
  111. </table>
  112. <%@include file="../include/bottom02.jsp"%>
  113. </BODY>
  114. </HTML>