WEB开发网
开发学院WEB开发ASP 网络寻呼机数据库版显示历史消息history.asp 阅读

网络寻呼机数据库版显示历史消息history.asp

 2001-12-03 11:06:01 来源:WEB开发网   
核心提示:<html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>历史消息</title><script
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>历史消息</title>
<script language="javaScript">
<!--



function CheckAll(form) {
 for (var i=0;i<document.checkboxform1.length;i++)  {
  var e = document.checkboxform1[i];
  if (e.name != 'chkall')    e.checked = form.chkall.checked;
  }
 }
 
 // 检查是否选择了记录
function checkbox1(form)
{
  var theLength;
  var i,j;

  theLength = form.id.length;
  i = 0;
  j = 0;

  while(i<theLength){
    if (form.id[i].checked)
      j ++ ;
    i ++ ;
  }

  if (j==0 && !form.id.checked){
    alert("请先选择删除记录");
    return false ;
  }
  return true ;
}

// 单击“删除”按钮时触发
function del(form)
{
   if (!checkbox1(form)){
    return false;
  }
  else
    if (confirm('您确信要删除这些记录吗')){
    window.location.href="DeleteMessage.asp?page=<%=clng(page)%>"}
}
 -->
 </SCRIPT>
</head>

<body>
<br><br><%
set conn=server.createobject("adodb.connection")
  PRovider = "Provider=Microsoft.Jet.OLEDB.4.0;"
  DBPath = "Data Source=" & Server.MapPath( "webuser.mdb" )

  conn.Open Provider & DBPath
  username=session("username")
  
  if username<>"" then
  sql="select * from talks where fromname='"& username & "'or toname='"& username & "' order by adddate desc"
  
  Set rs = Server.Createobject("ADODB.Recordset")
  
  rs.open sql,conn,3,3
  rs.pagesize=15
  Page = CLng(Request("Page"))
  If Page < 1 Then Page = 1
  If Page > rs.PageCount Then Page = rs.PageCount

%>

<table border="0" cellspacing="0" width=590 cellpadding="0" align=center height="75">
 <tr>
  <td width="100%" height="24"><font size="2">查看我的历史消息(<b><font color="#FF0000">聊天记录仅保存一周内容,请自行备份</font></b>)</font></td>
 </tr>
 <% if rs.eof or rs.bof then %>
 <tr>
  <td width="100%" height="20"><font color="#FF0000">没有你的历史纪录,赶快和大家交流</font>!!!</td>
 </tr>
 <% else %>
 
 <tr>
  <td width="100%" align="center">
  <form action=history.asp name=f1>  
         <% If Page <> 1 Then %>       
           <a href=history.asp?Page=1> 第一页</A>     
           <A HREF=history.asp?Page=<%=(Page-1)%>>上一页</A>       
         <% End If       
         If Page <> rs.PageCount Then %>      
           <A HREF=history.asp?Page=<%=(Page+1)%>>下一页</A>       
           <A HREF=history.asp?Page=<%=rs.PageCount%>>最后一页</A>       
         <% End if %>      
           页次:<font COLOR="Red"><%=Page%>/<%=rs.PageCount%></font>    
              <input type=text size=4 maxlength=4 name=page>  
      </form>
</td>
 </tr>
 <tr>
  <td ><% show rs, Page %></td>
 </tr>
 <% end if %>
 <tr>
  <td width="100%" height="16">
  
  <%
  Sub show( rs, Page )
    rs.AbsolutePage =page       
    count=rs.pagesize       
%>
<FORM name="checkboxform1" onsubmit="return del(checkboxform1)" method=post action="DeleteMessage.asp?page=<%=clng(page)%>">
  <table border="0" cellspacing="0" width="590" cellpadding="0" align=center>
   <% 
    do while not rs.eof and count>0        
   %>
  <tr bgcolor="#D8D3CD">
   <td height="20"> <input type="checkbox" name="id" value="<%=rs("id")%>"> <b><%=rs("fromname")%></b> 于<%=rs("adddate")%>传呼 <b><%=rs("toname")%></b></td></tr>
  <tr>
   <td height=22><%
    Word=replace(rs("word"),vbcrlf,"<br>") 
    response.write word %>
   </td>
   </tr>
    <%
    count=count-1
    rs.movenext
    loop
    %>
   <tr>
    <td >
     <input type="checkbox" id="check1" name="chkall" value="on" onclick="CheckAll(this.form)"><label for="check1">点击复选框或汉字可全选全清</label>  
     <input type="submit" value="删除选中的数据" name="shanchu"></td>
    </tr>
</table>
</form>
<% end sub %>
  </td>
 </tr>
</table>
<%
sql="select adddate,id from talks"

set obj=conn.execute(sql)
if not obj.eof then
do while not obj.eof

  sql="delete from talks where (day(now)-day(adddate)>8)"
  conn.execute(sql)

obj.movenext
loop
end if

obj.close
set obj=nothing
end if


rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</body>

</html>

Tags:网络 寻呼机 数据库

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接