ajax 笔记--不刷新实现简单的留言版 guestBook
来源:互联网 发布:淘宝店铺优化视频教程 编辑:程序博客网 时间:2024/06/07 17:28
下面是guest Book.aspx.cs代码----------------------------
下面是js代码------------------------------------
数据guestBook表结构
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.Text;
using GetCommand;
public partial class Ajax_guestBook : System.Web.UI.Page
...{
protected void Page_Load(object sender, EventArgs e)
...{
if (!this.Page.IsPostBack)
...{
AjaxPro.Utility.RegisterTypeForAjax(typeof(Ajax_guestBook));
}
}
/**//// <summary>
/// 添加留言信息
/// </summary>
/// <param name="txtNickName">用户昵称</param>
/// <param name="txtQQ">QQ号</param>
/// <param name="txtMSN">MSN号</param>
/// <param name="txtTel">电话</param>
/// <param name="txtContent">内容</param>
/// <returns>count</returns>
[AjaxPro.AjaxMethod]
public int InsertGuestBook(string txtNickName,string txtQQ,string txtMSN,string txtTel,string txtContent)
...{
string NickName = txtNickName.Trim();
string QQ = txtQQ.Trim();
string MSN = txtMSN.Trim();
string Tel = txtTel.Trim();
string Content = GeneralMethod.Encode(txtContent);
string sqlString = "insert into guestBook values('" + NickName + "','" + QQ + "','" + MSN + "','" + Tel + "','" + Content + "','" + DateTime.Now.ToString() +"')";
//这里你得你自己写一个,我这里自己早就写了一个GetCommand把 ExecuteNonQuery( 封装到里面去了
int count = SetConnection.ExecuteNonQuery(sqlString);
return count;
}
/**//// <summary>
/// 把所有留言信息取出来
/// </summary>
/// <returns>AllGuestBookInformation</returns>
[AjaxPro.AjaxMethod]
public string getGuestBook()
...{
//这里你得你自己写一个,我这里自己早就写了一个GetCommand把 DataSet 封装到里面去了.
DataSet ds = SetConnection.getDataSet("SELECT * FROM guestBook order by IssueTime Desc", "guestBook");
StringBuilder NickName = new StringBuilder();
StringBuilder QQ = new StringBuilder();
StringBuilder Tel = new StringBuilder();
StringBuilder MSN = new StringBuilder();
StringBuilder Content = new StringBuilder();
StringBuilder IssueTime = new StringBuilder();
foreach (DataRow dr in ds.Tables["guestBook"].Rows)
...{
NickName.Append(dr["NickName"].ToString()).Append("|");
QQ.Append(dr["QQ"].ToString()).Append("|");
Tel.Append(dr["Tel"].ToString()).Append("|");
MSN.Append(dr["MSN"].ToString()).Append("|");
Content.Append(dr["Content"].ToString()).Append("|");
IssueTime.Append(dr["IssueTime"].ToString()).Append("|");
}
return NickName.ToString() + "~" + QQ.ToString() + "~" + Tel.ToString() + "~" + MSN.ToString() + "~" + Content.ToString() + "~" + IssueTime.ToString();
}
}
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.Text;
using GetCommand;
public partial class Ajax_guestBook : System.Web.UI.Page
...{
protected void Page_Load(object sender, EventArgs e)
...{
if (!this.Page.IsPostBack)
...{
AjaxPro.Utility.RegisterTypeForAjax(typeof(Ajax_guestBook));
}
}
/**//// <summary>
/// 添加留言信息
/// </summary>
/// <param name="txtNickName">用户昵称</param>
/// <param name="txtQQ">QQ号</param>
/// <param name="txtMSN">MSN号</param>
/// <param name="txtTel">电话</param>
/// <param name="txtContent">内容</param>
/// <returns>count</returns>
[AjaxPro.AjaxMethod]
public int InsertGuestBook(string txtNickName,string txtQQ,string txtMSN,string txtTel,string txtContent)
...{
string NickName = txtNickName.Trim();
string QQ = txtQQ.Trim();
string MSN = txtMSN.Trim();
string Tel = txtTel.Trim();
string Content = GeneralMethod.Encode(txtContent);
string sqlString = "insert into guestBook values('" + NickName + "','" + QQ + "','" + MSN + "','" + Tel + "','" + Content + "','" + DateTime.Now.ToString() +"')";
//这里你得你自己写一个,我这里自己早就写了一个GetCommand把 ExecuteNonQuery( 封装到里面去了
int count = SetConnection.ExecuteNonQuery(sqlString);
return count;
}
/**//// <summary>
/// 把所有留言信息取出来
/// </summary>
/// <returns>AllGuestBookInformation</returns>
[AjaxPro.AjaxMethod]
public string getGuestBook()
...{
//这里你得你自己写一个,我这里自己早就写了一个GetCommand把 DataSet 封装到里面去了.
DataSet ds = SetConnection.getDataSet("SELECT * FROM guestBook order by IssueTime Desc", "guestBook");
StringBuilder NickName = new StringBuilder();
StringBuilder QQ = new StringBuilder();
StringBuilder Tel = new StringBuilder();
StringBuilder MSN = new StringBuilder();
StringBuilder Content = new StringBuilder();
StringBuilder IssueTime = new StringBuilder();
foreach (DataRow dr in ds.Tables["guestBook"].Rows)
...{
NickName.Append(dr["NickName"].ToString()).Append("|");
QQ.Append(dr["QQ"].ToString()).Append("|");
Tel.Append(dr["Tel"].ToString()).Append("|");
MSN.Append(dr["MSN"].ToString()).Append("|");
Content.Append(dr["Content"].ToString()).Append("|");
IssueTime.Append(dr["IssueTime"].ToString()).Append("|");
}
return NickName.ToString() + "~" + QQ.ToString() + "~" + Tel.ToString() + "~" + MSN.ToString() + "~" + Content.ToString() + "~" + IssueTime.ToString();
}
}
-----------------------------------
下面是 guestBook.aspx html代码
<%...@ Page Language="C#" AutoEventWireup="true" CodeFile="guestBook.aspx.cs" Inherits="Ajax_guestBook" %>
<!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 type="text/javascript" language="javascript" src="../JavaScripts/guestBook.js">...
</script>
</head>
<body onload="btn_ShowGuestBookContent();">
<form id="form1" runat="server" >
<div>
<table border="1">
<tr>
<td style="width: 100px">
昵称:</td>
<td style="width: 100px">
<input type="text" onmouseover="Clear_txtNickName();" id="txtNickName" value="小土呢" />
</td>
<td style="width: 100px">
QQ</td>
<td style="width: 100px">
<input type="text" onmouseover="Clear_txtQQ();" id="txtQQ" value="281827047" /></td>
</tr>
<tr>
<td style="width: 100px">
电话号码:</td>
<td style="width: 100px">
<input type="text" onmouseover="Clear_txtTel();" id="txtTel" value="13733377325" /></td>
<td style="width: 100px">
MSN</td>
<td style="width: 100px">
<input type="text" onmouseover="Clear_txtMSN();" id="txtMSN" value="xiaotuni@hotmail.com" /></td>
</tr>
<tr>
<td style="width: 100px; height: 42px;">
内容:</td>
<td colspan="3" style="height: 42px">
<textarea cols="6" rows="6" id="txtContent" style ="width:100%"> 这是一简单无刷新实现留言版的例子</textarea>
</td>
</tr>
<tr>
<td style="width: 100px">
</td>
<td colspan="3">
<input type="button" onclick="AddGuestBook();" value="添加留言信息" id="btnAddGuestBook" />
</td>
</tr>
<tr>
<td style="width: 100px">
</td>
<td colspan="3">
Copyright :<a href ="http://xiaotuni.w1.kingtoo.com">xiaotuni</a></td>
</tr>
</table>
</div>
<div id ="GuestBook">
</div>
</form>
</body>
</html>
<!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 type="text/javascript" language="javascript" src="../JavaScripts/guestBook.js">...
</script>
</head>
<body onload="btn_ShowGuestBookContent();">
<form id="form1" runat="server" >
<div>
<table border="1">
<tr>
<td style="width: 100px">
昵称:</td>
<td style="width: 100px">
<input type="text" onmouseover="Clear_txtNickName();" id="txtNickName" value="小土呢" />
</td>
<td style="width: 100px">
QQ</td>
<td style="width: 100px">
<input type="text" onmouseover="Clear_txtQQ();" id="txtQQ" value="281827047" /></td>
</tr>
<tr>
<td style="width: 100px">
电话号码:</td>
<td style="width: 100px">
<input type="text" onmouseover="Clear_txtTel();" id="txtTel" value="13733377325" /></td>
<td style="width: 100px">
MSN</td>
<td style="width: 100px">
<input type="text" onmouseover="Clear_txtMSN();" id="txtMSN" value="xiaotuni@hotmail.com" /></td>
</tr>
<tr>
<td style="width: 100px; height: 42px;">
内容:</td>
<td colspan="3" style="height: 42px">
<textarea cols="6" rows="6" id="txtContent" style ="width:100%"> 这是一简单无刷新实现留言版的例子</textarea>
</td>
</tr>
<tr>
<td style="width: 100px">
</td>
<td colspan="3">
<input type="button" onclick="AddGuestBook();" value="添加留言信息" id="btnAddGuestBook" />
</td>
</tr>
<tr>
<td style="width: 100px">
</td>
<td colspan="3">
Copyright :<a href ="http://xiaotuni.w1.kingtoo.com">xiaotuni</a></td>
</tr>
</table>
</div>
<div id ="GuestBook">
</div>
</form>
</body>
</html>
下面是js代码
// JScript 文件
function AddGuestBook()
...{
var Nick = document.getElementById("txtNickName").value;
var QQ = document.getElementById("txtQQ").value;
var Tel = document.getElementById("txtTel").value;
var MSN = document.getElementById("txtMSN").value;
var Content = document.getElementById("txtContent").value;
if( Nick == "")
...{
alert("昵称不能为空");
}
else
...{
if(Content == "")
...{
alert("内容不能为空");
}
else
...{
var response = Ajax_guestBook.InsertGuestBook(Nick,QQ,MSN,Tel,Content)
if(response.value == 1)
...{
alert("添加成功");
}
else
...{
alert("添加失败");
}
}
}
//显示所有留言信息
btn_ShowGuestBookContent();
//清空操作
btn_ClearControlsValue();
}
function btn_ClearControlsValue()
...{
document.getElementById("txtNickName").value = "";
document.getElementById("txtQQ").value = "";
document.getElementById("txtTel").value = "";
document.getElementById("txtMSN").value = "";
document.getElementById("txtContent").value = "";
}
function btn_ShowGuestBookContent()
...{
var response = Ajax_guestBook.getGuestBook();
if(response.value == null)
...{
alert("出错了" + response.value);
}
else
...{
BinderGuestBook(response);
}
}
function BinderGuestBook(response)
...{
var AllContent = response.value.split("~");
var NickName = AllContent[0].split("|");
var QQ = AllContent[1].split("|");
var Tel = AllContent[2].split("|")
var MSN = AllContent[3].split("|");
var Content = AllContent[4].split("|");
var IssueTime = AllContent[5].split("|");
var aa ="";
for(var i = 0 ; i < NickName.length - 1 ; i++)
...{
aa += '<table border="0" cellpadding="1" cellspacing="1"><tr><td>昵称:</td><td>' + NickName[i] +'<td >QQ</td><td >' + QQ[i] + '</td></tr><tr><td >电话号码:</td><td >' + Tel[i] + '</td><td >MSN</td><td >'+MSN[i]+'</td></tr><tr><td >内容</td><td colspan="3" >'+Content[i] + '</td></tr><tr><td >时间:</td><td colspan="3">'+IssueTime[i] +'</td></tr></table>'
}
document.getElementById("GuestBook").innerHTML = aa;
}
var statue = 1;
function Clear_txtNickName()
...{
if(statue == 1)
...{
document.getElementById("txtNickName").value = "";
}
}
function Clear_txtQQ()
...{
document.getElementById("txtQQ").value = "";
}
function Clear_txtTel()
...{
document.getElementById("txtTel").value = "";
}
function Clear_txtMSN()
...{
document.getElementById("txtMSN").value = "";
}
function AddGuestBook()
...{
var Nick = document.getElementById("txtNickName").value;
var QQ = document.getElementById("txtQQ").value;
var Tel = document.getElementById("txtTel").value;
var MSN = document.getElementById("txtMSN").value;
var Content = document.getElementById("txtContent").value;
if( Nick == "")
...{
alert("昵称不能为空");
}
else
...{
if(Content == "")
...{
alert("内容不能为空");
}
else
...{
var response = Ajax_guestBook.InsertGuestBook(Nick,QQ,MSN,Tel,Content)
if(response.value == 1)
...{
alert("添加成功");
}
else
...{
alert("添加失败");
}
}
}
//显示所有留言信息
btn_ShowGuestBookContent();
//清空操作
btn_ClearControlsValue();
}
function btn_ClearControlsValue()
...{
document.getElementById("txtNickName").value = "";
document.getElementById("txtQQ").value = "";
document.getElementById("txtTel").value = "";
document.getElementById("txtMSN").value = "";
document.getElementById("txtContent").value = "";
}
function btn_ShowGuestBookContent()
...{
var response = Ajax_guestBook.getGuestBook();
if(response.value == null)
...{
alert("出错了" + response.value);
}
else
...{
BinderGuestBook(response);
}
}
function BinderGuestBook(response)
...{
var AllContent = response.value.split("~");
var NickName = AllContent[0].split("|");
var QQ = AllContent[1].split("|");
var Tel = AllContent[2].split("|")
var MSN = AllContent[3].split("|");
var Content = AllContent[4].split("|");
var IssueTime = AllContent[5].split("|");
var aa ="";
for(var i = 0 ; i < NickName.length - 1 ; i++)
...{
aa += '<table border="0" cellpadding="1" cellspacing="1"><tr><td>昵称:</td><td>' + NickName[i] +'<td >QQ</td><td >' + QQ[i] + '</td></tr><tr><td >电话号码:</td><td >' + Tel[i] + '</td><td >MSN</td><td >'+MSN[i]+'</td></tr><tr><td >内容</td><td colspan="3" >'+Content[i] + '</td></tr><tr><td >时间:</td><td colspan="3">'+IssueTime[i] +'</td></tr></table>'
}
document.getElementById("GuestBook").innerHTML = aa;
}
var statue = 1;
function Clear_txtNickName()
...{
if(statue == 1)
...{
document.getElementById("txtNickName").value = "";
}
}
function Clear_txtQQ()
...{
document.getElementById("txtQQ").value = "";
}
function Clear_txtTel()
...{
document.getElementById("txtTel").value = "";
}
function Clear_txtMSN()
...{
document.getElementById("txtMSN").value = "";
}
数据guestBook表结构
USE [People]
GO
/**//****** 对象: Table [dbo].[GuestBook] 脚本日期: 10/21/2006 22:21:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GuestBook](
[guestBookID] [int] IDENTITY(1,1) NOT NULL,
[nickName] [nvarchar](16) COLLATE Chinese_PRC_CI_AS NULL,
[QQ] [nvarchar](11) COLLATE Chinese_PRC_CI_AS NULL,
[MSN] [nvarchar](35) COLLATE Chinese_PRC_CI_AS NULL,
[Tel] [nvarchar](13) COLLATE Chinese_PRC_CI_AS NULL,
[Content] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[IssueTime] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[guestBookID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/**//****** 对象: Table [dbo].[GuestBook] 脚本日期: 10/21/2006 22:21:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GuestBook](
[guestBookID] [int] IDENTITY(1,1) NOT NULL,
[nickName] [nvarchar](16) COLLATE Chinese_PRC_CI_AS NULL,
[QQ] [nvarchar](11) COLLATE Chinese_PRC_CI_AS NULL,
[MSN] [nvarchar](35) COLLATE Chinese_PRC_CI_AS NULL,
[Tel] [nvarchar](13) COLLATE Chinese_PRC_CI_AS NULL,
[Content] [nvarchar](4000) COLLATE Chinese_PRC_CI_AS NULL,
[IssueTime] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[guestBookID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1344601
- ajax 笔记--不刷新实现简单的留言版 guestBook
- ajax 笔记--不刷新实现简单的留言版 guestBook
- 用AjaxPro实现不刷新简单留言版
- Ajax GuestBook(ASP)实现_1
- Ajax GuestBook(ASP)实现_2
- 使用AJAX实现优酷视频播放时留言不刷新
- Ajax实现的留言本
- Ajax定时刷新网页的简单实现
- 简单的ajax实现局部刷新
- 基于Ajax的简单留言本
- 一个简单留言本的实现
- 一个简单留言本的实现
- Go语言实现简单的留言本
- Web Storage实现简单的留言本
- 不用Ajax实现简单的无刷新级联下拉框
- Ajax 实现不刷新取最新商品
- ajax 笔记--不用刷新实现数据的分页显示
- ajax 笔记--不用刷新实现数据的分页显示 (上)
- hibernate使用tomcate连接池
- DataList分页
- 与性同行(贴图)_性成熟
- 与ClientWidth有关的一点资料
- 2007年IT薪资调查 IT人更关注职业前途
- ajax 笔记--不刷新实现简单的留言版 guestBook
- 微软为什么成不了中国的取款机?
- 用ajax 不用刷新页面就可实现国家,省,城市的三级联动(转载)
- asp.net内实现在密码输入框内按回车就登陆的功能
- windows服务
- 服务器端的高性能实现(五)——对客户端消息的响应和处理
- 付出过就不要后悔,爱情里没有绝对地对与错,输与赢
- Java的反射机制
- 平淡的爱