📄 xssdq.asp
字号:
<!--#include file="../conn.inc" -->
<!--#include file="../showrs.asp" -->
<%
dq=Request("dq")
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.DQ='" & dq &"'"
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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -