急啊，请问如何统计网站的总访问量和今日访问量？高手们请帮忙，先谢了，在线等...

.aspx页面代码
----------------------------------------------------------<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UserCount.aspx.cs" Inherits="UserCount" %><!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>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <center>
            
            <br />
            <font>
                你是本站今天第<%=Application["day_count"].ToString() %>访问者！
            </font>
        </center>
    </div>
    </form>
</body>
</html>
Global.asax页面代码
----------------------------------------------------------------------<%@ Application Language="C#" %>
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Collections" %>
<%@ Import Namespace="System.ComponentModel" %>
<%@ Import Namespace="System.Web" %>
<%@ Import Namespace="System.Web.SessionState" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Data" %><script runat="server">    void Application_Start(object sender, EventArgs e)
    {
        // Code that runs on application startup
        string connectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
        OleDbConnection conn = null;
        int count = 0;
        int day_count = 0;
        int year = 0;
        int month = 0;
        int day = 0;        try
        {
            DataSet ds = new DataSet();            // 创建数据库链接，并打开此连接
            conn = new OleDbConnection(connectionString);
            conn.Open();            OleDbCommand cmd = new OleDbCommand();
            cmd.CommandText = "select count from SiteCount";
            cmd.Connection = conn;
            OleDbDataAdapter adapter = new OleDbDataAdapter();
            adapter.SelectCommand = cmd;
            adapter.Fill(ds);            if(ds.Tables[0].Rows.Count != 0 )
            {
                System.Data.DataRow dr = ds.Tables[0].Rows[0];
                count = Convert.ToInt32(dr["count"].ToString());
            }            ds.Clear();
            cmd.CommandText = "select count,year,month,day from DayCount";
            cmd.Connection = conn;
            adapter.SelectCommand = cmd;
            adapter.Fill(ds);
            if (ds.Tables[0].Rows.Count != 0)
            {
                System.Data.DataRow dr = ds.Tables[0].Rows[0];                day_count = Convert.ToInt32(dr["count"].ToString());
                year = Convert.ToInt32(dr["year"].ToString());
                month = Convert.ToInt32(dr["month"].ToString());
                day = Convert.ToInt32(dr["day"].ToString());
            }            DateTime today = DateTime.Now;
            if ((today.Year != year) || (today.Month != month) || (today.Day != day))
            {
                day_count = 0;
            }

            Application["count"] = count;
            Application["day_count"] = day_count;
        }
        catch (OleDbException ex)
        {
            throw ex;
        }
        finally
        {
            try
            {
                if (conn != null)
                    conn.Close();
            }
            catch (OleDbException ex)
            {
                throw ex;
            }
        }
    }

    void Application_End(object sender, EventArgs e)
    {
        //  Code that runs on application shutdown
        int count = 0;
        count = (int)Application["counter"];
        int day_count = (int)Application["day_count"];        string connectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
        OleDbConnection conn = null;
        DateTime today = DateTime.Now;        try
        {
            DataSet ds = new DataSet();            // 创建数据库链接，并打开此连接
            conn = new OleDbConnection(connectionString);
            conn.Open();            OleDbCommand cmd = new OleDbCommand();
            cmd.CommandText = "update SiteCount set count=" + count;
            cmd.Connection = conn;
            OleDbDataAdapter adapter = new OleDbDataAdapter();
            adapter.UpdateCommand = cmd;
            cmd.ExecuteNonQuery();            cmd.CommandText = "update DayCount set count=" + day_count + ",year=" + today.Year + ",month=" + today.Month + ",day=" + today.Day;
            cmd.Connection = conn;
            adapter.UpdateCommand = cmd;
            cmd.ExecuteNonQuery();
        }
        catch (OleDbException ex)
        {
            throw ex;
        }
        finally
        {
            try
            {
                if (conn != null)
                    conn.Close();
            }
            catch (OleDbException ex)
            {
                throw ex;
            }
        }    }

    void Application_Error(object sender, EventArgs e)
    {
        // Code that runs when an unhandled error occurs    }    void Session_Start(object sender, EventArgs e)
    {
        // Code that runs when a new session is started
        Application.Lock();

        int count = 0;
        int day_count = 0;
        DateTime today = DateTime.Now;        if (Application["count"] != null)
        {
            object obj = Application["count"];
            object obj_day = Application["day_count"];
            count = (int)obj;
            day_count = (int)obj_day;
            count++;
            day_count++;
            Application["count"] = count;
            Application["day_count"] = day_count;            string connectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
            OleDbConnection conn = null;            try
            {
                DataSet ds = new DataSet();                // 创建数据库链接，并打开此连接
                conn = new OleDbConnection(connectionString);
                conn.Open();                OleDbCommand cmd = new OleDbCommand();
                cmd.CommandText = "update SiteCount set count=" + count;
                cmd.Connection = conn;
                OleDbDataAdapter adapter = new OleDbDataAdapter();
                adapter.UpdateCommand = cmd;
                cmd.ExecuteNonQuery();                cmd.CommandText = "update DayCount set count=" + day_count + ",year=" + today.Year + ",month=" + today.Month + ",day=" + today.Day;
                cmd.Connection = conn;
                adapter.UpdateCommand = cmd;
                cmd.ExecuteNonQuery();
            }
            catch (OleDbException ex)
            {
                //alert("数据库错误：" + ex.Message);
            }
            finally
            {
                try
                {
                    if (conn != null)
                        conn.Close();
                }
                catch (OleDbException ex)
                {
                    //alert("数据库错误：" + ex.Message);
                }
            }
        }
        else
        {
            Application_Start(sender, e);
        }

        Application.UnLock();     }    void Session_End(object sender, EventArgs e)
    {
        // Code that runs when a session ends.
        // Note: The Session_End event is raised only when the sessionstate mode
        // is set to InProc in the Web.config file. If session mode is set to StateServer
        // or SQLServer, the event is not raised.    }

</script>

调试易

急啊，请问如何统计网站的总访问量和今日访问量？高手们请帮忙，先谢了，在线等...

解决方案 »