shownews.aspx.cs

来自「一个简单的新闻发布系统,入门最好先学这个」· CS 代码 · 共 45 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class shownews : System.Web.UI.Page
{
    public DataRow dr;
    public string newsid;
    protected void Page_Load(object sender, EventArgs e)
    {
        newsid = Request.Params["id"];
        string strConnnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
        strConnnection += Server.MapPath(".\\App_Data\\news.mdb");
        OleDbConnection myconn = new OleDbConnection(strConnnection);

        OleDbDataAdapter mycmd = new OleDbDataAdapter("select * from contents where id="+newsid,myconn);
        DataSet ds = new DataSet();
        mycmd.Fill(ds,"contents");
        dr = ds.Tables["contents"].Rows[0];

        //获取制定编号新闻的访问次数
        OleDbCommand mycmd2 = new OleDbCommand("select  click from contents where id="+newsid,myconn);
        mycmd2.Connection.Open();
        OleDbDataReader reader = mycmd2.ExecuteReader();
        //将访问次数转换成整数，然后加1
        int i =Convert.ToInt32(dr["click"]);
        i++;
        reader.Close();
        //重新定义语句，更新访问次数
        mycmd2.CommandText = "update  contents set click='"+i.ToString()+"'where id ="+newsid;
        mycmd2.ExecuteNonQuery();
        mycmd2.Connection.Close();
        myconn.Close();

    }
}