数据库技术基础

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace sqlserven
{
    class Schoolman
    {
        DBO DB = new DBO();
        public void Login() {
            Console.WriteLine("请输入用户名");
            int name =int.Parse(Console.ReadLine());
            Console.WriteLine("请输入密码");
            String pwd = Console.ReadLine();
            bool b=DB.che(name, pwd);
            if (b)
            {
                Console.WriteLine("登录成功");
                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("8.退出");
                int i = int.Parse(Console.ReadLine());
                xz(i);
            }
            else {
                Console.WriteLine("cuo");
            }
        }
        public void xz(int i) {
            switch (i) { 
                case 1:
                    Console.WriteLine("一共"+DB.yi()+"人");
                    break;
                case 2:
                    DB.er();
                    break;
                case 3:
                    DB.san();
                    break;
                case 4:
                    break;
                case 5:
                    DB.wu();
                    break;
                case 6:
                    DB.liu();
                    break;
                case 7:
                    DB.qi();
                    break;
                case 8:
                    Console.WriteLine("退出成功");
                    break;
            }
        }
       
    }
}







using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace sqlserven
{
    class DBO
    {
        string str = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
      
        public bool che(int name,String pwd)
        {
            SqlConnection conn = new SqlConnection(str);
            try
            {
              
                string sql = "select count(*) from student where StudentNo='" + name + "'and LoginPwd='" + pwd + "'";
                conn.Open();
                SqlCommand comm = new SqlCommand(sql, conn);
                int red = (int)comm.ExecuteScalar();
                
                if (red ==0 )
                {   
                    return false;
                }
                else
                {
                    return true;
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                return false;
            }
            finally {
                conn.Close();
            }            
        }
        public int yi()
        {
            SqlConnection conn = new SqlConnection(str);
            try
            {
                string s = "select count(*) from student";
                conn.Open();
                SqlCommand comm = new SqlCommand(s, conn);
                int i = (int)comm.ExecuteScalar();
               
                return i;
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw;
            }
            finally {
                conn.Close();
            }
          
        }
        public void er() {
            SqlConnection conn = new SqlConnection(str);
            String s = "select * from student student";
            conn.Open();
            SqlCommand comm = new SqlCommand(s,conn);
            SqlDataReader sql=comm.ExecuteReader();
            while(sql.Read()){
                Console.WriteLine(sql["studentname"]);
            }          
        }
        public void san() {
            Console.WriteLine("请输入学号");
            int id = int.Parse(Console.ReadLine());
            SqlConnection conn = new SqlConnection(str);
            try
            {
              
                String s = "select * from student where  studentno=' " + id + "'";
                conn.Open();
                SqlCommand comm = new SqlCommand(s, conn);
                SqlDataReader sql = comm.ExecuteReader();
                while (sql.Read())
                {
                    Console.WriteLine("学号{0},姓名{1}", sql["studentno"], sql["studentname"]);
                }

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw;
            }
            finally {
                conn.Close();
            }
        }
        public void wu() {
            Console.WriteLine("请输入学号");
            int id = int.Parse(Console.ReadLine()); 
            Console.WriteLine("请输入要修改的日期");
            String time=Console.ReadLine();
            DateTime ds = Convert.ToDateTime(time);
            SqlConnection conn = new SqlConnection(str);
            try
            {
                string s = "update student set Birthday='" + ds + "' where StudentNo='"+id+"'";
                conn.Open();
                SqlCommand comm = new SqlCommand(s,conn);
                int count=comm.ExecuteNonQuery();
                if(count>0){
                    Console.WriteLine("修改成功");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw;
            }
        }
        public void liu() {
            SqlConnection conn = new SqlConnection(str);
            try
            {
                Console.WriteLine("请输入要删除的学号");
                int i = int.Parse(Console.ReadLine());
                string s = "delete from student where studentno='" + i + "'";
                conn.Open();
                SqlCommand comm = new SqlCommand(s, conn);
                int y = comm.ExecuteNonQuery();
                if (y > 0)
                {
                    Console.WriteLine("删除成功");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw;
            }
            finally {
                conn.Close();
            }
        }
        public void qi() {
            SqlConnection conn = new SqlConnection(str);
            try
            {
                Console.WriteLine("请输入要添加的班级名");
                String name = Console.ReadLine();
                String s = "insert Grade(GradeName) values('"+name+"')";
                conn.Open();
                SqlCommand comm = new SqlCommand(s, conn);
                int i = comm.ExecuteNonQuery();
                if (i > 0)
                {
                    Console.WriteLine("添加成功");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw;
            }
            finally {
                conn.Close();
            }
        }
    }
}






using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace sqlserven
{
    class Program
    {
        static void Main(string[] args)
        {
            Schoolman s = new Schoolman();
            s.Login();
            Console.ReadLine();
        }
    }
}