<%
Dim sql
Dim rs
'建立 Recordset 对象并以追加记录方式打开数据库表 classmat
Set rs=Server.CreateObject("ADODB.Recordset")
sql="Select*from words"
rs.Open sql,db,1,1
If rs.EOF Or rs.BOF Then
Response.Write "数据库中暂无资料~"
Else
rs.Pagesize=13
Size=rs.Pagesize
Pagecount=rs.Pagecount
page=Int(Request.QueryString("page"))
If Request.QueryString("page")="" Then page=1
If page<1 Then page=1
If page>rs.Pagecount Then page=rs.Pagecount
rs.Absolutepage=page
%>
作者:郑维丰
6. dispI.asp
<%
If Not IsEmpty(Request.QueryString("id")) Then
id=Request.QueryString("id")
Else
id=1
End If
%>
<%
Function zdp(content)
zdp=content
If content<>"" Then
zdp=Replace(zdp,Chr(13)," ")
zdp=Replace(zdp,Chr(34),""")
zdp=Replace(zdp,Chr(32)," ")
End If
End Function
%>
<%
Set rs=Server.CreateObject("ADOdb.Recordset")
sql="select * from words where id="&id
rs.Open sql,db,1,3
rs("count")=rs("count")+1
rs.Update
作者:郑维丰 %>
日志内容
作者:郑维丰
7. login.asp
<%
If Request("act")="check" Then
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Open "select * from admin where username='"& Trim(Request.Form("username")) & "' and
password='"& Trim(Request.Form("password")) & "'",db,1,1
If rs.EOF and rs.BOF Then
Response.Write""
Response.End
Else
Session("user")=rs("username")
Response.Redirect"admin.asp"
End If
rs.Close
Set rs=Nothing
db.Close
Set conn=Nothing
End If
%>
管理登录
<%
If Request("XHType")="" Or Request("XHType")="login" Then
Call login()
ElseIf Request("XHType")="logout" Then
Call logout()
End If
作者:郑维丰
%>
<%
Sub logout()
Session("user")=""
Call login()
End Sub
%>
<% Sub login() %>
<% End Sub %>
8. admin.asp
<%
if session("user")="" then
response.write""
作者:郑维丰
response.end
end if
%>
<%
sql="select * from words order by id desc"
Set rs=db.execute(sql)
%>
日志发布管理
<%
Dim sql
Dim rs
'建立 Recordset 对象并以追加记录方式打开数据库表 classmat
Set rs=Server.CreateObject("ADODB.Recordset")
sql="Select*from words"
rs.Open sql,db,1,1
If rs.EOF Or rs.BOF Then
Response.Write "数据库中暂无资料~"
Else
rs.Pagesize=13
Size=rs.Pagesize
Pagecount=rs.Pagecount
page=Int(Request.QueryString("page"))
If Request.QueryString("page")="" Then page=1
If page<1 Then page=1
If page>rs.Pagecount Then page=rs.Pagecount
rs.Absolutepage=page
%>
作者:郑维丰
9. dispA.asp
<%
If Not IsEmpty(Request.QueryString("id")) Then
id=Request.QueryString("id")
Else
id=1
End If
%>
<%
Function zdp(content)
zdp=content
If content<>"" Then
zdp=Replace(zdp,Chr(13)," ")
作者:郑维丰
zdp=Replace(zdp,Chr(34),""")
zdp=Replace(zdp,Chr(32)," ")
End If
End Function
%>
<%
Set rs=Server.CreateObject("ADOdb.Recordset")
sql="select * from words where id="&id
rs.Open sql,db,1,3
rs("count")=rs("count")+1
rs.Update
%>
日志内容
10. write.asp
<%
if session("user")="" then
response.write""
response.end
end if
%>
发表日志
11. save.asp
<%
Set rs=Server.CreateObject("ADOdb.Recordset")
sql="select * from words"
rs.Open sql,db,1,3
rs.Addnew
rs("time")=Now()
rs("title")=Trim(Request.form("title"))
rs("content")=Server.HTMLEnCode(Request.form("content"))
rs("name")=Trim(Request.form("name"))
rs("count")=0
rs.Update
rs.Close
Set rs=Nothing
Response.Write""
%>
作者:郑维丰
12. edit.asp
<%
if session("user")="" then
response.write""
response.end
end if
%>
<%
id=Request.QueryString("id")
Set rs=Server.CreateObject("ADOdb.Recordset")
editsql="select * from words where id="&id
rs.Open editsql,db,1,3
%>
<%
If Request.form("active")="" Then
Else
rs("title")=Trim(Request.form("title"))
rs("content")=Server.HTMLEnCode(Request.form("content"))
rs("name")=Trim(Request.form("name"))
rs.Update
Response.Write""
End If
%>
修改日志
13. delnew.asp
<%
id=Request.QueryString("id")
delsql="delete * from words where id="&id
db.execute(delsql)
%>