62,046
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
this.Title = "请登录";
UserName.Focus();
}
protected void UserLogin_Click(object sender, EventArgs e)
{
if (UserName.Text == "" || Password.Text == "")
{
Response.Write("<script language=javascript>alert('请输入完整的登录信息!');</script>");
return;
}
using (OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["db1ConnectionString"].ToString()))
try
{
con.Open();
string sql = "select * from tbUser where Username='" + UserName.Text + "'and Password='" + Password.Text + "'";
OleDbCommand cmd = new OleDbCommand(sql, con);
using (OleDbDataReader re = cmd.ExecuteReader())
{
string name = string.Empty;
string pwd = string.Empty;
string nick = string.Empty;
Int32 power = 0;
while (re.Read())
{
Session["name"] = re["Username"].ToString();
name = re["Username"].ToString();
Session["nick"] = re["Nick"].ToString();
nick = re["Nick"].ToString();
Session["pwd"] = re["Password"].ToString();
pwd = re["Password"].ToString();
Session["power "] = Int32.Parse(re["Power"].ToString());
power = Int32.Parse(re["Power"].ToString());
}
if (name.Trim() == UserName.Text.Trim() && pwd.Trim() == Password.Text.Trim())
{
//在这里添加这么一句话
Response.Write(power);
Response.End();
//然后你用不同的身份登陆进去,看看输出的是什么东西
if (power == 1) //power == 1,管理员登陆;为0为普通用户登陆
{
Response.Redirect("../聊天室/admin/main.aspx");
}
else
{
Response.Redirect("../聊天室/chat.htm");
}
}
}
}
catch (Exception ex)
{
throw;
}
}
protected void NewUser_Click(object sender, EventArgs e)
{
Response.Redirect("../聊天室/zhuce.aspx");
}
}
using System;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
this.Title = "请登录";
UserName.Focus();
}
protected void UserLogin_Click(object sender, EventArgs e)
{
if (UserName.Text == "" || Password.Text == "")
{
Response.Write("<script language=javascript>alert('请输入完整的登录信息!');</script>");
return;
}
using (OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["db1ConnectionString"].ToString()))
try
{
con.Open();
string sql = "select * from tbUser where Username='" + UserName.Text + "'and Password='" + Password.Text + "'";
OleDbCommand cmd = new OleDbCommand(sql, con);
using (OleDbDataReader re = cmd.ExecuteReader())
{
string name = string.Empty;
string pwd = string.Empty;
string nick = string.Empty;
Int32 power = 0;
while (re.Read())
{
Session["name"] = re["Username"].ToString();
name = re["Username"].ToString();
Session["nick"] = re["Nick"].ToString();
nick = re["Nick"].ToString();
Session["pwd"] = re["Password"].ToString();
pwd = re["Password"].ToString();
Session["power "] = Int32.Parse(re["Power"].ToString());
power = Int32.Parse(re["Power"].ToString());
}
if (name.Trim() == UserName.Text.Trim() && pwd.Trim() == Password.Text.Trim())
{
if (power == 1) //power == 1,管理员登陆;为0为普通用户登陆
{
Response.Redirect("../聊天室/admin/main.aspx");
}
else
{
Response.Redirect("../聊天室/chat.htm");
}
}
}
}
catch (Exception ex)
{
throw;
}
}
protected void NewUser_Click(object sender, EventArgs e)
{
Response.Redirect("../聊天室/zhuce.aspx");
}
}