<% dim wybt
if lable="" then
wybt=""
wybt2="<-小山书斋>"
Response.Redirect "http://xsw.xszw.com/shu/sc/"
if name<>"" then wybt2=name&"诗词作品"
elseif lable=1 then
wybt="唐诗三百首 -"
wybt2=""
Response.Redirect "http://xsw.xszw.com/shu/sc/ts300"
else
wybt="宋词三百首 -"
wybt2=""
Response.Redirect "http://xsw.xszw.com/shu/sc/sc300"
end if
%>
<%=wybt%>唐诗宋词赏析 <%=wybt2%>
当前位置:
小山屋->小山书斋->古诗词赏析->
<%if Request("lable")<> "" then%>
<% if Request("lable")=1 then%>唐诗300首<%else%>宋词300首<%end if%>
<%else
if Request("name")<> "" then%>
<%=name%>诗词
<% end if
if Request("keyword")<> "" then%>
搜索关键词:<%=keyword%>
<% end if
end if%>
<%if Request("msg")<> "" then%>
<%=Request("msg")%>
<%end if%>
<%
if pagesize="0" or pagesize="" then pagesize=thesize
set conn=server.createobject("adodb.connection")
DBPath = Server.MapPath("#gs.asp")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Set rs = Server.CreateObject("ADODB.Recordset")
dim rs, sql
dim curpage, strcate
if lable <> "" then
wherestr=" where lable like '%" & trim(lable) & "%' "
else
if keyword <> "" then
keyword = replace(keyword,"'","") '过滤关键字
keyword = replace(keyword,"[","")
keyword = trim(keyword)
wherestr=" where name like '%" & trim(keyword) & "%' or content like '%" & trim(keyword) & "%' or title like '%" & trim(keyword) & "%'"
end if
if name<>"" then
wherestr=" where name like '%" & trim(name) & "%' "
end if
end if
if sort="name" then
wherestr= wherestr & "order by name "
end if
sql = "SELECT * FROM shici " & wherestr
rs.open sql, conn, 1, 1
if rs.bof and rs.eof then
rs.close
response.write "
还没有符合条件的投稿呢!
"
else
dim i
rs.pagesize = pagesize
if rs.pagecount < curpage then
rs.absolutepage=rs.pagecount
curpage=rs.pagecount
else
rs.absolutepage = curpage
end if
%>