📄 select_pinmu.asp
字号:
<!--#include file=inc/conn.asp-->
<style type="text/css">
<!--
a:hover { font-size: 12pt; color: #FF0000; text-decoration: underline}
a:link { font-size: 12pt; color: #006699; text-decoration: underline}
a:visited { font-size: 12pt; color: #006699; text-decoration: underline}
a:active { font-size: 12pt; color: #FF0000; text-decoration: none}
a.r1:hover { font-size: 12pt; color: #FF0000; text-decoration: underline overline}
a.r1:link { font-size: 12pt; color: #000000; text-decoration: underline overline}
a.r1:visited { font-size: 12pt; color: #99CC00; text-decoration: underline overline}
a.r1:active { font-size: 12pt; color: #000000; text-decoration: underline overline}
-->
</style>
<body bgcolor="D2E4FC">
<form name="search" method="post" action="select_pinmu.asp">
<p>查询内容:
<input type="text" name="name">
<input type="submit" name="Submit" value="查询">
</p>
</form>
<FORM METHOD=POST ACTION="">
查询结果:
<INPUT NAME="pinmu1" TYPE="text" id="pinmu1">
<INPUT TYPE="button" value="提交" onclick="window.opener.document.forms[0].pinmu.value = this.form.pinmu1.value">
<a href="javascript:window.close();">关闭</a><br>
</FORM>
<p>
<table border="1" width="100%"><tr>
<%
dim rsname,i
i=0
rsname=request("name")
rsname=Trim(request("name"))
set rs=server.CreateObject("adodb.recordset") '(建立recordset对象)
sqlstr="select * from pinmu where GOODSITEMNAME like'%"&rsname&"%' order by id desc"
'---->(message为数据库中的一个数据表⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -