using System.Data.SqlClient;

namespace adonet_接受_删除_添加
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("请输入要删除的用户名：");
            string uname = Console.ReadLine();
            //1、创建数据库链接类
            string sql = "server=.;database=data0928;user=sa;pwd=123;";
            SqlConnection conn = new SqlConnection(sql);
            //2、创建数据库操作类
            SqlCommand cmd = conn.CreateCommand();
            //3、编写操作语句
            cmd.CommandText = "delete from users where username=‘" + uname + "‘";
            //4、打开数据库连接
            conn.Open();
            //5、执行操作，返回受影响行数
            int a= cmd.ExecuteNonQuery();
            //6、关闭数据库连接
            conn.Close();
            //7、提示操作是否成功
            if (a > 0)
            { Console.WriteLine("删除成功"); }
            else
            { Console.WriteLine("删除失败"); }

            Console.ReadLine();
        }
    }
}

namespace insert
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("请输入要添加的用户名：");
            string uname = Console.ReadLine();
            Console.WriteLine("请输入要添加的密码：");
            string pwd = Console.ReadLine();
            Console.WriteLine("请输入要添加的昵称：");
            string nick = Console.ReadLine();
            Console.WriteLine("请输入要添加的性别：");
            string sex = Console.ReadLine();
            Console.WriteLine("请输入要添加的生日：");
            string bir = Console.ReadLine();
            Console.WriteLine("请输入要添加的民族：");
            string nation = Console.ReadLine();
            Console.WriteLine("请输入要添加的班级：");
            string cla = Console.ReadLine();

            //创建数据库连接类
            SqlConnection con = new SqlConnection("server=.;database=data0928;user=sa;pwd=123");
            //创建数据库操作类
            SqlCommand cm = con.CreateCommand();
            //编写操作语句
            cm.CommandText = "insert into users values(‘" + uname + "‘,‘" + pwd + "‘,‘" + nick + "‘,‘" + sex + "‘,‘" + bir + "‘,‘" + nation + "‘,‘" + cla + "‘)";
            //打开数据库连接
            con.Open();
            //执行操作
            cm.ExecuteNonQuery();
            //关闭数据库
            con.Close();

            Console.ReadLine();
        }
    }
}

namespace select
{
    class Program
    {
        static void Main(string[] args)
        {
            //创建连接
            SqlConnection conn = new SqlConnection("server=.;database=data0928;user=sa;pwd=123");
            //创建数据库操作
            SqlCommand cmd = conn.CreateCommand();
            //编写操作语句
            cmd.CommandText = "select * from users";

            conn.Open();
            SqlDataReader dr= cmd.ExecuteReader();
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    Console.WriteLine(dr["ids"] + "\t" + dr["username"] + "\t" + dr["password"] + "\t" + dr["nickname"] + "\t" + dr["sex"] + "\t" + dr["birthday"] + "\t" + dr["nation"] + "\t" + dr["class"]);
                }            
            }
            conn.Close();
            Console.ReadLine();
        }
    }
}

namespace Update
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.Write("请输入要修改的用户名：");
            string uname = Console.ReadLine();
            Console.Write("请输入密码：");
            string pwd = Console.ReadLine();
            Console.Write("请输入昵称：");
            string nick = Console.ReadLine();
            Console.Write("请输入性别：");
            string sex = Console.ReadLine();
            Console.Write("请输入生日：");
            string bir = Console.ReadLine();
            Console.Write("请输入民族：");
            string nation = Console.ReadLine();
            Console.Write("请输入班级：");
            string cla = Console.ReadLine();

            SqlConnection conn = new SqlConnection("server=.;database=Data0928;user=sa;pwd=123");

            SqlCommand cmd = conn.CreateCommand();

            cmd.CommandText = "update Users set PassWord = ‘" + pwd + "‘,NickName = ‘" + nick + "‘,Sex=‘" + sex + "‘,Birthday=‘" + bir + "‘,Nation=‘" + nation + "‘,Class=‘" + cla + "‘ where UserName = ‘" + uname + "‘";

            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();

        }
    }
}