logon.aspx.cs

一个关于登录数据库的源代码,数据库为ACCESS数据库

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Data.OleDb;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Security;
using System.Text;
using System.Text.RegularExpressions;

namespace WebApplication3
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.HtmlControls.HtmlInputText TextBox1;
		protected System.Web.UI.HtmlControls.HtmlInputButton Button1;
		protected System.Web.UI.HtmlControls.HtmlInputButton Button2;
		protected System.Web.UI.HtmlControls.HtmlGenericControl DIV1;
		protected System.Web.UI.HtmlControls.HtmlInputText TextBox2;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.HtmlControls.HtmlGenericControl DIV2;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
		}

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

		}
		#endregion

		
		private void TextBox1_TextChanged(object sender, System.EventArgs e)
		{

		}

		private void TextBox2_ServerChange(object sender, System.EventArgs e)
		{
		
		}

		private void Password1_ServerChange(object sender, System.EventArgs e)
		{
		
		}



		private void Button1_ServerClick(object sender, System.EventArgs e)
		{
			try
			{//连接数据库
				string strConnection = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\用户信息.mdb";//(local)
				OleDbConnection con = new OleDbConnection(strConnection);
				if(TextBox1.Value!="")
				{//查询
					string query="";
					query="SELECT * FROM 用户注册信息 WHERE(NAME='"+TextBox1.Value+"')";
					OleDbCommand cmd=new OleDbCommand(query,con);
					con.Open();
                    OleDbDataReader rd = cmd.ExecuteReader();
					if (rd.Read())
					{
						if (rd["NAME"].ToString() == TextBox1.Value)
						{
							if (rd["PWD"].ToString() ==TextBox2.Value)
							{
								if(rd["PERMISSION"].ToString()=="0")
								{
									con.Close();
									Response.Write("<script>alert('对不起,您的注册信息还没有得到批准,请耐心等待')</script>");
								}
								else if(rd["PERMISSION"].ToString()=="1")
								{
									string NameCookie=TextBox1.Value;
									string PowerCookie=rd["POWER"].ToString();
									HttpCookie cookie = new HttpCookie("Info");//定义cookie对象以及名为Info的项
									DateTime dt = DateTime.Now;//定义时间对象
									TimeSpan ts=new TimeSpan(1,0,0,0);//cookie有效作用时间，具体查msdn
									cookie.Expires = dt.Add(ts);//添加作用时间
									cookie.Values.Add("user",NameCookie);
									cookie.Values.Add("userpower",PowerCookie);// 
									
									Response.AppendCookie(cookie);//确定写入cookie中 
									 if(rd["POWER"].ToString()=="院级管理员")								  							
									{
										con.Close();
										 Response.Redirect("zww_main.aspx");
										//Response.Redirect("AfterLogon1.aspx");
									}
								 
									if(rd["POWER"].ToString()=="科级管理员")
									{
										con.Close();
										Response.Redirect("AfterLogon2.aspx");
									}
								
									if(rd["POWER"].ToString()=="普通人员")
									{
										con.Close();
										Response.Redirect("AfterLogon3.aspx");
									}
									else
									{
										con.Close();
										Response.Redirect("PWDWrong.aspx");
									} 
                                      
									  
  
 
  
									
								}
									/*else if(rd["PERMISSION"].ToString()=="2")
										Response.Write("<script>alert('对不起,您申请注册时失败')</script>");*/
								else if(rd["PERMISSION"].ToString()=="2")
								{
									con.Close();
									Response.Write("<script>alert('对不起,您已经被注销')</script>");
								}
							}
							else
							{    
								con.Close();
								 Response.Redirect("PWDWrong.aspx");
							}
						}
						else
						{   
							con.Close();
							Response.Write("<script>alert('用户名错误！')</script>");
						}
                    
					}
					else
					{
						con.Close();
						Response.Write("<script>alert('用户不存在！')</script>");
					}

				}
				else
					Response.Write("<script>alert('用户名不能为空')</script>");
				
			}			
		
			catch (SqlException ee)
			{
				Console.WriteLine(ee);
				Server.Transfer("Error.aspx");
			}

		}

		private void Button2_ServerClick(object sender, System.EventArgs e)
		{
		       Response.Redirect("Register.aspx");
		}

		private void Button3_Click(object sender, System.EventArgs e)
		{
			HttpCookie cookie = new HttpCookie("Info");//定义cookie对象以及名为Info的项
			DateTime dt = DateTime.Now;//定义时间对象
			TimeSpan ts=new TimeSpan(1,0,0,0);//cookie有效作用时间，具体查msdn
			cookie.Expires = dt.Add(ts);//添加作用时间
			cookie.Values.Add("user","cba");// 
		
			Response.AppendCookie(cookie);//确定写入cookie中 
Response.Redirect("AfterLogon1.aspx");
		}


		
	}

}