网络寻呼机数据库版显示消息showmessage.asp

ASP教程 2025-08-14






显示自己的信息








<%

username=session("username")
Set conn=server.createobject("adodb.connection")
Provider = "Provider=Microsoft.Jet.OLEDB.4.0;"
DBPath = "Data Source=" & Server.MapPath( "webuser.mdb" )

conn.Open Provider & DBPath

set rs=server.createobject("adodb.recordset")

sql="select id,fromname,toname,word,adddate,isread from talks where toname='"& username &"'andisread=0 order by adddate"

rs.open sql,conn,3,3
rs.pagesize=1
Page = CLng(Request("Page"))
If Page < 1 Then Page = 1
If Page > rs.PageCount Then Page = rs.PageCount

%>











<% else %>









发送短消息


<%if rs.eof or rs.bof then %>
<% response.write"目前没有你的消息" %>
<% show rs,page%>

<%
Sub Show( rs, Page )
rs.AbsolutePage = Page
%>


<%For iPage = 1 To rs.PageSize %>


















<%
sql="update talks set isread=-1 where id="&rs("id")
conn.execute(sql)
rs.movenext
If rs.EOF Then Exit For
Next %>

<%=rs("fromname")%>于<%=rs("adddate")%>传呼于你

<%
word=replace(rs("word"),vbcrlf,"
")
response.write word
%>
回复对象
readonly>
回复信息

 输入的汉字不要超过200个汉字


<% If Page <> rs.PageCount Then %>
>下一条
<% End If %>

<% end sub %>












<%
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>