index.aspx.cs

比较简单的网站登陆器

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Xml ;

namespace todotnet_kinghome
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{  
		public string countvisit;
		protected System.Web.UI.WebControls.TextBox username;
		protected System.Web.UI.WebControls.TextBox pasw;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Label wel;
		protected System.Web.UI.WebControls.Calendar Calendar1;
		protected System.Web.UI.WebControls.RadioButton vbnet;
		protected System.Web.UI.WebControls.RadioButton csharp;
		protected System.Web.UI.WebControls.RadioButton asp;
		protected System.Web.UI.WebControls.RadioButton php;
		protected System.Web.UI.WebControls.Button vote;
		protected System.Web.UI.WebControls.DataGrid mysoft;
		protected System.Web.UI.WebControls.DataGrid websoft;

		public string countreg;
	
		private void Page_Load(object sender, System.EventArgs e)
		{  
			Session.Timeout =20;
			string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
			string DataBase  = Server.MapPath("db/hsjdata.mdb");
			strConnection += "Data Source=" + DataBase;
		
			string strSQL = "SELECT * FROM ps where username='all'";
			OleDbConnection objConnection = new OleDbConnection(strConnection);
			OleDbCommand objCommand =new OleDbCommand(strSQL, objConnection);
			if (Session["guestin"]!="hasin")
			{Application.Lock() ;
				Session["guestin"]="hasin";
				string upsql  = "UPDATE ps SET visitime=visitime+1 where username='all'";
				OleDbCommand upcommand =new OleDbCommand(upsql, objConnection);
				upcommand.Connection.Open();
				upcommand.ExecuteNonQuery();
				upcommand.Connection.Close();
			Application.UnLock() ;}
			OleDbDataReader objDataReader ;
			objCommand.Connection.Open();
			objDataReader = objCommand.ExecuteReader();
			if (objDataReader.Read() == true) 
			{countvisit=objDataReader.GetValue(3).ToString();}
			objCommand.Connection.Close();
			 strSQL = "select * from ps order by id desc";
            objCommand.Connection.Open();
            objDataReader = objCommand.ExecuteReader();
            if (objDataReader.Read() == true) 
              countreg = objDataReader.GetValue(1).ToString();
              objCommand.Connection.Close();
			

		}
		public void Button1_click(object sender, System.EventArgs e)
		{ 
			Session["username"]=username.Text ;
			string getpasw=pasw.Text ;
			if (Session["username"]=="" || getpasw=="") 
			{
					wel.Text="请输入完整资料!";
				return;}
			string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
			string DataBase  = Server.MapPath("db/hsjdata.mdb");
			strConnection += "Data Source=" + DataBase;
			string strSQL = "SELECT * FROM ps where username='" + Session["username"]+ "'";
			OleDbConnection objConnection = new OleDbConnection(strConnection);
			OleDbCommand objCommand =new OleDbCommand(strSQL, objConnection);
			OleDbDataReader objDataReader ;
			objCommand.Connection.Open();
			objDataReader = objCommand.ExecuteReader();
			if (objDataReader.Read() == false) 
			{
				wel.Text = "该用户名还未注册!";
				return;}
			else if(objDataReader.GetString(2)!=getpasw)
			{
				wel.Text="密码错误!";
				return;}
			else
			{  string times= objDataReader.GetValue(3).ToString() ;



            if (Session["username.text"] == "hasin" )
			{wel.Text = "欢迎" + Session["username"] + "重新登陆本站!";
				return;}
            else
                wel.Text = "欢迎" + Session["username"] + "第" + times + "次登陆本站!";
                string upsql  = "UPDATE ps SET visitime=visitime+1 where username='" + Session["username"] + "'";
                OleDbCommand upcommand = new OleDbCommand(upsql, objConnection);

                objCommand.Connection.Close();
                upcommand.Connection.Open();
                upcommand.ExecuteNonQuery();
                upcommand.Connection.Close();
                Session["username.text"]= "hasin";
			}
		}

		
			 


		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}