ASP.NET使用数据库实现网站统计器

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.SessionState;
using System.Xml.Linq;
using System.Data.SqlClient;

//使用数据库存在总访问量，这样一个网站统计器

//
//Global.asas.cs文件中，定义全局变量
//

namespace PPPP
{
    public class Global : System.Web.HttpApplication
    {
        private string strConnString = "server=localhost;database=REGISTER;uid=sa;pwd=tianshi520;";

        protected void Application_Start(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(strConnString);
            conn.Open();
            SqlCommand cmd = new SqlCommand("select * from visit", conn);
            int total = (int)(cmd.ExecuteScalar());
            conn.Close();

            Application["total"] = total;
            Application["online"] = 0;
            
        }


        protected void Session_Start(object sender, EventArgs e)
        {
            Session.Timeout = 1;
            Application.Lock();
            Application["total"] = Convert.ToInt32(Application["total"]) + 1;
            Application["online"] = Convert.ToInt32(Application["online"]) + 1;
            Application.UnLock();
        }


        protected void Session_End(object sender, EventArgs e)
        {
            // 在会话结束时运行的代码。
            // 注意: 只有在 Web.config 文件中的 sessionstate 模式设置为 
            // InProc 时，才会引发 Session_End 事件。如果会话模式设置为 StateServer 
            // 或 SQLServer，则不会引发该事件。
            Application.Lock();
            Application["online"] = Convert.ToInt32(Application["online"]) - 1;
            Application.UnLock();
        }

        protected void Application_End(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(strConnString);
            conn.Open();
            SqlCommand cmd = new SqlCommand("insert into visit values(" + Application["total"] + ")", conn);
            cmd.ExecuteNonQuery();
            conn.Close();
        }
    }
}


//
//default.aspx中加入以下两句代码：
//当前在线人数：<asp:Label ID="online" runat="Server" /> <br />
//历史访问量：<asp:Label ID="total" runat="Server" />
//


//
//default.aspx.cs
//加入以下代码：
/*
 * 
        protected void Page_Load(object sender, EventArgs e)
        {
            online.Text = Application["online"].ToString();
            total.Text = Application["total"].ToString();
        }
 * /
//