Ajax留言板 

*******************message.aspx***********************

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="message.aspx.cs" Inherits="Test_Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>无标题页</title>
    <script src="JScript.js" type="text/javascript"></script>
    <style type="text/css">
        .style1
        {
            width: 100%;
            height: 344px;
        }
        .style2
        {
        }
        .style3
        {
            height: 306px;
        }

body
{
    text-align:center;
    margin:auto auto 20px auto;
    font-size:12px;
    font-family:宋体;
}
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div style="height: 351px">
   
        <table class="style1">
            <tr>
                <td class="style3">
                    <div style="height: 100%" id="left_word">加载留言中……</div>
                    </div>
                </td>
                <td class="style2" rowspan="2">
                    <div style="height: 100%; id="div_top">
        <div>
        <span>姓名:</span>
        <input type="text" id="username"/>
        </div>
        <div>
        <span>性别:</span>
        <input type="radio"  value="男" name="sex" id="sexa"  checked />男&nbsp;&nbsp;&nbsp;&nbsp;
        <input type="radio" value="女"  name="sex" id="sexb" /> 女</div>   
        <div>
        <span>&nbsp;&nbsp;QQ:</span>
        <input type="text" id="qq" />
   
    </div>
    <div>
        <span>邮箱:</span>
        <input type="text" id="mail" />
    </div>
    <div>
        <textarea style="width:100%;height:300px" id="txt"></textarea>   
    </div>
    <div style="text-align:center">
      <input type="button" value="确定留言" οnclick="chk(this)" id="btn_submit"/>
    </div>
</div>
                </td>
            <tr>
                <td>
                    <div style="height: 100%">
    <a href="javascript:firstpage()">首页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <a href="javascript:previoustpage()">上一页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <a href="javascript:nextpage()">下一页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <a href="javascript:lastpage()">尾页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    第<span id="page">1</span>页
    /共<span id="pagecount">1</span>页
                    </div>
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>

 

 

**************************************write.aspx********************************

 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class write : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        if (Request.QueryString["add"] == "yes")
        {

            //OleDbConnection conn = connMdb.createConnMdb();
         OleDbConnection conn=new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + Server.MapPath("guestbookData.mdb"));
            OleDbDataAdapter oda = new OleDbDataAdapter();
            oda.SelectCommand = new OleDbCommand("select * from wordData", conn);
            DataSet ds = new DataSet(); //创建一个离线的数据集对象
            oda.Fill(ds,"wordData");

            DataRow dr = ds.Tables[0].NewRow(); //新建一个数据行
            dr["username"] = Request.Form["username"]; //给该数据字段赋值
            dr["sex"]=Request.Form["sex"];
            dr["qq"]=Request.Form["bb"];
            dr["mail"]=Request.Form["mail"];
            dr["left_content"] = Request.Form["txt"].Replace(" < ", "&lt; ").Replace("> ", "&gt; ").Replace("/r/n", " <br> ").Replace("       ", "&nbsp; ");
            ds.Tables[0].Rows.Add(dr); //把新建的行添加进数据表中

            //编译命令,把对离线的数据库的操作,转换编译成真实的对应命令
            OleDbCommandBuilder odb = new OleDbCommandBuilder(oda);
           
            oda.Update(ds,"wordData"); //对离线数据库做的更改,回写到真实数据库中

        }

    }

}

 

**********************************game

 

<%@ Page Language="C#" AutoEventWireup="true" EnableViewState="false" CodeFile="getwordData.aspx.cs" Inherits="getwordData" %>
<%@ Import Namespace="System.Data" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>查看留言</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Repeater ID="Repeater1" runat="server">
        <HeaderTemplate><table align="center" border="1" width="90%" cellpadding="8" cellspacing="0" style="border-collapse:collapse"></HeaderTemplate>
        <ItemTemplate>
        <tr>
            <td style="text-align:left">
                 【编号:<%# ((DataRowView)Container.DataItem)["ID"] %>】
                 【姓名:<%# ((DataRowView)Container.DataItem)["username"] %>】
                 【性别:<%# ((DataRowView)Container.DataItem)["sex"] %>】
                 【QQ:<%# ((DataRowView)Container.DataItem)["qq"] %>】
                 【邮箱:<%# ((DataRowView)Container.DataItem)["mail"] %>】
            </td>
        </tr>
        <tr><td style="text-align: left"><%# ((DataRowView)Container.DataItem)["left_content"]%></td></tr>
        </ItemTemplate>
        <SeparatorTemplate></table><br /><br /><table align="center" border="1" width="90%" cellpadding="8" cellspacing="0" style="border-collapse:collapse"></SeparatorTemplate>
        <FooterTemplate></table></FooterTemplate>
        </asp:Repeater>
   
    </div>
    </form>
</body>
</html>

