下面是登陆按钮的事件,密码用MD5加密了。
using System.Data.OleDb; \\数据库引用
using System.Security.Cryptography; \\MD5加密引用
private void button1_Click(object sender, EventArgs e)
{
string cons = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\\Database.accdb"; \\数据库连接
string userid = this.textBox1.Text; \\用户名
string psd = this.textBox2.Text; \\ 密码
byte[] result = Encoding.Default.GetBytes(psd.Trim()); \\加密开始
MD5 md5 = new MD5CryptoServiceProvider();
byte[] output = md5.ComputeHash(result);
string pass = BitConverter.ToString(output).Replace("-", ""); \\加密结束
string sql = "SELECT * FROM LOGIN WHERE USERID='"+userid+"'";
OleDbConnection olc = new OleDbConnection(cons);
olc.Open();
OleDbCommand odc = new OleDbCommand(sql,olc);
if(odc.ExecuteScalar()!=null) \\判断用户名是否正确
{
string sqlx = "SELECT * FROM LOGIN WHERE USERID='" + userid + "' AND PASSWORD='"+pass+"'";
OleDbCommand odc2 = new OleDbCommand(sqlx,olc);
if(odc2.ExecuteScalar()!=null) \\判断密码是否正确
{
MessageBox.Show("恭喜您,登陆成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide(); \\隐藏登陆窗体
main mains = new main();
mains.Show(); \\显示主窗体
}
else
{
MessageBox.Show("您输入的密码有误,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Hand);
this.textBox2.Focus();
return;
}
}
else
{
MessageBox.Show("您输入的账号有误,请重新输入!","提示",MessageBoxButtons.OK,MessageBoxIcon.Hand);
this.textBox1.Focus();
return;
}
}