7,713
社区成员
发帖
与我相关
我的任务
分享
'如果描述不是很清楚的话可以参考这段VB代码,返回书的标签是否符合搜索标签
Function matchTag(ByVal bookTag As String, ByVal searchTag As String) As Boolean
Dim bookT, searchT, found As Boolean
bookT = Split(bookTag, "|")
'把书本的标签根据“|”分割成数组
searchT = Split(searchTag, "|")
'把搜索的标签根据“|”分割成数组
For i = 0 To UBound(searchT)
'遍历一遍搜索的标签,寻找图书关键字中是否有匹配的标签
found = False
'初始值为没有找到
For j = 0 To UBound(bookT)
'遍历一遍图书的标签
If (bookT(j) = searchT(i)) Then
'匹配图书的标签和搜索的标签
found = True: Exit For
'找到了,跳过当前For,继续匹配下一个搜索标签
End If
Next
If (Not (found)) Then matchTag = False: Exit Function
'要是没有找到就返回false
Next
matchTag = True: Exit Function
'执行到这一步说明全部找到,返回True
End Function
rs.open "select * from bookTable",db,1,3
while not(rs.eof)
if(matchTag(rs("booktag"),request("searchTag"))) then
response.write("图书编号:" & rs("BookID") & "<br>")
end if
rs.movenext
wend