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

开发平台：
JavaScript

c_customer_credit.jsp：源码内容
							<%@ page contentType="text/html;charset=gb2312"%> 
<%@include file="../include/checkadmin.jsp"%>
<%@page import="java.sql.*"%>
<%@include file="../include/db_conn.jsp"%>
<%@include file="../include/const.jsp"%>
<%@include file="../include/isNotInteger.jsp"%>
<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 >
<%!String c_01;%>
<%!String c_02;%>
<%!String c_03;
   Date c_ERDAT;
   Time c_ERZET;
%>
<%
 String admin_username;
 String customer_name="";
 //获取客户名称
 admin_username = (String)session.getAttribute("admin_username");
 sql="SELECT NAME1 FROM ZSD_KNA1 where KUNNR="+admin_username;
 //out.print(sql);
  rs=smt.executeQuery(sql);
while(rs.next()){
	customer_name =rs.getString("NAME1");
}
//获取详细数据
 sql="SELECT KUNNR,OBLIG,Waers,ERDAT,ERZET FROM ZSD_CREDIT where KUNNR="+admin_username;
 rs=smt.executeQuery(sql);
while(rs.next()){
	c_01	=rs.getString("KUNNR");
	c_02      =rs.getString("OBLIG");
	c_03	=rs.getString("Waers");
	c_ERDAT = rs.getDate("ERDAT");
	c_ERZET = rs.getTime("ERZET");
}
rs.close();
rs.close();
smt.close();
conn.close();
%>
<table width="778" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <tr> 
          <img src="../images/in1p_CRM1.gif" width="778" height="90"></td>
        </tr>
  <tr> 
    <td width="26" height="26"><img src="../images/indl1.gif" width="26" height="26"></td>
    <td width="165" height="26"><img src="../images/in1t2.gif" width="165" height="26"></td>
    <td height="26" align="right"><img src="../images/in1tblk.gif" width="585" height="26"></td>
  </tr>
 
</table>
<table width="778" height="300" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr> 
    <td width="190" align="right" valign="top" bgcolor="f0f0f0">
			<!--子目录-->
			<%@include file="s2menu.jsp"%>
			<!--子目录-->
	 </td>
    <td align="center" valign="top">
        <table width="80%">
		  <tr>
		    <td >
			  <p align="center"><strong><font size="+2"><%=customer_name%></font></strong></p>
			</td>
		  </tr>
		</table>
        <table width="80%">
		  <tr>
		    <td >
			  <p align="center"><strong><font size="3">信用额度</font></strong></p>
			</td>
		  </tr>
		</table>
	 <br><br>		
     <table width="85%" cellspacing="0" cellpadding="0">
       <tr > 
        	 <td><font color="#0033FF" size="+1"><strong>客户编号：</strong></font>
			 <font size="+1"><%=c_01%></font></td>
       </tr>
       <tr > 
        	 <td><font color="#0033FF" size="+1"><strong>客户名称：</strong></font>
			 <font size="+1"><%=customer_name%></font></td>
       </tr>	   
     </table>		
	 <br><br>
     <table width="85%" cellspacing="0" cellpadding="0">
       <tr> 
            <td><font color="#0033FF" size="+1"><strong>信用额度：</strong></font>
			<font size="+2" color="#ff0000"><%=c_02%> 元 </font><font size="+1"> (币别：<%=c_03%>)</font> </td>
       </tr>
     </table>
	 <br><br><br><br>
	 
   <table width="85%" cellspacing="0" cellpadding="0">
       <tr> 
        <td><font color="#0033FF" size="+1"><strong>最后更新时间：</strong></font><font 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>

						