customer_detail.jsp
资源名称:shihua.rar [点击查看]
上传用户:zghglow
上传日期:2022-08-09
资源大小:27227k
文件大小:3k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
JavaScript
- <%@ page contentType="text/html;charset=gb2312"%>
- <%@page import="java.sql.*"%>
- <%@include file="../include/checkadmin.jsp"%>
- <%@include file="../include/db_conn.jsp"%>
- <%@include file="../include/css.jsp"%>
- <%@include file="../include/const.jsp"%>
- <%!String c_id;%>
- <%!String c_KUNNR;%>
- <%!String c_NAME1;%>
- <%!String c_STREET;
- String c_TELF1;
- String c_KNAME1;
- String c_STREET1;
- String c_PSTLZ;
- Date c_ERDAT;
- Time c_ERZET;
- %>
- <%!Date news_date;%>
- <%
- int intReviewNum; //评论记录总数
- c_id=request.getParameter("c_id");
- if(c_id==null){
- //
- }
- sql="SELECT KUNNR,NAME1,STREET,TELF1,KNAME1,STREET1,PSTLZ,ERDAT,ERZET FROM ZSD_KNA1 where c_id="+c_id;
- rs=smt.executeQuery(sql);
- while(rs.next()){
- c_KUNNR =rs.getString("KUNNR");
- c_NAME1 =rs.getString("NAME1");
- c_STREET =rs.getString("STREET");
- c_TELF1 = rs.getString("TELF1");
- c_KNAME1 = rs.getString("KNAME1");
- c_STREET1 = rs.getString("STREET1");
- c_PSTLZ = rs.getString("PSTLZ");
- c_ERDAT = rs.getDate("ERDAT");
- c_ERZET = rs.getTime("ERZET");
- }
- rs.close();
- //更新阅读次数
- // smt.executeUpdate("update tbl_news_content set news_hits=news_hits+1 where news_id="+news_id);
- //取得评论数目
- //sql="SELECT review_id FROM tbl_news_review where news_id="+news_id;
- //rs=smt.executeQuery(sql);
- //rs.last();
- //intReviewNum=rs.getRow();
- //关闭数据库连接对象
- rs.close();
- smt.close();
- conn.close();
- %>
- <HTML>
- <HEAD>
- <TITLE>+ + 翔鹭石化 + +</TITLE>
- <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
- <link href="../style.css" rel="stylesheet" type="text/css">
- </HEAD>
- <BODY BGCOLOR=#CFE7F3 vlink="#666666" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 >
- <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
- <tr>
- <img src="../images/in1p_CRM1.gif" width="778" height="90"></td>
- </tr>
- </table>
- <table width="778" height="300" align="center" cellpadding="0" cellspacing="0" bgcolor="f0f0f0">
- <tr>
- <td height="20"></td>
- </tr>
- <tr>
- <td width="10%"></td>
- <td width="100" ></td>
- <td>
- <table width="100%" height="1%">
- <tr >
- <td><font color="#0033FF" size="+1">客户编号:</font>
- <font size="+1"><%=c_KUNNR%></font></td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1">客户名称:</font>
- <font size="+1"><%=c_NAME1%></font> </td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1">客户地址:</font>
- <font size="+1"><%=c_STREET%></font></td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1">客户电话:</font>
- <font size="+1"><%=c_TELF1%></font></td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1">联 系 人:</font>
- <font size="+1"><%=c_KNAME1%></font></td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1">联系地址:</font>
- <font size="+1"><%=c_STREET1%> </font></td>
- </tr>
- <tr>
- <td><font color="#0033FF" size="+1">邮政编码:</font>
- <font size="+1"><%=c_PSTLZ%></font></td>
- </tr>
- <tr>
- <td><font color="#ff0000" size="+1">数据更新时间:<%=c_ERDAT%> <%=c_ERZET%></font></td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- <table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#999999">
- <tr>
- <td><img src="../images/spacer.gif" width="1" height="1"></td>
- </tr>
- </table>
- <%@include file="../include/bottom02.jsp"%>
- </BODY>
- </HTML>