private void button1_Click(object sender, EventArgs e)
{
String username = this.textBox1.Text;
String password = this.textBox2.Text;
Database2 db = new Database2();
MySqlConnection conn = db.getConn();
if (username.Equals("") || password.Equals(""))
{
MessageBox.Show("账号或密码为空");
}
else
{
try
{
conn.Open();
String sql1 = String.Format("select * from `c#_store`.user_store where username= '******' ", username);
MySqlCommand comm2 = new MySqlCommand(sql1, conn);
if (Convert.ToInt32(comm2.ExecuteScalar()) > 0)
{
String sql = String.Format("select username,password from `c#_store`.user_store where username = '******' limit 1",
username);
MySqlCommand comm1 = new MySqlCommand(sql, conn);
MySqlDataReader reader = comm1.ExecuteReader();
while (reader.Read())
{
String username1 = reader[0].ToString();
String password1 = reader[1].ToString();
if (username1 != null && password.Equals(password1))
{
// db.insert(sql);
Form1 form1 = new Form1();
form1.username = username;
db.insert("登录成功");
MessageBox.Show("登录成功");
this.Hide();
form1.Show();
}
else
{
db.insert("登录失败");
MessageBox.Show("密码错误,请重新输入");
}
}
reader.Close();
}
else
{
MessageBox.Show("账户不存在,请注册");
register r = new register();
r.Show();
this.Hide();
}
}
catch (Exception exception)
{
Console.WriteLine(exception);
MessageBox.Show(exception.Message.ToString());
}
finally
{
conn.Close();
}
}
}