Sql-based-password-authentication.rar_登陆 html sql

/// <summary> /// LoginFrm 的摘要说明。 /// </summary> public class LoginFrm : System.Windows.Forms.Form { public static bool blCanLogin = false; //记录能否检验是否通过 public static string strUser = ""; //记录用户名 public static string strDepartment = "";//记录通过者所属部门 private DataSet ds = new DataSet(); private DataTable myTable; private DataRow myRow; private string sendStrSQL = "SELECT * from 用户清单"; private System.Windows.Forms.Label label1; private System.Windows.Forms.Label label2; private System.Windows.Forms.Label label3; private System.Windows.Forms.Button btn_Cancel; private System.Windows.Forms.Button btn_Login; private System.Windows.Forms.TextBox txt_ID; private System.Windows.Forms.TextBox txt_Name; private System.Windows.Forms.TextBox txt_Pwd; private System.Windows.Forms.GroupBox groupBox1; private System.Windows.Forms.Label LB_Warning; /// <summary> /// 必需的设计器变量。 /// </summary> private System.ComponentModel.Container components = null; public LoginFrm() { // // Windows 窗体设计器支持所必需的 // InitializeComponent(); // // TODO: 在 InitializeComponent 调用后添加任何构造函数代码 // //初始化窗体时，从数据库中的“用户清单”表中检索数据并保存在mytable中 LinkDataBase link = new LinkDataBase(); string sendTableName = "用户清单"; this.ds = link.SelectDataBase(sendStrSQL,sendTableName); this.myTable = ds.Tables[0]; } /// <summary> /// 清理所有正在使用的资源。 /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if(components != null) { components.Dispose(); } } base.Dispose( disposing ); } //-------------根据输入的用户名和密码进行登录校验------------ private void btn_Login_Click(object sender, System.EventArgs e) { for (int i=0;i<myTable.Rows.Count;i++) { this.myRow = myTable.Rows[i]; //只有当输入的用户名和密码同时对应上数据库中记录时，才能通过校验 if (myRow[0].ToString().Trim()==this.txt_ID.Text.ToString().Trim() && myRow[4].ToString().Trim()==this.txt_Pwd.Text.ToString().Trim()) { blCanLogin = true; strUser = myRow[0].ToString().Trim();//保存用户名 strDepartment = myRow[1].ToString().Trim();//保存部门名称 this.Close();//关闭窗体 return; } } MessageBox.Show( "您输入的用户号或密码不正确!"); return; } //-------关闭登录窗口，不进行任何操作----------- private void btn_Cancel_Click(object sender, System.EventArgs e) { blCanLogin = false; this.Close(); } //----当鼠标离开用户号填写框，立即从数据库中检索出对于用户名称并显示---- private void txt_ID_Leave(object sender, System.EventArgs e) { this.txt_Name.Text = ""; for (int i=0;i<myTable.Rows.Count;i++) { this.myRow = myTable.Rows[i]; if (myRow[0].ToString().Trim()==this.txt_ID.Text.ToString().Trim()) { this.txt_Name.Text = myRow[2].ToString().Trim(); this.txt_Pwd.Focus(); } } } }