/// <summary> /// 根据学生姓名查询学生信息 /// </summary> public void Query_five() { Console.WriteLine("请输入要查询的学生姓名:"); string Student_Name = Console.ReadLine(); string sql = string.Format("Select StudentNo,StudentName,Sex,GradeId,Phone,Address,BornDate,Email from Student Where StudentName Like '{0}%'", Student_Name); Console.WriteLine("================================================================================================================"); Console.WriteLine("学号\t\t姓名\t性别\t年级\t联系电话\t地址\t\t出生日期\t\t邮箱"); Console.WriteLine("================================================================================================================"); try { var reader = DBOperation.ExecuteReader(sql); StringBuilder buil = new StringBuilder(); while (reader.Read()) { buil.AppendFormat("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}", reader["StudentNo"], reader["StudentName"], reader["Sex"], reader["GradeId"], reader["Phone"], reader["Address"], reader["BornDate"], reader["Email"]); Console.WriteLine(buil); buil.Length = 0; } reader.Close(); } catch (Exception ex) { Console.WriteLine("出现异常:{0}", ex.Message); } finally { DBOperation.CloseConnection(); //Console.WriteLine("数据库关闭成功!"); } }
public void CheckDBCloseConnection() { DBOperation operation = new DBOperation(); operation.CloseConnection(); Assert.AreEqual(operation.CheckConnectionState(), false); }
/// <summary> /// 按学号查询学生姓名 /// </summary> public void Query_four() { Console.WriteLine("请输入要查询的学生学号:"); string Student_id = Console.ReadLine(); string sql = string.Format("Select StudentName from Student Where StudentNo Like '%{0}'", Student_id); try { var reader = DBOperation.ExecuteReader(sql); StringBuilder buil = new StringBuilder(); while (reader.Read()) { buil.AppendFormat("学号是:{0}的学生姓名为:{1}", Student_id, reader["StudentName"]); Console.WriteLine(buil); buil.Length = 0; } reader.Close(); } catch (Exception ex) { Console.WriteLine("出现异常:{0}", ex.Message); } finally { DBOperation.CloseConnection(); //Console.WriteLine("数据库关闭成功!"); } }
string name; //用户名 /// <summary> /// 判断用户密码是否有误 /// </summary> public void Query_one() { //登陆账号 Console.WriteLine("请输入用户名:"); name = Console.ReadLine(); Console.WriteLine("请输入密码:"); string pwo = Console.ReadLine(); string sql = string.Format("Select StudentName,LoginPwe from Student Where StudentName='{0}' and LoginPwe='{1}'", name, pwo); try { var reader = DBOperation.ExecuteReader(sql); if (reader.HasRows != true) { Console.WriteLine("登陆失败!用户名或密码有误!"); } else { Console.WriteLine("登陆成功!欢迎:{0}\n\n欢迎使用学生管理系统", name); reader.Close(); Choose_one(); } } catch (Exception ex) { Console.WriteLine("出现异常:{0}", ex.Message); } finally { DBOperation.CloseConnection(); //Console.WriteLine("数据库关闭成功!"); } }
/// <summary> /// 查询学生信息 /// </summary> public void Query_three() { string sql = "Select StudentNo,StudentName from Student"; Console.WriteLine("===================================================="); Console.WriteLine("学号\t\t\t姓名"); Console.WriteLine("===================================================="); try { var reader = DBOperation.ExecuteReader(sql); StringBuilder buil = new StringBuilder(); while (reader.Read()) { buil.AppendFormat("{0}\t\t{1}", reader["StudentNo"], reader["StudentName"]); Console.WriteLine(buil); buil.Length = 0; } reader.Close(); } catch (Exception ex) { Console.WriteLine("出现异常:{0}", ex.Message); } finally { DBOperation.CloseConnection(); //Console.WriteLine("数据库关闭成功!"); } }
private void MovieRentForm_FormClosed(object sender, FormClosedEventArgs e) { operation.CloseConnection(); this.HomeForm.Show(); }
private void MovieOperations_FormClosing(object sender, FormClosingEventArgs e) { db.CloseConnection(); }