很菜的有关问题,无法全文搜索.请帮忙!
日期：2014-05-17 浏览次数：20868 次
很菜的问题,无法全文搜索...请帮忙!!
<!--#include file= "conn.asp "-->
<link href= "css/css.css " rel= "stylesheet " type= "text/css " />
<%
'建立CONNECTION对象并打开数据库
set sql=server.createobject( "ADODB.CONNECTION ")
sql.open.con %>
<% '创建Recordset对象的例程，打开Recordset对象传递SQL串以及所有的连接信息%>
<% set rs=server.createobject( "ADODB.Recordset ")
sql= "select * from products where " & name & " like '% " & tel & "% ' "
rs.open sql,conn,1,3
' 建立查询后的显示信息和查询页面,你想取什么名字都可以
%>
<html> <head> <title> 查询结果 </title> </head>
<body bgcolor= "#ffffff ">
<p align= "center "> <br>
"统计查询共有 <% Response.Write(RS.RecordCount) %> 条纪录 </p> <br>
<div align= "center "> <center>
<table border= "1 " align= "center " bordercolor= "000000 " berdorcoorlight= "#000000 " bordercolordark= "#ffffff ">
<tr align= "center ">
<td width= "20% " align= "center " bgcolor= "#ffffff "> ID </td>
<td width= "60% " align= "center " bgcolor= "#ffffff "> 姓名 </td>
<td width= "20% " align= "center " bgcolor= "#ffffff "> 电话 </td> </table>
<table border= "1 " align= "center " bordercolor= "000000 " berdorcoorlight= "#000000 " bordercolordark= "#ffffff ">
<tr align= "center ">
<!--从数据库提取信息-->
&
<!--#include file= "conn.asp "-->
<link href= "css/css.css " rel= "stylesheet " type= "text/css " />
<%
'建立CONNECTION对象并打开数据库
set sql=server.createobject( "ADODB.CONNECTION ")
sql.open.con %>
<% '创建Recordset对象的例程，打开Recordset对象传递SQL串以及所有的连接信息%>
<% set rs=server.createobject( "ADODB.Recordset ")
sql= "select * from products where " & name & " like '% " & tel & "% ' "
rs.open sql,conn,1,3
' 建立查询后的显示信息和查询页面,你想取什么名字都可以
%>
<html> <head> <title> 查询结果 </title> </head>
<body bgcolor= "#ffffff ">
<p align= "center "> <br>
"统计查询共有 <% Response.Write(RS.RecordCount) %> 条纪录 </p> <br>
<div align= "center "> <center>
<table border= "1 " align= "center " bordercolor= "000000 " berdorcoorlight= "#000000 " bordercolordark= "#ffffff ">
<tr align= "center ">
<td width= "20% " align= "center " bgcolor= "#ffffff "> ID </td>
<td width= "60% " align= "center " bgcolor= "#ffffff "> 姓名 </td>
<td width= "20% " align= "center " bgcolor= "#ffffff "> 电话 </td> </table>
<table border= "1 " align= "center " bordercolor= "000000 " berdorcoorlight= "#000000 " bordercolordark= "#ffffff ">
<tr align= "center ">
<!--从数据库提取信息-->
&
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
