One method to build a high performance website

Introduction. 1

How to build a high performance website. 1

Create Article Entity Class. 1

Create Data Access class. 4

Create File Operate Class. 6

Create static article web page class. 8

Reference. 11

 

Introduction

In the modern times, there are a large number of websites on the internet, including static websites and dynamic websites. As we all know, the static websites have higher performance than the dynamic websites, but the static websites’ less communication with customs than dynamic websites. And the question is how can we build a high performance website?

How to build a high performance website

There are many methods to build a high performance website, such as use cache, high performance program, show your information by static pages and manage your website by dynamic pages. And this article just talks about the third method that how to create a high performance website.

Create Article Entity Class

First of all, let’s create a class that used to store article information, the following code shows the ArtilceEntity class and it inherits from IDisposable interface, and this class can use “using” statement to build a code block and it can automatic dispose the resource.

Create Data Access class/* * Created by Visual Studio 2008. * User: kangyi * Date: 2009-2-23 * Time: 20:12 * Modify: 2009-2-24 20:15 * This is the ArticleEntity class,used to store article information */ using System; using System.Data; using System.Data.OleDb; /// <summary> ///ArticleEntity /// </summary> public class ArticleEntity:IDisposable { /// <summary> /// Constructor /// </summary> public ArticleEntity(){ } /// <summary> /// Constructor /// </summary> /// <param name="aid">article id</param> /// <param name="tableName">database table name</param> /// <param name="conn">OleDbConnection object reference</param> public ArticleEntity(int aid,string tableName, OleDbConnection conn) { conn.Open(); articleID = aid; using (OleDbCommand cmd = new OleDbCommand("select * from [" + tableName + "] where ArticleId=" + ArticleID, conn)) { using (OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { while (dr.Read()) { ArticleTitle = dr["ArticleTitle"].ToString(); ArticleContent = dr["ArticleContent"].ToString(); ArticleAuthor = dr["ArticleAuthor"].ToString(); PublishDate = dr["PublishDate"].ToString(); } } } } private int articleID; public int ArticleID { get { return articleID; } set { this.articleID = value; } } private string articleTitle; public string ArticleTitle { get { return articleTitle; } set { this.articleTitle = value; } } private string articleContent; public string ArticleContent { get { return articleContent; } set { this.articleContent = value; } } private string articleAuthor; public string ArticleAuthor { get { return articleAuthor; } set { this.articleAuthor = value; } } private string publishDate; public string PublishDate { get { return publishDate; } set { this.publishDate = value; } } #region IDisposable member public void Dispose() { GC.SuppressFinalize(this); } #endregion }

This is a class that used to access database, such as create a connection object, and get data table method and ExecuteScalar method. The third method can access database, you can obtain data from database by this method. The following code is the Data Access class.

/* * Created by Visual Studio. * User: kangyi * Date: 2009-2-23 * Time: 21:12 * Modify: * This is the main class,used to operate database */ using System.Web; using System.Data; using System.Data.OleDb; /// <summary> ///DataAccess introcuction ///This is a class that used to operate database /// </summary> public class DataAccess { static OleDbConnection conn; static DataAccess() { conn = GetConn(); } private static string strConn; public static string StrConn { get { return strConn;} set { strConn = value; } } /// <summary> /// Get OleDbConnection object reference /// </summary> /// <returns>OleDbConnection object reference</returns> public static OleDbConnection GetConn() { if (HttpContext.Current.Cache["conn"] == null) { HttpContext.Current.Cache.Insert("conn", "data source=" + HttpContext.Current.Server.MapPath("database/db.mdb").ToString() + ";provider=microsoft.jet.oledb.4.0"); } strConn = HttpContext.Current.Cache["conn"].ToString(); return new OleDbConnection(StrConn); } /// <summary> /// To create a DataTable /// </summary> /// <param name="TableName">The database table name</param> /// <returns>Return a DataTabel object reference</returns> public static DataTable CreateDataTabel(string TableName) { OleDbDataAdapter da = new OleDbDataAdapter("select * from " + TableName, GetConn()); DataTable dt = new DataTable(); try { da.Fill(dt); } catch (OleDbException ex) { throw ex; } finally { da.Dispose(); } return dt; } /// <summary> /// Used to select a single row and column data /// </summary> /// <param name="sql">sql statement</param> /// <returns></returns> public static object ExecuteScalar(string sql) { object obj; OleDbCommand cmd = new OleDbCommand(sql, GetConn()); conn.Open(); try { obj = cmd.ExecuteScalar(); } catch (OleDbException ex) { throw ex; } finally { cmd.Dispose(); conn.Close(); } return obj; } }   

Create File Operate Class

This is a class that used to read the template file and write a static html file to virtual catalog. And this is a class just to use the IO namespace classes to read and write file. From the following code, there is a line of code “StreamReader sr = new StreamReader(path + FileName + ".template", System.Text.Encoding.GetEncoding("gb2312"));”, and this code used to read the template file, the template file is a file that contains html markup and some special markup like “[$$$title$$$]”, and this markup can be  replaced by the article entity property at user click create button.

