📄 message.aspx
字号:
<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<%
int AdminLogFlag,PageSize=15,intPageCount,intRecordCount,Page;
bool AllowUbbCode=false;
if( Session["AdminLogged"]!="1" )
AdminLogFlag=0;
else{
AdminLogFlag=1;
}
if (Request["Page"]==null||Request["Page"]=="")
Page=1;
else{
Page=Convert.ToInt32((Request["Page"]));
if (Page<1)
Page=1;
}
string DB_STR="Provider=Microsoft.Jet.OLEDB.4.0; Persist Security Info=False; Data Source=" + Server.MapPath("Database/GuestBook.mdb");
OleDbConnection conn = new OleDbConnection( DB_STR );
OleDbCommand cmd = new OleDbCommand( "select * from guestbook order by postdatetime DESC", conn );
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill( ds );
conn.Close();
DataTable msgTable=ds.Tables[0];
intRecordCount=msgTable.Rows.Count;
Response.ContentType = "text/xml";
Response.Expires = -1;
Response.Write("<?xml version='1.0' encoding='GB2312'?>");
Response.Write("<threads ");
if(intRecordCount>0){
intPageCount=intRecordCount/PageSize+1;
if ( intRecordCount%PageSize>0 )intPageCount++;
if ( intPageCount<1 )intPageCount=1;
if(Page>intPageCount)
Page=intPageCount;
Response.Write("PageCount=\""+Convert.ToString(intPageCount)+"\" RecordCount=\""+Convert.ToString(intRecordCount)+"\" AdminLog=\""+Convert.ToString(AdminLogFlag)+"\">");
int msgWrote=(Page-1)*PageSize;
for(int i=0 ; i< PageSize;i++){
if(msgWrote>intRecordCount-1)break;
Response.Write("<mes>");
Response.Write("<subj>");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["subj"]);
Response.Write("</subj>");
Response.Write("<number>");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["number"]);
Response.Write("</number>");
Response.Write("<email>");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["email"]);
Response.Write("</email>");
Response.Write("<url>");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["url"]);
Response.Write("</url>");
Response.Write("<body><![CDATA[");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["mes"]);
Response.Write("]]></body>");
Response.Write("<sex>");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["sex"]);
Response.Write("</sex>");
Response.Write("<rep><![CDATA[");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["rep"]);
Response.Write("]]></rep>");
Response.Write("<icon>");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["icon"]);
Response.Write("</icon>");
Response.Write("<posted>");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["postdatetime"]);
Response.Write("</posted>");
Response.Write("<face>");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["face"]);
Response.Write("</face>");
Response.Write("<username>");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["username"]);
Response.Write("</username>");
Response.Write("<icq>");
Response.Write(msgTable.Rows[i+(Page-1)*PageSize]["icq"]);
Response.Write("</icq>");
Response.Write("</mes>");
msgWrote++;
}
}
Response.Write("</threads>");
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -