留言版简单实现
-----------------------------------------------------------------------------------------------------------------------------------
项目截图：
1，新建留言板数据库：LiuYanbanDB
USE [LiuYanbanDB]
GO /****** Object: Table [dbo].[LiuYan] Script Date: 2015/5/15 22:06:11 ******/
SET ANSI_NULLS ON
GO SET QUOTED_IDENTIFIER ON
GO CREATE TABLE [dbo].[LiuYan](
[id] [bigint] IDENTITY(,) NOT NULL,
[Title] [nvarchar]() NULL,
[Message] [nvarchar](max) NULL,
[NickName] [nvarchar]() NULL,
[IsAnonymous] [bit] NULL,
[IPAddress] [nvarchar]() NULL,
[PostDate] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[LiuYan] ADD CONSTRAINT [DF_LiuYan_PostDate] DEFAULT (getdate()) FOR [PostDate]
GO
2，新建项目，添加 Head.html 和 Foot.html 作为所有页面的页头和页尾， 其他新建HTML页面，用#parse("Head.html")来调用
3，准备好 Nvelocity模板处理类：Common_Nvelocity.cs
using Commons.Collections;
using NVelocity;
using NVelocity.App;
using NVelocity.Runtime;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Web; namespace LiuYanban
{
public class Common_Nvelocity
{ /// <summary>
/// 通过NVelocity模板引擎，把Data数据参数中的数据传递到Template模板中
/// </summary>
/// <param name="TemplateName">模板页面名称</param>
/// <param name="Data">参数数据</param>
/// <returns>返回HTML直接渲染生成 页面</returns>
public static string RenderHTML(string TemplateName, object Data)
{ //创建NVlecocity模板引擎的实例对象
VelocityEngine vlEngine = new VelocityEngine(); //初始化实例对象，定义对象的部分属性
ExtendedProperties props = new ExtendedProperties();
props.AddProperty(RuntimeConstants.RESOURCE_LOADER, "file");//声明模板是在file中
props.AddProperty(RuntimeConstants.FILE_RESOURCE_LOADER_PATH, System.Web.Hosting.HostingEnvironment.MapPath("~/Templates")); //指定模板文件所在文件夹
vlEngine.Init(props); //模板中的数据的来源
VelocityContext vltContext = new VelocityContext();
vltContext.Put("data", Data); //设置参数，在HTML模板中可以通过$Data读取数据 //模板文件名
Template VltTemp = vlEngine.GetTemplate(TemplateName);
//合并模板
StringWriter writer = new StringWriter();
VltTemp.Merge(vltContext, writer); //转化为字符串
string html = writer.GetStringBuilder().ToString(); return html;
}
}
}
4，添加 新增留言处理程序和对应的HTML模板页面： MessageNew.ashx ， MessageNew.html 实现新增留言功能
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient; namespace LiuYanban
{
/// <summary>
/// MessageNew 的摘要说明
/// </summary>
public class MessageNew : IHttpHandler
{ public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/HTML";
string html = "";
SQLHelper sqlH = new SQLHelper(); string strButtonSave = context.Request["Save"];
if (string.IsNullOrEmpty(strButtonSave))
{
var data = new { PageTitle = "请发表您的留言" };
html = Common_Nvelocity.RenderHTML("MessageNew.html", data);
context.Response.Write(html);
}
else
{
// 把留言提交
string strTitle = context.Request["title"];
string strMsg = context.Request["message"];
string strNickName = context.Request["NickName"];
bool FlagIsAnonymous = context.Request["IsAnonymous"] == "on";
string strIPAddress = context.Request.UserHostAddress; //数据校验
//写入数据库 string sqlInsert = " insert into [LiuYanbanDB].[dbo].[LiuYan]([Title],[Message],[NickName],[IsAnonymous],[IPAddress]) values(@Title,@Message,@NickName,@IsAnonymous,@IPAddress)";
SqlParameter[] sqlParas = new SqlParameter[]{
new SqlParameter("@Title",strTitle),
new SqlParameter("@Message",strMsg),
new SqlParameter("@NickName",strNickName),
new SqlParameter("@IsAnonymous",FlagIsAnonymous),
new SqlParameter("@IPAddress",strIPAddress)
};
int numSucc = ;
numSucc = sqlH.ExecuteNonQuery(sqlInsert, sqlParas, CommandType.Text); if (numSucc == )
{
context.Response.Redirect("MessageShow.ashx");
}
else
{
context.Response.Write("留言失败");
}
//strReminder = "发表留言成功";
//DataTable dt = sqlH.ExecuteQuery(sqlMsg, CommandType.Text);
//var data = new { PageTitle = "发表您的留言", MsgList = dt.Rows, PageReminder = strReminder };
//html = Common_Nvelocity.RenderHTML("MessageNew.html", data);
//context.Response.Write(html);
} } public bool IsReusable
{
get
{
return false;
}
}
}
}
#parse("Head.html")
<p>$data.PageTitle</p>
<form action="MessageNew.ashx" method="post">
<table>
<tbody>
<tr>
<td>昵称</td>
<td>
<input name="NickName" /><input type="checkbox" name="IsAnonymous" /><lable for="IsAnonymous">匿名</lable></td>
</tr>
<tr>
<td>标题</td>
<td>
<input type="text" name="Title" /></td>
</tr>
<tr>
<td>内容</td>
<td>
<textarea cols="" rows="" name="Message"></textarea></td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" name="Save" value="发表" /></td>
</tr>
</tbody>
</table>
</form>
#parse("Foot.html")
5，添加 留言查看对应的处理程序和对应的HTML模板页面: MessageShow.ashx ， MessageShow.html 实现显示留言列表
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data; namespace LiuYanban
{
/// <summary>
/// MessageShow 的摘要说明
/// </summary>
public class MessageShow : IHttpHandler
{ public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html"; SQLHelper sqlH = new SQLHelper();
string sqlMsg = " select * FROM [LiuYanbanDB].[dbo].[LiuYan] order by PostDate desc";
DataTable dt = sqlH.ExecuteQuery(sqlMsg, CommandType.Text);
var data = new { PageTitle = "留言列表", MsgList = dt.Rows };
string html = Common_Nvelocity.RenderHTML("MessageShow.html", data);
context.Response.Write(html);
} public bool IsReusable
{
get
{
return false;
}
}
}
}
#parse("Head.html")
<style type="text/css">
table {
border-collapse: collapse;
border: none;
width: 800px;
}
td {
border: solid # 1px;
}
</style>
<h1>$data.PageTitle</h1>
<a href="MessageNew.ashx">新增留言</a><br />
<table>
#foreach($Msg in $data.MsgList)
<tr>
<td>昵称：</td>
<td>$Msg.NickName</td>
<td>发表时间：</td>
<td>$Msg.PostDate</td>
<td>IP地址：</td>
<td>$Msg.IPAddress</td>
</tr>
<tr>
<td>留言标题:</td>
<td colspan="">$Msg.Title</td>
</tr>
<tr>
<td>留言内容：</td>
<td colspan="">$Msg.Message</td>
</tr>
#end
</table>
#parse("Foot.html")