/* * Created by Visual Studio. * User: kangyi * Date: 2009-2-23 * Time: 10:12 * Modify: 2009-2-24 20:15 * This is the file operate class,used to read template file or write a static html file from the template file */ using System; using System.Web; using System.Text; using System.IO; using System.Data; using System.Data.OleDb; /// <summary> ///FileOperator introduction ///This a File operate class that used to read template file or write a static html file from the template file /// </summary> public class FileOperate { public FileOperate() { } public static string ReadTemplate(string FileName) { string re=""; string path = HttpContext.Current.Server.MapPath("template/"); StreamReader sr = new StreamReader(path + FileName + ".template", System.Text.Encoding.GetEncoding("gb2312")); try { re=sr.ReadToEnd(); } catch(Exception ex) { throw ex; } finally { sr.Close(); } return re; } /// <summary> /// /// </summary> /// <param name="sb">a StringBuilder reference</param> /// <param name="FileName">output file name</param> public static void AddStaticWeb(StringBuilder sb,string FileName) { string path=HttpContext.Current.Request.ServerVariables["APPL_PHYSICAL_PATH"].ToString(); StreamWriter sw=new StreamWriter(path+FileName+".htm",false,System.Text.Encoding.GetEncoding("utf-8")); try { sw.Write(sb.ToString()); } catch(Exception ex) { throw ex; } finally { sw.Close(); } } } Create static article web page class

This class inherits from IDisposable interface, it has a Add () method, this method is used to replace the special markup like “[$$$title$$$]” in the template file, and this method calls a static method in File Operate class like

  “FileOperate.AddStaticWeb(sb, articleID.ToString());”, to excute this method, we can create a static html file named by artile ID in the determining path. The following code shows how to create a static artile web pages.    

using System; using System.Configuration; /* * Created by Visual Studio. * User: kangyi * Date: 2009-2-23 * Time: 21:40 * Modify: 2009-2-24 21:15 * This is the main class,used to make the article information to a static html file */ using System; using System.Data; using System.Data.OleDb; using System.Text; using System.Web; /// <summary> ///CreateArticle introduction: ///This class used to make the article information to a static html file /// </summary> public class CreateArticle:IDisposable { private int articleID; private string ArticleTitle; OleDbConnection conn; /// <summary> /// Constructor /// </summary> /// <param name="aid">article ID</param> public CreateArticle(int aid) { articleID = aid; } /// <summary> /// This method used to replace string with article inforation /// </summary> public void Add() { StringBuilder sb = new StringBuilder(); sb.Append(FileOperate.ReadTemplate("htmlTemp")); conn = DataAccess.GetConn(); using (ArticleEntity article = new ArticleEntity(articleID, "ArticleInfo", conn)) { ArticleTitle = article.ArticleTitle; sb.Replace("[$$$title$$$]", "News Reader" + article.ArticleTitle); sb.Replace("[$$$articletitle$$$]", article.ArticleTitle); sb.Replace("[$$$articlecontent$$$]", article.ArticleContent); sb.Replace("[$$$poublishDate$$$]", article.PublishDate); sb.Replace("[$$$articleAuthor$$$]", article.ArticleAuthor); } FileOperate.AddStaticWeb(sb, articleID.ToString()); } #region IDisposable member void IDisposable.Dispose() { GC.SuppressFinalize(this); conn.Close(); } #endregion }

From the above code, we can see there is a code block like

 

using (ArticleEntity article = new ArticleEntity(articleID, "ArticleInfo", conn)) { ArticleTitle = article.ArticleTitle; sb.Replace("[$$$title$$$]", "News Reader" + article.ArticleTitle); sb.Replace("[$$$articletitle$$$]", article.ArticleTitle); sb.Replace("[$$$articlecontent$$$]", article.ArticleContent); sb.Replace("[$$$poublishDate$$$]", article.PublishDate); sb.Replace("[$$$articleAuthor$$$]", article.ArticleAuthor); }

And this block is important to this system. In this block, it is using the Replace(string,string) method of the StringBulider class, use this method we can replace the special markup that we defined in the template file, and then we call the AddStaticWeb(string, string) method of the File Operate class to convert StringBuilder object to a string by ToString() method, and then write this string to a html file name by article ID, and then we could create a static html file successful.

Example:

The following code shows how to call all above class method to create a html pages.

 

protected void Button1_Click(object sender, EventArgs e) { try { DataTable dt; dt = DataAccess.CreateDataTabel("ArticleInfo"); for (int i = 0; i < dt.Rows.Count; i++) { using (CreateArticle ca = new CreateArticle(Convert.ToInt32(dt.Rows[i][0].ToString()))) { ca.Add(); } } Response.Write("<mce:script type="text/javascript"><!-- alert('Create static website successful.'); // --></mce:script>"); } catch (OleDbException ex) { Response.Write("<mce:script type="text/javascript"><!-- alert('" + ex.Message.ToString() + "'); // --></mce:script>"); } } Reference

<!--[if !supportLists]-->1、  <!--[endif]-->Microsoft .NET Framework 2.0 Documentation.

<!--[if !supportLists]-->2、  <!--[endif]-->Effective C#