public void ProcessRequest(HttpContext context)
{
DataBooks book=new DataBooks();
book.name = context.Request["bookname"];
book.type = context.Request["booktype"];
if(book.name!=null)
bookcollector.Add(book);
context.Response.ContentType = "text/html";
VelocityEngine vltEngine = new VelocityEngine();
vltEngine.SetProperty(RuntimeConstants.RESOURCE_LOADER, "file");
vltEngine.SetProperty(RuntimeConstants.FILE_RESOURCE_LOADER_PATH, System.Web.Hosting.HostingEnvironment.MapPath("~/templates"));//模板文件所在的文件夹
vltEngine.Init();
VelocityContext vltContext = new VelocityContext();
//vltContext.Put("msg", "");
vltContext.Put("bookcollector", bookcollector);
vltContext.Put("book", book);
Template vltTemplate = vltEngine.GetTemplate("Front/ShopingCar.html");//模版文件所在位置
System.IO.StringWriter vltWriter = new System.IO.StringWriter();
vltTemplate.Merge(vltContext, vltWriter);
string html = vltWriter.GetStringBuilder().ToString();
context.Response.Write(html);
}
private void dataaccess(string table,string text)
{
string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
if (table == "2")
{
cmd.CommandText = "select * from T_Books where name like '%" + text + "%'";
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
string ser = reader.GetString(1);
string name = reader.GetString(2);
string type = reader.GetString(2);
book = new DataBooks(ser, name, type);
}
}
}
else if(table=="3")
{
cmd.CommandText = "select * from T_News where News like '%" + text + "%'";
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
string News = reader.GetString(1);
string Link = reader.GetString(2);
DateTime Date = reader.GetDateTime(3);
news = new GotNews(News, Link, Date);
}
}
}
}
}
}