using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
class DOB
{
string strconn = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
public bool CheckUserInfo(string name,string pwd) {
bool b = true;
SqlConnection conn = new SqlConnection(strconn);
try
{
string str = "select count(*) from Admin where LoginId='" + name + "' and LoginPwd='" + pwd + "'";
Console.WriteLine(str);
conn.Open();
SqlCommand comm = new SqlCommand(str, conn);
int iRet = (int)comm.ExecuteScalar();
if (iRet == 1)
{
b = true;
}
else {
b = false;
}
}
catch (Exception)
{
Console.WriteLine("发生异常");
}
finally {
conn.Close();
}
return b;
}
public int GetStudentAmount() {
SqlConnection conn = new SqlConnection(strconn);
try
{
string strsql = "select count(*) from Student";
conn.Open();
SqlCommand comm = new SqlCommand(strsql, conn);
int iRet = (int)comm.ExecuteScalar();
return iRet;
}
catch (Exception)
{
return -1;
throw;
}
finally {
conn.Close();
}
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
class SchoolManager
{
DOB d = new DOB();
public void Login()
{
Console.WriteLine("请输入用户名:");
string name = Console.ReadLine();
Console.WriteLine("请输入密码:");
string pwd = Console.ReadLine();
bool r = d.CheckUserInfo(name, pwd);
if (r)
{
Console.WriteLine("登陆成功!");
caidan();
}
else
{
Console.WriteLine("登陆失败!");
}
}
public void caidan()
{
Console.WriteLine("=================请选择操作数==================");
Console.WriteLine("1. 统计学生人数");
Console.WriteLine("2. 查看学生名单");
Console.WriteLine("3. 按单号查询学生的姓名");
Console.WriteLine("4. 按姓名查询学生信息");
Console.WriteLine("5. 修改学生的出生日期");
Console.WriteLine("6. 删除学生记录");
Console.WriteLine("7. 新增年级记录");
Console.WriteLine("0.退出");
Console.WriteLine("===============================================");
int z = int.Parse(Console.ReadLine());
switch (z)
{
case 1:
Console.WriteLine("在校学生人数:" + d.GetStudentAmount());
caidan();
break;
case 2:
caidan();
break;
case 3:
caidan();
break;
case 4:
caidan();
break;
case 5:
caidan();
break;
case 6:
caidan();
break;
case 7:
caidan();
break;
case 0:
Console.WriteLine("谢谢使用");
break;
default:
Console.WriteLine("输入错误");
break;
}
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
class Class1
{
static void Main(string[] args)
{
SchoolManager s = new SchoolManager();
s.Login();
Console.ReadLine();
}
}
}