*************cs代码*************

 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class getwordData : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //OleDbConnection conn = connMdb.createConnMdb();
     OleDbConnection conn=new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + Server.MapPath("guestbookData.mdb"));
        OleDbDataAdapter oda = new OleDbDataAdapter();
        oda.SelectCommand = new OleDbCommand("select * from wordData order by ID desc", conn);
        DataSet ds = new DataSet();
        oda.Fill(ds,"wordData");
        int page=0;
        if (Request.QueryString["page"] != null)
        {
            page=Convert.ToInt16(Request.QueryString["page"]);
        }
        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = ds.Tables[0].DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = 4;
        if (page >= pds.PageCount) //如果传递过来的页码大于最大页码,则取最大页码
        {
            page = pds.PageCount-1;
        }
        pds.CurrentPageIndex = page;
        this.Repeater1.DataSource = pds;
        this.Repeater1.DataBind();
        Response.Write("pagecount=" + pds.PageCount.ToString()); //最大页码

    }
}

 

 

********************************************Jscript.js**************************************************

function $(eid)
{
    return document.getElementById(eid);
}

function chk()
{
    if( $("username").value=="" )
    {
        alert("姓名不能为空!");
        $("username").focus();
    }
    else if( $("qq").value=="" )
    {
        alert("QQ不能为空!");
        $("qq").focus();
    }
    else if( $("mail").value=="" )
    {
        alert("邮箱不能为空!");
        $("mail").focus();
    }
    else if( $("txt").value=="" )
    {
        alert("内容不能为空!");
        $("txt").focus();
    }
    else
    {
        arguments[0].disabled=true;
        arguments[0].value="发送中…";
        var sex="男";
        if($("sexb").checked==true)
        {
            sex="女";
        }
        var strdata;
        strdata="username="+$("username").value; //姓名
        strdata+="&sex="+sex; //性别
        strdata+="&bb="+$("qq").value; //QQ
        strdata+="&mail="+$("mail").value;  //邮箱
        strdata+="&txt="+$("txt").value;
        var xmlhttp;
        if(window.ActiveXObject)
        {
            try
            {
                xmlhttp=new ActiveXObject("msxml2.xmlhttp.3.0");
            }
            catch(e)
            {
                xmlhttp=new ActiveXObject("microsoft.xmlhttp");
            }
        }
        else if(window.XMLHttpRequest)
        {
            xmlhttp=new XMLHttpRequest();
        }
//      xmlhttp.open("post","write.aspx?add=yes&st="+new Date().getTime(),true);
        xmlhttp.open("post","write.aspx?add=yes")
        xmlhttp.setRequestHeader("content-type","application/x-www-form-urlencoded");
        xmlhttp.send(strdata);
        xmlhttp.onreadystatechange=function()
        {
            if(xmlhttp.readystate==4)
            {
                if(xmlhttp.status==200)
                {
                    $("btn_submit").disabled=false;
                    $("btn_submit").value="确定留言";
                    alert("留言成功!");
                    window.location.href="message.aspx"; 
                }
  else
  {
   alert("服务返回错误!");
  }
            }
        }
     }
}

function firstpage()
{
    document.getElementById("left_word").innerHTML="加载留言中……";
    getpagedata(0);
    document.getElementById("page").innerHTML=1;
}

function previoustpage()
{
  
    var page=parseInt(document.getElementById("page").innerHTML);
    if(page<=1)
    {
        alert("不能再上一页了");
    }
    else
    {
        document.getElementById("left_word").innerHTML="加载留言中……";
        page=page-1;
        getpagedata(page-1);
        document.getElementById("page").innerHTML=page;
    }
}

function nextpage()
{
    var page=parseInt(document.getElementById("page").innerHTML);
    var pagecount=parseInt(document.getElementById("pagecount").innerHTML);
    if(page>=pagecount)
    {
        alert("不能再下一页了");
    }
    else
    {
        document.getElementById("left_word").innerHTML="加载留言中……";
        var page=parseInt(document.getElementById("page").innerHTML); 
        getpagedata(page);
        page=page+1;
        document.getElementById("page").innerHTML=page;
    }
}

function lastpage()
{
    var page=parseInt(document.getElementById("pagecount").innerHTML);
     getpagedata(page-1);
     document.getElementById("page").innerHTML=page;
}

function getpagedata(page)
{
    var xmlhttp;
    if(window.ActiveXObject)
    {
        try
        {
            xmlhttp=new ActiveXObject("msxml2.xmlhttp.3.0");
        }
        catch(e)
        {
            xmlhttp=new ActiveXObject("microsoft.xmlhttp");
        }
    }
    else if(window.XMLHttpRequest)
    {
        xmlhttp=new XMLHttpRequest();
    }
    xmlhttp.open("get","getwordData.aspx?page="+page+"&st="+new Date().getTime(),true);
    xmlhttp.onreadystatechange=function()
    {
        if(xmlhttp.readystate==4)
        {
            if(xmlhttp.status==200)
            {
                var strhtml=xmlhttp.responseText;
                var pagecount; //最大页码数
                pagecount=strhtml.match(/pagecount/=/d+/); //在返回的数据中,匹配出最大页码
                pagecount=parseInt(pagecount[0].split("=")[1]);
                strhtml=(strhtml.match(/<table[/s/S]*table>/g))[0];
                document.getElementById("left_word").innerHTML=strhtml;
                document.getElementById("pagecount").innerHTML=pagecount;
            }
     else
    {
  alert("服务器返回错误!");
    }
        }
    }
    xmlhttp.send(null);
}
getpagedata(0);

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 6
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 6
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值