第
页
4、管理员登录，代码如下：
protected void Button1_Click(object sender, EventArgs e) {
if (txtyPwd.Text != Request.Cookies[\].Value.ToString()) Response.Write(\验证码错误！')\); else {
string strSQL = \用户表 where username='\ + txtName.Text + %userpwd='\ + txtPwd.Text + \;
if (DbManger.ExecuteQuery(strSQL).Rows.Count > 0) {
Session[\] = 1;
Response.Redirect(\); } else
Response.Write(\用户名或密码错误！')\); }
5、建立留言管理页，代码如下： (1) 事件代码
protected void Page_Load(object sender, EventArgs e) {
int ipageSize = 5;
string strTableName = \; string strKey = \; string strORDER = \; string strFields = \; int iCurPage; int iMaxPage; string sql = \;
string sqlstr = \ + strTableName; if (Request.QueryString[\] != \)
iCurPage = Convert.ToInt32(Request.QueryString[\]); else
iCurPage = 1;
int intTotalRec = Convert.ToInt32(DbManger.ExecuteScalar(sqlstr)); if (intTotalRec % ipageSize == 0) iMaxPage = intTotalRec / ipageSize; else
iMaxPage = intTotalRec / ipageSize + 1; if (iMaxPage == 0) iMaxPage = 1; if (iCurPage < 1) iCurPage = 1; else
if (iCurPage > iMaxPage) iCurPage = iMaxPage; if (intTotalRec != 0) {
if (iCurPage == 1)
sql = \ + ipageSize + \ + strFields + \ + strTableName + \ + strKey + \ + strORDER; else
sql = \ + ipageSize + \ + strFields + \ + strTableName + \ + strKey + \ + (iCurPage - 1) * ipageSize + \ + strKey + \\ + strTableName + \order by \ + strKey + \\ + strORDER + \by \ + strKey + \\ + strORDER; Repeater1.DataSource = DbManger.ExecuteQuery(sql); Repeater1.DataBind();
Label1.Text = \共有\ + intTotalRec.ToString() + \条记录 当前是第\ + iCurPage.ToString() + \ + iMaxPage.ToString() + \页\; if (iCurPage != 1) {
hlFrst.NavigateUrl = Request.FilePath + \;
hlPre.NavigateUrl = Request.FilePath + \ + (iCurPage - 1); }
if (iCurPage != iMaxPage) {
hlNext.NavigateUrl = Request.FilePath + \ + (iCurPage + 1); hlLast.NavigateUrl = Request.FilePath + \ + iMaxPage; if (intTotalRec <= ipageSize) Panel1.Visible = false; else
Panel1.Visible = true; }
(2)html代码
<%@ Control Language=\ AutoEventWireup=\ CodeFile=\ Inherits=\ %>
<%#Eval (\留言者\) %>
在<%#Eval (\时间\) %>留言
<%#Eval (\正文\) %>
<%#Eval (\留言者\) %>
在<%#Eval (\时间\) %>留言
<%#Eval (\正文\) %>
<%#Eval (\回复\,\管理员回复：{0}
\) %>
第
页
(3)删除的代码如下：
protected void Page_Load(object sender, EventArgs e) {
if(Convert.ToInt16(Session[\]) != 1) {
Response.Write(\请先登录！')\);
Response.Write(\); } else {
string strSQL = \ + Convert.ToInt32(Request.QueryString[\]);
if (DbManger.ExecuteNonQuery(strSQL) > 0) {
Response.Write(\删除成功！')\);
Response.Write(\); }
四、实训效果：
1、添加留言页面，效果如图4-1所示：
图 4-1
2、留言分页显示，效果如图4-2所示
图4-2 留言分页显示
3、显示带有头像的留言，效果如图4-3所示：