asp 查询数据库所有表中存在某个字符串
asp教程 查询数据库教程所有表中存在某个字符串
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>www.zzzyk.com教程</title>
<style>
td{
font-size:12px;
}
</style>
</head>
<body>
<table width="300" border="0" cellspacing="0" cellpadding="0">
<form id="form1" name="form1" method="post" action="getall.asp">
<tr>
<td><input name="keyword" type="text" id="keyword" />
<input type="submit" name="Submit" value="提交" /></td>
</tr>
</form>
</table>
</body>
</html>
查找代码
<!-- #include file="adoconn.asp" -->
<%
keyword=request("keyword")
On Error Resume next
Set rs=Conn.OpenSchema(20)
k=0
Do Until rs.EOF
If rs(3)="TABLE" Then
Set rs1=server.CreateObject("adodb.recordset")
tablename=rs(2)
sql="select * from ["&tablename&"]"
Set rs1=conn.execute(sql)
c=1
Do While Not rs1.eof
For i=0 To rs1.fields.count-1
key=rs1.fields(i).name
value=rs1(CStr(key))
If InStr(value,keyword)>0 Then
k=1
response.write "已经找到：表名："&tablename&"，字段名"&key&"，第"&c&"条记录，"&rs1.fields(0).name&"="&rs1(rs1.fields(0).name)&"<br>www.zzzyk.com"
End if
Next
c=c+1
rs1.movenext
loop
End If
rs.MoveNext
Loop
If k=0 Then response.write "对不起，没有找到！！！"
Set rs=Nothing
Set conn=nothing
%>
数据连接文件
<%
DB="database/myfuture_empty.mdb"
Set fso = Server.CreateObject("Scripting.FileSystemObject")
if fso.FolderExists(server.MapPath("include"))=false then
DB="../"&DB
end if
set fso=nothing
path=Server.MapPath(DB)
set conn=server.createobject("adodb.Connection")
connstr="provider=Microsoft.Jet.OLEDB.4.0;Data Source="&path
conn.Open connstr
set rs=server.CreateObject("adodb.recordset")
%>
<!-- #include file="function.asp" -->
补充：asp教程,高级应用
