当前文件路径：XuYuanQiang/BlessPost.aspx.cs

		            
 1using System;
 2using System.Collections;
 3using System.ComponentModel;
 4using System.Data;
 5using System.Data.OleDb;
 6using System.Drawing;
 7using System.Web;
 8using System.Web.SessionState;
 9using System.Web.UI;
10using System.Web.UI.WebControls;
11using System.Web.UI.HtmlControls;
12
13namespace pizi
14...{
15    /**//// <summary>
16    /// Summary description for BlessPost.
17    /// </summary>
18    public partial class BlessPost : System.Web.UI.Page
19    
20    ...{
21        protected void Page_Load(object sender, System.EventArgs e)
22        ...{
23            if(Request["Upsotname"]==null)
24            ...{
25                //Response.Write("错了！");
26                Server.Transfer("index.aspx");
27            }
28            this.isnullr();//判断此连接是否已被使用过了
29            string s =Request["Upsotname"].ToString();
30            Session["md5id"] =s;
31        }
32        void isnullr()
33        ...{
34            OleDbDataReader dr =null;
35            string Constr ="Provider=Microsoft.Jet.OLeDb.4.0;Data source=" + Server.MapPath("Love_Dai.mdb");
36            string Querystring ="Select cauthor from ccc_love where md5id=@md5id";
37            OleDbConnection oleconnection = new OleDbConnection(Constr);
38            OleDbCommand cmd = new OleDbCommand(Querystring,oleconnection);
39            cmd.Parameters.Add("@md5id",OleDbType.VarChar,250);
40            cmd.Parameters["@md5id"].Value = Request["Upsotname"].ToString();
41            try
42            ...{
43                oleconnection.Open();
44                dr = cmd.ExecuteReader();
45                cmd.Dispose();
46            }
47            catch(Exception ex)
48            ...{
49                Response.Write(ex.ToString());
50            }
51            //在此判断是否匹配到记录 True进入说明匹配到
52            if(dr.Read())
53            ...{
54                //判断是否连接是否有效 如果不为空 说明连接失效 跳转到index.aspx
55                if(dr["cauthor"].ToString()!=""&&dr["cauthor"].ToString()!=null)
56                ...{
57                    dr.Close();
58                    cmd.Dispose();
59                    oleconnection.Close();
60                    Server.Transfer("index.aspx");
61                }
62            }
63            //进入else说明没有匹配到 跳转到index.aspx
64            
65            else
66            ...{
67                dr.Close();
68                cmd.Dispose();
69                oleconnection.Close();
70                Server.Transfer("index.aspx");
71            }
72            
73            
74        }
75        
76
77        Web Form Designer generated code#region Web Form Designer generated code
78        override protected void OnInit(EventArgs e)
79        ...{
80            //
81            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
82            //
83            InitializeComponent();
84            base.OnInit(e);
85        }
86        
87        /**//// <summary>
88        /// Required method for Designer support - do not modify
89        /// the contents of this method with the code editor.
90        /// </summary>
91        private void InitializeComponent()
92        ...{    
93        }
94        #endregion
95    }
96}
97