当前位置： 移动技术网 > IT编程>开发语言>.net > .net实现页面访问次数统计

.net实现页面访问次数统计

2018年10月30日  | 移动技术网IT编程  | 我要评论

温立三,胡雯靖下载,高中生新娘第一季

准备:建立一个表total里面数据项为totals类型为varchar 50

 

.net语言环境:c#

 

global.asax里的代码

 

<%@ import namespace="system.data" %>

<%@ import namespace="system.data.sqlclient" %>

 

<script language="c#" runat="server">

string strselect;

sqlconnection conpubs;

sqldataadapter dadpubs;

dataset dsttitles;

datarow drowtitle; 

    

void session_start(object sender , eventargs e) 

{

if ( application[ "sessioncount" ] == null ) {

    application[ "sessioncount" ] = 0;

    strselect = "select totals from total";

    conpubs = new sqlconnection(@"server=localhost;integrated security=sspi;database=test");

    dadpubs = new sqldataadapter(strselect, conpubs);

    dsttitles = new dataset();

    dadpubs.fill(dsttitles, "total"); 

    drowtitle = dsttitles.tables["total"].rows[0];

    application[ "sessioncount" ]=system.convert.toint32(drowtitle["totals"].tostring().trim());

}

}

 

void session_end() {

    application["sessioncount"] = 0;   

}

 

</script>

 

============================

 

sessioncount.x里的代码

 

void page_load(object sender , eventargs e) 

{

    int total = 0;

    string strselect;

    sqlconnection conpubs;

    //要执行某项数据操作要用sqlcommand方式调用

    sqlcommand cmdsql;

 

    //为了防止同文档里的其他页面在访问时也进行累加运算

    int inthits = 0;

    inthits = (int)application["sessioncount"];

    inthits += 1;

    application["sessioncount"] = inthits;

      

    lblsessioncount.text = application[ "sessioncount" ].tostring();

    total = (int)application["sessioncount"];

    strselect = "update total set totals= @total";

    conpubs = new sqlconnection(@"server=localhost;integrated security=sspi;database=test");

    cmdsql = new sqlcommand(strselect, conpubs);

    cmdsql.parameters.add("@total", total);

    conpubs.open();

    cmdsql.executenonquery();

    conpubs.close();

}

================上段代码有个小问题,就是过了一段时间后,application["sessioncount"]的值会变成0,而且由于前面设置了一个初始的0,也会连带的把数据库里原来保存的值更新为0起始.

 

更改后

 

global.asax

 

<%@ import namespace="system.data" %>

<%@ import namespace="system.data.sqlclient" %>

 

<script language="c#" runat="server">

string strselect;

sqlconnection conpubs;

sqldataadapter dadpubs;

dataset dsttitles;

datarow drowtitle; 

    

void session_start(object sender , eventargs e) 

{

if ( application[ "sessioncount" ] == null ) {

    application[ "sessioncount" ] = 0;

    strselect = "select totals from total";

    conpubs = new sqlconnection(@"server=localhost;integrated security=sspi;database=test");

    dadpubs = new sqldataadapter(strselect, conpubs);

    dsttitles = new dataset();

    dadpubs.fill(dsttitles, "total"); 

    drowtitle = dsttitles.tables["total"].rows[0];

    application[ "sessioncount" ]=system.convert.toint32(drowtitle["totals"].tostring().trim());

}

}

 

void session_end() {

    application["sessioncount"] = null;   

}

 

</script>

 

------------

 

sessioncount.aspx

 

<script language="c#" runat="server">

 

void page_load(object sender , eventargs e) 

{

    int total = 0;

    string strselect;

    sqlconnection conpubs;

    //要执行某项数据操作要用sqlcommand方式调用

    sqlcommand cmdsql;

 

    //为了防止同文档里的其他页面在访问时也进行累加运算

    int inthits = 0;

    inthits = (int)application["sessioncount"];

    inthits += 1;

    total = inthits;

    

    lblsessioncount.text = inthits.tostring();

     strselect = "update total set totals= @total";

    conpubs = new sqlconnection(@"server=localhost;integrated security=sspi;database=test");

    cmdsql = new sqlcommand(strselect, conpubs);

    cmdsql.parameters.add("@total", total);

    conpubs.open();

    cmdsql.executenonquery();

    conpubs.close();

    application["sessioncount"] = null;

}

 

</script>

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网