protected void surebtm_Click(object sender, EventArgs e)
{
string name = Request["username"];
string password = Request["password"];
PersonEntity person = new PersonEntity();
person.Password = password;
person.Username = name;
Didsqlconntion sql = new Didsqlconntion();
if (name == "")
{
userLab.Text = "用户名不能为空！";
}
if (sql.getperson(person))
{
// Response.Cookies.Add(cookie);
if (menberbox.Checked)
{
HttpCookie cookie = new HttpCookie("user", name);
cookie.Expires = DateTime.MaxValue;//设置Cookie 永不过期
Response.Cookies.Add(cookie);
}
Server.Transfer("Main.aspx");
}
else
{
errorLab.Text = "用户名或密码错误！";
}
}
public bool getperson(PersonEntity person)
{
bool flag = false;
conn.Open();
string query = "select * from persondetails where username=?name and password=?password";
MySqlCommand myCommand = new MySqlCommand(query, conn);
myCommand.Parameters.AddWithValue("?name", person.Username);
myCommand.Parameters.AddWithValue("?password", person.Password);
myCommand.ExecuteNonQuery();
MySqlDataReader myDataReader = myCommand.ExecuteReader();
while (myDataReader.Read() == true)
{
personentity.Username = myDataReader["username"].ToString().Trim();
personentity.Password = myDataReader["password"].ToString().Trim();
}
if (person.Username.Equals(personentity.Username)&&person.Password.Equals(personentity.Password))
{
flag =true ;
}
conn.Close();
myDataReader.Close();
return flag;
}