using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient; //SQL Server .NET 数据提供程序命名空间
namespace ConsoleApplication3
{
class Program
{
//测试打开数据库的操作
string strcoon = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
public bool CheckUserInfo(string userName, string pwd, ref string strMsg)
{
//创建数据库连接
SqlConnection conn = new SqlConnection(strcoon);
try
{
//创建Sql语句
string strSql = "select count(*) from Admin where LoginId='" + userName + "'and LoginPwd='" + pwd + "'";
conn.Open();
//创建Command 命令
SqlCommand comm = new SqlCommand(strSql, conn);
int iRet = (int)comm.ExecuteScalar(); //强制转换为int类型
if (iRet != 1)
{
return false;
}
else
{
return true;
}
}
catch (Exception)
{
return false;
}
finally
{
//关闭数据库连接
conn.Close();
}
}
static void Main(string[] args)
{
string strMsg = "";
Program p = new Program();
Console.WriteLine("请输入用户名:");
string a = Console.ReadLine();
Console.WriteLine("请输入密码:");
string b = Console.ReadLine();
bool c = p.CheckUserInfo(a, b, ref strMsg);
if (c)
{
Console.WriteLine("登陆成功!");
p.show();
}
else
{
Console.WriteLine("登陆失败!");
}
Console.ReadLine();
}
public void show()
{
do
{
Console.WriteLine("=======请选择操作键======");
Console.WriteLine("1. 统计学生人数");
Console.WriteLine("2. 查看学生名单");
Console.WriteLine("3. 按学号查询学生姓名");
Console.WriteLine("4. 按姓名查询学生信息");
Console.WriteLine("5. 修改学生出生日期");
Console.WriteLine("6. 删除学生记录");
Console.WriteLine("0. 退出");
Console.WriteLine("=========================");
Console.WriteLine("请选择:");
int num = int.Parse(Console.ReadLine());
switch (num)
{
case 1:
Console.WriteLine("在校学生人数:" + show1());
continue;
case 2:
Console.WriteLine("2. 查看学生名单");
continue;
case 3:
Console.WriteLine("3. 按学号查询学生姓名");
continue; ;
case 4:
Console.WriteLine("4. 按姓名查询学生信息");
continue;
case 5:
Console.WriteLine("5. 修改学生出生日期");
continue;
case 6:
Console.WriteLine("6. 删除学生记录");
continue;
case 0:
Console.WriteLine("感谢使用!");
break;
default:
Console.WriteLine("输入错误");
continue;
}
break;
} while (true);
}
public int show1()
{
SqlConnection conn = new SqlConnection(strcoon);
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;
}
finally
{
conn.Close();
}
}
}
}
14章 上机
最新推荐文章于 2016-11-30 12:05:06 发布