毕业设计--视频监控系统代码.docVIP

附录一 登录界面 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace MyVideopublic partial class frmLogin : Formpublic frmLoginInitializeComponent;private void frmLogin_Loadobject sender, EventArgs ethis.timer1.Start; //启动时间//确定private void btQueding_Clickobject sender, EventArgs eif tbName.Text.Trim ! tbPas.Text.Trim ! //信息输入框都不为空string LJ @Data SourcePC-座机电话号码CYWO;Initial CatalogMyData;Integrated SecurityTrue;//建立连接SqlConnection conn new SqlConnectionLJ;SqlCommand comm conn.CreateCommand;//实例化数据库的操作命令conn.Open;if rbStudent.Checked//学生string sql select sno,spass,sname from student wheresno + tbName.Text + ;comm.CommandText sql;SqlDataReader datar comm.ExecuteReader; //使 SqlDataReader 前进到下一条记录。返回一个bool值，如果为真跳出循环while datar.Read//读取数据库的内容，并与输入的进行比较；判断用户输入是否正确if datar[spass].ToString.Trim ! tbPas.Text.TrimMessageBox.Show密码不正确，请重新输入！;tbPas.Focus;//焦点：使光标聚焦在文本输入框return;elseForm1 f1 new Form1;this.Hide;//this.Close;f1.ShowDialog;//信息正确，界面跳转datar.Close;else if rbTeacher.Checked//老师string sql select tno,tpass,tname from teacher wheretno + tbName.Text + ;comm.CommandText sql;SqlDataReader datar comm.ExecuteReader;while datar.Read//判断用户输入是否正确if datar[tpass].ToString.Trim ! tbPas.Text.TrimMessageBox.Show用户名或密码不正确，请重新输入！;tbPas.Focus;return;elseForm1 f1 new Form1;this.Hide;//this.Close;f1.ShowDialog;datar.Close;else if rbAdmin.Checked//管理员string sql SELECT adminname,adminpass,adminID FROM admin WHEREadminID + tbName.Text + ;comm.CommandText sql;SqlDataReader datar comm.ExecuteReader;while datar.Readif datar[adminpass].ToString.Trim ! tbPas.Text.TrimMessageBox.Show密码不正确，请重新输入！;tbPas.Focus;return;elseAdminLogin f2 new AdminLogin;this.Hide;f2.ShowDialog;datar.Close;tbName.Text ;//用户信息错误，信息清除tbPas.Text ;elseMessageBox.Show用户或密码不能为空！;tbName.Focus;return;//取消private void btQuxiao_Clickobject sender