xssno.asp
来自「vbsql做的销售管理课程设计样本不完全仅为范例」· ASP 代码 · 共 17 行
ASP
17 行
<!--#include file="../conn.inc" -->
<!--#include file="../showrs.asp" -->
<%
id=Request("id")
set rs=Server.createobject("adodb.Recordset")
sql = "select a.CPMC as '产品名称',JG as '当前价格',KCL as '库存量', b.XSBH as '销售商编号',XSMC as '销售商名', DQ as '地区',"
sql = sql & "XSSJ as '销售时间',SL as '数量',JE as '金额' from CP a,XSS b,XSCP c where a.CPBH=c.CPBH and b.XSBH=c.XSBH and b.XSBH='" & id &"'"
rs.open sql,conn,3
showrs rs
rs.close
conn.close
%>
<html>
<body background="../img/bg-1.gif">
</body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?